SQL – Advanced


Return to schedule


Course Title SQL – Advanced
Course Number 900-024-EQ-02
Platform Windows
Duration 24 hours
Gouvernement du Québec fee (taxes incl.)
General Public fee (taxes incl.)
Schedule Monday & Wednesday; 6 p.m. – 10 p.m.
Dates February 17, 19, 24, 26; March 2, 4
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 BH-407

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

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