Microsoft SQL Server 2008 for Developers:

In this course, You will see how the principals of database design are used in creating of databases and then how to apply server tables to them. The course continues with SQL Server Management Studio and how to build effective views, stored procedures, triggers, and user-defined functions using Transact-SQL. Learn how to make your databases more scalable through partitioning and how to use .NET languages like Visual C# and Visual Basic to build database objects.
SQL Server 2008 includes a rich set of tools that go beyond the basics of querying and manipulating data. You will learn how to take advantage of the user-friendly management console that integrates both authoring and administrative tasks. You will learn how to take advantage of SQL Server's tools for analyzing and tuning your databases. You'll also learn about integration servers, implementing security, and Microsoft's new Business Intelligence (BI) suite.

Contents:

Creating Views

1. What Is a View?
2. Creating Views
3. Updating Data Using a View
4. Using Computed Columns
5. Partitioned Views

Creating Stored Procedures and Triggers

1. Creating Stored Procedures
2. Creating Triggers

Creating User-Defined Functions

1. User-Defined Function Overview
2. Scalar Functions
3. Inline Table-Valued Functions
4. Multi-Statement Table-Valued Functions
5. Using Functions, Views, and Stored Procedures
   

Transactions and Error Handling

1. Transaction Concepts
2. Applications and Transactions
3. Creating Explicit Transactions
4. Using TRY/CATCH Error Handling

Using .NET Code in SQL Server

1. Introduction
2. Writing SQLCLR Code
3. SQLCLR Code Modules
4. SQLCLR Security
5. T-SQL vs. .NET Code
   

Advanced SQLCLR Code Techniques

1. Advanced SQLCLR Code Modules
2. Managing Code Modules

Advanced Query Techniques

1. Full-Text Search
2. Advanced T-SQL Techniques
3. Executing Dynamic SQL

Advanced Data Types

1. Introduction
2. The HierarchyID Data Type
3. Sparse Columns and Column Sets
4. FILESTREAM Storage
5. Spatial Data

Implementing Partitions

1. SQL Server Partitions
2. Creating Partitioned Tables
3. Querying Partitions
4. Managing Partitions

Complex Querying

1. Complex Queries
2. Ranking
3. Correlated SubQueries
4. Common Table Expressions

Advanced Techniques

1. Complex Data and Structures
2. Efficient Queries
3. Working with Complex Queries
4. Maintaining Query Files

Design and Deployment with Visual Studio

1. Team System for Database Professionals
2. Creating Databases and Managing Projects
3. Database and Project Management

Working with XML

1. XML Data Type
2. XML Schema Collections
3. Querying XML
4. Best Practices

Business Intelligence Services

1. Introduction to Business Intelligence Services
2. Using Integration Services
3. Using Analysis Services
4. Using Reporting Services