Download Pluralsight - Optimizing SQL Queries in Oracle Torrent

Pluralsight - Optimizing SQL Queries in Oracle

01. Optimizing SQL Queries in Oracle

01_01-Introduction.mp4	MP4	735.01 KB
01_02-Course Overview.mp4	MP4	2.75 MB
01_03-Course Contents.mp4	MP4	5.43 MB
01_04-Module Contents.mp4	MP4	1.52 MB
01_05-Who Will Benefit.mp4	MP4	2.1 MB
01_06-Database Version.mp4	MP4	974.83 KB
01_07-Data Used in Course.mp4	MP4	8.42 MB
01_08-A Comment about Tablespaces.mp4	MP4	4.5 MB
01_09-Oracle Query Optimizer.mp4	MP4	7.32 MB
01_10-Oracle and Pluralsight Resources.mp4	MP4	3.83 MB
01_11-Your Database Administrator.mp4	MP4	2.2 MB
01_12-Summary.mp4	MP4	1.15 MB

02. Basic SQL Optimization Part I

02_01-Introduction.mp4	MP4	822.95 KB
02_02-Module Contents.mp4	MP4	2.59 MB
02_03-PrimaryForeign Keys.mp4	MP4	6.77 MB
02_04-Normal Forms - Part I.mp4	MP4	11.2 MB
02_05-Normal Forms - Part II.mp4	MP4	4.74 MB
02_06-Normal Forms - Part III.mp4	MP4	7.17 MB
02_07-PrimaryForeign Keys REDUX.mp4	MP4	11.07 MB
02_08-Infrequent Columns.mp4	MP4	3.38 MB
02_09-NULLs and Space.mp4	MP4	2 MB
02_10-Summary.mp4	MP4	1.7 MB

03. Basic SQL Optimization Part II

03_01-Introduction.mp4	MP4	1.22 MB
03_02-Module Contents.mp4	MP4	2.85 MB
03_03-Neaten Up SQL Code.mp4	MP4	1.42 MB
03_04-Restrict ColumnsRows.mp4	MP4	2.82 MB
03_05-INTERSECT vs. INNER JOIN.mp4	MP4	3.29 MB
03_06-MINUS vs. JOIN.mp4	MP4	3.3 MB
03_07-Correlated Subqueries.mp4	MP4	2.16 MB
03_08-IN vs. EXISTS.mp4	MP4	2.98 MB
03_09-Multi-Column IN vs. ANDsORs.mp4	MP4	4.21 MB
03_10-The WITH Clause.mp4	MP4	4.27 MB
03_11-The APPEND Hint.mp4	MP4	2.63 MB
03_12-ON Clause vs. WHERE Clause.mp4	MP4	2.17 MB
03_13-Order of Tables on FROM Clause.mp4	MP4	2.23 MB
03_14-Cartesian Products.mp4	MP4	1.5 MB
03_15-Summary.mp4	MP4	3.5 MB

04. Overview of Indexes

04_01-Introduction.mp4	MP4	998.56 KB
04_02-Module Contents.mp4	MP4	1.96 MB
04_03-What is an Index.mp4	MP4	10.47 MB
04_04-B-Tree Indexes.mp4	MP4	5.2 MB
04_05-Bitmap Indexes.mp4	MP4	6.27 MB
04_06-Function-Based Indexes.mp4	MP4	2.04 MB
04_07-Index-Organized Tables.mp4	MP4	1.92 MB
04_08-Bitmap Join Indexes.mp4	MP4	2.71 MB
04_09-Gathering Statistics.mp4	MP4	4.28 MB
04_10-IndexPartition Interaction.mp4	MP4	2.86 MB
04_11-Example.mp4	MP4	6.87 MB
04_12-Summary.mp4	MP4	2.1 MB

05. B-Tree Indexes

