An Introduction to PL/SQL Development for Professional Developers
(PLIDEV, Live Instructor-Led Training, 3 days)


Description

This SETC Certified course provides developers with a comprehensive overview of the powerful and flexible development language of PL/SQL. Beginning with the creation of database tables, the course presents a variety of PL/SQL language features in a logical and sequential order beginning with SQL syntax and ending with packages and functions. If you need to work with PL/SQL, this course will get you started in the right direction.

Dates and Pricing


Jan 10 to Jan 12, 2018$1,675/person Feb 7 to Feb 9, 2018$1,675/person Mar 7 to Mar 9, 2018$1,675/person

Outline

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
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