Oracle Intermediate

Quick Facts

Delivery Method Online
Professional Certificate
24hrs Suggested Study Time
3 Months Access
Tutor Support
Study On Any Device
2182 Students

Learn how to write powerful and flexible PL/SQL programs.

Gain hands-on experience with Oracle's PL/SQL programming language, with expert assistance from an IT veteran. PL/SQL is Oracle's procedural language extension to Structured Query Language (SQL). This course will give you the skills you need to write powerful and flexible programs using that language. You'll learn the building blocks and core features of PL/SQL, including expressions, various iterations, and built-in functions. Then, you'll begin building fully functional PL/SQL programs with procedures, packages, debugging routines, database structures, triggers, and cursor processing. By the time you finish this course, you will be able to store PL/SQL programs in a database and execute them.

Courses are delivered to you through expertly executed lessons, online instruction and interaction with like-minded students. Our courses are designed to deliver all of the benefits of studying in a classroom whilst giving you the flexibility to study at a time and place to suit your needs. You can access your classroom 24/7 from any device with an internet connection.

This course has a 3 month duration. You'll complete comprehensive lessons, quizzes and assignments before submitting your final exam at the end of the course to achieve your certificate. Courses must be completed within the 3 month access period.

In our first lesson, you'll master the basics of PL/SQL and discover how you can best get started using this powerful language.You'll also learn the differences between SQL, SQL*Plus, and PL/SQL today.

The block is the basic unit of PL/SQL programming. In this lesson, you'll learn and understand the various datatypes available to you when declaring variables. You'll also explore the PL/SQL's block structure, its use, and its impact on the scope of variable declarations.

Today, you're going to learn how to use operators to manipulate variables. You'll build simple expressions that compute two values, as well as complex expressions that consist of function calls, operations using variables, and relational comparisons. You'll also learn about datatype conversions for expressions that contain operands of multiple datatypes.

In this lesson, you'll take a closer look at how to create your own functions. The two main reasons for writing functions are the reduction of code and their ease of use. You'll learn how to code PL/SQL functions, how to define parameters in the functions, and how to store them. I'll also show you how to control the execution of PL/SQL blocks using the IF and looping statements. Then, we'll explore the various IF statements and how they operate, and you'll gain experience working with a simple loop.

In today’s lesson, you'll begin to master more methods for changing the order of execution of PL/SQL blocks. We'll cover statement labels, the GOTO statement, and the different kinds of loops. You'll learn how to branch by using the GOTO statement followed by a statement label. Then, we'll discuss why the statement label must appear in the same block and within the same scope as the GOTO statement. Next, we'll look at control structures. You'll learn about the different kinds of loops and how they operate. Finally, you'll discover techniques for exiting loops and how to simulate a REPEAT...UNTIL loop.

We'll look at a number of Oracle’s built-in functions in this lesson, including string functions, number functions, date functions, and conversion functions.

In this lesson, we'll focus on procedures and packages and how they allow you to organize your PL/SQL code into logical groups for uncomplicated maintenance and implementation.

Errors that occur from hardware or network failures, application logic errors, data integrity errors, and other sources are called <em>exceptions</em>. In this lesson, I'll introduce you to the concepts behind PL/SQL exception handling. I'll explain the different types of exceptions and show you how to identify and handle errors in your code.

The Structured Query Language (SQL) is the industry standard for accessing data from relational databases. In this lesson, we'll address the connection to the underlying Oracle database through SQL (Structured Query Language). We'll cover the usage of SQL's Data Manipulation Language (DML) commands within a PL/SQL block. Then you'll learn how to define DML transactions that insert, update, delete, and query the information.

PL/SQL cursors provide a method for selecting multiple rows of data from the database and processing each row individually. You can use cursors for simple procedures and complex processing. In this lesson, I'll introduce you to cursors and how they may be used.

In this lesson, you'll learn about triggers and experiment with implementing a few different types of functionality. We'll discuss advanced cursor concepts, which include the SELECT...FOR UPDATE statement, the WHERE CURRENT OF clause, and subqueries in cursors. Finally, you'll learn techniques to managing PL/SQL code.

Although some may never admit to it, everyone makes mistakes, so you will inevitably make some coding errors. These errors are usually comprised of syntax and logic errors. In our final lesson, I'll demonstrate how to find these bugs and then how to reduce the number of coding mistakes you may encounter.

Cindy Delia

Cindy Delia is a Systems Analyst and a certified instructor. She has been working in information technology for more than 18 years and has been a technical trainer for over 6 years. As a Systems Analyst, she specialises in database management syst... Read more

Read Cindy Delia's Profile

Frequently Asked Questions

Once you've made the payment, we'll send you a confirmation email with a link to start your course. Feel free to get started whenever you're ready!

You'll have 3 months access to your course. In that time you are free to study at your own pace. The course duration is 24 hours.

