SQL: Advanced Queries

Course Details

This course addresses how to write SQL effectively, taking into account performance considerations.


2 Days


This course will suit Database Administrators, Application Developers and other users who require access to their database in an efficient manner.


To successfully understand the content and complete activities students must have proficient knowledge of Windows and a basic understanding of SQL is recommended.


Learning Outcomes

At the end of the course students will be able to:

  • Be able to write complex SQL Queries
  • Understand Performance implications when writing SQL
  • Be able to interrupt QEPs and generate better SQL
  • Gain a thorough understanding of the syntax and semantics of SQL statements
  • Be able to use the OpenIngres interactive terminal monitor


  • Comparison
  • Like Predicates
  • Between Predicates
  • In Predicates
  • Any All or Some Predicates
  • Using Subqueries Effectively
  • Subquery Rules
  • Correlated Subqueries
  • EXISTS Predicate
  • Scalar Functions


  • Why Join Tables
  • Unions
  • Types of Joins
  • Formulation of Join
  • Outer Joins
  • Caveats
  • Self Joins
  • Limitations of Joins

Summarizing Data
  • Aggregate Functions
  • Aggregate Queries
  • Aggregate Quotes
  • Set Functions
  • Grouping

Managing Data Sequentially
  • Cursors
  • Cursor Solution
  • Select Cursor

Managing Tables
  • Creating Tables
  • Changing Tables
  • Deleting Tables
  • Ownership

Query Optimization
  • Indexes
  • Statistics
  • Query Flattening
  • Disjunctive Normal Form
  • Function Queries

Event Properties

Event Date 27-02-2018
Event End Date 28-02-2018
Individual Price $1,210.00
Course Code SQLADV
Corporate Training Solutions Australia
Level 19, Waterfront Place, 1 Eagle St Brisbane, QLD 4000 Australia
Corporate Training Solutions Australia

Group Rate

#Registrants Rate/Person($)
3 1,149.50
4 1,089.00
$1,210.00 10

Location Map

Share this event: