The was exceptional in the way it was administered and written. I got more that I expected. Excellent course."
What a fantastic course, especially for the cost. You can get out of it whatever you are willing to put into it. I would recommend this course to others."
Course Code: noc
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. Then, 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.
Learn how to use operators to manipulate variables, and learn about datatype conversions for expressions that contain operands of multiple datatypes. Then, you'll take a closer look at how to create your own functions. You’ll also explore the various IF statements and how they operate, and you'll gain experience working with a simple loop.
In this 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. Then, we’ll look at a number of Oracle’s built-in functions 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. Then, learn the concepts behind PL/SQL exception handling including different types of exceptions and how to identify and handle errors in your code.
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. You’ll also get an introduction to cursors which provide a method for selecting multiple rows of data from a database and processing each row individually.
In this lesson, you'll learn about triggers and experiment with implementing a few different types of functionality. You’ll also learn techniques to managing PL/SQL code. And finally, we’ll demonstrate how to find bugs and then how to reduce the number of coding mistakes you may encounter.
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.
Completion of Cindy Delia's Introduction to Oracle course (or equivalent experience).
The instructional materials required for this course are included in enrollment and will be available online.
A new session of each course opens each month, allowing you to enroll whenever your busy schedule permits.
Once a course session starts, two lessons will be released each week for the six-week duration of your course. You will have access to all previously released lessons until the course ends.
The interactive discussion area for each lesson automatically closes two weeks after each lesson is released, so you’re encouraged to complete each lesson within two weeks of its release.
The final exam will be released on the same day as the last lesson. Once the final exam has been released, you will have two weeks plus 10 days (24 days total) to complete the final and finish any remaining lessons in your course. No further extensions can be provided beyond these 10 days.