Online learning is a flexible way to study that fits around your schedule, giving you the freedom to learn at your own pace from anywhere in the world. You'll have 3 months to complete the course and can take the multiple-choice questions and final exam whenever it suits you.

If you need help, you can contact us anytime. You can also join the discussion area where you can interact with other students. The discussion area for each lesson is open for the entire duration of the course.

Of course! We offer a 7-day money back guarantee. As long as you haven't completed the course, you can get a full refund within 7 days of enrolling.

We do not offer extensions or transfers for this self-paced course. However, you will have 3 months to complete the course, and if you need to cancel within the first 10 days of enrolment, we offer a money back guarantee.

The Learning Environment

From the moment that you enrol in the Oracle Intermediate you will become an integral part of our learning community. You'll find yourself with the freedom to learn at a speed that suits you, on any device, from anywhere in the world. Achieving your career goals no longer has to mean compromising family and work commitments.

Our Values

Learn At Your Own Pace

We believe in personalised learning. That's why we provide all the tools and support you need to succeed at your own pace. With flexible learning, you'll stay motivated and retain more information. Plus, you can balance your studies with work and family commitments to make your dreams a reality.

We Won't Break The Bank

Education should be accessible to anyone who wants to learn. That's why we offer some of the most competitive prices in the industry with payments plans for just $25 per week. Investing in your future is a smart choice and doesn’t have to break the bank.

Industry-Led Courses

There's no better way to learn than from experts with years of experience in your field. That's why each of our 200+ industry-led courses are designed to give you a real-life perspective on your industry. With our expert mentors, you'll learn from people who have a wealth of knowledge and experience, and who are passionate about sharing it with you.

Get The Personal Support You Deserve

At Vibe Learning, we're real people who are dedicated to providing you with personal support every step of the way. Our industry experts are not only professional and knowledgeable but also incredibly passionate about sharing their expertise with you. With their guidance, you'll gain invaluable insights and practical knowledge to help you succeed.

Still looking?

Check out the following courses related to Oracle Intermediate:

Crystal Reports Fundamentals

Database Development Fundamentals

Oracle Fundamentals

SQL Fundamentals

SQL Intermediate

Discover more online courses

Oracle Intermediate

$599

$389AUD

Save 35%

Wireless Networking

Now Only

$389

AUD

35% off

$599 AUD

Quick Facts

Delivery Method Online
Professional Certificate
24hrs Suggested Study Time
3 Months Access
Tutor Support
Study On Any Device
3650 Students

An industry expert shows you how wireless networking works, as well as how to plan, deploy, and connect to wireless networks.

Wireless networking is one of the fastest growing segments of the computer industry. Every electronic device seems capable of wireless connections these days: computers, handhelds, cell phones , and even digital cameras are all capable of transmitting without a tether. To many people, those wireless connections are nothing short of technical wizardry. This course will remove the mystery and give you a thorough understanding of this fascinating and lucrative technology.

You'll learn how wireless works, how wireless devices connect to networks, and how to build and connect to your own wireless network. We'll also explore wireless standards, wireless security, satellite Internet and cellular phone technology, as well as the future of wireless.

Becoming knowledgeable about wireless networking is easier than ever. With a helpful instructor who is also a working industry expert, a practical and thoughtful approach to teaching, and an emphasis on giving you a practical, hands-on understanding how wireless works, this course will teach you everything you want to know about the world of wireless connectivity.

Course Revised January 2013

The first Internet connection was made at UCLA in September 1969 with a thick gray cable between two computers. Times sure have changed! Today the Internet serves millions of e-mails and Web pages every few minutes, connecting millions of users from all over the world. And today, wireless networking is the hottest networking technology around. People who use wireless networks can check e-mail from their favorite coffee shop, surf the Internet from their couch, and even get instant messages on their Internet-connected cellular phone. Learning how all those wireless networks operate is as interesting as the Internet itself. In this first lesson, you'll learn about basic network facts and operation, preparing you to expand your knowledge in subsequent lessons.

Did you ever wonder how your radio turns invisible waves into music? Or have you wondered why you can hear bass sounds from farther away than cymbals? Why does a radio station cut out when you go through a mountain tunnel or around a bend? Wireless networks have similar characteristics to radio music transmissions, but there are important differences. In this lesson, I'll explain how wireless networking actually works in simple everyday terms that make it easy to understand. You'll also learn about different methods used to pull computer data out of thin air.

Why do some electronic devices gain widespread popularity while others sit on the shelf? In this lesson, you'll learn how standards in the networking world help drive the adoption of technology. You'll also get a firsthand look at how standards operate in every real-world business, like clothes and batteries and shampoo. In doing so, you'll learn why some wireless networking technologies have flourished while others have failed miserably (early wireless technologies were a flop!). By the end of this lesson, you'll know who makes the standards, how something becomes standardized, and why it's so important. And yes, you'll also see how all this applies to wireless networking standards and gain insight on why wireless networking is so popular today.

