Structured Query Language (SQL)

Overview

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

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.

Course content

  • Introduction to MySQL. SQL files.
  • Relational database design.
  • Basic SELECT queries in a variety of settings.
  • Multi-table queries.
  • Types of table joins. Using aliases
  • User views of data.
  • SQL as a data security language
  • GRANT and REVOKE SQL as a DDL and a DML
  • CREATE TABLE queries and action queries SQL functions, expressions, aggregation and grouping in SQL Sub-queries and UNION queries
  • Various other aspects of SQL as required

Ideal for

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

Important Information

This is a non-accredited program.

More information

Outcome

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.

Pre-requisites

Participants should have basic understanding of databases. Some experience with Access or any other relational DBMS would be an advantage

Materials supplied

All written notes will be provided in class. 

 

 

Materials to bring

A USB storage device

Award

Participants will receive a Certificate of Participation.

Additional notes

N/A

Printable course flyer

Available course dates

Tuesday 20 February 2018

  • Code S650194
  • Start date 20.02.18
  • End date 17.04.18
  • Hours 16.00
  • Campus RMIT City
  • Fee $800.00
Enrol now
Session  Start  End Hours
Tue 20.02.18 05:30pm 07:30pm 2.00
Tue 27.02.18 05:30pm 07:30pm 2.00
Tue 06.03.18 05:30pm 07:30pm 2.00
Tue 13.03.18 05:30pm 07:30pm 2.00
Tue 20.03.18 05:30pm 07:30pm 2.00
Tue 27.03.18 05:30pm 07:30pm 2.00
Tue 10.04.18 05:30pm 07:30pm 2.00
Tue 17.04.18 05:30pm 07:30pm 2.00

Thursday 22 February 2018

  • Code S650194
  • Start date 22.02.18
  • End date 19.04.18
  • Hours 16.00
  • Campus RMIT City
  • Fee $800.00
Enrol now
Session  Start  End Hours
Thu 22.02.18 05:30pm 07:30pm 2.00
Thu 01.03.18 05:30pm 07:30pm 2.00
Thu 08.03.18 05:30pm 07:30pm 2.00
Thu 15.03.18 05:30pm 07:30pm 2.00
Thu 22.03.18 05:30pm 07:30pm 2.00
Thu 29.03.18 05:30pm 07:30pm 2.00
Thu 12.04.18 05:30pm 07:30pm 2.00
Thu 19.04.18 05:30pm 07:30pm 2.00

Tuesday 01 May 2018

  • Code S650194
  • Start date 01.05.18
  • End date 19.06.18
  • Hours 16.00
  • Campus RMIT City
  • Fee $800.00
Enrol now
Session  Start  End Hours
Tue 01.05.18 05:30pm 07:30pm 2.00
Tue 08.05.18 05:30pm 07:30pm 2.00
Tue 15.05.18 05:30pm 07:30pm 2.00
Tue 22.05.18 05:30pm 07:30pm 2.00
Tue 29.05.18 05:30pm 07:30pm 2.00
Tue 05.06.18 05:30pm 07:30pm 2.00
Tue 12.06.18 05:30pm 07:30pm 2.00
Tue 19.06.18 05:30pm 07:30pm 2.00

Thursday 03 May 2018

  • Code S650194
  • Start date 03.05.18
  • End date 21.06.18
  • Hours 16.00
  • Campus RMIT City
  • Fee $800.00
Enrol now
Session  Start  End Hours
Thu 03.05.18 05:30pm 07:30pm 2.00
Thu 10.05.18 05:30pm 07:30pm 2.00
Thu 17.05.18 05:30pm 07:30pm 2.00
Thu 24.05.18 05:30pm 07:30pm 2.00
Thu 31.05.18 05:30pm 07:30pm 2.00
Thu 07.06.18 05:30pm 07:30pm 2.00
Thu 14.06.18 05:30pm 07:30pm 2.00
Thu 21.06.18 05:30pm 07:30pm 2.00

Tuesday 03 July 2018

  • Code S650194
  • Start date 03.07.18
  • End date 21.08.18
  • Hours 16.00
  • Campus RMIT City
  • Fee $800.00
Enrol now
Session  Start  End Hours
Tue 03.07.18 05:30pm 07:30pm 2.00
Tue 10.07.18 05:30pm 07:30pm 2.00
Tue 17.07.18 05:30pm 07:30pm 2.00
Tue 24.07.18 05:30pm 07:30pm 2.00
Tue 31.07.18 05:30pm 07:30pm 2.00
Tue 07.08.18 05:30pm 07:30pm 2.00
Tue 14.08.18 05:30pm 07:30pm 2.00
Tue 21.08.18 05:30pm 07:30pm 2.00

Thursday 05 July 2018

  • Code S650194
  • Start date 05.07.18
  • End date 23.08.18
  • Hours 16.00
  • Campus RMIT City
  • Fee $800.00
Enrol now
Session  Start  End Hours
Thu 05.07.18 05:30pm 07:30pm 2.00
Thu 12.07.18 05:30pm 07:30pm 2.00
Thu 19.07.18 05:30pm 07:30pm 2.00
Thu 26.07.18 05:30pm 07:30pm 2.00
Thu 02.08.18 05:30pm 07:30pm 2.00
Thu 09.08.18 05:30pm 07:30pm 2.00
Thu 16.08.18 05:30pm 07:30pm 2.00
Thu 23.08.18 05:30pm 07:30pm 2.00

Tuesday 04 September 2018

  • Code S650194
  • Start date 04.09.18
  • End date 23.10.18
  • Hours 16.00
  • Campus RMIT City
  • Fee $800.00
Enrol now
Session  Start  End Hours
Tue 04.09.18 05:30pm 07:30pm 2.00
Tue 11.09.18 05:30pm 07:30pm 2.00
Tue 18.09.18 05:30pm 07:30pm 2.00
Tue 25.09.18 05:30pm 07:30pm 2.00
Tue 02.10.18 05:30pm 07:30pm 2.00
Tue 09.10.18 05:30pm 07:30pm 2.00
Tue 16.10.18 05:30pm 07:30pm 2.00
Tue 23.10.18 05:30pm 07:30pm 2.00

Thursday 06 September 2018

  • Code S650194
  • Start date 06.09.18
  • End date 25.10.18
  • Hours 16.00
  • Campus RMIT City
  • Fee $800.00
Enrol now
Session  Start  End Hours
Thu 06.09.18 05:30pm 07:30pm 2.00
Thu 13.09.18 05:30pm 07:30pm 2.00
Thu 20.09.18 05:30pm 07:30pm 2.00
Thu 27.09.18 05:30pm 07:30pm 2.00
Thu 04.10.18 05:30pm 07:30pm 2.00
Thu 11.10.18 05:30pm 07:30pm 2.00
Thu 18.10.18 05:30pm 07:30pm 2.00
Thu 25.10.18 05:30pm 07:30pm 2.00

Learn more

Share