|
|
Database Courses
Microsoft Access
| Code |
ACB |
Course 1 |
starts 04/06/2009 |
|
» Enrol now ... |
| Venue |
Rosebery |
Course 2 |
starts 26/11/2009 |
| Cost |
$725 (incl GST) |
Time |
9.00am - 5.00pm |
|
» Course flyer |
| Sessions |
2 sessions |
Status |
places available |
Use Microsoft Access for basic database storage and information management. This hands-on look at Microsoft's database management system teaches you how to use Access for quick data access and to organise your information into meaningful reports.
SQL - Fundamentals
| Code |
SQL |
Course dates |
21/03/09, 02/05/2009 |
|
» Enrol now ... |
| Venue |
Kensington |
|
19/09/2009, 21/11/2009 |
| Cost |
$375 (incl GST) |
Time |
9.00am - 5.00pm |
|
» Course flyer |
| Sessions |
1 session |
Status |
places available |
This course is for anyone wanting to extract data from relational databases and gain an insight into the fundamentals of SQL. Retrieve data from single and multiple tables, look at SELECT and JOIN statements, sort and group data, use aggregate functions and create sub-queries.
SQL - Extended
| Code |
SQ2 |
Course dates |
28/03/2009, 09/05/2009 |
|
» Enrol now ... |
| Venue |
Kensington |
|
26/09/2009, 28/11/2009 |
| Cost |
$375 (incl GST) |
Time |
9.00am - 5.00pm |
|
» Course flyer |
| Sessions |
1 session |
Status |
places available |
Examining the more advanced features of SQL, in this course you will create database tables and constraints, explore the use of indexes, experience the power of creating stored procedures and triggers and understand how they can be applied to transactional processing. Some familiarity with SQL is essential.
|