|
Think since you already know SQL Server 2000 there’s no reason to attend a 2005 training class? Think again! SQL Server 2005 includes a wide assortment of new features and functionality totally outside of anything you might have experienced previously. This 2-day, hands-on course focuses exclusively on the NEW stuff. It does not waste any time covering topics that are common to SQL Server 2000.
This course is intended for software developers with existing experience with SQL Server 2000. The course assumes the student is already comfortable with creating databases, tables and views, developing stored procedures and other common database tasks.
Course Outline
1. A Tour of SQL Server 2005
SQL Server 2005 is a very large and complex product. The course begins with an overview of the features available in each edition, focusing on topics of interest to developers.
2. Working with SQL Server Management Studio
A single integrated development environment called SQL Server Management Studio has replaced what used to be accomplished in numerous separate tools. Every developer has to master this environment to make productive use of SQL Server features.
3. Using .NET Code in SQL Server 2005
In addition to the Transact-SQL programming language, SQL Server now supports creating stored procedures, functions, types and aggregations in any .NET language, including C# and VB.NET. Developers should know when this option makes sense and when it does not, along with knowing how to implement functionality security and efficiently.
4. Advanced Query Techniques
The Transact-SQL language has been extended dramatically to include support for XML, an important new table operator called APPLY, the ability to break down complex queries and perform recursion with Common Table Expressions (CTE), perform PIVOT and UNPIVOT actions, and perform more powerful full-text queries.
5. Understanding and Implementing Security
SQL Server has made very significant changes to the way security works and developers must know how to take advantage of these changes to made database applications more secure while at the same time easy to understand and maintain – a win-win scenario for everyone.
6. Programming Replication
SQL Server makes replication so easy that is has become a reasonable solution for developers to utilize when supporting disconnected/mobile users, remote offices, branch locations and other scenarios.
7. Using Integration Services
SQL Server Integration Services (SSIS) greatly expands on the former Data Transformation Services (DTS) to such an extent that you should ignore what you think you know about DTS and give SSIS a fresh look. SSIS is a comprehensive data import, export, processing and management environment, every bit as powerful and sophisticated as a traditional software development tool.
8. Analysis Services
SQL Server includes a full-featured data warehousing and analytical processing system that would be difficult to even summarize in a two-day class. This module is intended as an overview of how any developer can create Analysis Services cubes and populate them with data, and server as a jumping-off point for further investigation.
9. Reporting Services
SQL Server includes a full-featured reporting system that supports the entire life cycle from creating and testing to deployment, management, user access and caching. As with Analysis Services, this module is intended to show developers how quickly and easily reports can be constructed, deployed and access via a portal.
| 
