Writing Queries Using Microsoft SQL Server 2005 T-SQL

PT5135
Summary
In this course, youll 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.
Prerequisites
Students should have a solid understanding of relational databases. No particular programming experience is required, but the course is taught from a developer's perspective.
Duration
3 Days/Lecture & Lab
Audience
This course is designed for database developers and SQL Server administrators who need to understand Transact-SQL.
Topics
  • A Tour of SQL Server 2005
  • Designing and Creating a Database
  • Data Selection Queries
  • Modifying Data
  • Working with SQL Server Management Studio
  • Transact-SQL Programming
  • Transactions and Error Handling
  • Creating Views
  • Creating Stored Procedures and Triggers
  • Creating User-Defined Functions
  • Using .NET Code in SQL Server 2005
  • Advanced Query Techniques

Related Scheduled Courses