|
|
|
Intermediate Oracle
|
| Price: |
$99.00 |
| Business Focus: |
Database Management & Programming |
| Instructor: |
Cindy Delia |
| Course Code: |
noc |
| Delivery Method: |
Instructor-led Online Course |
| Frequently Asked Questions |
|
|
| Course Overview: |
| 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. |
| Instructor Biography: |
| 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 specializes in database management systems and develops PC applications. She has taught computer courses at the community college level and also performs corporate training. Cindy has also written technical manuals for WordPerfect. |
| Course Syllabus: |
| Lesson 1 Syllabus |
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. |
| Lesson 2 Syllabus |
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. |
| Lesson 2 Objective |
Learn what is PL/SQL and how to get started with PL/SQL. |
| Lesson 3 Syllabus |
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. |
| Lesson 3 Objective |
Understand the available datatypes and block structure. |
| Lesson 4 Syllabus |
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. |
| Lesson 4 Objective |
Learn about operators, expressions, and datatype conversions and how they work. |
| Lesson 5 Syllabus |
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. |
| Lesson 5 Objective |
Learn PL/SQL Functions, IF Statements, and Looping Statements. |
| Lesson 6 Syllabus |
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. |
| Lesson 6 Objective |
Learn about the GOTO Statement, Statement Labels, and Loop Constructs. |
| Lesson 7 Syllabus |
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. |
| Lesson 7 Objective |
Make use of Oracle's Built-in Functions. |
| Lesson 8 Syllabus |
Errors that occur from hardware or network failures, application logic errors, data integrity errors, and other sources are called exceptions. 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. |
| Lesson 8 Objective |
Learn about Procedures and Packages. |
| Lesson 9 Syllabus |
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. |
| Lesson 9 Objective |
Learn how to use error handlers. |
| Lesson 10 Syllabus |
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. |
| Lesson 10 Objective |
Learn how to use SQL Statements in PL/SQL. |
| Lesson 11 Syllabus |
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. |
| Lesson 11 Objective |
Learn how to create Cursors. |
| Lesson 12 Syllabus |
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. |
| Lesson 12 Objective |
Create Database Triggers, Apply Advanced Cursor concepts, and Learn How to Manage PL/SQL Code. |
