PART 1: Introduction to SQL Server 2005
Lesson 1: SQL SERVER OVERVIEW (32 min)
1. Understanding Client Server Architecture
2. Introducing the Tools
3. Selecting an Addition
4. Creating Sample Databases
Lesson 2: USING MANAGEMENT STUDIO (23 min)
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
Lesson 3: DESIGNING RELATIONAL DATABASES (35 min)
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
Lesson 1: WORKING WITH SINGLE TABLE QUERIES (42 min)
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
Lesson 2: MERGING DATA WITH JOINS & UNIONS (25 min)
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
Lesson 3: WORKING WITH SUBQUERIES (19 min)
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
Lesson 4: AGGREGATING DATA (35 min)
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
Lesson 5: USING FULL-TEXT SEARCH (14 min)
1. Creating a Full-Text Index
2. Searching for Words
3. Using a Fuzzy Search to Search for Phrases
Lesson 6: SELECTING DATA THROUGH VIEWS (11 min)
1. Creating Views
2. Preventing Disappearing Rows
3. Protecting from Schema Changes
4. Nesting Views
Lesson 7: DISTRIBUTED QUERIES (18 min)
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
Lesson 8: MODIFYING DATA (29 min)
1. Inserting Data
2. Updating Data
3. Deleting Data
4. Using the Output Clause
5. Final Comments & Credits
PART 3: Developing Solutions
Lesson 1: T-SQL & STORED PROCEDURES (68 min)
1. Introducing T-SQL
2. Working with Variables
3. Controlling Procedural Flow
4. Examining SQL Server with Code
5. Using Temp Tables
6. Developing Dynamic SQL
7. Introducing Stored Procedures
8. Passing Parameters
9. Returning Parameters
10. Working with a Cursor
11. Handling Errors
12. Explaining the Raise Error
13. Controlling Transactions
Lesson 2: TRIGGERS & AUDIT TRAILS (31 min)
1. Introducing After Triggers
2. Using "Instead of" Trigger
3. Disabling Triggers
4. Using the Update ( ) Function
5. Selecting Transaction Data
6. Nesting & Recursion
7. Enforcing Complex RI
8. Auditing Data Changes
Lesson 3: USER-DEFINED FUNCTIONS (27 min)
1. Creating Scalar Functions
2. Working with Inline Table-Valued Functions
3. Using Multi-Statement Table-Valued UDFs
4. Navigating a Hierarchy
5. Having Fun with Apply
6. Exploring Functions in Nordic
Lesson 4: INDEXING FOR PERFORMANCE (31 min)
1. Introducing Indexes
2. Creating Indexes
3. Examinging Query Execution Plans, Pt. 1
4. Examinging Query Execution Plans, Pt. 2
Lesson 5: TRANSACTIONS, LOCKING & BLOCKING (33 min)
1. Introducing ACID
2. Understanding Transactional Faults
3. Stepping through a Transaction
4. Exploring Locks
5. Working with Locks
6. Viewing Deadlocks
7. Using Snapshot Isolation
Lesson 6: INTRODUCTION TO OPTIMIZATION THEORY (21 min)
1. Deconstructing the Database System
2. Walking through Optimization Theory
3. Optimization Theory Continued
4. Final Comments & Credits
Part1
http://rapidshare.com/files/56345531/TSQL05_P01_C01_L00.wmv
http://rapidshare.com/files/56345603/TSQL05_P01_C01_L01.wmv
http://rapidshare.com/files/56346080/TSQL05_P01_C01_L02.wmv
http://rapidshare.com/files/56346112/TSQL05_P01_C01_L03.wmv
http://rapidshare.com/files/56346160/TSQL05_P01_C01_L04.wmv
http://rapidshare.com/files/56344418/TSQL05_P01_C02_L00.wmv
http://rapidshare.com/files/56344615/TSQL05_P01_C02_L01.wmv
http://rapidshare.com/files/56345282/TSQL05_P01_C02_L02.wmv
http://rapidshare.com/files/56345757/TSQL05_P01_C02_L03.wmv
http://rapidshare.com/files/56345695/TSQL05_P01_C02_L04.wmv
http://rapidshare.com/files/56345307/TSQL05_P01_C02_L05.wmv
http://rapidshare.com/files/56345350/TSQL05_P01_C02_L06.wmv
http://rapidshare.com/files/56345797/TSQL05_P01_C02_L07.wmv
http://rapidshare.com/files/56344297/TSQL05_P01_C03_L00.wmv
http://rapidshare.com/files/56344645/TSQL05_P01_C03_L01.wmv
http://rapidshare.com/files/56346094/TSQL05_P01_C03_L02.wmv
http://rapidshare.com/files/56345708/TSQL05_P01_C03_L03.wmv
http://rapidshare.com/files/56345299/TSQL05_P01_C03_L04.wmv
http://rapidshare.com/files/56345116/TSQL05_P01_C03_L05.wmv
http://rapidshare.com/files/56345871/TSQL05_P01_C03_L06.wmv
http://rapidshare.com/files/56344226/TSQL05_P01_C03_L07.wmv
Part2
http://rapidshare.com/files/56347494/TSQL05_P02_C01_L00.wmv
http://rapidshare.com/files/56350511/TSQL05_P02_C01_L01.wmv
http://rapidshare.com/files/56350997/TSQL05_P02_C01_L02.wmv
http://rapidshare.com/files/56348537/TSQL05_P02_C01_L03.wmv
http://rapidshare.com/files/56350392/TSQL05_P02_C01_L04.wmv
http://rapidshare.com/files/56349477/TSQL05_P02_C01_L05.wmv
http://rapidshare.com/files/56347748/TSQL05_P02_C01_L06.wmv
http://rapidshare.com/files/56350510/TSQL05_P02_C01_L07.wmv
http://rapidshare.com/files/56349263/TSQL05_P02_C01_L08.wmv
http://rapidshare.com/files/56349448/TSQL05_P02_C01_L09.wmv
http://rapidshare.com/files/56348668/TSQL05_P02_C01_L10.wmv
http://rapidshare.com/files/56349540/TSQL05_P02_C01_L11.wmv
http://rapidshare.com/files/56347205/TSQL05_P02_C02_L00.wmv
http://rapidshare.com/files/56351012/TSQL05_P02_C02_L01.wmv
http://rapidshare.com/files/56349147/TSQL05_P02_C02_L02.wmv
http://rapidshare.com/files/56348591/TSQL05_P02_C02_L03.wmv
http://rapidshare.com/files/56350381/TSQL05_P02_C02_L04.wmv
http://rapidshare.com/files/56348847/TSQL05_P02_C02_L05.wmv
http://rapidshare.com/files/56347745/TSQL05_P02_C02_L06.wmv
http://rapidshare.com/files/56350474/TSQL05_P02_C02_L07.wmv
http://rapidshare.com/files/56347117/TSQL05_P02_C03_L00.wmv
http://rapidshare.com/files/56350193/TSQL05_P02_C03_L01.wmv
http://rapidshare.com/files/56348132/TSQL05_P02_C03_L02.wmv
http://rapidshare.com/files/56347704/TSQL05_P02_C03_L03.wmv
http://rapidshare.com/files/56349284/TSQL05_P02_C03_L04.wmv
http://rapidshare.com/files/56350272/TSQL05_P02_C03_L05.wmv
http://rapidshare.com/files/56346792/TSQL05_P02_C04_L00.wmv
http://rapidshare.com/files/56350866/TSQL05_P02_C04_L01.wmv
http://rapidshare.com/files/56349244/TSQL05_P02_C04_L02.wmv
http://rapidshare.com/files/56350855/TSQL05_P02_C04_L03.wmv
http://rapidshare.com/files/56349609/TSQL05_P02_C04_L04.wmv
http://rapidshare.com/files/56350914/TSQL05_P02_C04_L05.wmv
http://rapidshare.com/files/56351212/TSQL05_P02_C04_L06.wmv
http://rapidshare.com/files/56350646/TSQL05_P02_C04_L07.wmv
http://rapidshare.com/files/56347512/TSQL05_P02_C05_L00.wmv
http://rapidshare.com/files/56351020/TSQL05_P02_C05_L01.wmv
http://rapidshare.com/files/56351174/TSQL05_P02_C05_L02.wmv
http://rapidshare.com/files/56348435/TSQL05_P02_C05_L03.wmv
http://rapidshare.com/files/56347686/TSQL05_P02_C06_L00.wmv
http://rapidshare.com/files/56350880/TSQL05_P02_C06_L01.wmv
http://rapidshare.com/files/56349267/TSQL05_P02_C06_L02.wmv
http://rapidshare.com/files/56348695/TSQL05_P02_C06_L03.wmv
http://rapidshare.com/files/56349269/TSQL05_P02_C06_L04.wmv
http://rapidshare.com/files/56348452/TSQL05_P02_C07_L00.wmv
http://rapidshare.com/files/56350807/TSQL05_P02_C07_L01.wmv
http://rapidshare.com/files/56350833/TSQL05_P02_C07_L02.wmv
http://rapidshare.com/files/56349805/TSQL05_P02_C07_L03.wmv
http://rapidshare.com/files/56350286/TSQL05_P02_C07_L04.wmv
http://rapidshare.com/files/56350044/TSQL05_P02_C07_L05.wmv
http://rapidshare.com/files/56348605/TSQL05_P02_C08_L00.wmv
http://rapidshare.com/files/56351312/TSQL05_P02_C08_L01.wmv
http://rapidshare.com/files/56351007/TSQL05_P02_C08_L02.wmv
http://rapidshare.com/files/56350426/TSQL05_P02_C08_L03.wmv
http://rapidshare.com/files/56350132/TSQL05_P02_C08_L04.wmv
http://rapidshare.com/files/56350987/TSQL05_P02_C08_L05.wmv
Part3
http://rapidshare.com/files/56352619/TSQL05_P03_C01_L00.wmv
http://rapidshare.com/files/56354359/TSQL05_P03_C01_L02.wmv
http://rapidshare.com/files/56354110/TSQL05_P03_C01_L03.wmv
http://rapidshare.com/files/56353319/TSQL05_P03_C01_L04.wmv
http://rapidshare.com/files/56354555/TSQL05_P03_C01_L05.wmv
http://rapidshare.com/files/56354232/TSQL05_P03_C01_L06.wmv
http://rapidshare.com/files/56354106/TSQL05_P03_C01_L07.wmv
http://rapidshare.com/files/56354127/TSQL05_P03_C01_L08.wmv
http://rapidshare.com/files/56354582/TSQL05_P03_C01_L09.wmv
http://rapidshare.com/files/56354132/TSQL05_P03_C01_L10.wmv
http://rapidshare.com/files/56354583/TSQL05_P03_C01_L11.wmv
http://rapidshare.com/files/56354124/TSQL05_P03_C01_L12.wmv
http://rapidshare.com/files/56354077/TSQL05_P03_C01_L13.wmv
http://rapidshare.com/files/56353102/TSQL05_P03_C02_L00.wmv
http://rapidshare.com/files/56352910/TSQL05_P03_C02_L01.wmv
http://rapidshare.com/files/56353952/TSQL05_P03_C02_L02.wmv
http://rapidshare.com/files/56352842/TSQL05_P03_C02_L03.wmv
http://rapidshare.com/files/56352233/TSQL05_P03_C02_L04.wmv
http://rapidshare.com/files/56352925/TSQL05_P03_C02_L05.wmv
http://rapidshare.com/files/56354045/TSQL05_P03_C02_L06.wmv
http://rapidshare.com/files/56353245/TSQL05_P03_C02_L07.wmv
http://rapidshare.com/files/56352185/TSQL05_P03_C03_L00.wmv
http://rapidshare.com/files/56353647/TSQL05_P03_C03_L01.wmv
http://rapidshare.com/files/56353444/TSQL05_P03_C03_L02.wmv
http://rapidshare.com/files/56352616/TSQL05_P03_C03_L03.wmv
http://rapidshare.com/files/56354781/TSQL05_P03_C03_L04.wmv
http://rapidshare.com/files/56352812/TSQL05_P03_C03_L05.wmv
http://rapidshare.com/files/56353743/TSQL05_P03_C03_L06.wmv
http://rapidshare.com/files/56352734/TSQL05_P03_C04_L01.wmv
http://rapidshare.com/files/56354622/TSQL05_P03_C04_L02.wmv
http://rapidshare.com/files/56354426/TSQL05_P03_C04_L03.wmv
http://rapidshare.com/files/56354457/TSQL05_P03_C04_L04.wmv
http://rapidshare.com/files/56352838/TSQL05_P03_C05_L01.wmv
http://rapidshare.com/files/56353179/TSQL05_P03_C05_L03.wmv
No comments:
Post a Comment