Oracle SQL Performance Tuning Masterclass 2019

1. 1. SQL & Perfomance Tuning Course Introduction/1. SQL & Performance Tuning Course Overview.mp462.11MB
2. 1. SQL & Perfomance Tuning Course Introduction/2. UDEMY 101 How to Use Udemy +Some Useful Tips.mp450.62MB
3. 10. SQL Tuning Techniques/2. Ways of Getting the Execution Plan and the Statistics.mp4187.2MB
4. 10. SQL Tuning Techniques/1. How to find a performance problem and its tuning solution.mp4173.57MB
5. 10. SQL Tuning Techniques/3. Using the Real-Time SQL Monitoring Tool Part 1.mp4120.72MB
6. 12. Appendix Software Installations/2. Option 1 Having The Database with Oracle VirtualBox.mp4164.33MB
7. 12. Appendix Software Installations/3. Option 2 Downloading And Installing Oracle Database.mp4105.49MB
8. 12. Appendix Software Installations/6. Configuring and Using SQL Developer.mp482.98MB
9. 12. Appendix Software Installations/4. Installing SH Schema.mp462.91MB
10. 12. Appendix Software Installations/1. About the Installation.mp453.81MB
11. 2. What is SQL (Performance) Tuning and Why We Need/2. What to Know Before Starting the Course.mp466.72MB
12. 2. What is SQL (Performance) Tuning and Why We Need/1. What is SQL Tuning and Why to Do That.mp459.63MB
13. 3. Oracle Database Architecture/2. Oracle Database Architecture Overview (Part 1).mp4139.67MB
14. 3. Oracle Database Architecture/3. Oracle Database Architecture Overview (Part 2).mp488.03MB
15. 3. Oracle Database Architecture/4. Database Data Blocks in Detail.mp474.47MB
16. 3. Oracle Database Architecture/13. Logical and Physical Database Structure.mp467.76MB
17. 3. Oracle Database Architecture/6. What is Shared Pool.mp466.67MB
18. 3. Oracle Database Architecture/5. What is PGA.mp462.36MB
19. 3. Oracle Database Architecture/7. What is Buffer Cache.mp457.23MB
20. 3. Oracle Database Architecture/10. How a DML is processed and committed.mp450.39MB
21. 3. Oracle Database Architecture/8. What is Redo Log Buffer.mp447.2MB
22. 3. Oracle Database Architecture/12. Oracle Database Storage Architecture.mp446.81MB
23. 3. Oracle Database Architecture/9. What is Undo.mp442.84MB
24. 3. Oracle Database Architecture/1. Why to know the Oracle Database Architecture and how much to know.mp436.82MB
25. 3. Oracle Database Architecture/11. Automatic Memory Management.mp422.55MB
26. 4. SQL Tuning Basics/14. Query Analysis Strategy.mp4150.21MB
27. 4. SQL Tuning Basics/13. SQL Tuning Principles and Strategies.mp496.27MB
28. 4. SQL Tuning Basics/5. How an SQL Statement is Processed.mp495.12MB
29. 4. SQL Tuning Basics/3. Effective Schema Design.mp488.02MB
30. 4. SQL Tuning Basics/8. Query Transformer.mp486.56MB
31. 4. SQL Tuning Basics/9. Selectivity & Cardinality.mp479.12MB
32. 4. SQL Tuning Basics/4. Table Partitioning.mp474.81MB
33. 4. SQL Tuning Basics/1. When to Tune.mp467.23MB
34. 4. SQL Tuning Basics/2. What is a Bad SQL.mp455.55MB
35. 4. SQL Tuning Basics/6. Why do we need the Optimizer.mp452.29MB
36. 4. SQL Tuning Basics/10. What is cost in detail.mp444.42MB
37. 4. SQL Tuning Basics/11. Plan Generator.mp437.89MB
38. 4. SQL Tuning Basics/12. Row Source Generator.mp436.48MB
39. 4. SQL Tuning Basics/7. Optimizer Overview.mp431.09MB
40. 5. Execution Plans & Statistics/8. Autotrace.mp4112.51MB
41. 5. Execution Plans & Statistics/12. Reading the Execution Plans (Part 1).mp4110.73MB
42. 5. Execution Plans & Statistics/6. Generating Execution Plan.mp4109.77MB
43. 5. Execution Plans & Statistics/10. V$SQL_PLAN View.mp4109.35MB
44. 5. Execution Plans & Statistics/4. Generating Statistics (Part 3).mp4104.78MB
45. 5. Execution Plans & Statistics/15. Analyzing the Execution Plans.mp493.85MB
46. 5. Execution Plans & Statistics/3. Generating Statistics (Part 2).mp479.99MB
47. 5. Execution Plans & Statistics/1. Execution Plan and Explain Plan in Details.mp467.67MB
48. 5. Execution Plans & Statistics/2. Generating Statistics (Part 1).mp462.02MB
49. 5. Execution Plans & Statistics/13. Reading the Execution Plans (Part 2).mp459.94MB
50. 6. Table & Index Access Paths/2. Types of Table and Index Access Paths.mp4161.58MB
51. 6. Table & Index Access Paths/14. Index Skip Scan.mp4148.1MB
52. 6. Table & Index Access Paths/1. What are Indexes and How They work in details.mp4141.08MB
53. 6. Table & Index Access Paths/8. Index Range Scan.mp499.38MB
54. 6. Table & Index Access Paths/10. Index Full Scan.mp492.55MB
55. 6. Table & Index Access Paths/3. Table Access Full.mp491.36MB
56. 6. Table & Index Access Paths/12. Index Fast Full Scan.mp460.63MB
57. 6. Table & Index Access Paths/5. Table Access by ROWID.mp458.67MB
58. 6. Table & Index Access Paths/16. Index Join Scan.mp450.79MB
59. 6. Table & Index Access Paths/7. Index Unique Scan.mp443.49MB
60. 7. Optimizer Hints/2. How to use Hints.mp4130.4MB
61. 7. Optimizer Hints/1. What are Hints and Why to Use Them.mp442.74MB
62. 8. Join Operations/2. Nested Loop Joins.mp4117.11MB
63. 8. Join Operations/6. Hash Joins.mp4102.26MB
64. 8. Join Operations/4. Sort Merge Joins.mp499.42MB
65. 8. Join Operations/13. Outer Joins.mp490.27MB
66. 8. Join Operations/8. Cartesian Joins.mp462.49MB
67. 8. Join Operations/1. Join Methods Overview.mp461.35MB
68. 8. Join Operations/15. Semijoins.mp451.45MB
69. 8. Join Operations/11. Equijoins & Nonequijoins.mp434.91MB
70. 8. Join Operations/10. Join Types Overview.mp433.73MB
71. 8. Join Operations/17. Antijoins.mp430.66MB
72. 9. Other Optimizer Operators/5. Clusters.mp4143.98MB
73. 9. Other Optimizer Operators/1. Result Cache Operator.mp4106.67MB
74. 9. Other Optimizer Operators/7. Sort Operators.mp469.07MB
75. 9. Other Optimizer Operators/3. View Operator.mp463.64MB
76. 9. Other Optimizer Operators/21. Intersect Operator.mp445.4MB
77. 9. Other Optimizer Operators/9. INLIST Operator.mp443.01MB
78. 9. Other Optimizer Operators/13. First Row Operator.mp431.79MB
79. 9. Other Optimizer Operators/11. Count Stopkey Operator.mp419.64MB
80. 9. Other Optimizer Operators/17. Concatenation Operator.mp419.31MB
81. 9. Other Optimizer Operators/19. UNION Operators.mp418.6MB
82. 9. Other Optimizer Operators/23. Minus Operator.mp414.92MB
83. 9. Other Optimizer Operators/15. Filter Operator.mp48.78MB