Oracle PL SQL Tutorial Certification

From the comfort of your own desk you can have access to one of the most comprehensive Oracle PL SQL tutorials ever created. The training is presented using narrated QuickTime videos and have a duration of over 12 hours. The tutorial is project based and comes complete with working files for you to follow along with should you wish. Oracle is without a doubt a database with a serious pedigree and any user who has a strong understand of this application can expect to benefit financially in the workplace. This Oracle PL SQL tutorial covers in detail the subjects required to pass the prestigious 1Z0 007 Exam.

Before embarking on this tutorial users should have a basic knowledge of Oracle or at the very least a understanding of commercial databases. Authored by long time Oracle expert Gavin Powell you can expect to gain sufficient knowledge to be able to use PL SQL in a commercial environment and pass the Oracle Certification.

Topics covered include:
Relational Databases, Normalization, Using the Enterprise Manager in Oracle, Types of Tables, Basic Queries, Creating an Index, Constraints, Synonyms, Views, Errors, Adding Users, Database Security, Privileges, Using SELECT, Null Values, Functions, Strings, Numbers, Creating Joins with WHERE, ORDER BY, Inner Join, Outer Join, Group By, Running Sub Queries, Multiple Data Insert, Triggers, Using Variables, Implicit Cursors.

Whilst the topics listed above may seem a comprehensive list it’s only a small selection of subjects covered on the Oracle PL SQL tutorial. For a detailed view of subjects covered and a free demo please follow the link below.

Oracle PL SQL Tutorials online