Students enrolled in this course will develop skills in the use of Structured Query Language. SQL will be used to create, populate and manipulate databases within a client-server database system, as well as to retrieve data in a variety of ways.
Major types of queries studied in this course will include:
1. Basic SELECT queries
2. SQL functions
3. CREATE TABLE queries
The database management system utilised will be 'MS SQL Server', however, other databases such as Access, MS SQL Server and Oracle may also be explored.
This course is suitable for anyone who is interested in databases. It is specifically designed for students and employees who wish to develop their skills in SQL to intermediate level and beyond
This is a non-accredited program.
On completion of this course, participants will have good working knowledge of SQL. Participants will work on a fairly complex database on MS SQL Server and create a number of SQL queries in order to perform useful business functions.
Participants should have basic understanding of databases. Some experience with Access or any other relational DBMS would be an advantage
All written notes will be provided in class.
A USB storage device
Participants will receive a Certificate of Participation.
N/APrintable course flyer