Oracle Fundamentals

This course is designed primarily for administrators, developers and support personnel who need to access and work with an Oracle Database. The course combines the subject material of the Oracle SQL and PL/SQL courses and is suitable for delegates intending to sit the Oracle Certified Professional examination SQL and PL/SQL (1Z0-001).

Course Content

The Structure of a Relational Database
Using SQL*Plus
The Basic SQL Select Statement
Selecting Data from Multiple Tables
Grouping and Sorting Output
Character, Date and Numeric Functions
SQL*Plus Run-time Parameters and Variables
Producing Reports with SQL*Plus
Creating and Changing Tables, Indexes and Views
Inserting, Updating and Deleting Data
Controlling Access to the Database
Related Data Dictionary Tables and Views
The Structure of a PL/SQL Block
Declaring and Using Variables and Constants
Using SQL Statements in PL/SQL
PL/SQL Programming Constructs
Declaring and Using Cursors
Exceptions and Error Handling
Record Types and PL/SQL Tables

Skills

By the end of this course, the delegate will be able to:

Select data from an Oracle Database using SQL*Plus
Generate simple reports from selected data
Create and alter tables, indexes and views
Create, update and delete records
Grant and revoke access privileges
Access the Data Dictionary
Describe the Basic Structure of a PL/SQL Block
Use PL/SQL IF Statements, Expressions and LOOP Constructs
Declare and use Cursors
Use record types and PL/SQL Tables
Handle Errors and Exceptions within PL/SQL Scripts

Prerequisites

An understanding of IT. Some practical programming experience would prove advantageous.

Before taking any exam, ensure you have the recommended experience.