SQL – Advanced

register-button24

Return to schedule

 

Course Title SQL – Advanced
Course Number 900-024-EQ
Platform Windows
Duration 24 hours
Emploi-Québec fee (taxes incl.)
$48
General Public fee (taxes incl.)
$541.39
Schedule Saturday 9:00 a.m. – 5:30 p.m.
Lunch 30 mins.
Dates October 28, November 4, 11
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-408

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