ORACLE Fundamentals
Sponsored links
Course Overview
Training Course Description:
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*Plus and PL/SQL courses and is suitable for delegates intending to sit the Oracle Certified Professional examination SQL and PL/SQL (1Z0-001).
Prerequisites:
An understanding of IT. Some practical programming experience would prove advantageous.
ORACLE Fundamentals includes the following modules:
| Delivery: |
|
| Regions: |
|
| Category: |
Further Details
Course topics:
The Structure of a Relational Database
The Basic SQL*Plus Select Statement
Selecting Data from Multiple Tables
Grouping and Sorting Output
Character, Date and Numeric Functions
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
Variables, Constants and Cursors
Record Types, PL/SQL Tables and Sub-types
PL/SQL Programming Constructs
Exceptions and Error Handling
Introduction to Procedures and Functions
This Training Course is taught in classrooms in the following locations:
Medway
London W
Information provided is for information purposes only and no guarantees are made with regards to accuracy. It is advised that all details are checked prior to making a booking. Contents © 1999 - 2012. All rights reserved.
