SQL Server Programming, Advanced

Start Date: January 01, 1970 – 12:00 AM (Pacific Time)

End Date: January 01, 1970 – 12:00 AM (Pacific Time)


Download PDF of Course Details

Course Description

In this course, students will learn about advanced techniques in T-SQL programming. Students will understand how procedural objects are created, used, and maintained. Students will learn how data is stored in databases and develop strategies to create indexes for optimizing query performance. Students will be able to code scripts and procedures using multiple Error Handling techniques and Isolation Levels. Additionally, students will be exposed to multiple optimization techniques and execution plans.


Learning Objectives

  • Manage advanced database objects
  • Perform error handling
  • Develop and implement optimizations
  • Perform database index maintenance
  • Manage transactions and isolations