Pluralsight - Optimizing SQL Queries in Oracle
File List
| File | Size |
|---|---|
| 01. Optimizing SQL Queries in Oracle/01_01-Introduction.mp4 | 735.01 KB |
| 01. Optimizing SQL Queries in Oracle/01_02-Course Overview.mp4 | 2.75 MB |
| 01. Optimizing SQL Queries in Oracle/01_03-Course Contents.mp4 | 5.43 MB |
| 01. Optimizing SQL Queries in Oracle/01_04-Module Contents.mp4 | 1.52 MB |
| 01. Optimizing SQL Queries in Oracle/01_05-Who Will Benefit.mp4 | 2.1 MB |
| 01. Optimizing SQL Queries in Oracle/01_06-Database Version.mp4 | 974.83 KB |
| 01. Optimizing SQL Queries in Oracle/01_07-Data Used in Course.mp4 | 8.42 MB |
| 01. Optimizing SQL Queries in Oracle/01_08-A Comment about Tablespaces.mp4 | 4.5 MB |
| 01. Optimizing SQL Queries in Oracle/01_09-Oracle Query Optimizer.mp4 | 7.32 MB |
| 01. Optimizing SQL Queries in Oracle/01_10-Oracle and Pluralsight Resources.mp4 | 3.83 MB |
| 01. Optimizing SQL Queries in Oracle/01_11-Your Database Administrator.mp4 | 2.2 MB |
| 01. Optimizing SQL Queries in Oracle/01_12-Summary.mp4 | 1.15 MB |
| 02. Basic SQL Optimization Part I/02_01-Introduction.mp4 | 822.95 KB |
| 02. Basic SQL Optimization Part I/02_02-Module Contents.mp4 | 2.59 MB |
| 02. Basic SQL Optimization Part I/02_03-PrimaryForeign Keys.mp4 | 6.77 MB |
| 02. Basic SQL Optimization Part I/02_04-Normal Forms - Part I.mp4 | 11.2 MB |
| 02. Basic SQL Optimization Part I/02_05-Normal Forms - Part II.mp4 | 4.74 MB |
| 02. Basic SQL Optimization Part I/02_06-Normal Forms - Part III.mp4 | 7.17 MB |
| 02. Basic SQL Optimization Part I/02_07-PrimaryForeign Keys REDUX.mp4 | 11.07 MB |
| 02. Basic SQL Optimization Part I/02_08-Infrequent Columns.mp4 | 3.38 MB |
| 02. Basic SQL Optimization Part I/02_09-NULLs and Space.mp4 | 2 MB |
| 02. Basic SQL Optimization Part I/02_10-Summary.mp4 | 1.7 MB |
| 03. Basic SQL Optimization Part II/03_01-Introduction.mp4 | 1.22 MB |
| 03. Basic SQL Optimization Part II/03_02-Module Contents.mp4 | 2.85 MB |
| 03. Basic SQL Optimization Part II/03_03-Neaten Up SQL Code.mp4 | 1.42 MB |
| 03. Basic SQL Optimization Part II/03_04-Restrict ColumnsRows.mp4 | 2.82 MB |
| 03. Basic SQL Optimization Part II/03_05-INTERSECT vs. INNER JOIN.mp4 | 3.29 MB |
| 03. Basic SQL Optimization Part II/03_06-MINUS vs. JOIN.mp4 | 3.3 MB |
| 03. Basic SQL Optimization Part II/03_07-Correlated Subqueries.mp4 | 2.16 MB |
| 03. Basic SQL Optimization Part II/03_08-IN vs. EXISTS.mp4 | 2.98 MB |
| 03. Basic SQL Optimization Part II/03_09-Multi-Column IN vs. ANDsORs.mp4 | 4.21 MB |
| 03. Basic SQL Optimization Part II/03_10-The WITH Clause.mp4 | 4.27 MB |
| 03. Basic SQL Optimization Part II/03_11-The APPEND Hint.mp4 | 2.63 MB |
| 03. Basic SQL Optimization Part II/03_12-ON Clause vs. WHERE Clause.mp4 | 2.17 MB |
| 03. Basic SQL Optimization Part II/03_13-Order of Tables on FROM Clause.mp4 | 2.23 MB |
| 03. Basic SQL Optimization Part II/03_14-Cartesian Products.mp4 | 1.5 MB |
| 03. Basic SQL Optimization Part II/03_15-Summary.mp4 | 3.5 MB |
| 04. Overview of Indexes/04_01-Introduction.mp4 | 998.56 KB |
| 04. Overview of Indexes/04_02-Module Contents.mp4 | 1.96 MB |
| 04. Overview of Indexes/04_03-What is an Index.mp4 | 10.47 MB |
| 04. Overview of Indexes/04_04-B-Tree Indexes.mp4 | 5.2 MB |
| 04. Overview of Indexes/04_05-Bitmap Indexes.mp4 | 6.27 MB |
| 04. Overview of Indexes/04_06-Function-Based Indexes.mp4 | 2.04 MB |
| 04. Overview of Indexes/04_07-Index-Organized Tables.mp4 | 1.92 MB |
| 04. Overview of Indexes/04_08-Bitmap Join Indexes.mp4 | 2.71 MB |
| 04. Overview of Indexes/04_09-Gathering Statistics.mp4 | 4.28 MB |
| 04. Overview of Indexes/04_10-IndexPartition Interaction.mp4 | 2.86 MB |
| 04. Overview of Indexes/04_11-Example.mp4 | 6.87 MB |
| 04. Overview of Indexes/04_12-Summary.mp4 | 2.1 MB |
| 05. B-Tree Indexes/05_01-Introduction.mp4 | 493.52 KB |
| 05. B-Tree Indexes/05_02-Module Contents.mp4 | 1.89 MB |
| 05. B-Tree Indexes/05_03-What is a B-Tree Index.mp4 | 3.95 MB |
| 05. B-Tree Indexes/05_04-When do you use a B-Tree Index.mp4 | 8.14 MB |
| 05. B-Tree Indexes/05_05-Creating a B-Tree Index.mp4 | 8.82 MB |
| 05. B-Tree Indexes/05_06-Listing the Indexes on a Table.mp4 | 8.58 MB |
| 05. B-Tree Indexes/05_07-Dropping a B-Tree Index.mp4 | 1.05 MB |
| 05. B-Tree Indexes/05_08-Gathering Statistics.mp4 | 12.15 MB |
| 05. B-Tree Indexes/05_09-Is my Index Being Used.mp4 | 8.82 MB |
| 05. B-Tree Indexes/05_10-Summary.mp4 | 2.96 MB |
| 06. Bitmap Indexes/06_01-Introduction.mp4 | 513.45 KB |
| 06. Bitmap Indexes/06_02-Module Contents.mp4 | 1.11 MB |
| 06. Bitmap Indexes/06_03-What is a Bitmap Index.mp4 | 4.87 MB |
| 06. Bitmap Indexes/06_04-When do you use a Bitmap Index.mp4 | 3.61 MB |
| 06. Bitmap Indexes/06_05-Creating a Bitmap Index.mp4 | 4.03 MB |
| 06. Bitmap Indexes/06_06-Dropping a Bitmap Index.mp4 | 905.66 KB |
| 06. Bitmap Indexes/06_08-Summary.mp4 | 818.38 KB |
| 07. Additional Index Types/07_01-Introduction.mp4 | 725.65 KB |
| 07. Additional Index Types/07_02-Module Contents.mp4 | 788.22 KB |
| 07. Additional Index Types/07_03-Function-Based Indexes.mp4 | 9.02 MB |
| 07. Additional Index Types/07_04-Bitmap Join Indexes.mp4 | 15.15 MB |
| 07. Additional Index Types/07_05-Index-Organized Tables.mp4 | 11.98 MB |
| 07. Additional Index Types/07_06-Summary.mp4 | 2.04 MB |
| 08. Overview of Partitions/08_01-Introduction.mp4 | 428.14 KB |
| 08. Overview of Partitions/08_02-Module Contents.mp4 | 1.54 MB |
| 08. Overview of Partitions/08_03-What is a Partition.mp4 | 6.27 MB |
| 08. Overview of Partitions/08_04-Varieties of Partitions.mp4 | 9.07 MB |
| 08. Overview of Partitions/08_05-Partition-Wise Joins.mp4 | 1.94 MB |
| 08. Overview of Partitions/08_06-PartitionIndex Interaction.mp4 | 2.42 MB |
| 08. Overview of Partitions/08_07-Examples.mp4 | 6.84 MB |
| 08. Overview of Partitions/08_08-Summary.mp4 | 1.43 MB |
| 09. Simple Partitions/09_01-Introduction.mp4 | 485.76 KB |
| 09. Simple Partitions/09_02-Module Contents.mp4 | 888.21 KB |
| 09. Simple Partitions/09_03-What is a List Partition.mp4 | 3.94 MB |
| 09. Simple Partitions/09_04-Creating a List Partition.mp4 | 1.05 MB |
| 09. Simple Partitions/09_05-Examples of List Partitions.mp4 | 4.24 MB |
| 09. Simple Partitions/09_06-Adding to a List Partition.mp4 | 7.41 MB |
| 09. Simple Partitions/09_07-Dropping a List Partition.mp4 | 2.81 MB |
| 09. Simple Partitions/09_08-What is a Range Partition.mp4 | 2.44 MB |
| 09. Simple Partitions/09_09-Creating a Range Partition.mp4 | 2.35 MB |
| 09. Simple Partitions/09_10-Examples of Range Partitions.mp4 | 7.63 MB |
| 09. Simple Partitions/09_11-Adding to a Range Partition.mp4 | 8.5 MB |
| 09. Simple Partitions/09_12-Dropping a Range Partition.mp4 | 3 MB |
| 09. Simple Partitions/09_13-Summary.mp4 | 1.83 MB |
| 10. Composite Partitions/10_01-Introduction.mp4 | 684.98 KB |
| 10. Composite Partitions/10_02-Module Contents.mp4 | 1.73 MB |
| 10. Composite Partitions/10_03-What is a Composite Partition.mp4 | 3.29 MB |
| 10. Composite Partitions/10_04-Varieties of Composite Partitions.mp4 | 2.13 MB |
| 10. Composite Partitions/10_05-Example #1 - ListList.mp4 | 7.98 MB |
| 10. Composite Partitions/10_06-Example #2 - RangeList.mp4 | 11.45 MB |
| 10. Composite Partitions/10_07-Example #3 - AUTOTRACE.mp4 | 2.94 MB |
Trackers
No trackers found.