Microsoft SQL Server 2008 for Developers Course

Topics covered on the 5 day Microsoft SQL Server 2008 for Developers course

A Tour of SQL Server 2008

• SQL Server 2008 Editions, Components, and Tools
• Using SQL Server Management Studio (SSMS)
• Working with Tables, Queries, and Views
• Business Intelligence Services

Installing SQL Server 2008

• Preparing for Installation
• Upgrading an Earlier Version
• Installation Steps
• Configuring the Server

Designing and Creating a Database

• Relational Database Design Principles
• Implementing the Design
• Create a SQL Server Database
• Create SQL Server Tables
• Creating Relationships Using a Database Diagram

Data Selection

• Understanding Transact-SQL
• The SELECT Statement
• The WHERE Clause
• Using ORDER BY to Sort Data
• The GROUP BY Clause
• Joining Tables

Modifying Data

• Modifying DAta with Transact-SQL
• Inserting Data
• Updating Data
• Understanding Transaction Isolation

Working with SQL Server Management Studio

• Getting Started with Management Studio
• Exploring the Object Explorer
• Working with the Query Editor
• Using SQL Server Books Online

Transact-SQL Programming

• Overview of Transact-SQL
• Using Built-In Functions
• Using Control of Flow Constructs

Understanding and Implementing Security

• Security Overview
• Authentication
• Authorization
• Data Encryption
• Security Epilog

Creating Views

• What Is a View?
• Creating Views
• Updating Data Using a View
• Using Computed Columns
• Indexed Views
• Partitioned Views

Creating Stored Procedures and Triggers

• Creating Stored Procedures
• Creating Triggers

Creating User-Defined Functions

• User-Defined Function Overview
• Scalar Functions
• Inline Table-Valued Functions
• Multi-Statement Table-Valued Functions
• Using Functions, Views, and Stored Procedures

Transactions and Error Handling

• Transaction Concepts
• Applications and Transactions
• Creating Explicit Transactions
• Using TRY/CATCH Error Handling

Using .NET Code in SQL Server

• Introduction
• Writing SQLCLR Code
• SQLCLR Code Modules
• SQLCLR Security
• T-SQL vs. .NET Code

Advanced SQLCLR Code Techniques

• Advanced SQLCLR Code Modules
• Managing Code Modules

Advanced Query Techniques

• Full-Text Search
• Advanced T-SQL Techniques
• Executing Dynamic SQL

Advanced Data Types

• Introduction
• The HierarchyID Data Type
• Sparse Columns and Column Sets
• FILESTREAM Storage
• Spatial Data

Implementing Partitions

• SQL Server Partitions
• Creating Partitioned Tables
• Querying Partitions
• Managing Partitions

Complex Querying

• Complex Queries
• Ranking
• Correlated SubQueries
• Common Table Expressions

Advanced Techniques

• Complex Data and Structures
• Efficient Queries
• Working with Complex Queries
• Maintaining Query Files

Design and Deployment with Visual Studio

• Team System for Database Professionals
• Creating Databases and Managing Projects
• Database and Project Management

Working with XML

• XML Data Type
• XML Schema Collections
• Querying XML
• Best Practices

Business Intelligence Services

• Introduction to Business Intelligence Services
• Using Integration Services
• Using Analysis Services
• Using Reporting Services