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