Oracle9i DBA JumpStart
- Table of Contents
- BackCover
- Oracle9i DBA JumpStart
- Introduction
- What This Book Covers
- Understanding Oracle Certification
- Making the Most of This Book
- About the Author
- Chapter 1: Relational Database Concepts
- Relational Databases
- Object-Relational Databases
- Review Questions
- Terms to Know
- Chapter 2: SQLPlus and iSQLPlus Basics
- Tools for Running SQL
- The Ubiquitous SELECT Statement
- DML for Making Changes
- DDL for Handling Database Objects
- DCL for Handling Privileges
- Review Questions
- Terms to Know
- Chapter 3: Oracle Database Functions
- Built-in Single-Row Functions
- User-Defined Functions
- Review Questions
- Terms to Know
- Chapter 4: Restricting, Sorting, and Grouping Data
- The ORDER BY Clause
- Group Functions and the GROUP BY Clause
- Review Questions
- Terms to Know
- Chapter 5: Using Multiple Tables
- Equijoins
- Non-equijoins
- Outer Joins
- Self-Joins
- Cartesian Products: The Black Sheep of the Family
- Review Questions
- Terms to Know
- Chapter 6: Advanced SQL Queries
- Set Operators
- ROLLUP and CUBE
- Review Questions
- Terms to Know
- Chapter 7: Logical Consistency
- Transaction Processing
- Review Questions
- Terms to Know
- Chapter 8: Installing Oracle and Creating a Database
- Oracle Components Overview
- Installing Oracle Software
- Creating an Oracle Database
- Review Questions
- Terms to Know
- Chapter 9: Reporting Techniques
- iSQLPlus Configuration
- Report Formatting
- Substitution Variables
- Saving and Running Scripts
- Review Questions
- Terms to Know
- Chapter 10: Creating and Maintaining Database Objects
- Creating Tables
- Creating Indexes
- Creating and Using Views
- Creating Sequences and Synonyms
- Review Questions
- Terms to Know
- Chapter 11: Users and Security
- Granting and Revoking Privileges
- Auditing
- Review Questions
- Terms to Know
- Chapter 12: Making Things Run Fast (Enough)
- Indexes
- Data Design Tuning
- SQL Application Tuning
- Memory Tuning
- Review Questions
- Terms to Know
- Chapter 13: Saving Your Stuff (Backups)
- Database Failures
- User Backup and Recovery Methods
- DBA Backup and Recovery Methods
- Review Questions
- Terms to Know
- Chapter 14: Troubleshooting
- The Alert Log File
- OEM s Event Manager
- System Trace Files
- User Trace Files
- Review Questions
- Terms to Know
- Appendix A: Answers to Review Questions
- Chapter 2
- Chapter 3
- Chapter 4
- Chapter 5
- Chapter 6
- Chapter 7
- Chapter 8
- Chapter 9
- Chapter 10
- Chapter 11
- Chapter 12
- Chapter 13
- Chapter 14
- Appendix B: Glossary
- Appendix C: Common Database Platforms
- Personal and Freeware Databases
- Index
- Index_A
- Index_B
- Index_C
- Index_D
- Index_E
- Index_F
- Index_G
- Index_H
- Index_I
- Index_J
- Index_K
- Index_L
- Index_M
- Index_N
- Index_O
- Index_P
- Index_Q
- Index_R
- Index_S
- Index_T
- Index_U
- Index_V
- Index_W
- Where Can I Find?
- List of Tables
- List of Sidebars