2014
pluralsight
Scott Hecht
3h 46m
English

This course introduces SQL programmers and new Oracle database administrators to several methods to make SQL queries execute faster.

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

Download File Size:405.25 MB

---