Oracle Intermediate

Picture of 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

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.

Oracle Fundamentals Online Course | Vibe Learning
 

Oracle Fundamentals

Picture of Oracle Fundamentals
Quick Facts
  • Delivery Method Online
  • Professional Certificate
  • 24hrs Suggested Study Time
  • 3 Months Access
  • Tutor Support
  • Study On Any Device
  • 5785 Students

Learn how to use the Oracle database management system to plan, organise, and manage your data.

Learn how to use the Oracle database management system to plan, organise, and manage your data. Introduction to Oracle will provide you with a practical hands-on approach to relational databases concepts and Oracle's database management system. This course will introduce you to the Structured Query Language (SQL), Oracle's SQL*Plus, and other valuable tools used to develop, manage, and reference an Oracle database.

In this self-paced online course, you will learn how to create an Oracle database, build various database objects for the database, and write simple SQL statements that access the data from the database. This course will teach you how to write Data Definition Language statements to create, update, and delete database objects. You will learn how to execute Data Control Language statements to give or delete access rights to database objects. You will write Data Manipulation Language statements to insert, update, and delete records from a database. Finally, you will learn how to query the data and create finished reports.

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 this lesson, you'll gain a solid understanding of terms and concepts surrounding a relational database. You'll learn what's involved in the planning of a database and the steps involved in designing a database. Then we'll talk specifically about the Structured Query Language (SQL) and the database tools you'll use throughout the course.

Today you'll jump right into the course by creating the actual database you'll use in all the lessons that follow. You'll learn about the most common object in Oracle: the table. Then, I'll explain addresses the common datatypes that describe the kind of information a column in a table will store.

Creating Websites in Wordpress II Online Course | Vibe Learning
 

Creating Websites in Wordpress II

Picture of Creating Websites in Wordpress II
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
  • 2909 Students

Discover how to create and maintain dynamic websites and blogs without technical coding using the self-hosted WordPress.org publishing platform.

Create a website that can do just about anything, without any technical coding! In this course, you'll learn how to build content management websites and blogs with WordPress.org, the world's most popular Web page publisher.

Content management lets you control your own site by providing an easy-to-use online administrative area that makes creating and updating content as simple as sending an email. Your online visitors will be able to comment on your articles, fill out forms and applications, buy your products, and even make appointments.

You'll master each step, from selecting a domain name and a hosting company to installing WordPress and creating pages. You'll discover how to insert images and multimedia, create a user-friendly navigation system, and take advantage of the dynamic add-on features known as plug-ins. You'll explore how to turn your website into an ecommerce powerhouse and improve search engine page results. And you'll also learn some HTML and CSS coding to customise your site's look and feel.

If you want to build or maintain a professional WordPress website with all the bells and whistles, this course is for you.

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.

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.

Course Modules

In this first lesson, you'll find out why WordPress is among the world's most popular Web publishing platforms and how it's designed to help nontechnical people create good-looking, dynamic websites. I'll discuss what it takes to set up a self-hosted WordPress site, and you'll learn how to choose a domain name, find a hosting company, and access your piece of the World Wide Web!

Today, you'll learn how to upload files to your website, and we'll tour the WordPress administrative area and configure some basic settings. I'll also show you how to organize your site so your visitors will get the most out of it.

A WordPress theme gives your website a professionally designed look with a single mouse click. In this lesson, we'll discuss how themes work, where to find them, and how to install them. We'll compare free themes with those you have to pay for, and we'll also talk about the theme we're using for our class website project.

Today's lesson is all about organizing written content! We'll discuss how to enter and organize the information your visitors are looking for, and how to create pages and posts. You'll also find out how to put together a custom menu to guide your guests around the site. You want to arrange your articles so they're easy to find, and that's just what we're going to discuss today.

Now you're ready to start <i>adding </i>to your website&mdash;the details that will give it that extra-special touch! In today's lesson, you'll learn how to add photos, videos, maps, and documents to your Web pages without leaving the WordPress application. And we'll also discuss how to manage these files and create an image gallery to display your photographs.

In this lesson, you'll learn how to use plugins, the features that you can add to WordPress with a single mouse click. I'll show you where to find thousands of these free mini-programs and how to use them.

You likely know a bit about HTML and CSS, but today we'll cover HTML and CSS coding in more detail. Don't worry if this is foreign to you. I'll introduce you to the basics of each language, and you'll quickly discover how to change font styles, sizes, and colors; create lists; and work with margins. With this knowledge, you can customize your website so it'll look just how you want it to look!

As we continue exploring how to customize WordPress websites in this lesson, you'll discover an application that will spare you countless hours of drudgery. You'll also find out more ways to change the way your site looks, and you'll learn how to create a custom WordPress theme without learning the basic scripting language. Then you'll learn how to set up widgets, which fill your sidebars with information and features.

So how can you use your WordPress website to make money? That's what this lesson is all about. You'll learn ways to create pay-per-click, advertising, and affiliate marketing programs. And we'll also discuss PayPal and credit card processing and set up a shopping cart.

Today, we'll focus on the details that'll make your website stand out. You'll find out how to create a consistent style and set up an eye-catching slide show on your home page. We'll also discuss how to market your site using social networking plugins designed for WordPress.

Search engines love WordPress websites! In this lesson, we'll talk about how to get higher search page results, and we'll explore ways to collect and analyze data to ensure we're attracting and informing our target audience.

In our final lesson, you'll learn to use the WordPress Loop to customize your website. We'll also discuss some time-saving tips and tricks about handling contributors, bolstering security, and making your pages look great in mobile browsers!

John Agress

John Agress

John Agress has been active in the computer world since the 1980s and has been developing and designing websites for more than a decade. He was among the first designers to recognise that WordPress, which was originally created as blogging softwar... Read more Read John Agress'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.

What people are saying about our courses

Vibe Learning Logo
Online course created by industry leaders
ABN: 67 168 715 857
Facebook Instagram
checkout payment

Copyright © 2025 Vibe Learning. All rights reserved.