Loading Course Schedule...
PT5721
Summary
In this course, students will learn how to build basic queries using Transact-SQL, the language of SQL Server. They will also learn how to build effective views, stored procedures, triggers, and user-defined functions, using Transact-SQL. Students will 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
To get the most out of this course, 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. 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.
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
- Creating Views
- Creating Stored Procedures and Triggers
- Creating User-Defined Functions
- Using .NET Code in SQL Server 2005
- Advanced Query Techniques