My Account Details
ISBN10: 0071598766 | ISBN13: 9780071598767
ISBN10: 0071598766
ISBN13: 9780071598767
Step 1 . Download Adobe Digital Editions to your PC or Mac desktop/laptop.
Step 2. Register and authorize your Adobe ID (optional). To access your eBook on multiple devices, first create an Adobe ID at account.adobe.com. Then, open Adobe Digital Editions, go to the Help menu, and select "Authorize Computer" to link your Adobe ID.
Step 3. Open Your eBook. Use Adobe Digital Editions to open the file. If the eBook doesn’t open, contact customer service for assistance.
The Definitive Guide to Oracle Database 11g Get full details on the powerful features of Oracle Database 11g from this thoroughly updated Oracle Press guide. Oracle Database 11g: The Complete Reference explains how to use all the new features and tools, execute powerful SQL queries, construct PL/SQL and SQL*Plus statements, and work with large objects and object-relational databases. Learn how to implement the latest security measures, tune database performance, and deploy grid computing techniques. An invaluable cross-referenced appendix containing Oracle commands, keywords, features, and functions is also included. Install Oracle Database 11g or upgrade from an earlier version Create database tables, sequences, indexes, views, and user accounts Construct SQL statements, procedures, queries, and subqueries Optimize security using virtual private databases and transparent data encryption Import and export data using SQL*Loader and Oracle Data Pump Use SQL replay, change management, and result caching Avoid human errors using flashback and automatic undo management Build and tune PL/SQL triggers, functions, and packages Develop database applications using Java, JDBC, and XML Optimize availability and scalability with Oracle Real Application Clusters
PART I: Critical Database Concepts
Ch 1: Oracle Database 10g Architecture Options
Ch 2: Installing Oracle Database 10g and Creating a Database
Ch 3: Upgrading to Oracle Database 10g
Ch 4: Planning Oracle Applications—Approaches, Risks, and Standards
PART II: SQL and SQL*Plus
Ch 5: The Basic Parts of Speech in SQL
Ch 6: Basic SQL*Plus Reports and Commands
Ch 7: Getting Text Information and Changing It
Ch 8: Searching for Regular Expressions
Ch 9: Playing the Numbers
Ch 10: Dates: Then, Now, and the Difference
Ch 11: Conversion and Transformation Functions
Ch 12: Grouping Things Together
Ch 13: When One Query Depends upon Another
Ch 14: Some Complex Possibilities
Ch 15: Changing Data insert, update, merge, and delete
Ch16: DECODE and CASE: if, then, and else in SQL
Ch 17: Creating and Managing Tables, Views, Indexes, Clusters, and Sequences
Ch 18: Editioning Ch 19: Basic Oracle Security
PART III: Beyond the Basics
Ch 20: Advanced Security—Virtual Private Databases
Ch 21: Other Advaced Security Options
Ch 22: Working with Tablespaces
Ch 23: Using SQL*Loader to Load Data
Ch 24: Using Data Pump Export and Import
Ch 25: Accessing Remote Data
Ch 26: Using Materialized Views
Ch 27: Using Oracle Text for Text Searches
Ch 28: Using External Tables
Ch 29: Using Flashback Queries
Ch 30: Flashback—Tables and Databases
Ch 31: Change Replay and SQL Replay
PART IV: PL/SQL
Ch 32: An Introduction to PL/SQL
Ch 33: Online Application Upgrades
Ch 34: Triggers
Ch 35: Procedures, Functions, and Packages
Ch 36: Using Native Dynamic SQL and DBMS_SQL
Ch 37: PL/SQL Tuning
PART V: Object-Relational Databases
Ch 38: Implementing Types, Object Views, and Methods
Ch 39: Collectors (Nested Tables and Varying Arrays)
Ch 40: Using Large Objects
Ch 41: Advanced Object-Oriented Concepts
PART VI: Java in Oracle
Ch 42: An Introduction to Java
Ch 43: JDBC Programming
Ch 44: Java Stored Procedures
PART VII: Clustered Oracle—The Grid
Ch 45: Oracle Real Application Clusters, Grid Architecture, and Management
PART VIII: Hitchhiker’s Guides
Ch 46: The Hitchhiker’s Guide to the Oracle Data Dictionary
Ch 47: The Hitchhiker’s Guide to Tuning Applications and SQL
Ch 48: Client-side Query Cache
Ch 49: Case Studies in Tuning
Ch 50: Advanced Architecture Options
Ch 51: The Hitchhiker’s Guide to Database Administration
Ch 52: The Hitchhiker’s Guide to XML in OracleAppendix: Alphabetical Reference
Need support? We're here to help - Get real-world support and resources every step of the way.
Top