In this course, you'll learn about the features that are available in SQL Server 2005; how to design and create a database; and 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.

SQL Server 2005 includes a rich set of tools that go beyond the basics of querying and manipulating data. You'll learn how to take advantage of the new, user-friendly management console that integrates both authoring and administrative tasks. You'll learn 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.

At course completion:
Install and configure Microsoft SQL Server 2005.
Understand basic database design principles and how to implement them in SQL Server.
Learn the fundamentals of writing Transact-SQL queries that retrieve or modify data.
Understand the differences between view, stored procedures, triggers, and user-defined functions.
Perform calculations with Visual Basic and Visual C# code rather than T-SQL.
Use the new Common Table Expressions for creating hierarchical queries.
Understand the SQL Server security model.
Configure and tune SQL Server, and monitor database activity.
Support distributed users by implementing SQL Server Replication.
Publish data to the Web, and take advantage of SQL Server's rich support for XML.
Understand Business Intelligence to add reporting and analysis capabilities.

This course will be taught using Microsoft Visual Studio .

The cost of this course is $2,995 Cdn.

This course is designed for developers coming from Visual Studio or other development backgrounds who want to learn to build successful databases solutions with SQL Server 2005. Even developers who've already used Oracle, MySQL, DB2 or other relational database management systems will find this course useful for getting up to speed on SQL Server 2005.

To get the most out of the Microsoft SQL Server 2005 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.