on-demand course

Learning Path: Professional Oracle Developer

with Dan Hotka

June 2016

Intermediate

22h 29m

English

Pearson

Closed Captioning available in English, Japanese, Korean, Chinese (Simplified), Chinese (Traditional)

Watch now

Unlock full access

Includes

Earns Badge

Course outline

Oracle SQL Performance Tuning for Developers LiveLessons: Introduction
4m 14s
Learning Objectives
47s
1.1 Explore how Oracle processes SQL
16m 10s
1.2 Understand Library Cache Internals
5m 12s
1.3 Handle SQL with Bind Variables handling
4m 27s
1.4 Explore the performance advantages of SQL using Functions
3m 53s
1.5 See what's new for Oracle12: SQL Directives
3m 56s
Put it all together
1m 29s
Learning Objectives
53s
2.1 Understand Explain Plans
1m 41s
2.2 Set up and use the PLAN_TABLE
4m 24s
2.3 Use SQL*Plus
11m 59s
2.4 Use TOAD
3m 33s
2.5 Use SQL Developer
1m 27s
2.6 Use Rapid SQL
1m 47s
2.7 Use JS Tuner
3m 2s
2.8 Use SQL Trace
15m 37s
2.9 Get the correct information from Oracle to solve SQL performance issues
6m 23s
Put it all together
1m 22s
Learning Objectives
24s
3.1 Understand Explain Plan Anatomy
8m 24s
3.2 Explore the Oracle SQL Parsing Process
7m 5s
3.3 Understand the Cost-Based Optimizer steps
14m 25s
3.4 Explore the Explain Plan Line-Item Content
13m 1s
3.5 Understand Table Joins
10m 13s
3.6 Explore the Optimizer Choices
15m 46s
3.7 See common issues with poorly performing Partitioned queries
5m 33s
3.8 Use Driving Table Hints
7m 5s
Put it all together
1m 20s
Learning Objectives
53s
4.1 Understand how Indexes work
6m 20s
4.2 Explore the Complete Index syntax
19m 32s
4.3 See how the CBO chooses which Index to use
2m 14s
4.4 Utilize Index Monitoring
6m 40s
4.5 Understand Index Clustering Factor
10m 46s
4.6 Utilize Bitmap Indexes
5m 41s
4.7 Understand Index-organized tables
3m 13s
4.8 Explore Index tips and techniques
5m 26s
4.9 Use some helpful Index Hints
5m 39s
Put it all together
1m 22s
Learning Objectives
31s
5.1 Understand how the CBO arrives at row estimations
3m 16s
5.2 Explore where the math goes wrong
1m 49s
5.3 Use the proper data types for better performance
7m 21s
5.4 Look at the Where clause content
2m 46s
Put it all together
58s
Learning Objectives
31s
6.1 Look at SQL that has Sorts
4m 8s
6.2 Explore how the CBO processes views
3m 2s
6.3 Understand Sub-query processing
7m 13s
6.4 Control the Explain Plan via Sub-queries
8m 49s
6.5 Use Hints in Sub-queries
3m 33s
Put it all together
1m 9s
Learning Objectives
28s
7.1 Spot Problem SQL via Explain Plan
2m 21s
7.2 Review Problem SQL 1
2m 32s
7.3 Review Problem SQL 2
1m 39s
7.4 Review Problem SQL 3
1m 54s
7.5 Use Table Alias for code readability
5m 5s
7.6 Review Hints
7m 8s
Put it all together
46s
Learning Objectives
27s
8.1 Use the proper data types
3m 16s
8.2 Understand CBO Histograms
8m 36s
8.3 Explore Oracle12 Adaptive Statistics
1m 39s
8.4 Review Oracle Adaptive SQL Plans
6m 29s
Put it all together
1m 5s
Oracle SQL Performance Tuning for Developers LiveLessons: Summary
59s

Content preview from Learning Path: Professional Oracle Developer

13.6 Use the Toad PL/SQL profiler

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Start your free trial

Learning Path: Beginner Oracle Developer

Dan Hotka

Oracle Advanced PL/SQL Developer Professional Guide

Saurabh K. Gupta

Oracle PL/SQL Programming: A Developer's Workbook

Steven Feuerstein, Andrew Odewahn

Oracle 11g

Lewis Cunningham

Publisher Resources

ISBN: 9780134664026

Introduction

Lesson 1: Oracle Database Architecture

Lesson 2: Oracle Execution Plans/Explain Plans

Lesson 3: Explain Plan Content

Lesson 4: Indexes

Lesson 5: Where Clause Processing

Lesson 6: Sorts/Views/Sub-Query Processing

Lesson 7: Problem SQL Review

Lesson 8: Data Types and Statistics

Summary

Introduction

Lesson 1: Toad for Oracle Course Overview

Lesson 2: Toad Configuration and Setup Option

Lesson 3: SQL and the Editor Window

Lesson 4: The Schema Browser

Lesson 5: PL/SQL Tips and Techniques

Lesson 6: Toad as a SQL Tuning Tool

Lesson 7: Toad for the Database Administrator

Lesson 8: Other Useful Features of Toad

Lesson 9: Object and Data Relationship Features, Query Builder Features

Summary

Introduction

Introduction

Lesson 1: PL/SQL Course Overview

Lesson 2: Oracle PL/SQL Overview

Lesson 3: PL/SQL Basics and Variables

Lesson 4: Logic Flow

Lesson 5: PL/SQL Cursors

Lesson 6: PL/SQL Exception Handling

Lesson 7: PL/SQL Procedures and Functions

Lesson 8: PL/SQL Packages

Lesson 9: PL/SQL Triggers

Lesson 10: PL/SQL New Features

Lesson 11: PL/SQL Collections

Lesson 12: PL/SQL Debugger, PL/SQL Profiler, PL/SQL Tuning Tips

Oracle PL/SQL Programming Fundamentals LiveLessons: Summary

Introduction

Lesson 1: Oracle PL/SQL Advanced Course Overview

Lesson 2: PL/SQL Compiler Options: Part I

Lesson 3: PL/SQL Compiler Options: Part II

Lesson 4: PL/SQL Compiler Options and Packages

Lesson 5: PL/SQL Coding Style and New Features

Lesson 6: Oracle Database Triggers

Lesson 7: Cursors

Lesson 8: PL/SQL Collections

Lesson 9: Oracle Built-in Packages

Lesson 10: Dynamic SQL

Lesson 11: PL/SQL Performance

Lesson 12: Large Objects

Lesson 13: PL/SQL Debugger, PL/SQL Profiler, PL/SQL Tuning Tips

Summary

Summary

Content preview from Learning Path: Professional Oracle Developer

13.6 Use the Toad PL/SQL profiler

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,and much more.

You might also like

Learning Path: Beginner Oracle Developer

Oracle Advanced PL/SQL Developer Professional Guide

Oracle PL/SQL Programming: A Developer's Workbook

Oracle 11g

Publisher Resources

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.