About us   Registration   Site map    
      New user|Forgot password  
Select Your Country to check the Schedule for this Course
Time Zone:
Course Name Course Code
SQL Server Developer 21
Course Contents

A Tour of SQL Server 2005

· SQL Server 2005 Editions, Components, and Tools

· Using SQL Server Management Studio (SSMS)

· Working with Tables and Queries

· New Transact-SQL Features

· Business Intelligence Services

Installing SQL Server 2005

· Preparing for Installation

· Upgrading an Earlier Version

· Installation Steps

· Configuring the Server

Designing and Creating a Database

· Relational Database Design Principles

· Implementing the Design

Data Selection Queries

· 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

· Inserting Data

· Updating Data

·Deleting Data

· Understanding Transaction Isolation

Working with SQL Server Management Studio

· Getting Started with SSMS

· Exploring the Object Explorer

· Working with the Query Editor 

Transact-SQL Programming

· Overview of Transact-SQL

· Using Built-In Functions

· Controlling Flow

· Ranking Results


Transactions and Error Handling

· Transaction Concepts

· Using TRY/CATCH Error Handling

Creating Views, Stored Procedures, Cursors and Triggers

· What Is a View?

· Creating Views

· Creating Stored Procedures

· Creating Cursors

· 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

Using .NET Code in SQL Server 2005

· Writing SQLCLR Code

· SQLCLR Code Modules

· Managing Code Modules

· T-SQL vs. .NET Code

Advanced Query Techniques

· Generating XML with FOR XML

· Using APPLY

· Creating Recursive Queries

· Creating Pivot Queries

· Executing Dynamic SQL

Understanding and Implementing Security

· Security Overview

· Authentication

· Authorization

· Permissions


Analyzing and Tuning Performance

· Evaluating Performance

· Monitoring with SQL Server Profiler

· Tuning Queries

· Indexes