Book description
Written by Oracle insiders, this indispensable guide distills an enormous amount of information about the Oracle Database into one compact volume. Ideal for novice and experienced DBAs, developers, managers, and users, Oracle Essentials walks you through technologies and features in Oracle’s product line, including its architecture, data structures, networking, concurrency, and tuning.
Complete with illustrations and helpful hints, this fifth edition provides a valuable one-stop overview of Oracle Database 12c, including an introduction to Oracle and cloud computing. Oracle Essentials provides the conceptual background you need to understand how Oracle truly works.
Topics include:
- A complete overview of Oracle databases and data stores, and Fusion Middleware products and features
- Core concepts and structures in Oracle’s architecture, including pluggable databases
- Oracle objects and the various datatypes Oracle supports
- System and database management, including Oracle Enterprise Manager 12c
- Security options, basic auditing capabilities, and options for meeting compliance needs
- Performance characteristics of disk, memory, and CPU tuning
- Basic principles of multiuser concurrency
- Oracle’s online transaction processing (OLTP)
- Data warehouses, Big Data, and Oracle’s business intelligence tools
- Backup and recovery, and high availability and failover solutions
Publisher resources
Table of contents
- Oracle Essentials
- 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
- The Role of Oracle Fusion Middleware
- Distributed Database Features
- Data Movement Features
- Database Performance Features
- Managing the Oracle Database
- Database Security Features
- Oracle Database Development Tools
- Other Oracle Databases
- 2. Oracle Architecture
-
3. Installing and Running Oracle
- Installing Oracle
- Creating a Database
- Oracle Net Services and Oracle Net
- Starting Up the Database
- Shutting Down the Database
- Accessing a Database
- Oracle in the Cloud
- Oracle at Work
- 4. Oracle Data Structures
- 5. Managing Oracle
-
6. Oracle Security, Auditing, and Compliance
-
Security
- Usernames, Privileges, Groups, and Roles
- Identity Management
- Security Privileges
- Special Roles: DBA, SYSDBA, and SYSOPER
- Policies
- Restricting Data-Specific Access
- Label Security Option
- Security and Application Roles and Privileges
- Distributed Database and Multitier Security
- Advanced Security Option
- Encryption
- Data Redaction
- Secure Backup
- Auditing
- Compliance
-
Security
- 7. Oracle Performance
- 8. Oracle Multiuser Concurrency
- 9. Oracle and Transaction Processing
-
10. Oracle Data Warehousing and Business Intelligence
- Data Warehousing Basics
- Data Warehouse Design
- Query Optimization
- Dimensional Data and Hierarchies in the Database
- Analytics and Statistics in the Database
- Other Datatypes and Big Data
- Loading Data into the Data Warehouse
- Managing the Data Warehouse
- Business Intelligence Tools
- The Metadata Challenge
- Putting It All Together
- 11. Oracle and High Availability
- 12. Oracle and Hardware Architecture
- 13. Oracle Distributed Databases and Distributed Data
- 14. Oracle Extended Datatypes
- 15. Oracle and the Cloud
-
A. What’s New in This Book for Oracle Database 12c
- Chapter 1: Introducing Oracle
- Chapter 2: Oracle Architecture
- Chapter 3: Installing and Running Oracle
- Chapter 4: Data Structures
- Chapter 5: Managing Oracle
- Chapter 6: Oracle Security, Auditing, and Compliance
- Chapter 7: Oracle Performance
- Chapter 8: Oracle Multiuser Concurrency
- Chapter 9: Oracle and Transaction Processing
- Chapter 10: Oracle Data Warehousing and Business Intelligence
- Chapter 11: Oracle and High Availability
- Chapter 12: Oracle and Hardware Architecture
- Chapter 13: Oracle Distributed Databases and Distributed Data
- Chapter 14: Oracle Extended Datatypes
- Chapter 15: Oracle and the Cloud
-
B. Additional Resources
- Web Sites
-
Books and Oracle Documentation
- Chapter 1: Introducing Oracle
- Chapter 2: Oracle Architecture
- Chapter 3: Installing and Running Oracle
- Chapter 4: Data Structures
- Chapter 5: Managing Oracle
- Chapter 6: Oracle Security, Auditing, and Compliance
- Chapter 7: Oracle Performance
- Chapter 8: Oracle Multiuser Concurrency
- Chapter 9: Oracle and Transaction Processing
- Chapter 10: Oracle Data Warehousing and Business Intelligence
- Chapter 11: Oracle and High Availability
- Chapter 12: Oracle and Hardware Architecture
- Chapter 13: Oracle Distributed Databases and Distributed Data
- Chapter 14: Oracle Extended Datatypes
- Chapter 15: Oracle and the Cloud
- Index
- About the Authors
- Colophon
- Copyright
Product information
- Title: Oracle Essentials, 5th Edition
- Author(s):
- Release date: September 2013
- Publisher(s): O'Reilly Media, Inc.
- ISBN: 9781449343170
You might also like
book
Oracle SQL*Plus: The Definitive Guide, 2nd Edition
Despite its wide availability and usage, few developers and DBAs have mastered the true power of …
book
Advanced Oracle PL/SQL Developer's Guide - Second Edition
Master the advanced concepts of PL/SQL for professional-level certification and learn the new capabilities of Oracle …
book
Oracle Internals
Oracle has evolved from a simple relational database into one of the most complex e-commerce platforms …
book
Oracle PL/SQL by Example, 6th Edition
Using PL/SQL for Oracle Database 21c, you can build solutions that deliver unprecedented performance and efficiency …