Oracle SQL Performance Tuning Masterclass 2019 | CF120BF5E73080F5F2E663D1FAFBB11D37680B09

Oracle SQL Performance Tuning Masterclass 2019

Name	Oracle SQL Performance Tuning Masterclass 2019	DOWNLOAD Copy Link Trouble downloading? see How To
Total Size	6.6 GB
Total Files	229
Hash	CF120BF5E73080F5F2E663D1FAFBB11D37680B09

/1. SQL & Perfomance Tuning Course Introduction/
1. SQL & Performance Tuning Course Overview.mp4	65.1 MB
2. UDEMY 101 How to Use Udemy +Some Useful Tips.mp4	53.1 MB
3.1 (Oracle Master) SQL & Performance Tuning Document.pdf.pdf	5.4 MB
1. SQL & Performance Tuning Course Overview.vtt	5.8 KB
2. UDEMY 101 How to Use Udemy +Some Useful Tips.vtt	5.5 KB
3. Welcome! +Course Notes.html	1.1 KB
ReadMe.txt	0.7 KB
/10. SQL Tuning Techniques/
2. Ways of Getting the Execution Plan and the Statistics.mp4	196.3 MB
1. How to find a performance problem and its tuning solution.mp4	182.0 MB
3. Using the Real-Time SQL Monitoring Tool Part 1.mp4	126.6 MB
1. How to find a performance problem and its tuning solution.mp4.jpg	78.9 KB
3. Using the Real-Time SQL Monitoring Tool Part 1.mp4.jpg	77.7 KB
2. Ways of Getting the Execution Plan and the Statistics.vtt	18.4 KB
1. How to find a performance problem and its tuning solution.vtt	16.4 KB
3. Using the Real-Time SQL Monitoring Tool Part 1.vtt	11.8 KB
4. Rest is On Production. Will be ready soon!.html	0.3 KB
1. How to find a performance problem and its tuning solution.txt	0.3 KB
3. Using the Real-Time SQL Monitoring Tool Part 1.txt	0.2 KB
/11. Important Information - For Your Attention!/
1. Good news!.html	0.4 KB
/12. Appendix Software Installations/
2. Option 1 Having The Database with Oracle VirtualBox.mp4	172.3 MB
3. Option 2 Downloading And Installing Oracle Database.mp4	110.6 MB
6. Configuring and Using SQL Developer.mp4	87.0 MB
4. Installing SH Schema.mp4	66.0 MB
1. About the Installation.mp4	56.4 MB
4.1 sample_schemas.zip.zip	14.7 MB
2.4 Oracle Master Changing Virtual Machine Keyboard Input Settings (SQL Tuning Masterclass).pdf.pdf	898.0 KB
4.2 sh_installation_codes.pdf.pdf	52.5 KB
2. Option 1 Having The Database with Oracle VirtualBox.vtt	11.6 KB
6. Configuring and Using SQL Developer.vtt	9.5 KB
3. Option 2 Downloading And Installing Oracle Database.vtt	8.5 KB
4. Installing SH Schema.vtt	6.1 KB
5. How to Install VirtualBox on Mac OSX.html	3.9 KB
1. About the Installation.vtt	3.8 KB
2.2 Linux Operating System Username and Password.txt.txt	0.2 KB
2.3 Step 2 Download Virtual Machine Image Link.html	0.1 KB
2.1 Step 1 Download Oracle Virtual Box.html	0.1 KB
/13. Bonus (+) Section/
1.1 Oracle Master Training (Special Discounts for Our Students).xlsx.xlsx	36.4 KB
1. Bonus Lecture for Our Students.html	2.4 KB
/2. What is SQL (Performance) Tuning and Why We Need/
2. What to Know Before Starting the Course.mp4	70.0 MB
1. What is SQL Tuning and Why to Do That.mp4	62.5 MB
2. What to Know Before Starting the Course.mp4.jpg	86.2 KB
2. What to Know Before Starting the Course.vtt	7.4 KB
1. What is SQL Tuning and Why to Do That.vtt	7.0 KB
2. What to Know Before Starting the Course.txt	0.2 KB
/3. Oracle Database Architecture/
2. Oracle Database Architecture Overview (Part 1).mp4	146.5 MB
3. Oracle Database Architecture Overview (Part 2).mp4	92.3 MB
4. Database Data Blocks in Detail.mp4	78.1 MB
13. Logical and Physical Database Structure.mp4	71.1 MB
6. What is Shared Pool.mp4	69.9 MB
5. What is PGA.mp4	65.4 MB
7. What is Buffer Cache.mp4	60.0 MB
10. How a DML is processed and committed.mp4	52.8 MB
8. What is Redo Log Buffer.mp4	49.5 MB
12. Oracle Database Storage Architecture.mp4	49.1 MB
9. What is Undo.mp4	44.9 MB
1. Why to know the Oracle Database Architecture and how much to know.mp4	38.6 MB
11. Automatic Memory Management.mp4	23.6 MB
2. Oracle Database Architecture Overview (Part 1).vtt	10.6 KB
4. Database Data Blocks in Detail.vtt	9.7 KB
6. What is Shared Pool.vtt	7.6 KB
13. Logical and Physical Database Structure.vtt	6.9 KB
3. Oracle Database Architecture Overview (Part 2).vtt	6.7 KB
7. What is Buffer Cache.vtt	6.3 KB
5. What is PGA.vtt	6.2 KB
10. How a DML is processed and committed.vtt	4.9 KB
8. What is Redo Log Buffer.vtt	4.8 KB
12. Oracle Database Storage Architecture.vtt	4.3 KB
9. What is Undo.vtt	4.3 KB
1. Why to know the Oracle Database Architecture and how much to know.vtt	2.9 KB
11. Automatic Memory Management.vtt	2.3 KB
14. Quiz - Database Architecture.html	0.1 KB
/4. SQL Tuning Basics/
14. Query Analysis Strategy.mp4	157.5 MB
13. SQL Tuning Principles and Strategies.mp4	100.9 MB
5. How an SQL Statement is Processed.mp4	99.7 MB
3. Effective Schema Design.mp4	92.3 MB
8. Query Transformer.mp4	90.8 MB
9. Selectivity & Cardinality.mp4	83.0 MB
4. Table Partitioning.mp4	78.4 MB
1. When to Tune.mp4	70.5 MB
2. What is a Bad SQL.mp4	58.2 MB
6. Why do we need the Optimizer.mp4	54.8 MB
10. What is cost in detail.mp4	46.6 MB
11. Plan Generator.mp4	39.7 MB
12. Row Source Generator.mp4	38.3 MB
7. Optimizer Overview.mp4	32.6 MB
14. Query Analysis Strategy.vtt	15.7 KB
5. How an SQL Statement is Processed.vtt	10.6 KB
8. Query Transformer.vtt	10.3 KB
3. Effective Schema Design.vtt	10.0 KB
13. SQL Tuning Principles and Strategies.vtt	9.5 KB
1. When to Tune.vtt	8.8 KB
9. Selectivity & Cardinality.vtt	8.5 KB
4. Table Partitioning.vtt	8.3 KB
6. Why do we need the Optimizer.vtt	6.5 KB
2. What is a Bad SQL.vtt	5.7 KB
10. What is cost in detail.vtt	5.0 KB
11. Plan Generator.vtt	4.2 KB
7. Optimizer Overview.vtt	3.9 KB
12. Row Source Generator.vtt	3.8 KB
15. SQL Tuning Basics Assessment Test.html	0.1 KB
/5. Execution Plans & Statistics/
8. Autotrace.mp4	118.0 MB
12. Reading the Execution Plans (Part 1).mp4	116.1 MB
6. Generating Execution Plan.mp4	115.1 MB
10. V$SQL_PLAN View.mp4	114.7 MB
4. Generating Statistics (Part 3).mp4	109.9 MB
15. Analyzing the Execution Plans.mp4	98.4 MB
3. Generating Statistics (Part 2).mp4	83.9 MB
1. Execution Plan and Explain Plan in Details.mp4	71.0 MB
2. Generating Statistics (Part 1).mp4	65.0 MB
13. Reading the Execution Plans (Part 2).mp4	62.9 MB
12. Reading the Execution Plans (Part 1).vtt	14.3 KB
8. Autotrace.vtt	12.7 KB
6. Generating Execution Plan.vtt	12.2 KB
10. V$SQL_PLAN View.vtt	12.1 KB
13. Reading the Execution Plans (Part 2).vtt	10.7 KB
4. Generating Statistics (Part 3).vtt	9.7 KB
15. Analyzing the Execution Plans.vtt	8.6 KB
3. Generating Statistics (Part 2).vtt	8.4 KB
1. Execution Plan and Explain Plan in Details.vtt	8.4 KB
2. Generating Statistics (Part 1).vtt	7.0 KB
5. Generating Statistics (Code Samples).html	1.1 KB
11. V$SQL_PLAN (Code Samples).html	0.9 KB
16. Analyzing the Execution Plans (Code Samples).html	0.5 KB
7. Generating Execution Plan (Code Samples).html	0.4 KB
9. Autotrace (Code Samples).html	0.3 KB
14. Reading the Execution Plans (Code Samples).html	0.3 KB
17. Execution Plans & Statistics.html	0.1 KB
/6. Table & Index Access Paths/
2. Types of Table and Index Access Paths.mp4	169.4 MB
14. Index Skip Scan.mp4	155.3 MB
1. What are Indexes and How They work in details.mp4	147.9 MB
8. Index Range Scan.mp4	104.2 MB
10. Index Full Scan.mp4	97.0 MB
3. Table Access Full.mp4	95.8 MB
12. Index Fast Full Scan.mp4	63.6 MB
5. Table Access by ROWID.mp4	61.5 MB
16. Index Join Scan.mp4	53.3 MB
7. Index Unique Scan.mp4	45.6 MB
14. Index Skip Scan.vtt	13.8 KB
2. Types of Table and Index Access Paths.vtt	12.4 KB
1. What are Indexes and How They work in details.vtt	10.9 KB
8. Index Range Scan.vtt	10.6 KB
10. Index Full Scan.vtt	9.8 KB
3. Table Access Full.vtt	8.5 KB
12. Index Fast Full Scan.vtt	6.5 KB
5. Table Access by ROWID.vtt	6.2 KB
16. Index Join Scan.vtt	5.6 KB
7. Index Unique Scan.vtt	4.8 KB
11. Index Full Scan (Code Samples).html	1.8 KB
9. Index Range Scan (Code Samples).html	1.1 KB
13. Index Fast Full Scan (Code Samples).html	0.9 KB
15. Index Skip Scan (Code Samples).html	0.8 KB
4. Table Access Full (Code Samples).html	0.4 KB
17. Index Join Scan (Code Samples).html	0.4 KB
6. Table Access by ROWID (Code Samples).html	0.3 KB
18. Table & Index Access Paths.html	0.1 KB
/7. Optimizer Hints/
2. How to use Hints.mp4	136.7 MB
1. What are Hints and Why to Use Them.mp4	44.8 MB
4.1 HINTS Working Document for our Students(Oracle Master).pdf.pdf	295.2 KB
2. How to use Hints.vtt	15.3 KB
1. What are Hints and Why to Use Them.vtt	4.1 KB
3. How to use Hints (Code Samples).html	2.9 KB
4. List of Some Useful Hints.html	0.5 KB
/8. Join Operations/
2. Nested Loop Joins.mp4	122.8 MB
6. Hash Joins.mp4	107.2 MB
4. Sort Merge Joins.mp4	104.2 MB
13. Outer Joins.mp4	94.7 MB
8. Cartesian Joins.mp4	65.5 MB
1. Join Methods Overview.mp4	64.3 MB
15. Semijoins.mp4	53.9 MB
11. Equijoins & Nonequijoins.mp4	36.6 MB
10. Join Types Overview.mp4	35.4 MB
17. Antijoins.mp4	32.1 MB
2. Nested Loop Joins.vtt	12.6 KB
6. Hash Joins.vtt	11.6 KB
13. Outer Joins.vtt	11.4 KB
4. Sort Merge Joins.vtt	10.5 KB
8. Cartesian Joins.vtt	6.8 KB
15. Semijoins.vtt	5.7 KB
1. Join Methods Overview.vtt	5.5 KB
11. Equijoins & Nonequijoins.vtt	3.8 KB
17. Antijoins.vtt	3.2 KB
10. Join Types Overview.vtt	3.1 KB
14. CODE Outer Joins.html	1.1 KB
3. Nested Loop Join (Code Samples).html	1.1 KB
5. Sort Merge Join (Code Samples).html	0.8 KB
18. CODE Antijoins.html	0.7 KB
16. CODE Semijoins.html	0.4 KB
7. CODE Hash Joins.html	0.3 KB
12. CODE Equijoins & Nonequijoins.html	0.3 KB
9. CODE Cartesian Joins.html	0.1 KB
/9. Other Optimizer Operators/
5. Clusters.mp4	151.0 MB
1. Result Cache Operator.mp4	111.8 MB
7. Sort Operators.mp4	72.4 MB
3. View Operator.mp4	66.7 MB
21. Intersect Operator.mp4	47.6 MB
9. INLIST Operator.mp4	45.1 MB
13. First Row Operator.mp4	33.3 MB
11. Count Stopkey Operator.mp4	20.6 MB
17. Concatenation Operator.mp4	20.2 MB
19. UNION Operators.mp4	19.5 MB
23. Minus Operator.mp4	15.6 MB
15. Filter Operator.mp4	9.2 MB
5. Clusters.vtt	15.2 KB
1. Result Cache Operator.vtt	12.2 KB
7. Sort Operators.vtt	7.6 KB
3. View Operator.vtt	7.4 KB
13. First Row Operator.vtt	5.5 KB
21. Intersect Operator.vtt	5.3 KB
9. INLIST Operator.vtt	4.4 KB
11. Count Stopkey Operator.vtt	3.7 KB
17. Concatenation Operator.vtt	3.2 KB
19. UNION Operators.vtt	3.0 KB
23. Minus Operator.vtt	1.8 KB
15. Filter Operator.vtt	1.8 KB
4. CODE View Operator.html	1.7 KB
6. CODE Clusters.html	1.5 KB
10. CODE INLIST Operator.html	0.7 KB
2. CODE Result Cache Operator.html	0.7 KB
22. CODE Intersect Operator.html	0.6 KB
8. CODE Sort Operators.html	0.4 KB
14. CODE First Row Operator.html	0.4 KB
24. CODE Minus Operator.html	0.4 KB
20. CODE Union Operators.html	0.3 KB
12. CODE Count Stopkey Operator.html	0.2 KB
18. CODE Concatenation Operator.html	0.2 KB
16. CODE Filter Operator.html	0.1 KB
/
ReadMe.txt	0.7 KB
Visit Getnewcourses.com.url	0.3 KB
Visit Freecourseit.com.url	0.3 KB
Total files 229