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

Fall 2021

Evening Sessions

Nov 23 - Feb 01Tue

Tuesday, Nov 23 - Tuesday, Feb 01

DayTimeRoom Number
Tuesday18:00 - 21:00VIR-Non-CR
Register Now

Additional Information

Teacher: Jonathan Perlman
Course Number: 922049
Registration Start Date: Monday, Aug 16, 2021
Group Schedule Info: No class December 21, 28 & January 4th.
Maximum Class Size: 12
Total Hours: 24
Status: Registration in progress
Consult the complete course offering at montezdeniveau.ca

Return to all Emploi Quebec courses


Other Categories

Last Modified: September 15, 2021