|
|
1. About the Installation.mp4
|
MP4
|
53.8 MB
|
|
|
1. About the Installation.vtt
|
VTT
|
3.7 KB
|
|
|
1. Bonus Lecture for Our Students.html
|
HTML
|
2.3 KB
|
|
|
1. Execution Plan and Explain Plan in Details.mp4
|
MP4
|
67.7 MB
|
|
|
1. Execution Plan and Explain Plan in Details.vtt
|
VTT
|
8.2 KB
|
|
|
1. Good news!.html
|
HTML
|
409 B
|
|
|
1. How to find a performance problem and its tuning solution.mp4
|
MP4
|
173.6 MB
|
|
|
1. How to find a performance problem and its tuning solution.mp4.jpg
|
JPG
|
77.1 KB
|
|
|
1. How to find a performance problem and its tuning solution.txt
|
TXT
|
307 B
|
|
|
1. How to find a performance problem and its tuning solution.vtt
|
VTT
|
16 KB
|
|
|
1. Join Methods Overview.mp4
|
MP4
|
61.3 MB
|
|
|
1. Join Methods Overview.vtt
|
VTT
|
5.4 KB
|
|
|
1. Result Cache Operator.mp4
|
MP4
|
106.7 MB
|
|
|
1. Result Cache Operator.vtt
|
VTT
|
11.9 KB
|
|
|
1. SQL & Performance Tuning Course Overview.mp4
|
MP4
|
62.1 MB
|
|
|
1. SQL & Performance Tuning Course Overview.vtt
|
VTT
|
5.7 KB
|
|
|
1. What are Hints and Why to Use Them.mp4
|
MP4
|
42.7 MB
|
|
|
1. What are Hints and Why to Use Them.vtt
|
VTT
|
4 KB
|
|
|
1. What are Indexes and How They work in details.mp4
|
MP4
|
141.1 MB
|
|
|
1. What are Indexes and How They work in details.vtt
|
VTT
|
10.6 KB
|
|
|
1. What is SQL Tuning and Why to Do That.mp4
|
MP4
|
59.6 MB
|
|
|
1. What is SQL Tuning and Why to Do That.vtt
|
VTT
|
6.8 KB
|
|
|
1. When to Tune.mp4
|
MP4
|
67.2 MB
|
|
|
1. When to Tune.vtt
|
VTT
|
8.6 KB
|
|
|
1. Why to know the Oracle Database Architecture and how much to know.mp4
|
MP4
|
36.8 MB
|
|
|
1. Why to know the Oracle Database Architecture and how much to know.vtt
|
VTT
|
2.9 KB
|
|
|
1.1 Oracle Master Training (Special Discounts for Our Students).xlsx.xlsx
|
XLSX
|
35.5 KB
|
|
|
10. CODE INLIST Operator.html
|
HTML
|
716 B
|
|
|
10. How a DML is processed and committed.mp4
|
MP4
|
50.4 MB
|
|
|
10. How a DML is processed and committed.vtt
|
VTT
|
4.8 KB
|
|
|
10. Index Full Scan.mp4
|
MP4
|
92.6 MB
|
|
|
10. Index Full Scan.vtt
|
VTT
|
9.6 KB
|
|
|
10. Join Types Overview.mp4
|
MP4
|
33.7 MB
|
|
|
10. Join Types Overview.vtt
|
VTT
|
3 KB
|
|
|
10. V$SQL_PLAN View.mp4
|
MP4
|
109.4 MB
|
|
|
10. V$SQL_PLAN View.vtt
|
VTT
|
11.8 KB
|
|
|
10. What is cost in detail.mp4
|
MP4
|
44.4 MB
|
|
|
10. What is cost in detail.vtt
|
VTT
|
4.9 KB
|
|
|
11. Automatic Memory Management.mp4
|
MP4
|
22.5 MB
|
|
|
11. Automatic Memory Management.vtt
|
VTT
|
2.3 KB
|
|
|
11. Count Stopkey Operator.mp4
|
MP4
|
19.6 MB
|
|
|
11. Count Stopkey Operator.vtt
|
VTT
|
3.6 KB
|
|
|
11. Equijoins & Nonequijoins.mp4
|
MP4
|
34.9 MB
|
|
|
11. Equijoins & Nonequijoins.vtt
|
VTT
|
3.7 KB
|
|
|
11. Index Full Scan (Code Samples).html
|
HTML
|
1.8 KB
|
|
|
11. Plan Generator.mp4
|
MP4
|
37.9 MB
|
|
|
11. Plan Generator.vtt
|
VTT
|
4.1 KB
|
|
|
11. V$SQL_PLAN (Code Samples).html
|
HTML
|
921 B
|
|
|
12. CODE Count Stopkey Operator.html
|
HTML
|
204 B
|
|
|
12. CODE Equijoins & Nonequijoins.html
|
HTML
|
307 B
|
|
|
12. Index Fast Full Scan.mp4
|
MP4
|
60.6 MB
|
|
|
12. Index Fast Full Scan.vtt
|
VTT
|
6.3 KB
|
|
|
12. Oracle Database Storage Architecture.mp4
|
MP4
|
46.8 MB
|
|
|
12. Oracle Database Storage Architecture.vtt
|
VTT
|
4.2 KB
|
|
|
12. Reading the Execution Plans (Part 1).mp4
|
MP4
|
110.7 MB
|
|
|
12. Reading the Execution Plans (Part 1).vtt
|
VTT
|
13.9 KB
|
|
|
12. Row Source Generator.mp4
|
MP4
|
36.5 MB
|
|
|
12. Row Source Generator.vtt
|
VTT
|
3.7 KB
|
|
|
13. First Row Operator.mp4
|
MP4
|
31.8 MB
|
|
|
13. First Row Operator.vtt
|
VTT
|
5.4 KB
|
|
|
13. Index Fast Full Scan (Code Samples).html
|
HTML
|
819 B
|
|
|
13. Logical and Physical Database Structure.mp4
|
MP4
|
67.8 MB
|
|
|
13. Logical and Physical Database Structure.vtt
|
VTT
|
6.7 KB
|
|
|
13. Outer Joins.mp4
|
MP4
|
90.3 MB
|
|
|
13. Outer Joins.vtt
|
VTT
|
11.1 KB
|
|
|
13. Reading the Execution Plans (Part 2).mp4
|
MP4
|
59.9 MB
|
|
|
13. Reading the Execution Plans (Part 2).vtt
|
VTT
|
10.4 KB
|
|
|
13. SQL Tuning Principles and Strategies.mp4
|
MP4
|
96.3 MB
|
|
|
13. SQL Tuning Principles and Strategies.vtt
|
VTT
|
9.2 KB
|
|
|
14. CODE First Row Operator.html
|
HTML
|
409 B
|
|
|
14. CODE Outer Joins.html
|
HTML
|
1.1 KB
|
|
|
14. Index Skip Scan.mp4
|
MP4
|
148.1 MB
|
|
|
14. Index Skip Scan.vtt
|
VTT
|
13.5 KB
|
|
|
14. Query Analysis Strategy.mp4
|
MP4
|
150.2 MB
|
|
|
14. Query Analysis Strategy.vtt
|
VTT
|
15.3 KB
|
|
|
14. Quiz - Database Architecture.html
|
HTML
|
102 B
|
|
|
14. Reading the Execution Plans (Code Samples).html
|
HTML
|
307 B
|
|
|
15. Analyzing the Execution Plans.mp4
|
MP4
|
93.9 MB
|
|
|
15. Analyzing the Execution Plans.vtt
|
VTT
|
8.4 KB
|
|
|
15. Filter Operator.mp4
|
MP4
|
8.8 MB
|
|
|
15. Filter Operator.vtt
|
VTT
|
1.7 KB
|
|
|
15. Index Skip Scan (Code Samples).html
|
HTML
|
819 B
|
|
|
15. SQL Tuning Basics Assessment Test.html
|
HTML
|
102 B
|
|
|
15. Semijoins.mp4
|
MP4
|
51.4 MB
|
|
|
15. Semijoins.vtt
|
VTT
|
5.6 KB
|
|
|
16. Analyzing the Execution Plans (Code Samples).html
|
HTML
|
512 B
|
|
|
16. CODE Filter Operator.html
|
HTML
|
102 B
|
|
|
16. CODE Semijoins.html
|
HTML
|
409 B
|
|
|
16. Index Join Scan.mp4
|
MP4
|
50.8 MB
|
|
|
16. Index Join Scan.vtt
|
VTT
|
5.5 KB
|
|
|
17. Antijoins.mp4
|
MP4
|
30.7 MB
|
|
|
17. Antijoins.vtt
|
VTT
|
3.1 KB
|
|
|
17. Concatenation Operator.mp4
|
MP4
|
19.3 MB
|
|
|
17. Concatenation Operator.vtt
|
VTT
|
3.1 KB
|
|
|
17. Execution Plans & Statistics.html
|
HTML
|
102 B
|
|
|
17. Index Join Scan (Code Samples).html
|
HTML
|
409 B
|
|
|
18. CODE Antijoins.html
|
HTML
|
716 B
|
|
|
18. CODE Concatenation Operator.html
|
HTML
|
204 B
|
|
|
18. Table & Index Access Paths.html
|
HTML
|
102 B
|
|
|
19. UNION Operators.mp4
|
MP4
|
18.6 MB
|
|
|
19. UNION Operators.vtt
|
VTT
|
2.9 KB
|
|
|
2. CODE Result Cache Operator.html
|
HTML
|
716 B
|
|
|
2. Generating Statistics (Part 1).mp4
|
MP4
|
62 MB
|
|
|
2. Generating Statistics (Part 1).vtt
|
VTT
|
6.8 KB
|
|
|
2. How to use Hints.mp4
|
MP4
|
130.4 MB
|
|
|
2. How to use Hints.vtt
|
VTT
|
15 KB
|
|
|
2. Nested Loop Joins.mp4
|
MP4
|
117.1 MB
|
|
|
2. Nested Loop Joins.vtt
|
VTT
|
12.3 KB
|
|
|
2. Option 1 Having The Database with Oracle VirtualBox.mp4
|
MP4
|
164.3 MB
|
|
|
2. Option 1 Having The Database with Oracle VirtualBox.vtt
|
VTT
|
11.3 KB
|
|
|
2. Oracle Database Architecture Overview (Part 1).mp4
|
MP4
|
139.7 MB
|
|
|
2. Oracle Database Architecture Overview (Part 1).vtt
|
VTT
|
10.4 KB
|
|
|
2. Types of Table and Index Access Paths.mp4
|
MP4
|
161.6 MB
|
|
|
2. Types of Table and Index Access Paths.vtt
|
VTT
|
12.1 KB
|
|
|
2. UDEMY 101 How to Use Udemy +Some Useful Tips.mp4
|
MP4
|
50.6 MB
|
|
|
2. UDEMY 101 How to Use Udemy +Some Useful Tips.vtt
|
VTT
|
5.4 KB
|
|
|
2. Ways of Getting the Execution Plan and the Statistics.mp4
|
MP4
|
187.2 MB
|
|
|
2. Ways of Getting the Execution Plan and the Statistics.vtt
|
VTT
|
18 KB
|
|
|
2. What is a Bad SQL.mp4
|
MP4
|
55.5 MB
|
|
|
2. What is a Bad SQL.vtt
|
VTT
|
5.6 KB
|
|
|
2. What to Know Before Starting the Course.mp4
|
MP4
|
66.7 MB
|
|
|
2. What to Know Before Starting the Course.mp4.jpg
|
JPG
|
84.2 KB
|
|
|
2. What to Know Before Starting the Course.txt
|
TXT
|
204 B
|
|
|
2. What to Know Before Starting the Course.vtt
|
VTT
|
7.2 KB
|
|
|
2.1 Step 1 Download Oracle Virtual Box.html
|
HTML
|
102 B
|
|
|
2.2 Linux Operating System Username and Password.txt.txt
|
TXT
|
204 B
|
|
|
2.3 Step 2 Download Virtual Machine Image Link.html
|
HTML
|
102 B
|
|
|
2.4 Oracle Master Changing Virtual Machine Keyboard Input Settings (SQL Tuning Masterclass).pdf.pdf
|
PDF
|
876.9 KB
|
|
|
20. CODE Union Operators.html
|
HTML
|
307 B
|
|
|
21. Intersect Operator.mp4
|
MP4
|
45.4 MB
|
|
|
21. Intersect Operator.vtt
|
VTT
|
5.2 KB
|
|
|
22. CODE Intersect Operator.html
|
HTML
|
614 B
|
|
|
23. Minus Operator.mp4
|
MP4
|
14.9 MB
|
|
|
23. Minus Operator.vtt
|
VTT
|
1.8 KB
|
|
|
24. CODE Minus Operator.html
|
HTML
|
409 B
|
|
|
3. Effective Schema Design.mp4
|
MP4
|
88 MB
|
|
|
3. Effective Schema Design.vtt
|
VTT
|
9.8 KB
|
|
|
3. Generating Statistics (Part 2).mp4
|
MP4
|
80 MB
|
|
|
3. Generating Statistics (Part 2).vtt
|
VTT
|
8.2 KB
|
|
|
3. How to use Hints (Code Samples).html
|
HTML
|
2.8 KB
|
|
|
3. Nested Loop Join (Code Samples).html
|
HTML
|
1 KB
|
|
|
3. Option 2 Downloading And Installing Oracle Database.mp4
|
MP4
|
105.5 MB
|
|
|
3. Option 2 Downloading And Installing Oracle Database.vtt
|
VTT
|
8.3 KB
|
|
|
3. Oracle Database Architecture Overview (Part 2).mp4
|
MP4
|
88 MB
|
|
|
3. Oracle Database Architecture Overview (Part 2).vtt
|
VTT
|
6.5 KB
|
|
|
3. Table Access Full.mp4
|
MP4
|
91.4 MB
|
|
|
3. Table Access Full.vtt
|
VTT
|
8.3 KB
|
|
|
3. Using the Real-Time SQL Monitoring Tool Part 1.mp4
|
MP4
|
120.7 MB
|
|
|
3. Using the Real-Time SQL Monitoring Tool Part 1.mp4.jpg
|
JPG
|
75.8 KB
|
|
|
3. Using the Real-Time SQL Monitoring Tool Part 1.txt
|
TXT
|
204 B
|
|
|
3. Using the Real-Time SQL Monitoring Tool Part 1.vtt
|
VTT
|
11.5 KB
|
|
|
3. View Operator.mp4
|
MP4
|
63.6 MB
|
|
|
3. View Operator.vtt
|
VTT
|
7.3 KB
|
|
|
3. Welcome! +Course Notes.html
|
HTML
|
1.1 KB
|
|
|
3.1 (Oracle Master) SQL & Performance Tuning Document.pdf.pdf
|
PDF
|
5.2 MB
|
|
|
4. CODE View Operator.html
|
HTML
|
1.6 KB
|
|
|
4. Database Data Blocks in Detail.mp4
|
MP4
|
74.5 MB
|
|
|
4. Database Data Blocks in Detail.vtt
|
VTT
|
9.5 KB
|
|
|
4. Generating Statistics (Part 3).mp4
|
MP4
|
104.8 MB
|
|
|
4. Generating Statistics (Part 3).vtt
|
VTT
|
9.4 KB
|
|
|
4. Installing SH Schema.mp4
|
MP4
|
62.9 MB
|
|
|
4. Installing SH Schema.vtt
|
VTT
|
5.9 KB
|
|
|
4. List of Some Useful Hints.html
|
HTML
|
512 B
|
|
|
4. Rest is On Production. Will be ready soon!.html
|
HTML
|
307 B
|
|
|
4. Sort Merge Joins.mp4
|
MP4
|
99.4 MB
|
|
|
4. Sort Merge Joins.vtt
|
VTT
|
10.2 KB
|
|
|
4. Table Access Full (Code Samples).html
|
HTML
|
409 B
|
|
|
4. Table Partitioning.mp4
|
MP4
|
74.8 MB
|
|
|
4. Table Partitioning.vtt
|
VTT
|
8.1 KB
|
|
|
4.1 HINTS Working Document for our Students(Oracle Master).pdf.pdf
|
PDF
|
288.2 KB
|
|
|
4.1 sample_schemas.zip.zip
|
ZIP
|
14 MB
|
|
|
4.2 sh_installation_codes.pdf.pdf
|
PDF
|
51.3 KB
|
|
|
5. Clusters.mp4
|
MP4
|
144 MB
|
|
|
5. Clusters.vtt
|
VTT
|
14.8 KB
|
|
|
5. Generating Statistics (Code Samples).html
|
HTML
|
1 KB
|
|
|
5. How an SQL Statement is Processed.mp4
|
MP4
|
95.1 MB
|
|
|
5. How an SQL Statement is Processed.vtt
|
VTT
|
10.4 KB
|
|
|
5. How to Install VirtualBox on Mac OSX.html
|
HTML
|
3.8 KB
|
|
|
5. Sort Merge Join (Code Samples).html
|
HTML
|
819 B
|
|
|
5. Table Access by ROWID.mp4
|
MP4
|
58.7 MB
|
|
|
5. Table Access by ROWID.vtt
|
VTT
|
6.1 KB
|
|
|
5. What is PGA.mp4
|
MP4
|
62.4 MB
|
|
|
5. What is PGA.vtt
|
VTT
|
6 KB
|
|
|
6. CODE Clusters.html
|
HTML
|
1.5 KB
|
|
|
6. Configuring and Using SQL Developer.mp4
|
MP4
|
83 MB
|
|
|
6. Configuring and Using SQL Developer.vtt
|
VTT
|
9.2 KB
|
|
|
6. Generating Execution Plan.mp4
|
MP4
|
109.8 MB
|
|
|
6. Generating Execution Plan.vtt
|
VTT
|
12 KB
|
|
|
6. Hash Joins.mp4
|
MP4
|
102.3 MB
|
|
|
6. Hash Joins.vtt
|
VTT
|
11.3 KB
|
|
|
6. Table Access by ROWID (Code Samples).html
|
HTML
|
307 B
|
|
|
6. What is Shared Pool.mp4
|
MP4
|
66.7 MB
|
|
|
6. What is Shared Pool.vtt
|
VTT
|
7.4 KB
|
|
|
6. Why do we need the Optimizer.mp4
|
MP4
|
52.3 MB
|
|
|
6. Why do we need the Optimizer.vtt
|
VTT
|
6.4 KB
|
|
|
7. CODE Hash Joins.html
|
HTML
|
307 B
|
|
|
7. Generating Execution Plan (Code Samples).html
|
HTML
|
307 B
|
|
|
7. Index Unique Scan.mp4
|
MP4
|
43.5 MB
|
|
|
7. Index Unique Scan.vtt
|
VTT
|
4.7 KB
|
|
|
7. Optimizer Overview.mp4
|
MP4
|
31.1 MB
|
|
|
7. Optimizer Overview.vtt
|
VTT
|
3.8 KB
|
|
|
7. Sort Operators.mp4
|
MP4
|
69.1 MB
|
|
|
7. Sort Operators.vtt
|
VTT
|
7.4 KB
|
|
|
7. What is Buffer Cache.mp4
|
MP4
|
57.2 MB
|
|
|
7. What is Buffer Cache.vtt
|
VTT
|
6.1 KB
|
|
|
8. Autotrace.mp4
|
MP4
|
112.5 MB
|
|
|
8. Autotrace.vtt
|
VTT
|
12.4 KB
|
|
|
8. CODE Sort Operators.html
|
HTML
|
409 B
|
|
|
8. Cartesian Joins.mp4
|
MP4
|
62.5 MB
|
|
|
8. Cartesian Joins.vtt
|
VTT
|
6.6 KB
|
|
|
8. Index Range Scan.mp4
|
MP4
|
99.4 MB
|
|
|
8. Index Range Scan.vtt
|
VTT
|
10.3 KB
|
|
|
8. Query Transformer.mp4
|
MP4
|
86.6 MB
|
|
|
8. Query Transformer.vtt
|
VTT
|
10.1 KB
|
|
|
8. What is Redo Log Buffer.mp4
|
MP4
|
47.2 MB
|
|
|
8. What is Redo Log Buffer.vtt
|
VTT
|
4.6 KB
|
|
|
9. Autotrace (Code Samples).html
|
HTML
|
307 B
|
|
|
9. CODE Cartesian Joins.html
|
HTML
|
102 B
|
|
|
9. INLIST Operator.mp4
|
MP4
|
43 MB
|
|
|
9. INLIST Operator.vtt
|
VTT
|
4.3 KB
|
|
|
9. Index Range Scan (Code Samples).html
|
HTML
|
1 KB
|
|
|
9. Selectivity & Cardinality.mp4
|
MP4
|
79.1 MB
|
|
|
9. Selectivity & Cardinality.vtt
|
VTT
|
8.3 KB
|
|
|
9. What is Undo.mp4
|
MP4
|
42.8 MB
|
|
|
9. What is Undo.vtt
|
VTT
|
4.2 KB
|
|
|
ReadMe.txt
|
TXT
|
716 B
|
|
|
Visit Freecourseit.com.url
|
URL
|
307 B
|
|
|
Visit Getnewcourses.com.url
|
URL
|
307 B
|
![Udemy - Oracle SQL Performance Tuning Masterclass 2019 [Getnewcourses]](/upload_files/resize_cache/torrents-posters/22a/174_260_2/22a994f172d73237d26a5c91cf4f43d6.png "Udemy - Oracle SQL Performance Tuning Masterclass 2019 [Getnewcourses]")
