Book description
Get a Solid Foundation in Oracle Database Technology
Master Oracle Database 11g fundamentals quickly and easily. Using self-paced tutorials, this book covers core database essentials, the role of the administrator, high availability, and large database features. Oracle Database 11g: A Beginner's Guide walks you, step by step, through database setup, administration, programming, backup, and recovery. In-depth introductions to SQL and PL/SQL are included. Designed for easy learning, this exclusive Oracle Press guide offers:
- Core Concepts--Oracle Database 11g topics presented in logically organized chapters
- 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
- Notes--Extra information related to the topic being covered
- Mastery Checks--Chapter-ending quizzes to test your knowledge
Table of contents
- Cover Page
- Oracle Database 11g: A Beginner’s Guide
- Copyright Page
- Contents
- ACKNOWLEDGMENTS
- INTRODUCTION
-
1 Database Fundamentals
- Critical Skill 1.1 Define a Database
- Critical Skill 1.2 Learn the Oracle Database 11g Architecture
- Critical Skill 1.3 Learn the Basic Oracle Database 11g Data Types
- Critical Skill 1.4 Work with Tables
- Critical Skill 1.5 Work with Stored Programmed Objects
- Critical Skill 1.6 Become Familiar with Other Important Items in Oracle Database 11g
- Critical Skill 1.7 Work with Object and System Privileges
- Critical Skill 1.8 Introduce Yourself to the Grid
- Critical Skill 1.9 Tie It All Together
- Chapter 1 Mastery Check
- 2 Installing Oracle
-
3 Connecting to Oracle
- Critical Skill 3.1 Use Oracle Net Services
- Critical Skill 3.2 Learn the Difference Between Dedicated and Shared Server Architectures
- Critical Skill 3.3 Define Connections
- Critical Skill 3.4 Use the Oracle Net Listener
- Critical Skill 3.5 Learn Naming Methods
- Critical Skill 3.6 Use Oracle Configuration Files
- Critical Skill 3.7 Use Administration Tools
- Critical Skill 3.8 Use Profiles
- Critical Skill 3.9 Network in a Multi-tiered Environment
- Critical Skill 3.10 Install the Oracle 11g Client Software
- Chapter 3 Mastery Check
-
4 SQL: Structured Query Language
- Critical Skill 4.1 Learn the SQL Statement Components
- Critical Skill 4.2 Use Basic Insert and Select Statements
- Critical Skill 4.3 Use Simple Where Clauses
- Critical Skill 4.4 Use Basic Update and Delete Statements
- Critical Skill 4.5 Order Data
- Critical Skill 4.6 Employ Functions: String, Numeric, Aggregate (No Grouping)
- Critical Skill 4.7 Use Dates and Data Functions (Formatting and Chronological)
- Critical Skill 4.8 Employ Joins (ANSI vs. Oracle): Inner, Outer, Self
- Critical Skill 4.9 Learn the Group By and Having Clauses
- Critical Skill 4.10 Learn Subqueries: Simple and Correlated Comparison with Joins
- Critical Skill 4.11 Use Set Operators: Union, Intersect, Minus
- Critical Skill 4.12 Use Views
- Critical Skill 4.13 Learn Sequences: Just Simple Stuff
- Critical Skill 4.14 Employ Constraints: Linkage to Entity Models, Types, Deferred, Enforced, Gathering Exceptions
- Critical Skill 4.15 Format Your Output with SQL *Plus
- Chapter 4 Mastery Check
-
5 PL/SQL
- Critical Skill 5.1 Define PL/SQL and Learn Why We Use It
- Critical Skill 5.2 Describe the Basic PL/SQL Program Structure
- Critical Skill 5.3 Define PL/SQL Data Types
- Critical Skill 5.4 Write PL/SQL Programs in SQL*Plus
- Critical Skill 5.5 Handle Error Conditions in PL/SQL
- Critical Skill 5.6 Include Conditions in Your Programs
- Project 5-2 Use Conditions and Loops in PL/SQL
- Critical Skill 5.7 Create Stored Procedures—How and Why
- Critical Skill 5.8 Create and Use Functions
- Critical Skill 5.9 Call PL/SQL Programs
- Chapter 5 Mastery Check
-
6 The Database Administrator
- Critical Skill 6.1 Learn What a DBA Does
- Critical Skill 6.2 Perform Day-to-Day Operations
- Critical Skill 6.3 Understand the Oracle Database 11g Infrastructure
- Critical Skill 6.4 Operate Modes of an Oracle Database 11g
- Critical Skill 6.5 Get Started with Oracle Enterprise Manager
- Critical Skill 6.6 Manage Database Objects
- Critical Skill 6.7 Manage Space
- Critical Skill 6.8 Manage Users
- Critical Skill 6.9 Manage Privileges for Database Users
- Project 6-1 Create Essential Objects
- Chapter 6 Mastery Check
-
7 Backup and Recovery
- Critical Skill 7.1 Understand Oracle Backup and Recovery Fundamentals
- Critical Skill 7.2 Learn about Oracle User-Managed Backup and Recovery
- Critical Skill 7.3 Write a Database Backup
- Critical Skill 7.4 Back Up Archived Redo Logs
- Critical Skill 7.5 Get Started with Oracle Data Pump
- Critical Skill 7.6 Use Oracle Data Pump Export
- Critical Skill 7.7 Work with Oracle Data Pump Import
- Critical Skill 7.8 Use Traditional Export and Import
- Critical Skill 7.9 Get Started with Recovery Manager
- Project 7-1 RMAN End to End
- Chapter 7 Mastery Check
-
8 High Availability: RAC, ASM, and Data Guard
- Critical Skill 8.1 Define High Availability
- Critical Skill 8.2 Understand Real Application Clusters
- Critical Skill 8.3 Install RAC
- Critical Skill 8.4 Test RAC
- Critical Skill 8.5 Set Up the ASM Instance
- Critical Skill 8.6 Create ASM Disk Groups
- Critical Skill 8.7 Use ASMCMD and ASMLIB
- Critical Skill 8.8 Convert an Existing Database to ASM
- Critical Skill 8.9 Understand Data Guard
- Critical Skill 8.10 Explain Data Guard Protection Modes
- Critical Skill 8.11 Create a Physical Standby Server
- Chapter 8 Mastery Check
-
9 Large Database Features
- Critical Skill 9.1 Learn to Identify a Very Large Database
- Critical Skill 9.2 Why and How to Use Data Partitioning
- Project 9-1 Create a Range-Partitioned Table and a Local-Partitioned Index
- Critical Skill 9.3 Compress Your Data
- Critical Skill 9.4 Use Parallel Processing to Improve Performance
- Critical Skill 9.5 Use Materialized Views
- Critical Skill 9.6 Use SQL Aggregate and Analysis Functions
- Critical Skill 9.7 Create SQL Models
- Chapter 9 Mastery Check
-
A Mastery Check Answers
- Chapter 1: Database Fundamentals
- Chapter 2: Installing Oracle
- Chapter 3: Connecting to Oracle
- Chapter 4: SQL: Structured Query Language
- Chapter 5: PL/SQL
- Chapter 6: The Database Administrator
- Chapter 7: Backup and Recovery
- Chapter 8: High Availability: RAC, ASM, and Data Guard
- Chapter 9: Large Database Features
- Index
Product information
- Title: Oracle Database 11g A Beginner's Guide
- Author(s):
- Release date: October 2008
- Publisher(s): McGraw Hill Computing
- ISBN: 9780071604604
You might also like
book
Oracle Database 11g: New Features for DBAs and Developers
Oracle Database 11g : New Features for DBAs and Developers is a comprehensive, example-laden review of …
book
Oracle Database 11g DBA Handbook
The Essential Resource for Oracle DBAs--Fully Updated and Expanded Manage a flexible, highly available Oracle database …
book
Oracle GoldenGate 11g Handbook
Master Oracle GoldenGate 11 g Enable highly available, real-time access to enterprise data in heterogeneous environments. …
book
Building Database Clouds in Oracle 12c
An Expert Guide to Building Oracle Database Cloud Infrastructures This is the first complete, practical guide …