05_01-Introduction.mp4	MP4	493.52 KB
05_02-Module Contents.mp4	MP4	1.89 MB
05_03-What is a B-Tree Index.mp4	MP4	3.95 MB
05_04-When do you use a B-Tree Index.mp4	MP4	8.14 MB
05_05-Creating a B-Tree Index.mp4	MP4	8.82 MB
05_06-Listing the Indexes on a Table.mp4	MP4	8.58 MB
05_07-Dropping a B-Tree Index.mp4	MP4	1.05 MB
05_08-Gathering Statistics.mp4	MP4	12.15 MB
05_09-Is my Index Being Used.mp4	MP4	8.82 MB
05_10-Summary.mp4	MP4	2.96 MB

06. Bitmap Indexes

06_01-Introduction.mp4	MP4	513.45 KB
06_02-Module Contents.mp4	MP4	1.11 MB
06_03-What is a Bitmap Index.mp4	MP4	4.87 MB
06_04-When do you use a Bitmap Index.mp4	MP4	3.61 MB
06_05-Creating a Bitmap Index.mp4	MP4	4.03 MB
06_06-Dropping a Bitmap Index.mp4	MP4	905.66 KB
06_08-Summary.mp4	MP4	818.38 KB

07. Additional Index Types

08. Overview of Partitions

08_01-Introduction.mp4	MP4	428.14 KB
08_02-Module Contents.mp4	MP4	1.54 MB
08_03-What is a Partition.mp4	MP4	6.27 MB
08_04-Varieties of Partitions.mp4	MP4	9.07 MB
08_05-Partition-Wise Joins.mp4	MP4	1.94 MB
08_06-PartitionIndex Interaction.mp4	MP4	2.42 MB
08_07-Examples.mp4	MP4	6.84 MB
08_08-Summary.mp4	MP4	1.43 MB

09. Simple Partitions

09_01-Introduction.mp4	MP4	485.76 KB
09_02-Module Contents.mp4	MP4	888.21 KB
09_03-What is a List Partition.mp4	MP4	3.94 MB
09_04-Creating a List Partition.mp4	MP4	1.05 MB
09_05-Examples of List Partitions.mp4	MP4	4.24 MB
09_06-Adding to a List Partition.mp4	MP4	7.41 MB
09_07-Dropping a List Partition.mp4	MP4	2.81 MB
09_08-What is a Range Partition.mp4	MP4	2.44 MB
09_09-Creating a Range Partition.mp4	MP4	2.35 MB
09_10-Examples of Range Partitions.mp4	MP4	7.63 MB
09_11-Adding to a Range Partition.mp4	MP4	8.5 MB
09_12-Dropping a Range Partition.mp4	MP4	3 MB
09_13-Summary.mp4	MP4	1.83 MB

10. Composite Partitions

10_01-Introduction.mp4	MP4	684.98 KB
10_02-Module Contents.mp4	MP4	1.73 MB
10_03-What is a Composite Partition.mp4	MP4	3.29 MB
10_04-Varieties of Composite Partitions.mp4	MP4	2.13 MB
10_05-Example #1 - ListList.mp4	MP4	7.98 MB
10_06-Example #2 - RangeList.mp4	MP4	11.45 MB
10_07-Example #3 - AUTOTRACE.mp4	MP4	2.94 MB
10_08-Summary.mp4	MP4	1.59 MB

11. PartitionIndex Interaction

11_01-Introduction.mp4	MP4	639.35 KB
11_02-Module Contents.mp4	MP4	1020.12 KB
11_03-PartitionIndex Interaction.mp4	MP4	3.47 MB
11_04-Global Non-Partitioned Indexes.mp4	MP4	4.85 MB
11_05-Local Partitioned Indexes.mp4	MP4	2.95 MB
11_06-Changes in Partitions Affect Indexes.mp4	MP4	5.24 MB
11_07-Summary.mp4	MP4	1.83 MB

Course Description.txt

TXT

270 B

pluralsight.png

PNG

17.79 KB

									Show full description
								

Pluralsight - Optimizing SQL Queries in Oracle

Tracker name
udp://tracker.coppersurfer.tk:6969/announce
udp://9.rarbg.me:2850/announce
udp://9.rarbg.to:2920/announce
udp://tracker.opentrackr.org:1337
udp://tracker.leechers-paradise.org:6969/announce