589689.xyz

Total Training - Microsoft SQL Server Development

  • 收录时间:2018-04-10 11:18:42
  • 文件大小:1GB
  • 下载次数:9
  • 最近下载:2020-10-17 00:36:50
  • 磁力链接:
立即下载 复制链接

文件列表

  1. Lesson 11 MODIFYING DATA (29 min)/1. Inserting Data.mov 28MB
  2. Lesson 3 DESIGNING RELATIONAL DATABASES(35 min)/2. Discovering Patterns.mov 22MB
  3. Lesson 1 SQL SERVER OVERVIEW(32 min)/1. Understanding Client Server Architecture.mov 21MB
  4. Lesson 16 TRANSACTIONS, LOCKING & BLOCKING (33 min)/2. Understanding Transactional Faults.mov 20MB
  5. Lesson 7 AGGREGATING DATA (35 min)/6. Generating Cross Tab Tables (Pivot).mov 20MB
  6. Lesson 1 SQL SERVER OVERVIEW(32 min)/4. Creating Sample Databases.mov 20MB
  7. Lesson 1 SQL SERVER OVERVIEW(32 min)/2. Introducing the Tools.mov 19MB
  8. Lesson 17 INTRODUCTION TO OPTIMIZATION THEORY (21 min)/2. Walking through Optimization Theory.mov 17MB
  9. Lesson 13 TRIGGERS & AUDIT TRAILS (31 min)/8. Auditing Data Changes.wmv 17MB
  10. Lesson 8 USING FULL-TEXT SEARCH (14 min)/2. Searching for Words.mov 17MB
  11. Lesson 5 MERGING DATA WITH JOINS & UNIONS(25 min)/1. Working with Inner Joins.mov 17MB
  12. Lesson 17 INTRODUCTION TO OPTIMIZATION THEORY (21 min)/3. Optimization Theory Continued.mov 16MB
  13. Lesson 1 SQL SERVER OVERVIEW(32 min)/3. Selecting an Addition.mov 16MB
  14. Lesson 11 MODIFYING DATA (29 min)/2. Updating Data.mov 15MB
  15. Lesson 7 AGGREGATING DATA (35 min)/3. Grouping a Data Set.mov 15MB
  16. Lesson 8 USING FULL-TEXT SEARCH (14 min)/1. Creating a Full-Text Index.mov 15MB
  17. Lesson 9 SELECTING DATA THROUGH VIEWS (11 min)/1. Creating Views.mov 15MB
  18. Lesson 3 DESIGNING RELATIONAL DATABASES(35 min)/3. Avoiding Over Complexity.mov 15MB
  19. Lesson 15 INDEXING FOR PERFORMANCE (31 min)/2. Creating Indexes.wmv 14MB
  20. Lesson 7 AGGREGATING DATA (35 min)/1. Using the New Windowing Functions.mov 14MB
  21. Lesson 16 TRANSACTIONS, LOCKING & BLOCKING (33 min)/6. Viewing Deadlocks.mov 14MB
  22. Lesson 6 WORKING WITH SUBQUERIES (19 min)/5. Solving for X with Relations Division.mov 14MB
  23. Lesson 6 WORKING WITH SUBQUERIES (19 min)/1. Using Subqueries as Expressions.mov 14MB
  24. Lesson 2 USING MANAGEMENT STUDIO(23 min)/4. Explaining the Database Properties Dialog.mov 13MB
  25. Lesson 14 USER-DEFINED FUNCTIONS (27 min)/4. Navigating a Hierarchy.wmv 13MB
  26. Lesson 3 DESIGNING RELATIONAL DATABASES(35 min)/5. Creating Physical Keys.mov 13MB
  27. Lesson 2 USING MANAGEMENT STUDIO(23 min)/7. Using the Query Editor.mov 13MB
  28. Lesson 10 DISTRIBUTED QUERIES (18 min)/1. Linking to External Data Sources.mov 13MB
  29. Lesson 15 INDEXING FOR PERFORMANCE (31 min)/4. Examinging Query Execution Plans, Pt. 2.wmv 13MB
  30. Lesson 3 DESIGNING RELATIONAL DATABASES(35 min)/6. Using the Database Diagrammer Tool.mov 12MB
  31. Lesson 12 T-SQL & STORED PROCEDURES (68 min)/5. Using Temp Tables.wmv 12MB
  32. Lesson 7 AGGREGATING DATA (35 min)/7. Calculating Cumulative Sums.mov 12MB
  33. Lesson 3 DESIGNING RELATIONAL DATABASES(35 min)/4. Managing Optional Data.mov 12MB
  34. Lesson 2 USING MANAGEMENT STUDIO(23 min)/3. Explaining Items in the Object Explorer.mov 12MB
  35. Lesson 15 INDEXING FOR PERFORMANCE (31 min)/3. Examinging Query Execution Plans, Pt. 1.wmv 12MB
  36. Lesson 12 T-SQL & STORED PROCEDURES (68 min)/2. Working with Variables.wmv 12MB
  37. Lesson 7 AGGREGATING DATA (35 min)/5. Filtering Groups & Adding Grand Totals.mov 12MB
  38. Lesson 5 MERGING DATA WITH JOINS & UNIONS(25 min)/7. Stacking Data with Unions.mov 11MB
  39. Lesson 11 MODIFYING DATA (29 min)/3. Deleting Data.mov 11MB
  40. Lesson 16 TRANSACTIONS, LOCKING & BLOCKING (33 min)/5. Working with Locks.mov 11MB
  41. Lesson 4 WORKING WITH SINGLE TABLE QUERIES(42 min)/2. Filtering Data with the Where Clause.wmv 11MB
  42. Lesson 12 T-SQL & STORED PROCEDURES (68 min)/11. Handling Errors.wmv 11MB
  43. Lesson 11 MODIFYING DATA (29 min)/5. Final Comments & Credits.mov 10MB
  44. Lesson 12 T-SQL & STORED PROCEDURES (68 min)/9. Returning Parameters.wmv 10MB
  45. Lesson 17 INTRODUCTION TO OPTIMIZATION THEORY (21 min)/4. Final Comments & Credits.mov 10MB
  46. Lesson 5 MERGING DATA WITH JOINS & UNIONS(25 min)/4. Referencing Self-Joins.mov 10MB
  47. Lesson 10 DISTRIBUTED QUERIES (18 min)/2. Executing Distributed Queries.wmv 10MB
  48. Lesson 12 T-SQL & STORED PROCEDURES (68 min)/6. Developing Dynamic SQL.wmv 10MB
  49. Lesson 6 WORKING WITH SUBQUERIES (19 min)/4. Working with Correlated Subqueries.mov 10MB
  50. Lesson 16 TRANSACTIONS, LOCKING & BLOCKING (33 min)/7. Using Snapshot Isolation.mov 9MB
  51. Lesson 11 MODIFYING DATA (29 min)/4. Using the Output Clause.mov 9MB
  52. Lesson 12 T-SQL & STORED PROCEDURES (68 min)/12. Explaining the Raise Error.wmv 9MB
  53. Lesson 7 AGGREGATING DATA (35 min)/2. Using Aggregate Functions.mov 9MB
  54. Lesson 4 WORKING WITH SINGLE TABLE QUERIES(42 min)/1. Understanding Query Flow.wmv 9MB
  55. Lesson 12 T-SQL & STORED PROCEDURES (68 min)/10. Working with a Cursor.wmv 9MB
  56. Lesson 12 T-SQL & STORED PROCEDURES (68 min)/7. Introducing Stored Procedures.wmv 8MB
  57. Lesson 4 WORKING WITH SINGLE TABLE QUERIES(42 min)/4. Using Case Expressions.wmv 8MB
  58. Lesson 14 USER-DEFINED FUNCTIONS (27 min)/6. Exploring Functions in Nordic.wmv 8MB
  59. Lesson 10 DISTRIBUTED QUERIES (18 min)/5. Controlling Distributed Transactions.mov 8MB
  60. Lesson 14 USER-DEFINED FUNCTIONS (27 min)/1. Creating Scalar Functions.wmv 8MB
  61. Lesson 4 WORKING WITH SINGLE TABLE QUERIES(42 min)/7. Working with Dates & Times.wmv 8MB
  62. Lesson 13 TRIGGERS & AUDIT TRAILS (31 min)/6. Nesting & Recursion.wmv 8MB
  63. Lesson 2 USING MANAGEMENT STUDIO(23 min)/5. Explaining the Columns Properties Dialog.mov 8MB
  64. Lesson 5 MERGING DATA WITH JOINS & UNIONS(25 min)/2. Using Left Outer Joins.mov 7MB
  65. Lesson 13 TRIGGERS & AUDIT TRAILS (31 min)/2. Using Instead of Trigger.wmv 7MB
  66. Lesson 7 AGGREGATING DATA (35 min)/4. Nesting Aggregations.mov 7MB
  67. Lesson 12 T-SQL & STORED PROCEDURES (68 min)/3. Controlling Procedural Flow.wmv 7MB
  68. Lesson 1 SQL SERVER OVERVIEW(32 min)/0. Introduction.mov 7MB
  69. Lesson 14 USER-DEFINED FUNCTIONS (27 min)/2. Working with Inline Table-Valued Functions.wmv 7MB
  70. Lesson 10 DISTRIBUTED QUERIES (18 min)/4. Using Pass Through Queries.mov 7MB
  71. Lesson 3 DESIGNING RELATIONAL DATABASES(35 min)/1. Understanding Normalization.mov 6MB
  72. Lesson 13 TRIGGERS & AUDIT TRAILS (31 min)/7. Enforcing Complex RI.wmv 6MB
  73. Lesson 5 MERGING DATA WITH JOINS & UNIONS(25 min)/3. Multiplying Data with Cross Joins.mov 6MB
  74. Lesson 4 WORKING WITH SINGLE TABLE QUERIES(42 min)/5. Working with Nulls & Coalesce.wmv 6MB
  75. Lesson 10 DISTRIBUTED QUERIES (18 min)/3. Looking at Where the Work Takes Place.mov 6MB
  76. Lesson 4 WORKING WITH SINGLE TABLE QUERIES(42 min)/11. Topping Off the Query with Predicates.wmv 6MB
  77. Lesson 12 T-SQL & STORED PROCEDURES (68 min)/8. Passing Parameters.wmv 6MB
  78. Lesson 2 USING MANAGEMENT STUDIO(23 min)/2. Registering Servers.mov 6MB
  79. Lesson 12 T-SQL & STORED PROCEDURES (68 min)/13. Controlling Transactions.wmv 5MB
  80. Lesson 6 WORKING WITH SUBQUERIES (19 min)/2. Including Subqueries as Lists.mov 5MB
  81. Lesson 17 INTRODUCTION TO OPTIMIZATION THEORY (21 min)/1. Deconstructing the Database System.mov 5MB
  82. Lesson 12 T-SQL & STORED PROCEDURES (68 min)/4. Examining SQL Server with Code.wmv 5MB
  83. Lesson 12 T-SQL & STORED PROCEDURES (68 min)/1. Introducing T-SQL.wmv 5MB
  84. Lesson 9 SELECTING DATA THROUGH VIEWS (11 min)/2. Preventing Disappearing Rows.mov 5MB
  85. Lesson 13 TRIGGERS & AUDIT TRAILS (31 min)/5. Selecting Transaction Data.wmv 5MB
  86. Lesson 2 USING MANAGEMENT STUDIO(23 min)/1. Arranging the Workspace.mov 5MB
  87. Lesson 13 TRIGGERS & AUDIT TRAILS (31 min)/1. Introducing After Triggers.wmv 5MB
  88. Lesson 9 SELECTING DATA THROUGH VIEWS (11 min)/4. Nesting Views.mov 5MB
  89. Lesson 5 MERGING DATA WITH JOINS & UNIONS(25 min)/6. Finding the Set Difference.mov 5MB
  90. Lesson 16 TRANSACTIONS, LOCKING & BLOCKING (33 min)/4. Exploring Locks.wmv 5MB
  91. Lesson 6 WORKING WITH SUBQUERIES (19 min)/3. Adding Subqueries as Derived Tables.mov 5MB
  92. Lesson 2 USING MANAGEMENT STUDIO(23 min)/6. Continuing with Object Explorer Items.mov 4MB
  93. Lesson 14 USER-DEFINED FUNCTIONS (27 min)/5. Having Fun with Apply.wmv 4MB
  94. Lesson 8 USING FULL-TEXT SEARCH (14 min)/3. Using a Fuzzy Search to Search for Phrases.mov 4MB
  95. Lesson 5 MERGING DATA WITH JOINS & UNIONS(25 min)/5. Working with Complex Joins.mov 4MB
  96. Lesson 15 INDEXING FOR PERFORMANCE (31 min)/1. Introducing Indexes.wmv 4MB
  97. Lesson 4 WORKING WITH SINGLE TABLE QUERIES(42 min)/8. Parsing Strings.wmv 4MB
  98. Lesson 4 WORKING WITH SINGLE TABLE QUERIES(42 min)/10. Sorting Data.wmv 4MB
  99. Lesson 9 SELECTING DATA THROUGH VIEWS (11 min)/3. Protecting from Schema Changes.mov 4MB
  100. Lesson 14 USER-DEFINED FUNCTIONS (27 min)/3. Using Multi-Statement Table-Valued UDFs.wmv 4MB
  101. Lesson 4 WORKING WITH SINGLE TABLE QUERIES(42 min)/3. Columns, Expressions & Scalar Functions.wmv 4MB
  102. Lesson 4 WORKING WITH SINGLE TABLE QUERIES(42 min)/9. Converting Data.wmv 4MB
  103. Lesson 16 TRANSACTIONS, LOCKING & BLOCKING (33 min)/3. Stepping through a Transaction.wmv 3MB
  104. Lesson 10 DISTRIBUTED QUERIES (18 min)/0. Introduction.mov 3MB
  105. Lesson 11 MODIFYING DATA (29 min)/0.Introduction.mov 3MB
  106. Lesson 12 T-SQL & STORED PROCEDURES (68 min)/0. Introduction.wmv 3MB
  107. Lesson 13 TRIGGERS & AUDIT TRAILS (31 min)/3. Disabling Triggers.wmv 3MB
  108. Lesson 6 WORKING WITH SUBQUERIES (19 min)/0. Introduction.mov 3MB
  109. Lesson 3 DESIGNING RELATIONAL DATABASES(35 min)/0. Introduction.mov 2MB
  110. Lesson 15 INDEXING FOR PERFORMANCE (31 min)/0. Introduction.wmv 2MB
  111. Lesson 13 TRIGGERS & AUDIT TRAILS (31 min)/4. Using the Update ( ) Function.wmv 2MB
  112. Lesson 5 MERGING DATA WITH JOINS & UNIONS(25 min)/0. Introduction.mov 2MB
  113. Lesson 16 TRANSACTIONS, LOCKING & BLOCKING (33 min)/1. Introducing ACID.wmv 2MB
  114. Lesson 13 TRIGGERS & AUDIT TRAILS (31 min)/0. Introduction.wmv 2MB
  115. Lesson 4 WORKING WITH SINGLE TABLE QUERIES(42 min)/6. Selecting Environment Functions.wmv 2MB
  116. Lesson 14 USER-DEFINED FUNCTIONS (27 min)/0. Introduction.wmv 2MB
  117. Lesson 2 USING MANAGEMENT STUDIO(23 min)/0. Introduction.mov 2MB
  118. Lesson 3 DESIGNING RELATIONAL DATABASES(35 min)/7. Final Comments.mov 2MB
  119. Lesson 9 SELECTING DATA THROUGH VIEWS (11 min)/0. Introduction.mov 2MB
  120. Lesson 7 AGGREGATING DATA (35 min)/0. Introduction.mov 2MB
  121. Lesson 8 USING FULL-TEXT SEARCH (14 min)/0. Introduction.mov 2MB
  122. Lesson 16 TRANSACTIONS, LOCKING & BLOCKING (33 min)/0 Introduction.wmv 1MB
  123. Lesson 17 INTRODUCTION TO OPTIMIZATION THEORY (21 min)/0. Introduction.wmv 1MB
  124. Project Files - SQL Server 2005/Sample Databases/CapeHatterasAdventures/CHA1_Customers.mdb 120KB
  125. Project Files - SQL Server 2005/Sample Databases/OBXKites/OBXKites_Create.sql 29KB
  126. Project Files - SQL Server 2005/Sample Databases/CapeHatterasAdventures/CHA1_Schedule.xls 24KB
  127. Project Files - SQL Server 2005/Sample Databases/Aesop/Aesop.adp 22KB
  128. Project Files - SQL Server 2005/Sample Databases/OBXKites/OBXKites_Populate.sql 19KB
  129. Project Files - SQL Server 2005/Sample Databases/Aesop/Aesop_Create.sql 18KB
  130. Project Files - SQL Server 2005/Lesson Scripts/Part 2 - Selecting Data/Lesson 04 - Aggregating Data.sql 16KB
  131. Project Files - SQL Server 2005/Lesson Scripts/Part 3 - Developing Solutions/Lesson 01 - T-SQL and Stored Procedures.sql 12KB
  132. Project Files - SQL Server 2005/Sample Databases/Family/Family_Queries.sql 12KB
  133. Project Files - SQL Server 2005/Lesson Scripts/Part 3 - Developing Solutions/Lesson 02 - Triggers.sql 11KB
  134. Project Files - SQL Server 2005/Sample Databases/Family/Family_Create.sql 10KB
  135. Project Files - SQL Server 2005/Lesson Scripts/Part 2 - Selecting Data/Lesson 03 - Subqueries.sql 10KB
  136. Project Files - SQL Server 2005/Lesson Scripts/Part 2 - Selecting Data/Lesson 01 - Selecting Data.sql 10KB
  137. Project Files - SQL Server 2005/Lesson Scripts/Part 2 - Selecting Data/Lesson 08 - Modifying Data.sql 8KB
  138. Project Files - SQL Server 2005/Sample Databases/CapeHatterasAdventures/CHA_Create.sql 7KB
  139. Project Files - SQL Server 2005/Lesson Scripts/Part 3 - Developing Solutions/Lesson 03 - User-Defined Functions.sql 6KB
  140. Project Files - SQL Server 2005/Lesson Scripts/Part 2 - Selecting Data/Lesson 02 - Joins and Unions.sql 5KB
  141. Project Files - SQL Server 2005/Lesson Scripts/Part 3 - Developing Solutions/Lesson 05 - Transactions, Locking and Blocking.sql 4KB
  142. Project Files - SQL Server 2005/Sample Databases/CapeHatterasAdventures/CHA_Convert.sql 4KB
  143. Project Files - SQL Server 2005/Lesson Scripts/Part 2 - Selecting Data/Lesson 07 - Distributed Queries.sql 4KB
  144. Project Files - SQL Server 2005/Lesson Scripts/Part 2 - Selecting Data/Lesson 05 - FullText Search.sql 4KB
  145. Project Files - SQL Server 2005/Lesson Scripts/Part 2 - Selecting Data/Lesson 06 - Views.sql 3KB
  146. Project Files - SQL Server 2005/Sample Databases/Family/Family_UDF.sql 907B
  147. Project Files - SQL Server 2005/Lesson Scripts/Part 3 - Developing Solutions/Lesson 04 - Indexing.sql 793B