Toad for Oracle Unleashed

By: Bert Scalzo, Dan Hotka

ISBN-13: 9780134131856
ISBN-10: 0134131851
Publisher: Sams Publishing
Published date: 2015-07-10
Toad is the world’s most popular third-party Oracle database tool: more than 3,000,000 people have used it, and acquiring it is a key reason Dell paid $2.4 billion last year for Quest Software. Now, world-renowned Toad and Oracle development experts Bert Scalzo and Dan Hotka have written the definitive, up-to-date guide to Version 12.x, the most powerful version of Toad ever created. 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 with Toad. It thoroughly covers every area of Toad’s functionality, offering practical, proven solutions you can apply immediately to leverage TOAD’s dramatically improved feature set. Scalzo and Hotka provide practical insights into each of Toad’s most useful tools, from App Designer to Doc Generator, ER Diagrammer to Code Road Map. Coverage includes: Toad setup and configuration Browsing databases and schemas Editing SQL and PL/SQL within Toad Creating new databases Checking database health Performing common DBA tasks Reporting via standard and custom reports Automating configurable, objective code reviews and reports Generating randomized or real-world test data Modeling PL/SQL dependencies and relationships graphically and within a database Identifying gaps between intended and actual functional code execution Optimizing database performance, and much more Automating performance and scalability testing, including database workload replay Building programs according to pre-defined project coding standards, and much more