SQL Server DB Training

Introduction

Overview,

Understanding Client Server Architecture,

Introducing the Tools,

Selecting an Edition,

Creating Sample Databases

DESIGNING RELATIONAL DB

Understanding Normalization, v

Discovering Patterns,

Avoiding Over Complexity,

Managing Optional Data,

Creating Physical Keys,

Using the Database Diag Tool,

Di Final Comments

WORKING WITH QUERIES

Understanding Query Flow,

Filtering Data with the Where Clause Columns,

Expressions & Scalar Functions.

Using Case Expressions

Working with Nulls & Coalesce.,

Selecting Environment Functions,

Working with Dates & Times, v

Parsing Strings,

Converting Data and Sorting Data,

Topping Off the Query with Predicates

MODIFYING DATA

Insert, Update and Delete Data,

Using the Output Clause,

Final Comments & Credits

STORED PROCEDURES

Introducing Stored Procedures,

Passing Parameters,

Returning Parameters,

Working with a Cursor,

Handling Errors,

Explaining the Raise Error,

Controlling Transactions

TRIGGERS

Introducing After Triggers,

Using "Instead of" Trigger,

Disabling Triggers, v

Using the Update ( ) Function,

Selecting Transaction Data,

Nesting & Recursion, v

Enforcing Complex RI,

Auditing Data Changes

INDEX

Introducing Indexes,

Creating Indexes,

TRANSACTIONS

Introducing ACID,

Transactional Faults,

Stepping through a Transaction,

Exploring Locks,

Working with Locks & Viewing,

Using Snapshot Isolation

OPTIMIZATION THEORY

Deconstructing the Database System,

Walk thro.. Optimization Theory,

Optimization Theory Continued,

Final Comments & Credits

Reliability and availability

Database backup & Restore,

Log shipping,

Database snapshots ,

Mirrored databases

Applications

Service Broker,

HTTP endpoints

SQL Server 2008 Installation & Features

Installing SQL Server, Essential Tools

Creating & Managing Databases

Storage Structures, Managing Database Space, Moving Databases

Implementing Server & Database Security

Creating Logins, Authorising Database Access

Managing Permissions

Granting Database-Scoped Privileges, Schemas, Handling Object-Level Permissions

Recovering From Disasters

Backingup Databases, Restoring Databases

Automating Tasks with Jobs & Alerts

The SQL Server Agent, Multistep Jobs

Performing Database Maintenanace

Fragmentation & Database Corruption, Database Maintenance Plan Wizard

Monitoring SQL Server

Ad hoc Monitoring, The Management Data Warehouse