Deze website maakt gebruik van cookies. Klik hier voor meer informatie.X sluit
Uitgebreid zoeken
Boek

Toad For Oracle Unleashed

Unleashed

Vooraankondiging
Toad For Oracle Unleashed - Scalzo, Bert; Hotka, Dan - ISBN: 9780134131856
Prijs: € 51,50 (onder voorbehoud)
Beschikbaarheid: Nog niet verschenen.
Bindwijze: Boek
Genre: Databases
Boekenliefde.nl:
Toad For Oracle Unleashed op boekenliefde.nl
Add to cart

Beschrijving

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

Details

Titel: Toad For Oracle Unleashed
auteur: Scalzo, Bert; Hotka, Dan
Mediatype: Boek
Taal: Engels
Druk: 1
Aantal pagina's: 288
Uitgever: Pearson Education (us)
Plaats van publicatie: 01
NUR: Databases
Afmetingen: 233 x 183 x 16
Gewicht: 474 gr
ISBN/ISBN13: 9780134131856
Intern nummer: 29635311

Inhoudsopgave

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

Winkelvoorraad

Dit product is op dit moment niet op voorraad in een van onze vestigingen.