Opis: Toad for Oracle Unleashed - Dan Hotka, Bert Scalzo

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.Introduction xi Who Should Read This Book xi Why This Book Is Unique xii How This Book Is Organized xii 1 Getting Started 1 Introduction to Toad 1 Toad Release History 2 Toad Editions and Suites 3 Prerequisites and Installation 5 Running Toad the First Time 8 Oracle Client Software 9 Database Connections 10 Introduction to Main Screens 16 Basic Toad Customizations 18 Common Newbie Questions 21 Can Toad Do That? 21 Toad versus Database Security 22 Sharing Toad Options Settings 22 Help-Toad Running Slowly 22 Summary 23 2 Fast Track 25 Organizing Connections 25 Toolbars and Menus 30 Keyboard Shortcut Keys 33 Startup Windows/Screens 34 Startup Files, Scripts, and Actions 36 Advanced Toad Customizations 37 Sharing Toad Settings 40 Summary 41 3 Working with SQL 43 Editor Window 43 SQL Editor Output Area 48 Object Describe 51 Toad Insights 57 Code Snippets 58 SQL Recall 60 Auto Replace 63 Query Builder 64 Summary 68 4 Schema Browser 69 Configuring the Schema Browser 69 Creating and Editing Objects 76 Printing Data Using FastReport 79 Using the Reports Manager 85 Summary 91 5 Working with Data 93 Reviewing Data Grid Options 93 Filter/Sort the Table Data 97 View/Edit Query 99 Show/Hide Columns 100 Show Detail Dataset 100 Calculate Selected Cells 101 Export Dataset 102 Refresh Dataset 103 Cancel Query Execution or Fetch 104 Add/Delete Rows 104 Row Set Navigation Buttons 105 Edit Row Set Control Buttons 105 Commit/Rollback 105 Bookmark Navigation 105 Single Record Viewer 105 Save Data in Various Formats 106 Master Detail Browser 111 ER Diagrammer 113 HTML Documentation Generator 115 Summary 119 6 Working with PL/SQL 121 Using the Editor 121 Using Code Templates 127 Project Manager 132 Using Code Snippets 133 Code Shortcuts 135 Code Analysis 139 Using the Debugger 142 Basic Debugging 142 Advanced Debugging Techniques 148 Using the PL/SQL Profiler 153 Summary 156 7 Miscellaneous Tools 157 Code Road Map 157 External Tools 160 Compare Files 163 TNS Editor 164 Script Manager 165 UNIX Monitor 167 Summary 169 8 Getting Started with Toad Automation 171 Command Line (Legacy) 172 Automation Designer (Future) 180 Summary 190 9 Database Administration 191 Health Check 192 Session Browser 194 Database Browser 197 Simple Export 202 Data Pump Export 205 Tablespace Management 210 Generate Database Script 212 Generate Schema Script 214 Compare Databases 216 Compare Schema 218 Analyze All Objects 220 Rebuild Multiple Objects 223 Summary 224 10 Toad as a SQL Tuning Tool 227 Toad and Explain Plans 227 SQL Statistics 231 Toad and SQL Trace 233 Toad and TKPROF 238 Toad and Trace File Browser 241 Statspack Interface 243 AWR Browser 245 Toad and the PL/SQL Profiler 246 Toad and the SQL Optimizer 248 Summary 249 Index 251

Szczegóły: Toad for Oracle Unleashed - Dan Hotka, Bert Scalzo

Tytuł: Toad for Oracle Unleashed
Autor: Dan Hotka, Bert Scalzo
Producent: Sams Publishing
ISBN: 9780134131856
Rok produkcji: 2015
Ilość stron: 288
Oprawa: Miękka
Waga: 0.47 kg

Recenzje: Toad for Oracle Unleashed - Dan Hotka, Bert Scalzo