SQL – Advanced


Return to schedule


Course Title SQL – Advanced
Course Number 900-024-EQ
Platform Windows
Duration 24 hours
Emploi-Québec fee (taxes incl.)
General Public fee (taxes incl.)
Schedule Saturday Jan.28   13:00-17:30
Saturday Feb.4 & 11   9:00-12:30 & 13:00-17:00
Monday Feb.13   18:00-22:30
Dates TBD
Prerequisites SQL Level 1 and Level 2 or  working knowledge of relational databases
Target Audience Participants interested in acquiring the  knowledge and skills needed to implement a Microsoft SQL Server database
Instructor Khattar Daou
Location Brittain Hall – lab to be determined

NB. This is a non-credit course. Certificate provided for all participants who have completed 80% of course hours

*Textbook: SQL Server 2014 Development Essentials | Basit A. Masood-Al-Farooq | ISBN 978-1-78217-255-0 © 2014 Packt Publishing

Course Description:

In this level, participants will continue to learn advanced techniques for building and designing databases using Microsoft SQL server.

Topics to be covered:

  • Creating views
  • T-SQL view statements
  • Alter views
  • Encrypt views
  • Creating stored procedures
  • Overview of systems stored procedures
  • Create user defined stored procedures
  • Modify and alter stored procedures
  • Create triggers
  • Creating DML triggers
  • Modify triggers
  • Built-in and user defined functions
  • Using built-in SQL server functions
  • Creating user defined functions