Muutke küpsiste eelistusi

TOAD Handbook 2nd edition [Pehme köide]

4.00/5 (12 hinnangut Goodreads-ist)
,
  • Formaat: Paperback / softback, 312 pages, kõrgus x laius x paksus: 228x179x16 mm, kaal: 484 g
  • Ilmumisaeg: 24-Sep-2009
  • Kirjastus: Addison-Wesley Educational Publishers Inc
  • ISBN-10: 0321649109
  • ISBN-13: 9780321649102
Teised raamatud teemal:
  • Pehme köide
  • Hind: 63,99 €*
  • * saadame teile pakkumise kasutatud raamatule, mille hind võib erineda kodulehel olevast hinnast
  • See raamat on trükist otsas, kuid me saadame teile pakkumise kasutatud raamatule.
  • Kogus:
  • Lisa ostukorvi
  • Tasuta tarne
  • Lisa soovinimekirja
TOAD Handbook 2nd editionSuurem pilt
  • Formaat: Paperback / softback, 312 pages, kõrgus x laius x paksus: 228x179x16 mm, kaal: 484 g
  • Ilmumisaeg: 24-Sep-2009
  • Kirjastus: Addison-Wesley Educational Publishers Inc
  • ISBN-10: 0321649109
  • ISBN-13: 9780321649102
Teised raamatud teemal:
Püsilink: https://www.kriso.ee/db/9780321649102.html
Märksõnad:
TOAD® Handbook, Second Edition, is the definitive, completely up-to-date guide to the newest version of TOAD, the worlds premier third-party Oracle utility. Packed with step-by-step recipes, screen snapshots, and hands-on exercises, this book brings together everything developers and DBAs need to maximize their productivity with TOAD in both administrative and development tasks.

 

TOAD product architect Bert Scalzo and leading TOAD trainer Dan Hotka thoroughly cover every area of TOADs functionality, offering practical, proven solutions that can be applied immediately to leverage TOADs dramatically improved feature set. Comprehensive 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 Optimizing database performance

Throughout the text, the authors offer practical insights into each of TOADs most useful tools, from App Designer to Doc Generator, ER Diagrammer to Code Road Map.

 

This book is the only current, comprehensive, and affordable guide to the latest version of TOADa must-have for any TOAD user.
Acknowledgments xiii
About the Authors xv
Introduction 1(1)
Who Should Read This Book
1(1)
Why This Book Is Unique
2(1)
How This Book Is Organized
2(3)
TOAD Setup and Configuration
5(14)
Windows Platform Support
6(1)
Database Connectivity
7(3)
Database Client Versions
10(1)
Which Version of TOAD to Use
10(2)
Running the TOAD Installer
12(1)
Copying TOAD Settings
13(1)
TOAD Adheres to Oracle Security
13(2)
Activating TOAD's Read-Only Mode
15(1)
Advanced TOAD Security Options
15(1)
Customizing TOAD to User Taste
16(1)
Summary
17(2)
Database and Schema Browsers
19(26)
Auto-Start a Browser
20(1)
Database Browser
21(6)
Schema Browser
27(15)
Schema Browser Options
42(2)
Summary
44(1)
SQL Editor
45(44)
Basic Concepts of the SQL Editor
45(14)
Predefined Shortcuts
59(3)
User-Defined Shortcuts
62(1)
Using Bind Variables
63(1)
Table and Column Name Select Lists
64(2)
TOAD Table Aliases Substitutions
66(1)
Auto Replacement Substitutions
67(1)
SQL Templates
68(2)
Code Snippets
70(1)
Executing SQL Statements
71(1)
Executing SQL Scripts
72(1)
Editing Result-Set Data
73(2)
Saving Result-Set Data
75(1)
Printing Result-Set Data
76(3)
Examining Explain Plans
79(3)
Examining Basic Performance Information
82(2)
Other Result Output Tabs
84(1)
SQL*Plus Compatibility
84(3)
SQL-Creating-SQL
87(1)
Summary
88(1)
TOAD PL/SQL Editor
89(36)
Basic Concepts of the PL/SQL Editor
89(7)
Formatting PL/SQL Code
96(2)
Predefined Shortcuts
98(3)
Using Aliases, Pick Lists, Shortcuts, Snippets, and Auto-Replacement Substitutions
101(1)
PL/SQL Object Templates
102(3)
Compiling PL/SQL Code
105(1)
Executing PL/SQL Code
105(2)
Saving PL/SQL Code to Files
107(1)
Debugging Setup, Requirements, and Parameters
108(1)
Basic Debugging PL/SQL Code
109(6)
Debugging Breakpoint Options
115(2)
Advanced Debugging PL/SQL Code
117(3)
Profiling PL/SQL Code
120(3)
Setting Up Source Code Control
123(1)
Using Source Code Control
123(1)
Summary
123(2)
Database Reporting
125(24)
TOAD Report Manager
125(6)
Building Reports Using Fast Reports
131(10)
Adding Reports to the TOAD Report Manager
141(3)
Using the HTML Schema Document Generator
144(4)
Summary
148(1)
Tuning Tools in TOAD
149(24)
Oracle Tuning Using TOAD
149(1)
SQL Explain Plans/Auto Trace
150(5)
Oracle Trace Facility
155(10)
StatsPack Reporting
165(3)
Automated Workload Repository Reporting
168(3)
Summary
171(2)
Database Management
173(32)
Database Health Check
174(2)
Creating New Databases
176(2)
Tablespaces and Data Files
178(3)
Start-ups and Shut-downs
181(2)
Oracle and NLS Parameters
183(3)
Generating Database Scripts
186(2)
Generating Schema Scripts
188(2)
Comparing Database Differences
190(5)
Rebuilding Multiple Objects
195(2)
Top Session Finder
197(1)
SGA Trace/Optimization
198(2)
Session Browser
200(3)
Summary
203(2)
Exporting Table Data
205(18)
Saving Grid Contents
205(3)
Flat File Export
208(1)
Creating Inserts
209(1)
Schema Browser Script
210(1)
Oracle Export
211(3)
Data Pump Export
214(4)
Data Subset Wizard
218(2)
Import Table Data
220(2)
Summary
222(1)
Other Useful Tools
223(24)
Master-Detail Browser
223(4)
ER Diagram
227(2)
Code Road Map
229(3)
Query Builder
232(6)
External Tools
238(2)
Compare Files
240(1)
TNS Editor
241(2)
Script Manager
243(2)
Summary
245(2)
TOAD App Designer
247(14)
TOAD Command Line
247(4)
TOAD App Designer
251(9)
Summary
260(1)
Index 261
Bert Scalzo, currently TOAD product architect at Quest Software, has worked with Oracle databases for well over two decades, including stints at both Oracle Education and Oracle Consulting. An accomplished speaker and presenter at Oracle conferences and user groups, he is author of many books, including TOAD Pocket Reference for Oracle, Second Edition (OReilly Media, Inc., 2005) and Oracle DBA Guide to Data Warehousing and Star Schemas (Prentice Hall, 2003).

 

Dan Hotka, an internationally recognized Oracle expert, has twenty-six years of experience with Oracle products. He regularly teaches courses on TOAD and works closely with Quest Software. He has authored or coauthored eleven books and speaks regularly at Oracle conferences and user groups around the world. He can be found on the Web at DanHotka.com.