Learn how to develop powerful PL/SQL programs in support of Oracle's industry leading database product. Unlock the true potential of your Oracle database by leveraging the power of this important tool.




Course Topics:
Covers over 35 topics on SQL and PL/SQL

SQL
• Table and Relational Concepts
• Building Record Sets
• Using Column Expressions
• Sorting Results
• Filtering Record Sets
• Grouping Data
• Filtering Grouped Results
• Inner and Outer Joins
• Simple Sub-Queries
• Correlated Sub-Queries
• Scalar Functions
• Data Type Conversion
• Logic Functions
• Aggregate Functions
• Manipulating Database Records
• Creating Tables
• Creating Views
• Creating Sequences
• Database Constraints and Keys
• Synonyms
PL/SQL
• Building Procedures and Functions
• PL/SQL Variables
• PL/SQL Parameters
• Exception Handling
• Using Implicit Cursors
• Using Explicit Cursors
• Building PL/SQL Packages
• Overloading Program Units
• User-Defined SQL Functions
• Implementing Triggers
• Native Dynamic SQL
• Programming with Large Objects
• Encrypting PL/SQL code
• Protecting the Database Against SQL Injection
• PL/SQL Best Practices

There are over 30 Hands-On Labs to reinforce the materials presented

IMPORTANT:
This course is not for a certification from Oracle
This course is not teaching Oracle Administration

Main Course Page      Frequently Asked Questions About This Course