SQL Server 2005 Boot Camp

5 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 and 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.  You will then learn how to take advantage of the new, user-friendly management console that integrates both authoring and administrative tasks.  You will learn to install, upgrade and configure instances of SQL Server 2005, and how to take advantage of SQL Server's tools for analyzing and tuning your databases. You'll also learn about integration services, implementing security, and Microsoft's new Business Intelligence (BI) suite.

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

• Introduction to SQL Server 2005
• Installing and Configuring 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
• Understanding and Implementing Security
• Analyzing and Tuning Performance
• Automating Administrative Tasks
• Replication
• Integration Services
• Analysis Services
• Introduction to Reporting Services