Introduction
9:00am
Retrieving Data using the SQL SELECT Statement
11:00am
Lunch Break
12:30pm
Restricting and Sorting Data
1:30pm
Using Single-Row Functions to Customize Output
3:00pm
End of Day One
5:00pm
Day Two
Using Conversion Functions and Conditional Expressions
9:00am
Reporting Aggregated Data Using the Group Functions
11:00am
Lunch Break
12:30pm
Displaying Data From Multiple Tables Using Joins
1:30pm
Using Subqueries to Solve Queries
3:00pm
End of Day Two
5:00pm
Day Three
Using the SET Operators
9:00am
Managing Tables using DML statements
11:00am
Lunch Break
12:30pm
Continue Managing Tables using DML statements
1:30pm
Introduction to Data Definition Language
2:30pm
End of Day Three
5:00pm
Programme scope, delivery arrangements and suitability are confirmed during enquiry.