Oracle SQL Performance Tuning Masterclass 2019

1. SQL & Perfomance Tuning Course Introduction/1. SQL & Performance Tuning Course Overview.mp4

62.11 MB

1. SQL & Perfomance Tuning Course Introduction/2. UDEMY 101 How to Use Udemy +Some Useful Tips.mp4

50.62 MB

1. SQL & Perfomance Tuning Course Introduction/3.1 (Oracle Master) SQL & Performance Tuning Document.pdf.pdf

5.15 MB

1. SQL & Perfomance Tuning Course Introduction/1. SQL & Performance Tuning Course Overview.vtt

5.71 KB

1. SQL & Perfomance Tuning Course Introduction/2. UDEMY 101 How to Use Udemy +Some Useful Tips.vtt

5.4 KB

1. SQL & Perfomance Tuning Course Introduction/3. Welcome! +Course Notes.html

1.09 KB

1. SQL & Perfomance Tuning Course Introduction/ReadMe.txt

669 B

10. SQL Tuning Techniques/2. Ways of Getting the Execution Plan and the Statistics.mp4

187.2 MB

10. SQL Tuning Techniques/1. How to find a performance problem and its tuning solution.mp4

173.57 MB

10. SQL Tuning Techniques/3. Using the Real-Time SQL Monitoring Tool Part 1.mp4

120.72 MB

10. SQL Tuning Techniques/1. How to find a performance problem and its tuning solution.mp4.jpg

77.08 KB

10. SQL Tuning Techniques/3. Using the Real-Time SQL Monitoring Tool Part 1.mp4.jpg

75.83 KB

10. SQL Tuning Techniques/2. Ways of Getting the Execution Plan and the Statistics.vtt

17.97 KB

10. SQL Tuning Techniques/1. How to find a performance problem and its tuning solution.vtt

16.01 KB

10. SQL Tuning Techniques/3. Using the Real-Time SQL Monitoring Tool Part 1.vtt

11.55 KB

10. SQL Tuning Techniques/4. Rest is On Production. Will be ready soon!.html

274 B

10. SQL Tuning Techniques/1. How to find a performance problem and its tuning solution.txt

260 B

10. SQL Tuning Techniques/3. Using the Real-Time SQL Monitoring Tool Part 1.txt

249 B

11. Important Information - For Your Attention!/1. Good news!.html

423 B

12. Appendix Software Installations/2. Option 1 Having The Database with Oracle VirtualBox.mp4

164.33 MB

12. Appendix Software Installations/3. Option 2 Downloading And Installing Oracle Database.mp4

105.49 MB

12. Appendix Software Installations/6. Configuring and Using SQL Developer.mp4

82.98 MB

12. Appendix Software Installations/4. Installing SH Schema.mp4

62.91 MB

12. Appendix Software Installations/1. About the Installation.mp4

53.81 MB

12. Appendix Software Installations/4.1 sample_schemas.zip.zip

14.03 MB

12. Appendix Software Installations/2.4 Oracle Master Changing Virtual Machine Keyboard Input Settings (SQL Tuning Masterclass).pdf.pdf

876.92 KB

12. Appendix Software Installations/4.2 sh_installation_codes.pdf.pdf

51.27 KB

12. Appendix Software Installations/2. Option 1 Having The Database with Oracle VirtualBox.vtt

11.3 KB

12. Appendix Software Installations/6. Configuring and Using SQL Developer.vtt

9.24 KB

12. Appendix Software Installations/3. Option 2 Downloading And Installing Oracle Database.vtt

8.29 KB

12. Appendix Software Installations/4. Installing SH Schema.vtt

5.92 KB

12. Appendix Software Installations/5. How to Install VirtualBox on Mac OSX.html

3.8 KB

12. Appendix Software Installations/1. About the Installation.vtt

3.72 KB

12. Appendix Software Installations/2.2 Linux Operating System Username and Password.txt.txt

185 B

12. Appendix Software Installations/2.3 Step 2 Download Virtual Machine Image Link.html

141 B

12. Appendix Software Installations/2.1 Step 1 Download Oracle Virtual Box.html

136 B

13. Bonus (+) Section/1.1 Oracle Master Training (Special Discounts for Our Students).xlsx.xlsx

35.51 KB

