ISBN 9789351343707,Oracle Database 12C: The Complete Reference

Oracle Database 12C: The Complete Reference



Tata McGraw - Hill Education

Publication Year 2013

ISBN 9789351343707

ISBN-10 9351343707


Number of Pages 1468 Pages
Language (English)

Software Requirement & Analysis

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