Oracle Essentials: Oracle Database 12c

Preface

1. Introducing Oracle
-The Evolution of the Relational Database
-The Oracle Database Family
-Summary of Oracle Database Features
-Database Application Development Features
-Database Connection Features
-Distributed Database Features
-Data Movement Features
-Database Performance Features
-Database Management Features
-Database Security Features
-Oracle Development Tools
-Embedded Databases

2. Oracle Architecture
-Databases and Instances
-Deploying Physical Components
-Instance Memory and Processes
-The Data Dictionary

3. Installing and Running Oracle
-Installing Oracle
-Creating a Database
-Configuring Oracle Net
-Starting Up the Database
-Shutting Down the Database
-Accessing a Database
-Oracle at Work

4. Oracle Data Structures
-Datatypes
-Basic Data Structures
-Additional Data Structures
-Extended Logic for Data
-Data Design
-Constraints
-Triggers
-Query Optimization
-Understanding the Execution Plan
-SQL Advisors
-Data Dictionary Tables

5. Managing Oracle
-Manageability Features
-Oracle Enterprise Manager
-Fragmentation and Reorganization
-Backup and Recovery
-Working with Oracle Support

6. Oracle Security, Auditing, and Compliance
-Security
-Auditing
-Compliance

7. Oracle Performance
-Performance Tuning Basics
-Oracle and Disk I/O Resources
-Oracle and Parallelism
-Oracle and Memory Resources
-Oracle and CPU Resources
-Database Resource Manager

8. Oracle Multiuser Concurrency
-Basics of Concurrent Access
-Oracle and Concurrent User Access
-Oracle's Isolation Levels
-Oracle Concurrency Features
-How Oracle Handles Locking
-Concurrent Access and Performance
-Workspaces

9. Oracle and Transaction Processing
-OLTP Basics
-Oracle's OLTP Heritage
-Architectures for OLTP
-Oracle Features for OLTP
-High Availability
-Oracle Streams and Advanced Queuing
-Object Technologies and Distributed Components

10. Oracle Data Warehousing and Business Intelligence
-Business Intelligence Basics
-Data Warehouse Design
-Query Optimization
-Analytics, OLAP, and Data Mining in the Database
-Managing the Data Warehouse
-Other Software for the Data Warehouse
-The Metadata Challenge
-Best Practices

11. Oracle and High Availability
-What Is High Availability?
-System Failure
-Protecting Against System Failure
-Recovering from Failures
-Complete Site Failure
-Data Redundancy Solutions
-Rolling Upgrades

12. Oracle and Hardware Architecture
-System Basics
-Uniprocessor Systems
-Symmetric Multiprocessing Systems
-Clusters
-Non-Uniform Memory Access Systems
-Grid Computing
-Disk and Storage Technology
-Which Platform Deployment Solution?

13. Oracle Distributed Databases and Distributed Data
-Accessing Multiple Databases As a Single Entity
-Moving Data Between Distributed Systems

14. Oracle Extended Datatypes
-Object-Oriented Development
-Extensibility Features and Options
-Using the Extensibility Framework in Oracle

15. Beyond the Oracle Database
-Application Express
-Oracle Fusion Middleware
-Oracle SOA Suite

Appendix A: What's New in This Book for Oracle Database 11g
Appendix B: Additional Resources

Index