Oracle Database 11g The Complete Reference [NOOK Book]

Overview

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 ...

See more details below
Oracle Database 11g The Complete Reference

Available on NOOK devices and apps  
  • NOOK Devices
  • Samsung Galaxy Tab 4 NOOK
  • NOOK HD/HD+ Tablet
  • NOOK
  • NOOK Color
  • NOOK Tablet
  • Tablet/Phone
  • NOOK for Windows 8 Tablet
  • NOOK for iOS
  • NOOK for Android
  • NOOK Kids for iPad
  • PC/Mac
  • NOOK for Windows 8
  • NOOK for PC
  • NOOK for Mac
  • NOOK for Web

Want a NOOK? Explore Now

NOOK Book (eBook)
$74.99
BN.com price

Overview

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

Read More Show Less

Product Details

  • ISBN-13: 9780071598767
  • Publisher: McGraw-Hill Education
  • Publication date: 1/7/2009
  • Series: Oracle Press
  • Sold by: Barnes & Noble
  • Format: eBook
  • Edition number: 1
  • Pages: 1368
  • Sales rank: 921761
  • File size: 17 MB
  • Note: This product may take a few minutes to download.

Meet the Author

Kevin Loney was named Consultant ofthe Year by ORACLE Magazine in 2002. He is an internationally recognized Oracle expert who frequently presents at Oracle user conferences in North America and Europe where he is regularly among the highest-rated presenters.

Read More Show Less

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
Read More Show Less

Customer Reviews

Average Rating 4.5
( 2 )
Rating Distribution

5 Star

(1)

4 Star

(1)

3 Star

(0)

2 Star

(0)

1 Star

(0)
Sort by: Showing all of 2 Customer Reviews
  • Posted Mon Jan 04 00:00:00 EST 2010

    Oracle Definitive Guide to 11g, I would agree as much as any can be.

    This is a good reference guide to help spin up to 11g. I have worked with Oracle since v7 and find Oracle is always a challenge yet, Oracle Press found Mr. Loney to help focus on the new 11g material. This book is clearly written by someone who has made all the mistakes and understand where you need a "heads up" to the pitfalls. It is clear he uses Oracle and not "paper" or instruction level only but hands on.
    I was very impressed with the material on DB upgrades as most references only lightly touch these issues although this book did the follow the same path in referencing you to the Oracle instructions for more detail Mr. Loney gave informative information.
    The Hitchhiker's Guide was helpful as was the explanation using the Data Pump Export's.
    I purchased this book under the "USED" icon yet the seller had listed it as "NEW". This book was in execellent condition and was a "NEW" book.
    I had never bought any book except directly from Oracle Press or from a major book store like B&N, and I would definitely buy a book using the B&N contractor's sales again. B & N, thank you for screening and providing alternative sources with awesome prices. Great results, great tracking of this shipment. I am very happy with this purchase.

    1 out of 1 people found this review helpful.

    Was this review helpful? Yes  No   Report this review
  • Posted Wed May 06 00:00:00 EDT 2009

    A useful reference for beginner to expert

    Since Oracle 7, this is the first book I get with each major release. It has contained the basic concepts, definitions, and syntax for each database version, making this the book to use for learning Oracle. Especially with major upgrades like 11g.

    With Oracle, no single book could actually be a complete reference, but this book serves as a quick reference to get up to speed on database topics, a starting point for detailed analysis. Although it does not drill deep down on most topics, it has enough detail to put features in context and help solve routine problems.

    Also included are "Hitchhiker Guides" to help proceduralize thought and execution. And don't forget the always useful Alphabetical Reference with the abridged syntax map.

    One additon I would like to see is a distinct way to mark what is new in the current database version. This would help DBAs in multi-version shops who use the book as a quick reference and do not want mix syntax.

    1 out of 1 people found this review helpful.

    Was this review helpful? Yes  No   Report this review
Sort by: Showing all of 2 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)