Mastering Relational Database Programming with PL/SQL
(PLS201, Live Instructor-Led Training, 4 days)


Description

This SETC Certified course covers the essential elements of the PL/SQL language. This course includes the creation and deletion of tables and the use of SQL to display, insert, delete and modify relational data. Having covered the basics of relational database manipulation, the course introduces participants to the more formal elements of the PL/SQL language including blocks, data types, variables and program flows. The course concludes with a preliminary exploration of procedures and functions in the context of PL/SQL packages.

Dates and Pricing


Jan 16 to Jan 19, 2018$2,500/person Feb 13 to Feb 16, 2018$2,500/person Mar 13 to Mar 16, 2018$2,500/person

Outline

The Oracle Development Environment
The Oracle RDBMS
Oracle Server Product Overview
PL/SQL Overview
Oracle Application Development Tools
Configuring and Creating Oracle Databases
Oracle Relational DB Management System
Tablespaces, Datafiles and Control Files
Using the Oracle SQL*PLUS Utility
Optimizing Table Storage
Creating Oracle Database Tables
Working with Schemas
Security
Creating and Managing Table
Creating Tables
Dealing with Time Zones
Datetime SQL Functions
Structured Query Language (SQL) Basics
The SELECT Statement
Retrieving Aggregate Values
Adding Table Records Using INSERT INTO
Advanced Sub-Queries
Deleting Data
Constraints and Sequences
Database Integrity and Constraints
Integrity Constraints
Primary Key Constraints
Referential Integrity: Foreign Keys
Modifying Tables and Constraints
Sequence
Retrieving Table and Constraint Information
Advanced SQL Querying
Multiple-Table Join Strategies
Using Multi-Table Joins
Creating and Using Sub-Queries
Creating and Using Stored Views
PL/SQL Language Fundamentals
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
PL/SQL Procedures and Functions
Overview
Creating Procedures and Functions
Simple Stored Procedures
Stored Procedures with Parameters
What We Have Learned and the Real World
PL/SQL Packages
Creating PL/SQL Packages
Oracle WRAP Utility