Oracle SQL Performance Tuning Masterclass 2019

File Name

Size

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

62 MB

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

51 MB

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

5.2 MB

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

5.7 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.1 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 MB

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

174 MB

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

121 MB

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

77 kB

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

76 kB

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

18 kB

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

16 kB

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

12 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 MB

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

106 MB

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

83 MB

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

63 MB

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

54 MB

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

14 MB

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

877 kB

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

51 kB

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

11 kB

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

9.2 kB

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

8.3 kB

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

5.9 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.7 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

36 kB

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

2.3 kB

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

67 MB

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

60 MB

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

84 kB

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

7.2 kB

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

6.8 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

140 MB

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

88 MB

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

74 MB

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

68 MB

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

67 MB

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

62 MB

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

57 MB

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

50 MB

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

47 MB

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

47 MB

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

43 MB

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

37 MB

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

22 MB

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

10 kB

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

9.5 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.5 kB

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

6.1 kB

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

6.0 kB

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

4.8 kB

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

4.6 kB

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

4.2 kB

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

4.2 kB

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

2.9 kB

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

2.3 kB

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

141 B

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

150 MB

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

96 MB

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

95 MB

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

88 MB

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

87 MB

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

79 MB

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

75 MB

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

67 MB

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

56 MB

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

52 MB

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

44 MB

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

38 MB

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

36 MB

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

31 MB

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

15 kB

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

10 kB

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

10 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.2 kB

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

8.6 kB

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

8.3 kB

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

8.1 kB

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

6.4 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.9 kB

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

4.1 kB

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

3.8 kB

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

3.7 kB

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

141 B

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

112 MB

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

111 MB

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

110 MB

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

109 MB

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

105 MB

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

94 MB

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

80 MB

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

68 MB

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

62 MB

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

60 MB

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

14 kB

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

12 kB

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

12 kB

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

12 kB

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

10 kB

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

9.4 kB

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

8.4 kB

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

8.2 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.8 kB

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

1.0 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

162 MB

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

148 MB

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

141 MB

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

99 MB

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

93 MB

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

91 MB

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

61 MB

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

59 MB

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

51 MB

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

44 MB

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

14 kB

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

12 kB

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

11 kB

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

10 kB

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

9.6 kB

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

8.3 kB

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

6.3 kB

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

6.1 kB

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

5.5 kB

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

4.7 kB

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

1.8 kB

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

1.0 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 MB

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

43 MB

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

288 kB

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

15 kB

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

4.0 kB

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

2.8 kB

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

516 B

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

117 MB

8. Join Operations/6. Hash Joins.mp4

102 MB

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

99 MB

8. Join Operations/13. Outer Joins.mp4

90 MB

8. Join Operations/8. Cartesian Joins.mp4

62 MB

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

61 MB

8. Join Operations/15. Semijoins.mp4

51 MB

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

35 MB

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

34 MB

8. Join Operations/17. Antijoins.mp4

31 MB

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

12 kB

8. Join Operations/6. Hash Joins.vtt

11 kB

8. Join Operations/13. Outer Joins.vtt

11 kB

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

10 kB

8. Join Operations/8. Cartesian Joins.vtt

6.6 kB

8. Join Operations/15. Semijoins.vtt

5.6 kB

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

5.4 kB

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

3.7 kB

8. Join Operations/17. Antijoins.vtt

3.1 kB

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

3.0 kB

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

1.1 kB

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

1.0 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

144 MB

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

107 MB

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

69 MB

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

64 MB

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

45 MB

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

43 MB

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

32 MB

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

20 MB

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

19 MB

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

19 MB

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

15 MB

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

8.8 MB

9. Other Optimizer Operators/5. Clusters.vtt

15 kB

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

12 kB

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

7.4 kB

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

7.3 kB

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

5.4 kB

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

5.2 kB

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

4.3 kB

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

3.6 kB

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

3.1 kB

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

2.9 kB

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

1.8 kB

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

1.7 kB

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

1.6 kB

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

1.5 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