HOME
 

Oracle SQL Advanced

Focus on Training
Course summary
Nationwide
Next available date: - United Kingdom
Professional Training

Course description

The Oracle SQL Advanced course is designed to give delegates practical experience in using some of the more advanced features of Oracle SQL.  Additional datatypes and the use of advanced SQL functions and expressions are covered together with enhanced table handling features.

The delegate will learn and acquire skills as follows:

  • Retrieving Data Using Correlated Subqueries, In-Line Views and Multi-Column Subqueries
  • Using the WITH Clause
  • Inserting and Updating Rows Using Complex Subqueries
  • Creating Hierarchical Queries
  • Creating Analytic Queries
  • Using ROLLUP, CUBE and GROUPING SETS Group By Enhancements
  • Implementing the GROUPING and GROUPING_ID Functions
  • Managing Large Data Sets
  • Inserting Data Conditionally and Unconditionally
  • Merging Rows in a Table
  • Creating TIMESTAMP and INTERVAL Datatypes
  • Using TIMESTAMP, TIMEZONE and INTERVAL Functions and Literals
  • Using Regular Expressions and Implementing Related Functions
  • Managing Objects with the Data Dictionary
  • Managing Schema Objects
  • Performing Flashback Operations
  • Creating and Using External Tables
  • Controlling User Access to Database Objects

Who will the Course Benefit?

Anyone who needs to use the more advanced features of SQL to improve their productivity in querying and updating an Oracle database.

About provider

Focus on Training: Best Practice Skills from the Specialists

Focus on Training is a professional training company specialising in offering accredited Project Management and IT programmes. With over 10,000 courses offered in over 100 locations throughout the United Kingdom, Focus is a premier training provider. All programmes can be booked online...


Read more and show all courses with this provider

Contact info

Focus on Training

Olympus House, Werrington Centre
PE4 6NA Peterborough

 Show phone number
www.focus-on-training.co.uk


Find a course for you!

  Read the course
 summary on this page

 Fill in your details and Request information

 Receive all the info you need

Find more courses here