SQL Server Development Course Content:

1.A Tour of SQL Server 2008

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

2.Installing SQL Server 2008

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

3.Designing and Creating a Database

• Relational Database Design Principles
• Implementing the Design

4.Data Selection Queries

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

5.Modifying Data

• Modifying Data
• Inserting Data
• Updating Data
• Deleting Data
• Understanding Transaction Isolation

6.Working with SQL Server Management Studio

• Getting Started with SSMS
• Exploring the Object Explorer
• Working with the Query Editor

7.Transact-SQL Programming

• Overview of Transact-SQL
• Using Built-In Functions
• Controlling Flow
• Ranking Results

8.Transactions and Error Handling

• Transaction Concepts
• Using TRY/CATCH Error Handling

9.Creating Views, Stored Procedures, Cursors and Triggers

• What Is a View?
• Creating Views
• Creating Stored Procedures
• Creating Cursors
• Creating Triggers

10.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

11.Advanced Query Techniques

• Generating XML with FOR XML
• Using APPLY
• Creating Recursive Queries
• Creating Pivot Queries
• Executing Dynamic SQL

12.Understanding and Implementing Security

• Security Overview
• Authentication
• Authorization
• Permissions

13.Analyzing and Tuning Performance

• Evaluating Performance
• Monitoring with SQL Server Profiler
• Tuning Queries
• Indexes