13. Bonus (+) Section/1. Bonus Lecture for Our Students.html

2.33 KB

2. What is SQL (Performance) Tuning and Why We Need/2. What to Know Before Starting the Course.mp4

66.72 MB

2. What is SQL (Performance) Tuning and Why We Need/1. What is SQL Tuning and Why to Do That.mp4

59.63 MB

2. What is SQL (Performance) Tuning and Why We Need/2. What to Know Before Starting the Course.mp4.jpg

84.16 KB

2. What is SQL (Performance) Tuning and Why We Need/2. What to Know Before Starting the Course.vtt

7.19 KB

2. What is SQL (Performance) Tuning and Why We Need/1. What is SQL Tuning and Why to Do That.vtt

6.84 KB

2. What is SQL (Performance) Tuning and Why We Need/2. What to Know Before Starting the Course.txt

240 B

3. Oracle Database Architecture/2. Oracle Database Architecture Overview (Part 1).mp4

139.67 MB

3. Oracle Database Architecture/3. Oracle Database Architecture Overview (Part 2).mp4

88.03 MB

3. Oracle Database Architecture/4. Database Data Blocks in Detail.mp4

74.47 MB

3. Oracle Database Architecture/13. Logical and Physical Database Structure.mp4

67.76 MB

3. Oracle Database Architecture/6. What is Shared Pool.mp4

66.67 MB

3. Oracle Database Architecture/5. What is PGA.mp4

62.36 MB

3. Oracle Database Architecture/7. What is Buffer Cache.mp4

57.23 MB

3. Oracle Database Architecture/10. How a DML is processed and committed.mp4

50.39 MB

3. Oracle Database Architecture/8. What is Redo Log Buffer.mp4

47.2 MB

3. Oracle Database Architecture/12. Oracle Database Storage Architecture.mp4

46.81 MB

3. Oracle Database Architecture/9. What is Undo.mp4

42.84 MB

3. Oracle Database Architecture/1. Why to know the Oracle Database Architecture and how much to know.mp4

36.82 MB

3. Oracle Database Architecture/11. Automatic Memory Management.mp4

22.55 MB

3. Oracle Database Architecture/2. Oracle Database Architecture Overview (Part 1).vtt

10.37 KB

3. Oracle Database Architecture/4. Database Data Blocks in Detail.vtt

9.47 KB

3. Oracle Database Architecture/6. What is Shared Pool.vtt

7.4 KB

3. Oracle Database Architecture/13. Logical and Physical Database Structure.vtt

6.7 KB

3. Oracle Database Architecture/3. Oracle Database Architecture Overview (Part 2).vtt

6.55 KB

3. Oracle Database Architecture/7. What is Buffer Cache.vtt

6.12 KB

3. Oracle Database Architecture/5. What is PGA.vtt

6.03 KB

3. Oracle Database Architecture/10. How a DML is processed and committed.vtt

4.76 KB

3. Oracle Database Architecture/8. What is Redo Log Buffer.vtt

4.64 KB

3. Oracle Database Architecture/12. Oracle Database Storage Architecture.vtt

4.21 KB

3. Oracle Database Architecture/9. What is Undo.vtt

4.16 KB

3. Oracle Database Architecture/1. Why to know the Oracle Database Architecture and how much to know.vtt

2.86 KB

3. Oracle Database Architecture/11. Automatic Memory Management.vtt

2.29 KB

3. Oracle Database Architecture/14. Quiz - Database Architecture.html

141 B

4. SQL Tuning Basics/14. Query Analysis Strategy.mp4

150.21 MB

4. SQL Tuning Basics/13. SQL Tuning Principles and Strategies.mp4

96.27 MB

4. SQL Tuning Basics/5. How an SQL Statement is Processed.mp4

95.12 MB

4. SQL Tuning Basics/3. Effective Schema Design.mp4

88.02 MB

4. SQL Tuning Basics/8. Query Transformer.mp4

86.56 MB

4. SQL Tuning Basics/9. Selectivity & Cardinality.mp4

79.12 MB

4. SQL Tuning Basics/4. Table Partitioning.mp4

74.81 MB

4. SQL Tuning Basics/1. When to Tune.mp4

67.23 MB

4. SQL Tuning Basics/2. What is a Bad SQL.mp4

55.55 MB

