Toad for Oracle Unleashed

by Scalzo, Bert; Hotka, Dan

• ISBN13: 9780134131856
• ISBN10: 0134131851
• Format: Paperback
• Copyright: 2015-07-16
• Publisher: Sams Publishing

Summary

Bert Scalzo and Dan Hotka have written the definitive, up-to-date guide to Version 12.x, Dell’s powerful new release of Toad for Oracle. Packed with step-by-step recipes, detailed screen shots, and hands-on exercises, Toad for Oracle Unleashed shows both developers and DBAs how to maximize their productivity.

Drawing on their unsurpassed experience running Toad in production Oracle environments, Scalzo and Hotka thoroughly cover every area of Toad’s functionality. You’ll find practical insights into each of Toad’s most useful tools, from App Designer to Doc Generator, ER Diagrammer to Code Road Map. The authors offer proven solutions you can apply immediately to solve a wide variety of problems, from maintaining code integrity to automating performance and scalability testing.

 

Learn how to…

• Install and launch Toad, connect to a database, and explore Toad’s new features
• Customize Toad to optimize productivity in your environment
• Use the Editor Window to execute SQL and PL/SQL, and view, save, or convert data
• Browse your schema, and create and edit objects
• Quickly generate useful reports with FastReport and Report Manager
• Clarify your database’s tables and data with the powerful Entity Relationship Diagrammer (ERD) and HTML documentation generator
• Work more efficiently with PL/SQL using code templates, snippets, and shortcuts
• Automate actions and applications with Automation Designer
• Perform key DBA tasks including database health checks, tablespace management, database and schema comparisons, and object rebuilding
• Identify and optimize poorlyperforming SQL and applications

ON THE WEB:
Download all examples and source code presented in this book from informit.com/title/9780134131856 as it becomes available.

Author Biography

Bert Scalzo is a Database Expert for HGST (a Western Digital company) and was formerly at Dell Software as a member of the Toad dev team for 15 years. He has worked with Oracle databases for more than two decades. Mr. Scalzo’s work history includes time at both Oracle Education and Oracle Consulting. He holds several Oracle Masters certifications and has an extensive academic background—including a BS, MS, and PhD in Computer Science, an MBA, plus insurance industry designations. Mr. Scalzo is also an Oracle ACE.
Mr. Scalzo is an accomplished speaker and has presented at numerous Oracle conferences and user groups, including OOW, ODTUG, IOUG, OAUG, RMOUG, and many others.
He has written several books and numerous articles, papers, and blogs for the Oracle Technology Network (OTN), Oracle Magazine, Oracle Informant, PC Week (eWeek), Dell Power Solutions Magazine, The LINUX Journal, LINUX.com, Oracle FAQ, and Toad World.
http://bertscalzo.com/

Dan Hotka is a Training Specialist and an Oracle ACE Director who has more than 37 years in the computer industry, and more than 31 years of experience with Oracle products. His experience with the Oracle RDBMS dates back to the Oracle V4.0 days. Dan enjoys sharing his knowledge of the Oracle RDBMS. Dan is well published with 12 Oracle books and well over 200 published articles. He is frequently published in Oracle trade journals, regularly blogs, and speaks at Oracle conferences and user groups around the world.
Dan Hotka, Author/Instructor/Oracle ACE Director
www.DanHotka.com
[e-mail]
DanHotka.Blogspot.com

Table of Contents

I. Getting Started
1. Initial Setup
2. Configuring TOAD/Configuration Options
3. Customizing TOAD for Your Needs

 

II. Fast Track
1. Using TOAD

 

III. Working with SQL Editor Window
1. Insites
2. Code Snippets
3. SQL Recall
4. Auto Replace
5. SQL Modeler

 

IV. Schema Browser
1. Review of Data Grids

 

V. Working with Data
1. Review Data Grid Options
2. Master/Detail Browser
3. ERD Diagraming (Mapping of Data Relationships)

 

VI. Working with PL/SQL
1. Using the Editor
2. Using Templates
3. Project Manager
4. Using Code Snippets
5. Using the Debugger
6. Using the PL/SQL Profiler

 

VII. Team Building
1. Using the Team Building features of TOAD
2. Version Control

 

VIII. Automation Management/Scheduling
1. Using Automation Designer
2. Scheduling Regular Tasks

 

IX. Database Administration
1. Health Check
2. Session Browser
3. Database Browser
4. Export/Import
5. Tablespace Management
6. DBMS_Redefinition Wizard
7. Log Miner
8. Reporting
9. DBMS_Flashback
10. Schema and Database Compare
11. Service Manager
12. Scheduling

 

X. TOAD as a SQL Tuning Tool
1. Review Explain Plan Options
2. Review Useful Hints in Code Snippets
3. Running SQL Trace
4. Running TKProf/TKProf Browser
5. Using the Trace File Browser
6. Top Session Finder
7. AWR Browser
8. SGA Trace Optimization
9. DBA Diagnose (what SQL is getting called a lot)

 

Appendices:
1. Function/Menu/Button Cross Reference
2. TOAD Yahoo Groups