SQL Advanced
Book Now - 2 Delivery Methods Available:
Classroom Virtual Classroom Private Group - Virtual Self-Paced OnlineOverview
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.
Objectives
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
Target Audience
Anyone who needs to use the more advanced features of SQL to improve their productivity in querying and updating an Oracle database.
Additional Information
- Course technical content is subject to change without notice.
- Course content is structured as sessions, this does not strictly map to course timings. Concepts, content and practicals often span sessions.
Training Partners
We work with the following best of breed training partners using our bulk buying power to bring you a wider range of dates, locations and prices.
Modules
Prerequisites
Delegates should have attended the Oracle SQL course or have a similar level of experience.
Additional Learning
The courses below may help you meet the knowledge level required to take this course.
-
Oracle SQL
The SQL training course is designed for anyone who needs to access and work with an Oracle Database
Scheduled Dates
Please select from the dates below to make an enquiry or booking.
Pricing
Different pricing structures are available including special offers. These include early bird, late availability, multi-place, corporate volume and self-funding rates. Please arrange a discussion with a training advisor to discover your most cost effective option.
| Code | Location | Duration | Price | Sep | Oct | Nov | Dec | Jan | Feb |
|---|---|---|---|---|---|---|---|---|---|
| OSA |
Virtual Classroom (London)
|
2 Days | $1,095 |
14-15
21-22
|
|
|