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.
- Manage advanced database objects
- Perform error handling
- Develop and implement optimizations
- Perform database index maintenance
- Manage transactions and isolations