Back
|
|
|
ORACLE FUNDAMENTALS
Delegates: |
|
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). |
Objectives: |
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
|
Note: |
|
Before taking any exam, ensure you have the recommended experience.
|
Topics Covered: |
- 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
|
Requirements:
|
|
An understanding of IT. Some practical programming experience would prove advantageous. |
|
|
|
