In this hands-on class you will be provided with advanced features and clauses of the SELECT statement. Everything you learn here will be ANSI SQL compliant and should work with SQL databases such as Oracle, SQL Server, MySQL, MS Access, Informix, Sybase, or any other ANSI SQL compliant database.

Key Topics Covered

• Left, Right, Natural and Cross Joins
• Correlated Sub queries
• EXISTS and NOT EXISTS
• Sub queries in the FROM clause
• Writing Scripts to Generate Scripts

Prerequisite: Structured Query Language (SQL): Introduction or equivalent experience