Oracle SQL II

Course

In Manchester

Price on request

Description

  • Typology

    Course

  • Location

    Manchester

  • Duration

    3 Days

Description

To gain knowledge and skills on the advanced functions of SQL.
Suitable for: Anyone

Facilities

Location

Starts

Manchester (Lancashire)
One Central Park, Northampton Road, M40 5WR

Starts

On request

To take into account

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

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

Course programme

Oracle SQL II

What's the course about?

The aim of this course is to enable students to carry out a number of advanced functions using SQL.

Areas covered by the course include:

  • How to use iSQLPlus
  • ANSI-Compliant Inner Joins
  • ANSI-Compliant Outer and Self Joins
  • Hierarchical Queries
  • Enhanced Grouping Extensions and Functions
  • TIMESTAMP, TIMEZONE and INTERVAL Datatypes
  • TIMESTAMP and INTERVAL Functions and Literals
  • Overview of Analytic Functions
  • Ranking Data by Value and Percentile
  • Providing Cumulative, Moving and Centered Aggregates
  • POSIX Compliant Regular Expression Notation
  • Regular Expression Functions
  • Enhanced Subquery Functions
  • CASE Expressions
  • Extended Insert and Merge Operations on Tables
  • Creating and Using External Tables

The course is delivered through lectures and workshops and it is assessed on an end test.

What will I be able to do after I've completed this course?

On completion of this course, delegates could go on to study on the PL/SQL course at Manchester NTI. The Oracle SQL 2 course can enhance the career opportunities of junior Oracle developers.

Oracle SQL II

Price on request