| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/hell.nfo |
3 KB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 1 SQL SERVER OVERVIEW(32 min)/0. Introduction.mov |
6.9 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 1 SQL SERVER OVERVIEW(32 min)/1. Understanding Client Server Architecture.mov |
20.7 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 1 SQL SERVER OVERVIEW(32 min)/2. Introducing the Tools.mov |
18.8 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 1 SQL SERVER OVERVIEW(32 min)/3. Selecting an Addition.mov |
15.5 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 1 SQL SERVER OVERVIEW(32 min)/4. Creating Sample Databases.mov |
19.8 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 10 DISTRIBUTED QUERIES (18 min)/0. Introduction.mov |
2.8 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 10 DISTRIBUTED QUERIES (18 min)/1. Linking to External Data Sources.mov |
12.8 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 10 DISTRIBUTED QUERIES (18 min)/2. Executing Distributed Queries.wmv |
9.8 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 10 DISTRIBUTED QUERIES (18 min)/3. Looking at Where the Work Takes Place.mov |
6 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 10 DISTRIBUTED QUERIES (18 min)/4. Using Pass Through Queries.mov |
6.6 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 10 DISTRIBUTED QUERIES (18 min)/5. Controlling Distributed Transactions.mov |
8.2 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 11 MODIFYING DATA (29 min)/0.Introduction.mov |
2.8 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 11 MODIFYING DATA (29 min)/1. Inserting Data.mov |
27.8 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 11 MODIFYING DATA (29 min)/2. Updating Data.mov |
15.4 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 11 MODIFYING DATA (29 min)/3. Deleting Data.mov |
11 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 11 MODIFYING DATA (29 min)/4. Using the Output Clause.mov |
8.9 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 11 MODIFYING DATA (29 min)/5. Final Comments & Credits.mov |
10.2 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 12 T-SQL & STORED PROCEDURES (68 min)/0. Introduction.wmv |
2.7 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 12 T-SQL & STORED PROCEDURES (68 min)/1. Introducing T-SQL.wmv |
5.1 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 12 T-SQL & STORED PROCEDURES (68 min)/10. Working with a Cursor.wmv |
8.6 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 12 T-SQL & STORED PROCEDURES (68 min)/11. Handling Errors.wmv |
10.5 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 12 T-SQL & STORED PROCEDURES (68 min)/12. Explaining the Raise Error.wmv |
8.7 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 12 T-SQL & STORED PROCEDURES (68 min)/13. Controlling Transactions.wmv |
5.5 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 12 T-SQL & STORED PROCEDURES (68 min)/2. Working with Variables.wmv |
11.8 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 12 T-SQL & STORED PROCEDURES (68 min)/3. Controlling Procedural Flow.wmv |
7 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 12 T-SQL & STORED PROCEDURES (68 min)/4. Examining SQL Server with Code.wmv |
5.1 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 12 T-SQL & STORED PROCEDURES (68 min)/5. Using Temp Tables.wmv |
12.4 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 12 T-SQL & STORED PROCEDURES (68 min)/6. Developing Dynamic SQL.wmv |
9.8 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 12 T-SQL & STORED PROCEDURES (68 min)/7. Introducing Stored Procedures.wmv |
8.5 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 12 T-SQL & STORED PROCEDURES (68 min)/8. Passing Parameters.wmv |
5.8 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 12 T-SQL & STORED PROCEDURES (68 min)/9. Returning Parameters.wmv |
9.9 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 13 TRIGGERS & AUDIT TRAILS (31 min)/0. Introduction.wmv |
2 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 13 TRIGGERS & AUDIT TRAILS (31 min)/1. Introducing After Triggers.wmv |
4.9 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 13 TRIGGERS & AUDIT TRAILS (31 min)/2. Using Instead of Trigger.wmv |
7.3 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 13 TRIGGERS & AUDIT TRAILS (31 min)/3. Disabling Triggers.wmv |
2.6 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 13 TRIGGERS & AUDIT TRAILS (31 min)/4. Using the Update ( ) Function.wmv |
2.2 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 13 TRIGGERS & AUDIT TRAILS (31 min)/5. Selecting Transaction Data.wmv |
5 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 13 TRIGGERS & AUDIT TRAILS (31 min)/6. Nesting & Recursion.wmv |
7.9 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 13 TRIGGERS & AUDIT TRAILS (31 min)/7. Enforcing Complex RI.wmv |
6.1 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 13 TRIGGERS & AUDIT TRAILS (31 min)/8. Auditing Data Changes.wmv |
17.3 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 14 USER-DEFINED FUNCTIONS (27 min)/0. Introduction.wmv |
1.9 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 14 USER-DEFINED FUNCTIONS (27 min)/1. Creating Scalar Functions.wmv |
8.1 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 14 USER-DEFINED FUNCTIONS (27 min)/2. Working with Inline Table-Valued Functions.wmv |
6.8 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 14 USER-DEFINED FUNCTIONS (27 min)/3. Using Multi-Statement Table-Valued UDFs.wmv |
3.7 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 14 USER-DEFINED FUNCTIONS (27 min)/4. Navigating a Hierarchy.wmv |
13 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 14 USER-DEFINED FUNCTIONS (27 min)/5. Having Fun with Apply.wmv |
4.4 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 14 USER-DEFINED FUNCTIONS (27 min)/6. Exploring Functions in Nordic.wmv |
8.3 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 15 INDEXING FOR PERFORMANCE (31 min)/0. Introduction.wmv |
2.2 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 15 INDEXING FOR PERFORMANCE (31 min)/1. Introducing Indexes.wmv |
4.1 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 15 INDEXING FOR PERFORMANCE (31 min)/2. Creating Indexes.wmv |
14.3 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 15 INDEXING FOR PERFORMANCE (31 min)/3. Examinging Query Execution Plans, Pt. 1.wmv |
12 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 15 INDEXING FOR PERFORMANCE (31 min)/4. Examinging Query Execution Plans, Pt. 2.wmv |
12.7 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 16 TRANSACTIONS, LOCKING & BLOCKING (33 min)/0 Introduction.wmv |
1.4 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 16 TRANSACTIONS, LOCKING & BLOCKING (33 min)/1. Introducing ACID.wmv |
2 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 16 TRANSACTIONS, LOCKING & BLOCKING (33 min)/2. Understanding Transactional Faults.mov |
19.9 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 16 TRANSACTIONS, LOCKING & BLOCKING (33 min)/3. Stepping through a Transaction.wmv |
3.1 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 16 TRANSACTIONS, LOCKING & BLOCKING (33 min)/4. Exploring Locks.wmv |
4.6 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 16 TRANSACTIONS, LOCKING & BLOCKING (33 min)/5. Working with Locks.mov |
10.9 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 16 TRANSACTIONS, LOCKING & BLOCKING (33 min)/6. Viewing Deadlocks.mov |
13.9 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 16 TRANSACTIONS, LOCKING & BLOCKING (33 min)/7. Using Snapshot Isolation.mov |
9.4 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 17 INTRODUCTION TO OPTIMIZATION THEORY (21 min)/0. Introduction.wmv |
1.1 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 17 INTRODUCTION TO OPTIMIZATION THEORY (21 min)/1. Deconstructing the Database System.mov |
5.2 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 17 INTRODUCTION TO OPTIMIZATION THEORY (21 min)/2. Walking through Optimization Theory.mov |
17.5 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 17 INTRODUCTION TO OPTIMIZATION THEORY (21 min)/3. Optimization Theory Continued.mov |
16.2 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 17 INTRODUCTION TO OPTIMIZATION THEORY (21 min)/4. Final Comments & Credits.mov |
9.9 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 2 USING MANAGEMENT STUDIO(23 min)/0. Introduction.mov |
1.8 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 2 USING MANAGEMENT STUDIO(23 min)/1. Arranging the Workspace.mov |
4.9 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 2 USING MANAGEMENT STUDIO(23 min)/2. Registering Servers.mov |
5.7 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 2 USING MANAGEMENT STUDIO(23 min)/3. Explaining Items in the Object Explorer.mov |
12.2 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 2 USING MANAGEMENT STUDIO(23 min)/4. Explaining the Database Properties Dialog.mov |
13.4 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 2 USING MANAGEMENT STUDIO(23 min)/5. Explaining the Columns Properties Dialog.mov |
7.5 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 2 USING MANAGEMENT STUDIO(23 min)/6. Continuing with Object Explorer Items.mov |
4.4 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 2 USING MANAGEMENT STUDIO(23 min)/7. Using the Query Editor.mov |
13 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 3 DESIGNING RELATIONAL DATABASES(35 min)/0. Introduction.mov |
2.3 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 3 DESIGNING RELATIONAL DATABASES(35 min)/1. Understanding Normalization.mov |
6.4 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 3 DESIGNING RELATIONAL DATABASES(35 min)/2. Discovering Patterns.mov |
22.1 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 3 DESIGNING RELATIONAL DATABASES(35 min)/3. Avoiding Over Complexity.mov |
14.7 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 3 DESIGNING RELATIONAL DATABASES(35 min)/4. Managing Optional Data.mov |
12.2 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 3 DESIGNING RELATIONAL DATABASES(35 min)/5. Creating Physical Keys.mov |
13 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 3 DESIGNING RELATIONAL DATABASES(35 min)/6. Using the Database Diagrammer Tool.mov |
12.5 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 3 DESIGNING RELATIONAL DATABASES(35 min)/7. Final Comments.mov |
1.8 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 4 WORKING WITH SINGLE TABLE QUERIES(42 min)/1. Understanding Query Flow.wmv |
8.6 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 4 WORKING WITH SINGLE TABLE QUERIES(42 min)/10. Sorting Data.wmv |
4 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 4 WORKING WITH SINGLE TABLE QUERIES(42 min)/11. Topping Off the Query with Predicates.wmv |
5.9 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 4 WORKING WITH SINGLE TABLE QUERIES(42 min)/2. Filtering Data with the Where Clause.wmv |
10.8 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 4 WORKING WITH SINGLE TABLE QUERIES(42 min)/3. Columns, Expressions & Scalar Functions.wmv |
3.7 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 4 WORKING WITH SINGLE TABLE QUERIES(42 min)/4. Using Case Expressions.wmv |
8.3 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 4 WORKING WITH SINGLE TABLE QUERIES(42 min)/5. Working with Nulls & Coalesce.wmv |
6 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 4 WORKING WITH SINGLE TABLE QUERIES(42 min)/6. Selecting Environment Functions.wmv |
1.9 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 4 WORKING WITH SINGLE TABLE QUERIES(42 min)/7. Working with Dates & Times.wmv |
8 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 4 WORKING WITH SINGLE TABLE QUERIES(42 min)/8. Parsing Strings.wmv |
4 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 4 WORKING WITH SINGLE TABLE QUERIES(42 min)/9. Converting Data.wmv |
3.6 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 5 MERGING DATA WITH JOINS & UNIONS(25 min)/0. Introduction.mov |
2 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 5 MERGING DATA WITH JOINS & UNIONS(25 min)/1. Working with Inner Joins.mov |
17.2 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 5 MERGING DATA WITH JOINS & UNIONS(25 min)/2. Using Left Outer Joins.mov |
7.4 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 5 MERGING DATA WITH JOINS & UNIONS(25 min)/3. Multiplying Data with Cross Joins.mov |
6.1 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 5 MERGING DATA WITH JOINS & UNIONS(25 min)/4. Referencing Self-Joins.mov |
9.9 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 5 MERGING DATA WITH JOINS & UNIONS(25 min)/5. Working with Complex Joins.mov |
4.1 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 5 MERGING DATA WITH JOINS & UNIONS(25 min)/6. Finding the Set Difference.mov |
4.8 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 5 MERGING DATA WITH JOINS & UNIONS(25 min)/7. Stacking Data with Unions.mov |
11.4 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 6 WORKING WITH SUBQUERIES (19 min)/0. Introduction.mov |
2.6 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 6 WORKING WITH SUBQUERIES (19 min)/1. Using Subqueries as Expressions.mov |
13.6 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 6 WORKING WITH SUBQUERIES (19 min)/2. Including Subqueries as Lists.mov |
5.3 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 6 WORKING WITH SUBQUERIES (19 min)/3. Adding Subqueries as Derived Tables.mov |
4.5 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 6 WORKING WITH SUBQUERIES (19 min)/4. Working with Correlated Subqueries.mov |
9.8 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 6 WORKING WITH SUBQUERIES (19 min)/5. Solving for X with Relations Division.mov |
13.8 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 7 AGGREGATING DATA (35 min)/0. Introduction.mov |
1.6 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 7 AGGREGATING DATA (35 min)/1. Using the New Windowing Functions.mov |
14.1 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 7 AGGREGATING DATA (35 min)/2. Using Aggregate Functions.mov |
8.7 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 7 AGGREGATING DATA (35 min)/3. Grouping a Data Set.mov |
14.9 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 7 AGGREGATING DATA (35 min)/4. Nesting Aggregations.mov |
7.1 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 7 AGGREGATING DATA (35 min)/5. Filtering Groups & Adding Grand Totals.mov |
11.7 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 7 AGGREGATING DATA (35 min)/6. Generating Cross Tab Tables (Pivot).mov |
19.9 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 7 AGGREGATING DATA (35 min)/7. Calculating Cumulative Sums.mov |
12.3 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 8 USING FULL-TEXT SEARCH (14 min)/0. Introduction.mov |
1.6 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 8 USING FULL-TEXT SEARCH (14 min)/1. Creating a Full-Text Index.mov |
14.8 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 8 USING FULL-TEXT SEARCH (14 min)/2. Searching for Words.mov |
17.3 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 8 USING FULL-TEXT SEARCH (14 min)/3. Using a Fuzzy Search to Search for Phrases.mov |
4.2 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 9 SELECTING DATA THROUGH VIEWS (11 min)/0. Introduction.mov |
1.7 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 9 SELECTING DATA THROUGH VIEWS (11 min)/1. Creating Views.mov |
14.8 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 9 SELECTING DATA THROUGH VIEWS (11 min)/2. Preventing Disappearing Rows.mov |
5 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 9 SELECTING DATA THROUGH VIEWS (11 min)/3. Protecting from Schema Changes.mov |
4 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Lesson 9 SELECTING DATA THROUGH VIEWS (11 min)/4. Nesting Views.mov |
4.9 MB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Project Files - SQL Server 2005/Lesson Scripts/Part 2 - Selecting Data/Lesson 01 - Selecting Data.sql |
10 KB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Project Files - SQL Server 2005/Lesson Scripts/Part 2 - Selecting Data/Lesson 02 - Joins and Unions.sql |
5 KB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Project Files - SQL Server 2005/Lesson Scripts/Part 2 - Selecting Data/Lesson 03 - Subqueries.sql |
10 KB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Project Files - SQL Server 2005/Lesson Scripts/Part 2 - Selecting Data/Lesson 04 - Aggregating Data.sql |
16 KB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Project Files - SQL Server 2005/Lesson Scripts/Part 2 - Selecting Data/Lesson 05 - FullText Search.sql |
4 KB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Project Files - SQL Server 2005/Lesson Scripts/Part 2 - Selecting Data/Lesson 06 - Views.sql |
3 KB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Project Files - SQL Server 2005/Lesson Scripts/Part 2 - Selecting Data/Lesson 07 - Distributed Queries.sql |
4 KB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Project Files - SQL Server 2005/Lesson Scripts/Part 2 - Selecting Data/Lesson 08 - Modifying Data.sql |
8 KB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Project Files - SQL Server 2005/Lesson Scripts/Part 3 - Developing Solutions/Lesson 01 - T-SQL and Stored Procedures.sql |
12 KB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Project Files - SQL Server 2005/Lesson Scripts/Part 3 - Developing Solutions/Lesson 02 - Triggers.sql |
11 KB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Project Files - SQL Server 2005/Lesson Scripts/Part 3 - Developing Solutions/Lesson 03 - User-Defined Functions.sql |
6 KB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Project Files - SQL Server 2005/Lesson Scripts/Part 3 - Developing Solutions/Lesson 04 - Indexing.sql |
793 B |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Project Files - SQL Server 2005/Lesson Scripts/Part 3 - Developing Solutions/Lesson 05 - Transactions, Locking and Blocking.sql |
4 KB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Project Files - SQL Server 2005/Sample Databases/Aesop/Aesop.adp |
22 KB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Project Files - SQL Server 2005/Sample Databases/Aesop/Aesop_Create.sql |
18 KB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Project Files - SQL Server 2005/Sample Databases/CapeHatterasAdventures/CHA1_Customers.mdb |
120 KB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Project Files - SQL Server 2005/Sample Databases/CapeHatterasAdventures/CHA1_Schedule.xls |
24 KB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Project Files - SQL Server 2005/Sample Databases/CapeHatterasAdventures/CHA_Convert.sql |
4 KB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Project Files - SQL Server 2005/Sample Databases/CapeHatterasAdventures/CHA_Create.sql |
7 KB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Project Files - SQL Server 2005/Sample Databases/Family/Family_Create.sql |
10 KB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Project Files - SQL Server 2005/Sample Databases/Family/Family_Queries.sql |
12 KB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Project Files - SQL Server 2005/Sample Databases/Family/Family_UDF.sql |
907 B |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Project Files - SQL Server 2005/Sample Databases/OBXKites/OBXKites_Create.sql |
29 KB |
| TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL/Project Files - SQL Server 2005/Sample Databases/OBXKites/OBXKites_Populate.sql |
19 KB |
Magnet link
