SQL – Advanced

register-button24

Return to schedule

 

Course Title SQL – Advanced
Course Number 900-024-EQ
Platform Windows
Duration 24 hours
Gouvernement du Québec fee (taxes incl.)
$48
General Public fee (taxes incl.)
$558.78
Schedule Tuesday 6 p.m. – 10 p.m.
Dates May 15, 22, 29; June 5, 12, 19
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 – BH-214

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
TOP