Stock Image

Oracle Database 11g: The Complete Reference: Master the Powerful Features of the Latest Database Release

Kevin Loney

ISBN 10: 0070140790 / ISBN 13: 9780070140790
Published by Tata McGraw-Hill Education Pvt. Ltd., 2008
New Condition: New Soft cover
From BookVistas (New Delhi, DELHI, India)

AbeBooks Seller Since November 24, 2010

Quantity Available: > 20

Buy New
Price: US$ 24.98 Convert Currency
Shipping: US$ 4.69 From India to U.S.A. Destination, Rates & Speeds
Add to basket

30 Day Return Policy

About this Item

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 Table of contents PART I: Critical Database Concepts Ch 1: Oracle Database 11g Architecture Options Ch 2: Installing Oracle Database 11g and Creating a Database Ch 3: Upgrading to Oracle Database 11g 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 Ch 16: DECODE and CASE: if, then, and else in SQL Ch 17: Creating and Managing Tables, Views, Indexes, Clusters, and Sequences Ch 18: Partitioning Ch 19: Basic Oracle Security PART III: Beyond the Basics Ch 20: Advanced Security-Virtual Private Databases Ch 21: Advanced Security: Transparent Data Encryption 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: 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: Hitchhiker`s Guides Ch 45: The Hitchhiker`s Guide to Oracle Data Dictionary Ch 46: The Hitchhiker`s Guide to Tuning Applications and SQL Ch 47: SQL Result Cache and Client-Side Query Cache Ch 48: Case Studies in Tuning Ch 49: Advanced Architecture Options--DB Vault, Content DB, and Records DB Ch 50: Oracle Real Application Clusters Ch 51: The Hitchhiker`s Guide to Database Administration Ch 52: The Hitchhiker`s Guide to XML in Oracle Part VIII Alphabetical Reference Index Printed Pages: 1363. Bookseller Inventory # 21604

Ask Seller a Question

Bibliographic Details

Title: Oracle Database 11g: The Complete Reference:...

Publisher: Tata McGraw-Hill Education Pvt. Ltd.

Publication Date: 2008

Binding: Softcover

Book Condition:New

Edition: First edition.

About this title

Synopsis:

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

"About this title" may belong to another edition of this title.

Store Description

Visit Seller's Storefront

Terms of Sale:

All books are new. We accept payments by the following methods:

  1. Credit Card: Visa, MasterCard, or American Express.
  2. PayPal.
  3. Bank Draft or Banker's Cheque.
  4. Bank/Wire Transfer.

Cheques may be made payable to BookVistas.

Books are shipped by DHL, FedEx, Aramex, Registered Air Mail, or Registered SAL (Surface Air
Lifted).


Shipping Terms:

Shipping costs are based on books weighing 2.2 LB, or 1 KG. If your book order is heavy or oversized, we may contact you to let you know extra shipping is required.

List this Seller's Books

Payment Methods
accepted by seller

Visa Mastercard American Express

PayPal Bank Draft Bank/Wire Transfer