Further Details
Prerequisites:
An understanding of IT. Some practical programming experience would prove advantageous.
ORACLE Fundamentals includes the following modules:
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
Guide price
£1350 + Vat |
