PL/SQL

Provides an in-depth coverage of Structured Query Language (SQL) and PL/SQL. SQL is the standard relational database access and programming language for computers of all sizes. This course will also introduce Stored Procedures and Functions, Database Triggers, Transaction Processing, Normalization, Client/Server with Java & Oracle, and Database Administration.

PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's procedural language extension for SQL and the Oracle relational database. PL/SQL is available in Oracle Database (since version 7), TimesTen in-memory database (since version 11.2.1), and IBM DB2 (since version 9.7). Oracle Corporation usually extends PL/SQL functionality with each successive release of the Oracle Database.

PL/SQL includes procedural language elements such as conditions and loops. You can declare constants and variables, procedures and functions, types and variables of those types, and triggers. You can handle exceptions (runtime errors). Arrays are supported involving the use of PL/SQL collections. Implementations from version 8 of Oracle Database onwards have included features associated with object-orientation. You can create PL/SQL units—procedures, functions, packages, types, and triggers —that are stored in the database for reuse by applications that use any of the Oracle Database programmatic interfaces.

A PL/SQL program unit is one of the following: PL/SQL Anonymous Block, Procedure, Function, Package Specification, Package Body, Trigger, Type Specification, Type Body, Library. Program units are the PL/SQL source code that is compiled, developed and ultimately executed on the database.

Course Contents

SQL	PL/SQL
Retriving data using the SQL select statement Restricting and sorting data Using single row function to customize output Aggregated data using the grout function Displaying data from multiple tables Using sub queries to solve problems Using set operators Manipulating data Using DDL statements to create and manage tables Creating other schema objects Managing objects with data dictionary Controlling User access Managing schema objects Manipulating large data sets Generating report by grouping related data Retrieving data using sub queries Regular expression support	Introduction Declaring Variables Writing Executable Statements Interacting with Oracle Server Writing Control Structures Working with Composite Data Types Writing Explicit Cursors Writing Implicit Cursors Handling Exceptions Creating Procedures Creating Functions Managing Subprograms Creating Packages More Package concepts Creating Database Triggers

SQL

PL/SQL

Retriving data using the SQL select statement
Restricting and sorting data
Using single row function to customize output
Aggregated data using the grout function
Displaying data from multiple tables
Using sub queries to solve problems
Using set operators
Manipulating data
Using DDL statements to create and manage tables
Creating other schema objects
Managing objects with data dictionary
Controlling User access
Managing schema objects
Manipulating large data sets
Generating report by grouping related data
Retrieving data using sub queries
Regular expression support

Introduction
Declaring Variables
Writing Executable Statements
Interacting with Oracle Server
Writing Control Structures
Working with Composite Data Types
Writing Explicit Cursors
Writing Implicit Cursors
Handling Exceptions
Creating Procedures
Creating Functions
Managing Subprograms
Creating Packages
More Package concepts
Creating Database Triggers