» » Pluralsight - Optimizing SQL Queries in Oracle (2014)
uploaded.to



Information of news
22-01-2015, 20:10

Pluralsight - Optimizing SQL Queries in Oracle (2014)

Category: Tutorials

Pluralsight - Optimizing SQL Queries in Oracle (2014)

Pluralsight - Optimizing SQL Queries in Oracle (2014)

MP4 | AVC 206kbps | English | 1024x768 | 15fps | 3h 46mins | AAC stereo 118kbps | 421 MB

Genre: Video Training



This course introduces SQL programmers and new Oracle database administrators to several methods to make SQL queries execute faster, such as transforming your data to normal form, using more efficient SQL code, and using indexes, as well as how to work with partitions.

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

Pluralsight - Optimizing SQL Queries in Oracle (2014)

Pluralsight - Optimizing SQL Queries in Oracle (2014)

Pluralsight - Optimizing SQL Queries in Oracle (2014)



Download link:


uploaded


Rapidgator.net

Site BBcode/HTML Code:
Dear visitor, you went to the site as unregistered user.
We recommend you Sign up or Login to website under your name.
Information
Would you like to leave your comment? Please Login to your account to leave comments. Don't have an account? You can create a free account now.

Tag Cloud

archive of news

^
 
free html hit counter