Home | | Shopping Cart | | Track Your Order | Help | Wish List | Contact Us
> >

Oracle Database 11g The Complete Reference, 1/e


Rs.725
Rs.616
15%
Rs.108 (15%)

Out Of Stock
Oracle Database 11g The Complete Reference, 1/e
INR
P-M-B-9780070140790
Out Of Stock
616.25
Rs.616
Out of Stock

Description

Description:

The Definitive Guide to Oracle Database 11
g

Get full details on the powerful features of Oracle Database 11
g

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 11
g

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 11
g

Architecture Options

Ch 2: Installing Oracle Database 11
g

and Creating a Database

Ch 3: Upgrading to Oracle Database 11
g

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

Description:The Definitive Guide to Oracle Database 11gGet full details on the powerful features of Oracle Database 11gfrom this thoroughly updated Oracle Press guide.Oracle Database 11g: The Complete Referenceexplains 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 11gor upgrade from an earlier versionCreate database tables, sequences, indexes, views, and user accountsConstruct SQL statements, procedures, queries, and subqueriesOptimize security using virtual private databases and transparent data encryptionImport and export data using SQL*Loader and Oracle Data PumpUse 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 ClustersTable of Contents:PART I: Critical Database ConceptsCh 1: Oracle Database 11gArchitecture OptionsCh 2: Installing Oracle Database 11gand Creating a DatabaseCh 3: Upgrading to Oracle Database 11gCh 4: Planning Oracle Applications?Approaches, Risks, and StandardsPART II: SQL and SQL*PlusCh 5: The Basic Parts of Speech in SQLCh 6: Basic SQL*Plus Reports and CommandsCh 7: Getting Text Information and Changing ItCh 8: Searching for Regular ExpressionsCh 9: Playing the NumbersCh 10: Dates: Then, Now, and the DifferenceCh 11: Conversion and Transformation FunctionsCh 12: Grouping Things TogetherCh 13: When One Query Depends upon AnotherCh 14: Some Complex PossibilitiesCh 15: Changing Data: insert, update, merge, and deleteCh 16: DECODE and CASE: if, then, and else in SQLCh 17: Creating and Managing Tables, Views, Indexes, Clusters, and SequencesCh 18: PartitioningCh 19: Basic Oracle SecurityPART III: Beyond the BasicsCh 20: Advanced Security?Virtual Private DatabasesCh 21: Advanced Security: Transparent Data EncryptionCh 22: Working with TablespacesCh 23: Using SQL*Loader to Load DataCh 24: Using Data Pump Export and ImportCh 25: Accessing Remote DataCh 26: Using Materialized ViewsCh 27: Using Oracle Text for Text SearchesCh 28: Using External TablesCh 29: Using Flashback QueriesCh 30: Flashback?Tables and DatabasesCh 31: SQL ReplayPART IV: PL/SQLCh 32: An Introduction to PL/SQLCh 33: Online Application UpgradesCh 34: TriggersCh 35: Procedures, Functions, and PackagesCh 36: Using Native Dynamic SQL and DBMS_SQLCh 37: PL/SQL TuningPART V: Object-Relational DatabasesCh 38: Implementing Types, Object Views, and MethodsCh 39: Collectors (Nested Tables and Varying Arrays)Ch 40: Using Large ObjectsCh 41: Advanced Object-Oriented ConceptsPART VI: Java in OracleCh 42: An Introduction to JavaCh 43: JDBC ProgrammingCh 44: Java Stored ProceduresPART VII: Hitchhiker's GuidesCh 45: The Hitchhiker's Guide to Oracle Data DictionaryCh 46: The Hitchhiker's Guide to Tuning Applications and SQLCh 47: SQL Result Cache and Client-Side Query CacheCh 48: Case Studies in TuningCh 49: Advanced Architecture Options--DB Vault, Content DB, and Records DBCh 50: Oracle Real Application ClustersCh 51: The Hitchhiker?s Guide to Database AdministrationCh 52: The Hitchhiker?s Guide to XML in OraclePart VIIIAlphabetical ReferenceIndex

Features

  • : Oracle Database 11g The Complete Reference, 1/e
  • : Tata McGraw-Hill
  • : 0070140790
  • : 9780070140790
  • : Paperback
  • : English

Look for Similar Items by Category

Disclaimer

Shipped by Infibeam.com

The following policies apply for the above product which would be shipped by Infibeam.com
1. Infibeam accept returns if the item shipped is defective or damaged
2. In case of damaged or defective product, the customer is required to raise a concern and ship the product back to us within 15 days from delivery
3. Return shipping costs will be borne by Infibeam.com
4. Infibeam will send a replacement unit as soon as the return package is received
5. Infibeam does not offer any cash refunds

Contact Us

Others

My Account

Help

Payment Options

  • Credit Cards
  • Net Banking(All Major Indian Banks)
payment.jpg
Powered by infibeam