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