Intermediate Oracle

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. This course will give you the skills you need to write, build, debug, and execute fully functional PL/SQL programs in a database.

for just $129.99.



Multiple Start Dates -

Certification

About Intermediate Oracle

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.

Prerequisites & Requirements

Intermediate Oracle

Requirements:

Hardware Requirements:

  • This course can be taken on either a PC or Mac.

Software Requirements:

  • PC: Windows 8 or later.
  • Mac: macOS 10.6 or later.
  • Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge and Safari are also compatible.
  • Oracle's Database Software. The Database Software is available for downloading from Oracle's website (www.oracle.com). Download the Oracle Database that supports your operating system. This course provides post-installation instruction on Oracle. Installation support will not be provided in the course. Installation support is provided from Oracle's website.
  • Adobe Acrobat Reader.
  • Software must be installed and fully operational before the course begins.

Other:

  • Email capabilities and access to a personal email account.

Prerequisites:

Completion of Cindy Delia's Introduction to Oracle course (or equivalent experience).

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment and will be available online.

Syllabus

Introduction to PL/SQL

In the 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.

Datatypes and Block Structure

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.

Operators, Expressions, and Datatype Conversions

In this lesson, 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.

PL/SQL Functions, IF Statements, and Looping Statements

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. The lesson will also show you how to control the execution of PL/SQL blocks using the IF and looping statements. Then, you'll explore the various IF statements and how they operate, and you'll gain experience working with a simple loop.

GOTO Statement, Statement Labels, and Loop Constructs

In this lesson, you'll begin to master more methods for changing the order of execution of PL/SQL blocks. You'll explore 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. After that, the lesson will discuss why the statement label must appear in the same block and within the same scope as the GOTO statement. Next, you'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.

Oracle's Built-In Functions

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

Procedures and Packages

In this lesson, you'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 and Exceptions

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

Types of SQL Statements, Declaring Variables in PL/SQL, and Transaction Management

Structured Query Language (SQL) is the industry standard for accessing data from relational databases. This lesson will address the connection to the underlying Oracle database through SQL (Structured Query Language). It will 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.

Using Cursors

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. This lesson will introduce you to cursors and how they may be used.

Database Triggers, Advanced Cursor Concepts, and Managing PL/SQL Code

In this lesson, you'll learn about triggers and experiment with implementing a few different types of functionality. The lesson will 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.

Debugging Your 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. The final lesson will demonstrate how to find these bugs and then how to reduce the number of coding mistakes you may encounter.

AUTHOR

Intermediate Oracle Instructor

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 six years. As a Systems Analyst, Delia specializes in database management systems and develops PC applications. She has taught computer courses at the community college level and also performs corporate training.

Keep Learning

The ExpertRating Intermediate Oracle is designed keeping in mind your comfort and convenience. You can access the course from anywhere, anytime. Whether you are a stay-at-home mom or an always-on-the-go working professional, you can keep learning. Access it from your home computer, your tablet or your mobile phone – whatever or whenever is convenient for you.

When you choose the ExpertRating Intermediate Oracle, you can be sure that you are choosing a respected certification that is recognized by hundreds of private employers in the US and other countries.

ExpertRating offers its training and testing services to some of the biggest and best companies in the world, such as Convergys Corp, UPS, GAP, Federal Bureau of Prisons, Coke, Citrix, IKEA Systems, Google and Ericsson, to name a few.

Certificate

Life Coach Certificate

When you purchase the Intermediate Oracle, you also receive the highly recognizable hard copy certificate at your physical address within 12-15 days of taking the exam.

  • The certificate can be used to prove your certified status and does not mention the word "online".
  • You will receive an online transcript that mentions your score and you can use it to prove your certified credentials on the internet or to employers and customers.
The Intermediate Oracle is by far the "best value-for-money"
Intermediate Oracle -- FOR JUST $129.99
Certification

Intermediate Oracle - ExpertRating Advantages

paypal

At just $129.99, the ExpertRating Intermediate Oracle is your 'best value-for-money' option for enrolling in a Life Coach Program. Payments can be made using all major credit cards or PayPal. All payments are through secure online transactions. ExpertRating is a PayPal verified seller with 200,000+ sales through PayPal.

Privacy

ExpertRating upholds the highest privacy standards and complies with strict program requirements, ensuring that your information is always safe.

tuv

ExpertRating is an ISO 9001:2015 certified company, which reflects that our courses and tests conform to the highest international quality standards. Our training material is prepared by thorough professionals with years of experience, and goes through several rounds of analysis by expert teams to help develop well balanced, comprehensive and meaningful content.




Our website is certified by TrustedSite, formerly McAfee SECURE™ as safe from potential hacking threats. The TrustedSite trustmark indicates that our website has passed daily intensive security scans.

Testimonials

Our customers love us!

Related Courses

SQL Course

ExpertRating Online SQL Course and SQL Training leading to SQL Programming Skills Certification helps you in gaining a solid working knowledge of the most powerful and widely used database programming language.
Know more about SQL Course

PHP Course (Introductory)

Learn how to create dynamic, interactive Web sites using PHP and a MySQL database server.Learn how to create an interactive Web site, allowing visitors to post and retrieve information provided by you or your sites visitors. In this six-week online course, you will see how to create dynamic Web pages using the PHP programming language and the MySQL database server.
Know more about PHP Course (Introductory)

C++ Programming Course

Learn to program in C++, even if you have no prior programming experience! In the course, you will see how the world around us is built up by objects--things that have qualities and capabilities, and you will explore how you can take that information and write a computer program that models the world around us.
Know more about C++ Programming Course

C# Programming Course (Introduction)

Learn the fundamentals of computer programming with the new C# programming language.This course will show you how to write professional looking applications with many of the common GUI controls, such as buttons, labels, text boxes, check boxes, and radio buttons.
Know more about C# Programming Course (Introduction)

C# Programming Course (Intermediate)

Learn to write Graphical User Interface programs in the C# Programming Language.This course will show you how to write professional looking applications with many of the common GUI controls, such as buttons, labels, text boxes, check boxes, and radio buttons.
Know more about C# Programming Course (Intermediate)

About us

ExpertRating

Over 6500 companies rely on ExpertRating for their training and testing needs

ExpertRating is an ISO 9001:2015 certified company offering online certification and training services to individuals and companies globally. Over 25 million people have benefited from ExpertRating Online Certifications and assessments. ExpertRating is the winner of the Google SME Hero's award for showing outstanding use of technology in delivering trusted services to thousands of people on a daily basis. Our affordable certifications are an excellent way of demonstrating your knowledge and skills to prospective employers as well as vastly boosting your chances of moving ahead in your business or career.
company logos
We deliver over 3 million online certifications and tests annually.
Visit us on YouTube. Expertrating Facebook Channel

Since 2001

Decades of excellence

1100+ Skill Tests

World's largest test inventory

6500+ Companies

Thousands depend on us

25 Million People Tested

10 tests every minute

160 Countries Serviced

Globally Accepted

86% Reorder Rate

Satisfied clients