589689.xyz

[] Udemy - 70-462 SQL Server Database Administration (DBA)

  • 收录时间:2021-04-17 22:10:21
  • 文件大小:4GB
  • 下载次数:1
  • 最近下载:2021-04-17 22:10:21
  • 磁力链接:
立即下载 复制链接

文件列表

  1. 13. Install SQL Server and related services/3. 4a. Set up and configure all SQL Server components, including Visual Studio SSDT.mp4 97MB
  2. 4. Implement and maintain indexes/4. Fragmentation, reorganize and rebuild in SSMS.mp4 96MB
  3. 7. Manage and configure databases/4. 6c. Manage file space, including adding new filegroups and moving objects.mp4 96MB
  4. 2. Backup and Restore - Part 1/7. 13a and 14c. Point in Time Recovery.mp4 94MB
  5. 5. Import and export data/1. Transfer data.mp4 85MB
  6. 8. Compression/1. 6e. Page and Row Data Compression.mp4 84MB
  7. 1. Introduction/6. Downloading and Installing SQL Server Developer Edition.mp4 82MB
  8. 7. Manage and configure databases/7. Partitioning in practice using T-SQL, and testing partitioning.mp4 75MB
  9. 7. Manage and configure databases/11. 6d, 19d. Implement and configure contained databases and logins.mp4 73MB
  10. 2. Backup and Restore - Part 1/12. 13d and 14b. Recover from a corrupted drive.mp4 73MB
  11. 7. Manage and configure databases/6. Partitioning in practice using the GUI.mp4 72MB
  12. 2. Backup and Restore - Part 1/9. Using NORECOVERY and RECOVERY.mp4 72MB
  13. 15/4. 4e. Filetable.mp4 72MB
  14. 2. Backup and Restore - Part 1/2. Looking around SSMS and how to generate T-SQL.mp4 71MB
  15. 7. Manage and configure databases/1. 6b, 7a. Database configuration autoclose, autoshrink, recovery models.mp4 70MB
  16. 6. Manage SQL Server Agent - Part 1/5. 5b. Adding operators to jobs and alerts.mp4 70MB
  17. 11. Audit SQL Server Instances/2. 12e. Monitor elevated privileges as well as unsolicited attempts to connect.mp4 70MB
  18. 10. Collect and analyse troubleshooting data/3. 11b, 11f, 11g, 11h. Collect performance data by using System Monitor.mp4 70MB
  19. 13. Install SQL Server and related services/2. 1b, 2b, 2c, 4a, 4b. Design the installation of SQL Server and its components.mp4 69MB
  20. 15/1. 4b. Configure full-text indexing.mp4 69MB
  21. 9. Identify and resolve concurrency problems/4. 10a. Examine deadlocking issues using the SQL server logs using trace flags.mp4 66MB
  22. 4. Implement and maintain indexes/1. What are indexes.mp4 66MB
  23. 3. Manage logins and server roles/6. User Database-Level Roles.mp4 62MB
  24. 9. Identify and resolve concurrency problems/5. 10g. Know What Affects Performance.mp4 59MB
  25. 2. Backup and Restore - Part 1/11. 13c and 13f. Perform backuprestore based on strategies inc. backup redundancy.mp4 59MB
  26. 3. Manage logins and server roles/2. 17d. Manage access to the server, 17b. secure the SQL server using server roles.mp4 58MB
  27. 4. Implement and maintain indexes/3. Fragmentation - theory.mp4 58MB
  28. 8. Compression/3. 15k. Columnstore Indexes.mp4 58MB
  29. 11. Audit SQL Server Instances/1. 12a. implement a security strategy for auditing; 12c. configure server audits.mp4 57MB
  30. 13. Install SQL Server and related services/1. 9a. Install an instance; 7b. Install Default and named instances.mp4 57MB
  31. 9. Identify and resolve concurrency problems/3. 10c. Monitor via DMV or other MS product; 10e. diagnose waits.mp4 57MB
  32. 9. Identify and resolve concurrency problems/2. 10d. Diagnose deadlocking - practice; 10h. kill processes.mp4 56MB
  33. 2. Backup and Restore - Part 1/3. Backing up Database, and problem with Restoring.mp4 56MB
  34. 7. Manage and configure databases/8. 13e. Manage a multi-TB database; 14d. File group restore.mp4 55MB
  35. 1. Introduction/4. Curriculum.mp4 54MB
  36. 3. Manage logins and server roles/5. 18b. Fixed Database-Level Roles.mp4 54MB
  37. 10. Collect and analyse troubleshooting data/1. 11a, 11c. Collect trace data by using SQL Server Profiler.mp4 53MB
  38. 6. Manage SQL Server Agent - Part 1/1. 5a. Create, maintain and monitor jobs.mp4 52MB
  39. 7. Manage and configure databases/9. 6h. Manage log file growth.mp4 51MB
  40. 15/3. 4d. Filestream.mp4 50MB
  41. 7. Manage and configure databases/5. 6g. Partitioning in theory.srt 49MB
  42. 7. Manage and configure databases/5. 6g. Partitioning in theory.mp4 49MB
  43. 7. Manage and configure databases/3. 6a. Creating database with multiple file groups.mp4 49MB
  44. 3. Manage logins and server roles/3. 17e. Create and maintain user-defined server roles.mp4 49MB
  45. 2. Backup and Restore - Part 1/6. 13a. Different backup models - practice in SSMS.mp4 49MB
  46. 2. Backup and Restore - Part 1/10. 13g and 13h. Back up an SQL Server environment and system databases.mp4 49MB
  47. 11. Audit SQL Server Instances/3. 12b. Configure an audit; 12d. Track who modified an object.mp4 48MB
  48. 2. Backup and Restore - Part 1/1. Restoring a Database.mp4 47MB
  49. 6. Manage SQL Server Agent - Part 1/3. RAISERROR and Create Event Alerts.mp4 46MB
  50. 8. Compression/2. 6e. Sparse columns.mp4 45MB
  51. 7. Manage and configure databases/2. 6a. Design multiple file groups.mp4 44MB
  52. 4. Implement and maintain indexes/7. 15c. Identify unused indexes.mp4 44MB
  53. 3. Manage logins and server roles/7. Creating and Using Schemas.srt 43MB
  54. 3. Manage logins and server roles/7. Creating and Using Schemas.mp4 43MB
  55. 15/2. 4c. SSIS Security.mp4 43MB
  56. 2. Backup and Restore - Part 1/5. 13a. Different backup models - theory.mp4 43MB
  57. 1. Introduction/5.3 Adventure Works 2014 Full Database Backup.zip 43MB
  58. 1. Introduction/7.1 Adventure Works 2014 Full Database Backup.zip 43MB
  59. 13. Install SQL Server and related services/5. 2d. Configure an OS disk.mp4 42MB
  60. 4. Implement and maintain indexes/2. 15d. Implement indexes.mp4 42MB
  61. 3. Manage logins and server roles/1. 17c. Create login accounts.mp4 41MB
  62. 9. Identify and resolve concurrency problems/1. 10d. Diagnose blocking, live locking and deadlocking - theory.mp4 40MB
  63. 12. Plan installation/1. 1l. Choose the right hardware; 1a. Evaluate Installation Requirements.mp4 39MB
  64. 4. Implement and maintain indexes/8. 15h. Statistics (full, filter) force or fix queue.mp4 38MB
  65. 12. Plan installation/4. 1f. Design the storage for new databases.mp4 38MB
  66. 10. Collect and analyse troubleshooting data/2. 11i. Use XEvents (Extended Events).mp4 37MB
  67. 4. Implement and maintain indexes/5. Fill factor.mp4 36MB
  68. 3. Manage logins and server roles/1. 17c. Create login accounts.srt 35MB
  69. 12. Plan installation/3. 1d. Plan for capacity; 1i. Windows-Level and Service Level Security.mp4 35MB
  70. 3. Manage logins and server roles/4. 19c. Create Database User Accounts.mp4 34MB
  71. 2. Backup and Restore - Part 1/4. Changing Recovery Model.mp4 33MB
  72. 7. Manage and configure databases/10. 6i. DBCC.mp4 32MB
  73. 3. Manage logins and server roles/8. Creating access to serverdatabase with least privilege.mp4 31MB
  74. 13. Install SQL Server and related services/4. 2a. Test connectivity.mp4 30MB
  75. 1. Introduction/1. Introduction.mp4 30MB
  76. 6. Manage SQL Server Agent - Part 1/2. 5b. Administer jobs and alerts.mp4 29MB
  77. 14. Implement a migration strategy/2. 3b. Migrate Security.mp4 29MB
  78. 1. Introduction/7. Downloading AdventureWorks.mp4 27MB
  79. 12. Plan installation/2. 1c. Plan Scale-up vs Scale-out basics.mp4 27MB
  80. 6. Manage SQL Server Agent - Part 1/4. What happens when a job runs And running a RAISERROR WITH LOG.mp4 26MB
  81. 4. Implement and maintain indexes/6. 15g. Optimise indexes (full, filter index).mp4 26MB
  82. 16. Well done/1. Bonus Lecture.srt 25MB
  83. 16. Well done/1. Bonus Lecture.mp4 25MB
  84. 5. Import and export data/2. Bulk Insert.mp4 24MB
  85. 14. Implement a migration strategy/4. 3e. Migrate systems and data from other sources.mp4 24MB
  86. 3. Manage logins and server roles/9. 18c. Protect objects from being modified.mp4 24MB
  87. 6. Manage SQL Server Agent - Part 1/6. 11j. Create alerts on critical server condition.mp4 24MB
  88. 14. Implement a migration strategy/3. 3c. Migrate from a previous version; 3d. Migrate to new hardware.mp4 23MB
  89. 1. Introduction/3. The Udemy Interface.mp4 21MB
  90. 1. Introduction/5.4 AdventureWorksDW2014.zip 21MB
  91. 14. Implement a migration strategy/1. 3a. Restore versus detachattach.mp4 20MB
  92. 10. Collect and analyse troubleshooting data/4. 11l. Identify IO v memory v CPU bottlenecks.mp4 19MB
  93. 16. Well done/2. Congratulations.mp4 15MB
  94. 1. Introduction/5.2 DBAT-SQLCode180730.docx 32KB
  95. 4. Implement and maintain indexes/1. What are indexes.srt 22KB
  96. 1. Introduction/5.1 Curriculum180218.docx 21KB
  97. 1. Introduction/6. Downloading and Installing SQL Server Developer Edition.srt 20KB
  98. 8. Compression/1. 6e. Page and Row Data Compression.srt 18KB
  99. 2. Backup and Restore - Part 1/7. 13a and 14c. Point in Time Recovery.srt 17KB
  100. 12. Plan installation/1. 1l. Choose the right hardware; 1a. Evaluate Installation Requirements.srt 16KB
  101. 5. Import and export data/1. Transfer data.srt 16KB
  102. 13. Install SQL Server and related services/3. 4a. Set up and configure all SQL Server components, including Visual Studio SSDT.srt 16KB
  103. 10. Collect and analyse troubleshooting data/3. 11b, 11f, 11g, 11h. Collect performance data by using System Monitor.srt 16KB
  104. 13. Install SQL Server and related services/2. 1b, 2b, 2c, 4a, 4b. Design the installation of SQL Server and its components.srt 16KB
  105. 12. Plan installation/4. 1f. Design the storage for new databases.srt 15KB
  106. 7. Manage and configure databases/4. 6c. Manage file space, including adding new filegroups and moving objects.srt 14KB
  107. 12. Plan installation/2. 1c. Plan Scale-up vs Scale-out basics.srt 14KB
  108. 2. Backup and Restore - Part 1/2. Looking around SSMS and how to generate T-SQL.srt 13KB
  109. 7. Manage and configure databases/1. 6b, 7a. Database configuration autoclose, autoshrink, recovery models.srt 13KB
  110. 2. Backup and Restore - Part 1/12. 13d and 14b. Recover from a corrupted drive.srt 13KB
  111. 2. Backup and Restore - Part 1/5. 13a. Different backup models - theory.srt 13KB
  112. 4. Implement and maintain indexes/4. Fragmentation, reorganize and rebuild in SSMS.srt 13KB
  113. 12. Plan installation/3. 1d. Plan for capacity; 1i. Windows-Level and Service Level Security.srt 13KB
  114. 6. Manage SQL Server Agent - Part 1/5. 5b. Adding operators to jobs and alerts.srt 13KB
  115. 4. Implement and maintain indexes/3. Fragmentation - theory.srt 12KB
  116. 3. Manage logins and server roles/2. 17d. Manage access to the server, 17b. secure the SQL server using server roles.srt 12KB
  117. 3. Manage logins and server roles/6. User Database-Level Roles.srt 12KB
  118. 7. Manage and configure databases/7. Partitioning in practice using T-SQL, and testing partitioning.srt 12KB
  119. 2. Backup and Restore - Part 1/9. Using NORECOVERY and RECOVERY.srt 12KB
  120. 6. Manage SQL Server Agent - Part 1/1. 5a. Create, maintain and monitor jobs.srt 12KB
  121. 2. Backup and Restore - Part 1/1. Restoring a Database.srt 12KB
  122. 2. Backup and Restore - Part 1/11. 13c and 13f. Perform backuprestore based on strategies inc. backup redundancy.srt 12KB
  123. 11. Audit SQL Server Instances/1. 12a. implement a security strategy for auditing; 12c. configure server audits.srt 12KB
  124. 13. Install SQL Server and related services/1. 9a. Install an instance; 7b. Install Default and named instances.srt 12KB
  125. 10. Collect and analyse troubleshooting data/1. 11a, 11c. Collect trace data by using SQL Server Profiler.srt 11KB
  126. 7. Manage and configure databases/11. 6d, 19d. Implement and configure contained databases and logins.srt 11KB
  127. 3. Manage logins and server roles/8. Creating access to serverdatabase with least privilege.srt 10KB
  128. 9. Identify and resolve concurrency problems/1. 10d. Diagnose blocking, live locking and deadlocking - theory.srt 10KB
  129. 7. Manage and configure databases/6. Partitioning in practice using the GUI.srt 10KB
  130. 7. Manage and configure databases/2. 6a. Design multiple file groups.srt 10KB
  131. 3. Manage logins and server roles/3. 17e. Create and maintain user-defined server roles.srt 10KB
  132. 8. Compression/3. 15k. Columnstore Indexes.srt 10KB
  133. 13. Install SQL Server and related services/5. 2d. Configure an OS disk.srt 10KB
  134. 3. Manage logins and server roles/5. 18b. Fixed Database-Level Roles.srt 10KB
  135. 10. Collect and analyse troubleshooting data/2. 11i. Use XEvents (Extended Events).srt 9KB
  136. 1. Introduction/4. Curriculum.srt 9KB
  137. 4. Implement and maintain indexes/2. 15d. Implement indexes.srt 9KB
  138. 7. Manage and configure databases/8. 13e. Manage a multi-TB database; 14d. File group restore.srt 9KB
  139. 15/4. 4e. Filetable.srt 9KB
  140. 11. Audit SQL Server Instances/2. 12e. Monitor elevated privileges as well as unsolicited attempts to connect.srt 9KB
  141. 7. Manage and configure databases/3. 6a. Creating database with multiple file groups.srt 9KB
  142. 2. Backup and Restore - Part 1/3. Backing up Database, and problem with Restoring.srt 9KB
  143. 2. Backup and Restore - Part 1/10. 13g and 13h. Back up an SQL Server environment and system databases.srt 9KB
  144. 9. Identify and resolve concurrency problems/4. 10a. Examine deadlocking issues using the SQL server logs using trace flags.srt 9KB
  145. 9. Identify and resolve concurrency problems/2. 10d. Diagnose deadlocking - practice; 10h. kill processes.srt 9KB
  146. 9. Identify and resolve concurrency problems/5. 10g. Know What Affects Performance.srt 9KB
  147. 15/1. 4b. Configure full-text indexing.srt 9KB
  148. 15/3. 4d. Filestream.srt 8KB
  149. 6. Manage SQL Server Agent - Part 1/3. RAISERROR and Create Event Alerts.srt 8KB
  150. 7. Manage and configure databases/9. 6h. Manage log file growth.srt 8KB
  151. 15/2. 4c. SSIS Security.srt 8KB
  152. 14. Implement a migration strategy/3. 3c. Migrate from a previous version; 3d. Migrate to new hardware.srt 8KB
  153. 3. Manage logins and server roles/4. 19c. Create Database User Accounts.srt 8KB
  154. 10. Collect and analyse troubleshooting data/4. 11l. Identify IO v memory v CPU bottlenecks.srt 8KB
  155. 4. Implement and maintain indexes/5. Fill factor.srt 7KB
  156. 4. Implement and maintain indexes/8. 15h. Statistics (full, filter) force or fix queue.srt 7KB
  157. 8. Compression/2. 6e. Sparse columns.srt 7KB
  158. 11. Audit SQL Server Instances/3. 12b. Configure an audit; 12d. Track who modified an object.srt 7KB
  159. 14. Implement a migration strategy/2. 3b. Migrate Security.srt 7KB
  160. 1. Introduction/7. Downloading AdventureWorks.srt 6KB
  161. 4. Implement and maintain indexes/7. 15c. Identify unused indexes.srt 6KB
  162. 9. Identify and resolve concurrency problems/3. 10c. Monitor via DMV or other MS product; 10e. diagnose waits.srt 6KB
  163. 14. Implement a migration strategy/1. 3a. Restore versus detachattach.srt 6KB
  164. 2. Backup and Restore - Part 1/6. 13a. Different backup models - practice in SSMS.srt 6KB
  165. 6. Manage SQL Server Agent - Part 1/2. 5b. Administer jobs and alerts.srt 5KB
  166. 2. Backup and Restore - Part 1/4. Changing Recovery Model.srt 5KB
  167. 3. Manage logins and server roles/9. 18c. Protect objects from being modified.srt 5KB
  168. 7. Manage and configure databases/10. 6i. DBCC.srt 5KB
  169. 5. Import and export data/2. Bulk Insert.srt 5KB
  170. 14. Implement a migration strategy/4. 3e. Migrate systems and data from other sources.srt 5KB
  171. 6. Manage SQL Server Agent - Part 1/6. 11j. Create alerts on critical server condition.srt 5KB
  172. 13. Install SQL Server and related services/4. 2a. Test connectivity.srt 5KB
  173. 4. Implement and maintain indexes/6. 15g. Optimise indexes (full, filter index).srt 5KB
  174. 6. Manage SQL Server Agent - Part 1/4. What happens when a job runs And running a RAISERROR WITH LOG.srt 4KB
  175. 1. Introduction/3. The Udemy Interface.srt 4KB
  176. 1. Introduction/1. Introduction.srt 2KB
  177. 3. Manage logins and server roles/11. Practice Activity Number 2.html 1KB
  178. 2. Backup and Restore - Part 1/14. Practice Activity Number 1.html 1KB
  179. 16. Well done/2. Congratulations.srt 1KB
  180. 1. Introduction/2. Welcome to Udemy.html 886B
  181. 6. Manage SQL Server Agent - Part 1/8. Practice Activity Number 4.html 885B
  182. 10. Collect and analyse troubleshooting data/6. Practice Activity Number 7.html 830B
  183. 11. Audit SQL Server Instances/5. Practice Activity Number 8.html 731B
  184. 7. Manage and configure databases/13. Practice Activity Number 5.html 598B
  185. 4. Implement and maintain indexes/10. Practice Activity Number 3.html 476B
  186. 8. Compression/5. Practice Activity Number 6.html 416B
  187. 1. Introduction/5. Databases - Resources.html 325B
  188. 13. Install SQL Server and related services/7. Practice Activity 9.html 185B
  189. 10. Collect and analyse troubleshooting data/5. Collect and analyse troubleshooting data.html 156B
  190. 11. Audit SQL Server Instances/4. Audit SQL Server Instances.html 156B
  191. 12. Plan installation/5. Plan Installation.html 156B
  192. 13. Install SQL Server and related services/6. Install SQL Server and related services.html 156B
  193. 14. Implement a migration strategy/5. Implement a migration strategy.html 156B
  194. 15/5. Install SQL Server, related services and additional SQL Server components.html 156B
  195. 2. Backup and Restore - Part 1/13. More backing up questions.html 156B
  196. 2. Backup and Restore - Part 1/8. Recovery and Backup models.html 156B
  197. 3. Manage logins and server roles/10. Manage logins and server roles.html 156B
  198. 4. Implement and maintain indexes/9. Implement and maintain indexes.html 156B
  199. 5. Import and export data/3. Import and Export Data.html 156B
  200. 6. Manage SQL Server Agent - Part 1/7. Manage SQL Server Agent.html 156B
  201. 7. Manage and configure databases/12. Manage and configure databases.html 156B
  202. 8. Compression/4. Compresison.html 156B
  203. 9. Identify and resolve concurrency problems/6. Identify and resolve concurrency problems.html 156B
  204. 1. Introduction/[Tutorialsplanet.NET].url 128B
  205. 8. Compression/[Tutorialsplanet.NET].url 128B
  206. [Tutorialsplanet.NET].url 128B