Books & Videos

Table of Contents

Chapter: Introduction

Toad for Oracle: Introduction

06m 2s

Chapter: Lesson 1: Toad for Oracle Course Overview

Learning objectives

00m 28s

1.1 Understand the course pre-requisites

00m 53s

1.2 Understand the course database objects and the course download

03m 18s

1.3 Introduce Toad for Oracle Unleashed book

00m 42s

Put it all together

00m 20s

Chapter: Lesson 2: Toad Configuration and Setup Option

Learning objectives

00m 27s

2.1 Install Toad

00m 46s

2.2 Understand login panel options and configuration

06m 4s

2.3 Explore useful Toad options panels

14m 30s

2.4 Customize the Tool bar

05m 11s

Put it all together

00m 43s

Chapter: Lesson 3: SQL and the Editor Window

Learning objectives

00m 44s

3.1 Use the editor window

06m 48s

3.2 Work with the describe panel

06m 44s

3.3 Discover useful SQL code

05m 57s

3.4 Work with the Toad SQL history feature

04m 35s

3.5 Discover useful user enhancements

04m 2s

3.6 Introduce Toad's Code Review

05m 5s

3.7 Hands-on Lab

08m 24s

Put it all together

00m 41s

Chapter: Lesson 4: The Schema Browser

Learning objectives

00m 36s

4.1 Use the Toad schema browser panel to configure the interface LHS and RHS options

04m 39s

4.2 Manage vast numbers of objects

06m 18s

4.3 Create object wizards from navigator tree

04m 49s

4.4 Explore additional data grid features

07m 6s

4.5 Export data from the data grid

05m 45s

4.6 Create reports from data grids using the Fast Reports interface

04m 48s

4.7 Hands-on Lab

14m 8s

Put it all together

00m 51s

Chapter: Lesson 5: PL/SQL Tips and Techniques

Learning objectives

00m 28s

5.1 Explore PL/SQL

06m 27s

5.2 Work with code templates

06m 11s

5.3 Use the PL/SQL symbolic debugger

13m 27s

5.4 Hands-on Lab

02m 44s

Put it all together

00m 35s

Chapter: Lesson 6: Toad as a SQL Tuning Tool

Learning objectives

01m 3s

6.1 Utilize Toad Explain Plan features

06m 45s

6.2 Use the query viewer

01m 43s

6.3 Work with auto trace

01m 28s

6.4 Use Auto Optimize SQL/SQL Tuning Advisor

04m 49s

6.5 Utilize Session Browser to show SQL, wait events and locking

09m 54s

6.6 Work with SQL Trace (10046 trace)

04m 12s

6.7 Work with the PL/SQL profiler

06m 1s

6.8 Hands-on Lab

06m 47s

Put it all together

00m 49s

Chapter: Lesson 7: Toad for the Database Administrator

Learning objectives

00m 42s

7.1 Utilize Toad monitoring features for the DBA

06m 20s

7.2 Review Toad's tablespace management options

03m 39s

7.3 Work with statistics and useful monitoring assistance

08m 25s

7.4 Review additional DBA topics in Toad

03m 48s

Put it all together

00m 25s

Chapter: Lesson 8: Other Useful Features of Toad

Learning objectives

00m 38s

8.1 Explore Automation Designer

03m 51s

8.2 Utilize Finding Objects

02m 35s

8.3 Work with HTML doc generator

05m 32s

8.4 Use Toad's compare features

04m 36s

8.5 Create objects and scripts using Toad

04m 56s

8.6 Explore various Toad reports

02m 40s

8.7 Review useful keystrokes in Toad

04m 26s

8.8 Hands-on Lab

03m 43s

Put it all together

00m 42s

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

Learning objectives

00m 28s

9.1 Discover master/detail data browsing

02m 50s

9.2 Use Entity Relationship Diagram

02m 43s

9.3 Use Query Builder

05m 22s

9.4 Hands-on Lab

05m 17s

Put it all together

00m 55s

Chapter: Summary

Toad for Oracle: Summary

01m 49s