SQL Server DB

Sql Server Database Learning, Introduction to SQL Server, Overview, Understanding Client Server Architecture, Introducing the Tools, Selecting an Edition, Creating Sample Databases

DESIGNING RELATIONAL DATABASES

Understanding Normalization, Discovering Patterns, Avoiding Over Complexity, Managing Optional Data, Creating Physical Keys, Using the Database Diag Tool, Di Final Comments

WORKING WITH SINGLE TABLE QUERIES

Understanding Query Flow, Filtering Data with the Where ClauseColumns, Expressions & Scalar Functions. Using Case ExpressionsWorking with Nulls & Coalesce., Selecting Environment Functions, Working with Dates & Times, 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, Using the Update ( ) Function, Selecting Transaction Data, Nesting & Recursion, Enforcing Complex RI, Auditing Data Changes

INDEX

Introducing Indexes, Creating Indexes, TRANSACTIONS, LOCKING & BLOCKING, Introducing ACID, Transactional Faults, Stepping through a Transaction, Exploring Locks, Working with Locks & Viewing, Using Snapshot Isolation

INTRODUCTION TO 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