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

Evening Sessions

Mar 27 - May 29Tue

Saturday, Mar 27 - Saturday, May 29

DayTimeRoom Number
Tuesday18:00 - 21:002F.20
Register Now

Additional Information

Teacher: Jonathan Perlman
Course Number: 922049
Registration Start Date: Thursday, Nov 12, 2020
Group Schedule Info: No class April 4th 2021
Maximum Class Size: 12
Total Hours: 24
Status: Registration in progress
Consult the complete course offering at

Return to all Emploi Quebec courses

Other Categories

Last Modified: January 23, 2021