In this course, you will learn how to build basic queries using Transact-SQL, the language of SQL Server. Then, you'll learn how to build effective views, stored procedures, triggers, and user-defined functions, using Transact-SQL. You'll learn about the new enhancements to the Transact-SQL programming language including improved support for error handling and hierarchical queries, and programmers can now use .NET languages like C# and Visual Basic to build database objects.
Target Audience:
This course is designed for database developers and SQL Server administrators who need to understand Transact-SQL.
Pre-requisites:
To get the most out of this course, you should have a solid understanding of relational databases. No particular programming experience is required, but the course is taught from a developer's perspective.
At Course Completion:
After completing this course, students will be able to:
Build queries in Transact-SQL to insert, update, delete, and retrieve data.
Create stored procedures to promote enhanced security and performance.
Take advantage of triggers and user-defined functions.
Utilize SQL server transactions for insure data integrity.
Leverage their .NET programming skills with SQLCLR.
Create highly optimized queries using advanced techniques.