4. SQL Tuning Basics/6. Why do we need the Optimizer.mp4

52.29 MB

4. SQL Tuning Basics/10. What is cost in detail.mp4

44.42 MB

4. SQL Tuning Basics/11. Plan Generator.mp4

37.89 MB

4. SQL Tuning Basics/12. Row Source Generator.mp4

36.48 MB

4. SQL Tuning Basics/7. Optimizer Overview.mp4

31.09 MB

4. SQL Tuning Basics/14. Query Analysis Strategy.vtt

15.35 KB

4. SQL Tuning Basics/5. How an SQL Statement is Processed.vtt

10.38 KB

4. SQL Tuning Basics/8. Query Transformer.vtt

10.07 KB

4. SQL Tuning Basics/3. Effective Schema Design.vtt

9.8 KB

4. SQL Tuning Basics/13. SQL Tuning Principles and Strategies.vtt

9.23 KB

4. SQL Tuning Basics/1. When to Tune.vtt

8.58 KB

4. SQL Tuning Basics/9. Selectivity & Cardinality.vtt

8.3 KB

4. SQL Tuning Basics/4. Table Partitioning.vtt

8.14 KB

4. SQL Tuning Basics/6. Why do we need the Optimizer.vtt

6.36 KB

4. SQL Tuning Basics/2. What is a Bad SQL.vtt

5.6 KB

4. SQL Tuning Basics/10. What is cost in detail.vtt

4.93 KB

4. SQL Tuning Basics/11. Plan Generator.vtt

4.06 KB

4. SQL Tuning Basics/7. Optimizer Overview.vtt

3.77 KB

4. SQL Tuning Basics/12. Row Source Generator.vtt

3.74 KB

4. SQL Tuning Basics/15. SQL Tuning Basics Assessment Test.html

141 B

5. Execution Plans & Statistics/8. Autotrace.mp4

112.51 MB

5. Execution Plans & Statistics/12. Reading the Execution Plans (Part 1).mp4

110.73 MB

5. Execution Plans & Statistics/6. Generating Execution Plan.mp4

109.77 MB

5. Execution Plans & Statistics/10. V$SQL_PLAN View.mp4

109.35 MB

5. Execution Plans & Statistics/4. Generating Statistics (Part 3).mp4

104.78 MB

5. Execution Plans & Statistics/15. Analyzing the Execution Plans.mp4

93.85 MB

5. Execution Plans & Statistics/3. Generating Statistics (Part 2).mp4

79.99 MB

5. Execution Plans & Statistics/1. Execution Plan and Explain Plan in Details.mp4

67.67 MB

5. Execution Plans & Statistics/2. Generating Statistics (Part 1).mp4

62.02 MB

5. Execution Plans & Statistics/13. Reading the Execution Plans (Part 2).mp4

59.94 MB

5. Execution Plans & Statistics/12. Reading the Execution Plans (Part 1).vtt

13.93 KB

5. Execution Plans & Statistics/8. Autotrace.vtt

12.43 KB

5. Execution Plans & Statistics/6. Generating Execution Plan.vtt

11.96 KB

5. Execution Plans & Statistics/10. V$SQL_PLAN View.vtt

11.77 KB

5. Execution Plans & Statistics/13. Reading the Execution Plans (Part 2).vtt

10.44 KB

5. Execution Plans & Statistics/4. Generating Statistics (Part 3).vtt

9.45 KB

5. Execution Plans & Statistics/15. Analyzing the Execution Plans.vtt

8.36 KB

5. Execution Plans & Statistics/3. Generating Statistics (Part 2).vtt

8.23 KB

5. Execution Plans & Statistics/1. Execution Plan and Explain Plan in Details.vtt

8.2 KB

5. Execution Plans & Statistics/2. Generating Statistics (Part 1).vtt

6.83 KB

5. Execution Plans & Statistics/5. Generating Statistics (Code Samples).html

1.04 KB

5. Execution Plans & Statistics/11. V$SQL_PLAN (Code Samples).html

909 B

5. Execution Plans & Statistics/16. Analyzing the Execution Plans (Code Samples).html

547 B

5. Execution Plans & Statistics/7. Generating Execution Plan (Code Samples).html

354 B

5. Execution Plans & Statistics/9. Autotrace (Code Samples).html

313 B

