2778.  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.

In this course, you will

• Understand basic database design principles and how to implement them in SQL Server.
• Learn the fundamentals of writing Transact-SQL queries that retrieve or modify data.
• Understand the differences between view, stored procedures, triggers, and user-defined functions.
• Use the new Common Table Expressions for creating hierarchical queries.
• Perform calculations with Visual Basic and Visual C# code rather than T-SQL.

This course is designed for database developers and SQL Server administrators who need to understand Transact-SQL. 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.