Book description
Master the Fundamentals of Oracle Database 12c
Filled with easy-to-follow tutorials, this Oracle Press guide provides detailed coverage of core database concepts, the role of the administrator, and enterprise database capabilities. Oracle Database 12c: Install, Configure & Maintain Like a Professional walks you through database configuration, administration, programming, backup and recovery, and high availability. You'll get in-depth introductions to SQL and PL/SQL as well as important information on managing large databases and using Oracle's engineered systems. This essential beginner's resource features:
- Critical Skills--Lists of specific skills covered in each chapter
- Projects--Practical exercises that show how to apply the critical skills learned in each chapter
- Progress Checks--Quick self-assessment sections to check your progress
- Ask the Expert--Q&A sections filled with helpful tips
- Notes--Extra information related to the topic being covered
- Mastery Checks--Chapter-ending quizzes to test your knowledge
Table of contents
- Cover
- Title Page
- Copyright Page
- About the Authors
- Contents at a Glance
- Contents
- Acknowledgments
-
Introduction
- What’s in This Book
- Chapter 1: The Database: The Foundations of 12c
- Chapter 2: Installing Oracle
- Chapter 3: SQL: Accessing and Retrieving Data
- Chapter 4: Programming in the Database
- Chapter 5: The Database Administrator
- Chapter 6: Backup and Recovery
- Chapter 7: High Availability: RAC, ASM, and Data Guard
- Chapter 8: Using and Managing Large Databases
- Chapter 9: Oracle’s Engineered Systems: From the Database Appliance to Exadata
- Intended Audience
-
Chapter 1: The Database: The Foundations of 12c
- CRITICAL SKILL 1.1. Define a Database
- CRITICAL SKILL 1.2. Become Familiar with the Characteristics of a Database
- CRITICAL SKILL 1.3. Learn When to Use a Database
- CRITICAL SKILL 1.4. Learn the Oracle Database 12c Architecture
- CRITICAL SKILL 1.5. Work with Objects in the Oracle Database
- CRITICAL SKILL 1.6. Work with Data Types in an Oracle Database
- CRITICAL SKILL 1.7. Pull It All Together: Objects and Data Types
- CRITICAL SKILL 1.8. Interact with the Data
- CRITICAL SKILL 1.9. Learn the New Features of Oracle Database 12c
- Chapter 1: Mastery Check
-
Chapter 2: Installing Oracle
- CRITICAL SKILL 2.1. Research and Plan the Installation
- CRITICAL SKILL 2.2. Set Up the Operating System
- Project 2-1: Configure Kernel Parameters
- CRITICAL SKILL 2.3. Get Familiar with Linux
- CRITICAL SKILL 2.4. Choose Components to Install
- CRITICAL SKILL 2.5. Install the Oracle Software
- Chapter 2: Mastery Check
-
Chapter 3: SQL: Accessing and Retrieving Data
- CRITICAL SKILL 3.1. Learn the SQL Statement Components
- CRITICAL SKILL 3.2. Use Basic Insert and Select Statements
- CRITICAL SKILL 3.3. Use Simple WHERE Clauses
- CRITICAL SKILL 3.4. Use Basic Update, Delete, and Merge Statements
- CRITICAL SKILL 3.5. Order Data
- CRITICAL SKILL 3.6. Employ Functions: String, Numeric, Aggregate (No Grouping)
- CRITICAL SKILL 3.7. Use Dates and Data Functions (Formatting and Chronological)
- CRITICAL SKILL 3.8. Employ Joins (ANSI vs. Oracle): Inner, Outer, Self, Apply
- Project 3-1: Join Data Using Inner and Outer Joins
- Project 3-2: Join Data Using ANSI SQL Joins
- CRITICAL SKILL 3.9. Learn the Group By and Having Clauses
- Project 3-3: Group Data in Your Select Statements
- CRITICAL SKILL 3.10. Learn Subqueries: Simple and Correlated Comparison with Joins
- CRITICAL SKILL 3.11. Use Set Operators: Union, Intersect, Minus
- Project 3-4: Use the Union Function in Your SQL
- CRITICAL SKILL 3.12. Use Views
- CRITICAL SKILL 3.13. Learn Sequences: Just Simple Stuff
- CRITICAL SKILL 3.14. Employ Constraints: Linkage to Entity Models, Types, Deferred, Enforced, Gathering Exceptions
- CRITICAL SKILL 3.15. Format Your Output with SQL*Plus
- Project 3-5: Format Your SQL Output
- Chapter 3: Mastery Check
-
Chapter 4: Programming in the Database
- CRITICAL SKILL 4.1. Define PL/SQL and Learn Why We Use It
- CRITICAL SKILL 4.2. Describe the Basic PL/SQL Program Structure
- CRITICAL SKILL 4.3. Define PL/SQL Data Types
- CRITICAL SKILL 4.4. Write PL/SQL Programs in SQL*Plus
- Project 4-1: Create a PL/SQL Program
- CRITICAL SKILL 4.5. Handle Error Conditions in PL/SQL
- CRITICAL SKILL 4.6. Include Conditions in Your Programs
- Project 4-2: Use Conditions and Loops in PL/SQL
- CRITICAL SKILL 4.7. Create Stored Procedures—How and Why
- CRITICAL SKILL 4.8. Create and Use Functions
- Project 4-3: Create and Use a Function
- CRITICAL SKILL 4.9. Call PL/SQL Programs
- Chapter 4: Mastery Check
-
Chapter 5: The Database Administrator
- CRITICAL SKILL 5.1. Learn What a DBA Does
- CRITICAL SKILL 5.2. Perform Day-to-Day Operations
- CRITICAL SKILL 5.3. Understand the Oracle Database 12c Architecture
- CRITICAL SKILL 5.4. Operate Modes for an Oracle Database 12c
- CRITICAL SKILL 5.5. Get Started with Oracle Enterprise Manager
- CRITICAL SKILL 5.6. Understand Database Connections
- CRITICAL SKILL 5.7. Manage Database Objects
- CRITICAL SKILL 5.8. Manage Space
- CRITICAL SKILL 5.9. Manage Users
- CRITICAL SKILL 5.10. Manage Privileges for Database Users
- Project 5-1: Create Essential Objects
- Chapter 5: Mastery Check
-
Chapter 6: Backup and Recovery
- CRITICAL SKILL 6.1. Understand Rman
- CRITICAL SKILL 6.2. See Reasons to Use Rman
- CRITICAL SKILL 6.3. Understand Storage Media
- CRITICAL SKILL 6.4. Examine RMAN Components
- CRITICAL SKILL 6.5. Invoke Rman
- CRITICAL SKILL 6.6. Learn RMAN Commands
- CRITICAL SKILL 6.7. Review RMAN Channels
- CRITICAL SKILL 6.8. Examine RMAN Configuration
- CRITICAL SKILL 6.9. Explore Backup Commands
- CRITICAL SKILL 6.10. Conduct Incremental Backups
- CRITICAL SKILL 6.11. List Backups
- CRITICAL SKILL 6.12. See RMAN Metadata
- CRITICAL SKILL 6.13. Use RMAN Restore
- CRITICAL SKILL 6.14. Understand RMAN Recover
- CRITICAL SKILL 6.15. Learn About Backup Retention
- CRITICAL SKILL 6.16. Check Syntax
- CRITICAL SKILL 6.17. Recover a Table
- CRITICAL SKILL 6.18. Pull It All Together
- Chapter 6: Mastery Check
-
Chapter 7: High Availability: RAC, ASM, and Data Guard
- CRITICAL SKILL 7.1. Define High Availability
- CRITICAL SKILL 7.2. Understand Real Application Clusters
- CRITICAL SKILL 7.3. Install RAC
- CRITICAL SKILL 7.4. Test RAC
- CRITICAL SKILL 7.5. Set Up the ASM Instance
- Project 7-1: Install ASMLib
- Project 7-2: Create Disk Groups
- CRITICAL SKILL 7.7. Use ASMCMD and ASMLib
- CRITICAL SKILL 7.8. Convert an Existing Database to ASM
- CRITICAL SKILL 7.9. Understand Data Guard
- CRITICAL SKILL 7.10. Explain Data Guard Protection Modes
- CRITICAL SKILL 7.11. Create a Physical Standby Server
- Project 7-3: Create a Physical Standby Server
- Chapter 7: Mastery Check
-
Chapter 8: Using and Managing Large Databases
- CRITICAL SKILL 8.1. Learn to Identify a Very Large Database
- CRITICAL SKILL 8.2. How and Why to Use Data Partitioning
- Project 8-1: Create a Range-Partitioned Table and a Local-Partitioned Index
- CRITICAL SKILL 8.3. Compress Your Data
- CRITICAL SKILL 8.4. Use Parallel Processing to Improve Performance
- CRITICAL SKILL 8.5. Use Materialized Views
- CRITICAL SKILL 8.6. Use SQL Aggregate and Analysis Functions
- CRITICAL SKILL 8.7. Create SQL Models
- Project 8-2: Use Analytic SQL Functions and Models
- Chapter 8: Mastery Check
-
Chapter 9: Oracle’s Engineered Systems: From the Database Appliance to Exadata
- CRITICAL SKILL 9.1. Understand Oracle Database Appliance
- CRITICAL SKILL 9.2. Manage Oracle Database Appliance
- CRITICAL SKILL 9.3. Learn about Exadata’s Main Components
- CRITICAL SKILL 9.4. Understand Exadata Storage
- CRITICAL SKILL 9.5. Accelerate Large Queries with Storage Offload
- CRITICAL SKILL 9.6. Understand Storage Indexes
- CRITICAL SKILL 9.7. Use the Exadata Flash Cache
- CRITICAL SKILL 9.8. Save Storage Space with Hybrid Columnar Compression
- CRITICAL SKILL 9.9. Enable Database Consolidation with I/O Resource Management
- Project 9-1: Create an Interdatabase IORM Plan
- CRITICAL SKILL 9.10. Perform Common Exadata Management Tasks
- CRITICAL SKILL 9.11. Manage Exadata with Oracle Enterprise Manager
- Chapter 9: Mastery Check
-
Appendix: Mastery Check Answers
- Chapter 1: The Database: The Foundations of 12c
- Chapter 2: Installing Oracle
- Chapter 3: SQL: Accessing and Retrieving Data
- Chapter 4: Programming in the Database
- Chapter 5: The Database Administrator
- Chapter 6: Backup and Recovery
- Chapter 7: High Availability: RAC, ASM, and Data Guard
- Chapter 8: Using and Managing Large Databases
- Chapter 9: Oracle’s Engineered Systems: From the Database Appliance to Exadata
- Index
Product information
- Title: Oracle Database 12c Install, Configure & Maintain Like a Professional
- Author(s):
- Release date: October 2013
- Publisher(s): McGraw Hill Computing
- ISBN: 9780071799348
You might also like
book
Oracle Database 12c Release 2 New Features
Leverage the New and Improved Features of Oracle Database 12c Written by Oracle experts Bob Bryla …
video
Oracle 12c New Features, Part I LiveLessons
4+ Hours of Video Instruction Overview In the wake of the release of Oracle Database 12 …
book
Oracle Database 12c New Features
Maximize the New and Improved Features of Oracle Database 12 c Written by Master Principle Database …
book
Oracle Database 12c Security
Best Practices for Comprehensive Oracle Database Security Written by renowned experts from Oracle's National Security Group, …