EQ SQL (Microsoft Environment) – Advanced
These courses can either be offered Online or In-Person. See course information at registration for more information.
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
Online courses require, Computer with Windows 10 or MacOS X or higher, microphone & headset, high speed internet connection.
Course Price: $54.00
Winter 2023
Evening Sessions
Apr 20 - Jun 15Thu
Thursday, Apr 20 - Thursday, Jun 15
Day | Time | Room Number |
---|---|---|
Thursday | 18:00 - 21:00 | 2F.20 |
Additional Information
Teacher: | Jonathan Perlman |
Course Number: | 922049 |
Registration Start Date: | Monday, Jul 04, 2022 |
Maximum Class Size: | 12 |
Total Hours: | 27 |
Status: | Registration in progress |
