SQL Server 2005 - Introduction

3 day course

In this course, you'll learn about the features that are available in SQL Server 2005, how to design and create a database, how to design and create tables/keys/indexes/relationships, and how to build queries and modify data using Transact-SQL (T-SQL), which is the language of SQL Server and SQL Server Management Studio (SSMS).  You will then learn how to build effective views, stored procedures, triggers, and user-defined functions, using T-SQL and SSMS. You'll also learn about the new enhancements to the T-SQL programming language including improved support for error handling and using .NET languages like C# and Visual Basic to build database objects, such as stored-procedures and functions.

Overview of Course Topics:
(for a full detailed outline, visit our PDF link above)

• Introduction to SQL Server 2005
• Designing and Creating a Database
• Data Selection Queries
• Modifying Data
• SQL Server Management Studio
• Transact SQL Programming
• Database Transactions and Error Handling
• Creating and Working with Views
• Stored Procedures
• User-Defined Functions
• Using .NET Code in SQL Server 2005
• Advanced Query Techniques