You are previewing Oracle Database Foundations.
O'Reilly logo
Oracle Database Foundations

Book Description

The world of IT is always evolving, but in every area there are stable, core concepts that anyone just setting out needed to know last year, needs to know this year, and will still need to know next year. The purpose of the Foundations series is to identify these concepts and present them in a way that gives you the strongest possible starting point, no matter what your endeavor.

Oracle Database Foundations provides essential knowledge about installing, configuring, maintaining, and querying Oracle 9i and 10g databases. What you learn here will benefit you in the short term, as you acquire and practice your skills, and in the long term, as you use them. Topics covered include:

  • Basic relational database concepts

  • Reporting and querying using SQL*Plus and iSQL*Plus

  • Creating and maintaining a database

  • Managing user access and security

  • Understanding Oracle database functions

  • Using multiple tables in a query

  • Restricting, sorting, and grouping data

  • Optimizing database performance

  • Creating backups

  • Troubleshooting database errors

Table of Contents

  1. Copyright
  2. Dedication
  3. Acknowledgments
  4. Introduction
  5. Relational Database Concepts
    1. Are Spreadsheets Like Databases?
    2. Relational Databases
    3. Object-Relational Databases
    4. Terms to Know
    5. Review Questions
  6. SQL*Plus and iSQL*Plus Basics
    1. Some SQL Formalities
    2. Tools for Running SQL
    3. The Ubiquitous SELECT Statement
    4. DML for Making Changes
    5. DDL for Handling Database Objects
    6. DCL for Handling Privileges
    7. Terms to Know
    8. Review Questions
  7. Oracle Database Functions
    1. Query Basics
    2. Built-In Single-Row Functions
    3. User-Defined Functions
    4. Terms to Know
    5. Review Questions
  8. Restricting, Sorting, and Grouping Data
    1. The WHERE Clause
    2. The ORDER BY Clause
    3. Group Functions and the GROUP BY Clause
    4. Terms to Know
    5. Review Questions
  9. Using Multiple Tables
    1. Join Syntax: Out with the Old and In with the New (SQL:1999)
    2. Equijoins
    3. Outer Joins
    4. Self-Joins
    5. Cartesian Products: The Black Sheep of the Family
    6. Terms to Know
    7. Review Questions
  10. Advanced SQL Queries
    1. Subqueries
    2. Set Operators
    3. ROLLUP and CUBE
    4. Terms to Know
    5. Review Questions
  11. Logical Consistency
    1. Constraints
    2. Transaction Processing
    3. Terms to Know
    4. Review Questions
  12. Installing Oracle and Creating a Database
    1. Oracle Components Overview
    2. Installing Oracle Software
    3. Creating an Oracle Database
    4. Terms to Know
    5. Review Questions
  13. Reporting Techniques
    1. iSQL*Plus Configuration
    2. Report Formatting
    3. Substitution Variables
    4. Saving and Running Scripts
    5. Terms to Know
    6. Review Questions
  14. Creating and Maintaining Database Objects
    1. Creating Tables
    2. Creating Indexes
    3. Creating and Using Views
    4. Creating Sequences and Synonyms
    5. Terms to Know
    6. Review Questions
  15. Users and Security
    1. Creating User Accounts
    2. Granting and Revoking Privileges
    3. Auditing
    4. Terms to Know
    5. Review Questions
  16. Making Things Run Fast (Enough)
    1. Oracle's Tuning Methodology
    2. Indexes
    3. Data Design Tuning
    4. SQL Application Tuning
    5. Memory Tuning
    6. Terms to Know
    7. Review Questions
  17. Saving Your Stuff (Backups)
    1. Database Failures
    2. User Backup and Recovery Methods
    3. DBA Backup and Recovery Methods
    4. Terms to Know
    5. Review Questions
  18. Troubleshooting
    1. The Alert Log File
    2. Event Notification
    3. System Trace Files
    4. User Trace Files
    5. Terms to Know
    6. Review Questions
  19. Answers to Review Questions
    1. Chapter 1
    2. Chapter 2
    3. Chapter 3
    4. Chapter 4
    5. Chapter 5
    6. Chapter 6
    7. Chapter 7
    8. Chapter 8
    9. Chapter 9
    10. Chapter 10
    11. Chapter 11
    12. Chapter 12
    13. Chapter 13
    14. Chapter 14
  20. Common Database Platforms
    1. Enterprise Databases
    2. Personal and Freeware Databases
  21. Glossary