Oracle Fundamentals

Book Now - 2 Delivery Methods Available:
Classroom Virtual Classroom Private Group - Virtual Self-Paced OnlineOverview
This course is designed to give delegates practical experience in writing SQL statements and scripts using Oracle SQL. The basic SELECT statement, the use of SQL functions, SQL*Plus parameters and the basic table and view handling statements are introduced.
The course also provides practical experience in using Oracle's PL/SQL programming language to implement conditional execution, loop control, cursor handling and exception handling.
The delegate will practise:
- Using SQL*Plus and SQL Developer
- Creating SQL statements to query database tables
- Using standard aggregate functions and related SELECT statement clauses
- Implementing extended SQL functions
- Using SQL*Plus run time parameters
- Creating and altering tables and views
- Inserting, updating and deleting rows in database tables
- Retrieving information from the data dictionary
- Writing PL/SQL programs
- Declaring and using variables and constants
- Using the IF... THEN ... ELSE statement
- Implementing CASE expressions
- Implementing basic, WHILE and FOR loop constructs
- Handling implicit and explicit cursors
- Implementing the cursor FOR loop
- Handling system raised exceptions
- Defining and raising user defined exceptions
- Declaring and using record types and PL/SQL tables
Training Partners
We work with the following best of breed training partners using our bulk buying power to bring you a wider range of dates, locations and prices.
Modules
Prerequisites
An understanding of databases and exposure to information technology in general would be useful
Scheduled Dates
Please select from the dates below to make an enquiry or booking.
Pricing
Different pricing structures are available including special offers. These include early bird, late availability, multi-place, corporate volume and self-funding rates. Please arrange a discussion with a training advisor to discover your most cost effective option.
Code | Location | Duration | Price | Mar | Apr | May | Jun | Jul | Aug |
---|---|---|---|---|---|---|---|---|---|
Later scheduled dates may be available for this course. |