Filename Size hell.nfo 2.8 KB Lesson 1 SQL SERVER OVERVIEW(32 min)/0. Introduction.mov 6.9 MB Lesson 1 SQL SERVER OVERVIEW(32 min)/1. Understanding Client Server Architecture.mov 20.7 MB Lesson 1 SQL SERVER OVERVIEW(32 min)/2. Introducing the Tools.mov 18.8 MB Lesson 1 SQL SERVER OVERVIEW(32 min)/3. Selecting an Addition.mov 15.5 MB Lesson 1 SQL SERVER OVERVIEW(32 min)/4. Creating Sample Databases.mov 19.8 MB Lesson 10 DISTRIBUTED QUERIES (18 min)/0. Introduction.mov 2.8 MB Lesson 10 DISTRIBUTED QUERIES (18 min)/1. Linking to External Data Sources.mov 12.8 MB Lesson 10 DISTRIBUTED QUERIES (18 min)/2. Executing Distributed Queries.wmv 9.8 MB Lesson 10 DISTRIBUTED QUERIES (18 min)/3. Looking at Where the Work Takes Place.mov 6 MB Lesson 10 DISTRIBUTED QUERIES (18 min)/4. Using Pass Through Queries.mov 6.6 MB Lesson 10 DISTRIBUTED QUERIES (18 min)/5. Controlling Distributed Transactions.mov 8.2 MB Lesson 11 MODIFYING DATA (29 min)/0.Introduction.mov 2.8 MB Lesson 11 MODIFYING DATA (29 min)/1. Inserting Data.mov 27.8 MB Lesson 11 MODIFYING DATA (29 min)/2. Updating Data.mov 15.4 MB Lesson 11 MODIFYING DATA (29 min)/3. Deleting Data.mov 11 MB Lesson 11 MODIFYING DATA (29 min)/4. Using the Output Clause.mov 8.9 MB Lesson 11 MODIFYING DATA (29 min)/5. Final Comments & Credits.mov 10.2 MB Lesson 12 T-SQL & STORED PROCEDURES (68 min)/0. Introduction.wmv 2.7 MB Lesson 12 T-SQL & STORED PROCEDURES (68 min)/1. Introducing T-SQL.wmv 5.1 MB Lesson 12 T-SQL & STORED PROCEDURES (68 min)/10. Working with a Cursor.wmv 8.6 MB Lesson 12 T-SQL & STORED PROCEDURES (68 min)/11. Handling Errors.wmv 10.5 MB Lesson 12 T-SQL & STORED PROCEDURES (68 min)/12. Explaining the Raise Error.wmv 8.7 MB Lesson 12 T-SQL & STORED PROCEDURES (68 min)/13. Controlling Transactions.wmv 5.5 MB Lesson 12 T-SQL & STORED PROCEDURES (68 min)/2. Working with Variables.wmv 11.8 MB Lesson 12 T-SQL & STORED PROCEDURES (68 min)/3. Controlling Procedural Flow.wmv 7 MB Lesson 12 T-SQL & STORED PROCEDURES (68 min)/4. Examining SQL Server with Code.wmv 5.1 MB Lesson 12 T-SQL & STORED PROCEDURES (68 min)/5. Using Temp Tables.wmv 12.4 MB Lesson 12 T-SQL & STORED PROCEDURES (68 min)/6. Developing Dynamic SQL.wmv 9.8 MB Lesson 12 T-SQL & STORED PROCEDURES (68 min)/7. Introducing Stored Procedures.wmv 8.5 MB Lesson 12 T-SQL & STORED PROCEDURES (68 min)/8. Passing Parameters.wmv 5.8 MB Lesson 12 T-SQL & STORED PROCEDURES (68 min)/9. Returning Parameters.wmv 9.9 MB Lesson 13 TRIGGERS & AUDIT TRAILS (31 min)/0. Introduction.wmv 2 MB Lesson 13 TRIGGERS & AUDIT TRAILS (31 min)/1. Introducing After Triggers.wmv 4.9 MB Lesson 13 TRIGGERS & AUDIT TRAILS (31 min)/2. Using Instead of Trigger.wmv 7.3 MB Lesson 13 TRIGGERS & AUDIT TRAILS (31 min)/3. Disabling Triggers.wmv 2.6 MB Lesson 13 TRIGGERS & AUDIT TRAILS (31 min)/4. Using the Update ( ) Function.wmv 2.2 MB Lesson 13 TRIGGERS & AUDIT TRAILS (31 min)/5. Selecting Transaction Data.wmv 5 MB Lesson 13 TRIGGERS & AUDIT TRAILS (31 min)/6. Nesting & Recursion.wmv 7.9 MB Lesson 13 TRIGGERS & AUDIT TRAILS (31 min)/7. Enforcing Complex RI.wmv 6.1 MB Lesson 13 TRIGGERS & AUDIT TRAILS (31 min)/8. Auditing Data Changes.wmv 17.3 MB Lesson 14 USER-DEFINED FUNCTIONS (27 min)/0. Introduction.wmv 1.9 MB Lesson 14 USER-DEFINED FUNCTIONS (27 min)/1. Creating Scalar Functions.wmv 8.1 MB Lesson 14 USER-DEFINED FUNCTIONS (27 min)/2. Working with Inline Table-Valued Functions.wmv 6.8 MB Lesson 14 USER-DEFINED FUNCTIONS (27 min)/3. Using Multi-Statement Table-Valued UDFs.wmv 3.7 MB Lesson 14 USER-DEFINED FUNCTIONS (27 min)/4. Navigating a Hierarchy.wmv 13 MB Lesson 14 USER-DEFINED FUNCTIONS (27 min)/5. Having Fun with Apply.wmv 4.4 MB Lesson 14 USER-DEFINED FUNCTIONS (27 min)/6. Exploring Functions in Nordic.wmv 8.3 MB Lesson 15 INDEXING FOR PERFORMANCE (31 min)/0. Introduction.wmv 2.2 MB Lesson 15 INDEXING FOR PERFORMANCE (31 min)/1. Introducing Indexes.wmv 4.1 MB Lesson 15 INDEXING FOR PERFORMANCE (31 min)/2. Creating Indexes.wmv 14.3 MB Lesson 15 INDEXING FOR PERFORMANCE (31 min)/3. Examinging Query Execution Plans, Pt. 1.wmv 12 MB Lesson 15 INDEXING FOR PERFORMANCE (31 min)/4. Examinging Query Execution Plans, Pt. 2.wmv 12.7 MB Lesson 16 TRANSACTIONS, LOCKING & BLOCKING (33 min)/0 Introduction.wmv 1.4 MB Lesson 16 TRANSACTIONS, LOCKING & BLOCKING (33 min)/1. Introducing ACID.wmv 2 MB Lesson 16 TRANSACTIONS, LOCKING & BLOCKING (33 min)/2. Understanding Transactional Faults.mov 19.9 MB Lesson 16 TRANSACTIONS, LOCKING & BLOCKING (33 min)/3. Stepping through a Transaction.wmv 3.1 MB Lesson 16 TRANSACTIONS, LOCKING & BLOCKING (33 min)/4. Exploring Locks.wmv 4.6 MB Lesson 16 TRANSACTIONS, LOCKING & BLOCKING (33 min)/5. Working with Locks.mov 10.9 MB Lesson 16 TRANSACTIONS, LOCKING & BLOCKING (33 min)/6. Viewing Deadlocks.mov 13.9 MB Lesson 16 TRANSACTIONS, LOCKING & BLOCKING (33 min)/7. Using Snapshot Isolation.mov 9.4 MB Lesson 17 INTRODUCTION TO OPTIMIZATION THEORY (21 min)/0. Introduction.wmv 1.1 MB Lesson 17 INTRODUCTION TO OPTIMIZATION THEORY (21 min)/1. Deconstructing the Database System.mov 5.2 MB Lesson 17 INTRODUCTION TO OPTIMIZATION THEORY (21 min)/2. Walking through Optimization Theory.mov 17.5 MB Lesson 17 INTRODUCTION TO OPTIMIZATION THEORY (21 min)/3. Optimization Theory Continued.mov 16.2 MB Lesson 17 INTRODUCTION TO OPTIMIZATION THEORY (21 min)/4. Final Comments & Credits.mov 9.9 MB Lesson 2 USING MANAGEMENT STUDIO(23 min)/0. Introduction.mov 1.8 MB Lesson 2 USING MANAGEMENT STUDIO(23 min)/1. Arranging the Workspace.mov 4.9 MB Lesson 2 USING MANAGEMENT STUDIO(23 min)/2. Registering Servers.mov 5.7 MB Lesson 2 USING MANAGEMENT STUDIO(23 min)/3. Explaining Items in the Object Explorer.mov 12.2 MB Lesson 2 USING MANAGEMENT STUDIO(23 min)/4. Explaining the Database Properties Dialog.mov 13.4 MB Lesson 2 USING MANAGEMENT STUDIO(23 min)/5. Explaining the Columns Properties Dialog.mov 7.5 MB Lesson 2 USING MANAGEMENT STUDIO(23 min)/6. Continuing with Object Explorer Items.mov 4.4 MB Lesson 2 USING MANAGEMENT STUDIO(23 min)/7. Using the Query Editor.mov 13 MB Lesson 3 DESIGNING RELATIONAL DATABASES(35 min)/0. Introduction.mov 2.3 MB Lesson 3 DESIGNING RELATIONAL DATABASES(35 min)/1. Understanding Normalization.mov 6.4 MB Lesson 3 DESIGNING RELATIONAL DATABASES(35 min)/2. Discovering Patterns.mov 22.1 MB Lesson 3 DESIGNING RELATIONAL DATABASES(35 min)/3. Avoiding Over Complexity.mov 14.7 MB Lesson 3 DESIGNING RELATIONAL DATABASES(35 min)/4. Managing Optional Data.mov 12.2 MB Lesson 3 DESIGNING RELATIONAL DATABASES(35 min)/5. Creating Physical Keys.mov 13 MB Lesson 3 DESIGNING RELATIONAL DATABASES(35 min)/6. Using the Database Diagrammer Tool.mov 12.5 MB Lesson 3 DESIGNING RELATIONAL DATABASES(35 min)/7. Final Comments.mov 1.8 MB Lesson 4 WORKING WITH SINGLE TABLE QUERIES(42 min)/1. Understanding Query Flow.wmv 8.6 MB Lesson 4 WORKING WITH SINGLE TABLE QUERIES(42 min)/10. Sorting Data.wmv 4 MB Lesson 4 WORKING WITH SINGLE TABLE QUERIES(42 min)/11. Topping Off the Query with Predicates.wmv 5.9 MB Lesson 4 WORKING WITH SINGLE TABLE QUERIES(42 min)/2. Filtering Data with the Where Clause.wmv 10.8 MB Lesson 4 WORKING WITH SINGLE TABLE QUERIES(42 min)/3. Columns, Expressions & Scalar Functions.wmv 3.7 MB Lesson 4 WORKING WITH SINGLE TABLE QUERIES(42 min)/4. Using Case Expressions.wmv 8.3 MB Lesson 4 WORKING WITH SINGLE TABLE QUERIES(42 min)/5. Working with Nulls & Coalesce.wmv 6 MB Lesson 4 WORKING WITH SINGLE TABLE QUERIES(42 min)/6. Selecting Environment Functions.wmv 1.9 MB Lesson 4 WORKING WITH SINGLE TABLE QUERIES(42 min)/7. Working with Dates & Times.wmv 8 MB Lesson 4 WORKING WITH SINGLE TABLE QUERIES(42 min)/8. Parsing Strings.wmv 4 MB Lesson 4 WORKING WITH SINGLE TABLE QUERIES(42 min)/9. Converting Data.wmv 3.6 MB Lesson 5 MERGING DATA WITH JOINS & UNIONS(25 min)/0. Introduction.mov 2 MB Lesson 5 MERGING DATA WITH JOINS & UNIONS(25 min)/1. Working with Inner Joins.mov 17.2 MB Lesson 5 MERGING DATA WITH JOINS & UNIONS(25 min)/2. Using Left Outer Joins.mov 7.4 MB Lesson 5 MERGING DATA WITH JOINS & UNIONS(25 min)/3. Multiplying Data with Cross Joins.mov 6.1 MB Lesson 5 MERGING DATA WITH JOINS & UNIONS(25 min)/4. Referencing Self-Joins.mov 9.9 MB Lesson 5 MERGING DATA WITH JOINS & UNIONS(25 min)/5. Working with Complex Joins.mov 4.1 MB
