SQL: Advanced Queries

Course Details


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

Duration:

2 Days

Audience:

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

Prerequisites:

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

SQL


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

Predicates

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

Joins

  • 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
Location
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: