Oracle 12c For Dummies

Demystifying the power of the Oracle 12c database

The Oracle database is the industry-leading relational database management system (RDMS) used from small companies to the world’s largest enterprises alike for their most critical business and analytical processing. Oracle 12c includes industry leading enhancements to enable cloud computing and empowers users to manage both Big Data and traditional data structures faster and cheaper than ever before. Oracle 12c For Dummies is the perfect guide for a novice database administrator or an Oracle DBA who is new to Oracle 12c. The book covers what you need to know about Oracle 12c architecture, software tools, and how to successfully manage Oracle databases in the real world.

• Highlights the important features of Oracle 12c
• Explains how to create, populate, protect, tune, and troubleshoot a new Oracle database
• Covers advanced Oracle 12c technologies including Oracle Multitenant—the “pluggable database” concept—as well as several other key changes in this release

Make the most of Oracle 12c’s improved efficiency, stronger security, and simplified management capabilities with Oracle 12c For Dummies.

Table of Contents

Part I: Getting Started with Oracle 12c
Chapter 1: Discovering Databases and Oracle 12c
Chapter 2: Understanding Oracle Database Architecture
Chapter 3: Preparing to Implement Oracle

Part II: Implementing an Oracle Database
Chapter 4: Creating Your Database
Chapter 5: Connecting to the Database
Chapter 6: Understanding the Language of Databases: SQL
Chapter 7: Loading Data into Your Database

Part III: Caring for and Feeding an Oracle Database
Chapter 8: Keeping the Database Running
Chapter 9: Tuning an Oracle Database for Performance
Chapter 10: Securing and Auditing Your Database
Chapter 11: Facilitating Backup and Recovery
Chapter 12: Troubleshooting an Oracle Database
Chapter 13: Managing Your Database with Enterprise Manager

Part IV: Advanced Oracle Technologies
Chapter 14: Advanced Features
Chapter 15: Using High-Availability Options

Part V: The Part of Tens
Chapter 16: Ten Oracle Installation Do’s
Chapter 17: Ten Database Design Do’s

Appendix A: Installing Oracle 12c on Linux