GogoTraining - Oracle 11g/12c: Advanced SQL

In this course, students learn how to use the advanced features of SQL in order to query and manipulate data within the database. Advanced querying and reporting techniques including using SET operators, writing hierarchical queries and using the Flashback Query feature are explained. Schema objects such as Tables, Indexes and Constraints are discussed in detail.

In order to take this course you need to have taken Oracle 11g/12c: Introduction to SQL and have experience in writing Oracle SQL statements.

Prerequisites
You need to have equivalent experience or have taken the following GogoTraining courses:
- Introduction to Programming for Non-Programmers
- Introduction to Programming and Coding for Everyone with JavaScript
- Oracle 10g/11g: Introduction to SQL
- Oracle 11g/12c: Introduction to SQL

Objectives
As a result of taking this Oracle course, you will be to:
- Combine SQL result sets into a single result set using SET operators
- Access data from a previous point in time using the flashback query feature
- Combine multiple SQL statements into one statement
- Create various database objects

Course Materials
Want to be able to access these helpful materials? Contact Us!
- Student Guide
- Lab Exercise Guide
- Data File
- Setup Guide - 11g
- Setup Guide - 12c