Home  |  My Account  |  Shopping Cart (0 items)   
Login/Signup  |  Help  |  Contact Us  
Search for Books:       Advanced Search
Advance Search Cancel
Title : Author :
From Date To Date
Publisher : ISBN Number :
Category : Price : From To

Oracle Database 12c The Complete Reference-Bob Bryla, Kevin Loney
Oracle Database 12c The Complete Reference  Review
by Bob Bryla, Kevin Loney (Author)
Customer Reviews (0) | Write a Review
Publisher : Tata McGraw-Hill
Publish date : 01-Nov-2013
Category : Oracle
Mediatype : Books
Binding : Paperback
Availability : InStock, Order now ships within 2-3 business days
List Price :   Rs. 1285
Greenleaf Price :  Rs. 1092
You Save :  Rs. 193
ISBN : 9789351343707 / Indian ISBN 13: 9789351343707
Pages : 1468
Book Summary : Oracle Database 12c The Complete Reference
Maintain a scalable, highly available enterprise platform and reduce complexity by leveraging the powerful new tools and cloud enhancements of Oracle Database 12c. This authoritative Oracle Press guide offers complete coverage of installation, configuration, tuning and administration. Find out how to build and populate Oracle databases, perform effective queries, design applications and secure your enterprise data. Oracle Database 12c: The Complete Reference also contains a comprehensive appendix covering commands, keywords, features and functions.

    Set up Oracle Database 12c or upgrade from an earlier version.
    Design Oracle databases and plan for application implementation.
    Construct SQL and SQL*Plus statements and execute powerful queries.
    Secure data with roles, privileges, visualization and encryption.
    Move data with SQL*Loader and Oracle Data Pump.
    Restore databases using flashback and the Oracle Database Automatic Undo Management feature.
    Build and deploy PL/SQL triggers, procedures and packages.
    Work with Oracle pluggable and container databases.
    Develop database applications using Java, JDBC and XML.
    Optimize performance with Oracle Real Application Clusters.

Table of Contents:

Part I: Critical Database Concepts
    Oracle Database 12c Architecture Options
    Installing Oracle Database 12c and Creating a Database
    Upgrading to Oracle Database 12c
    Planning Oracle Applications - Approaches, Risks and Standards

Part II: SQL and SQL*Plus

    The Basic Parts of Speech in SQL
    Basic SQL*Plus Reports and Commands
    Getting Text Information and Changing It
    Searching for Regular Expressions
    Playing the Numbers
    Dates: Then, Now and the Difference
    Conversion and Transformation Functions
    Grouping Things Together
    When One Query Depends on Another
    Some Complex Possibilities
    Changing Data: Insert, Delete, Update and Merge
    Decode and Case: If, Then and Else In Sql
    Creating and Managing Tables, Views, Indexes, Clusters and Sequences
    Basic Oracle Security

Part III: Beyond the Basics
    Advanced Security - Virtual Private Databases
    Advanced Security - Transparent Data Encryption
    Working with Table spaces
    Using SQL*Loader to Load Data
    Using Data Pump ExpoPart and ImpoPart
    Accessing Remote Data
    Using Materialized Views
    Using Oracle Text for Text Searches
    Using External Tables
    Using Flashback Queries
    Flashback - Tables and Databases
    SQL Replay


    An Introduction to PL/SQL
    Online Application Upgrades
    Procedures, Functions and Packages
    Using Native Dynamic SQL and DBMS_SQL
    PL/SQL Tuning

Part V: Object-Relational Databases
    Implementing Object Types, Object Views and Methods
    Collectors (Nested Tables and Varying Arrays)
    Using Large Objects
    Advanced Object-Oriented Concepts

Part VI: Java in Oracle
    An Introduction to Java
    JDBC Programming
    Java Stored Procedures

Part VII: Hitchhiker's Guides
    The Hitchhiker's Guide to the Oracle Data Dictionary
    The Hitchhiker's Guide to Tuning Applications and SQL
    The Hitchhiker's Guide to SQL Result Cache and Client-Side Query Cache
    Case Studies in Tuning
    The Hitchhiker's Guide to Pluggable Databases
    The Hitchhiker's Guide to Oracle Real Application Clusters
    The Hitchhiker's Guide to Database Administration
    The Hitchhiker's Guide to XML in Oracle

Part VIII: Alphabetical Reference

About the Author

Bob Bryla has more than 20 years of experience in MIS, ranging from database and data warehouse design to system administration on multiple hardware platforms. He is currently lead designer and data analyst for Land's End's online store database and handles the DBA activities on Land's End Oracle Internet databases.

Kevin Loney was named Consultant of the Year by Oracle Magazine in 2002. He is an internationally recognized expert in the design, development and administration and tuning of Oracle databases. An Oracle developer and database administrator since 1987, Loney has designed and implemented both transactional processing systems and data warehouses.

Contact Us
Shipping & Returns
Help & FAQ
Terms of Use
About Us
About us
e-Gift Voucher
Book List
Author List
Search for Books :
© 2010 Greenleaf Bookshop. One Stop Shop for all your Books,CBT's, DVD's