About this Course
This course builds on the fundamental concepts introduced in Course 1 and provides a strong foundation in the basics of Transact-SQL (T-SQL) programming extensions. You'll learn how to employ scalar and table-valued functions, branching and conditional logic, transactions and concurrency, and more advanced data structures.
What You'll Learn
- How to query and manipulate data using Transact-SQL
- Ways to understand transactions and error handling
- Methods for reading graphical execution plans and look for performance bottlenecks
- How to execute advanced SQL Server programming objects such as triggers, table variables, common table expressions, windowing functions and some tuning techniques
Get Hands-On Experience
- Build efficient data access solutions with SQL Server
- Create modular and reusable code in functions and stored procedures