To receive updates and new releases subscribe today.
Oracle 10g PL/SQL Training
 Instructor
Course Outline
|
  Online Delivery
$795
$495
DVD-ROM Delivery
$795
$495
 DVD Lending License
$1988
$1238
|
COURSE OVERVIEW
This video-centered training program teaches students how to develop PL/SQL applications and resolve common business problems. Students will be introduced to stored procedures and functions and learn how to utilize basic Oracle supplied packages and PL/SQL exception handling procedures. Additionally, students will learn about the Oracle PL/SQL language.
Oracle's Procedural Language addition to SQL is known as PL/SQL. Its language structure, data types, and syntax share similarities with ADA. The PL/SQL language features object oriented programming strategies, including information hiding (excluding inheritance), function overloading, and encapsulation. PL/SQL is often utilized to write data-based programs to alter data within Oracle databases.
PACKAGE INCLUDES
- 3 DVD-ROMS with video lectures, live demonstrations, full audio, and more than 13 hours of expert-led training from Jerry Richard
- Printable course materials
- Exclusive LearningZone Live Mentor Click for Details ($695 Value). Obtain answers to your questions now! Don't wait for an email response. Chat online with our Instructors 24/7
- Interactive Labs
- We teach practical solutions to common development problems
- 1 year upgrade for free
YOUR INSTRUCTOR
Jerry Richard - has utilized Oracle products since the early 80's. In 1984, he worked as a analyst and programmer for Oracle Version 6. Jerry has worked with every version of Oracle, ranging from Oracle 6 to 10g. Additionally, he specializes in SQL reports, SQL Writer, and SQL.
Jerry is certified as a Database Administrator (DBA) and an Oracle Certified Administrator (OCA). When Jerry was employed at Texas Instruments, he utilized various databases, such as Sybase, SQL Server, and DB2. In fact, he participated in the converting process for many current databases. Jerry also has experience working with operating systems. He has worked as a Sun and UNIX administrator, and he specializes in Microsoft Windows and IBM Mainframe.
FEATURES
-
Main Menu
The organized and effective structure enables users to browse through hours of comprehensive content rapidly and with ease. -
PowerPoint
PowerPoint presentations improve instruction by displaying all types of information for users. They can better comprehend material by viewing graphs, definitions, charts, etc. -
Exclusive Learning Zone
Train anywhere in the world at any time. Certified online instructors are situated at international support centers in the United States, United Kingdom, Australia, and Singapore to offer support and answer technology-related questions 24 hours a day. In other words, no matter where you live, you can communicate with specialists at any time. This level of interaction between instructors and students makes it possible for students to get answers to specific questions at their convenience. -
Controls
Move ahead, review, or repeat previous topics and sections. A progress bar monitors progress as you complete exercises. -
Full Motion Video
Every course offers full-motion videos of classroom instruction. It's as if you're sitting in a classroom. Our one of a kind delivery mimics a one-on-one classroom setting for more personalized educational experiences. -
Study Guides
Users can print entire course study guides, permitting them to view and review course material at their convenience. -
Review Exercises
Every section contains a review quiz to assist and enhance learning by testing whether students comprehend course concepts before moving forward. -
Resume
Every course resumes where you finished during the previous session in case you forget where you stopped. -
Live Demonstrations
Instructors provide live and "hands on" demonstrations to explain and show users how to complete tasks. This enables users to witness professionals perform everyday tasks in real world settings as often as they like. -
Labs
This course offers interactive labs, making it possible for students to obtain hands-on learning. This setting enables you to use the software without buying it or installing it on a computer. -
Certificate of Completion
We are internationally recognized for our technology-centered IT training programs. Once you finish a program, you'll receive a Certificate of Completion.
COURSE OUTLINE
Course Introduction
Course Introduction
Introduction to Oracle & SQL*PLUS
Introduction to Oracle & SQL*PLUS
Section Objectives
Basic Components of the SGA
Logging Into SQL*PLUS
A Simple Select
Demo - Correcting an Incorrect SQL
Oracle File Extensions
Saving A SQL Statement To A File
Demo - Running Scripts
CRT Files and Spool Files
Oracle SQL*PLUS Editing Commands
Demo - Using the Oracle Editor
SQL Scripts
Dictionary Tables For Users
Demo - Oracle Data Dictionary Views
Future Directions
Programmer Responsibilities
Benefits of Database Development
Introduction to Lab 1
Lab - Running Oracle & Building Tables
SQL*PLUS Commands
Programming Commands
Demo - Creating Variables in SQL*PLUS
Programming Commands Cont.
Reporting Commands
Demo - Report Commands in SQL*PLUS
More Programming Commands
Demo - Compute Statements with Break
Other Commands
SQL*Plus Enhancements in Oracle 10g
Append, Create and Replace Extensions
Show Recyclebin
Introduction to Lab 2
Lab - Commands Using SQL*Plus
SQL*Plus Commands
Chapter 1 Review
Section Objectives
Basic Components of the SGA
Logging Into SQL*PLUS
A Simple Select
Demo - Correcting an Incorrect SQL
Oracle File Extensions
Saving A SQL Statement To A File
Demo - Running Scripts
CRT Files and Spool Files
Oracle SQL*PLUS Editing Commands
Demo - Using the Oracle Editor
SQL Scripts
Dictionary Tables For Users
Demo - Oracle Data Dictionary Views
Future Directions
Programmer Responsibilities
Benefits of Database Development
Introduction to Lab 1
Lab - Running Oracle & Building Tables
SQL*PLUS Commands
Programming Commands
Demo - Creating Variables in SQL*PLUS
Programming Commands Cont.
Reporting Commands
Demo - Report Commands in SQL*PLUS
More Programming Commands
Demo - Compute Statements with Break
Other Commands
SQL*Plus Enhancements in Oracle 10g
Append, Create and Replace Extensions
Show Recyclebin
Introduction to Lab 2
Lab - Commands Using SQL*Plus
SQL*Plus Commands
Chapter 1 Review
Structured Query Language
Structured Query Language
SQL Components
SQL Data Manipulation Language (DML)
SQL Basic Retrieval
Demo - Basic SQL Commands
Retrieval of Computed Values
Demo - SQL Retrieval
Order By Clause
Ordering By Descending
The Distinct Operand
Selecting On Conditions
Multiple Conditions
The Between Clause
The Like Clause
Demo - Showing Like Clause
Negative Conditions
Built In Functions
Group By Clause
The Having Clause
Demo - Review of Having Clause
The Analytical Commands
Cube
Retrieval Involving Null
Treatment of Nulls
Null Values Are Considered In:
Case Expression
Introduction to Lab 3
Lab - More About Selects
Demo - Review of Exercises
Chapter 2 Review
SQL Components
SQL Data Manipulation Language (DML)
SQL Basic Retrieval
Demo - Basic SQL Commands
Retrieval of Computed Values
Demo - SQL Retrieval
Order By Clause
Ordering By Descending
The Distinct Operand
Selecting On Conditions
Multiple Conditions
The Between Clause
The Like Clause
Demo - Showing Like Clause
Negative Conditions
Built In Functions
Group By Clause
The Having Clause
Demo - Review of Having Clause
The Analytical Commands
Cube
Retrieval Involving Null
Treatment of Nulls
Null Values Are Considered In:
Case Expression
Introduction to Lab 3
Lab - More About Selects
Demo - Review of Exercises
Chapter 2 Review
Advanced Structured Query Language
Advanced Structured Query Language
Advanced DML Functions
Qualified Names
Correlation Variables
Advanced DML Functions Cont.
Demo - Oracle's Natural and Outer Joins
ANSI/ISO Join Statements
Oracle Join Statements
Multiple Table Join
More about Aliases
Demo - Joins
Subqueries
Demo - Single & Multi-Value Subqueries
Multivalued Subqueries
The Any Parameter
In-Line Views
The Exists Parameter
Demo - How Exists Help Performance
Set Operators (Conjunctions)
Union
Demo - Unions
Set Operator Intersect
The Minus Conjunction
The Model Clause
Modify Functions
Update a Single Row
Complex Update
Merging Data In Oracle Tables
SQL Delete
Introduction to Lab 4
Lab - Select Rows from Multiple Tables
Chapter 3 Review
Advanced DML Functions
Qualified Names
Correlation Variables
Advanced DML Functions Cont.
Demo - Oracle's Natural and Outer Joins
ANSI/ISO Join Statements
Oracle Join Statements
Multiple Table Join
More about Aliases
Demo - Joins
Subqueries
Demo - Single & Multi-Value Subqueries
Multivalued Subqueries
The Any Parameter
In-Line Views
The Exists Parameter
Demo - How Exists Help Performance
Set Operators (Conjunctions)
Union
Demo - Unions
Set Operator Intersect
The Minus Conjunction
The Model Clause
Modify Functions
Update a Single Row
Complex Update
Merging Data In Oracle Tables
SQL Delete
Introduction to Lab 4
Lab - Select Rows from Multiple Tables
Chapter 3 Review
Non ANSI SQL Statements
Non ANSI SQL Statements
Oracle SQL Plus Commands
Number Formats
Numeric Functions
Character
Date Formats
Demo - Date Formats and Usage
Date Formats
The Date Functions
Demo - Date Functions
Syntax Operators & Parameter Subs.
Demo - Identify How Users Input Data
The Conversion Functions
The Sample Clause
Introduction to Lab 5
Lab - SQL*Plus Commands for Reporting
Chapter 4 Review
Oracle SQL Plus Commands
Number Formats
Numeric Functions
Character
Date Formats
Demo - Date Formats and Usage
Date Formats
The Date Functions
Demo - Date Functions
Syntax Operators & Parameter Subs.
Demo - Identify How Users Input Data
The Conversion Functions
The Sample Clause
Introduction to Lab 5
Lab - SQL*Plus Commands for Reporting
Chapter 4 Review
Data Definition Language Commands
Data Definition Language Commands
Base Tables
DDL Commands
Logical Definition - Tables
Create Table Mystaff
Demo - Create a Table
Logical Definition – System Datatypes
Column Data Types
Creating Table and
Creating Check Constraints
Demo - Creating Constraints
Creating Unique Constraints
Creating Referential Integrity Constraints
Demo - Create Primary and Foreign Keys
Non-Unique Indexes
Composite Indexes
Rebuilding Indexes
Bitmap Indexes
Creating Reverse Key Indexes
Demo - Creating Reverse Key Indexes
Index-Organized Tables
IOT Row-Overflow Strategy
Index Before or After Loading Data
Demo - Altering Tables after Creation
Synonyms
Deleting Catalog Items
Views
Column Names
Join Views
Views of Views
View Retrieval Queries
Introduction to Lab 6
Lab - Creating Tables and Indexes
Chapter 5 Review
Base Tables
DDL Commands
Logical Definition - Tables
Create Table Mystaff
Demo - Create a Table
Logical Definition – System Datatypes
Column Data Types
Creating Table and
Creating Check Constraints
Demo - Creating Constraints
Creating Unique Constraints
Creating Referential Integrity Constraints
Demo - Create Primary and Foreign Keys
Non-Unique Indexes
Composite Indexes
Rebuilding Indexes
Bitmap Indexes
Creating Reverse Key Indexes
Demo - Creating Reverse Key Indexes
Index-Organized Tables
IOT Row-Overflow Strategy
Index Before or After Loading Data
Demo - Altering Tables after Creation
Synonyms
Deleting Catalog Items
Views
Column Names
Join Views
Views of Views
View Retrieval Queries
Introduction to Lab 6
Lab - Creating Tables and Indexes
Chapter 5 Review
PL/SQL Programming
PL/SQL Programming
Overview of PL/SQL
The PL/SQL Block Structure
PL/SQL In The Oracle RDBMS
PL/SQL Variables
Referencing Variables
Using Composite Variables
Demo - Creating Composite Variables
Using Composite Variables Cont.
PL/SQL Records Processing
Assigning Values To Variables
Demo - Local and Global Variables
Assigning Values To Variables Cont.
Defining Composite Variables - Tables
Datatype Conversions
Input and Output Values For Variables
Demo - Creating Global Variables
Using The Select Clause
PL/SQL Insert Statements
PL/SQL Update Processing
PL/SQL Delete Processing
Decision Statements!
Use CASE Statements in PL/SQL
CASE Statement and Expression
CASE_NOT_FOUND Exception
PL/SQL Iterative Processing
Developing A Continue Statement
PL/SQL Iterative Processing Cont.
PL/SQL Exceptions
Error Processing
PL/SQL Exceptions Cont.
Demo - Exception Handling
PL/SQL Error Processing
Demo - Exception Block Processing
Raising User-Defined Exceptions
Demo - User-Defined Exceptions
PL/SQL Error Processing Cont.
Propagating Exceptions
PL/SQL Cursor Processing
Declaring The Cursor
Cursor Attributes With Explicit Cursors
Demo - How CURSORS are Handled
Cursor Attributes With Explicit Cursors
Demo - Cursor Looping
Update The Current Row
Demo - Update Processing via Cursors
Storing Rows In a PL/SQL Table
Passing in the Declare Cursor Command
PL/SQL Subprograms
PL/SQL Subprograms Viewing Code
Demo - Creating Procedures
PL/SQL Subprograms Rebuilding
Procedures
PL/SQL Stored Procedures
Returning Values
Demo - Parameters
Returning Values
The In/Out Argument in a Procedure
Demo - OUTPUT Parameters
Displaying Parameters
Executing a Stored Procedure in SQL
Creating Functions
Create Functions in a Declarative Section
Database Packages
A Sample Package
Reading/Writing Operating System Files
Reading Operating System
Introduction to Lab 7
Lab - Creating Procedures & Functions
Introduction to Lab 8
Lab - Creating Packages
Chapter 6 Review
Overview of PL/SQL
The PL/SQL Block Structure
PL/SQL In The Oracle RDBMS
PL/SQL Variables
Referencing Variables
Using Composite Variables
Demo - Creating Composite Variables
Using Composite Variables Cont.
PL/SQL Records Processing
Assigning Values To Variables
Demo - Local and Global Variables
Assigning Values To Variables Cont.
Defining Composite Variables - Tables
Datatype Conversions
Input and Output Values For Variables
Demo - Creating Global Variables
Using The Select Clause
PL/SQL Insert Statements
PL/SQL Update Processing
PL/SQL Delete Processing
Decision Statements!
Use CASE Statements in PL/SQL
CASE Statement and Expression
CASE_NOT_FOUND Exception
PL/SQL Iterative Processing
Developing A Continue Statement
PL/SQL Iterative Processing Cont.
PL/SQL Exceptions
Error Processing
PL/SQL Exceptions Cont.
Demo - Exception Handling
PL/SQL Error Processing
Demo - Exception Block Processing
Raising User-Defined Exceptions
Demo - User-Defined Exceptions
PL/SQL Error Processing Cont.
Propagating Exceptions
PL/SQL Cursor Processing
Declaring The Cursor
Cursor Attributes With Explicit Cursors
Demo - How CURSORS are Handled
Cursor Attributes With Explicit Cursors
Demo - Cursor Looping
Update The Current Row
Demo - Update Processing via Cursors
Storing Rows In a PL/SQL Table
Passing in the Declare Cursor Command
PL/SQL Subprograms
PL/SQL Subprograms Viewing Code
Demo - Creating Procedures
PL/SQL Subprograms Rebuilding
Procedures
PL/SQL Stored Procedures
Returning Values
Demo - Parameters
Returning Values
The In/Out Argument in a Procedure
Demo - OUTPUT Parameters
Displaying Parameters
Executing a Stored Procedure in SQL
Creating Functions
Create Functions in a Declarative Section
Database Packages
A Sample Package
Reading/Writing Operating System Files
Reading Operating System
Introduction to Lab 7
Lab - Creating Procedures & Functions
Introduction to Lab 8
Lab - Creating Packages
Chapter 6 Review
Course Closure
Course Closure
Product Code: OR-10G