Pluralsight - Optimizing SQL Queries in Oracle - 2014

seeders: 9

leechers: 12

Download torrent

Added on January 17, 2015 by RocknBassin Other > Tutorials
Torrent verified.

Main

add to bookmarks

Pluralsight - Optimizing SQL Queries in Oracle - 2014 (Size: 421.02 MB)

		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
		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_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
		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
		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_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_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_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_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
		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_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

Description

Year : 2014
Manufacturer : pluralsight
Author : Scott Hecht
Duration : 3h 46m
Language : English
Format : MP4
Video : AVC, 1024x768, 4: 3, 15 fps, 159 Kbps
Audio : AAC, 111 Kbps, 2 channels, 44.1 KHz

This course introduces SQL programmers and new Oracle database administrators to several methods to make SQL queries execute faster. This course introduces programmers and new SQL DBA Oracle c several ways to speed up queries SQL.

Content:
01. Optimizing SQL Queries in Oracle 22:15
Introduction 0:22
Course Overview 1:36
Course Contents 3:30
Module Contents 0:55
Who Will Benefit? 1:10
Database Version 0:38
Data Used in Course 4:36
A Comment about Tablespaces 2:36
Oracle Query Optimizer 3:27
Oracle and Pluralsight Resources 1:32
Your Database Administrator 0:58
Summary 0:49

02. Basic SQL Optimization Part I 28:25
Introduction 0:24
Module Contents 1:42
Primary/Foreign Keys 3:31
Normal Forms - Part I 6:24
Normal Forms - Part II 2:40
Normal Forms - Part III 3:52
Primary/Foreign Keys REDUX 5:43
Infrequent Columns 1:47
NULLs and Space 1:14
Summary 1:03

03. Basic SQL Optimization Part II 22:41
Introduction 0:40
Module Contents 1:41
Neaten Up SQL Code 0:50
Restrict Columns/Rows 1:43
INTERSECT vs. INNER JOIN 1:47
MINUS vs. JOIN 1:54
Correlated Subqueries 1:11
IN vs. EXISTS 1:36
Multi-Column IN vs. ANDs/ORs 2:17
The WITH Clause 1:51
The APPEND Hint 1:41
ON Clause vs. WHERE Clause 1:14
Order of Tables on FROM Clause 1:17
Cartesian Products 1:00
Summary 1:54

04. Overview of Indexes 25:03
Introduction 0:32
Module Contents 1:13
What is an Index? 4:29
B-Tree Indexes 2:56
Bitmap Indexes 3:22
Function-Based Indexes 1:08
Index-Organized Tables 1:05
Bitmap Join Indexes 1:29
Gathering Statistics 2:03
Index/Partition Interaction 1:40
Example 3:40
Summary 1:19

05. B-Tree Indexes 30:18
Introduction 0:15
Module Contents 1:08
What is a B-Tree Index? 2:13
When do you use a B-Tree Index? 4:50
Creating a B-Tree Index 5:05
Listing the Indexes on a Table 4:23
Dropping a B-Tree Index 0:41
Gathering Statistics 5:24
Is my Index Being Used? 4:48
Summary 1:25

06. Bitmap Indexes 11:58
Introduction 0:16
Module Contents 0:41
What is a Bitmap Index? 2:51
When do you use a Bitmap Index? 2:14
Creating a Bitmap Index 1:55
Dropping a Bitmap Index 0:33
Is my Index Being Used? 2:57
Summary 0:28

07. Additional Index Types 19:15
Introduction 0:22
Module Contents 0:22
Function-Based Indexes 4:30
Bitmap Join Indexes 7:37
Index-Organized Tables 5:06
Summary 1:15

08. Overview of Partitions 16:03
Introduction 0:12
Module Contents 1:00
What is a Partition? 3:12
Varieties of Partitions 5:11
Partition-Wise Joins 0:55
Partition/Index Interaction 1:17
Examples 3:13
Summary 0:59

09. Simple Partitions 23:57
Introduction 0:14
Module Contents 0:29
What is a List Partition? 2:16
Creating a List Partition 0:43
Examples of List Partitions 1:51
Adding to a List Partition 4:33
Dropping a List Partition 1:40
What is a Range Partition? 1:30
Creating a Range Partition 1:27
Examples of Range Partitions 2:39
Adding to a Range Partition 3:50
Dropping a Range Partition 1:31
Summary 1:08

10. Composite Partitions 15:43
Introduction 0:21
Module Contents 1:04
What is a Composite Partition? 1:54
Varieties of Composite Partitions 1:11
Example #1 - List/List 3:49
Example #2 - Range/List 4:43
Example #3 - AUTOTRACE 1:30
Summary 1:06

11. Partition/Index Interaction 10:58
Introduction 0:20
Module Contents 0:42
Partition/Index Interaction 2:19
Global Non-Partitioned Indexes 2:26
Local Partitioned Indexes 1:27
Changes in Partitions Affect Indexes 2:32
Summary 1:09

Sharing Widget

Download torrent

421.02 MB

seeders:9

leechers:12

Pluralsight - Optimizing SQL Queries in Oracle - 2014