Oracle SQL II

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.