Sign in  |  Register
Advanced search
Publication Cover

CITATION

Abramson, Ian; Abbey, Michael; Malcher, Michelle; and Corey, Michael. Oracle Database 12c: Install, Configure & Maintain Like a Professional. US: McGraw-Hill Osborne Media, 2013.

Oracle Database 12c: Install, Configure & Maintain Like a Professional

Authors: Ian Abramson, Michael Abbey, Michelle Malcher and Michael Corey

Published:  September 2013

eISBN: 9780071799348 0071799346 | ISBN: 9780071799331
Open eBook
  • Cover
  • Title Page
  • Copyright Page
  • Dedication
  • 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
  • Sharing
  • Storage
  • Data Consistency
  • Data Integrity
  • Critical Skill 1.3. Learn When to Use a Database
  • Critical Skill 1.4. Learn the Oracle Database 12c Architecture
  • Shared Memory
  • System Support Processes
  • Operating System Files
  • Critical Skill 1.5. Work with Objects in the Oracle Database
  • Tables
  • Views
  • Synonyms
  • Stored Objects
  • Critical Skill 1.6. Work with Data Types in an Oracle Database
  • Variable Length Character— Varchar2
  • Number
  • Datetime
  • CLOB/BLOB
  • Critical Skill 1.7. Pull it All Together: Objects and Data Types
  • Critical Skill 1.8. Interact with the Data
  • SQL*Developer
  • sqlplus
  • Critical Skill 1.9. Learn the New Features of Oracle Database 12c
  • Pluggable Databases
  • Application Development
  • Availability
  • Business Intelligence and Data Warehousing
  • Compression and Archiving
  • Overall Database Features
  • Grid Features
  • Manageability
  • Performance
  • Security
  • XML DB
  • Chapter 1: Mastery Check
  • Chapter 2: Installing Oracle
  • Critical Skill 2.1. Research and Plan the Installation
  • Define System Requirements
  • Linux Installation
  • Critical Skill 2.2. Set Up the Operating System
  • Project 2-1 Configure Kernel Parameters
  • Step by Step
  • Project Summary
  • Critical Skill 2.3. Get Familiar with Linux
  • Critical Skill 2.4. Choose Components to Install
  • Critical Skill 2.5. Install the Oracle Software
  • Database Configuration Assistant
  • Verify the Installation
  • Tie it All Together
  • Chapter 2: Mastery Check
  • Chapter 3: SQL: Accessing and Retrieving Data
  • Critical Skill 3.1. Learn the SQL Statement Components
  • DDL
  • DML
  • Critical Skill 3.2. Use Basic Insert and Select Statements
  • Insert
  • Select
  • Critical Skill 3.3. Use Simple WHERE Clauses
  • A WHERE Clause with AND/OR
  • The WHERE Clause with NOT
  • The WHERE Clause with a Range Search
  • The WHERE Clause with a Search List
  • The WHERE Clause with a Pattern Search
  • The WHERE Clause: Common Operators
  • Critical Skill 3.4. Use Basic Update, Delete, and Merge Statements
  • Update
  • Delete
  • Insert
  • Use Basic Merge Statements
  • Critical Skill 3.5. Order Data
  • Critical Skill 3.6. Employ Functions: String, Numeric, Aggregate (No Grouping)
  • String Functions
  • Numeric Functions
  • Aggregate Functions
  • Critical Skill 3.7. Use Dates and Data Functions (Formatting and Chronological)
  • Date Functions
  • Special Formats with the Date Data Type
  • Nested Functions
  • Critical Skill 3.8. Employ Joins (ANSI vs. Oracle): Inner, Outer, Self, Apply
  • Inner Joins
  • Outer Joins
  • Project 3-1: Join Data Using Inner and Outer Joins
  • Step by Step
  • Project Summary
  • Project 3-2: Join Data Using ANSI SQL Joins
  • Step by Step
  • Project Summary
  • Self-Joins
  • Critical Skill 3.9. Learn the Group By and Having Clauses
  • Group By
  • Having
  • Project 3-3: Group Data in Your Select Statements
  • Step by Step
  • Project Summary
  • Critical Skill 3.10. Learn Subqueries: Simple and Correlated Comparison with Joins
  • Simple Subquery
  • Correlated Subqueries with Joins
  • Critical Skill 3.11. Use Set Operators: Union, Intersect, Minus
  • Union
  • Union All
  • Intersect
  • Minus
  • Project 3-4: Use the Union Function in Your SQL
  • Step by Step
  • Project Summary
  • 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
  • Linkage to Entity Models
  • Types
  • Deferred
  • Critical Skill 3.15. Format Your Output with SQL*Plus
  • Page and Line Size
  • Page Titles
  • Page Footers
  • Formatting Columns
  • Project 3-5: Format Your SQL Output
  • Step by Step
  • Project Summary
  • Writing SQL*Plus Output to a File
  • 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
  • Valid Characters
  • Arithmetic Operators
  • The VARCHAR2 Data Type
  • The NUMBER Data Type
  • The DATE Data Type
  • The BOOLEAN Data Type
  • The VARRAY Data Type
  • Critical Skill 4.4. Write PL/SQL Programs in SQL*Plus
  • Project 4-1: Create a PL/SQL Program
  • Step by Step
  • Project Summary
  • SQL in Your PL/SQL Programs
  • PL/SQL Cursors
  • The Cursor FOR Loop
  • Critical Skill 4.5. Handle Error Conditions in PL/SQL
  • Error Handling Using Oracle-Supplied Variables
  • Critical Skill 4.6. Include Conditions in Your Programs
  • Program Control
  • IF Logic Structures
  • CASE Statements
  • Loops
  • The WHILE Loop
  • The FOR Loop
  • Project 4-2: Use Conditions and Loops in PL/SQL
  • Step by Step
  • Project Summary
  • 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
  • Step by Step
  • Project Summary
  • 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
  • Architecture and Design
  • Capacity Planning
  • Backup and Recovery
  • Security
  • Performance and Tuning
  • Managing Database Objects
  • Storage Management
  • Change Management
  • Schedule Jobs
  • Network Management
  • High Availability
  • Troubleshooting
  • Critical Skill 5.3. Understand the Oracle Database 12c Architecture
  • Schemas
  • Segments, Extents, and Blocks
  • Pluggable Databases
  • Logical Schema Structures
  • Storage Structures
  • Critical Skill 5.4. Operate Modes for an Oracle Database 12c
  • Modes of Operation
  • Container Database STARTUP
  • Other Ways to Open the Database
  • Forcing a Startup
  • Database and Instance Shutdown
  • Critical Skill 5.5. Get Started with Oracle Enterprise Manager
  • Instance Configuration
  • User Sessions
  • Resource Consumer Groups
  • Other Tools
  • Critical Skill 5.6. Understand Database Connections
  • Oracle Net Services
  • Command-Line Utilities
  • Connections
  • Maintain Connections
  • Define a Location
  • A Connect Descriptor
  • Define a Connect Descriptor
  • Critical Skill 5.7. Manage Database Objects
  • Control Files
  • Redo Logs
  • Undo Management
  • Schema Objects
  • Critical Skill 5.8. Manage Space
  • Archive Logs
  • Tablespaces and Data Files
  • Critical Skill 5.9. Manage Users
  • Create a User
  • Edit Users
  • Critical Skill 5.10. Manage Privileges for Database Users
  • Grant Authority
  • Types of Grants
  • Take Away Authority
  • Roles
  • Oracle-Defined Roles
  • Create and Grant a Role
  • Profiles
  • Tie it All Together
  • Project 5-1: Create Essential Objects
  • Step by Step
  • Project Summary
  • Chapter 5: Mastery Check
  • Chapter 6: Backup and Recovery
  • Critical Skill 6.1. Understand RMAN
  • RMAN Metadata
  • Critical Skill 6.2. See Reasons to Use RMAN
  • Critical Skill 6.3. Understand Storage Media
  • Critical Skill 6.4. Examine RMAN Components
  • Backup
  • Restore
  • Recovery
  • 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
  • Database
  • Tablespace
  • Datafile
  • Control File
  • Server Parameter File
  • Archived Redo Logs
  • 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
  • Backup Script
  • Restore and Recovery Script
  • 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
  • Workload Manager
  • ASM
  • Critical Skill 7.5. Set Up the ASM Instance
  • Project 7-1: Install ASMLib
  • Step by Step
  • Project Summary
  • Critical Skill 7.6. Create ASM Disk Groups
  • Project 7-2: Create Disk Groups
  • Step by Step
  • Project Summary
  • 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
  • Step by Step
  • Project Summary
  • Tie it All Together
  • 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
  • Why Use Data Partitioning
  • Manageability
  • Performance
  • Implement Data Partitioning
  • Project 8-1: Create a Range-Partitioned Table and a Local-Partitioned Index
  • Step by Step
  • Project Summary
  • Critical Skill 8.3. Compress Your Data
  • Data Compression
  • Index Key Compression
  • Automatic Data Optimization
  • Critical Skill 8.4. Use Parallel Processing to Improve Performance
  • Parallel Processing Database Components
  • Parallel Processing Configuration
  • Invoke Parallel Execution
  • Critical Skill 8.5. Use Materialized Views
  • Uses for Materialized Views
  • Query Rewrite
  • When to Create Materialized Views
  • Create Materialized Views
  • Critical Skill 8.6. Use SQL Aggregate and Analysis Functions
  • Aggregation Functions
  • rollup
  • cube
  • Analytic Functions
  • Windowing Functions
  • Other Functions
  • Critical Skill 8.7. Create SQL Models
  • Project 8-2: Use Analytic SQL Functions and Models
  • Step by Step
  • Project Summary
  • 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
  • Initial Configuration
  • Critical Skill 9.3. Learn About Exadata’s Main Components
  • Critical Skill 9.4. Understand Exadata Storage
  • Exadata Storage Concepts
  • Critical Skill 9.5. Accelerate Large Queries with Storage Offload
  • Smart Scan in Action
  • Why Smart Scans May Not Happen
  • Critical Skill 9.6. Understand Storage Indexes
  • Storage Indexes in Action
  • Critical Skill 9.7. Use the Exadata Flash Cache
  • Trying Out the Flash Cache
  • Critical Skill 9.8. Save Storage Space with Hybrid Columnar Compression
  • Hybrid Columnar Compression in Action
  • Using DBMS_COMPRESSION to Estimate Compression
  • Critical Skill 9.9. Enable Database Consolidation with I/O Resource Management
  • Project 9-1: Create an Interdatabase IORM Plan
  • Step by Step
  • Project Summary
  • Critical Skill 9.10. Perform Common Exadata Management Tasks
  • User Accounts on Exadata Storage Servers
  • Using DCLI to Retrieve Metrics from the Storage Server
  • Using EXACHK to Validate Exadata Configurations
  • Critical Skill 9.11. Manage Exadata with Oracle Enterprise Manager
  • Wrapping Up
  • 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