Structured Query Language (SQL)

Duration

15 hours

Mode

Live delivery

Location

Online

Cost

$880

Next Intake

To be determined

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. The database management system used in this course will be Microsoft SQL Server. However, other relational database systems such as Access, MySQL and Oracle may also be discussed. Each week example SQL queries will be demonstrated on screen, and students can run these on their own computers. At the end of each worksheet (each topic) there are exercises for students to work though, either in class or at home.

Course content

  • Introduction to database concepts. Introduction to SQL Server
  • Single-table SQL SELECT queries. GROUP BY statements simple functions
  • Multi-table SQL SELECT queries. Different types of table joins
  • CREATE TABLE queries. INSERT, UPDATE DELETE queries
  • SQL subqueries other advanced queries e.g. UNION queries
  • Types of functions in SQL Server
  • User views in SQL Server. Simple self-joins
  • Introduction to stored procedures. The basics of SQL security.
  • Various other aspects of SQL as required

Timetable

There are currently no dates scheduled for this course. Please contact us or join our mailing list to express your interest in this course.

How to enrol

More details

Prerequisites

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

Materials supplied

All relevant course notes are supplied with comprehensive instructions and exercises in class and online.
Students will be provided with SQL Server software to install into their own desktop or laptop.

Materials to bring

A USB flash drive for transferring and storing files.

Hardware specifications:
For Windows we recommend an i3 or better machine with a minimum 4 GB of RAM

For Macs you will need 8 GB of RAM to run a virtual machine

Suited to

This course is suitable for anyone who is interested in databases. It is specifically designed for students or employees who wish to develop their skills in SQL to intermediate level and beyond.

Additional notes

This is a non-accredited course. Due to COVID 19, this course will be delivered online until further notice.

Outcome

On completion of this course, participants will have good working knowledge of SQL. Participants will work on a variety of small databases in SQL Server and create a number of SQL queries in order to perform useful business functions. Upon finishing the course you will receive a RMIT Certificate of Completion. You can use this as a record to demonstrate the outcomes covered in the course.

Girl at computer in cafe

Sign up to the newsletter

Stay connected with RMIT Short Courses. Hear about special offers, new course dates and stories from our students.

aboriginal flag
torres strait flag

Acknowledgement of country

RMIT University acknowledges the people of the Woi wurrung and Boon wurrung language groups of the eastern Kulin Nation on whose unceded lands we conduct the business of the University. RMIT University respectfully acknowledges their Ancestors and Elders, past and present. RMIT also acknowledges the Traditional Custodians and their Ancestors of the lands and waters across Australia where we conduct our business. - Artwork created by Louisa Bloomer