Total Training Microsoft SQL Server Development

Total Training for Microsoft SQL Server Development get deeper into the latest, coolest, and most powerful database software platform, Microsoft's SQL Server 2005. The tutorials focus on key elements in a logical sequence. You can easily find what you need-including all the SQL Server 2005 basics, best practices, dozens of targeted examples, and sample code. If you design or develop SQL Server 2005 databases, this video series is what you need to succeed.

Key Features:

* Create triggers to build custom audit trails and enforce database rules;
* Master the fundamentals of SQL Server technology;
* Learn how to write better queries to return the exact data required;
* Develop stored procedures using T-SQL;
* Avoid slow iterative code by refactoring cursors into queries using user-defined functions and case expressions;
* Understand how transactions affect performance, how to detect blocking transactions, and how to minimize the impact of locking and blocking.

Course Outline:

PART 1: Introduction to SQL Server 2005

Chapter 1: SQL SERVER OVERVIEW
1. Understanding Client Server Architecture;
2. Introducing the Tools;
3. Selecting an Edition;
4. Creating Sample Databases.

Chapter 2: USING MANAGEMENT STUDIO
1. Arranging the Workspace;
2. Registering Servers;
3. Explaining Items in the Object Explorer;
4. Explaining the Database Properties Dialog;
5. Explaining the Columns Properties Dialog;
6. Continuing with Object Explorer Items;
7. Using the Query Editor.

Chapter 3: DESIGNING RELATIONAL DATABASES
1. Understanding Normalization;
2. Discovering Patterns;
3. Avoiding Over Complexity;
4. Managing Optional Data;
5. Creating Physical Keys
6. Using the Database Diagrammer Tool;
7. Final Comments.

PART 2: Selecting Data

Chapter 1: WORKING WITH SINGLE TABLE QUERIES
1. Understanding Query Flow;
2. Filtering Data with the Where Clause;
3. Columns, Expressions & Scalar Functions;
4. Using Case Expressions;
5. Working with Nulls & Coalesce;
6. Selecting Environment Functions;
7. Working with Dates & Times;
8. Parsing Strings;
9. Converting Data;
10. Sorting Data;
11. Topping Off the Query with Predicates.

Chapter 2: MERGING DATA WITH JOINS & UNIONS
1. Working with Inner Joins;
2. Using Left Outer Joins;
3. Multiplying Data with Cross Joins;
4. Referencing Self-Joins;
5. Working with Complex Joins;
6. Finding the Set Difference;
7. Stacking Data with Unions.

Chapter 3: WORKING WITH SUBQUERIES
1. Using Subqueries as Expressions;
2. Including Subqueries as Lists;
3. Adding Subqueries as Derived Tables;
4. Working with Correlated Subqueries;
5. Solving for X with Relations Division;

Chapter 4: AGGREGATING DATA
1. Using the New Windowing Functions;
2. Using Aggregate Functions;
3. Grouping a Data Set;
4. Nesting Aggregations;
5. Filtering Groups & Adding Grand Totals;
6. Generating Cross Tab Tables (Pivot);
7. Calculating Cumulative Sums.

Chapter 5: USING FULL-TEXT SEARCH
1. Creating a Full-Text Index;
2. Searching for Words;
3. Using a Fuzzy Search to Search for Phrases.

Chapter 6: SELECTING DATA THROUGH VIEWS
1. Creating Views;
2. Preventing Disappearing Rows;
3. Protecting from Schema Changes;
4. Nesting Views.

Chapter 7: DISTRIBUTED QUERIES
1. Linking to External Data Sources;
2. Executing Distributed Queries;
3. Looking at Where the Work Takes Place;
4. Using Pass Through Queries;
5. Controlling Distributed Transactions.

Chapter 8: MODIFYING DATA
1. Inserting Data;
2. Updating Data;
3. Deleting Data;
4. Using the Output Clause;
5. Final Comments & Credits.