Oracle SQL Advanced

StayAhead Training Ltd

Course

In London

£ 725 VAT inc.

The best Oracle courses

See all

See all

Description

  • Type

    Course

  • Location

    London

  • Class hours

    14h

  • Duration

    2 Days

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. 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:

Facilities

Location

Start date

London
See map
6 Long Lane, Barbican, EC1A 9HF

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

  • Controlling User Access to Database Objects

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

See related categories

Oracle SQL Advanced

£ 725 VAT inc.

The best Oracle courses

See all

See all