[Tutorialsplanet.NET] Udemy - 70-461, 761 Querying Microsoft SQL Server with Transact-SQL

파일 형식 창조 시간 파일 크기 Seeders Leechers 업데이트 된 시간
비디오 2020-12-15 15.59GB 0 2 2 months ago
다운로드
자석 링크   or   Save Instantly without Torrenting   또는   토런트 다운로드

이 다운로드를 시작하려면, 당신은 qBittorrent 같은 무료 비트 토런트 클라이언트가 필요합니다.

Report Abuse
태그들
Tutorialsplanet  NET  Udemy  461  761  Querying  Microsoft  SQL  Server  with  Transact  SQL  
관련 링크
  1. [ DevCourseWeb.com ] Udemy - Angular 17, .NET Core Web API and Microsoft SQL Server App 339.39MB
  2. Training Kit (Exam 70-461) Querying Microsoft SQL Server 2012 Opsylum 55.63MB
  3. CBT Nuggests - Querying Microsoft SQL Server 2012 70-461 1.22GB
  4. 70-461 Session 6 Querying Microsoft SQL Server 2012 577.12MB
  5. VTC.com Querying Microsoft SQL Server 2012 Exam 70-461 Course DVD-iNKiSO 1.17GB
  6. Querying Microsoft SQL Server 2012 (Exam 70-461) Course 1.17GB
  7. Ben-Gan I., Sarka D., Talmage R. - Training Kit (Exam 70-461) Querying Microsoft SQL Server 2012 - 2012 63.55MB
  8. Querying Microsoft SQL Server 2012 - (Exam No. 70-461) 1.08GB
  9. CBT Nuggets - Exam 70-461 Querying Microsoft SQL Server 2012 1.53GB
  10. Ben-Gan I. - Inside Microsoft SQL Server 2005 T-SQL Querying - 2006.chm 8.20MB