If you've considered buying wireless networking equipment, you know that there are lots of choices out there. How do you make sense of it all? Which technology is better? What do all of those extra features mean to you? In this lesson, you'll learn all about wireless network devices, what role each device plays, and how to make sense of it all! By the end of this chapter, you'll know exactly what each wireless networking device is capable of doing and which one is right for you.

In this lesson, we'll investigate short-range wireless network technologies. You'll learn all about Bluetooth (it has nothing to do with dentistry!), Wi-Fi, and the details that make each technology unique. We'll also take a firsthand look at why one is better than the other and where each technology fits into the larger wireless networking picture.

Would you consider a wireless networking technology capable of traveling 90,000 miles a long-range wireless technology? I certainly would! In this lesson, you'll learn which wireless technology can go beyond your house, beyond your neighborhood, and even beyond the atmosphere. You'll also learn the drawbacks of having your data travel into space and back, and about some long-range wireless technologies that might give DSL or cable Internet access a run for their long-range money.

Now that you've learned all about wireless technologies, it's time to put your knowledge to work. In this lesson, you'll learn how to plan a wireless network. After all, once you learn about wireless networking, you'll want to get wireless working in your house or office! In this lesson, I'll walk you through each planning phase, complete with network drawings that depict how a real-life wireless network should be prepared.

In the previous lesson, you planned a network. In this lesson, you'll install a wireless access point (WAP) to get the wireless network up and running. You'll also learn about issues you should address when configuring a wireless network, including interference with neighboring networks and how to extend your network to reach far-off corners of your home or office.

Once you have a wireless network ready for computers to access, you're ready for the next step: connecting wireless devices. In this lesson, you'll learn how to outfit a computer with a wireless network card, how to connect that computer to your wireless network, and how to make sure that wireless network connection is properly configured. By the end of this lesson, you'll be ready to surf the Internet from your couch! Then we'll look at the similarities and differences between Windows and Apple software.

Computers aren't the only devices capable of connecting to wireless networks these days. There are all sorts of wireless devices, like Personal Data Assistants (PDAs), that you can connect. In this lesson, you'll learn how to hook those other devices into the wireless network you created in previous lessons. Then you'll get a chance to explore how Bluetooth networks operate, how they differ from Wi-Fi, and how to go about connecting one Bluetooth device to another.

You can't take the security of your computer (or network) for granted these days. In this lesson, you'll discover how wireless networks provide security for wireless devices that connect to them. You'll also learn how to make your own wireless network secure, ensuring that only the people you want to connect to your wireless network are capable of doing so. You'll also learn how to secure your wireless device, such as a computer or PDA, when you're roaming all those cool (but potentially unsafe) public access areas like coffee shops or downtown wireless districts.

What is the future of wireless networking? Are we there? Is this as cool as it's going to get or are we going to see all sorts of new wireless technologies in the future? In this lesson, I'll give you my thoughts on where the future of wireless networking is headed and what that future might have in store. We'll discuss the future of cellular networks, the future of answering the telephone on the Internet, and how power lines and broadband might be a match made in heaven! Of course, the future is open, but it's fun to make some educated guesses based on history and how networking technology has moved in the past. Be prepared to add you own thoughts to our discussion on the future of networking—this will be an especially interesting and exciting lesson!

David Iseminger

David Iseminger is a computer and networking expert and an experienced teacher of networking topics. As a student first and expert second, Iseminger knows which teaching approaches are most effective. Iseminger has worked at Microsoft Corporation ... Read more

Read David Iseminger's Profile

Frequently Asked Questions

Once you've made the payment, we'll send you a confirmation email with a link to start your course. Feel free to get started whenever you're ready!

You'll have 3 months access to your course. In that time you are free to study at your own pace. The course duration is 24 hours.

Of course! We offer a 7-day money back guarantee. As long as you haven't completed the course, you can get a full refund within 7 days of enrolling.

What people are saying about our courses

Enjoyed the course very much. I believe this will help me greatly when I set up my own home wireless network.

Verified Student

Great class! Although I have worked with wireless equipment, it was nice to have some of the "background" information to go along with what I've taught myself. I would definitely recommend this class and the instructor to others.

Verified Student

I enjoyed the class very much. It was very informative and will help me in my job. The lessons were well written and easy to understand. Thank you!!

Verified Student

See More Reviews

The Learning Environment

From the moment that you enrol in the Wireless Networking you will become an integral part of our learning community. You'll find yourself with the freedom to learn at a speed that suits you, on any device, from anywhere in the world. Achieving your career goals no longer has to mean compromising family and work commitments.

Ready to get started?

Enrol Now