Books & Videos

Table of Contents

  1. Chapter 1 Introducing Oracle

    1. The Evolution of the Relational Database

    2. The Oracle Database Family

    3. Summary of Oracle Database Features

    4. Database Application Development Features

    5. Database Connection Features

    6. The Role of Oracle Fusion Middleware

    7. Distributed Database Features

    8. Data Movement Features

    9. Database Performance Features

    10. Managing the Oracle Database

    11. Database Security Features

    12. Oracle Database Development Tools

    13. Other Oracle Databases

  2. Chapter 2 Oracle Architecture

    1. Databases and Instances

    2. Deploying Physical Components

    3. Instance Memory and Processes

    4. Configuration, Engineered Systems, and the Cloud

    5. The Data Dictionary

  3. Chapter 3 Installing and Running Oracle

    1. Installing Oracle

    2. Creating a Database

    3. Oracle Net Services and Oracle Net

    4. Starting Up the Database

    5. Shutting Down the Database

    6. Accessing a Database

    7. Oracle in the Cloud

    8. Oracle at Work

  4. Chapter 4 Oracle Data Structures

    1. Datatypes

    2. Basic Data Structures

    3. Additional Data Structures

    4. Extended Logic for Data

    5. Data Design

    6. Constraints

    7. Triggers

    8. Query Optimization

    9. SQL Translation

    10. Understanding the Execution Plan

    11. SQL Advisors

    12. Data Dictionary Tables

  5. Chapter 5 Managing Oracle

    1. Manageability Features

    2. Oracle Enterprise Manager

    3. Backup and Recovery

    4. Working with Oracle Support

  6. Chapter 6 Oracle Security, Auditing, and Compliance

    1. Security

    2. Auditing

    3. Compliance

  7. Chapter 7 Oracle Performance

    1. Oracle and Resource Usage

    2. Oracle and Parallelism

    3. Oracle and Memory Resources

    4. Oracle and CPU Resources

    5. Performance Tuning Basics

  8. Chapter 8 Oracle Multiuser Concurrency

    1. Basics of Concurrent Access

    2. Oracle and Concurrent User Access

    3. Oracle’s Isolation Levels

    4. Oracle Concurrency Features

    5. How Oracle Handles Locking

    6. Concurrent Access and Performance

    7. Workspaces

  9. Chapter 9 Oracle and Transaction Processing

    1. OLTP Basics

    2. Oracle’s OLTP Heritage

    3. Architectures for OLTP

    4. Oracle Features for OLTP

    5. High Availability

  10. Chapter 10 Oracle Data Warehousing and Business Intelligence

    1. Data Warehousing Basics

    2. Data Warehouse Design

    3. Query Optimization

    4. Dimensional Data and Hierarchies in the Database

    5. Analytics and Statistics in the Database

    6. Other Datatypes and Big Data

    7. Loading Data into the Data Warehouse

    8. Managing the Data Warehouse

    9. Business Intelligence Tools

    10. The Metadata Challenge

    11. Putting It All Together

  11. Chapter 11 Oracle and High Availability

    1. What Is High Availability?

    2. The System Stack and Availability

    3. Protecting Against System Failure

    4. Site and Computer Server Failover

    5. Recovering from Failures and Data Corruption

    6. Planned Downtime

  12. Chapter 12 Oracle and Hardware Architecture

    1. System Basics

    2. Oracle’s Engineered Systems

    3. Choosing and Defining the Right Platform

  13. Chapter 13 Oracle Distributed Databases and Distributed Data

    1. Accessing Distributed Databases

    2. Replication and Data Transport

  14. Chapter 14 Oracle Extended Datatypes

    1. Object-Oriented Development

    2. Extensibility Features and Options

    3. The Extensibility Architecture Framework

  15. Chapter 15 Oracle and the Cloud

    1. Cloud Definitions

    2. Oracle Database in the Cloud

    3. Oracle Database Cloud Service

    4. Implementing Provider Clouds

  1. Appendix What’s New in This Book for Oracle Database 12c

    1. Chapter 1: Introducing Oracle

    2. Chapter 2: Oracle Architecture

    3. Chapter 3: Installing and Running Oracle

    4. Chapter 4: Data Structures

    5. Chapter 5: Managing Oracle

    6. Chapter 6: Oracle Security, Auditing, and Compliance

    7. Chapter 7: Oracle Performance

    8. Chapter 8: Oracle Multiuser Concurrency

    9. Chapter 9: Oracle and Transaction Processing

    10. Chapter 10: Oracle Data Warehousing and Business Intelligence

    11. Chapter 11: Oracle and High Availability

    12. Chapter 12: Oracle and Hardware Architecture

    13. Chapter 13: Oracle Distributed Databases and Distributed Data

    14. Chapter 14: Oracle Extended Datatypes

    15. Chapter 15: Oracle and the Cloud

  2. Appendix Additional Resources

    1. Web Sites

    2. Books and Oracle Documentation

  3. Colophon