Oracle9i DBA JumpStart / Bob Bryla.

Format:

Book

Author/Creator:

Bryla, Bob.

Language:

English

Subjects (All):

Relational databases.

Database management.

Oracle (Computer file).

Physical Description:

1 online resource (367 p.)

Edition:

1st ed.

Place of Publication:

San Francisco, Calif. ; London : SYBEX, 2003.

Language Note:

English

Summary:

Get Up to Speed for Oracle9i Administration Training Courses--Fast!Oracle9i DBA JumpStart gives you the solid grounding you need to approach Oracle certification with confidence:* Introduction to relational database concepts* Using basic SQL*Plus and iSQL*Plus commands* Understanding Oracle database functions* Using multiple tables* Restricting, sorting, and grouping data* Creating and maintaining a database* Using SQL*Plus reporting techniques* Creating and maintaining database objects* Setting up users and managing security* Configuring optimizatio

Contents:

Oracle9i DBA JumpStart; Acknowledgments; Contents; Introduction; What You Need; What This Book Covers; Understanding Oracle Certification; Making the Most of This Book; About the Author; Chapter 1: Relational Database Concepts; Are Spreadsheets Like Databases?; Relational Databases; Object-Relational Databases; Chapter 2: SQL*Plus and iSQL*Plus Basics; Some SQL Formalities; Tools for Running SQL; The Ubiquitous SELECT Statement; DML for Making Changes; DDL for Handling Database Objects; DCL for Handling Privileges; Chapter 3: Oracle Database Functions; Query Basics

Built-in Single-Row FunctionsUser-Defined Functions; Chapter 4: Restricting, Sorting, and Grouping Data; The WHERE Clause; The ORDER BY Clause; Group Functions and the GROUP BY Clause; Chapter 5: Using Multiple Tables; Join Syntax: Out with the Old and In with the New (SQL:1999); Equijoins; Non-equijoins; Outer Joins; Self-Joins; Cartesian Products: The Black Sheep of the Family; Chapter 6: Advanced SQL Queries; Subqueries; Set Operators; ROLLUP and CUBE; Chapter 7: Logical Consistency; Constraints; Transaction Processing; Chapter 8: Installing Oracle and Creating a Database

Oracle Components OverviewInstalling Oracle Software; Creating an Oracle Database; Chapter 9: Reporting Techniques; iSQL*Plus Configuration; Report Formatting; Substitution Variables; Saving and Running Scripts; Chapter 10: Creating and Maintaining Database Objects; Creating Tables; Creating Indexes; Creating and Using Views; Creating Sequences and Synonyms; Chapter 11: Users and Security; Creating User Accounts; Granting and Revoking Privileges; Auditing; Chapter 12: Making Things Run Fast (Enough); Oracle's Tuning Methodology; Indexes; Data Design Tuning; SQL Application Tuning

Memory TuningChapter 13: Saving Your Stuff (Backups); Database Failures; User Backup and Recovery Methods; DBA Backup and Recovery Methods; Chapter 14: Troubleshooting; The Alert Log File; OEM's Event Manager; System Trace Files; User Trace Files; Appendix A: Answers to Review Questions; Chapter 1; 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; Enterprise Databases; Personal and Freeware Databases; Index

Notes:

Includes index.

ISBN:

1-280-65241-1

9786610652419

0-585-48762-6

0-7821-5161-2

OCLC:

86174043