Oracle SQL Advanced

RSM Technology

Course

In London, Leeds and Edinburgh

£ 725 + VAT

The best Oracle courses

See all

See all

Description

  • Type

    Course

  • Level

    Advanced

By the end of this course, the delegate will be able to: Use SQL Developer as an alternative to SQL*Plus, Manage Schema Objects with Data Dictionary Views, Write Multiple Column Subqueries, Manage Large Data Sets with Subqueries, Construct Hierarchical Queries, Use the ROLLUP, CUBE and GROUPING SETS Group By Extensions, Manage Data in Different Time Zones, Use Regular. Suitable for: Anyone who needs to use the more advanced features of SQL to improve their productivity in querying and updating an Oracle database Together with the SQL course, this course covers the major topics required for the following Oracle examinations: Introduction to Oracle9i: SQL Oracle Certified Professional examination (1Z0-007) Oracle Database SQL Expert (IZ0-047)

Facilities

Location

Start date

Edinburgh (Midlothian/Edinburghshire)

Start date

On request
Leeds (North Yorkshire)

Start date

On request
London
See map

Start date

On request

About this course

Delegates should have attended the SQL course or have a similar level of experience.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • SQL

Course programme

Delegates:
Anyone who needs to use the more advanced features of SQL to improve their productivity in querying and updating an Oracle database Together with the SQL course, this course covers the major topics required for the following Oracle examinations:

Introduction to Oracle9i: SQL Oracle Certified Professional examination (1Z0-007)Oracle Database SQL Expert (IZ0-047)
Objectives:
By the end of this course, the delegate will be able to:
  • Use SQL Developer as an alternative to SQL*Plus
  • Manage Schema Objects with Data Dictionary Views
  • Write Multiple Column Subqueries
  • Manage Large Data Sets with Subqueries
  • Construct Hierarchical Queries
  • Use the ROLLUP, CUBE and GROUPING SETS Group By Extensions
  • Manage Data in Different Time Zones
  • Use Regular Expression Functions
  • Control User Access to Database Objects
Note:
Exams are not included as part of the course. Before taking any exam, delegates must ensure they have the recommended experience.
Topics Covered:
  • SQL Developer
  • Hierarchical Queries
  • Enhanced Grouping Extensions and Functions
  • TIMESTAMP, TIMEZONE and INTERVAL Datatypes
  • TIMESTAMP and INTERVAL Functions and Literals
  • POSIX Compliant Regular Expression Notation
  • Regular Expression Functions
  • Enhanced Subquery Functions
  • Multitable Insert Statements
  • Merge Rows in a Table
  • External Tables
  • Flashback Operations
  • Control User Access
Requirements:
Delegates should have attended the SQL course or have a similar level of experience.

See related categories

Oracle SQL Advanced

£ 725 + VAT

The best Oracle courses

See all

See all