5. Execution Plans & Statistics/14. Reading the Execution Plans (Code Samples).html

303 B

5. Execution Plans & Statistics/17. Execution Plans & Statistics.html

141 B

6. Table & Index Access Paths/2. Types of Table and Index Access Paths.mp4

161.58 MB

6. Table & Index Access Paths/14. Index Skip Scan.mp4

148.1 MB

6. Table & Index Access Paths/1. What are Indexes and How They work in details.mp4

141.08 MB

6. Table & Index Access Paths/8. Index Range Scan.mp4

99.38 MB

6. Table & Index Access Paths/10. Index Full Scan.mp4

92.55 MB

6. Table & Index Access Paths/3. Table Access Full.mp4

91.36 MB

6. Table & Index Access Paths/12. Index Fast Full Scan.mp4

60.63 MB

6. Table & Index Access Paths/5. Table Access by ROWID.mp4

58.67 MB

6. Table & Index Access Paths/16. Index Join Scan.mp4

50.79 MB

6. Table & Index Access Paths/7. Index Unique Scan.mp4

43.49 MB

6. Table & Index Access Paths/14. Index Skip Scan.vtt

13.48 KB

6. Table & Index Access Paths/2. Types of Table and Index Access Paths.vtt

12.13 KB

6. Table & Index Access Paths/1. What are Indexes and How They work in details.vtt

10.64 KB

6. Table & Index Access Paths/8. Index Range Scan.vtt

10.34 KB

6. Table & Index Access Paths/10. Index Full Scan.vtt

9.61 KB

6. Table & Index Access Paths/3. Table Access Full.vtt

8.34 KB

6. Table & Index Access Paths/12. Index Fast Full Scan.vtt

6.34 KB

6. Table & Index Access Paths/5. Table Access by ROWID.vtt

6.08 KB

6. Table & Index Access Paths/16. Index Join Scan.vtt

5.51 KB

6. Table & Index Access Paths/7. Index Unique Scan.vtt

4.69 KB

6. Table & Index Access Paths/11. Index Full Scan (Code Samples).html

1.79 KB

6. Table & Index Access Paths/9. Index Range Scan (Code Samples).html

1.04 KB

6. Table & Index Access Paths/13. Index Fast Full Scan (Code Samples).html

869 B

6. Table & Index Access Paths/15. Index Skip Scan (Code Samples).html

824 B

6. Table & Index Access Paths/4. Table Access Full (Code Samples).html

444 B

6. Table & Index Access Paths/17. Index Join Scan (Code Samples).html

379 B

6. Table & Index Access Paths/6. Table Access by ROWID (Code Samples).html

284 B

6. Table & Index Access Paths/18. Table & Index Access Paths.html

141 B

7. Optimizer Hints/2. How to use Hints.mp4

130.4 MB

7. Optimizer Hints/1. What are Hints and Why to Use Them.mp4

42.74 MB

7. Optimizer Hints/4.1 HINTS Working Document for our Students(Oracle Master).pdf.pdf

288.24 KB

7. Optimizer Hints/2. How to use Hints.vtt

14.96 KB

7. Optimizer Hints/1. What are Hints and Why to Use Them.vtt

3.98 KB

7. Optimizer Hints/3. How to use Hints (Code Samples).html

2.85 KB

7. Optimizer Hints/4. List of Some Useful Hints.html

516 B

8. Join Operations/2. Nested Loop Joins.mp4

117.11 MB

8. Join Operations/6. Hash Joins.mp4

102.26 MB

8. Join Operations/4. Sort Merge Joins.mp4

99.42 MB

8. Join Operations/13. Outer Joins.mp4

90.27 MB

8. Join Operations/8. Cartesian Joins.mp4

62.49 MB

8. Join Operations/1. Join Methods Overview.mp4

61.35 MB

8. Join Operations/15. Semijoins.mp4

51.45 MB

8. Join Operations/11. Equijoins & Nonequijoins.mp4

34.91 MB

8. Join Operations/10. Join Types Overview.mp4

33.73 MB

8. Join Operations/17. Antijoins.mp4

30.66 MB

8. Join Operations/2. Nested Loop Joins.vtt

12.3 KB

8. Join Operations/6. Hash Joins.vtt

11.34 KB

8. Join Operations/13. Outer Joins.vtt

