Udemy - Oracle SQL Performance Tuning Masterclass (2025) (5.2023)

Creation Time	Aug. 16, 2025, 11:53 p.m.
Last Access Time	Aug. 17, 2025, 7:47 p.m.
File Size	7.2 GB
Keywords	Tuning Masterclass 2023 - Udemy 2025 5 SQL Oracle Performance
Total Requests	7
Total Files	388
Magnet Link	Please wait ...
	Download (Magnet Link) Play (Watch Online)

13 - Appendix Software Installations/011 Option 2 Downloading and Installing the Oracle Database.mp4 167.5 MB
11 - Tuning with ADVANCED Indexing Techniques/028 Full-Text Searches.mp4 163.0 MB
11 - Tuning with ADVANCED Indexing Techniques/005 Bitmap Indexes in Details.mp4 161.9 MB
12 - Advanced SQL Tuning Techniques/013 Dynamic Statistics (Dynamic Sampling).mp4 146.9 MB
03 - Oracle Database Architecture/003 Oracle Database Architecture Overview (Part 1).mp4 139.7 MB
13 - Appendix Software Installations/013 Option 2 Configuring and Using Oracle SQL Developer.mp4 136.8 MB
06 - Table & Index Access Paths/001 What are Indexes and How They work in details.mp4 113.0 MB
10 - SQL Tuning Techniques/002 Ways of Getting the Execution Plan and the Statistics.mp4 113.0 MB
05 - Execution Plans & Statistics/008 Autotrace.mp4 112.5 MB
11 - Tuning with ADVANCED Indexing Techniques/019 Index-Organized Tables.mp4 111.1 MB
06 - Table & Index Access Paths/014 Index Skip Scan.mp4 110.6 MB
12 - Advanced SQL Tuning Techniques/009 Adaptive Cursor Sharing.mp4 110.4 MB
05 - Execution Plans & Statistics/010 V$SQL_PLAN View.mp4 109.3 MB
10 - SQL Tuning Techniques/007 Using the Trace Files & TKPROF Utility - Part 1.mp4 108.3 MB
12 - Advanced SQL Tuning Techniques/011 Adaptive Plans.mp4 105.8 MB
10 - SQL Tuning Techniques/001 How to find a performance problem and its tuning solution.mp4 105.6 MB
10 - SQL Tuning Techniques/038 Be Careful on Views!.mp4 100.0 MB
13 - Appendix Software Installations/002 The Ways to Get a Database.mp4 99.5 MB
12 - Advanced SQL Tuning Techniques/007 Cursor Sharing.mp4 95.9 MB
13 - Appendix Software Installations/007 Option 1 Configuring the VMware Virtualization Software.mp4 95.0 MB
06 - Table & Index Access Paths/010 Index Full Scan.mp4 92.6 MB
13 - Appendix Software Installations/014 Option 2 Installing Sample Schemas in Oracle Database.mp4 89.6 MB
04 - SQL Tuning Basics/014 Query Analysis Strategy.mp4 89.3 MB
13 - Appendix Software Installations/003 Option 1 Installing VMware and VirtualBox on Windows.mp4 87.9 MB
05 - Execution Plans & Statistics/012 Reading the Execution Plans (Part 1).mp4 83.8 MB
10 - SQL Tuning Techniques/008 Using the Trace Files & TKPROF Utility - Part 2.mp4 81.8 MB
05 - Execution Plans & Statistics/004 Generating Statistics (Part 3).mp4 81.5 MB
11 - Tuning with ADVANCED Indexing Techniques/013 Bitmap Join Indexes.mp4 79.1 MB
11 - Tuning with ADVANCED Indexing Techniques/003 B-Tree Indexes in Details.mp4 78.8 MB
10 - SQL Tuning Techniques/009 Using the Trace Files & TKPROF Utility - Part 3.mp4 77.8 MB
11 - Tuning with ADVANCED Indexing Techniques/008 Composite Indexes and Order of Indexed Columns.mp4 77.7 MB
08 - Join Operations/002 Nested Loop Joins.mp4 76.0 MB
10 - SQL Tuning Techniques/055 Using WITH Clause.mp4 75.5 MB
10 - SQL Tuning Techniques/004 Using the Real-Time SQL Monitoring Tool Part 2.mp4 73.8 MB
13 - Appendix Software Installations/009 Option 1 Configuring SQL Developer inside of the Virtual Machine.mp4 73.5 MB
11 - Tuning with ADVANCED Indexing Techniques/001 Why Indexing is Important.mp4 72.2 MB
10 - SQL Tuning Techniques/003 Using the Real-Time SQL Monitoring Tool Part 1.mp4 72.2 MB
05 - Execution Plans & Statistics/015 Analyzing the Execution Plans.mp4 71.4 MB
12 - Advanced SQL Tuning Techniques/003 Using Bind Variables.mp4 71.2 MB
10 - SQL Tuning Techniques/013 Index Usage.mp4 69.4 MB
09 - Other Optimizer Operators/001 Result Cache Operator.mp4 69.1 MB
05 - Execution Plans & Statistics/006 Generating Execution Plan.mp4 69.1 MB
04 - SQL Tuning Basics/001 When to Tune.mp4 67.2 MB
02 - What is SQL (Performance) Tuning and Why We Need/002 What to Know Before Starting the Course.mp4 66.7 MB
08 - Join Operations/006 Hash Joins.mp4 65.2 MB
10 - SQL Tuning Techniques/051 Using Temporary Tables.mp4 65.2 MB
07 - Optimizer Hints/002 How to use Hints.mp4 64.6 MB
10 - SQL Tuning Techniques/049 Multitable DML Operations.mp4 63.8 MB
08 - Join Operations/004 Sort Merge Joins.mp4 63.4 MB
06 - Table & Index Access Paths/008 Index Range Scan.mp4 62.6 MB
08 - Join Operations/008 Cartesian Joins.mp4 62.5 MB
03 - Oracle Database Architecture/006 What is PGA.mp4 62.4 MB
01 - SQL & Perfomance Tuning Course Introduction/001 SQL & Performance Tuning Course Overview.mp4 62.1 MB
02 - What is SQL (Performance) Tuning and Why We Need/001 What is SQL Tuning and Why to Do That.mp4 59.6 MB
11 - Tuning with ADVANCED Indexing Techniques/015 Combining Bitmap Indexes.mp4 58.0 MB
10 - SQL Tuning Techniques/005 Using the Real-Time SQL Monitoring Tool Part 3.mp4 57.2 MB
10 - SQL Tuning Techniques/032 Retrieving the MIN & MAX Values.mp4 55.9 MB
09 - Other Optimizer Operators/005 Clusters.mp4 55.5 MB
13 - Appendix Software Installations/008 Option 1 Configuring the Oracle VirtualBox Virtualization Software.mp4 55.0 MB
11 - Tuning with ADVANCED Indexing Techniques/002 Index Selectivity & Cardinality.mp4 52.6 MB
06 - Table & Index Access Paths/002 Types of Table and Index Access Paths.mp4 51.4 MB
10 - SQL Tuning Techniques/023 Handling NULL-Based Performance Problems.mp4 51.1 MB
13 - Appendix Software Installations/018 Option 2 Configuring and Using Oracle SQL Developer for Oracle Database 12c.mp4 50.8 MB
11 - Tuning with ADVANCED Indexing Techniques/023 Invisible Indexes.mp4 49.8 MB
03 - Oracle Database Architecture/005 Database Data Blocks in Detail.mp4 46.2 MB
10 - SQL Tuning Techniques/045 Using BULK COLLECT.mp4 44.8 MB
10 - SQL Tuning Techniques/047 Tuning the Join Order.mp4 43.7 MB
11 - Tuning with ADVANCED Indexing Techniques/017 Function-Based Indexes.mp4 43.1 MB
08 - Join Operations/013 Outer Joins.mp4 39.8 MB
11 - Tuning with ADVANCED Indexing Techniques/025 Index Key Compression- Part 1.mp4 38.9 MB
04 - SQL Tuning Basics/008 Query Transformer.mp4 38.6 MB
13 - Appendix Software Installations/006 Option 1 Downloading Virtual Machine Image.mp4 36.9 MB
04 - SQL Tuning Basics/009 Selectivity & Cardinality.mp4 36.7 MB
10 - SQL Tuning Techniques/025 Using EXISTS instead of IN Clause.mp4 36.0 MB
13 - Appendix Software Installations/017 Option 2 Oracle Database 12c Installation into Your Computer.mp4 36.0 MB
06 - Table & Index Access Paths/005 Table Access by ROWID.mp4 35.8 MB
11 - Tuning with ADVANCED Indexing Techniques/026 Index Key Compression- Part 2.mp4 35.7 MB
03 - Oracle Database Architecture/004 Oracle Database Architecture Overview (Part 2).mp4 32.6 MB
10 - SQL Tuning Techniques/040 Create Materialized Views.mp4 32.0 MB
10 - SQL Tuning Techniques/021 Using Functions on the Indexed Columns.mp4 31.8 MB
06 - Table & Index Access Paths/003 Table Access Full.mp4 31.6 MB
10 - SQL Tuning Techniques/030 Tuning Ordered Queries.mp4 30.6 MB
09 - Other Optimizer Operators/003 View Operator.mp4 30.4 MB
11 - Tuning with ADVANCED Indexing Techniques/010 Covering Indexes.mp4 30.2 MB
11 - Tuning with ADVANCED Indexing Techniques/007 Bitmap Operations.mp4 30.1 MB
10 - SQL Tuning Techniques/053 Combining SQL Statements.mp4 29.9 MB
12 - Advanced SQL Tuning Techniques/001 Tuning Star Queries.mp4 29.2 MB
04 - SQL Tuning Basics/005 How an SQL Statement is Processed.mp4 28.5 MB
03 - Oracle Database Architecture/014 Logical and Physical Database Structure.mp4 28.3 MB
06 - Table & Index Access Paths/012 Index Fast Full Scan.mp4 28.0 MB
05 - Execution Plans & Statistics/003 Generating Statistics (Part 2).mp4 27.8 MB
05 - Execution Plans & Statistics/013 Reading the Execution Plans (Part 2).mp4 27.4 MB
09 - Other Optimizer Operators/007 Sort Operators.mp4 26.8 MB
05 - Execution Plans & Statistics/001 Execution Plan and Explain Plan in Details.mp4 26.6 MB
10 - SQL Tuning Techniques/011 Get What You Need Only.mp4 25.8 MB
03 - Oracle Database Architecture/010 What is Undo.mp4 25.2 MB
10 - SQL Tuning Techniques/043 Partition Pruning.mp4 25.1 MB
04 - SQL Tuning Basics/003 Effective Schema Design.mp4 25.1 MB
04 - SQL Tuning Basics/013 SQL Tuning Principles and Strategies.mp4 24.9 MB
11 - Tuning with ADVANCED Indexing Techniques/021 Cluster Indexes.mp4 24.1 MB
03 - Oracle Database Architecture/007 What is Shared Pool.mp4 24.0 MB
05 - Execution Plans & Statistics/002 Generating Statistics (Part 1).mp4 23.5 MB
10 - SQL Tuning Techniques/019 Using Like Conditions.mp4 23.2 MB
10 - SQL Tuning Techniques/028 Data Type Mismatch.mp4 22.6 MB
04 - SQL Tuning Basics/012 Row Source Generator.mp4 22.4 MB
12 - Advanced SQL Tuning Techniques/005 Beware of Bind Variable Peeking.mp4 21.3 MB
04 - SQL Tuning Basics/004 Table Partitioning.mp4 21.3 MB
04 - SQL Tuning Basics/006 Why do we need the Optimizer.mp4 21.0 MB
01 - SQL & Perfomance Tuning Course Introduction/003 Course-Slide-for-Students-SQL-Performance-Tuning-Masterclass-2023.pdf 20.9 MB
10 - SQL Tuning Techniques/036 Avoid Using the HAVING Clause!.mp4 20.2 MB
03 - Oracle Database Architecture/002 Why to know the Oracle Database Architecture and how much to know.mp4 20.1 MB
03 - Oracle Database Architecture/008 What is Buffer Cache.mp4 20.0 MB
10 - SQL Tuning Techniques/034 UNION and UNION ALL Operators (Which one is faster).mp4 19.8 MB
06 - Table & Index Access Paths/016 Index Join Scan.mp4 19.4 MB
07 - Optimizer Hints/001 What are Hints and Why to Use Them.mp4 19.2 MB
10 - SQL Tuning Techniques/042 Avoid Commit Too Much or Too Less!.mp4 18.9 MB
10 - SQL Tuning Techniques/057 Using Analytical Functions.mp4 18.6 MB
10 - SQL Tuning Techniques/026 Using TRUNCATE instead of DELETE command.mp4 18.5 MB
03 - Oracle Database Architecture/013 Oracle Database Storage Architecture.mp4 18.4 MB
01 - SQL & Perfomance Tuning Course Introduction/002 UDEMY 101 How to Use Udemy +Some Useful Tips (Do not Skip).mp4 17.7 MB
13 - Appendix Software Installations/001 About the Database Installation.mp4 17.5 MB
13 - Appendix Software Installations/012 Option 2 Unlocking the HR Schema.mp4 17.0 MB
03 - Oracle Database Architecture/011 How a DML is processed and committed.mp4 16.9 MB
08 - Join Operations/015 Semijoins.mp4 16.5 MB
03 - Oracle Database Architecture/009 What is Redo Log Buffer.mp4 16.4 MB
09 - Other Optimizer Operators/009 INLIST Operator.mp4 16.3 MB
08 - Join Operations/001 Join Methods Overview.mp4 15.9 MB
06 - Table & Index Access Paths/007 Index Unique Scan.mp4 15.7 MB
09 - Other Optimizer Operators/021 Intersect Operator.mp4 15.3 MB
11 - Tuning with ADVANCED Indexing Techniques/012 Reverse Key Indexes.mp4 14.6 MB
04 - SQL Tuning Basics/002 What is a Bad SQL.mp4 14.4 MB
04 - SQL Tuning Basics/011 Plan Generator.mp4 14.3 MB
13 - Appendix Software Installations/014 sample-schemas.zip 14.0 MB
04 - SQL Tuning Basics/010 What is cost in detail.mp4 13.5 MB
08 - Join Operations/011 Equijoins & Nonequijoins.mp4 13.3 MB
08 - Join Operations/017 Antijoins.mp4 12.6 MB
10 - SQL Tuning Techniques/015 Using Concatenation Operator.mp4 12.5 MB
09 - Other Optimizer Operators/013 First Row Operator.mp4 12.3 MB
10 - SQL Tuning Techniques/017 Using Arithmetic Operators.mp4 12.2 MB
13 - Appendix Software Installations/010 Option 2 What is Pluggable Database.mp4 11.4 MB
04 - SQL Tuning Basics/007 Optimizer Overview.mp4 9.6 MB
03 - Oracle Database Architecture/012 Automatic Memory Management.mp4 9.4 MB
08 - Join Operations/010 Join Types Overview.mp4 9.0 MB
09 - Other Optimizer Operators/011 Count Stopkey Operator.mp4 7.5 MB
09 - Other Optimizer Operators/017 Concatenation Operator.mp4 7.1 MB
09 - Other Optimizer Operators/019 UNION Operators.mp4 6.7 MB
09 - Other Optimizer Operators/023 Minus Operator.mp4 6.0 MB
09 - Other Optimizer Operators/015 Filter Operator.mp4 3.2 MB
10 - SQL Tuning Techniques/007 TKPROF-Sorting-Options.pdf 401.3 KB
07 - Optimizer Hints/004 HINTS-Working-Document-for-our-Students-Oracle-Master.pdf 288.2 KB
13 - Appendix Software Installations/012 -Oracle-Master-Training-Scripts-to-Unlock-the-HR-Schema.pdf 230.8 KB
13 - Appendix Software Installations/013 Option 2 Configuring and Using Oracle SQL Developer.srt 26.7 KB
10 - SQL Tuning Techniques/008 Using the Trace Files & TKPROF Utility - Part 2.srt 25.5 KB
11 - Tuning with ADVANCED Indexing Techniques/028 Full-Text Searches.srt 24.3 KB
13 - Appendix Software Installations/011 Option 2 Downloading and Installing the Oracle Database.srt 22.1 KB
11 - Tuning with ADVANCED Indexing Techniques/005 Bitmap Indexes in Details.srt 21.9 KB
10 - SQL Tuning Techniques/002 Ways of Getting the Execution Plan and the Statistics.srt 21.2 KB
11 - Tuning with ADVANCED Indexing Techniques/019 Index-Organized Tables.srt 20.3 KB
10 - SQL Tuning Techniques/007 Using the Trace Files & TKPROF Utility - Part 1.srt 20.0 KB
13 - Appendix Software Installations/002 The Ways to Get a Database.srt 20.0 KB
12 - Advanced SQL Tuning Techniques/013 Dynamic Statistics (Dynamic Sampling).srt 19.8 KB
10 - SQL Tuning Techniques/001 How to find a performance problem and its tuning solution.srt 19.3 KB
10 - SQL Tuning Techniques/013 Index Usage.srt 19.3 KB
07 - Optimizer Hints/002 How to use Hints.srt 19.3 KB
12 - Advanced SQL Tuning Techniques/009 Adaptive Cursor Sharing.srt 18.5 KB
09 - Other Optimizer Operators/005 Clusters.srt 17.9 KB
12 - Advanced SQL Tuning Techniques/007 Cursor Sharing.srt 17.3 KB
10 - SQL Tuning Techniques/004 Using the Real-Time SQL Monitoring Tool Part 2.srt 17.0 KB
04 - SQL Tuning Basics/014 Query Analysis Strategy.srt 17.0 KB
06 - Table & Index Access Paths/014 Index Skip Scan.srt 16.3 KB
13 - Appendix Software Installations/009 Option 1 Configuring SQL Developer inside of the Virtual Machine.srt 16.0 KB
12 - Advanced SQL Tuning Techniques/011 Adaptive Plans.srt 15.8 KB
05 - Execution Plans & Statistics/012 Reading the Execution Plans (Part 1).srt 15.3 KB
08 - Join Operations/002 Nested Loop Joins.srt 15.0 KB
09 - Other Optimizer Operators/001 Result Cache Operator.srt 14.9 KB
10 - SQL Tuning Techniques/005 Using the Real-Time SQL Monitoring Tool Part 3.srt 14.8 KB
06 - Table & Index Access Paths/002 Types of Table and Index Access Paths.srt 14.3 KB
11 - Tuning with ADVANCED Indexing Techniques/003 B-Tree Indexes in Details.srt 14.1 KB
05 - Execution Plans & Statistics/008 Autotrace.srt 13.8 KB
08 - Join Operations/006 Hash Joins.srt 13.7 KB
08 - Join Operations/013 Outer Joins.srt 13.7 KB
10 - SQL Tuning Techniques/003 Using the Real-Time SQL Monitoring Tool Part 1.srt 13.3 KB
05 - Execution Plans & Statistics/006 Generating Execution Plan.srt 13.2 KB
11 - Tuning with ADVANCED Indexing Techniques/026 Index Key Compression- Part 2.srt 13.1 KB
10 - SQL Tuning Techniques/032 Retrieving the MIN & MAX Values.srt 13.0 KB
05 - Execution Plans & Statistics/010 V$SQL_PLAN View.srt 13.0 KB
06 - Table & Index Access Paths/001 What are Indexes and How They work in details.srt 13.0 KB
10 - SQL Tuning Techniques/009 Using the Trace Files & TKPROF Utility - Part 3.srt 12.7 KB
06 - Table & Index Access Paths/008 Index Range Scan.srt 12.6 KB
11 - Tuning with ADVANCED Indexing Techniques/008 Composite Indexes and Order of Indexed Columns.srt 12.6 KB
10 - SQL Tuning Techniques/038 Be Careful on Views!.srt 12.3 KB
08 - Join Operations/004 Sort Merge Joins.srt 12.3 KB
10 - SQL Tuning Techniques/045 Using BULK COLLECT.srt 12.0 KB
05 - Execution Plans & Statistics/013 Reading the Execution Plans (Part 2).srt 12.0 KB
03 - Oracle Database Architecture/003 Oracle Database Architecture Overview (Part 1).srt 11.4 KB
11 - Tuning with ADVANCED Indexing Techniques/013 Bitmap Join Indexes.srt 11.4 KB
06 - Table & Index Access Paths/010 Index Full Scan.srt 11.4 KB
04 - SQL Tuning Basics/005 How an SQL Statement is Processed.srt 11.4 KB
13 - Appendix Software Installations/018 Option 2 Configuring and Using Oracle SQL Developer for Oracle Database 12c.srt 11.3 KB
04 - SQL Tuning Basics/008 Query Transformer.srt 11.1 KB
11 - Tuning with ADVANCED Indexing Techniques/017 Function-Based Indexes.srt 11.1 KB
04 - SQL Tuning Basics/003 Effective Schema Design.srt 10.8 KB
05 - Execution Plans & Statistics/004 Generating Statistics (Part 3).srt 10.4 KB
03 - Oracle Database Architecture/005 Database Data Blocks in Detail.srt 10.3 KB
13 - Appendix Software Installations/017 Option 2 Oracle Database 12c Installation into Your Computer.srt 10.3 KB
04 - SQL Tuning Basics/013 SQL Tuning Principles and Strategies.srt 10.2 KB
12 - Advanced SQL Tuning Techniques/003 Using Bind Variables.srt 9.8 KB
13 - Appendix Software Installations/007 Option 1 Configuring the VMware Virtualization Software.srt 9.7 KB
05 - Execution Plans & Statistics/015 Analyzing the Execution Plans.srt 9.6 KB
06 - Table & Index Access Paths/003 Table Access Full.srt 9.5 KB
11 - Tuning with ADVANCED Indexing Techniques/015 Combining Bitmap Indexes.srt 9.5 KB
11 - Tuning with ADVANCED Indexing Techniques/010 Covering Indexes.srt 9.5 KB
04 - SQL Tuning Basics/001 When to Tune.srt 9.5 KB
11 - Tuning with ADVANCED Indexing Techniques/021 Cluster Indexes.srt 9.4 KB
11 - Tuning with ADVANCED Indexing Techniques/023 Invisible Indexes.srt 9.3 KB
04 - SQL Tuning Basics/009 Selectivity & Cardinality.srt 9.3 KB
10 - SQL Tuning Techniques/055 Using WITH Clause.srt 9.2 KB
10 - SQL Tuning Techniques/051 Using Temporary Tables.srt 9.2 KB
10 - SQL Tuning Techniques/023 Handling NULL-Based Performance Problems.srt 9.2 KB
09 - Other Optimizer Operators/007 Sort Operators.srt 9.2 KB
13 - Appendix Software Installations/012 Option 2 Unlocking the HR Schema.srt 9.2 KB
10 - SQL Tuning Techniques/011 Get What You Need Only.srt 9.1 KB
05 - Execution Plans & Statistics/003 Generating Statistics (Part 2).srt 9.1 KB
05 - Execution Plans & Statistics/001 Execution Plan and Explain Plan in Details.srt 9.0 KB
04 - SQL Tuning Basics/004 Table Partitioning.srt 9.0 KB
10 - SQL Tuning Techniques/030 Tuning Ordered Queries.srt 8.8 KB
09 - Other Optimizer Operators/003 View Operator.srt 8.8 KB
11 - Tuning with ADVANCED Indexing Techniques/007 Bitmap Operations.srt 8.8 KB
10 - SQL Tuning Techniques/049 Multitable DML Operations.srt 8.8 KB
12 - Advanced SQL Tuning Techniques/001 Tuning Star Queries.srt 8.7 KB
10 - SQL Tuning Techniques/040 Create Materialized Views.srt 8.6 KB
13 - Appendix Software Installations/014 Option 2 Installing Sample Schemas in Oracle Database.srt 8.6 KB
13 - Appendix Software Installations/003 Option 1 Installing VMware and VirtualBox on Windows.srt 8.5 KB
10 - SQL Tuning Techniques/019 Using Like Conditions.srt 8.4 KB
13 - Appendix Software Installations/008 Option 1 Configuring the Oracle VirtualBox Virtualization Software.srt 8.2 KB
03 - Oracle Database Architecture/007 What is Shared Pool.srt 8.1 KB
10 - SQL Tuning Techniques/047 Tuning the Join Order.srt 8.0 KB
08 - Join Operations/008 Cartesian Joins.srt 8.0 KB
02 - What is SQL (Performance) Tuning and Why We Need/002 What to Know Before Starting the Course.srt 7.9 KB
06 - Table & Index Access Paths/012 Index Fast Full Scan.srt 7.8 KB
02 - What is SQL (Performance) Tuning and Why We Need/001 What is SQL Tuning and Why to Do That.srt 7.6 KB
05 - Execution Plans & Statistics/002 Generating Statistics (Part 1).srt 7.5 KB
10 - SQL Tuning Techniques/043 Partition Pruning.srt 7.5 KB
06 - Table & Index Access Paths/005 Table Access by ROWID.srt 7.4 KB
03 - Oracle Database Architecture/014 Logical and Physical Database Structure.srt 7.3 KB
03 - Oracle Database Architecture/004 Oracle Database Architecture Overview (Part 2).srt 7.2 KB
08 - Join Operations/015 Semijoins.srt 7.1 KB
11 - Tuning with ADVANCED Indexing Techniques/002 Index Selectivity & Cardinality.srt 7.1 KB
04 - SQL Tuning Basics/006 Why do we need the Optimizer.srt 7.1 KB
10 - SQL Tuning Techniques/028 Data Type Mismatch.srt 7.0 KB
11 - Tuning with ADVANCED Indexing Techniques/025 Index Key Compression- Part 1.srt 7.0 KB
11 - Tuning with ADVANCED Indexing Techniques/001 Why Indexing is Important.srt 6.9 KB
03 - Oracle Database Architecture/008 What is Buffer Cache.srt 6.7 KB
03 - Oracle Database Architecture/006 What is PGA.srt 6.7 KB
12 - Advanced SQL Tuning Techniques/005 Beware of Bind Variable Peeking.srt 6.6 KB
09 - Other Optimizer Operators/013 First Row Operator.srt 6.5 KB
09 - Other Optimizer Operators/021 Intersect Operator.srt 6.4 KB
10 - SQL Tuning Techniques/025 Using EXISTS instead of IN Clause.srt 6.4 KB
06 - Table & Index Access Paths/016 Index Join Scan.srt 6.4 KB
08 - Join Operations/001 Join Methods Overview.srt 6.3 KB
10 - SQL Tuning Techniques/036 Avoid Using the HAVING Clause!.srt 6.3 KB
01 - SQL & Perfomance Tuning Course Introduction/001 SQL & Performance Tuning Course Overview.srt 6.3 KB
04 - SQL Tuning Basics/002 What is a Bad SQL.srt 6.2 KB
10 - SQL Tuning Techniques/021 Using Functions on the Indexed Columns.srt 6.1 KB
10 - SQL Tuning Techniques/057 Using Analytical Functions.srt 6.0 KB
10 - SQL Tuning Techniques/053 Combining SQL Statements.srt 6.0 KB
01 - SQL & Perfomance Tuning Course Introduction/002 UDEMY 101 How to Use Udemy +Some Useful Tips (Do not Skip).srt 5.9 KB
10 - SQL Tuning Techniques/042 Avoid Commit Too Much or Too Less!.srt 5.6 KB
10 - SQL Tuning Techniques/026 Using TRUNCATE instead of DELETE command.srt 5.5 KB
06 - Table & Index Access Paths/007 Index Unique Scan.srt 5.4 KB
04 - SQL Tuning Basics/010 What is cost in detail.srt 5.4 KB
03 - Oracle Database Architecture/011 How a DML is processed and committed.srt 5.2 KB
03 - Oracle Database Architecture/009 What is Redo Log Buffer.srt 5.1 KB
09 - Other Optimizer Operators/009 INLIST Operator.srt 5.1 KB
13 - Appendix Software Installations/006 Option 1 Downloading Virtual Machine Image.srt 4.8 KB
03 - Oracle Database Architecture/013 Oracle Database Storage Architecture.srt 4.6 KB
07 - Optimizer Hints/001 What are Hints and Why to Use Them.srt 4.6 KB
03 - Oracle Database Architecture/010 What is Undo.srt 4.6 KB
09 - Other Optimizer Operators/011 Count Stopkey Operator.srt 4.6 KB
13 - Appendix Software Installations/001 About the Database Installation.srt 4.5 KB
13 - Appendix Software Installations/004 Option 1 How to Install the Virtual Box on Mac OS X.html 4.5 KB
11 - Tuning with ADVANCED Indexing Techniques/012 Reverse Key Indexes.srt 4.4 KB
04 - SQL Tuning Basics/011 Plan Generator.srt 4.4 KB
08 - Join Operations/011 Equijoins & Nonequijoins.srt 4.4 KB
10 - SQL Tuning Techniques/015 Using Concatenation Operator.srt 4.3 KB
04 - SQL Tuning Basics/007 Optimizer Overview.srt 4.2 KB
04 - SQL Tuning Basics/012 Row Source Generator.srt 4.1 KB
10 - SQL Tuning Techniques/017 Using Arithmetic Operators.srt 3.9 KB
10 - SQL Tuning Techniques/034 UNION and UNION ALL Operators (Which one is faster).srt 3.8 KB
08 - Join Operations/017 Antijoins.srt 3.8 KB
13 - Appendix Software Installations/010 Option 2 What is Pluggable Database.srt 3.7 KB
08 - Join Operations/010 Join Types Overview.srt 3.7 KB
09 - Other Optimizer Operators/017 Concatenation Operator.srt 3.7 KB
09 - Other Optimizer Operators/019 UNION Operators.srt 3.6 KB
03 - Oracle Database Architecture/002 Why to know the Oracle Database Architecture and how much to know.srt 3.1 KB
13 - Appendix Software Installations/016 Option 2 How to Unlock the HR Schema in the Oracle Database 12c.html 3.0 KB
07 - Optimizer Hints/003 How to use Hints (Code Samples).html 2.9 KB
14 - Bonus/001 Bonus Lecture.html 2.6 KB
03 - Oracle Database Architecture/012 Automatic Memory Management.srt 2.5 KB
10 - SQL Tuning Techniques/056 CODE Using WITH Clause.html 2.4 KB
09 - Other Optimizer Operators/023 Minus Operator.srt 2.2 KB
09 - Other Optimizer Operators/015 Filter Operator.srt 2.1 KB
10 - SQL Tuning Techniques/050 CODE Multitable DML Operations.html 1.9 KB
06 - Table & Index Access Paths/011 Index Full Scan (Code Samples).html 1.8 KB
10 - SQL Tuning Techniques/046 CODE Using BULK COLLECT.html 1.8 KB
09 - Other Optimizer Operators/004 CODE View Operator.html 1.7 KB
11 - Tuning with ADVANCED Indexing Techniques/029 CODE Full-Text Search Indexes.html 1.6 KB
10 - SQL Tuning Techniques/014 CODE Index Usage.html 1.6 KB
12 - Advanced SQL Tuning Techniques/008 CODE Cursor Sharing.html 1.6 KB
11 - Tuning with ADVANCED Indexing Techniques/014 CODE Bitmap Join Indexes.html 1.5 KB
09 - Other Optimizer Operators/006 CODE Clusters.html 1.5 KB
12 - Advanced SQL Tuning Techniques/004 CODE Using Bind Variables.html 1.5 KB
10 - SQL Tuning Techniques/052 CODE Using Temporary Tables.html 1.4 KB
10 - SQL Tuning Techniques/039 CODE Be Careful on Views!.html 1.4 KB
11 - Tuning with ADVANCED Indexing Techniques/022 CODE Cluster Indexes.html 1.4 KB
11 - Tuning with ADVANCED Indexing Techniques/006 CODE Bitmap Indexes in Details.html 1.4 KB
11 - Tuning with ADVANCED Indexing Techniques/020 CODE Index-Organized Tables.html 1.4 KB
13 - Appendix Software Installations/015 Extra 12c Installation.html 1.4 KB
03 - Oracle Database Architecture/001 Do You Have a Running Database in Your PC.html 1.3 KB
12 - Advanced SQL Tuning Techniques/010 CODE Adaptive Cursor Sharing.html 1.3 KB
11 - Tuning with ADVANCED Indexing Techniques/016 CODE Combining Bitmap Indexes.html 1.3 KB
13 - Appendix Software Installations/014 Installation-Code.txt 1.3 KB
12 - Advanced SQL Tuning Techniques/002 CODE Tuning Star Queries.html 1.3 KB
12 - Advanced SQL Tuning Techniques/014 CODE Dynamic Statistics (Dynamic Sampling).html 1.3 KB
13 - Appendix Software Installations/005 Option 1 Downloading Virtual Machine Image (19c).html 1.2 KB
01 - SQL & Perfomance Tuning Course Introduction/003 Welcome Gift! + Course Document.html 1.2 KB
10 - SQL Tuning Techniques/024 CODE Handling NULL-Based Performance Problems.html 1.1 KB
11 - Tuning with ADVANCED Indexing Techniques/004 CODE B-Tree Indexes in Details.html 1.1 KB
08 - Join Operations/014 CODE Outer Joins.html 1.1 KB
10 - SQL Tuning Techniques/041 CODE Create Materialized Views.html 1.1 KB
05 - Execution Plans & Statistics/005 Generating Statistics (Code Samples).html 1.1 KB
08 - Join Operations/003 Nested Loop Join (Code Samples).html 1.1 KB
06 - Table & Index Access Paths/009 Index Range Scan (Code Samples).html 1.1 KB
11 - Tuning with ADVANCED Indexing Techniques/027 CODE Index Key Compression.html 1.0 KB
05 - Execution Plans & Statistics/011 V$SQL_PLAN (Code Samples).html 933 bytes
06 - Table & Index Access Paths/013 Index Fast Full Scan (Code Samples).html 891 bytes
11 - Tuning with ADVANCED Indexing Techniques/018 CODE Function-Based Indexes.html 880 bytes
10 - SQL Tuning Techniques/048 CODE Tuning the Join Order.html 845 bytes
08 - Join Operations/005 Sort Merge Join (Code Samples).html 843 bytes
10 - SQL Tuning Techniques/054 CODE Combining SQL Statements.html 842 bytes
06 - Table & Index Access Paths/015 Index Skip Scan (Code Samples).html 841 bytes
10 - SQL Tuning Techniques/010 CODE Using the Trace Files & TKPROF Utility.html 792 bytes
12 - Advanced SQL Tuning Techniques/006 CODE Beware of Bind Variable Peeking.html 764 bytes
09 - Other Optimizer Operators/010 CODE INLIST Operator.html 753 bytes
09 - Other Optimizer Operators/002 CODE Result Cache Operator.html 711 bytes
10 - SQL Tuning Techniques/058 CODE Using Analytical Functions.html 701 bytes
08 - Join Operations/018 CODE Antijoins.html 690 bytes
10 - SQL Tuning Techniques/006 CODE Using the Real-Time SQL Monitoring Tool.html 675 bytes
11 - Tuning with ADVANCED Indexing Techniques/009 CODE Composite Indexes and Order of Indexed Columns.html 654 bytes
10 - SQL Tuning Techniques/033 CODE Retrieving the MIN & MAX Values.html 642 bytes
10 - SQL Tuning Techniques/029 CODE Data Type Mismatch.html 627 bytes
09 - Other Optimizer Operators/022 CODE Intersect Operator.html 622 bytes
11 - Tuning with ADVANCED Indexing Techniques/011 CODE Covering Indexes.html 587 bytes
10 - SQL Tuning Techniques/022 CODE Using Functions on the Indexed Columns.html 580 bytes
10 - SQL Tuning Techniques/020 CODE Using Like Conditions.html 570 bytes
05 - Execution Plans & Statistics/016 Analyzing the Execution Plans (Code Samples).html 563 bytes
12 - Advanced SQL Tuning Techniques/012 CODE Adaptive Plans.html 549 bytes
10 - SQL Tuning Techniques/031 CODE Tuning Ordered Queries.html 536 bytes
07 - Optimizer Hints/004 List of Some Useful Hints.html 501 bytes
06 - Table & Index Access Paths/004 Table Access Full (Code Samples).html 456 bytes
11 - Tuning with ADVANCED Indexing Techniques/024 CODE Invisible Indexes.html 452 bytes
10 - SQL Tuning Techniques/037 CODE Avoid Using the HAVING Clause!.html 442 bytes
08 - Join Operations/016 CODE Semijoins.html 408 bytes
10 - SQL Tuning Techniques/035 UNION and UNION ALL Operators (Which one is faster).html 408 bytes
09 - Other Optimizer Operators/008 CODE Sort Operators.html 405 bytes
06 - Table & Index Access Paths/017 Index Join Scan (Code Samples).html 386 bytes
09 - Other Optimizer Operators/014 CODE First Row Operator.html 383 bytes
13 - Appendix Software Installations/external-links.txt 381 bytes
09 - Other Optimizer Operators/024 CODE Minus Operator.html 375 bytes
05 - Execution Plans & Statistics/007 Generating Execution Plan (Code Samples).html 359 bytes
08 - Join Operations/007 CODE Hash Joins.html 349 bytes
05 - Execution Plans & Statistics/009 Autotrace (Code Samples).html 321 bytes
05 - Execution Plans & Statistics/014 Reading the Execution Plans (Code Samples).html 310 bytes
10 - SQL Tuning Techniques/044 CODE Partition Pruning.html 298 bytes
10 - SQL Tuning Techniques/018 CODE Using Arithmetic Operators.html 290 bytes
06 - Table & Index Access Paths/006 Table Access by ROWID (Code Samples).html 288 bytes
10 - SQL Tuning Techniques/016 CODE Using Concatenation Operator.html 272 bytes
08 - Join Operations/012 CODE Equijoins & Nonequijoins.html 265 bytes
09 - Other Optimizer Operators/020 CODE Union Operators.html 264 bytes
10 - SQL Tuning Techniques/027 CODE Using TRUNCATE instead of DELETE command.html 249 bytes
09 - Other Optimizer Operators/012 CODE Count Stopkey Operator.html 215 bytes
09 - Other Optimizer Operators/018 CODE Concatenation Operator.html 201 bytes
10 - SQL Tuning Techniques/012 CODE Get What You Need Only.html 201 bytes
13 - Appendix Software Installations/003 Download-VMware-Workstation-Player.url 155 bytes
09 - Other Optimizer Operators/016 CODE Filter Operator.html 145 bytes
08 - Join Operations/009 CODE Cartesian Joins.html 142 bytes
13 - Appendix Software Installations/006 Download-Virtual-Machine-Image-19c-.url 108 bytes
13 - Appendix Software Installations/003 Download-Oracle-Virtualbox.url 65 bytes

Udemy - Oracle SQL Performance Tuning Masterclass (2025) (5.2023)

File List

Download Torrent

Related Resources

Copyright Infringement