589689.xyz

Oracle SQL Performance Tuning Masterclass 2019

  • 收录时间:2019-12-27 17:31:55
  • 文件大小:6GB
  • 下载次数:99
  • 最近下载:2020-12-24 13:22:09
  • 磁力链接:
立即下载 复制链接

文件列表

  1. 10. SQL Tuning Techniques/2. Ways of Getting the Execution Plan and the Statistics.mp4 187MB
  2. 10. SQL Tuning Techniques/1. How to find a performance problem and its tuning solution.mp4 174MB
  3. 12. Appendix Software Installations/2. Option 1 Having The Database with Oracle VirtualBox.mp4 164MB
  4. 6. Table & Index Access Paths/2. Types of Table and Index Access Paths.mp4 162MB
  5. 4. SQL Tuning Basics/14. Query Analysis Strategy.mp4 150MB
  6. 6. Table & Index Access Paths/14. Index Skip Scan.mp4 148MB
  7. 9. Other Optimizer Operators/5. Clusters.mp4 144MB
  8. 6. Table & Index Access Paths/1. What are Indexes and How They work in details.mp4 141MB
  9. 3. Oracle Database Architecture/2. Oracle Database Architecture Overview (Part 1).mp4 140MB
  10. 7. Optimizer Hints/2. How to use Hints.mp4 130MB
  11. 10. SQL Tuning Techniques/3. Using the Real-Time SQL Monitoring Tool Part 1.mp4 121MB
  12. 8. Join Operations/2. Nested Loop Joins.mp4 117MB
  13. 5. Execution Plans & Statistics/8. Autotrace.mp4 113MB
  14. 5. Execution Plans & Statistics/12. Reading the Execution Plans (Part 1).mp4 111MB
  15. 5. Execution Plans & Statistics/6. Generating Execution Plan.mp4 110MB
  16. 5. Execution Plans & Statistics/10. V$SQL_PLAN View.mp4 109MB
  17. 9. Other Optimizer Operators/1. Result Cache Operator.mp4 107MB
  18. 12. Appendix Software Installations/3. Option 2 Downloading And Installing Oracle Database.mp4 105MB
  19. 5. Execution Plans & Statistics/4. Generating Statistics (Part 3).mp4 105MB
  20. 8. Join Operations/6. Hash Joins.mp4 102MB
  21. 8. Join Operations/4. Sort Merge Joins.mp4 99MB
  22. 6. Table & Index Access Paths/8. Index Range Scan.mp4 99MB
  23. 4. SQL Tuning Basics/13. SQL Tuning Principles and Strategies.mp4 96MB
  24. 4. SQL Tuning Basics/5. How an SQL Statement is Processed.mp4 95MB
  25. 5. Execution Plans & Statistics/15. Analyzing the Execution Plans.mp4 94MB
  26. 6. Table & Index Access Paths/10. Index Full Scan.mp4 93MB
  27. 6. Table & Index Access Paths/3. Table Access Full.mp4 91MB
  28. 8. Join Operations/13. Outer Joins.mp4 90MB
  29. 3. Oracle Database Architecture/3. Oracle Database Architecture Overview (Part 2).mp4 88MB
  30. 4. SQL Tuning Basics/3. Effective Schema Design.mp4 88MB
  31. 4. SQL Tuning Basics/8. Query Transformer.mp4 87MB
  32. 12. Appendix Software Installations/6. Configuring and Using SQL Developer.mp4 83MB
  33. 5. Execution Plans & Statistics/3. Generating Statistics (Part 2).mp4 80MB
  34. 4. SQL Tuning Basics/9. Selectivity & Cardinality.mp4 79MB
  35. 4. SQL Tuning Basics/4. Table Partitioning.mp4 75MB
  36. 3. Oracle Database Architecture/4. Database Data Blocks in Detail.mp4 74MB
  37. 9. Other Optimizer Operators/7. Sort Operators.mp4 69MB
  38. 3. Oracle Database Architecture/13. Logical and Physical Database Structure.mp4 68MB
  39. 5. Execution Plans & Statistics/1. Execution Plan and Explain Plan in Details.mp4 68MB
  40. 4. SQL Tuning Basics/1. When to Tune.mp4 67MB
  41. 2. What is SQL (Performance) Tuning and Why We Need/2. What to Know Before Starting the Course.mp4 67MB
  42. 3. Oracle Database Architecture/6. What is Shared Pool.mp4 67MB
  43. 9. Other Optimizer Operators/3. View Operator.mp4 64MB
  44. 12. Appendix Software Installations/4. Installing SH Schema.mp4 63MB
  45. 8. Join Operations/8. Cartesian Joins.mp4 62MB
  46. 3. Oracle Database Architecture/5. What is PGA.mp4 62MB
  47. 1. SQL & Perfomance Tuning Course Introduction/1. SQL & Performance Tuning Course Overview.mp4 62MB
  48. 5. Execution Plans & Statistics/2. Generating Statistics (Part 1).mp4 62MB
  49. 8. Join Operations/1. Join Methods Overview.mp4 61MB
  50. 6. Table & Index Access Paths/12. Index Fast Full Scan.mp4 61MB
  51. 5. Execution Plans & Statistics/13. Reading the Execution Plans (Part 2).mp4 60MB
  52. 2. What is SQL (Performance) Tuning and Why We Need/1. What is SQL Tuning and Why to Do That.mp4 60MB
  53. 6. Table & Index Access Paths/5. Table Access by ROWID.mp4 59MB
  54. 3. Oracle Database Architecture/7. What is Buffer Cache.mp4 57MB
  55. 4. SQL Tuning Basics/2. What is a Bad SQL.mp4 56MB
  56. 12. Appendix Software Installations/1. About the Installation.mp4 54MB
  57. 4. SQL Tuning Basics/6. Why do we need the Optimizer.mp4 52MB
  58. 8. Join Operations/15. Semijoins.mp4 51MB
  59. 6. Table & Index Access Paths/16. Index Join Scan.mp4 51MB
  60. 1. SQL & Perfomance Tuning Course Introduction/2. UDEMY 101 How to Use Udemy +Some Useful Tips.mp4 51MB
  61. 3. Oracle Database Architecture/10. How a DML is processed and committed.mp4 50MB
  62. 3. Oracle Database Architecture/8. What is Redo Log Buffer.mp4 47MB
  63. 3. Oracle Database Architecture/12. Oracle Database Storage Architecture.mp4 47MB
  64. 9. Other Optimizer Operators/21. Intersect Operator.mp4 45MB
  65. 4. SQL Tuning Basics/10. What is cost in detail.mp4 44MB
  66. 6. Table & Index Access Paths/7. Index Unique Scan.mp4 43MB
  67. 9. Other Optimizer Operators/9. INLIST Operator.mp4 43MB
  68. 3. Oracle Database Architecture/9. What is Undo.mp4 43MB
  69. 7. Optimizer Hints/1. What are Hints and Why to Use Them.mp4 43MB
  70. 4. SQL Tuning Basics/11. Plan Generator.mp4 38MB
  71. 3. Oracle Database Architecture/1. Why to know the Oracle Database Architecture and how much to know.mp4 37MB
  72. 4. SQL Tuning Basics/12. Row Source Generator.mp4 36MB
  73. 8. Join Operations/11. Equijoins & Nonequijoins.mp4 35MB
  74. 8. Join Operations/10. Join Types Overview.mp4 34MB
  75. 9. Other Optimizer Operators/13. First Row Operator.mp4 32MB
  76. 4. SQL Tuning Basics/7. Optimizer Overview.mp4 31MB
  77. 8. Join Operations/17. Antijoins.mp4 31MB
  78. 3. Oracle Database Architecture/11. Automatic Memory Management.mp4 23MB
  79. 9. Other Optimizer Operators/11. Count Stopkey Operator.mp4 20MB
  80. 9. Other Optimizer Operators/17. Concatenation Operator.mp4 19MB
  81. 9. Other Optimizer Operators/19. UNION Operators.mp4 19MB
  82. 9. Other Optimizer Operators/23. Minus Operator.mp4 15MB
  83. 12. Appendix Software Installations/4.1 sample_schemas.zip.zip 14MB
  84. 9. Other Optimizer Operators/15. Filter Operator.mp4 9MB
  85. 1. SQL & Perfomance Tuning Course Introduction/3.1 (Oracle Master) SQL & Performance Tuning Document.pdf.pdf 5MB
  86. 12. Appendix Software Installations/2.4 Oracle Master Changing Virtual Machine Keyboard Input Settings (SQL Tuning Masterclass).pdf.pdf 877KB
  87. 7. Optimizer Hints/4.1 HINTS Working Document for our Students(Oracle Master).pdf.pdf 288KB
  88. 2. What is SQL (Performance) Tuning and Why We Need/2. What to Know Before Starting the Course.mp4.jpg 84KB
  89. 10. SQL Tuning Techniques/1. How to find a performance problem and its tuning solution.mp4.jpg 77KB
  90. 10. SQL Tuning Techniques/3. Using the Real-Time SQL Monitoring Tool Part 1.mp4.jpg 76KB
  91. 12. Appendix Software Installations/4.2 sh_installation_codes.pdf.pdf 51KB
  92. 13. Bonus (+) Section/1.1 Oracle Master Training (Special Discounts for Our Students).xlsx.xlsx 36KB
  93. 10. SQL Tuning Techniques/2. Ways of Getting the Execution Plan and the Statistics.vtt 18KB
  94. 10. SQL Tuning Techniques/1. How to find a performance problem and its tuning solution.vtt 16KB
  95. 4. SQL Tuning Basics/14. Query Analysis Strategy.vtt 15KB
  96. 7. Optimizer Hints/2. How to use Hints.vtt 15KB
  97. 9. Other Optimizer Operators/5. Clusters.vtt 15KB
  98. 5. Execution Plans & Statistics/12. Reading the Execution Plans (Part 1).vtt 14KB
  99. 6. Table & Index Access Paths/14. Index Skip Scan.vtt 13KB
  100. 5. Execution Plans & Statistics/8. Autotrace.vtt 12KB
  101. 8. Join Operations/2. Nested Loop Joins.vtt 12KB
  102. 6. Table & Index Access Paths/2. Types of Table and Index Access Paths.vtt 12KB
  103. 5. Execution Plans & Statistics/6. Generating Execution Plan.vtt 12KB
  104. 9. Other Optimizer Operators/1. Result Cache Operator.vtt 12KB
  105. 5. Execution Plans & Statistics/10. V$SQL_PLAN View.vtt 12KB
  106. 10. SQL Tuning Techniques/3. Using the Real-Time SQL Monitoring Tool Part 1.vtt 12KB
  107. 8. Join Operations/6. Hash Joins.vtt 11KB
  108. 12. Appendix Software Installations/2. Option 1 Having The Database with Oracle VirtualBox.vtt 11KB
  109. 8. Join Operations/13. Outer Joins.vtt 11KB
  110. 6. Table & Index Access Paths/1. What are Indexes and How They work in details.vtt 11KB
  111. 5. Execution Plans & Statistics/13. Reading the Execution Plans (Part 2).vtt 10KB
  112. 4. SQL Tuning Basics/5. How an SQL Statement is Processed.vtt 10KB
  113. 3. Oracle Database Architecture/2. Oracle Database Architecture Overview (Part 1).vtt 10KB
  114. 6. Table & Index Access Paths/8. Index Range Scan.vtt 10KB
  115. 8. Join Operations/4. Sort Merge Joins.vtt 10KB
  116. 4. SQL Tuning Basics/8. Query Transformer.vtt 10KB
  117. 4. SQL Tuning Basics/3. Effective Schema Design.vtt 10KB
  118. 6. Table & Index Access Paths/10. Index Full Scan.vtt 10KB
  119. 3. Oracle Database Architecture/4. Database Data Blocks in Detail.vtt 9KB
  120. 5. Execution Plans & Statistics/4. Generating Statistics (Part 3).vtt 9KB
  121. 12. Appendix Software Installations/6. Configuring and Using SQL Developer.vtt 9KB
  122. 4. SQL Tuning Basics/13. SQL Tuning Principles and Strategies.vtt 9KB
  123. 4. SQL Tuning Basics/1. When to Tune.vtt 9KB
  124. 5. Execution Plans & Statistics/15. Analyzing the Execution Plans.vtt 8KB
  125. 6. Table & Index Access Paths/3. Table Access Full.vtt 8KB
  126. 4. SQL Tuning Basics/9. Selectivity & Cardinality.vtt 8KB
  127. 12. Appendix Software Installations/3. Option 2 Downloading And Installing Oracle Database.vtt 8KB
  128. 5. Execution Plans & Statistics/3. Generating Statistics (Part 2).vtt 8KB
  129. 5. Execution Plans & Statistics/1. Execution Plan and Explain Plan in Details.vtt 8KB
  130. 4. SQL Tuning Basics/4. Table Partitioning.vtt 8KB
  131. 3. Oracle Database Architecture/6. What is Shared Pool.vtt 7KB
  132. 9. Other Optimizer Operators/7. Sort Operators.vtt 7KB
  133. 9. Other Optimizer Operators/3. View Operator.vtt 7KB
  134. 2. What is SQL (Performance) Tuning and Why We Need/2. What to Know Before Starting the Course.vtt 7KB
  135. 2. What is SQL (Performance) Tuning and Why We Need/1. What is SQL Tuning and Why to Do That.vtt 7KB
  136. 5. Execution Plans & Statistics/2. Generating Statistics (Part 1).vtt 7KB
  137. 3. Oracle Database Architecture/13. Logical and Physical Database Structure.vtt 7KB
  138. 8. Join Operations/8. Cartesian Joins.vtt 7KB
  139. 3. Oracle Database Architecture/3. Oracle Database Architecture Overview (Part 2).vtt 7KB
  140. 4. SQL Tuning Basics/6. Why do we need the Optimizer.vtt 6KB
  141. 6. Table & Index Access Paths/12. Index Fast Full Scan.vtt 6KB
  142. 3. Oracle Database Architecture/7. What is Buffer Cache.vtt 6KB
  143. 6. Table & Index Access Paths/5. Table Access by ROWID.vtt 6KB
  144. 3. Oracle Database Architecture/5. What is PGA.vtt 6KB
  145. 12. Appendix Software Installations/4. Installing SH Schema.vtt 6KB
  146. 1. SQL & Perfomance Tuning Course Introduction/1. SQL & Performance Tuning Course Overview.vtt 6KB
  147. 4. SQL Tuning Basics/2. What is a Bad SQL.vtt 6KB
  148. 8. Join Operations/15. Semijoins.vtt 6KB
  149. 6. Table & Index Access Paths/16. Index Join Scan.vtt 6KB
  150. 1. SQL & Perfomance Tuning Course Introduction/2. UDEMY 101 How to Use Udemy +Some Useful Tips.vtt 5KB
  151. 9. Other Optimizer Operators/13. First Row Operator.vtt 5KB
  152. 8. Join Operations/1. Join Methods Overview.vtt 5KB
  153. 9. Other Optimizer Operators/21. Intersect Operator.vtt 5KB
  154. 4. SQL Tuning Basics/10. What is cost in detail.vtt 5KB
  155. 3. Oracle Database Architecture/10. How a DML is processed and committed.vtt 5KB
  156. 6. Table & Index Access Paths/7. Index Unique Scan.vtt 5KB
  157. 3. Oracle Database Architecture/8. What is Redo Log Buffer.vtt 5KB
  158. 9. Other Optimizer Operators/9. INLIST Operator.vtt 4KB
  159. 3. Oracle Database Architecture/12. Oracle Database Storage Architecture.vtt 4KB
  160. 3. Oracle Database Architecture/9. What is Undo.vtt 4KB
  161. 4. SQL Tuning Basics/11. Plan Generator.vtt 4KB
  162. 7. Optimizer Hints/1. What are Hints and Why to Use Them.vtt 4KB
  163. 12. Appendix Software Installations/5. How to Install VirtualBox on Mac OSX.html 4KB
  164. 4. SQL Tuning Basics/7. Optimizer Overview.vtt 4KB
  165. 4. SQL Tuning Basics/12. Row Source Generator.vtt 4KB
  166. 8. Join Operations/11. Equijoins & Nonequijoins.vtt 4KB
  167. 12. Appendix Software Installations/1. About the Installation.vtt 4KB
  168. 9. Other Optimizer Operators/11. Count Stopkey Operator.vtt 4KB
  169. 9. Other Optimizer Operators/17. Concatenation Operator.vtt 3KB
  170. 8. Join Operations/17. Antijoins.vtt 3KB
  171. 8. Join Operations/10. Join Types Overview.vtt 3KB
  172. 9. Other Optimizer Operators/19. UNION Operators.vtt 3KB
  173. 3. Oracle Database Architecture/1. Why to know the Oracle Database Architecture and how much to know.vtt 3KB
  174. 7. Optimizer Hints/3. How to use Hints (Code Samples).html 3KB
  175. 13. Bonus (+) Section/1. Bonus Lecture for Our Students.html 2KB
  176. 3. Oracle Database Architecture/11. Automatic Memory Management.vtt 2KB
  177. 9. Other Optimizer Operators/23. Minus Operator.vtt 2KB
  178. 6. Table & Index Access Paths/11. Index Full Scan (Code Samples).html 2KB
  179. 9. Other Optimizer Operators/15. Filter Operator.vtt 2KB
  180. 9. Other Optimizer Operators/4. CODE View Operator.html 2KB
  181. 9. Other Optimizer Operators/6. CODE Clusters.html 1KB
  182. 1. SQL & Perfomance Tuning Course Introduction/3. Welcome! +Course Notes.html 1KB
  183. 8. Join Operations/14. CODE Outer Joins.html 1KB
  184. 5. Execution Plans & Statistics/5. Generating Statistics (Code Samples).html 1KB
  185. 6. Table & Index Access Paths/9. Index Range Scan (Code Samples).html 1KB
  186. 8. Join Operations/3. Nested Loop Join (Code Samples).html 1KB
  187. 5. Execution Plans & Statistics/11. V$SQL_PLAN (Code Samples).html 909B
  188. 6. Table & Index Access Paths/13. Index Fast Full Scan (Code Samples).html 869B
  189. 6. Table & Index Access Paths/15. Index Skip Scan (Code Samples).html 824B
  190. 8. Join Operations/5. Sort Merge Join (Code Samples).html 820B
  191. 9. Other Optimizer Operators/10. CODE INLIST Operator.html 742B
  192. 9. Other Optimizer Operators/2. CODE Result Cache Operator.html 685B
  193. 8. Join Operations/18. CODE Antijoins.html 676B
  194. 1. SQL & Perfomance Tuning Course Introduction/ReadMe.txt 669B
  195. ReadMe.txt 669B
  196. 9. Other Optimizer Operators/22. CODE Intersect Operator.html 607B
  197. 5. Execution Plans & Statistics/16. Analyzing the Execution Plans (Code Samples).html 547B
  198. 7. Optimizer Hints/4. List of Some Useful Hints.html 516B
  199. 6. Table & Index Access Paths/4. Table Access Full (Code Samples).html 444B
  200. 11. Important Information - For Your Attention!/1. Good news!.html 423B
  201. 8. Join Operations/16. CODE Semijoins.html 401B
  202. 9. Other Optimizer Operators/8. CODE Sort Operators.html 393B
  203. 6. Table & Index Access Paths/17. Index Join Scan (Code Samples).html 379B
  204. 9. Other Optimizer Operators/14. CODE First Row Operator.html 375B
  205. 9. Other Optimizer Operators/24. CODE Minus Operator.html 369B
  206. 5. Execution Plans & Statistics/7. Generating Execution Plan (Code Samples).html 354B
  207. Visit Getnewcourses.com.url 343B
  208. Visit Freecourseit.com.url 342B
  209. 8. Join Operations/7. CODE Hash Joins.html 340B
  210. 5. Execution Plans & Statistics/9. Autotrace (Code Samples).html 313B
  211. 5. Execution Plans & Statistics/14. Reading the Execution Plans (Code Samples).html 303B
  212. 6. Table & Index Access Paths/6. Table Access by ROWID (Code Samples).html 284B
  213. 10. SQL Tuning Techniques/4. Rest is On Production. Will be ready soon!.html 274B
  214. 10. SQL Tuning Techniques/1. How to find a performance problem and its tuning solution.txt 260B
  215. 8. Join Operations/12. CODE Equijoins & Nonequijoins.html 259B
  216. 9. Other Optimizer Operators/20. CODE Union Operators.html 258B
  217. 10. SQL Tuning Techniques/3. Using the Real-Time SQL Monitoring Tool Part 1.txt 249B
  218. 2. What is SQL (Performance) Tuning and Why We Need/2. What to Know Before Starting the Course.txt 240B
  219. 9. Other Optimizer Operators/12. CODE Count Stopkey Operator.html 210B
  220. 9. Other Optimizer Operators/18. CODE Concatenation Operator.html 199B
  221. 12. Appendix Software Installations/2.2 Linux Operating System Username and Password.txt.txt 185B
  222. 9. Other Optimizer Operators/16. CODE Filter Operator.html 143B
  223. 12. Appendix Software Installations/2.3 Step 2 Download Virtual Machine Image Link.html 141B
  224. 3. Oracle Database Architecture/14. Quiz - Database Architecture.html 141B
  225. 4. SQL Tuning Basics/15. SQL Tuning Basics Assessment Test.html 141B
  226. 5. Execution Plans & Statistics/17. Execution Plans & Statistics.html 141B
  227. 6. Table & Index Access Paths/18. Table & Index Access Paths.html 141B
  228. 8. Join Operations/9. CODE Cartesian Joins.html 139B
  229. 12. Appendix Software Installations/2.1 Step 1 Download Oracle Virtual Box.html 136B