on-demand course

Toad for Oracle

with Dan Hotka

November 2015

Beginner

4h 41m

English

Pearson

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

Watch now

Unlock full access

Includes

Earns Badge

Course outline

Toad for Oracle: Introduction
6m 2s
Learning objectives
28s
1.1 Understand the course pre-requisites
53s
1.2 Understand the course database objects and the course download
3m 18s
1.3 Introduce Toad for Oracle Unleashed book
42s
Put it all together
19s
Learning objectives
27s
2.1 Install Toad
46s
2.2 Understand login panel options and configuration
6m 5s
2.3 Explore useful Toad options panels
14m 30s
2.4 Customize the Tool bar
5m 11s
Put it all together
43s
Learning objectives
44s
3.1 Use the editor window
6m 49s
3.2 Work with the describe panel
6m 45s
3.3 Discover useful SQL code
5m 58s
3.4 Work with the Toad SQL history feature
4m 35s
3.5 Discover useful user enhancements
4m 2s
3.6 Introduce Toad's Code Review
5m 5s
3.7 Hands-on Lab
8m 24s
Put it all together
41s
Learning objectives
35s
4.1 Use the Toad schema browser panel to configure the interface LHS and RHS options
4m 39s
4.2 Manage vast numbers of objects
6m 18s
4.3 Create object wizards from navigator tree
4m 50s
4.4 Explore additional data grid features
7m 7s
4.5 Export data from the data grid
5m 45s
4.6 Create reports from data grids using the Fast Reports interface
4m 48s
4.7 Hands-on Lab
14m 8s
Put it all together
51s
Learning objectives
28s
5.1 Explore PL/SQL
6m 27s
5.2 Work with code templates
6m 11s
5.3 Use the PL/SQL symbolic debugger
13m 28s
5.4 Hands-on Lab
2m 44s
Put it all together
35s
Learning objectives
1m 3s
6.1 Utilize Toad Explain Plan features
6m 46s
6.2 Use the query viewer
1m 43s
6.3 Work with auto trace
1m 28s
6.4 Use Auto Optimize SQL/SQL Tuning Advisor
4m 50s
6.5 Utilize Session Browser to show SQL, wait events and locking
9m 55s
6.6 Work with SQL Trace (10046 trace)
4m 13s
6.7 Work with the PL/SQL profiler
6m 1s
6.8 Hands-on Lab
6m 47s
Put it all together
49s
Learning objectives
42s
7.1 Utilize Toad monitoring features for the DBA
6m 20s
7.2 Review Toad's tablespace management options
3m 39s
7.3 Work with statistics and useful monitoring assistance
8m 25s
7.4 Review additional DBA topics in Toad
3m 49s
Put it all together
25s
Learning objectives
38s
8.1 Explore Automation Designer
3m 51s
8.2 Utilize Finding Objects
2m 36s
8.3 Work with HTML doc generator
5m 32s
8.4 Use Toad's compare features
4m 36s
8.5 Create objects and scripts using Toad
4m 56s
8.6 Explore various Toad reports
2m 40s
8.7 Review useful keystrokes in Toad
4m 27s
8.8 Hands-on Lab
3m 44s
Put it all together
42s
Learning objectives
28s
9.1 Discover master/detail data browsing
2m 50s
9.2 Use Entity Relationship Diagram
2m 44s
9.3 Use Query Builder
5m 22s
9.4 Hands-on Lab
5m 17s
Put it all together
55s

Toad for Oracle: Summary
1m 49s

Content preview from Toad for Oracle

6.6 Work with SQL Trace (10046 trace)

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

Toad for Oracle Unleashed

Bert Scalzo, Dan Hotka

Toad Pocket Reference for Oracle, 2nd Edition

Jeff Smith, Patrick McGrath, Bert Scalzo

Oracle 11g

Lewis Cunningham

Learning Path: Professional Oracle Developer

Dan Hotka

Publisher Resources

ISBN: 9780134289311Other

Toad for Oracle

with Dan Hotka

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

Content preview from Toad for Oracle

6.6 Work with SQL Trace (10046 trace)

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.