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 02 July 2019

  • Code S650194
  • Start date 02.07.19
  • End date 30.07.19
  • Hours 15
  • Campus RMIT City
  • Fee $880.00
Enrol now
Session  Start  End Hours
Tue 02.07.19 05:30pm 08:30pm 3.00
Tue 09.07.19 05:30pm 08:30pm 3.00
Tue 16.07.19 05:30pm 08:30pm 3.00
Tue 23.07.19 05:30pm 08:30pm 3.00
Tue 30.07.19 05:30pm 08:30pm 3.00

Thursday 04 July 2019

  • Code S650194
  • Start date 04.07.19
  • End date 01.08.19
  • Hours 15
  • Campus RMIT City
  • Fee $880.00
Enrol now
Session  Start  End Hours
Thu 04.07.19 05:30pm 08:30pm 3.00
Thu 11.07.19 05:30pm 08:30pm 3.00
Thu 18.07.19 05:30pm 08:30pm 3.00
Thu 25.07.19 05:30pm 08:30pm 3.00
Thu 01.08.19 05:30pm 08:30pm 3.00

Tuesday 03 September 2019

  • Code S650194
  • Start date 03.09.19
  • End date 01.10.19
  • Hours 15
  • Campus RMIT City
  • Fee $880.00
Enrol now
Session  Start  End Hours
Tue 03.09.19 05:30pm 08:30pm 3.00
Tue 10.09.19 05:30pm 08:30pm 3.00
Tue 17.09.19 05:30pm 08:30pm 3.00
Tue 24.09.19 05:30pm 08:30pm 3.00
Tue 01.10.19 05:30pm 08:30pm 3.00

Thursday 05 September 2019

  • Code S650194
  • Start date 05.09.19
  • End date 03.10.19
  • Hours 15
  • Campus RMIT City
  • Fee $880.00
Enrol now
Session  Start  End Hours
Thu 05.09.19 05:30pm 08:30pm 3.00
Thu 12.09.19 05:30pm 08:30pm 3.00
Thu 19.09.19 05:30pm 08:30pm 3.00
Thu 26.09.19 05:30pm 08:30pm 3.00
Thu 03.10.19 05:30pm 08:30pm 3.00

Learn more

Share