Oracle SQL

Course

In London, Manchester, Birmingham and 3 other venues

£ 995 + VAT

Description

  • Duration

    3 Days

Description

By the end of this course, the delegate will be able to: Describe the basic structure of a relational database, Use the command line features of SQL*Plus, Use SQL Developer to access an Oracle Database, Create SQL statements to select data from an Oracle Database, Use SQL run time parameters, Use aggregate functions, Use numeric, character, date, conversion and miscellaneous.
Suitable for: This course is designed for anyone who needs to access and work with an Oracle Database. This course is suitable for anyone intending to sit the Oracle Database 11g: SQL Fundamentals (IZ0-051) examination.  Together with the Oracle SQL Advanced course, this course is suitable for delegates intending to sit the following exams: Introduction to Oracle9i: SQL Oracle Certified Professional (1Z0-007) Oracle Database SQL Expert (IZ0-047)

Facilities

Location

Starts

Birmingham (West Midlands)

Starts

On request
Bristol (Avon)

Starts

On request
Edinburgh (Midlothian/Edinburghshire)

Starts

On request
Leeds (North Yorkshire)

Starts

On request
London
See map

Starts

On request
Manchester (Greater Manchester)

Starts

On request
See all (6)

To take into account

An understanding of IT is required.

Questions & Answers

Ask a question and other users will answer you

Who do you want to respond to your question/enquiry?

We will only publish your name and question

Subjects

  • SQL

Course programme

Delegates:
This course is designed for anyone who needs to access and work with an Oracle Database. This course is suitable for anyone intending to sit theOracle Database 11g: SQL Fundamentals (IZ0-051)examination. Together with the Oracle SQL Advanced course, this course is suitable for delegates intending to sit the following exams:

Introduction to Oracle9i: SQL Oracle Certified Professional (1Z0-007)
Oracle Database SQL Expert (IZ0-047)
Objectives:

By the end of this course, the delegate will be able to:
  • Describe the basic structure of a relational database
  • Use the command line features of SQL*Plus
  • Use SQL Developer to access an Oracle Database
  • Create SQL statements to select data from an Oracle Database
  • Use SQL run time parameters
  • Use aggregate functions
  • Use numeric, character, date, conversion and miscellaneous functions
  • Use subqueries
  • Create and alter tables, indexes and views
  • Create, update and delete records
  • Manage sequences and synonymns
  • Use the Data Dictionary
Note:
Exams are not included as part of the course. Before taking any exam, delegates must ensure they have the recommended experience.
Topics Covered:
  • The Structure of a Relational Database
  • Using SQL*Plus
  • Using SQL Developer
  • The Basic SQL Select Statement
  • Selecting Data from Multiple Tables
  • Inner Joins, Outer Joins and Self Joins
  • Grouping and Sorting Output
  • Sub-queries and In-line Views
  • Character, Date and Numeric Functions
  • SQL*Plus Run-time Parameters and Variables
  • Creating and Changing Tables and Views
  • Constraints and Indexes
  • Inserting, Updating and Deleting Data
  • Basic Transaction Control
  • Controlling Access to the Database
  • Related Data Dictionary Tables and Views
Requirements:
An understanding of IT is required.

Oracle SQL

£ 995 + VAT