TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL

资源大小: 1.04 GB
上传日期: 2016-07-29
有关资源: TOTAL   TRAINING   ONLINE   MICROSOFT   SQL   SERVER   DEVELOPMENT   HELL   

文件列表

  • hell.nfo 2.82 KB
  • Lesson 1 SQL SERVER OVERVIEW(32 min)/0. Introduction.mov 6.87 MB
  • Lesson 1 SQL SERVER OVERVIEW(32 min)/1. Understanding Client Server Architecture.mov 20.66 MB
  • Lesson 1 SQL SERVER OVERVIEW(32 min)/2. Introducing the Tools.mov 18.82 MB
  • Lesson 1 SQL SERVER OVERVIEW(32 min)/3. Selecting an Addition.mov 15.54 MB
  • Lesson 1 SQL SERVER OVERVIEW(32 min)/4. Creating Sample Databases.mov 19.80 MB
  • Lesson 10 DISTRIBUTED QUERIES (18 min)/0. Introduction.mov 2.84 MB
  • Lesson 10 DISTRIBUTED QUERIES (18 min)/1. Linking to External Data Sources.mov 12.83 MB
  • Lesson 10 DISTRIBUTED QUERIES (18 min)/2. Executing Distributed Queries.wmv 9.82 MB
  • Lesson 10 DISTRIBUTED QUERIES (18 min)/3. Looking at Where the Work Takes Place.mov 6.04 MB
  • Lesson 10 DISTRIBUTED QUERIES (18 min)/4. Using Pass Through Queries.mov 6.58 MB
  • Lesson 10 DISTRIBUTED QUERIES (18 min)/5. Controlling Distributed Transactions.mov 8.21 MB
  • Lesson 11 MODIFYING DATA (29 min)/0.Introduction.mov 2.80 MB
  • Lesson 11 MODIFYING DATA (29 min)/1. Inserting Data.mov 27.84 MB
  • Lesson 11 MODIFYING DATA (29 min)/2. Updating Data.mov 15.45 MB
  • Lesson 11 MODIFYING DATA (29 min)/3. Deleting Data.mov 11.01 MB
  • Lesson 11 MODIFYING DATA (29 min)/4. Using the Output Clause.mov 8.87 MB
  • Lesson 11 MODIFYING DATA (29 min)/5. Final Comments & Credits.mov 10.24 MB
  • Lesson 12 T-SQL & STORED PROCEDURES (68 min)/0. Introduction.wmv 2.73 MB
  • Lesson 12 T-SQL & STORED PROCEDURES (68 min)/1. Introducing T-SQL.wmv 5.06 MB
  • Lesson 12 T-SQL & STORED PROCEDURES (68 min)/10. Working with a Cursor.wmv 8.61 MB
  • Lesson 12 T-SQL & STORED PROCEDURES (68 min)/11. Handling Errors.wmv 10.52 MB
  • Lesson 12 T-SQL & STORED PROCEDURES (68 min)/12. Explaining the Raise Error.wmv 8.74 MB
  • Lesson 12 T-SQL & STORED PROCEDURES (68 min)/13. Controlling Transactions.wmv 5.46 MB
  • Lesson 12 T-SQL & STORED PROCEDURES (68 min)/2. Working with Variables.wmv 11.83 MB
  • Lesson 12 T-SQL & STORED PROCEDURES (68 min)/3. Controlling Procedural Flow.wmv 7.01 MB
  • Lesson 12 T-SQL & STORED PROCEDURES (68 min)/4. Examining SQL Server with Code.wmv 5.13 MB
  • Lesson 12 T-SQL & STORED PROCEDURES (68 min)/5. Using Temp Tables.wmv 12.45 MB
  • Lesson 12 T-SQL & STORED PROCEDURES (68 min)/6. Developing Dynamic SQL.wmv 9.81 MB
  • Lesson 12 T-SQL & STORED PROCEDURES (68 min)/7. Introducing Stored Procedures.wmv 8.49 MB
  • Lesson 12 T-SQL & STORED PROCEDURES (68 min)/8. Passing Parameters.wmv 5.76 MB
  • Lesson 12 T-SQL & STORED PROCEDURES (68 min)/9. Returning Parameters.wmv 9.94 MB
  • Lesson 13 TRIGGERS & AUDIT TRAILS (31 min)/0. Introduction.wmv 1.96 MB
  • Lesson 13 TRIGGERS & AUDIT TRAILS (31 min)/1. Introducing After Triggers.wmv 4.89 MB
  • Lesson 13 TRIGGERS & AUDIT TRAILS (31 min)/2. Using Instead of Trigger.wmv 7.34 MB
  • Lesson 13 TRIGGERS & AUDIT TRAILS (31 min)/3. Disabling Triggers.wmv 2.64 MB
  • Lesson 13 TRIGGERS & AUDIT TRAILS (31 min)/4. Using the Update ( ) Function.wmv 2.16 MB
  • Lesson 13 TRIGGERS & AUDIT TRAILS (31 min)/5. Selecting Transaction Data.wmv 4.99 MB
  • Lesson 13 TRIGGERS & AUDIT TRAILS (31 min)/6. Nesting & Recursion.wmv 7.90 MB
  • Lesson 13 TRIGGERS & AUDIT TRAILS (31 min)/7. Enforcing Complex RI.wmv 6.14 MB
  • Lesson 13 TRIGGERS & AUDIT TRAILS (31 min)/8. Auditing Data Changes.wmv 17.31 MB
  • Lesson 14 USER-DEFINED FUNCTIONS (27 min)/0. Introduction.wmv 1.91 MB
  • Lesson 14 USER-DEFINED FUNCTIONS (27 min)/1. Creating Scalar Functions.wmv 8.10 MB
  • Lesson 14 USER-DEFINED FUNCTIONS (27 min)/2. Working with Inline Table-Valued Functions.wmv 6.77 MB
  • Lesson 14 USER-DEFINED FUNCTIONS (27 min)/3. Using Multi-Statement Table-Valued UDFs.wmv 3.68 MB
  • Lesson 14 USER-DEFINED FUNCTIONS (27 min)/4. Navigating a Hierarchy.wmv 12.97 MB
  • Lesson 14 USER-DEFINED FUNCTIONS (27 min)/5. Having Fun with Apply.wmv 4.40 MB
  • Lesson 14 USER-DEFINED FUNCTIONS (27 min)/6. Exploring Functions in Nordic.wmv 8.27 MB
  • Lesson 15 INDEXING FOR PERFORMANCE (31 min)/0. Introduction.wmv 2.25 MB
  • Lesson 15 INDEXING FOR PERFORMANCE (31 min)/1. Introducing Indexes.wmv 4.09 MB
  • Lesson 15 INDEXING FOR PERFORMANCE (31 min)/2. Creating Indexes.wmv 14.31 MB
  • Lesson 15 INDEXING FOR PERFORMANCE (31 min)/3. Examinging Query Execution Plans, Pt. 1.wmv 12.01 MB
  • Lesson 15 INDEXING FOR PERFORMANCE (31 min)/4. Examinging Query Execution Plans, Pt. 2.wmv 12.70 MB
  • Lesson 16 TRANSACTIONS, LOCKING & BLOCKING (33 min)/0 Introduction.wmv 1.43 MB
  • Lesson 16 TRANSACTIONS, LOCKING & BLOCKING (33 min)/1. Introducing ACID.wmv 1.98 MB
  • Lesson 16 TRANSACTIONS, LOCKING & BLOCKING (33 min)/2. Understanding Transactional Faults.mov 19.88 MB
  • Lesson 16 TRANSACTIONS, LOCKING & BLOCKING (33 min)/3. Stepping through a Transaction.wmv 3.14 MB
  • Lesson 16 TRANSACTIONS, LOCKING & BLOCKING (33 min)/4. Exploring Locks.wmv 4.60 MB
  • Lesson 16 TRANSACTIONS, LOCKING & BLOCKING (33 min)/5. Working with Locks.mov 10.93 MB
  • Lesson 16 TRANSACTIONS, LOCKING & BLOCKING (33 min)/6. Viewing Deadlocks.mov 13.85 MB
  • Lesson 16 TRANSACTIONS, LOCKING & BLOCKING (33 min)/7. Using Snapshot Isolation.mov 9.44 MB
  • Lesson 17 INTRODUCTION TO OPTIMIZATION THEORY (21 min)/0. Introduction.wmv 1.07 MB
  • Lesson 17 INTRODUCTION TO OPTIMIZATION THEORY (21 min)/1. Deconstructing the Database System.mov 5.16 MB
  • Lesson 17 INTRODUCTION TO OPTIMIZATION THEORY (21 min)/2. Walking through Optimization Theory.mov 17.50 MB
  • Lesson 17 INTRODUCTION TO OPTIMIZATION THEORY (21 min)/3. Optimization Theory Continued.mov 16.18 MB
  • Lesson 17 INTRODUCTION TO OPTIMIZATION THEORY (21 min)/4. Final Comments & Credits.mov 9.91 MB
  • Lesson 2 USING MANAGEMENT STUDIO(23 min)/0. Introduction.mov 1.85 MB
  • Lesson 2 USING MANAGEMENT STUDIO(23 min)/1. Arranging the Workspace.mov 4.90 MB
  • Lesson 2 USING MANAGEMENT STUDIO(23 min)/2. Registering Servers.mov 5.74 MB
  • Lesson 2 USING MANAGEMENT STUDIO(23 min)/3. Explaining Items in the Object Explorer.mov 12.20 MB
  • Lesson 2 USING MANAGEMENT STUDIO(23 min)/4. Explaining the Database Properties Dialog.mov 13.40 MB
  • Lesson 2 USING MANAGEMENT STUDIO(23 min)/5. Explaining the Columns Properties Dialog.mov 7.55 MB
  • Lesson 2 USING MANAGEMENT STUDIO(23 min)/6. Continuing with Object Explorer Items.mov 4.41 MB
  • Lesson 2 USING MANAGEMENT STUDIO(23 min)/7. Using the Query Editor.mov 12.96 MB
  • Lesson 3 DESIGNING RELATIONAL DATABASES(35 min)/0. Introduction.mov 2.26 MB
  • Lesson 3 DESIGNING RELATIONAL DATABASES(35 min)/1. Understanding Normalization.mov 6.38 MB
  • Lesson 3 DESIGNING RELATIONAL DATABASES(35 min)/2. Discovering Patterns.mov 22.15 MB
  • Lesson 3 DESIGNING RELATIONAL DATABASES(35 min)/3. Avoiding Over Complexity.mov 14.67 MB
  • Lesson 3 DESIGNING RELATIONAL DATABASES(35 min)/4. Managing Optional Data.mov 12.25 MB
  • Lesson 3 DESIGNING RELATIONAL DATABASES(35 min)/5. Creating Physical Keys.mov 12.96 MB
  • Lesson 3 DESIGNING RELATIONAL DATABASES(35 min)/6. Using the Database Diagrammer Tool.mov 12.47 MB
  • Lesson 3 DESIGNING RELATIONAL DATABASES(35 min)/7. Final Comments.mov 1.81 MB
  • Lesson 4 WORKING WITH SINGLE TABLE QUERIES(42 min)/1. Understanding Query Flow.wmv 8.63 MB
  • Lesson 4 WORKING WITH SINGLE TABLE QUERIES(42 min)/10. Sorting Data.wmv 3.97 MB
  • Lesson 4 WORKING WITH SINGLE TABLE QUERIES(42 min)/11. Topping Off the Query with Predicates.wmv 5.92 MB
  • Lesson 4 WORKING WITH SINGLE TABLE QUERIES(42 min)/2. Filtering Data with the Where Clause.wmv 10.85 MB
  • Lesson 4 WORKING WITH SINGLE TABLE QUERIES(42 min)/3. Columns, Expressions & Scalar Functions.wmv 3.65 MB
  • Lesson 4 WORKING WITH SINGLE TABLE QUERIES(42 min)/4. Using Case Expressions.wmv 8.33 MB
  • Lesson 4 WORKING WITH SINGLE TABLE QUERIES(42 min)/5. Working with Nulls & Coalesce.wmv 6.05 MB
  • Lesson 4 WORKING WITH SINGLE TABLE QUERIES(42 min)/6. Selecting Environment Functions.wmv 1.93 MB
  • Lesson 4 WORKING WITH SINGLE TABLE QUERIES(42 min)/7. Working with Dates & Times.wmv 7.99 MB
  • Lesson 4 WORKING WITH SINGLE TABLE QUERIES(42 min)/8. Parsing Strings.wmv 3.98 MB
  • Lesson 4 WORKING WITH SINGLE TABLE QUERIES(42 min)/9. Converting Data.wmv 3.65 MB
  • Lesson 5 MERGING DATA WITH JOINS & UNIONS(25 min)/0. Introduction.mov 2.00 MB
  • Lesson 5 MERGING DATA WITH JOINS & UNIONS(25 min)/1. Working with Inner Joins.mov 17.20 MB
  • Lesson 5 MERGING DATA WITH JOINS & UNIONS(25 min)/2. Using Left Outer Joins.mov 7.38 MB
  • Lesson 5 MERGING DATA WITH JOINS & UNIONS(25 min)/3. Multiplying Data with Cross Joins.mov 6.11 MB
  • Lesson 5 MERGING DATA WITH JOINS & UNIONS(25 min)/4. Referencing Self-Joins.mov 9.90 MB
  • Lesson 5 MERGING DATA WITH JOINS & UNIONS(25 min)/5. Working with Complex Joins.mov 4.11 MB
  • Lesson 5 MERGING DATA WITH JOINS & UNIONS(25 min)/6. Finding the Set Difference.mov 4.81 MB
  • Lesson 5 MERGING DATA WITH JOINS & UNIONS(25 min)/7. Stacking Data with Unions.mov 11.39 MB
  • Lesson 6 WORKING WITH SUBQUERIES (19 min)/0. Introduction.mov 2.62 MB
  • Lesson 6 WORKING WITH SUBQUERIES (19 min)/1. Using Subqueries as Expressions.mov 13.57 MB
  • Lesson 6 WORKING WITH SUBQUERIES (19 min)/2. Including Subqueries as Lists.mov 5.32 MB
  • Lesson 6 WORKING WITH SUBQUERIES (19 min)/3. Adding Subqueries as Derived Tables.mov 4.54 MB
  • Lesson 6 WORKING WITH SUBQUERIES (19 min)/4. Working with Correlated Subqueries.mov 9.77 MB
  • Lesson 6 WORKING WITH SUBQUERIES (19 min)/5. Solving for X with Relations Division.mov 13.84 MB
  • Lesson 7 AGGREGATING DATA (35 min)/0. Introduction.mov 1.62 MB
  • Lesson 7 AGGREGATING DATA (35 min)/1. Using the New Windowing Functions.mov 14.06 MB
  • Lesson 7 AGGREGATING DATA (35 min)/2. Using Aggregate Functions.mov 8.70 MB
  • Lesson 7 AGGREGATING DATA (35 min)/3. Grouping a Data Set.mov 14.88 MB
  • Lesson 7 AGGREGATING DATA (35 min)/4. Nesting Aggregations.mov 7.11 MB
  • Lesson 7 AGGREGATING DATA (35 min)/5. Filtering Groups & Adding Grand Totals.mov 11.75 MB
  • Lesson 7 AGGREGATING DATA (35 min)/6. Generating Cross Tab Tables (Pivot).mov 19.87 MB
  • Lesson 7 AGGREGATING DATA (35 min)/7. Calculating Cumulative Sums.mov 12.31 MB
  • Lesson 8 USING FULL-TEXT SEARCH (14 min)/0. Introduction.mov 1.59 MB
  • Lesson 8 USING FULL-TEXT SEARCH (14 min)/1. Creating a Full-Text Index.mov 14.79 MB
  • Lesson 8 USING FULL-TEXT SEARCH (14 min)/2. Searching for Words.mov 17.27 MB
  • Lesson 8 USING FULL-TEXT SEARCH (14 min)/3. Using a Fuzzy Search to Search for Phrases.mov 4.18 MB
  • Lesson 9 SELECTING DATA THROUGH VIEWS (11 min)/0. Introduction.mov 1.69 MB
  • Lesson 9 SELECTING DATA THROUGH VIEWS (11 min)/1. Creating Views.mov 14.76 MB
  • Lesson 9 SELECTING DATA THROUGH VIEWS (11 min)/2. Preventing Disappearing Rows.mov 5.03 MB
  • Lesson 9 SELECTING DATA THROUGH VIEWS (11 min)/3. Protecting from Schema Changes.mov 3.96 MB
  • Lesson 9 SELECTING DATA THROUGH VIEWS (11 min)/4. Nesting Views.mov 4.88 MB
  • Project Files - SQL Server 2005/Lesson Scripts/Part 2 - Selecting Data/Lesson 01 - Selecting Data.sql 9.53 KB
  • Project Files - SQL Server 2005/Lesson Scripts/Part 2 - Selecting Data/Lesson 02 - Joins and Unions.sql 4.82 KB
  • Project Files - SQL Server 2005/Lesson Scripts/Part 2 - Selecting Data/Lesson 03 - Subqueries.sql 9.93 KB
  • Project Files - SQL Server 2005/Lesson Scripts/Part 2 - Selecting Data/Lesson 04 - Aggregating Data.sql 16.33 KB
  • Project Files - SQL Server 2005/Lesson Scripts/Part 2 - Selecting Data/Lesson 05 - FullText Search.sql 3.69 KB
  • Project Files - SQL Server 2005/Lesson Scripts/Part 2 - Selecting Data/Lesson 06 - Views.sql 3.06 KB
  • Project Files - SQL Server 2005/Lesson Scripts/Part 2 - Selecting Data/Lesson 07 - Distributed Queries.sql 4.07 KB
  • Project Files - SQL Server 2005/Lesson Scripts/Part 2 - Selecting Data/Lesson 08 - Modifying Data.sql 8.36 KB
  • Project Files - SQL Server 2005/Lesson Scripts/Part 3 - Developing Solutions/Lesson 01 - T-SQL and Stored Procedures.sql 12.39 KB
  • Project Files - SQL Server 2005/Lesson Scripts/Part 3 - Developing Solutions/Lesson 02 - Triggers.sql 11.48 KB
  • Project Files - SQL Server 2005/Lesson Scripts/Part 3 - Developing Solutions/Lesson 03 - User-Defined Functions.sql 6.16 KB
  • Project Files - SQL Server 2005/Lesson Scripts/Part 3 - Developing Solutions/Lesson 04 - Indexing.sql 793 bytes
  • Project Files - SQL Server 2005/Lesson Scripts/Part 3 - Developing Solutions/Lesson 05 - Transactions, Locking and Blocking.sql 4.25 KB
  • Project Files - SQL Server 2005/Sample Databases/Aesop/Aesop.adp 22.00 KB
  • Project Files - SQL Server 2005/Sample Databases/Aesop/Aesop_Create.sql 18.18 KB
  • Project Files - SQL Server 2005/Sample Databases/CapeHatterasAdventures/CHA1_Customers.mdb 120.00 KB
  • Project Files - SQL Server 2005/Sample Databases/CapeHatterasAdventures/CHA1_Schedule.xls 24.00 KB
  • Project Files - SQL Server 2005/Sample Databases/CapeHatterasAdventures/CHA_Convert.sql 4.09 KB
  • Project Files - SQL Server 2005/Sample Databases/CapeHatterasAdventures/CHA_Create.sql 7.29 KB
  • Project Files - SQL Server 2005/Sample Databases/Family/Family_Create.sql 9.93 KB
  • Project Files - SQL Server 2005/Sample Databases/Family/Family_Queries.sql 11.50 KB
  • Project Files - SQL Server 2005/Sample Databases/Family/Family_UDF.sql 907 bytes
  • Project Files - SQL Server 2005/Sample Databases/OBXKites/OBXKites_Create.sql 29.22 KB
  • Project Files - SQL Server 2005/Sample Databases/OBXKites/OBXKites_Populate.sql 18.85 KB

相关作品

相关词汇

相关文件