Oracle Introduction for Experienced SQL Users

2 Day Course
Code OIEU

Book Now - 2 Delivery Methods Available:

Scheduled Online Onsite

Overview

This course is designed for anyone who needs to access and work with an Oracle Database.  In conjunction with the Oracle PL/SQL course, this course is suitable for delegates intending to sit the; Introduction to Oracle: SQL and PL/SQL Oracle Certified Professional examination (1Z0-001).  In conjunction with the Oracle9i SQL Advanced course, this course is suitable for delegates intending to sit the; Introduction to Oracle9i: SQL Oracle Certified Professional examination (IZ0-007).

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

Course topics: (17 topics)

  • The Basic SQL Select Statement
  • Selecting Data from Multiple Tables
  • Inner Joins, Outer Joins and Self Joins
  • Hierarchical Queries
  • Sub-queries
  • Grouping and Sorting Output
  • CUBE and ROLLUP features
  • Character, Date and Numeric Functions
  • Run-time Parameters and Variables
  • SQL*Plus Control Parameters
  • Creating and Changing Tables and Views
  • Constraints and Indexes
  • Inserting, Updating and Deleting Data
  • Multi-Table Inserts and Merges
  • Basic Transaction Control
  • Controlling Access to the Database
  • Related Data Dictionary Tables and Views

Prerequisites

Experience of using SQL with another relational database is required.

Relevant Certifications

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 Sep Oct Nov Dec Jan Feb
OIEU 2 Days $895

or call:408-759-5074

Course PDF

Print

Share this Course

+1
Share

Recommend this Course

Sections