P o l y m o r p h i c S o l u t i o n s

Home > Education > Course Outlines > Ingres

Education

Advanced SQL Course Outline

Duration

2 days

Overview

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

Upon completion of this course students will,

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

Audience

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

Prerequisites

A reasonable understanding of SQL and an ability to use Windows or Mac environment is the prerequisite for this course.

Format

Instructor-led class consisting of lectures, demonstrations and hands-on lab exercises.

What will you Learn?

Overview
Combining Tables
Managing Data Sequentially
Storage Structures
Complex Queries

Summarising Data
Basic Query Optimisation
Advanced Query Optimiser
Exercise Aids

Want more information?

View course dates, register on-line, or for more information (or a registration form) email the Education Manager, or call our office on +61 7 3236 5588.

Announcements

The Mental Health Council of Australia chooses ChilliDB as its enterprise CRM February 2010
The Mental Health Council of Australia (MHCA) is the peak, national non-government organisation representing and promoting the interests of the Australian mental health sector, committed to achieving better mental health for all Australians.
More...

Events

SQL & Databases Training Courses Brisbane Queensland
The course offers end-users a sound background on the concepts of a Relational Database Management System.
More...

Newsletters

Poly News - May 2010
Our third News Letter features the following articles, A Report on Technology Capacity in Australia's Not-For-Profit Sector in 2008, QCOSS Conference, ChilliDB 2.6 Release, Tips & Tricks of the Month, Staff Profile and our Upcoming Public Courses.
More...

Press Releases

Campbell Page chooses ChilliDB as its enterprise CRM
Campbell Page is an Australian, award winning, not-for-profit organisation operating from over 80 locations.
More...