PRZEDMIOTEM OFERTY JEST KOD DOSTĘPOWY DO KSIĄŻKI ELEKTRONICZNEJ (EBOOK)
KSIĄŻKA JEST DOSTĘPNA NA ZEWNĘTRZNEJ PLATFORMIE. KSIĄŻKA NIE JEST W POSTACI PLIKU.
Bert Scalzo and Dan Hotka have written the definitive, up-to-date guide to Version ASK_FOR_LINK_2, 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 ASK_FOR_LINK_2/title/9780134131856 as it becomes available.
- Autorzy: Bert Scalzo Dan Hotka
- Wydawnictwo: Pearson Technology Group
- Data wydania: 2015
- Wydanie: 1
- Liczba stron:
- Forma publikacji: ePub (online)
- Język publikacji: angielski
- ISBN: 9780134131894
- About This eBook
- Title Page
- Copyright Page
- Contents at a Glance
- Table of Contents
- About the Authors
- Dedication
- We Want to Hear from You!
- Reader Services
- Introduction
- Who Should Read This Book
- Why This Book Is Unique
- How This Book Is Organized
- Chapter 1. Getting Started
- Introduction to Toad
- Toad Release History
- Toad Editions and Suites
- Prerequisites and Installation
- Running Toad the First Time
- Oracle Client Software
- Database Connections
- Introduction to Main Screens
- Basic Toad Customizations
- Common Newbie Questions
- Can Toad Do That?
- Toad versus Database Security
- Sharing Toad Options Settings
- HelpToad Running Slowly
- Summary
- Chapter 2. Fast Track
- Organizing Connections
- Toolbars and Menus
- Keyboard Shortcut Keys
- Startup Windows/Screens
- Startup Files, Scripts, and Actions
- Advanced Toad Customizations
- Sharing Toad Settings
- Summary
- Chapter 3. Working with SQL
- Editor Window
- SQL Editor Output Area
- Object Describe
- Toad Insights
- Code Snippets
- SQL Recall
- Auto Replace
- Query Builder
- Summary
- Chapter 4. Schema Browser
- Configuring the Schema Browser
- Creating and Editing Objects
- Printing Data Using FastReport
- Using the Reports Manager
- Summary
- Chapter 5. Working with Data
- Reviewing Data Grid Options
- Filter/Sort the Table Data
- View/Edit Query
- Show/Hide Columns
- Show Detail Dataset
- Calculate Selected Cells
- Export Dataset
- Refresh Dataset
- Cancel Query Execution or Fetch
- Add/Delete Rows
- Row Set Navigation Buttons
- Edit Row Set Control Buttons
- Commit/Rollback
- Bookmark Navigation
- Single Record Viewer
- Save Data in Various Formats
- Master Detail Browser
- ER Diagrammer
- HTML Documentation Generator
- Summary
- Chapter 6. Working with PL/SQL
- Using the Editor
- Using Code Templates
- Project Manager
- Using Code Snippets
- Code Shortcuts
- Code Analysis
- Using the Debugger
- Basic Debugging
- Advanced Debugging Techniques
- Using the PL/SQL Profiler
- Summary
- Chapter 7. Miscellaneous Tools
- Code Road Map
- External Tools
- Compare Files
- TNS Editor
- Script Manager
- UNIX Monitor
- Summary
- Chapter 8. Getting Started with Toad Automation
- Command Line (Legacy)
- Automation Designer (Future)
- Summary
- Chapter 9. Database Administration
- Health Check
- Session Browser
- Database Browser
- Simple Export
- Data Pump Export
- Tablespace Management
- Generate Database Script
- Generate Schema Script
- Compare Databases
- Compare Schemas
- Analyze All Objects
- Rebuild Multiple Objects
- Summary
- Chapter 10. Toad as a SQL Tuning Tool
- Toad and Explain Plans
- SQL Statistics
- Toad and SQL Trace
- Toad and TKProf
- Toad and Trace File Browser
- Statspack Interface
- AWR Browser
- Toad and the PL/SQL Profiler
- Toad and the SQL Optimizer
- Summary
- Index
- Code Snippets
W tej ofercie kupujesz kod dostępowy umożliwiający dostęp do wskazanej treści. Kod umożliwia dostęp do treści za pomocą przeglądarki WWW, dedykowanej aplikacji iOS (Apple) ze sklepu App Store lub dedykowanej aplikacji Android ze sklepu Play. Kod oraz instrukcje otrzymasz pocztą elektroniczną niezwłocznie po zaksięgowaniu płatności. Brak możliwości pobrania pliku.
Na podstawie art. 38 pkt 13 Ustawy z dnia 30 maja 2014 roku o prawach konsumenta realizując kod dostępowy rezygnujesz z prawa do odstąpienia od umowy zawartej na odległość.
Typ licencji: licencja wieczysta.
BRAK MOŻLIWOŚCI POBRANIA PLIKU.
NIE PRZESYŁAMY PLIKÓW E-MAILEM.