Pluralsight Optimizing SQL Queries in Oracle | F497DDEFD98CFF58CE21820A9A4048502A2211EF

Pluralsight Optimizing SQL Queries in Oracle

Name	Pluralsight Optimizing SQL Queries in Oracle	DOWNLOAD Copy Link
Total Size	441.5 MB
Total Files	108
Last Seen	2024-11-02 02:38
Hash	F497DDEFD98CFF58CE21820A9A4048502A2211EF

/01. Optimizing SQL Queries in Oracle/
01_01-Introduction.mp4	752.7 KB
01_02-Course Overview.mp4	2.9 MB
01_03-Course Contents.mp4	5.7 MB
01_04-Module Contents.mp4	1.6 MB
01_05-Who Will Benefit.mp4	2.2 MB
01_06-Database Version.mp4	998.2 KB
01_07-Data Used in Course.mp4	8.8 MB
01_08-A Comment about Tablespaces.mp4	4.7 MB
01_09-Oracle Query Optimizer.mp4	7.7 MB
01_10-Oracle and Pluralsight Resources.mp4	4.0 MB
01_11-Your Database Administrator.mp4	2.3 MB
01_12-Summary.mp4	1.2 MB
/02. Basic SQL Optimization Part I/
02_01-Introduction.mp4	842.7 KB
02_02-Module Contents.mp4	2.7 MB
02_03-PrimaryForeign Keys.mp4	7.1 MB
02_04-Normal Forms - Part I.mp4	11.7 MB
02_05-Normal Forms - Part II.mp4	5.0 MB
02_06-Normal Forms - Part III.mp4	7.5 MB
02_07-PrimaryForeign Keys REDUX.mp4	11.6 MB
02_08-Infrequent Columns.mp4	3.5 MB
02_09-NULLs and Space.mp4	2.1 MB
02_10-Summary.mp4	1.8 MB
/03. Basic SQL Optimization Part II/
03_01-Introduction.mp4	1.3 MB
03_02-Module Contents.mp4	3.0 MB
03_03-Neaten Up SQL Code.mp4	1.5 MB
03_04-Restrict ColumnsRows.mp4	3.0 MB
03_05-INTERSECT vs. INNER JOIN.mp4	3.4 MB
03_06-MINUS vs. JOIN.mp4	3.5 MB
03_07-Correlated Subqueries.mp4	2.3 MB
03_08-IN vs. EXISTS.mp4	3.1 MB
03_09-Multi-Column IN vs. ANDsORs.mp4	4.4 MB
03_10-The WITH Clause.mp4	4.5 MB
03_11-The APPEND Hint.mp4	2.8 MB
03_12-ON Clause vs. WHERE Clause.mp4	2.3 MB
03_13-Order of Tables on FROM Clause.mp4	2.3 MB
03_14-Cartesian Products.mp4	1.6 MB
03_15-Summary.mp4	3.7 MB
/04. Overview of Indexes/
04_01-Introduction.mp4	1.0 MB
04_02-Module Contents.mp4	2.1 MB
04_03-What is an Index.mp4	11.0 MB
04_04-B-Tree Indexes.mp4	5.4 MB
04_05-Bitmap Indexes.mp4	6.6 MB
04_06-Function-Based Indexes.mp4	2.1 MB
04_07-Index-Organized Tables.mp4	2.0 MB
04_08-Bitmap Join Indexes.mp4	2.8 MB
04_09-Gathering Statistics.mp4	4.5 MB
04_10-IndexPartition Interaction.mp4	3.0 MB
04_11-Example.mp4	7.2 MB
04_12-Summary.mp4	2.2 MB
/05. B-Tree Indexes/
05_01-Introduction.mp4	505.4 KB
05_02-Module Contents.mp4	2.0 MB
05_03-What is a B-Tree Index.mp4	4.1 MB
05_04-When do you use a B-Tree Index.mp4	8.5 MB
05_05-Creating a B-Tree Index.mp4	9.2 MB
05_06-Listing the Indexes on a Table.mp4	9.0 MB
05_07-Dropping a B-Tree Index.mp4	1.1 MB
05_08-Gathering Statistics.mp4	12.7 MB
05_09-Is my Index Being Used.mp4	9.2 MB
05_10-Summary.mp4	3.1 MB
/06. Bitmap Indexes/
06_01-Introduction.mp4	525.8 KB
06_02-Module Contents.mp4	1.2 MB
06_03-What is a Bitmap Index.mp4	5.1 MB
06_04-When do you use a Bitmap Index.mp4	3.8 MB
06_05-Creating a Bitmap Index.mp4	4.2 MB
06_06-Dropping a Bitmap Index.mp4	927.4 KB
06_08-Summary.mp4	838.0 KB
/07. Additional Index Types/
07_01-Introduction.mp4	743.1 KB
07_02-Module Contents.mp4	807.1 KB
07_03-Function-Based Indexes.mp4	9.5 MB
07_04-Bitmap Join Indexes.mp4	15.9 MB
07_05-Index-Organized Tables.mp4	12.6 MB
07_06-Summary.mp4	2.1 MB
/08. Overview of Partitions/
08_01-Introduction.mp4	438.4 KB
08_02-Module Contents.mp4	1.6 MB
08_03-What is a Partition.mp4	6.6 MB
08_04-Varieties of Partitions.mp4	9.5 MB
08_05-Partition-Wise Joins.mp4	2.0 MB
08_06-PartitionIndex Interaction.mp4	2.5 MB
08_07-Examples.mp4	7.2 MB
08_08-Summary.mp4	1.5 MB
/09. Simple Partitions/
09_01-Introduction.mp4	497.4 KB
09_02-Module Contents.mp4	909.5 KB
09_03-What is a List Partition.mp4	4.1 MB
09_04-Creating a List Partition.mp4	1.1 MB
09_05-Examples of List Partitions.mp4	4.4 MB
09_06-Adding to a List Partition.mp4	7.8 MB
09_07-Dropping a List Partition.mp4	2.9 MB
09_08-What is a Range Partition.mp4	2.6 MB
09_09-Creating a Range Partition.mp4	2.5 MB
09_10-Examples of Range Partitions.mp4	8.0 MB
09_11-Adding to a Range Partition.mp4	8.9 MB
09_12-Dropping a Range Partition.mp4	3.1 MB
09_13-Summary.mp4	1.9 MB
/10. Composite Partitions/
10_01-Introduction.mp4	701.4 KB
10_02-Module Contents.mp4	1.8 MB
10_03-What is a Composite Partition.mp4	3.4 MB
10_04-Varieties of Composite Partitions.mp4	2.2 MB
10_05-Example #1 - ListList.mp4	8.4 MB
10_06-Example #2 - RangeList.mp4	12.0 MB
10_07-Example #3 - AUTOTRACE.mp4	3.1 MB
10_08-Summary.mp4	1.7 MB
/11. PartitionIndex Interaction/
11_01-Introduction.mp4	654.7 KB
11_02-Module Contents.mp4	1.0 MB
11_03-PartitionIndex Interaction.mp4	3.6 MB
11_04-Global Non-Partitioned Indexes.mp4	5.1 MB
11_05-Local Partitioned Indexes.mp4	3.1 MB
11_06-Changes in Partitions Affect Indexes.mp4	5.5 MB
11_07-Summary.mp4	1.9 MB
Total files 108