Udemy - Oracle SQL Performance Tuning Masterclass (2025) (5.2023)
大小
7.18 GB
文件数
388
Info Hash:
95F7A0765973DCC581F4170EAC5D3FB42847A3E2
收录时间
2026-01-13 08:37:45
更新时间
2026-01-13 08:37:45
文件列表 (388)
01 - SQL & Perfomance Tuning Course Introduction/001 SQL & Performance Tuning Course Overview.mp4
62.11 MB
01 - SQL & Perfomance Tuning Course Introduction/001 SQL & Performance Tuning Course Overview.srt
6.26 KB
01 - SQL & Perfomance Tuning Course Introduction/002 UDEMY 101 How to Use Udemy +Some Useful Tips (Do not Skip).mp4
17.7 MB
01 - SQL & Perfomance Tuning Course Introduction/002 UDEMY 101 How to Use Udemy +Some Useful Tips (Do not Skip).srt
5.92 KB
01 - SQL & Perfomance Tuning Course Introduction/003 Course-Slide-for-Students-SQL-Performance-Tuning-Masterclass-2023.pdf
20.91 MB
01 - SQL & Perfomance Tuning Course Introduction/003 Welcome Gift! + Course Document.html
1.17 KB
02 - What is SQL (Performance) Tuning and Why We Need/001 What is SQL Tuning and Why to Do That.mp4
59.63 MB
02 - What is SQL (Performance) Tuning and Why We Need/001 What is SQL Tuning and Why to Do That.srt
7.56 KB
02 - What is SQL (Performance) Tuning and Why We Need/002 What to Know Before Starting the Course.mp4
66.72 MB
02 - What is SQL (Performance) Tuning and Why We Need/002 What to Know Before Starting the Course.srt
7.91 KB
03 - Oracle Database Architecture/001 Do You Have a Running Database in Your PC.html
1.3 KB
03 - Oracle Database Architecture/002 Why to know the Oracle Database Architecture and how much to know.mp4
20.07 MB
03 - Oracle Database Architecture/002 Why to know the Oracle Database Architecture and how much to know.srt
3.13 KB
03 - Oracle Database Architecture/003 Oracle Database Architecture Overview (Part 1).mp4
139.67 MB
03 - Oracle Database Architecture/003 Oracle Database Architecture Overview (Part 1).srt
11.45 KB
03 - Oracle Database Architecture/004 Oracle Database Architecture Overview (Part 2).mp4
32.56 MB
03 - Oracle Database Architecture/004 Oracle Database Architecture Overview (Part 2).srt
7.2 KB
03 - Oracle Database Architecture/005 Database Data Blocks in Detail.mp4
46.22 MB
03 - Oracle Database Architecture/005 Database Data Blocks in Detail.srt
10.33 KB
03 - Oracle Database Architecture/006 What is PGA.mp4
62.35 MB
03 - Oracle Database Architecture/006 What is PGA.srt
6.66 KB
03 - Oracle Database Architecture/007 What is Shared Pool.mp4
23.96 MB
03 - Oracle Database Architecture/007 What is Shared Pool.srt
8.12 KB
03 - Oracle Database Architecture/008 What is Buffer Cache.mp4
20.01 MB
03 - Oracle Database Architecture/008 What is Buffer Cache.srt
6.72 KB
03 - Oracle Database Architecture/009 What is Redo Log Buffer.mp4
16.4 MB
03 - Oracle Database Architecture/009 What is Redo Log Buffer.srt
5.13 KB
03 - Oracle Database Architecture/010 What is Undo.mp4
25.24 MB
03 - Oracle Database Architecture/010 What is Undo.srt
4.57 KB
03 - Oracle Database Architecture/011 How a DML is processed and committed.mp4
16.95 MB
03 - Oracle Database Architecture/011 How a DML is processed and committed.srt
5.22 KB
03 - Oracle Database Architecture/012 Automatic Memory Management.mp4
9.36 MB
03 - Oracle Database Architecture/012 Automatic Memory Management.srt
2.52 KB
03 - Oracle Database Architecture/013 Oracle Database Storage Architecture.mp4
18.4 MB
03 - Oracle Database Architecture/013 Oracle Database Storage Architecture.srt
4.63 KB
03 - Oracle Database Architecture/014 Logical and Physical Database Structure.mp4
28.34 MB
03 - Oracle Database Architecture/014 Logical and Physical Database Structure.srt
7.34 KB
04 - SQL Tuning Basics/001 When to Tune.mp4
67.23 MB
04 - SQL Tuning Basics/001 When to Tune.srt
9.46 KB
04 - SQL Tuning Basics/002 What is a Bad SQL.mp4
14.4 MB
04 - SQL Tuning Basics/002 What is a Bad SQL.srt
6.2 KB
04 - SQL Tuning Basics/003 Effective Schema Design.mp4
25.08 MB
04 - SQL Tuning Basics/003 Effective Schema Design.srt
10.79 KB
04 - SQL Tuning Basics/004 Table Partitioning.mp4
21.26 MB
04 - SQL Tuning Basics/004 Table Partitioning.srt
8.97 KB
04 - SQL Tuning Basics/005 How an SQL Statement is Processed.mp4
28.52 MB
04 - SQL Tuning Basics/005 How an SQL Statement is Processed.srt
11.4 KB
04 - SQL Tuning Basics/006 Why do we need the Optimizer.mp4
20.96 MB
04 - SQL Tuning Basics/006 Why do we need the Optimizer.srt
7.06 KB
04 - SQL Tuning Basics/007 Optimizer Overview.mp4
9.61 MB
04 - SQL Tuning Basics/007 Optimizer Overview.srt
4.15 KB
04 - SQL Tuning Basics/008 Query Transformer.mp4
38.58 MB
04 - SQL Tuning Basics/008 Query Transformer.srt
11.12 KB
04 - SQL Tuning Basics/009 Selectivity & Cardinality.mp4
36.73 MB
04 - SQL Tuning Basics/009 Selectivity & Cardinality.srt
9.25 KB
04 - SQL Tuning Basics/010 What is cost in detail.mp4
13.54 MB
04 - SQL Tuning Basics/010 What is cost in detail.srt
5.42 KB
04 - SQL Tuning Basics/011 Plan Generator.mp4
14.29 MB
04 - SQL Tuning Basics/011 Plan Generator.srt
4.39 KB
04 - SQL Tuning Basics/012 Row Source Generator.mp4
22.4 MB
04 - SQL Tuning Basics/012 Row Source Generator.srt
4.12 KB
04 - SQL Tuning Basics/013 SQL Tuning Principles and Strategies.mp4
24.92 MB
04 - SQL Tuning Basics/013 SQL Tuning Principles and Strategies.srt
10.21 KB
04 - SQL Tuning Basics/014 Query Analysis Strategy.mp4
89.25 MB
04 - SQL Tuning Basics/014 Query Analysis Strategy.srt
16.97 KB
05 - Execution Plans & Statistics/001 Execution Plan and Explain Plan in Details.mp4
26.56 MB
05 - Execution Plans & Statistics/001 Execution Plan and Explain Plan in Details.srt
9.03 KB
05 - Execution Plans & Statistics/002 Generating Statistics (Part 1).mp4
23.54 MB
05 - Execution Plans & Statistics/002 Generating Statistics (Part 1).srt
7.55 KB
05 - Execution Plans & Statistics/003 Generating Statistics (Part 2).mp4
27.8 MB
05 - Execution Plans & Statistics/003 Generating Statistics (Part 2).srt
9.09 KB
05 - Execution Plans & Statistics/004 Generating Statistics (Part 3).mp4
81.46 MB
05 - Execution Plans & Statistics/004 Generating Statistics (Part 3).srt
10.38 KB
05 - Execution Plans & Statistics/005 Generating Statistics (Code Samples).html
1.07 KB
05 - Execution Plans & Statistics/006 Generating Execution Plan.mp4
69.06 MB
05 - Execution Plans & Statistics/006 Generating Execution Plan.srt
13.24 KB
05 - Execution Plans & Statistics/007 Generating Execution Plan (Code Samples).html
359 B
05 - Execution Plans & Statistics/008 Autotrace.mp4
112.51 MB
05 - Execution Plans & Statistics/008 Autotrace.srt
13.75 KB
05 - Execution Plans & Statistics/009 Autotrace (Code Samples).html
321 B
05 - Execution Plans & Statistics/010 V$SQL_PLAN View.mp4
109.34 MB
05 - Execution Plans & Statistics/010 V$SQL_PLAN View.srt
13.02 KB
05 - Execution Plans & Statistics/011 V$SQL_PLAN (Code Samples).html
933 B
05 - Execution Plans & Statistics/012 Reading the Execution Plans (Part 1).mp4
83.79 MB
05 - Execution Plans & Statistics/012 Reading the Execution Plans (Part 1).srt
15.34 KB
05 - Execution Plans & Statistics/013 Reading the Execution Plans (Part 2).mp4
27.37 MB
05 - Execution Plans & Statistics/013 Reading the Execution Plans (Part 2).srt
11.99 KB
05 - Execution Plans & Statistics/014 Reading the Execution Plans (Code Samples).html
310 B
05 - Execution Plans & Statistics/015 Analyzing the Execution Plans.mp4
71.38 MB
05 - Execution Plans & Statistics/015 Analyzing the Execution Plans.srt
9.64 KB
05 - Execution Plans & Statistics/016 Analyzing the Execution Plans (Code Samples).html
563 B
06 - Table & Index Access Paths/001 What are Indexes and How They work in details.mp4
113.03 MB
06 - Table & Index Access Paths/001 What are Indexes and How They work in details.srt
12.99 KB
06 - Table & Index Access Paths/002 Types of Table and Index Access Paths.mp4
51.43 MB
06 - Table & Index Access Paths/002 Types of Table and Index Access Paths.srt
14.29 KB
06 - Table & Index Access Paths/003 Table Access Full.mp4
31.64 MB
06 - Table & Index Access Paths/003 Table Access Full.srt
9.54 KB
06 - Table & Index Access Paths/004 Table Access Full (Code Samples).html
456 B
06 - Table & Index Access Paths/005 Table Access by ROWID.mp4
35.77 MB
06 - Table & Index Access Paths/005 Table Access by ROWID.srt
7.4 KB
06 - Table & Index Access Paths/006 Table Access by ROWID (Code Samples).html
288 B
06 - Table & Index Access Paths/007 Index Unique Scan.mp4
15.67 MB
06 - Table & Index Access Paths/007 Index Unique Scan.srt
5.43 KB
06 - Table & Index Access Paths/008 Index Range Scan.mp4
62.57 MB
06 - Table & Index Access Paths/008 Index Range Scan.srt
12.6 KB
06 - Table & Index Access Paths/009 Index Range Scan (Code Samples).html
1.06 KB
06 - Table & Index Access Paths/010 Index Full Scan.mp4
92.55 MB
06 - Table & Index Access Paths/010 Index Full Scan.srt
11.43 KB
06 - Table & Index Access Paths/011 Index Full Scan (Code Samples).html
1.83 KB
06 - Table & Index Access Paths/012 Index Fast Full Scan.mp4
27.97 MB
06 - Table & Index Access Paths/012 Index Fast Full Scan.srt
7.81 KB
06 - Table & Index Access Paths/013 Index Fast Full Scan (Code Samples).html
891 B
06 - Table & Index Access Paths/014 Index Skip Scan.mp4
110.59 MB
06 - Table & Index Access Paths/014 Index Skip Scan.srt
16.35 KB
06 - Table & Index Access Paths/015 Index Skip Scan (Code Samples).html
841 B
06 - Table & Index Access Paths/016 Index Join Scan.mp4
19.42 MB
06 - Table & Index Access Paths/016 Index Join Scan.srt
6.39 KB
06 - Table & Index Access Paths/017 Index Join Scan (Code Samples).html
386 B
07 - Optimizer Hints/001 What are Hints and Why to Use Them.mp4
19.17 MB
07 - Optimizer Hints/001 What are Hints and Why to Use Them.srt
4.62 KB
07 - Optimizer Hints/002 How to use Hints.mp4
64.62 MB
07 - Optimizer Hints/002 How to use Hints.srt
19.31 KB
07 - Optimizer Hints/003 How to use Hints (Code Samples).html
2.92 KB
07 - Optimizer Hints/004 HINTS-Working-Document-for-our-Students-Oracle-Master.pdf
288.24 KB
07 - Optimizer Hints/004 List of Some Useful Hints.html
501 B
08 - Join Operations/001 Join Methods Overview.mp4
15.9 MB
08 - Join Operations/001 Join Methods Overview.srt
6.34 KB
08 - Join Operations/002 Nested Loop Joins.mp4
76.01 MB
08 - Join Operations/002 Nested Loop Joins.srt
14.99 KB
08 - Join Operations/003 Nested Loop Join (Code Samples).html
1.07 KB
08 - Join Operations/004 Sort Merge Joins.mp4
63.4 MB
08 - Join Operations/004 Sort Merge Joins.srt
12.26 KB
08 - Join Operations/005 Sort Merge Join (Code Samples).html
843 B
08 - Join Operations/006 Hash Joins.mp4
65.17 MB
08 - Join Operations/006 Hash Joins.srt
13.73 KB
08 - Join Operations/007 CODE Hash Joins.html
349 B
08 - Join Operations/008 Cartesian Joins.mp4
62.49 MB
08 - Join Operations/008 Cartesian Joins.srt
7.99 KB
08 - Join Operations/009 CODE Cartesian Joins.html
142 B
08 - Join Operations/010 Join Types Overview.mp4
9 MB
08 - Join Operations/010 Join Types Overview.srt
3.67 KB
08 - Join Operations/011 Equijoins & Nonequijoins.mp4
13.29 MB
08 - Join Operations/011 Equijoins & Nonequijoins.srt
4.35 KB
08 - Join Operations/012 CODE Equijoins & Nonequijoins.html
265 B
08 - Join Operations/013 Outer Joins.mp4
39.81 MB
08 - Join Operations/013 Outer Joins.srt
13.67 KB
08 - Join Operations/014 CODE Outer Joins.html
1.1 KB
08 - Join Operations/015 Semijoins.mp4
16.48 MB
08 - Join Operations/015 Semijoins.srt
7.12 KB
08 - Join Operations/016 CODE Semijoins.html
408 B
08 - Join Operations/017 Antijoins.mp4
12.62 MB
08 - Join Operations/017 Antijoins.srt
3.76 KB
08 - Join Operations/018 CODE Antijoins.html
690 B
09 - Other Optimizer Operators/001 Result Cache Operator.mp4
69.07 MB
09 - Other Optimizer Operators/001 Result Cache Operator.srt
14.92 KB
09 - Other Optimizer Operators/002 CODE Result Cache Operator.html
711 B
09 - Other Optimizer Operators/003 View Operator.mp4
30.4 MB
09 - Other Optimizer Operators/003 View Operator.srt
8.83 KB
09 - Other Optimizer Operators/004 CODE View Operator.html
1.67 KB
09 - Other Optimizer Operators/005 Clusters.mp4
55.46 MB
09 - Other Optimizer Operators/005 Clusters.srt
17.9 KB
09 - Other Optimizer Operators/006 CODE Clusters.html
1.52 KB
09 - Other Optimizer Operators/007 Sort Operators.mp4
26.8 MB
09 - Other Optimizer Operators/007 Sort Operators.srt
9.18 KB
09 - Other Optimizer Operators/008 CODE Sort Operators.html
405 B
09 - Other Optimizer Operators/009 INLIST Operator.mp4
16.35 MB
09 - Other Optimizer Operators/009 INLIST Operator.srt
5.09 KB
09 - Other Optimizer Operators/010 CODE INLIST Operator.html
753 B
09 - Other Optimizer Operators/011 Count Stopkey Operator.mp4
7.52 MB
09 - Other Optimizer Operators/011 Count Stopkey Operator.srt
4.55 KB
09 - Other Optimizer Operators/012 CODE Count Stopkey Operator.html
215 B
09 - Other Optimizer Operators/013 First Row Operator.mp4
12.35 MB
09 - Other Optimizer Operators/013 First Row Operator.srt
6.54 KB
09 - Other Optimizer Operators/014 CODE First Row Operator.html
383 B
09 - Other Optimizer Operators/015 Filter Operator.mp4
3.15 MB
09 - Other Optimizer Operators/015 Filter Operator.srt
2.06 KB
09 - Other Optimizer Operators/016 CODE Filter Operator.html
145 B
09 - Other Optimizer Operators/017 Concatenation Operator.mp4
7.09 MB
09 - Other Optimizer Operators/017 Concatenation Operator.srt
3.67 KB
09 - Other Optimizer Operators/018 CODE Concatenation Operator.html
201 B
09 - Other Optimizer Operators/019 UNION Operators.mp4
6.69 MB
09 - Other Optimizer Operators/019 UNION Operators.srt
3.63 KB
09 - Other Optimizer Operators/020 CODE Union Operators.html
264 B
09 - Other Optimizer Operators/021 Intersect Operator.mp4
15.27 MB
09 - Other Optimizer Operators/021 Intersect Operator.srt
6.45 KB
09 - Other Optimizer Operators/022 CODE Intersect Operator.html
622 B
09 - Other Optimizer Operators/023 Minus Operator.mp4
6 MB
09 - Other Optimizer Operators/023 Minus Operator.srt
2.18 KB
09 - Other Optimizer Operators/024 CODE Minus Operator.html
375 B
10 - SQL Tuning Techniques/001 How to find a performance problem and its tuning solution.mp4
105.61 MB
10 - SQL Tuning Techniques/001 How to find a performance problem and its tuning solution.srt
19.32 KB
10 - SQL Tuning Techniques/002 Ways of Getting the Execution Plan and the Statistics.mp4
112.98 MB
10 - SQL Tuning Techniques/002 Ways of Getting the Execution Plan and the Statistics.srt
21.18 KB
10 - SQL Tuning Techniques/003 Using the Real-Time SQL Monitoring Tool Part 1.mp4
72.17 MB
10 - SQL Tuning Techniques/003 Using the Real-Time SQL Monitoring Tool Part 1.srt
13.28 KB
10 - SQL Tuning Techniques/004 Using the Real-Time SQL Monitoring Tool Part 2.mp4
73.76 MB
10 - SQL Tuning Techniques/004 Using the Real-Time SQL Monitoring Tool Part 2.srt
17.02 KB
10 - SQL Tuning Techniques/005 Using the Real-Time SQL Monitoring Tool Part 3.mp4
57.18 MB
10 - SQL Tuning Techniques/005 Using the Real-Time SQL Monitoring Tool Part 3.srt
14.79 KB
10 - SQL Tuning Techniques/006 CODE Using the Real-Time SQL Monitoring Tool.html
675 B
10 - SQL Tuning Techniques/007 TKPROF-Sorting-Options.pdf
401.28 KB
10 - SQL Tuning Techniques/007 Using the Trace Files & TKPROF Utility - Part 1.mp4
108.34 MB
10 - SQL Tuning Techniques/007 Using the Trace Files & TKPROF Utility - Part 1.srt
20.04 KB
10 - SQL Tuning Techniques/008 Using the Trace Files & TKPROF Utility - Part 2.mp4
81.77 MB
10 - SQL Tuning Techniques/008 Using the Trace Files & TKPROF Utility - Part 2.srt
25.53 KB
10 - SQL Tuning Techniques/009 Using the Trace Files & TKPROF Utility - Part 3.mp4
77.84 MB
10 - SQL Tuning Techniques/009 Using the Trace Files & TKPROF Utility - Part 3.srt
12.71 KB
10 - SQL Tuning Techniques/010 CODE Using the Trace Files & TKPROF Utility.html
792 B
10 - SQL Tuning Techniques/011 Get What You Need Only.mp4
25.84 MB
10 - SQL Tuning Techniques/011 Get What You Need Only.srt
9.13 KB
10 - SQL Tuning Techniques/012 CODE Get What You Need Only.html
201 B
10 - SQL Tuning Techniques/013 Index Usage.mp4
69.39 MB
10 - SQL Tuning Techniques/013 Index Usage.srt
19.32 KB
10 - SQL Tuning Techniques/014 CODE Index Usage.html
1.6 KB
10 - SQL Tuning Techniques/015 Using Concatenation Operator.mp4
12.51 MB
10 - SQL Tuning Techniques/015 Using Concatenation Operator.srt
4.27 KB
10 - SQL Tuning Techniques/016 CODE Using Concatenation Operator.html
272 B
10 - SQL Tuning Techniques/017 Using Arithmetic Operators.mp4
12.25 MB
10 - SQL Tuning Techniques/017 Using Arithmetic Operators.srt
3.87 KB
10 - SQL Tuning Techniques/018 CODE Using Arithmetic Operators.html
290 B
10 - SQL Tuning Techniques/019 Using Like Conditions.mp4
23.15 MB
10 - SQL Tuning Techniques/019 Using Like Conditions.srt
8.38 KB
10 - SQL Tuning Techniques/020 CODE Using Like Conditions.html
570 B
10 - SQL Tuning Techniques/021 Using Functions on the Indexed Columns.mp4
31.8 MB
10 - SQL Tuning Techniques/021 Using Functions on the Indexed Columns.srt
6.05 KB
10 - SQL Tuning Techniques/022 CODE Using Functions on the Indexed Columns.html
580 B
10 - SQL Tuning Techniques/023 Handling NULL-Based Performance Problems.mp4
51.1 MB
10 - SQL Tuning Techniques/023 Handling NULL-Based Performance Problems.srt
9.21 KB
10 - SQL Tuning Techniques/024 CODE Handling NULL-Based Performance Problems.html
1.15 KB
10 - SQL Tuning Techniques/025 Using EXISTS instead of IN Clause.mp4
36.03 MB
10 - SQL Tuning Techniques/025 Using EXISTS instead of IN Clause.srt
6.41 KB
10 - SQL Tuning Techniques/026 Using TRUNCATE instead of DELETE command.mp4
18.55 MB
10 - SQL Tuning Techniques/026 Using TRUNCATE instead of DELETE command.srt
5.54 KB
10 - SQL Tuning Techniques/027 CODE Using TRUNCATE instead of DELETE command.html
249 B
10 - SQL Tuning Techniques/028 Data Type Mismatch.mp4
22.59 MB
10 - SQL Tuning Techniques/028 Data Type Mismatch.srt
6.96 KB
10 - SQL Tuning Techniques/029 CODE Data Type Mismatch.html
627 B
10 - SQL Tuning Techniques/030 Tuning Ordered Queries.mp4
30.63 MB
10 - SQL Tuning Techniques/030 Tuning Ordered Queries.srt
8.83 KB
10 - SQL Tuning Techniques/031 CODE Tuning Ordered Queries.html
536 B
10 - SQL Tuning Techniques/032 Retrieving the MIN & MAX Values.mp4
55.91 MB
10 - SQL Tuning Techniques/032 Retrieving the MIN & MAX Values.srt
13.04 KB
10 - SQL Tuning Techniques/033 CODE Retrieving the MIN & MAX Values.html
642 B
10 - SQL Tuning Techniques/034 UNION and UNION ALL Operators (Which one is faster).mp4
19.85 MB
10 - SQL Tuning Techniques/034 UNION and UNION ALL Operators (Which one is faster).srt
3.8 KB
10 - SQL Tuning Techniques/035 UNION and UNION ALL Operators (Which one is faster).html
408 B
10 - SQL Tuning Techniques/036 Avoid Using the HAVING Clause!.mp4
20.19 MB
10 - SQL Tuning Techniques/036 Avoid Using the HAVING Clause!.srt
6.33 KB
10 - SQL Tuning Techniques/037 CODE Avoid Using the HAVING Clause!.html
442 B
10 - SQL Tuning Techniques/038 Be Careful on Views!.mp4
100.01 MB
10 - SQL Tuning Techniques/038 Be Careful on Views!.srt
12.33 KB
10 - SQL Tuning Techniques/039 CODE Be Careful on Views!.html
1.41 KB
10 - SQL Tuning Techniques/040 Create Materialized Views.mp4
32.05 MB
10 - SQL Tuning Techniques/040 Create Materialized Views.srt
8.6 KB
10 - SQL Tuning Techniques/041 CODE Create Materialized Views.html
1.09 KB
10 - SQL Tuning Techniques/042 Avoid Commit Too Much or Too Less!.mp4
18.87 MB
10 - SQL Tuning Techniques/042 Avoid Commit Too Much or Too Less!.srt
5.63 KB
10 - SQL Tuning Techniques/043 Partition Pruning.mp4
25.08 MB
10 - SQL Tuning Techniques/043 Partition Pruning.srt
7.48 KB
10 - SQL Tuning Techniques/044 CODE Partition Pruning.html
298 B
10 - SQL Tuning Techniques/045 Using BULK COLLECT.mp4
44.8 MB
10 - SQL Tuning Techniques/045 Using BULK COLLECT.srt
12.04 KB
10 - SQL Tuning Techniques/046 CODE Using BULK COLLECT.html
1.75 KB
10 - SQL Tuning Techniques/047 Tuning the Join Order.mp4
43.73 MB
10 - SQL Tuning Techniques/047 Tuning the Join Order.srt
8.05 KB
10 - SQL Tuning Techniques/048 CODE Tuning the Join Order.html
845 B
10 - SQL Tuning Techniques/049 Multitable DML Operations.mp4
63.78 MB
10 - SQL Tuning Techniques/049 Multitable DML Operations.srt
8.8 KB
10 - SQL Tuning Techniques/050 CODE Multitable DML Operations.html
1.95 KB
10 - SQL Tuning Techniques/051 Using Temporary Tables.mp4
65.15 MB
10 - SQL Tuning Techniques/051 Using Temporary Tables.srt
9.22 KB
10 - SQL Tuning Techniques/052 CODE Using Temporary Tables.html
1.44 KB
10 - SQL Tuning Techniques/053 Combining SQL Statements.mp4
29.86 MB
10 - SQL Tuning Techniques/053 Combining SQL Statements.srt
5.98 KB
10 - SQL Tuning Techniques/054 CODE Combining SQL Statements.html
842 B
10 - SQL Tuning Techniques/055 Using WITH Clause.mp4
75.51 MB
10 - SQL Tuning Techniques/055 Using WITH Clause.srt
9.23 KB
10 - SQL Tuning Techniques/056 CODE Using WITH Clause.html
2.44 KB
10 - SQL Tuning Techniques/057 Using Analytical Functions.mp4
18.56 MB
10 - SQL Tuning Techniques/057 Using Analytical Functions.srt
6.03 KB
10 - SQL Tuning Techniques/058 CODE Using Analytical Functions.html
701 B
11 - Tuning with ADVANCED Indexing Techniques/001 Why Indexing is Important.mp4
72.2 MB
11 - Tuning with ADVANCED Indexing Techniques/001 Why Indexing is Important.srt
6.92 KB
11 - Tuning with ADVANCED Indexing Techniques/002 Index Selectivity & Cardinality.mp4
52.63 MB
11 - Tuning with ADVANCED Indexing Techniques/002 Index Selectivity & Cardinality.srt
7.11 KB
11 - Tuning with ADVANCED Indexing Techniques/003 B-Tree Indexes in Details.mp4
78.8 MB
11 - Tuning with ADVANCED Indexing Techniques/003 B-Tree Indexes in Details.srt
14.13 KB
11 - Tuning with ADVANCED Indexing Techniques/004 CODE B-Tree Indexes in Details.html
1.12 KB
11 - Tuning with ADVANCED Indexing Techniques/005 Bitmap Indexes in Details.mp4
161.88 MB
11 - Tuning with ADVANCED Indexing Techniques/005 Bitmap Indexes in Details.srt
21.91 KB
11 - Tuning with ADVANCED Indexing Techniques/006 CODE Bitmap Indexes in Details.html
1.38 KB
11 - Tuning with ADVANCED Indexing Techniques/007 Bitmap Operations.mp4
30.05 MB
11 - Tuning with ADVANCED Indexing Techniques/007 Bitmap Operations.srt
8.82 KB
11 - Tuning with ADVANCED Indexing Techniques/008 Composite Indexes and Order of Indexed Columns.mp4
77.7 MB
11 - Tuning with ADVANCED Indexing Techniques/008 Composite Indexes and Order of Indexed Columns.srt
12.58 KB
11 - Tuning with ADVANCED Indexing Techniques/009 CODE Composite Indexes and Order of Indexed Columns.html
654 B
11 - Tuning with ADVANCED Indexing Techniques/010 Covering Indexes.mp4
30.21 MB
11 - Tuning with ADVANCED Indexing Techniques/010 Covering Indexes.srt
9.49 KB
11 - Tuning with ADVANCED Indexing Techniques/011 CODE Covering Indexes.html
587 B
11 - Tuning with ADVANCED Indexing Techniques/012 Reverse Key Indexes.mp4
14.6 MB
11 - Tuning with ADVANCED Indexing Techniques/012 Reverse Key Indexes.srt
4.4 KB
11 - Tuning with ADVANCED Indexing Techniques/013 Bitmap Join Indexes.mp4
79.05 MB
11 - Tuning with ADVANCED Indexing Techniques/013 Bitmap Join Indexes.srt
11.44 KB
11 - Tuning with ADVANCED Indexing Techniques/014 CODE Bitmap Join Indexes.html
1.55 KB
11 - Tuning with ADVANCED Indexing Techniques/015 Combining Bitmap Indexes.mp4
57.99 MB
11 - Tuning with ADVANCED Indexing Techniques/015 Combining Bitmap Indexes.srt
9.51 KB
11 - Tuning with ADVANCED Indexing Techniques/016 CODE Combining Bitmap Indexes.html
1.27 KB
11 - Tuning with ADVANCED Indexing Techniques/017 Function-Based Indexes.mp4
43.15 MB
11 - Tuning with ADVANCED Indexing Techniques/017 Function-Based Indexes.srt
11.1 KB
11 - Tuning with ADVANCED Indexing Techniques/018 CODE Function-Based Indexes.html
880 B
11 - Tuning with ADVANCED Indexing Techniques/019 Index-Organized Tables.mp4
111.14 MB
11 - Tuning with ADVANCED Indexing Techniques/019 Index-Organized Tables.srt
20.28 KB
11 - Tuning with ADVANCED Indexing Techniques/020 CODE Index-Organized Tables.html
1.36 KB
11 - Tuning with ADVANCED Indexing Techniques/021 Cluster Indexes.mp4
24.05 MB
11 - Tuning with ADVANCED Indexing Techniques/021 Cluster Indexes.srt
9.43 KB
11 - Tuning with ADVANCED Indexing Techniques/022 CODE Cluster Indexes.html
1.41 KB
11 - Tuning with ADVANCED Indexing Techniques/023 Invisible Indexes.mp4
49.8 MB
11 - Tuning with ADVANCED Indexing Techniques/023 Invisible Indexes.srt
9.27 KB
11 - Tuning with ADVANCED Indexing Techniques/024 CODE Invisible Indexes.html
452 B
11 - Tuning with ADVANCED Indexing Techniques/025 Index Key Compression- Part 1.mp4
38.89 MB
11 - Tuning with ADVANCED Indexing Techniques/025 Index Key Compression- Part 1.srt
6.96 KB
11 - Tuning with ADVANCED Indexing Techniques/026 Index Key Compression- Part 2.mp4
35.71 MB
11 - Tuning with ADVANCED Indexing Techniques/026 Index Key Compression- Part 2.srt
13.05 KB
11 - Tuning with ADVANCED Indexing Techniques/027 CODE Index Key Compression.html
1.03 KB
11 - Tuning with ADVANCED Indexing Techniques/028 Full-Text Searches.mp4
162.96 MB
11 - Tuning with ADVANCED Indexing Techniques/028 Full-Text Searches.srt
24.28 KB
11 - Tuning with ADVANCED Indexing Techniques/029 CODE Full-Text Search Indexes.html
1.64 KB
12 - Advanced SQL Tuning Techniques/001 Tuning Star Queries.mp4
29.24 MB
12 - Advanced SQL Tuning Techniques/001 Tuning Star Queries.srt
8.68 KB
12 - Advanced SQL Tuning Techniques/002 CODE Tuning Star Queries.html
1.26 KB
12 - Advanced SQL Tuning Techniques/003 Using Bind Variables.mp4
71.17 MB
12 - Advanced SQL Tuning Techniques/003 Using Bind Variables.srt
9.82 KB
12 - Advanced SQL Tuning Techniques/004 CODE Using Bind Variables.html
1.52 KB
12 - Advanced SQL Tuning Techniques/005 Beware of Bind Variable Peeking.mp4
21.29 MB
12 - Advanced SQL Tuning Techniques/005 Beware of Bind Variable Peeking.srt
6.64 KB
12 - Advanced SQL Tuning Techniques/006 CODE Beware of Bind Variable Peeking.html
764 B
12 - Advanced SQL Tuning Techniques/007 Cursor Sharing.mp4
95.93 MB
12 - Advanced SQL Tuning Techniques/007 Cursor Sharing.srt
17.34 KB
12 - Advanced SQL Tuning Techniques/008 CODE Cursor Sharing.html
1.57 KB
12 - Advanced SQL Tuning Techniques/009 Adaptive Cursor Sharing.mp4
110.4 MB
12 - Advanced SQL Tuning Techniques/009 Adaptive Cursor Sharing.srt
18.48 KB
12 - Advanced SQL Tuning Techniques/010 CODE Adaptive Cursor Sharing.html
1.3 KB
12 - Advanced SQL Tuning Techniques/011 Adaptive Plans.mp4
105.79 MB
12 - Advanced SQL Tuning Techniques/011 Adaptive Plans.srt
15.76 KB
12 - Advanced SQL Tuning Techniques/012 CODE Adaptive Plans.html
549 B
12 - Advanced SQL Tuning Techniques/013 Dynamic Statistics (Dynamic Sampling).mp4
146.86 MB
12 - Advanced SQL Tuning Techniques/013 Dynamic Statistics (Dynamic Sampling).srt
19.83 KB
12 - Advanced SQL Tuning Techniques/014 CODE Dynamic Statistics (Dynamic Sampling).html
1.25 KB
13 - Appendix Software Installations/001 About the Database Installation.mp4
17.45 MB
13 - Appendix Software Installations/001 About the Database Installation.srt
4.53 KB
13 - Appendix Software Installations/002 The Ways to Get a Database.mp4
99.49 MB
13 - Appendix Software Installations/002 The Ways to Get a Database.srt
19.96 KB
13 - Appendix Software Installations/003 Download-Oracle-Virtualbox.url
65 B
13 - Appendix Software Installations/003 Download-VMware-Workstation-Player.url
155 B
13 - Appendix Software Installations/003 Option 1 Installing VMware and VirtualBox on Windows.mp4
87.89 MB
13 - Appendix Software Installations/003 Option 1 Installing VMware and VirtualBox on Windows.srt
8.52 KB
13 - Appendix Software Installations/004 Option 1 How to Install the Virtual Box on Mac OS X.html
4.46 KB
13 - Appendix Software Installations/005 Option 1 Downloading Virtual Machine Image (19c).html
1.19 KB
13 - Appendix Software Installations/006 Download-Virtual-Machine-Image-19c-.url
108 B
13 - Appendix Software Installations/006 Option 1 Downloading Virtual Machine Image.mp4
36.89 MB
13 - Appendix Software Installations/006 Option 1 Downloading Virtual Machine Image.srt
4.75 KB
13 - Appendix Software Installations/007 Option 1 Configuring the VMware Virtualization Software.mp4
94.97 MB
13 - Appendix Software Installations/007 Option 1 Configuring the VMware Virtualization Software.srt
9.67 KB
13 - Appendix Software Installations/008 Option 1 Configuring the Oracle VirtualBox Virtualization Software.mp4
55 MB
13 - Appendix Software Installations/008 Option 1 Configuring the Oracle VirtualBox Virtualization Software.srt
8.2 KB
13 - Appendix Software Installations/009 Option 1 Configuring SQL Developer inside of the Virtual Machine.mp4
73.52 MB
13 - Appendix Software Installations/009 Option 1 Configuring SQL Developer inside of the Virtual Machine.srt
16 KB
13 - Appendix Software Installations/010 Option 2 What is Pluggable Database.mp4
11.37 MB
13 - Appendix Software Installations/010 Option 2 What is Pluggable Database.srt
3.69 KB
13 - Appendix Software Installations/011 Option 2 Downloading and Installing the Oracle Database.mp4
167.52 MB
13 - Appendix Software Installations/011 Option 2 Downloading and Installing the Oracle Database.srt
22.14 KB
13 - Appendix Software Installations/012 -Oracle-Master-Training-Scripts-to-Unlock-the-HR-Schema.pdf
230.84 KB
13 - Appendix Software Installations/012 Option 2 Unlocking the HR Schema.mp4
16.99 MB
13 - Appendix Software Installations/012 Option 2 Unlocking the HR Schema.srt
9.17 KB
13 - Appendix Software Installations/013 Option 2 Configuring and Using Oracle SQL Developer.mp4
136.77 MB
13 - Appendix Software Installations/013 Option 2 Configuring and Using Oracle SQL Developer.srt
26.72 KB
13 - Appendix Software Installations/014 Installation-Code.txt
1.27 KB
13 - Appendix Software Installations/014 Option 2 Installing Sample Schemas in Oracle Database.mp4
89.56 MB
13 - Appendix Software Installations/014 Option 2 Installing Sample Schemas in Oracle Database.srt
8.56 KB
13 - Appendix Software Installations/014 sample-schemas.zip
14.03 MB
13 - Appendix Software Installations/015 Extra 12c Installation.html
1.36 KB
13 - Appendix Software Installations/016 Option 2 How to Unlock the HR Schema in the Oracle Database 12c.html
3.03 KB
13 - Appendix Software Installations/017 Option 2 Oracle Database 12c Installation into Your Computer.mp4
36.02 MB
13 - Appendix Software Installations/017 Option 2 Oracle Database 12c Installation into Your Computer.srt
10.32 KB
13 - Appendix Software Installations/018 Option 2 Configuring and Using Oracle SQL Developer for Oracle Database 12c.mp4
50.77 MB
13 - Appendix Software Installations/018 Option 2 Configuring and Using Oracle SQL Developer for Oracle Database 12c.srt
11.27 KB
13 - Appendix Software Installations/external-links.txt
381 B
14 - Bonus/001 Bonus Lecture.html
2.57 KB