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

Home > Education > Course Outlines > Database and SQL

Education

Introduction to Databases & SQL Course Outline

Duration

2 days

Overview

This course offers end-users a sound background on the concepts of a Relational Database Management System. It is primarily aimed at end-users who need to understand SQL in order to effectively and efficiently query their corporate database either directly or through third-party Query and Reporting Tools.

Audience

Users who will be querying the corporate database either directly or through third-party Query and Reporting Tools.

Prerequisites

There are no prerequisites for this course.

Format

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

Objectives

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

Understand the basics of what a database is
Formulate simple SELECT statements
Qualify queries using the WHERE clause
Summarise data using the GROUP BY and HAVING clauses
Formulate complex queries which span multiple tables
Gain an appreciation for performance when developing queries
Gain confidence in developing accurate and efficient SQL queries

Topics Covered

Introduction to Databases	Combining Tables
Defining a databases management system Defining a Relational Database Management System Defining Normalisation What does SQL do?	What is a join? Why we join tables? How to get a good Join Formulation of a Join
Basic SELECT Statements	Summarising Information
The SELECT Statement Restricting Columns Performing Arithmetic Computing SQL Functions Eliminating Duplicate Rows Sorting Data	Aggregate Functions Grouping Data Qualifying Groups of Data � The Having Clause
Qualifying Data	More Complex SQL
The WHERE clause Comparison Operators Logical Operators Selecting NULL values Subqueries ANY and ALL predicates String Components	Exists Predicate Outer Joins Pattern Matching and String Manipulations Handling Date Comparisons and Manipulation

Sign up to learn about SQL and database technology. Learn to harness the power which is contained within your corporate database.

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...