Name [DesireCourse.Net] Udemy - Oracle SQL Performance Tuning Masterclass 2019

File Type video

Size 6.16GB

UpdateDate 2024-10-11

hash *****C2BF660D4924F1A8E3215B2FA0072C1071

Hot 1

Files 1. SQL & Perfomance Tuning Course Introduction/1. SQL & Performance Tuning Course Overview.mp4 | 62.11MB 1. SQL & Perfomance Tuning Course Introduction/1. SQL & Performance Tuning Course Overview.vtt | 5.71KB 1. SQL & Perfomance Tuning Course Introduction/2. UDEMY 101 How to Use Udemy +Some Useful Tips.mp4 | 50.62MB 1. SQL & Perfomance Tuning Course Introduction/2. UDEMY 101 How to Use Udemy +Some Useful Tips.vtt | 5.40KB 1. SQL & Perfomance Tuning Course Introduction/3. Welcome! +Course Notes.html | 1.09KB 1. SQL & Perfomance Tuning Course Introduction/3.1 (Oracle Master) SQL & Performance Tuning Document.pdf.pdf | 5.15MB 1. SQL & Perfomance Tuning Course Introduction/Must Read.txt | 540B 1. SQL & Perfomance Tuning Course Introduction/Visit Coursedrive.org.url | 124B 10. SQL Tuning Techniques/1. How to find a performance problem and its tuning solution.mp4 | 173.57MB 10. SQL Tuning Techniques/1. How to find a performance problem and its tuning solution.mp4.jpg | 77.08KB 10. SQL Tuning Techniques/1. How to find a performance problem and its tuning solution.txt | 260B 10. SQL Tuning Techniques/1. How to find a performance problem and its tuning solution.vtt | 16.01KB 10. SQL Tuning Techniques/2. Ways of Getting the Execution Plan and the Statistics.mp4 | 187.20MB 10. SQL Tuning Techniques/2. Ways of Getting the Execution Plan and the Statistics.vtt | 17.97KB 10. SQL Tuning Techniques/3. Using the Real-Time SQL Monitoring Tool Part 1.mp4 | 120.72MB 10. SQL Tuning Techniques/3. Using the Real-Time SQL Monitoring Tool Part 1.mp4.jpg | 75.83KB 10. SQL Tuning Techniques/3. Using the Real-Time SQL Monitoring Tool Part 1.txt | 249B 10. SQL Tuning Techniques/3. Using the Real-Time SQL Monitoring Tool Part 1.vtt | 11.55KB 10. SQL Tuning Techniques/4. Rest is On Production. Will be ready soon!.html | 274B 11. Important Information - For Your Attention!/1. Good news!.html | 423B 12. Appendix Software Installations/1. About the Installation.mp4 | 53.81MB 12. Appendix Software Installations/1. About the Installation.vtt | 3.72KB 12. Appendix Software Installations/2. Option 1 Having The Database with Oracle VirtualBox.mp4 | 164.33MB 12. Appendix Software Installations/2. Option 1 Having The Database with Oracle VirtualBox.vtt | 11.30KB 12. Appendix Software Installations/2.1 Step 1 Download Oracle Virtual Box.html | 136B 12. Appendix Software Installations/2.2 Linux Operating System Username and Password.txt.txt | 185B 12. Appendix Software Installations/2.3 Step 2 Download Virtual Machine Image Link.html | 141B 12. Appendix Software Installations/2.4 Oracle Master Changing Virtual Machine Keyboard Input Settings (SQL Tuning Masterclass).pdf.pdf | 876.92KB 12. Appendix Software Installations/3. Option 2 Downloading And Installing Oracle Database.mp4 | 105.49MB 12. Appendix Software Installations/3. Option 2 Downloading And Installing Oracle Database.vtt | 8.29KB 12. Appendix Software Installations/4. Installing SH Schema.mp4 | 62.91MB 12. Appendix Software Installations/4. Installing SH Schema.vtt | 5.92KB 12. Appendix Software Installations/4.1 sample_schemas.zip.zip | 14.03MB 12. Appendix Software Installations/4.2 sh_installation_codes.pdf.pdf | 51.27KB 12. Appendix Software Installations/5. How to Install VirtualBox on Mac OSX.html | 3.80KB 12. Appendix Software Installations/6. Configuring and Using SQL Developer.mp4 | 82.98MB 12. Appendix Software Installations/6. Configuring and Using SQL Developer.vtt | 9.24KB 13. Bonus (+) Section/1. Bonus Lecture for Our Students.html | 2.33KB 13. Bonus (+) Section/1.1 Oracle Master Training (Special Discounts for Our Students).xlsx.xlsx | 35.51KB 13. Bonus (+) Section/ReadMe.txt | 538B 13. Bonus (+) Section/Visit Coursedrive.org.url | 124B 2. What is SQL (Performance) Tuning and Why We Need/1. What is SQL Tuning and Why to Do That.mp4 | 59.63MB 2. What is SQL (Performance) Tuning and Why We Need/1. What is SQL Tuning and Why to Do That.vtt | 6.84KB 2. What is SQL (Performance) Tuning and Why We Need/2. What to Know Before Starting the Course.mp4 | 66.72MB 2. What is SQL (Performance) Tuning and Why We Need/2. What to Know Before Starting the Course.mp4.jpg | 84.16KB 2. What is SQL (Performance) Tuning and Why We Need/2. What to Know Before Starting the Course.txt | 240B 2. What is SQL (Performance) Tuning and Why We Need/2. What to Know Before Starting the Course.vtt | 7.19KB 3. Oracle Database Architecture/1. Why to know the Oracle Database Architecture and how much to know.mp4 | 36.82MB 3. Oracle Database Architecture/1. Why to know the Oracle Database Architecture and how much to know.vtt | 2.86KB 3. Oracle Database Architecture/10. How a DML is processed and committed.mp4 | 50.39MB 3. Oracle Database Architecture/10. How a DML is processed and committed.vtt | 4.76KB 3. Oracle Database Architecture/11. Automatic Memory Management.mp4 | 22.55MB 3. Oracle Database Architecture/11. Automatic Memory Management.vtt | 2.29KB 3. Oracle Database Architecture/12. Oracle Database Storage Architecture.mp4 | 46.81MB 3. Oracle Database Architecture/12. Oracle Database Storage Architecture.vtt | 4.21KB 3. Oracle Database Architecture/13. Logical and Physical Database Structure.mp4 | 67.76MB 3. Oracle Database Architecture/13. Logical and Physical Database Structure.vtt | 6.70KB 3. Oracle Database Architecture/14. Quiz - Database Architecture.html | 141B 3. Oracle Database Architecture/2. Oracle Database Architecture Overview (Part 1).mp4 | 139.67MB 3. Oracle Database Architecture/2. Oracle Database Architecture Overview (Part 1).vtt | 10.37KB 3. Oracle Database Architecture/3. Oracle Database Architecture Overview (Part 2).mp4 | 88.03MB 3. Oracle Database Architecture/3. Oracle Database Architecture Overview (Part 2).vtt | 6.55KB 3. Oracle Database Architecture/4. Database Data Blocks in Detail.mp4 | 74.47MB 3. Oracle Database Architecture/4. Database Data Blocks in Detail.vtt | 9.47KB 3. Oracle Database Architecture/5. What is PGA.mp4 | 62.36MB 3. Oracle Database Architecture/5. What is PGA.vtt | 6.03KB 3. Oracle Database Architecture/6. What is Shared Pool.mp4 | 66.67MB 3. Oracle Database Architecture/6. What is Shared Pool.vtt | 7.40KB 3. Oracle Database Architecture/7. What is Buffer Cache.mp4 | 57.23MB 3. Oracle Database Architecture/7. What is Buffer Cache.vtt | 6.12KB 3. Oracle Database Architecture/8. What is Redo Log Buffer.mp4 | 47.20MB 3. Oracle Database Architecture/8. What is Redo Log Buffer.vtt | 4.64KB 3. Oracle Database Architecture/9. What is Undo.mp4 | 42.84MB 3. Oracle Database Architecture/9. What is Undo.vtt | 4.16KB 4. SQL Tuning Basics/1. When to Tune.mp4 | 67.23MB 4. SQL Tuning Basics/1. When to Tune.vtt | 8.58KB 4. SQL Tuning Basics/10. What is cost in detail.mp4 | 44.42MB 4. SQL Tuning Basics/10. What is cost in detail.vtt | 4.93KB 4. SQL Tuning Basics/11. Plan Generator.mp4 | 37.89MB 4. SQL Tuning Basics/11. Plan Generator.vtt | 4.06KB 4. SQL Tuning Basics/12. Row Source Generator.mp4 | 36.48MB 4. SQL Tuning Basics/12. Row Source Generator.vtt | 3.74KB 4. SQL Tuning Basics/13. SQL Tuning Principles and Strategies.mp4 | 96.27MB 4. SQL Tuning Basics/13. SQL Tuning Principles and Strategies.vtt | 9.23KB 4. SQL Tuning Basics/14. Query Analysis Strategy.mp4 | 150.21MB 4. SQL Tuning Basics/14. Query Analysis Strategy.vtt | 15.35KB 4. SQL Tuning Basics/15. SQL Tuning Basics Assessment Test.html | 141B 4. SQL Tuning Basics/2. What is a Bad SQL.mp4 | 55.55MB 4. SQL Tuning Basics/2. What is a Bad SQL.vtt | 5.60KB 4. SQL Tuning Basics/3. Effective Schema Design.mp4 | 88.02MB 4. SQL Tuning Basics/3. Effective Schema Design.vtt | 9.80KB 4. SQL Tuning Basics/4. Table Partitioning.mp4 | 74.81MB 4. SQL Tuning Basics/4. Table Partitioning.vtt | 8.14KB 4. SQL Tuning Basics/5. How an SQL Statement is Processed.mp4 | 95.12MB 4. SQL Tuning Basics/5. How an SQL Statement is Processed.vtt | 10.38KB 4. SQL Tuning Basics/6. Why do we need the Optimizer.mp4 | 52.29MB 4. SQL Tuning Basics/6. Why do we need the Optimizer.vtt | 6.36KB 4. SQL Tuning Basics/7. Optimizer Overview.mp4 | 31.09MB 4. SQL Tuning Basics/7. Optimizer Overview.vtt | 3.77KB 4. SQL Tuning Basics/8. Query Transformer.mp4 | 86.56MB 4. SQL Tuning Basics/8. Query Transformer.vtt | 10.07KB 4. SQL Tuning Basics/9. Selectivity & Cardinality.mp4 | 79.12MB 4. SQL Tuning Basics/9. Selectivity & Cardinality.vtt | 8.30KB 4. SQL Tuning Basics/ReadMe.txt | 538B 4. SQL Tuning Basics/Visit Coursedrive.org.url | 124B 5. Execution Plans & Statistics/1. Execution Plan and Explain Plan in Details.mp4 | 67.67MB 5. Execution Plans & Statistics/1. Execution Plan and Explain Plan in Details.vtt | 8.20KB 5. Execution Plans & Statistics/10. V$SQL_PLAN View.mp4 | 109.35MB 5. Execution Plans & Statistics/10. V$SQL_PLAN View.vtt | 11.77KB 5. Execution Plans & Statistics/11. V$SQL_PLAN (Code Samples).html | 909B 5. Execution Plans & Statistics/12. Reading the Execution Plans (Part 1).mp4 | 110.73MB 5. Execution Plans & Statistics/12. Reading the Execution Plans (Part 1).vtt | 13.93KB 5. Execution Plans & Statistics/13. Reading the Execution Plans (Part 2).mp4 | 59.94MB 5. Execution Plans & Statistics/13. Reading the Execution Plans (Part 2).vtt | 10.44KB 5. Execution Plans & Statistics/14. Reading the Execution Plans (Code Samples).html | 303B 5. Execution Plans & Statistics/15. Analyzing the Execution Plans.mp4 | 93.85MB 5. Execution Plans & Statistics/15. Analyzing the Execution Plans.vtt | 8.36KB 5. Execution Plans & Statistics/16. Analyzing the Execution Plans (Code Samples).html | 547B 5. Execution Plans & Statistics/17. Execution Plans & Statistics.html | 141B 5. Execution Plans & Statistics/2. Generating Statistics (Part 1).mp4 | 62.02MB 5. Execution Plans & Statistics/2. Generating Statistics (Part 1).vtt | 6.83KB 5. Execution Plans & Statistics/3. Generating Statistics (Part 2).mp4 | 79.99MB 5. Execution Plans & Statistics/3. Generating Statistics (Part 2).vtt | 8.23KB 5. Execution Plans & Statistics/4. Generating Statistics (Part 3).mp4 | 104.78MB 5. Execution Plans & Statistics/4. Generating Statistics (Part 3).vtt | 9.45KB 5. Execution Plans & Statistics/5. Generating Statistics (Code Samples).html | 1.04KB 5. Execution Plans & Statistics/6. Generating Execution Plan.mp4 | 109.77MB 5. Execution Plans & Statistics/6. Generating Execution Plan.vtt | 11.96KB 5. Execution Plans & Statistics/7. Generating Execution Plan (Code Samples).html | 354B 5. Execution Plans & Statistics/8. Autotrace.mp4 | 112.51MB 5. Execution Plans & Statistics/8. Autotrace.vtt | 12.43KB 5. Execution Plans & Statistics/9. Autotrace (Code Samples).html | 313B 6. Table & Index Access Paths/1. What are Indexes and How They work in details.mp4 | 141.08MB 6. Table & Index Access Paths/1. What are Indexes and How They work in details.vtt | 10.64KB 6. Table & Index Access Paths/10. Index Full Scan.mp4 | 92.55MB 6. Table & Index Access Paths/10. Index Full Scan.vtt | 9.61KB 6. Table & Index Access Paths/11. Index Full Scan (Code Samples).html | 1.79KB 6. Table & Index Access Paths/12. Index Fast Full Scan.mp4 | 60.63MB 6. Table & Index Access Paths/12. Index Fast Full Scan.vtt | 6.34KB 6. Table & Index Access Paths/13. Index Fast Full Scan (Code Samples).html | 869B 6. Table & Index Access Paths/14. Index Skip Scan.mp4 | 148.10MB 6. Table & Index Access Paths/14. Index Skip Scan.vtt | 13.48KB 6. Table & Index Access Paths/15. Index Skip Scan (Code Samples).html | 824B 6. Table & Index Access Paths/16. Index Join Scan.mp4 | 50.79MB 6. Table & Index Access Paths/16. Index Join Scan.vtt | 5.51KB 6. Table & Index Access Paths/17. Index Join Scan (Code Samples).html | 379B 6. Table & Index Access Paths/18. Table & Index Access Paths.html | 141B 6. Table & Index Access Paths/2. Types of Table and Index Access Paths.mp4 | 161.58MB 6. Table & Index Access Paths/2. Types of Table and Index Access Paths.vtt | 12.13KB 6. Table & Index Access Paths/3. Table Access Full.mp4 | 91.36MB 6. Table & Index Access Paths/3. Table Access Full.vtt | 8.34KB 6. Table & Index Access Paths/4. Table Access Full (Code Samples).html | 444B 6. Table & Index Access Paths/5. Table Access by ROWID.mp4 | 58.67MB 6. Table & Index Access Paths/5. Table Access by ROWID.vtt | 6.08KB 6. Table & Index Access Paths/6. Table Access by ROWID (Code Samples).html | 284B 6. Table & Index Access Paths/7. Index Unique Scan.mp4 | 43.49MB 6. Table & Index Access Paths/7. Index Unique Scan.vtt | 4.69KB 6. Table & Index Access Paths/8. Index Range Scan.mp4 | 99.38MB 6. Table & Index Access Paths/8. Index Range Scan.vtt | 10.34KB 6. Table & Index Access Paths/9. Index Range Scan (Code Samples).html | 1.04KB 7. Optimizer Hints/1. What are Hints and Why to Use Them.mp4 | 42.74MB 7. Optimizer Hints/1. What are Hints and Why to Use Them.vtt | 3.98KB 7. Optimizer Hints/2. How to use Hints.mp4 | 130.40MB 7. Optimizer Hints/2. How to use Hints.vtt | 14.96KB 7. Optimizer Hints/3. How to use Hints (Code Samples).html | 2.85KB 7. Optimizer Hints/4. List of Some Useful Hints.html | 516B 7. Optimizer Hints/4.1 HINTS Working Document for our Students(Oracle Master).pdf.pdf | 288.24KB 8. Join Operations/1. Join Methods Overview.mp4 | 61.35MB 8. Join Operations/1. Join Methods Overview.vtt | 5.38KB 8. Join Operations/10. Join Types Overview.mp4 | 33.73MB 8. Join Operations/10. Join Types Overview.vtt | 3.03KB 8. Join Operations/11. Equijoins & Nonequijoins.mp4 | 34.91MB 8. Join Operations/11. Equijoins & Nonequijoins.vtt | 3.73KB 8. Join Operations/12. CODE Equijoins & Nonequijoins.html | 259B 8. Join Operations/13. Outer Joins.mp4 | 90.27MB 8. Join Operations/13. Outer Joins.vtt | 11.10KB 8. Join Operations/14. CODE Outer Joins.html | 1.07KB 8. Join Operations/15. Semijoins.mp4 | 51.45MB 8. Join Operations/15. Semijoins.vtt | 5.58KB 8. Join Operations/16. CODE Semijoins.html | 401B 8. Join Operations/17. Antijoins.mp4 | 30.66MB 8. Join Operations/17. Antijoins.vtt | 3.10KB 8. Join Operations/18. CODE Antijoins.html | 676B 8. Join Operations/2. Nested Loop Joins.mp4 | 117.11MB 8. Join Operations/2. Nested Loop Joins.vtt | 12.30KB 8. Join Operations/3. Nested Loop Join (Code Samples).html | 1.04KB 8. Join Operations/4. Sort Merge Joins.mp4 | 99.42MB 8. Join Operations/4. Sort Merge Joins.vtt | 10.22KB 8. Join Operations/5. Sort Merge Join (Code Samples).html | 820B 8. Join Operations/6. Hash Joins.mp4 | 102.26MB 8. Join Operations/6. Hash Joins.vtt | 11.34KB 8. Join Operations/7. CODE Hash Joins.html | 340B 8. Join Operations/8. Cartesian Joins.mp4 | 62.49MB 8. Join Operations/8. Cartesian Joins.vtt | 6.65KB 8. Join Operations/9. CODE Cartesian Joins.html | 139B 9. Other Optimizer Operators/1. Result Cache Operator.mp4 | 106.67MB 9. Other Optimizer Operators/1. Result Cache Operator.vtt | 11.93KB 9. Other Optimizer Operators/10. CODE INLIST Operator.html | 742B 9. Other Optimizer Operators/11. Count Stopkey Operator.mp4 | 19.64MB 9. Other Optimizer Operators/11. Count Stopkey Operator.vtt | 3.60KB 9. Other Optimizer Operators/12. CODE Count Stopkey Operator.html | 210B 9. Other Optimizer Operators/13. First Row Operator.mp4 | 31.79MB 9. Other Optimizer Operators/13. First Row Operator.vtt | 5.38KB 9. Other Optimizer Operators/14. CODE First Row Operator.html | 375B 9. Other Optimizer Operators/15. Filter Operator.mp4 | 8.78MB 9. Other Optimizer Operators/15. Filter Operator.vtt | 1.71KB 9. Other Optimizer Operators/16. CODE Filter Operator.html | 143B 9. Other Optimizer Operators/17. Concatenation Operator.mp4 | 19.31MB 9. Other Optimizer Operators/17. Concatenation Operator.vtt | 3.12KB 9. Other Optimizer Operators/18. CODE Concatenation Operator.html | 199B 9. Other Optimizer Operators/19. UNION Operators.mp4 | 18.60MB 9. Other Optimizer Operators/19. UNION Operators.vtt | 2.91KB 9. Other Optimizer Operators/2. CODE Result Cache Operator.html | 685B 9. Other Optimizer Operators/20. CODE Union Operators.html | 258B 9. Other Optimizer Operators/21. Intersect Operator.mp4 | 45.40MB 9. Other Optimizer Operators/21. Intersect Operator.vtt | 5.18KB 9. Other Optimizer Operators/22. CODE Intersect Operator.html | 607B 9. Other Optimizer Operators/23. Minus Operator.mp4 | 14.92MB 9. Other Optimizer Operators/23. Minus Operator.vtt | 1.80KB 9. Other Optimizer Operators/24. CODE Minus Operator.html | 369B 9. Other Optimizer Operators/3. View Operator.mp4 | 63.64MB 9. Other Optimizer Operators/3. View Operator.vtt | 7.27KB 9. Other Optimizer Operators/4. CODE View Operator.html | 1.62KB 9. Other Optimizer Operators/5. Clusters.mp4 | 143.98MB 9. Other Optimizer Operators/5. Clusters.vtt | 14.82KB 9. Other Optimizer Operators/6. CODE Clusters.html | 1.48KB 9. Other Optimizer Operators/7. Sort Operators.mp4 | 69.07MB 9. Other Optimizer Operators/7. Sort Operators.vtt | 7.38KB 9. Other Optimizer Operators/8. CODE Sort Operators.html | 393B 9. Other Optimizer Operators/9. INLIST Operator.mp4 | 43.01MB 9. Other Optimizer Operators/9. INLIST Operator.vtt | 4.34KB 9. Other Optimizer Operators/ReadMe.txt | 538B 9. Other Optimizer Operators/Visit Coursedrive.org.url | 124B [CourseClub.Me].url | 48B [DesireCourse.Net].url | 51B