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