EQ SQL (Microsoft Environment) – Advanced

ImportantThis course will be given online using Zoom video conference.There are no in-person classes.

This advanced course will give participants the opportunity to learn advanced techniques for building and designing databases using Microsoft SQL server.

Prerequisite: SQL – Intermediate

Topics Covered in this Course:
• 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

Required Material: 2GB (or higher) Flash (USB) Drive

Course Price: $48.00

Winter 2021

Day Sessions

Mar 27 - May 29Sat

Saturday, Mar 27 - Saturday, May 29

DayTimeRoom Number
Saturday09:30 - 12:30VIR-Non-CR

Additional Information

Teacher: Jonathan Perlman
Course Number: 922049
Registration Start Date: Thursday, Nov 12, 2020
Group Schedule Info: No class April 3rd & May 22nd 2021
Maximum Class Size: 12
Total Hours: 24
Status: Activity in Progress
Consult the complete course offering at

Return to all Emploi Quebec courses

Other Categories

Last Modified: April 20, 2021