Knockout Narratives Sale
 
 

Special Offers see all

Enter to WIN a $100 Credit

Subscribe to PowellsBooks.news
for a chance to win.
Privacy Policy

Visit our stores


    Recently Viewed clear list


    The Powell's Playlist | January 5, 2015

    Tim Johnston: IMG The Powell's Playlist: Songs for Not Sleeping by Tim Johnston



    I once told a medical-profession-type lady that I didn't sleep well, that I awoke all through the night and was awake for hours. "What do you do... Continue »

    spacer
Qualifying orders ship free.
$25.00
Used Trade Paper
Ships in 1 to 3 days
Add to Wishlist
Qty Store Section
1 Burnside Database- Applications

More copies of this ISBN

Oracle Database 11g: The Complete Reference (Oracle Press)

by

Oracle Database 11g: The Complete Reference (Oracle Press) Cover

 

Synopses & Reviews

Publisher Comments:

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 versionCreate database tables, sequences, indexes, views, and user accountsConstruct SQL statements, procedures, queries, and subqueries Optimize security using virtual private databases and transparent data encryptionImport and export data using SQL*Loader and Oracle Data Pump Use SQL replay, change management, and result cachingAvoid human errors using flashback and automatic undo managementBuild and tune PL/SQL triggers, functions, and packagesDevelop database applications using Java, JDBC, and XMLOptimize availability and scalability with Oracle Real Application Clusters

Synopsis:

Fully revised and expanded for the latest database release, this authoritative guide provides thorough coverage of Oracle Database 11g in one of the most comprehensive references available.

Synopsis:

An all-new edition of the top-selling Oracle Press book ever published

Fully revised and expanded for the latest database release, this authoritative guide provides thorough coverage of Oracle Database 11g in the most comprehensive reference available. Starting by establishing critical database concepts and with in-depth details on all the new features, this powerhouse resource provides an overview of database architecture and Oracle Grid Computing technology.

Oracle Database 11g: The Complete Reference covers SQL, SQL Plus, PL/SQL, dynamic PL/SQL, object-oriented features, and Java programming in the Oracle environment. The book includes valuable database administration and application development techniques, plus an alphabetical reference covering major Oracle commands, keywords, features, and functions, with cross-referencing of topics. All code from the book will be available for download.

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

Table of Contents

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 ApplicationsApproaches, 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 SecurityVirtual Private Databases

Ch 21: Advacned Security - On-disk Encryption and Secure Backup

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: FlashbackTables 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: Hitchhiker's Guides

Ch 45: The Hitchhiker's Guide to Oracle Data Dictionary

Ch 46: The Hitchhiker's Guide to Tuning Applications

Ch 47: Client-side query cache -Use,configuration,and benefits

Ch 48: Case Studies in Tuning

Ch 49: Advanced Architecture Options

Ch 50: Oracle Real Application Clusters, Grid Architecture, and Management

Ch 51: The Hitchhikers Guide to Database Administration

Ch 52: The Hitchhikers Guide to XML in Oracle

Appendix: Alphabetical Reference

Product Details

ISBN:
9780071598750
Author:
Loney, Kevin
Publisher:
McGraw-Hill/Osborne Media
Author:
Loney Kevin
Subject:
Database Management - General
Subject:
Oracle DBA, Oracle developer, Oracle Grid Computing, PL/SQL, Oracle Database 11g New Features, Oracle Database 11g: A Beginners Guide, Oracle Database 11g SQL, Oracle Database 11g PL/SQL Programming
Subject:
Database Management - Oracle
Subject:
Oracle DBA, Oracle developer, Oracle Grid Computing, PL/SQL, Oracle Database 11g New Features, Oracle Database 11g: A Beginners Guide, Oracle Database 11g SQL, Oracle Database 11g PL/SQL Programming, 0071598758, 0071604596, 0071494456, 0071496610, 0071496
Subject:
Oracle DBA, Oracle developer, Oracle Grid Computing, PL/SQL, Oracle Database 11g New Features, Oracle Database 11g: A Beginners Guide, Oracle Database 11g SQL, Oracle Database 11g PL/SQL Programming, 0071598758, 0071604596, 0071494456, 0071496610, 0071496
Subject:
Relational databases
Subject:
Database management
Subject:
Database design
Copyright:
Series:
Osborne ORACLE Press Series
Publication Date:
September 2008
Binding:
Hardcover
Grade Level:
Professional and scholarly
Language:
English
Illustrations:
Y
Pages:
1334
Dimensions:
9.28x7.56x2.19 in. 4.67 lbs.

Other books you might like

  1. Introduction To Bioinformatics... New Hardcover $62.60

Related Subjects

Computers and Internet » Database » Applications
Computers and Internet » Database » Design
Computers and Internet » Software Engineering » Software Management
Health and Self-Help » Health and Medicine » General
Health and Self-Help » Health and Medicine » General Medicine

Oracle Database 11g: The Complete Reference (Oracle Press) Used Trade Paper
0 stars - 0 reviews
$25.00 In Stock
Product details 1334 pages McGraw-Hill/Osborne Media - English 9780071598750 Reviews:
"Synopsis" by , Fully revised and expanded for the latest database release, this authoritative guide provides thorough coverage of Oracle Database 11g in one of the most comprehensive references available.
"Synopsis" by ,

An all-new edition of the top-selling Oracle Press book ever published

Fully revised and expanded for the latest database release, this authoritative guide provides thorough coverage of Oracle Database 11g in the most comprehensive reference available. Starting by establishing critical database concepts and with in-depth details on all the new features, this powerhouse resource provides an overview of database architecture and Oracle Grid Computing technology.

Oracle Database 11g: The Complete Reference covers SQL, SQL Plus, PL/SQL, dynamic PL/SQL, object-oriented features, and Java programming in the Oracle environment. The book includes valuable database administration and application development techniques, plus an alphabetical reference covering major Oracle commands, keywords, features, and functions, with cross-referencing of topics. All code from the book will be available for download.

spacer
spacer
  • back to top

FOLLOW US ON...

     
Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.