| |
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
Partitioning
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
Part IV: PL/SQL
An Introduction to PL/SQL
Online Application Upgrades
Triggers
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 ReferenceISBN - 9789351343707
|
| |
|