11.1 KB

8. Join Operations/4. Sort Merge Joins.vtt

10.22 KB

8. Join Operations/8. Cartesian Joins.vtt

6.65 KB

8. Join Operations/15. Semijoins.vtt

5.58 KB

8. Join Operations/1. Join Methods Overview.vtt

5.38 KB

8. Join Operations/11. Equijoins & Nonequijoins.vtt

3.73 KB

8. Join Operations/17. Antijoins.vtt

3.1 KB

8. Join Operations/10. Join Types Overview.vtt

3.03 KB

8. Join Operations/14. CODE Outer Joins.html

1.07 KB

8. Join Operations/3. Nested Loop Join (Code Samples).html

1.04 KB

8. Join Operations/5. Sort Merge Join (Code Samples).html

820 B

8. Join Operations/18. CODE Antijoins.html

676 B

8. Join Operations/16. CODE Semijoins.html

401 B

8. Join Operations/7. CODE Hash Joins.html

340 B

8. Join Operations/12. CODE Equijoins & Nonequijoins.html

259 B

8. Join Operations/9. CODE Cartesian Joins.html

139 B

9. Other Optimizer Operators/5. Clusters.mp4

143.98 MB

9. Other Optimizer Operators/1. Result Cache Operator.mp4

106.67 MB

9. Other Optimizer Operators/7. Sort Operators.mp4

69.07 MB

9. Other Optimizer Operators/3. View Operator.mp4

63.64 MB

9. Other Optimizer Operators/21. Intersect Operator.mp4

45.4 MB

9. Other Optimizer Operators/9. INLIST Operator.mp4

43.01 MB

9. Other Optimizer Operators/13. First Row Operator.mp4

31.79 MB

9. Other Optimizer Operators/11. Count Stopkey Operator.mp4

19.64 MB

9. Other Optimizer Operators/17. Concatenation Operator.mp4

19.31 MB

9. Other Optimizer Operators/19. UNION Operators.mp4

18.6 MB

9. Other Optimizer Operators/23. Minus Operator.mp4

14.92 MB

9. Other Optimizer Operators/15. Filter Operator.mp4

8.78 MB

9. Other Optimizer Operators/5. Clusters.vtt

14.82 KB

9. Other Optimizer Operators/1. Result Cache Operator.vtt

11.93 KB

9. Other Optimizer Operators/7. Sort Operators.vtt

7.38 KB

9. Other Optimizer Operators/3. View Operator.vtt

7.27 KB

9. Other Optimizer Operators/13. First Row Operator.vtt

5.38 KB

9. Other Optimizer Operators/21. Intersect Operator.vtt

5.18 KB

9. Other Optimizer Operators/9. INLIST Operator.vtt

4.34 KB

9. Other Optimizer Operators/11. Count Stopkey Operator.vtt

3.6 KB

9. Other Optimizer Operators/17. Concatenation Operator.vtt

3.12 KB

9. Other Optimizer Operators/19. UNION Operators.vtt

2.91 KB

9. Other Optimizer Operators/23. Minus Operator.vtt

1.8 KB

9. Other Optimizer Operators/15. Filter Operator.vtt

1.71 KB

9. Other Optimizer Operators/4. CODE View Operator.html

1.62 KB

9. Other Optimizer Operators/6. CODE Clusters.html

1.48 KB

9. Other Optimizer Operators/10. CODE INLIST Operator.html

742 B

9. Other Optimizer Operators/2. CODE Result Cache Operator.html

685 B

9. Other Optimizer Operators/22. CODE Intersect Operator.html

607 B

9. Other Optimizer Operators/8. CODE Sort Operators.html

393 B

9. Other Optimizer Operators/14. CODE First Row Operator.html

375 B

9. Other Optimizer Operators/24. CODE Minus Operator.html

369 B

9. Other Optimizer Operators/20. CODE Union Operators.html

258 B

9. Other Optimizer Operators/12. CODE Count Stopkey Operator.html

210 B

9. Other Optimizer Operators/18. CODE Concatenation Operator.html

199 B

9. Other Optimizer Operators/16. CODE Filter Operator.html

143 B

ReadMe.txt

669 B

Visit Getnewcourses.com.url

343 B

Visit Freecourseit.com.url

342 B

资源详情

免责声明