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
Day | Time | Room Number |
---|---|---|
Saturday | 09:30 - 12:30 | VIR-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 |
