[pluralsight] Optimizing SQL Queries in Oracle [2014, ENG]

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