Table of content
|
Oracle9i DBA JumpStart Authors: Bryla B. Published year: 2006 Pages: 1/138 |
 |
- 1
- 2
- Table of Contents
- 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
- 1
- 2
|
Oracle9i DBA JumpStart Authors: Bryla B. Published year: 2006 Pages: 1/138 |
|