DesireCourse Net Udemy Oracle SQL Performance Tuning Masterclass 2019

DesireCourse Net Udemy Oracle SQL Performance Tuning Masterclass 2019

Name	[DesireCourse.Net] Udemy - Oracle SQL Performance Tuning Masterclass 2019	DOWNLOAD Copy Link
Total Size	6.6 GB
Total Files	235
Hash	7789CC2BF660D4924F1A8E3215B2FA0072C1071D

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