The Complete PL/SQL Programming Course
(ORASQLCP, Live Instructor-Led Training, 4 days)


Description

This intensive SETC certified course provides a comprehensive and detailed exploration of the PL/SQL language and it many nooks and crannies. Starting with the basic concepts of the SQL language, the course quickly accelerates to coverage of advanced SQL techniques and PL/SQL programming fundamentals. This is followed by modules covering the concepts of cursors, triggers, procedures and functions and packages. An no course on PL/SQL would be complete in the absence of object oriented programming, Java integration and XML processing. So we do that too. Finally, we conclude our grand tour of PL/SQL with a look at performance and an introduction to performance tuning concepts. If you want to learn PL/SQL, this is the course for you.

Dates and Pricing


Jan 23 to Jan 26, 2018$2,500/person Feb 20 to Feb 23, 2018$2,500/person Mar 20 to Mar 23, 2018$2,500/person

Outline

The Oracle Development Environment
Learning Objectives
The Oracle RDBMS
Oracle Server Product Overview
PL/SQL Overview
Oracle Application Development Tools
What We Have Learned and the Real World
Configuring and Creating Oracle Databases
Learning Objectives
Oracle Relational DB Management System
Tablespaces, Datafiles and Control Files
Using the Oracle SQL*PLUS Utility
Optimizing Table Storage
What We Have Learned and the Real World
Creating Oracle Database Tables
Learning Objectives
Working with Schemas
Security
Creating and Managing Table
Creating Tables
Dealing with Time Zones
Datetime SQL Functions
What We Have Learned and the Real World
Structured Query Language (SQL) Basics
Learning Objectives
Retrieving Records
Retrieving Aggregate Values
Adding Table Records Using INSERT INTO
Advanced Sub-Queries
Deleting Data
What We Have Learned and the Real World
Constraints and Sequences
Learning Objectives
Database Integrity and Constraints
Integrity Constraints
Primary Key Constraints
Referential Integrity: Foreign Keys
Modifying Tables and Constraints
Sequence
Retrieving Table and Constraint Information
What We Have Learned and the Real World
Advanced SQL Querying
Learning Objectives
Multiple-Table Join Strategies
Using Multi-Table Joins
Creating and Using Sub-Queries
Creating and Using Stored Views
What We Have Learned and the Real World
PL/SQL Language Fundamentals
Learning Objectives
PL/SQL Programming Basics
Entering PL/SQL Using SQL*Plus
PL/SQL Script Development Basics
PL/SQL Blocks
PL/SQL Data Types
PL/SQL Variables
Controlling PL/SQL Program Flow
What We Have Learned and the Real World
PL/SQL Procedures and Functions
Learning Objectives
Overview
Creating Procedures and Functions
Simple Stored Procedures
Stored Procedures with Parameters
What We Have Learned and the Real World
PL/SQL Packages
Learning Objectives
Creating PL/SQL Packages
Oracle WRAP Utility
What We Have Learned and the Real World
Oracle Database Triggers
Learning Objectives
Triggers
Creating Triggers
Using Triggers for Logging
System Triggers
Working with PL/SQL Records
Learning Objectives
PL/SQL Records
Defining Record Types in PL/SQL
Defining Record Types as Object Types
What We Have Learned and the Real World
PL/SQL Collections
Learning Objectives
Introduction
PL/SQL Collections Overview/Types
Working with Varrays
Using Nested Tables
Using Associative Arrays
Collection Reference
PL/SQL Error Handling
Learning Objectives
Oracle Errors
Custom Errors
Exception Handling
Raising Exceptions
Handling User Exceptions
Handling PL/SQL Exception
Propagating Exception
What We Have Learned and the Real World
Object Oriented Programming with PL/SQL
Learning Objectives
PL/SQL and Object Oriented Programming
Creating Objects
Methods
Object Table
Using DML with Objects
What We Have Learned and the Real World
XML Processing
Learning Objectives
Processing XML Data
Creating XML Documents
Validating XML Data against a Schema
A Few Examples
What We Have Learned and the Real World
Oracle and Java
Learning Objectives
Preparing the Environment
Using loadjava and dropjava
Managing Java
Using DBMS_JAVA and DBMS_JAVA_TEST
Publishing and Using Java
A Few Useful Examples
What We Have Learned and the Real World
Best Practices and Performance Tuning
Learning Objectives
Overview
Optimization and Performance Tuning
Using Indexes
Common Mistakes and their Solutions
What We Have Learned and the Real World