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