Click here to see our Press Centre for Latest News and Events

3 Day Course
Course Overview:
The course provides a comprehensive introduction to use of the Structured Query Language, commonly known as SQL. Most of the learning is “hands-on”, allowing the student to rapidly become familiar with the constructs necessary to extract information from, and manipulate data in, relational databases.

                                                                                                                    
Course Content:

Day One
Introduction and Objectives, Teaching Method, Brief history of SQL
Elements of a Relational Database (tables, columns, relationships)
Select queries – a first look
Structure of the basic SQL statement
Specific versus all columns
Applying simple conditions
Applying compound conditions
Additional comparison operators
The null value
Sorting results
Practical Classroom Exercises
Summary of day’s training

Day Two
Re-cap of key learning points
Select queries – a further look
Queries involving calculated values
Summarising values – group by and aggregation
Groups with conditions – the Having clause
Advanced queries
Retrieving data from multiple tables – the join statement
Cartesian products
Database Design weaknesses and implications
Practical Classroom Exercises
Summary of day’s training

Day Three
Re-cap of key learning points
Complex table joins
Inner and outer (left and right) joins
Sub-queries
Joining a table to itself
Union command
Table maintenance syntax
View syntax
Common SQL Databases and proprietary syntax in each
Course Summary
Course Evaluation

Duration:   
3 days (8.00 to 16.00)                   

Intended participants: 
Business Analysts, System Developers, Data Modellers and others (e.g. management, auditors) who need to extract data from corporate databases. Essentially, anyone needing to write or modify SQL queries.

Presenter:
Amberjack Systems Engineering.  Two trainers are used for the duration of the course, which ensures that all participants receive the necessary focused attention during practical exercises. Both trainers have extensive experience with SQL (and relational databases). 

Pre-requisites
None. However, it would be very advantageous to have attended the ‘Introduction to Data Modelling’ course.

Nr of participants:
Minimum 8    Maximum 12

Registration:
For Course Schedules, Locations, Fees and Registration information:                                        see www.infoblueprint.co.za > Services > Education and Coaching or contact Tammy on 021 551 2410.   
We can also present this course ‘in-house’ if required. Please contact Alan Snow on 079 907 7680 to discuss your requirements.