Skip to main content

Oracle 12c For Dummies

Oracle 12c For Dummies

Chris Ruel, Michael Wessler

ISBN: 978-1-118-74527-4

Oct 2013

432 pages

$22.99

Description

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.

Introduction 1

Part I: Getting Started with Oracle 12c 5

Chapter 1: Discovering Databases and Oracle 12c 7

Chapter 2: Understanding Oracle Database Architecture 17

Chapter 3: Preparing to Implement Oracle 49

Part II: Implementing an Oracle Database 67

Chapter 4: Creating Your Database 69

Chapter 5: Connecting to the Database 93

Chapter 6: Understanding the Language of Databases: SQL 115

Chapter 7: Loading Data into Your Database 135

Part III: Caring for and Feeding an Oracle Database 153

Chapter 8: Keeping the Database Running 155

Chapter 9: Tuning an Oracle Database for Performance 185

Chapter 10: Securing and Auditing Your Database 215

Chapter 11: Facilitating Backup and Recovery 237

Chapter 12: Troubleshooting an Oracle Database 273

Chapter 13: Managing Your Database with Enterprise Manager 301

Part IV: Advanced Oracle Technologies 313

Chapter 14: Advanced Features 315

Chapter 15: Using High-Availability Options 351

Part V: The Part of Tens 373

Chapter 16: Ten Oracle Installation Do's 375

Chapter 17: Ten Database Design Do's 383

Appendix A: Installing Oracle 12c on Linux 391

Index 401