파일 리스트
  1. 1. Session 1 - Let's begin, and let's download SQL Server/1. Introduction.mp4 51.43MB
  2. 1. Session 1 - Let's begin, and let's download SQL Server/1. Introduction.srt 3.71KB
  3. 1. Session 1 - Let's begin, and let's download SQL Server/2. Welcome to Udemy.html 886B
  4. 1. Session 1 - Let's begin, and let's download SQL Server/3. The Udemy Interface.mp4 21.25MB
  5. 1. Session 1 - Let's begin, and let's download SQL Server/3. The Udemy Interface.srt 3.88KB
  6. 1. Session 1 - Let's begin, and let's download SQL Server/4. Curriculum.mp4 88.74MB
  7. 1. Session 1 - Let's begin, and let's download SQL Server/4. Curriculum.srt 15.91KB
  8. 1. Session 1 - Let's begin, and let's download SQL Server/4.1 Exam 70-461.pptx 111.25KB
  9. 1. Session 1 - Let's begin, and let's download SQL Server/5. Do you have Windows 7 or Windows Vista.html 1.44KB
  10. 1. Session 1 - Let's begin, and let's download SQL Server/6. Downloading SQL Server.mp4 41.11MB
  11. 1. Session 1 - Let's begin, and let's download SQL Server/6. Downloading SQL Server.srt 9.82KB
  12. 1. Session 1 - Let's begin, and let's download SQL Server/7. Installing SQL Server Back Engine.mp4 65.07MB
  13. 1. Session 1 - Let's begin, and let's download SQL Server/7. Installing SQL Server Back Engine.srt 16.30KB
  14. 1. Session 1 - Let's begin, and let's download SQL Server/8. Installing SSMS.mp4 36.70MB
  15. 1. Session 1 - Let's begin, and let's download SQL Server/8. Installing SSMS.srt 7.79KB
  16. 10. Session 2 - Summarising and ordering data/1. Summarising and ordering data.mp4 136.93MB
  17. 10. Session 2 - Summarising and ordering data/1. Summarising and ordering data.srt 16.59KB
  18. 10. Session 2 - Summarising and ordering data/2. Summarising and ordering data.html 161B
  19. 10. Session 2 - Summarising and ordering data/3. Criteria on summarised data.mp4 151.78MB
  20. 10. Session 2 - Summarising and ordering data/3. Criteria on summarised data.srt 18.72KB
  21. 10. Session 2 - Summarising and ordering data/4. Criteria on summarised data.html 161B
  22. 10. Session 2 - Summarising and ordering data/5. Changing blank strings to NULLs.html 292B
  23. 10. Session 2 - Summarising and ordering data/6. Exercise.mp4 153.53MB
  24. 10. Session 2 - Summarising and ordering data/6. Exercise.srt 19.07KB
  25. 11. Session 2 - Adding a second table/1. Adding a second table.mp4 63.96MB
  26. 11. Session 2 - Adding a second table/1. Adding a second table.srt 12.85KB
  27. 11. Session 2 - Adding a second table/10. Creating a third table.mp4 147.56MB
  28. 11. Session 2 - Adding a second table/10. Creating a third table.srt 19.23KB
  29. 11. Session 2 - Adding a second table/11. JOINing three tables.mp4 139.77MB
  30. 11. Session 2 - Adding a second table/11. JOINing three tables.srt 19.94KB
  31. 11. Session 2 - Adding a second table/12. JOINing three tables.html 161B
  32. 11. Session 2 - Adding a second table/2. Designing a connection.mp4 112.21MB
  33. 11. Session 2 - Adding a second table/2. Designing a connection.srt 17.13KB
  34. 11. Session 2 - Adding a second table/3. New spreadsheet data.html 319B
  35. 11. Session 2 - Adding a second table/3.1 tblTransaction150707.xlsx 294.87KB
  36. 11. Session 2 - Adding a second table/4. Importing data and showing tables graphically.mp4 95.51MB
  37. 11. Session 2 - Adding a second table/4. Importing data and showing tables graphically.srt 14.75KB
  38. 11. Session 2 - Adding a second table/5. Writing a JOIN query.mp4 85.64MB
  39. 11. Session 2 - Adding a second table/5. Writing a JOIN query.srt 11.72KB
  40. 11. Session 2 - Adding a second table/6. Writing a JOIN query.html 161B
  41. 11. Session 2 - Adding a second table/7. The FROM clause - connecting to two tables.html 162B
  42. 11. Session 2 - Adding a second table/8. Different types of JOIN.mp4 28.87MB
  43. 11. Session 2 - Adding a second table/8. Different types of JOIN.srt 8.09KB
  44. 11. Session 2 - Adding a second table/9. Different types of JOIN.html 161B
  45. 12. Session 2 - Find missing data, and delete and update data/1. Missing data.mp4 118.26MB
  46. 12. Session 2 - Find missing data, and delete and update data/1. Missing data.srt 13.98KB
  47. 12. Session 2 - Find missing data, and delete and update data/2. Missing data.html 161B
  48. 12. Session 2 - Find missing data, and delete and update data/3. Deleting data.mp4 92.86MB
  49. 12. Session 2 - Find missing data, and delete and update data/3. Deleting data.srt 10.85KB
  50. 12. Session 2 - Find missing data, and delete and update data/4. Deleting data.html 161B
  51. 12. Session 2 - Find missing data, and delete and update data/5. Updating data.mp4 80.29MB
  52. 12. Session 2 - Find missing data, and delete and update data/5. Updating data.srt 12.13KB
  53. 12. Session 2 - Find missing data, and delete and update data/6. Updating data.html 161B
  54. 13. End of Session 2/1. BONUS - Recap, Look ahead and Voucher Code.mp4 5.08MB
  55. 13. End of Session 2/1. BONUS - Recap, Look ahead and Voucher Code.srt 6.19KB
  56. 13. End of Session 2/2. Thank you.mp4 74.28MB
  57. 13. End of Session 2/2. Thank you.srt 3.22KB
  58. 14. Session 3 - Introduction/1. Introduction.mp4 52.94MB
  59. 14. Session 3 - Introduction/1. Introduction.srt 3.84KB
  60. 14. Session 3 - Introduction/2. Is this your first session.html 367B
  61. 14. Session 3 - Introduction/2.1 CreateDatabaseSession3.sql 147.83KB
  62. 14. Session 3 - Introduction/3. Resources.html 239B
  63. 14. Session 3 - Introduction/3.1 70-461-Session-3-150707.docx 44.18KB
  64. 14. Session 3 - Introduction/4. Objectives.mp4 13.08MB
  65. 14. Session 3 - Introduction/4. Objectives.srt 4.67KB
  66. 14. Session 3 - Introduction/5. Summary of and problems with our existing database.mp4 47.40MB
  67. 14. Session 3 - Introduction/5. Summary of and problems with our existing database.srt 8.26KB
  68. 15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/1. What are constraints.mp4 56.72MB
  69. 15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/1. What are constraints.srt 8.20KB
  70. 15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/10. Check constraints.html 162B
  71. 15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/11. Primary key.mp4 68.06MB
  72. 15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/11. Primary key.srt 8.65KB
  73. 15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/12. Primary key - in practice.mp4 105.76MB
  74. 15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/12. Primary key - in practice.srt 18.33KB
  75. 15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/13. Primary Keys.html 162B
  76. 15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/14. Foreign key - what is it.mp4 68.77MB
  77. 15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/14. Foreign key - what is it.srt 11.73KB
  78. 15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/15. Foreign key - in practice.mp4 112.51MB
  79. 15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/15. Foreign key - in practice.srt 112.54MB
  80. 15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/16. Foreign Keys.html 162B
  81. 15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/17. Summary.mp4 9.50MB
  82. 15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/17. Summary.srt 3.53KB
  83. 15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/2. Unique constraints - what are they.mp4 22.66MB
  84. 15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/2. Unique constraints - what are they.srt 4.19KB
  85. 15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/3. Unique constraints in action.mp4 19.56MB
  86. 15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/3. Unique constraints in action.srt 5.43KB
  87. 15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/4. Unique constraints.html 162B
  88. 15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/5. Default constraints - what are they.mp4 22.51MB
  89. 15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/5. Default constraints - what are they.srt 4.22KB
  90. 15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/6. Default constraints in action.mp4 94.04MB
  91. 15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/6. Default constraints in action.srt 14.40KB
  92. 15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/7. Default constraints.html 162B
  93. 15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/8. Check constraint - what are they.mp4 40.03MB
  94. 15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/8. Check constraint - what are they.srt 4.72KB
  95. 15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/9. Check constraints - in practice.mp4 106.38MB
  96. 15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/9. Check constraints - in practice.srt 16.76KB
  97. 16. Session 3 - Objectives 2 and 3 Views/1. Creating views.mp4 83.63MB
  98. 16. Session 3 - Objectives 2 and 3 Views/1. Creating views.srt 83.65MB
  99. 16. Session 3 - Objectives 2 and 3 Views/10. Adding and deleting rows in views.html 162B
  100. 16. Session 3 - Objectives 2 and 3 Views/11. What is an index.mp4 50.18MB
  101. 16. Session 3 - Objectives 2 and 3 Views/11. What is an index.srt 8.21KB
  102. 16. Session 3 - Objectives 2 and 3 Views/12. Creating an indexed view.mp4 79.29MB
  103. 16. Session 3 - Objectives 2 and 3 Views/12. Creating an indexed view.srt 12.51KB
  104. 16. Session 3 - Objectives 2 and 3 Views/13. Creating an indexed view.html 162B
  105. 16. Session 3 - Objectives 2 and 3 Views/2. Altering and dropping views.mp4 70.43MB
  106. 16. Session 3 - Objectives 2 and 3 Views/2. Altering and dropping views.srt 9.36KB
  107. 16. Session 3 - Objectives 2 and 3 Views/3. CREATE OR ALTER VIEW.html 326B
  108. 16. Session 3 - Objectives 2 and 3 Views/4. Creating views.html 162B
  109. 16. Session 3 - Objectives 2 and 3 Views/5. Securing views.mp4 50.89MB
  110. 16. Session 3 - Objectives 2 and 3 Views/5. Securing views.srt 7.04KB
  111. 16. Session 3 - Objectives 2 and 3 Views/6. Security.mp4 47.33MB
  112. 16. Session 3 - Objectives 2 and 3 Views/6. Security.srt 9.88KB
  113. 16. Session 3 - Objectives 2 and 3 Views/7. Security.html 162B
  114. 16. Session 3 - Objectives 2 and 3 Views/8. Adding new rows to views.mp4 114.47MB
  115. 16. Session 3 - Objectives 2 and 3 Views/8. Adding new rows to views.srt 7.23KB
  116. 16. Session 3 - Objectives 2 and 3 Views/9. Deleting rows in views.mp4 23.93MB
  117. 16. Session 3 - Objectives 2 and 3 Views/9. Deleting rows in views.srt 4.29KB
  118. 17. Session 3 - Objective 5 Create and alter DML triggers/1. What are triggers.mp4 34.30MB
  119. 17. Session 3 - Objective 5 Create and alter DML triggers/1. What are triggers.srt 7.68KB
  120. 17. Session 3 - Objective 5 Create and alter DML triggers/2. Creating an AFTER trigger.mp4 51.77MB
  121. 17. Session 3 - Objective 5 Create and alter DML triggers/2. Creating an AFTER trigger.srt 6.95KB
  122. 17. Session 3 - Objective 5 Create and alter DML triggers/3. Creating an INSTEAD OF trigger.mp4 127.28MB
  123. 17. Session 3 - Objective 5 Create and alter DML triggers/3. Creating an INSTEAD OF trigger.srt 15.71KB
  124. 17. Session 3 - Objective 5 Create and alter DML triggers/4. Triggers.html 162B
  125. 17. Session 3 - Objective 5 Create and alter DML triggers/5. Nested triggers.mp4 88.64MB
  126. 17. Session 3 - Objective 5 Create and alter DML triggers/5. Nested triggers.srt 14.57KB
  127. 17. Session 3 - Objective 5 Create and alter DML triggers/6. Update functions.mp4 110.95MB
  128. 17. Session 3 - Objective 5 Create and alter DML triggers/6. Update functions.srt 14.80KB
  129. 17. Session 3 - Objective 5 Create and alter DML triggers/7. Nested triggers and update functions.html 162B
  130. 17. Session 3 - Objective 5 Create and alter DML triggers/8. Handling multiple rows in a session.mp4 60.95MB
  131. 17. Session 3 - Objective 5 Create and alter DML triggers/8. Handling multiple rows in a session.srt 7.60KB
  132. 17. Session 3 - Objective 5 Create and alter DML triggers/9. Summary.mp4 7.36MB
  133. 17. Session 3 - Objective 5 Create and alter DML triggers/9. Summary.srt 2.42KB
  134. 18. Session 3 - Conclusion/1. BONUS - Recap, Look ahead and Voucher Code.mp4 15.84MB
  135. 18. Session 3 - Conclusion/1. BONUS - Recap, Look ahead and Voucher Code.srt 5.76KB
  136. 18. Session 3 - Conclusion/2. Well done!.mp4 42.65MB
  137. 18. Session 3 - Conclusion/2. Well done!.srt 3.30KB
  138. 19. Session 4 - Introduction/1. Introduction.mp4 48.21MB
  139. 19. Session 4 - Introduction/1. Introduction.srt 48.23MB
  140. 19. Session 4 - Introduction/2. Is this your first session.html 380B
  141. 19. Session 4 - Introduction/2.1 CreateDatabaseSession3.sql 147.83KB
  142. 19. Session 4 - Introduction/3. Session 4 - Resources.html 239B
  143. 19. Session 4 - Introduction/3.1 70-461Session4-150721.docx 34.24KB
  144. 2. Session 1 - Starting SQL Server/1. Opening SQL Server.mp4 32.71MB
  145. 2. Session 1 - Starting SQL Server/1. Opening SQL Server.srt 3.73KB
  146. 2. Session 1 - Starting SQL Server/2. Looking at SQL Server Management Studio.mp4 51.46MB
  147. 2. Session 1 - Starting SQL Server/2. Looking at SQL Server Management Studio.srt 5.99KB
  148. 2. Session 1 - Starting SQL Server/3. Create a database.mp4 16.98MB
  149. 2. Session 1 - Starting SQL Server/3. Create a database.srt 2.35KB
  150. 2. Session 1 - Starting SQL Server/4. Creating our first queries.mp4 53.85MB
  151. 2. Session 1 - Starting SQL Server/4. Creating our first queries.srt 7.74KB
  152. 2. Session 1 - Starting SQL Server/5. Practice Activity Number 1 - Writing mathematical queries.html 511B
  153. 2. Session 1 - Starting SQL Server/6. Coding Exercises.html 263B
  154. 2. Session 1 - Starting SQL Server/7. Writing mathematical queries.html 162B
  155. 2. Session 1 - Starting SQL Server/8. Databases and Queries.html 162B
  156. 20. Session 4 - Objective 13 Combine datasets/1. UNION and UNION ALL.mp4 87.40MB
  157. 20. Session 4 - Objective 13 Combine datasets/1. UNION and UNION ALL.srt 16.77KB
  158. 20. Session 4 - Objective 13 Combine datasets/10. Let's expand our MERGE statement.mp4 96.37MB
  159. 20. Session 4 - Objective 13 Combine datasets/10. Let's expand our MERGE statement.srt 14.13KB
  160. 20. Session 4 - Objective 13 Combine datasets/11. Merge with additional columns.mp4 128.40MB
  161. 20. Session 4 - Objective 13 Combine datasets/11. Merge with additional columns.srt 18.43KB
  162. 20. Session 4 - Objective 13 Combine datasets/12. MERGE.html 162B
  163. 20. Session 4 - Objective 13 Combine datasets/13. Summary.mp4 9.23MB
  164. 20. Session 4 - Objective 13 Combine datasets/13. Summary.srt 3.42KB
  165. 20. Session 4 - Objective 13 Combine datasets/2. Intersect and Except.mp4 99.92MB
  166. 20. Session 4 - Objective 13 Combine datasets/2. Intersect and Except.srt 13.97KB
  167. 20. Session 4 - Objective 13 Combine datasets/3. UNION, UNION ALL, INTERSECT and EXCEPT.html 162B
  168. 20. Session 4 - Objective 13 Combine datasets/4. CASE statement.mp4 127.22MB
  169. 20. Session 4 - Objective 13 Combine datasets/4. CASE statement.srt 20.24KB
  170. 20. Session 4 - Objective 13 Combine datasets/5. CASE.html 162B
  171. 20. Session 4 - Objective 13 Combine datasets/6. IsNull and Coalesce.mp4 132.90MB
  172. 20. Session 4 - Objective 13 Combine datasets/6. IsNull and Coalesce.srt 17.00KB
  173. 20. Session 4 - Objective 13 Combine datasets/7. IsNull and Coalesce.html 162B
  174. 20. Session 4 - Objective 13 Combine datasets/8. MERGE statement - in theory.mp4 89.49MB
  175. 20. Session 4 - Objective 13 Combine datasets/8. MERGE statement - in theory.srt 17.23KB
  176. 20. Session 4 - Objective 13 Combine datasets/9. Let's Build our MERGE statement.mp4 103.68MB
  177. 20. Session 4 - Objective 13 Combine datasets/9. Let's Build our MERGE statement.srt 15.44KB
  178. 21. Session 4 - Objective 11 - Create and alter stored procedures (simple statements/1. Let's create our first procedure.mp4 61.00MB
  179. 21. Session 4 - Objective 11 - Create and alter stored procedures (simple statements/1. Let's create our first procedure.srt 14.47KB
  180. 21. Session 4 - Objective 11 - Create and alter stored procedures (simple statements/2. Ask for a specific employee.mp4 107.38MB
  181. 21. Session 4 - Objective 11 - Create and alter stored procedures (simple statements/2. Ask for a specific employee.srt 17.48KB
  182. 21. Session 4 - Objective 11 - Create and alter stored procedures (simple statements/3. Creating procedures.html 162B
  183. 21. Session 4 - Objective 11 - Create and alter stored procedures (simple statements/4. Exercise with IF.mp4 50.87MB
  184. 21. Session 4 - Objective 11 - Create and alter stored procedures (simple statements/4. Exercise with IF.srt 15.98MB
  185. 21. Session 4 - Objective 11 - Create and alter stored procedures (simple statements/5. Multiple arguments.mp4 49.43MB
  186. 21. Session 4 - Objective 11 - Create and alter stored procedures (simple statements/5. Multiple arguments.srt 7.56KB
  187. 21. Session 4 - Objective 11 - Create and alter stored procedures (simple statements/6. While.mp4 123.33MB
  188. 21. Session 4 - Objective 11 - Create and alter stored procedures (simple statements/6. While.srt 17.86KB
  189. 21. Session 4 - Objective 11 - Create and alter stored procedures (simple statements/7. Return.mp4 114.76MB
  190. 21. Session 4 - Objective 11 - Create and alter stored procedures (simple statements/7. Return.srt 17.61KB
  191. 21. Session 4 - Objective 11 - Create and alter stored procedures (simple statements/8. While and Return.html 162B
  192. 21. Session 4 - Objective 11 - Create and alter stored procedures (simple statements/9. Summary.mp4 14.16MB
  193. 21. Session 4 - Objective 11 - Create and alter stored procedures (simple statements/9. Summary.srt 4.93KB
  194. 22. Session 4 - Objective 18a - Implement trycatchthrow/1. Procedure Exercise.mp4 102.00MB
  195. 22. Session 4 - Objective 18a - Implement trycatchthrow/1. Procedure Exercise.srt 16.37KB
  196. 22. Session 4 - Objective 18a - Implement trycatchthrow/2. TRYCATCH.mp4 90.49MB
  197. 22. Session 4 - Objective 18a - Implement trycatchthrow/2. TRYCATCH.srt 13.63KB
  198. 22. Session 4 - Objective 18a - Implement trycatchthrow/3. THROW and RAISERROR.mp4 98.86MB
  199. 22. Session 4 - Objective 18a - Implement trycatchthrow/3. THROW and RAISERROR.srt 13.88KB
  200. 22. Session 4 - Objective 18a - Implement trycatchthrow/4. PRINT.mp4 84.01MB
  201. 22. Session 4 - Objective 18a - Implement trycatchthrow/4. PRINT.srt 12.00KB
  202. 22. Session 4 - Objective 18a - Implement trycatchthrow/5. Trycatchthrow.html 162B
  203. 22. Session 4 - Objective 18a - Implement trycatchthrow/6. Summary.mp4 7.32MB
  204. 22. Session 4 - Objective 18a - Implement trycatchthrow/6. Summary.srt 2.26KB
  205. 23. End of Session 4!/1. BONUS - Recap, Look ahead.mp4 13.64MB
  206. 23. End of Session 4!/1. BONUS - Recap, Look ahead.srt 5.17KB
  207. 23. End of Session 4!/2. Well done!.mp4 55.78MB
  208. 23. End of Session 4!/2. Well done!.srt 4.04KB
  209. 24. Session 5 - Introduction/1. Introduction.mp4 53.83MB
  210. 24. Session 5 - Introduction/1. Introduction.srt 4.00KB
  211. 24. Session 5 - Introduction/2. Is this your first session.html 368B
  212. 24. Session 5 - Introduction/2.1 CreateDatabaseSession5.zip 47.10KB
  213. 24. Session 5 - Introduction/3. Session 5 Resources.html 330B
  214. 24. Session 5 - Introduction/3.1 70-461Session5-150717.docx 44.99KB
  215. 24. Session 5 - Introduction/3.2 Session5Start.sql.zip 7.16KB
  216. 25. Session 5 - Objective 9 Implement aggregate queries/1. Introduction.mp4 62.49MB
  217. 25. Session 5 - Objective 9 Implement aggregate queries/1. Introduction.srt 10.10KB
  218. 25. Session 5 - Objective 9 Implement aggregate queries/1.1 Session5Start.zip 6.75KB
  219. 25. Session 5 - Objective 9 Implement aggregate queries/10. Row and Range.html 162B
  220. 25. Session 5 - Objective 9 Implement aggregate queries/2. OVER().mp4 78.90MB
  221. 25. Session 5 - Objective 9 Implement aggregate queries/2. OVER().srt 12.03KB
  222. 25. Session 5 - Objective 9 Implement aggregate queries/3. OVER.html 162B
  223. 25. Session 5 - Objective 9 Implement aggregate queries/4. PARTITION BY and ORDER BY.mp4 86.93MB
  224. 25. Session 5 - Objective 9 Implement aggregate queries/4. PARTITION BY and ORDER BY.srt 10.78KB
  225. 25. Session 5 - Objective 9 Implement aggregate queries/5. PARTITION BY and ORDER BY.html 162B
  226. 25. Session 5 - Objective 9 Implement aggregate queries/6. ROWS BETWEEN.mp4 40.06MB
  227. 25. Session 5 - Objective 9 Implement aggregate queries/6. ROWS BETWEEN.srt 6.48KB
  228. 25. Session 5 - Objective 9 Implement aggregate queries/7. CURRENT ROW and UNBOUNDED.mp4 43.75MB
  229. 25. Session 5 - Objective 9 Implement aggregate queries/7. CURRENT ROW and UNBOUNDED.srt 6.52KB
  230. 25. Session 5 - Objective 9 Implement aggregate queries/8. RANGE versus ROWS.mp4 89.37MB
  231. 25. Session 5 - Objective 9 Implement aggregate queries/8. RANGE versus ROWS.srt 12.77KB
  232. 25. Session 5 - Objective 9 Implement aggregate queries/9. Omitting RANGEROW.mp4 71.85MB
  233. 25. Session 5 - Objective 9 Implement aggregate queries/9. Omitting RANGEROW.srt 10.70KB
  234. 26. Session 5 - Objective 9d Ranking functions/1. ROW_NUMBER, RANK and DENSE_RANK.mp4 59.87MB
  235. 26. Session 5 - Objective 9d Ranking functions/1. ROW_NUMBER, RANK and DENSE_RANK.srt 9.71KB
  236. 26. Session 5 - Objective 9d Ranking functions/2. NTILE.mp4 53.23MB
  237. 26. Session 5 - Objective 9d Ranking functions/2. NTILE.srt 9.91KB
  238. 26. Session 5 - Objective 9d Ranking functions/3. Ranking functions.html 162B
  239. 27. Session 5 - Objective 9a New analytic functions/1. FIRST_VALUE and LAST_VALUE.mp4 71.69MB
  240. 27. Session 5 - Objective 9a New analytic functions/1. FIRST_VALUE and LAST_VALUE.srt 13.33KB
  241. 27. Session 5 - Objective 9a New analytic functions/2. LAG and LEAD.mp4 55.49MB
  242. 27. Session 5 - Objective 9a New analytic functions/2. LAG and LEAD.srt 9.29KB
  243. 27. Session 5 - Objective 9a New analytic functions/3. CUME_DIST and PERCENT_RANK.mp4 70.10MB
  244. 27. Session 5 - Objective 9a New analytic functions/3. CUME_DIST and PERCENT_RANK.srt 11.29KB
  245. 27. Session 5 - Objective 9a New analytic functions/4. PERCENTILE_CONT and PERCENTILE_DISC.mp4 76.04MB
  246. 27. Session 5 - Objective 9a New analytic functions/4. PERCENTILE_CONT and PERCENTILE_DISC.srt 13.01KB
  247. 27. Session 5 - Objective 9a New analytic functions/5. New analytic functions.html 162B
  248. 28. Section 5 - Objective 9b Grouping sets/1. Adding Totals.mp4 90.12MB
  249. 28. Section 5 - Objective 9b Grouping sets/1. Adding Totals.srt 13.08KB
  250. 28. Section 5 - Objective 9b Grouping sets/2. ROLLUP, GROUPING and GROUPING_ID.mp4 45.56MB
  251. 28. Section 5 - Objective 9b Grouping sets/2. ROLLUP, GROUPING and GROUPING_ID.srt 7.22KB
  252. 28. Section 5 - Objective 9b Grouping sets/3. GROUPING SETS.mp4 104.53MB
  253. 28. Section 5 - Objective 9b Grouping sets/3. GROUPING SETS.srt 15.88KB
  254. 28. Section 5 - Objective 9b Grouping sets/4. Grouping sets.html 162B
  255. 29. Session 5 - Objective 9c Spatial aggregates/1. Introduction.mp4 26.52MB
  256. 29. Session 5 - Objective 9c Spatial aggregates/1. Introduction.srt 8.29KB
  257. 29. Session 5 - Objective 9c Spatial aggregates/10. Spatial Aggregates.mp4 120.06MB
  258. 29. Session 5 - Objective 9c Spatial aggregates/10. Spatial Aggregates.srt 19.71KB
  259. 29. Session 5 - Objective 9c Spatial aggregates/11. Geography and Spatial Aggregates.html 162B
  260. 29. Session 5 - Objective 9c Spatial aggregates/12. Summary.mp4 11.32MB
  261. 29. Session 5 - Objective 9c Spatial aggregates/12. Summary.srt 3.75KB
  262. 29. Session 5 - Objective 9c Spatial aggregates/2. POINT.mp4 69.26MB
  263. 29. Session 5 - Objective 9c Spatial aggregates/2. POINT.srt 14.13KB
  264. 29. Session 5 - Objective 9c Spatial aggregates/3. POINT queries.mp4 152.69MB
  265. 29. Session 5 - Objective 9c Spatial aggregates/3. POINT queries.srt 4.70KB
  266. 29. Session 5 - Objective 9c Spatial aggregates/4. Point.html 162B
  267. 29. Session 5 - Objective 9c Spatial aggregates/5. Line, POLYGON and Circles.mp4 72.84MB
  268. 29. Session 5 - Objective 9c Spatial aggregates/5. Line, POLYGON and Circles.srt 12.93KB
  269. 29. Session 5 - Objective 9c Spatial aggregates/6. Lines and Circles.html 162B
  270. 29. Session 5 - Objective 9c Spatial aggregates/7. Line queries.mp4 76.08MB
  271. 29. Session 5 - Objective 9c Spatial aggregates/7. Line queries.srt 11.21KB
  272. 29. Session 5 - Objective 9c Spatial aggregates/8. Line queries.html 162B
  273. 29. Session 5 - Objective 9c Spatial aggregates/9. Geography.mp4 106.93MB
  274. 29. Session 5 - Objective 9c Spatial aggregates/9. Geography.srt 13.96KB
  275. 3. Session 1 - Creating tables - First pass/1. Creating a table - first pass using GUI.mp4 18.47MB
  276. 3. Session 1 - Creating tables - First pass/1. Creating a table - first pass using GUI.srt 2.96KB
  277. 3. Session 1 - Creating tables - First pass/10. How do you like these coding exercises.html 829B
  278. 3. Session 1 - Creating tables - First pass/11. Deleting the data, then the table.mp4 28.45MB
  279. 3. Session 1 - Creating tables - First pass/11. Deleting the data, then the table.srt 3.38KB
  280. 3. Session 1 - Creating tables - First pass/12. Deleting data using T-SQL.html 162B
  281. 3. Session 1 - Creating tables - First pass/13. Practice Activity Number 2.html 669B
  282. 3. Session 1 - Creating tables - First pass/2. Creating a table - first pass using T-SQL.mp4 25.25MB
  283. 3. Session 1 - Creating tables - First pass/2. Creating a table - first pass using T-SQL.srt 26.04MB
  284. 3. Session 1 - Creating tables - First pass/3. New Tables.html 162B
  285. 3. Session 1 - Creating tables - First pass/4. Entering data using the GUI.mp4 21.01MB
  286. 3. Session 1 - Creating tables - First pass/4. Entering data using the GUI.srt 4.22KB
  287. 3. Session 1 - Creating tables - First pass/5. Entering data using T-SQL.mp4 44.58MB
  288. 3. Session 1 - Creating tables - First pass/5. Entering data using T-SQL.srt 5.73KB
  289. 3. Session 1 - Creating tables - First pass/6. Entering data using T-SQL.html 162B
  290. 3. Session 1 - Creating tables - First pass/7. Retrieving data.mp4 40.96MB
  291. 3. Session 1 - Creating tables - First pass/7. Retrieving data.srt 6.75KB
  292. 3. Session 1 - Creating tables - First pass/8. Retrieving data.html 162B
  293. 3. Session 1 - Creating tables - First pass/9. The FROM clause - connecting to one table.html 162B
  294. 30. End of Session 5/1. End of Session 5.mp4 9.71MB
  295. 30. End of Session 5/1. End of Session 5.srt 3.04KB
  296. 30. End of Session 5/2. Well done!.mp4 44.66MB
  297. 30. End of Session 5/2. Well done!.srt 3.04KB
  298. 31. Session 6 - Introduction/1. Introduction.mp4 66.07MB
  299. 31. Session 6 - Introduction/1. Introduction.srt 4.04KB
  300. 31. Session 6 - Introduction/2. Objectives.mp4 11.78MB
  301. 31. Session 6 - Introduction/2. Objectives.srt 11.79MB
  302. 31. Session 6 - Introduction/3. Session 6 Resources.html 239B
  303. 31. Session 6 - Introduction/3.1 Session6Start.sql 47.50KB
  304. 31. Session 6 - Introduction/3.2 JSON190304.docx 13.98KB
  305. 31. Session 6 - Introduction/3.3 70-461Session6-180501.docx 58.12KB
  306. 31. Session 6 - Introduction/3.4 Temporal Tables190519.docx 15.21KB
  307. 32. Session 6 - Objective 7 Sub-queries/1. Table structure.mp4 35.68MB
  308. 32. Session 6 - Objective 7 Sub-queries/1. Table structure.srt 7.41KB
  309. 32. Session 6 - Objective 7 Sub-queries/2. The WHERE clause.mp4 55.70MB
  310. 32. Session 6 - Objective 7 Sub-queries/2. The WHERE clause.srt 9.92KB
  311. 32. Session 6 - Objective 7 Sub-queries/3. WHERE and NOT.mp4 52.74MB
  312. 32. Session 6 - Objective 7 Sub-queries/3. WHERE and NOT.srt 7.44KB
  313. 32. Session 6 - Objective 7 Sub-queries/4. ANY, SOME and ALL.mp4 67.88MB
  314. 32. Session 6 - Objective 7 Sub-queries/4. ANY, SOME and ALL.srt 12.36KB
  315. 32. Session 6 - Objective 7 Sub-queries/5. The FROM clause.mp4 98.73MB
  316. 32. Session 6 - Objective 7 Sub-queries/5. The FROM clause.srt 14.95KB
  317. 32. Session 6 - Objective 7 Sub-queries/6. The SELECT clause.mp4 94.27MB
  318. 32. Session 6 - Objective 7 Sub-queries/6. The SELECT clause.srt 16.39KB
  319. 32. Session 6 - Objective 7 Sub-queries/7. Correlated subquery - WHERE.mp4 58.61MB
  320. 32. Session 6 - Objective 7 Sub-queries/7. Correlated subquery - WHERE.srt 10.34KB
  321. 32. Session 6 - Objective 7 Sub-queries/8. Sub-query.html 162B
  322. 32. Session 6 - Objective 7 Sub-queries/9. Top 5 from various categories.mp4 55.45MB
  323. 32. Session 6 - Objective 7 Sub-queries/9. Top 5 from various categories.srt 9.89KB
  324. 33. Session 6 - Objective 7e WITH statement/1. WITH statement.mp4 47.77MB
  325. 33. Session 6 - Objective 7e WITH statement/1. WITH statement.srt 6.47KB
  326. 33. Session 6 - Objective 7e WITH statement/2. Generating a list of numbers.mp4 84.27MB
  327. 33. Session 6 - Objective 7e WITH statement/2. Generating a list of numbers.srt 12.56KB
  328. 33. Session 6 - Objective 7e WITH statement/3. Grouping numbers.mp4 85.54MB
  329. 33. Session 6 - Objective 7e WITH statement/3. Grouping numbers.srt 15.77KB
  330. 33. Session 6 - Objective 7e WITH statement/4. WITH statement.html 162B
  331. 34. Session 6 - Objective 7b PIVOTing and UNPIVOTing/1. PIVOT.mp4 63.86MB
  332. 34. Session 6 - Objective 7b PIVOTing and UNPIVOTing/1. PIVOT.srt 50.09MB
  333. 34. Session 6 - Objective 7b PIVOTing and UNPIVOTing/2. Replacing NULLs in PIVOTs..mp4 56.86MB
  334. 34. Session 6 - Objective 7b PIVOTing and UNPIVOTing/2. Replacing NULLs in PIVOTs..srt 9.69KB
  335. 34. Session 6 - Objective 7b PIVOTing and UNPIVOTing/3. UNPIVOT.mp4 28.47MB
  336. 34. Session 6 - Objective 7b PIVOTing and UNPIVOTing/3. UNPIVOT.srt 4.35KB
  337. 34. Session 6 - Objective 7b PIVOTing and UNPIVOTing/4. Pivotting and Unpivotting.html 162B
  338. 35. Session 6 - Objective 7d CTE statement/1. Self-Join.mp4 88.14MB
  339. 35. Session 6 - Objective 7d CTE statement/1. Self-Join.srt 12.73KB
  340. 35. Session 6 - Objective 7d CTE statement/2. Recursive CTE.mp4 107.67MB
  341. 35. Session 6 - Objective 7d CTE statement/2. Recursive CTE.srt 16.21KB
  342. 35. Session 6 - Objective 7d CTE statement/3. Recursive CTE.html 162B
  343. 36. Session 6 - Objective 14 Functions/1. Introduction.mp4 28.83MB
  344. 36. Session 6 - Objective 14 Functions/1. Introduction.srt 8.54KB
  345. 36. Session 6 - Objective 14 Functions/2. Scalar Functions.mp4 74.55MB
  346. 36. Session 6 - Objective 14 Functions/2. Scalar Functions.srt 12.25KB
  347. 36. Session 6 - Objective 14 Functions/3. A more complicated scalar function.mp4 63.87MB
  348. 36. Session 6 - Objective 14 Functions/3. A more complicated scalar function.srt 10.56KB
  349. 36. Session 6 - Objective 14 Functions/4. Inline Table Function.mp4 47.78MB
  350. 36. Session 6 - Objective 14 Functions/4. Inline Table Function.srt 7.73KB
  351. 36. Session 6 - Objective 14 Functions/5. Multi-statement Table Function.mp4 50.01MB
  352. 36. Session 6 - Objective 14 Functions/5. Multi-statement Table Function.srt 7.59KB
  353. 36. Session 6 - Objective 14 Functions/6. APPLY.mp4 83.58MB
  354. 36. Session 6 - Objective 14 Functions/6. APPLY.srt 11.60KB
  355. 36. Session 6 - Objective 14 Functions/7. Functions.html 162B
  356. 37. Session 6 - Objectives 6b and 6c Synonyms and Dynamics/1. Synonyms.mp4 54.34MB
  357. 37. Session 6 - Objectives 6b and 6c Synonyms and Dynamics/1. Synonyms.srt 9.77KB
  358. 37. Session 6 - Objectives 6b and 6c Synonyms and Dynamics/2. Dynamic SQL.mp4 60.93MB
  359. 37. Session 6 - Objectives 6b and 6c Synonyms and Dynamics/2. Dynamic SQL.srt 9.18KB
  360. 37. Session 6 - Objectives 6b and 6c Synonyms and Dynamics/3. Dynamic SQL.html 162B
  361. 38. Session 6 - Objectives 8c GUIDs; and Sequences/1. The problems about IDENTITY.mp4 23.93MB
  362. 38. Session 6 - Objectives 8c GUIDs; and Sequences/1. The problems about IDENTITY.srt 4.04KB
  363. 38. Session 6 - Objectives 8c GUIDs; and Sequences/2. GUIDs.mp4 79.80MB
  364. 38. Session 6 - Objectives 8c GUIDs; and Sequences/2. GUIDs.srt 11.98KB
  365. 38. Session 6 - Objectives 8c GUIDs; and Sequences/3. Creating SEQUENCEs.mp4 45.62MB
  366. 38. Session 6 - Objectives 8c GUIDs; and Sequences/3. Creating SEQUENCEs.srt 8.18KB
  367. 38. Session 6 - Objectives 8c GUIDs; and Sequences/4. Using SEQUENCEs.mp4 72.22MB
  368. 38. Session 6 - Objectives 8c GUIDs; and Sequences/4. Using SEQUENCEs.srt 10.03KB
  369. 38. Session 6 - Objectives 8c GUIDs; and Sequences/5. GUIDs and SEQUENCEs.html 162B
  370. 39/1. Introduction to XML - Let's make a shopping list.mp4 38.95MB
  371. 39/1. Introduction to XML - Let's make a shopping list.srt 7.46KB
  372. 39/2. Attributes.mp4 39.00MB
  373. 39/2. Attributes.srt 12.09KB
  374. 39/3. Creating XML variable and XML field.mp4 53.30MB
  375. 39/3. Creating XML variable and XML field.srt 9.33KB
  376. 39/4. FOR XML RAW.mp4 75.95MB
  377. 39/4. FOR XML RAW.srt 9.41KB
  378. 39/5. FOR XML AUTO.mp4 43.44MB
  379. 39/5. FOR XML AUTO.srt 6.43KB
  380. 39/6. FOR XML PATH.mp4 102.67MB
  381. 39/6. FOR XML PATH.srt 13.59KB
  382. 39/7. FOR XML EXPLICIT.mp4 79.46MB
  383. 39/7. FOR XML EXPLICIT.srt 10.46KB
  384. 4. Session 1 - Number types and functions/1. Creating an Employee table.mp4 37.61MB
  385. 4. Session 1 - Number types and functions/1. Creating an Employee table.srt 5.71KB
  386. 4. Session 1 - Number types and functions/10. Mathematical functions.mp4 99.68MB
  387. 4. Session 1 - Number types and functions/10. Mathematical functions.srt 13.50KB
  388. 4. Session 1 - Number types and functions/11. Mathematical functions.html 162B
  389. 4. Session 1 - Number types and functions/12. Converting between number types.mp4 63.42MB
  390. 4. Session 1 - Number types and functions/12. Converting between number types.srt 10.62KB
  391. 4. Session 1 - Number types and functions/13. Converting between number types.html 162B
  392. 4. Session 1 - Number types and functions/14. Practice Activity Number 4.html 1016B
  393. 4. Session 1 - Number types and functions/14.1 Practice-Activity-Number-4-Hints.txt 480B
  394. 4. Session 1 - Number types and functions/15. Practice Activity Number 4 - Solution.mp4 55.13MB
  395. 4. Session 1 - Number types and functions/15. Practice Activity Number 4 - Solution.srt 7.35KB
  396. 4. Session 1 - Number types and functions/2. Session 1 Resources.html 587B
  397. 4. Session 1 - Number types and functions/2.1 70-461-Session-1-200902.docx 25.54KB
  398. 4. Session 1 - Number types and functions/3. Creating temporary variables.mp4 108.73MB
  399. 4. Session 1 - Number types and functions/3. Creating temporary variables.srt 14.97KB
  400. 4. Session 1 - Number types and functions/4. Integer numbers.mp4 69.40MB
  401. 4. Session 1 - Number types and functions/4. Integer numbers.srt 10.37KB
  402. 4. Session 1 - Number types and functions/5. Integer numbers.html 162B
  403. 4. Session 1 - Number types and functions/6. Practice Activity Number 3.html 1.07KB
  404. 4. Session 1 - Number types and functions/7. Practice Activity Number 3 - Solution.mp4 36.08MB
  405. 4. Session 1 - Number types and functions/7. Practice Activity Number 3 - Solution.srt 4.64KB
  406. 4. Session 1 - Number types and functions/8. Non-integer numbers.mp4 121.36MB
  407. 4. Session 1 - Number types and functions/8. Non-integer numbers.srt 23.06KB
  408. 4. Session 1 - Number types and functions/9. Non-integer numbers.html 162B
  409. 40. Session 6 - Objective 10 Shredding XML data/1. XQuery Value and Exist methods.mp4 60.96MB
  410. 40. Session 6 - Objective 10 Shredding XML data/1. XQuery Value and Exist methods.srt 10.35KB
  411. 40. Session 6 - Objective 10 Shredding XML data/2. XQuery Modify method.mp4 52.09MB
  412. 40. Session 6 - Objective 10 Shredding XML data/2. XQuery Modify method.srt 8.12KB
  413. 40. Session 6 - Objective 10 Shredding XML data/3. XQuery Query method using for and return.mp4 57.94MB
  414. 40. Session 6 - Objective 10 Shredding XML data/3. XQuery Query method using for and return.srt 10.33KB
  415. 40. Session 6 - Objective 10 Shredding XML data/4. XQuery Query method using let, where and order by (FLWOR).mp4 54.85MB
  416. 40. Session 6 - Objective 10 Shredding XML data/4. XQuery Query method using let, where and order by (FLWOR).srt 8.70KB
  417. 40. Session 6 - Objective 10 Shredding XML data/5. XQuery Nodes - shredding a variable.mp4 59.20MB
  418. 40. Session 6 - Objective 10 Shredding XML data/5. XQuery Nodes - shredding a variable.srt 8.63KB
  419. 40. Session 6 - Objective 10 Shredding XML data/6. XQuery Nodes - shredding a table.mp4 57.47MB
  420. 40. Session 6 - Objective 10 Shredding XML data/6. XQuery Nodes - shredding a table.srt 8.32KB
  421. 41. Session 6 - Objective 10 Other XML considerations/1. Importing and exporting XML using the bcp utility.mp4 47.07MB
  422. 41. Session 6 - Objective 10 Other XML considerations/1. Importing and exporting XML using the bcp utility.srt 9.10KB
  423. 41. Session 6 - Objective 10 Other XML considerations/2. Bulk Insert and Openrowset.mp4 45.83MB
  424. 41. Session 6 - Objective 10 Other XML considerations/2. Bulk Insert and Openrowset.srt 7.32KB
  425. 41. Session 6 - Objective 10 Other XML considerations/2.1 SampleDataBulkInsert.txt 260B
  426. 41. Session 6 - Objective 10 Other XML considerations/2.2 SampleDataOpenRowset.txt 187B
  427. 41. Session 6 - Objective 10 Other XML considerations/3. Schema.mp4 74.62MB
  428. 41. Session 6 - Objective 10 Other XML considerations/3. Schema.srt 10.88KB
  429. 41. Session 6 - Objective 10 Other XML considerations/4. When should I use XML in SQL Server.mp4 41.20MB
  430. 41. Session 6 - Objective 10 Other XML considerations/4. When should I use XML in SQL Server.srt 6.25KB
  431. 41. Session 6 - Objective 10 Other XML considerations/5. Creating Primary and Secondary XML Indexes.mp4 91.69MB
  432. 41. Session 6 - Objective 10 Other XML considerations/5. Creating Primary and Secondary XML Indexes.srt 14.52KB
  433. 42. Session 6 - Manipulating JSON data (SQL Server 2016 onwards)/1. These next two sections require SQL Server 2016 or later.html 1.24KB
  434. 42. Session 6 - Manipulating JSON data (SQL Server 2016 onwards)/2. Creating JSON and ISJSON.mp4 73.40MB
  435. 42. Session 6 - Manipulating JSON data (SQL Server 2016 onwards)/2. Creating JSON and ISJSON.srt 15.48KB
  436. 42. Session 6 - Manipulating JSON data (SQL Server 2016 onwards)/3. JSON_VALUE and JSON_QUERY.mp4 64.51MB
  437. 42. Session 6 - Manipulating JSON data (SQL Server 2016 onwards)/3. JSON_VALUE and JSON_QUERY.srt 10.61KB
  438. 42. Session 6 - Manipulating JSON data (SQL Server 2016 onwards)/4. JSON_MODIFY.mp4 31.12MB
  439. 42. Session 6 - Manipulating JSON data (SQL Server 2016 onwards)/4. JSON_MODIFY.srt 5.77KB
  440. 42. Session 6 - Manipulating JSON data (SQL Server 2016 onwards)/5. Converting JSON data into SQL Server tables.mp4 20.53MB
  441. 42. Session 6 - Manipulating JSON data (SQL Server 2016 onwards)/5. Converting JSON data into SQL Server tables.srt 3.94KB
  442. 42. Session 6 - Manipulating JSON data (SQL Server 2016 onwards)/6. Converting SQL Server data into JSON.mp4 16.65MB
  443. 42. Session 6 - Manipulating JSON data (SQL Server 2016 onwards)/6. Converting SQL Server data into JSON.srt 3.06KB
  444. 43. Session 6 - Temporal Tables/1. What are temporal tables.mp4 87.28MB
  445. 43. Session 6 - Temporal Tables/1. What are temporal tables.srt 14.20KB
  446. 43. Session 6 - Temporal Tables/2. Creating temporal tables.mp4 69.95MB
  447. 43. Session 6 - Temporal Tables/2. Creating temporal tables.srt 8.81KB
  448. 43. Session 6 - Temporal Tables/3. Dropping temporal tables, and specifying the history table.mp4 35.70MB
  449. 43. Session 6 - Temporal Tables/3. Dropping temporal tables, and specifying the history table.srt 4.78KB
  450. 43. Session 6 - Temporal Tables/4. Altering existing tables to make them temporal tables.mp4 41.69MB
  451. 43. Session 6 - Temporal Tables/4. Altering existing tables to make them temporal tables.srt 7.27KB
  452. 43. Session 6 - Temporal Tables/5. Querying temporal data at a point of time.mp4 35.02MB
  453. 43. Session 6 - Temporal Tables/5. Querying temporal data at a point of time.srt 3.91KB
  454. 43. Session 6 - Temporal Tables/6. Querying temporal data between a range of times.mp4 84.62MB
  455. 43. Session 6 - Temporal Tables/6. Querying temporal data between a range of times.srt 10.09KB
  456. 44. Session 6 - Conclusion/1. Bonus lecture.mp4 11.71MB
  457. 44. Session 6 - Conclusion/1. Bonus lecture.srt 3.90KB
  458. 44. Session 6 - Conclusion/2. Well done!.mp4 25.42MB
  459. 44. Session 6 - Conclusion/2. Well done!.srt 1.83KB
  460. 45. Session 7 - Introduction/1. Introduction.mp4 49.81MB
  461. 45. Session 7 - Introduction/1. Introduction.srt 3.67KB
  462. 45. Session 7 - Introduction/2. Curriculum.mp4 16.40MB
  463. 45. Session 7 - Introduction/2. Curriculum.srt 5.80KB
  464. 45. Session 7 - Introduction/3. Session 7 Resources.mp4 38.54MB
  465. 45. Session 7 - Introduction/3. Session 7 Resources.srt 7.44KB
  466. 45. Session 7 - Introduction/3.1 70-461Session7.181025.docx 49.51KB
  467. 45. Session 7 - Introduction/3.2 CreateDatabaseSession7.sql 147.83KB
  468. 46. Session 7 - Manage transactions/1. Introduction - What are transactions.mp4 17.07MB
  469. 46. Session 7 - Manage transactions/1. Introduction - What are transactions.srt 11.90KB
  470. 46. Session 7 - Manage transactions/10. Isolation Levels in Action.mp4 92.54MB
  471. 46. Session 7 - Manage transactions/10. Isolation Levels in Action.srt 16.99KB
  472. 46. Session 7 - Manage transactions/11. Conclusion.mp4 5.45MB
  473. 46. Session 7 - Manage transactions/11. Conclusion.srt 2.04KB
  474. 46. Session 7 - Manage transactions/2. Implicit transactions.mp4 23.63MB
  475. 46. Session 7 - Manage transactions/2. Implicit transactions.srt 4.44KB
  476. 46. Session 7 - Manage transactions/3. Explicit Transactions - Start and end transactions.mp4 74.90MB
  477. 46. Session 7 - Manage transactions/3. Explicit Transactions - Start and end transactions.srt 11.25KB
  478. 46. Session 7 - Manage transactions/4. Mark a transaction.mp4 35.62MB
  479. 46. Session 7 - Manage transactions/4. Mark a transaction.srt 5.02KB
  480. 46. Session 7 - Manage transactions/5. Trancount.mp4 65.56MB
  481. 46. Session 7 - Manage transactions/5. Trancount.srt 9.86KB
  482. 46. Session 7 - Manage transactions/6. Scope and type of locks.mp4 38.24MB
  483. 46. Session 7 - Manage transactions/6. Scope and type of locks.srt 14.74KB
  484. 46. Session 7 - Manage transactions/7. Locks in Practice, and using the WAITFOR statement.mp4 30.11MB
  485. 46. Session 7 - Manage transactions/7. Locks in Practice, and using the WAITFOR statement.srt 5.58KB
  486. 46. Session 7 - Manage transactions/8. What would happen if locks didn't exist.mp4 31.96MB
  487. 46. Session 7 - Manage transactions/8. What would happen if locks didn't exist.srt 13.66KB
  488. 46. Session 7 - Manage transactions/9. What are Isolation levels.mp4 23.17MB
  489. 46. Session 7 - Manage transactions/9. What are Isolation levels.srt 6.61KB
  490. 47. Session 7 - Indexes/1. Re-introducing Query plans.mp4 27.06MB
  491. 47. Session 7 - Indexes/1. Re-introducing Query plans.srt 6.44KB
  492. 47. Session 7 - Indexes/2. Heaps, and scans.mp4 37.24MB
  493. 47. Session 7 - Indexes/2. Heaps, and scans.srt 9.49KB
  494. 47. Session 7 - Indexes/3. B-Tree.mp4 35.22MB
  495. 47. Session 7 - Indexes/3. B-Tree.srt 7.95KB
  496. 47. Session 7 - Indexes/4. Clustered indexes.mp4 89.94MB
  497. 47. Session 7 - Indexes/4. Clustered indexes.srt 15.08KB
  498. 47. Session 7 - Indexes/5. Quiz - Clustered Indexes.html 162B
  499. 47. Session 7 - Indexes/6. Non-clustered indexes.mp4 53.44MB
  500. 47. Session 7 - Indexes/6. Non-clustered indexes.srt 7.29KB
  501. 47. Session 7 - Indexes/7. Filtered Indices.mp4 32.74MB
  502. 47. Session 7 - Indexes/7. Filtered Indices.srt 6.52KB
  503. 47. Session 7 - Indexes/8. Include.mp4 69.53MB
  504. 47. Session 7 - Indexes/8. Include.srt 11.50KB
  505. 48. Session 7 - Optimise queries/1. What are statistics - Include Client Statistics.mp4 48.71MB
  506. 48. Session 7 - Optimise queries/1. What are statistics - Include Client Statistics.srt 8.63KB
  507. 48. Session 7 - Optimise queries/10. SET SHOWPLAN_ALL and Client Statistics.mp4 51.99MB
  508. 48. Session 7 - Optimise queries/10. SET SHOWPLAN_ALL and Client Statistics.srt 8.45KB
  509. 48. Session 7 - Optimise queries/11. Dynamic vs. parameterised queries.mp4 49.54MB
  510. 48. Session 7 - Optimise queries/11. Dynamic vs. parameterised queries.srt 8.12KB
  511. 48. Session 7 - Optimise queries/2. The different join types and seeing HASH join in action.mp4 27.01MB
  512. 48. Session 7 - Optimise queries/2. The different join types and seeing HASH join in action.srt 7.23KB
  513. 48. Session 7 - Optimise queries/3. Nested Loops and Merge Joins in action.mp4 75.03MB
  514. 48. Session 7 - Optimise queries/3. Nested Loops and Merge Joins in action.srt 11.44KB
  515. 48. Session 7 - Optimise queries/4. Even bigger savings of time when using a SARG.mp4 39.29MB
  516. 48. Session 7 - Optimise queries/4. Even bigger savings of time when using a SARG.srt 7.18KB
  517. 48. Session 7 - Optimise queries/5. Reading Query plans and the cost of Sorting.mp4 48.39MB
  518. 48. Session 7 - Optimise queries/5. Reading Query plans and the cost of Sorting.srt 7.11KB
  519. 48. Session 7 - Optimise queries/6. A more advanced query plan.mp4 40.40MB
  520. 48. Session 7 - Optimise queries/6. A more advanced query plan.srt 6.43KB
  521. 48. Session 7 - Optimise queries/7. Plan guides.mp4 78.36MB
  522. 48. Session 7 - Optimise queries/7. Plan guides.srt 13.36KB
  523. 48. Session 7 - Optimise queries/8. Hints.mp4 87.95MB
  524. 48. Session 7 - Optimise queries/8. Hints.srt 15.65KB
  525. 48. Session 7 - Optimise queries/9. Statistics IO.mp4 47.13MB
  526. 48. Session 7 - Optimise queries/9. Statistics IO.srt 8.72KB
  527. 49. Session 7 - Dynamic Management Views and Functions/1. dm_db_index_usage_stats.mp4 110.87MB
  528. 49. Session 7 - Dynamic Management Views and Functions/1. dm_db_index_usage_stats.srt 17.72KB
  529. 49. Session 7 - Dynamic Management Views and Functions/2. sys.dm_db_index_physical_stats.mp4 56.32MB
  530. 49. Session 7 - Dynamic Management Views and Functions/2. sys.dm_db_index_physical_stats.srt 11.59KB
  531. 49. Session 7 - Dynamic Management Views and Functions/3. sys.dm_db_missing_index_details.mp4 60.43MB
  532. 49. Session 7 - Dynamic Management Views and Functions/3. sys.dm_db_missing_index_details.srt 9.43KB
  533. 49. Session 7 - Dynamic Management Views and Functions/4. Conclusion.mp4 9.45MB
  534. 49. Session 7 - Dynamic Management Views and Functions/4. Conclusion.srt 2.93KB
  535. 5. Session 1 - String data types and functions/1. Strings.mp4 123.32MB
  536. 5. Session 1 - String data types and functions/1. Strings.srt 18.77KB
  537. 5. Session 1 - String data types and functions/10. Joining numbers to strings.html 162B
  538. 5. Session 1 - String data types and functions/11. Practice Activity Number 5.html 620B
  539. 5. Session 1 - String data types and functions/11.1 Practice-Activity-Number-5-Hints.txt 296B
  540. 5. Session 1 - String data types and functions/12. Practice Activity Number 5 - The Solution.html 504B
  541. 5. Session 1 - String data types and functions/2. Strings.html 162B
  542. 5. Session 1 - String data types and functions/3. String Functions - extraction.mp4 57.61MB
  543. 5. Session 1 - String data types and functions/3. String Functions - extraction.srt 9.30KB
  544. 5. Session 1 - String data types and functions/4. TRIM.html 287B
  545. 5. Session 1 - String data types and functions/5. String Functions - extraction.html 162B
  546. 5. Session 1 - String data types and functions/6. NULL - an introduction.mp4 67.71MB
  547. 5. Session 1 - String data types and functions/6. NULL - an introduction.srt 11.26KB
  548. 5. Session 1 - String data types and functions/7. Joining two strings together.mp4 97.31MB
  549. 5. Session 1 - String data types and functions/7. Joining two strings together.srt 15.93KB
  550. 5. Session 1 - String data types and functions/8. NULL.html 162B
  551. 5. Session 1 - String data types and functions/9. Joining a string to a number.mp4 70.50MB
  552. 5. Session 1 - String data types and functions/9. Joining a string to a number.srt 10.66KB
  553. 50. Session 7 - Evaluate the use of row-based operations vs. set-based operations/1. How to write a cursor.mp4 68.73MB
  554. 50. Session 7 - Evaluate the use of row-based operations vs. set-based operations/1. How to write a cursor.srt 14.08KB
  555. 50. Session 7 - Evaluate the use of row-based operations vs. set-based operations/2. Disadvantages.mp4 61.46MB
  556. 50. Session 7 - Evaluate the use of row-based operations vs. set-based operations/2. Disadvantages.srt 10.95KB
  557. 50. Session 7 - Evaluate the use of row-based operations vs. set-based operations/3. Alternatives.mp4 32.07MB
  558. 50. Session 7 - Evaluate the use of row-based operations vs. set-based operations/3. Alternatives.srt 5.02KB
  559. 50. Session 7 - Evaluate the use of row-based operations vs. set-based operations/4. Impact of scalar UDFs.mp4 110.99MB
  560. 50. Session 7 - Evaluate the use of row-based operations vs. set-based operations/4. Impact of scalar UDFs.srt 14.73KB
  561. 50. Session 7 - Evaluate the use of row-based operations vs. set-based operations/5. Combine multiple DML operations.mp4 12.35MB
  562. 50. Session 7 - Evaluate the use of row-based operations vs. set-based operations/5. Combine multiple DML operations.srt 5.68KB
  563. 51. Congratulations/1. You have finished this course - now what.mp4 102.79MB
  564. 51. Congratulations/1. You have finished this course - now what.srt 15.41KB
  565. 51. Congratulations/2. Bonus Lecture.mp4 24.66MB
  566. 51. Congratulations/2. Bonus Lecture.srt 5.41KB
  567. 51. Congratulations/3. Thank you, and goodbye.mp4 22.07MB
  568. 51. Congratulations/3. Thank you, and goodbye.srt 1.71KB
  569. 52/1. Downloading SQL Server back engine - the Developer edition - for free!.mp4 15.55MB
  570. 52/1. Downloading SQL Server back engine - the Developer edition - for free!.srt 13.58KB
  571. 52/2. Installing SQL Server back engine.mp4 31.58MB
  572. 52/2. Installing SQL Server back engine.srt 20.13KB
  573. 52/3. Installing SQL Server Front Engine.mp4 29.67MB
  574. 52/3. Installing SQL Server Front Engine.srt 15.94KB
  575. 52/4. The next step.html 125B
  576. 53/1. Downloading SQL Server back engine - the Developer edition - for free!.mp4 60.29MB
  577. 53/1. Downloading SQL Server back engine - the Developer edition - for free!.srt 10.29KB
  578. 53/2. Mount an ISO.html 325B
  579. 53/3. Installing SQL Server 2014.mp4 79.91MB
  580. 53/3. Installing SQL Server 2014.srt 13.86KB
  581. 6. Session 1 - Date data types and functions/1. Date data types.mp4 64.09MB
  582. 6. Session 1 - Date data types and functions/1. Date data types.srt 10.76KB
  583. 6. Session 1 - Date data types and functions/2. Using a computer language other than English.html 1012B
  584. 6. Session 1 - Date data types and functions/3. Setting dates and Date extraction.mp4 54.87MB
  585. 6. Session 1 - Date data types and functions/3. Setting dates and Date extraction.srt 8.02KB
  586. 6. Session 1 - Date data types and functions/4. Date data types.html 162B
  587. 6. Session 1 - Date data types and functions/5. Today's date, and more date functions.mp4 64.08MB
  588. 6. Session 1 - Date data types and functions/5. Today's date, and more date functions.srt 10.44KB
  589. 6. Session 1 - Date data types and functions/6. Today's date and more date functions.html 162B
  590. 6. Session 1 - Date data types and functions/7. Date offset.mp4 86.60MB
  591. 6. Session 1 - Date data types and functions/7. Date offset.srt 13.38KB
  592. 6. Session 1 - Date data types and functions/8. Converting from date to strings.mp4 100.09MB
  593. 6. Session 1 - Date data types and functions/8. Converting from date to strings.srt 14.25KB
  594. 6. Session 1 - Date data types and functions/9. Converting from date to strings.html 162B
  595. 7. Session 1 - Conclusion/1. BONUS - Review what you have learnt (PDF).html 240B
  596. 7. Session 1 - Conclusion/1.1 70-461-Session-1-190819.docx 25.92KB
  597. 7. Session 1 - Conclusion/2. Well done!.mp4 39.95MB
  598. 7. Session 1 - Conclusion/2. Well done!.srt 3.23KB
  599. 8. Welcome to Session 2/1. Introduction.mp4 72.42MB
  600. 8. Welcome to Session 2/1. Introduction.srt 3.35KB
  601. 8. Welcome to Session 2/2. Spreadsheet Data.html 427B
  602. 8. Welcome to Session 2/2.1 70 461data.xlsx 81.49KB
  603. 8. Welcome to Session 2/2.2 70-461dataZIPFile.zip 74.44KB
  604. 8. Welcome to Session 2/2.3 70-461datau.xlsx 81.49KB
  605. 8. Welcome to Session 2/3. Session 2 Resources.html 722B
  606. 8. Welcome to Session 2/3.1 70-461-Session-2-150703 ZIPFile.zip 28.50KB
  607. 8. Welcome to Session 2/3.2 70 461 Session 2 150703.docx 31.62KB
  608. 9. Session 2 - Creating and querying part of a table/1. Creation of tblEmployee table.mp4 94.74MB
  609. 9. Session 2 - Creating and querying part of a table/1. Creation of tblEmployee table.srt 17.23KB
  610. 9. Session 2 - Creating and querying part of a table/2. Adding additional columns.mp4 104.04MB
  611. 9. Session 2 - Creating and querying part of a table/2. Adding additional columns.srt 15.72KB
  612. 9. Session 2 - Creating and querying part of a table/3. SELECTing only part of a table - strings.mp4 165.10MB
  613. 9. Session 2 - Creating and querying part of a table/3. SELECTing only part of a table - strings.srt 18.01KB
  614. 9. Session 2 - Creating and querying part of a table/4. SELECTing only part of a table - strings.html 161B
  615. 9. Session 2 - Creating and querying part of a table/5. SELECTing only part of a table - numbers.mp4 103.72MB
  616. 9. Session 2 - Creating and querying part of a table/5. SELECTing only part of a table - numbers.srt 12.06KB
  617. 9. Session 2 - Creating and querying part of a table/6. SELECTing only part of a table - numbers.html 161B
  618. [Tutorialsplanet.NET].url 128B