Oracle Database Foundations: Technology Fundamentals for IT Success

The world of IT is always evolving, but in every area there are stable, coreconcepts that anyone just setting out needed to know last year, needs to knowthis year, and will still need to know next year. The purpose of theFoundations series is to identify these concepts and present them in a waythat gives you the strongest possible starting point, no matter what yourendeavor.
Oracle Database Foundations provides essentialknowledge about installing, configuring, maintaining, and querying Oracle9i and 10g databases. What you learn here will benefit you in theshort term, as you acquire and practice your skills, and in the long term, as youuse them. Topics covered include:
Basic relationaldatabase conceptsReporting and querying using SQL∗Plus andiSQL∗PlusCreating and maintaining a databaseManaging user access andsecurityUnderstanding Oracle database functionsUsing multiple tables ina queryRestricting, sorting, and grouping dataOptimizing databaseperformanceCreating backupsTroubleshooting database errors

Spis treści:

Introduction.
Chapter 1: Relational Database Concepts.
Chapter 2: SQL∗Plus and iSQL∗Plus Basics.
Chapter 3: Oracle Database Functions.
Chapter 4: Restricting, Sorting, and Grouping Data.
Chapter 5: Using Multiple Tables.
Chapter 6: Advanced SQL Queries.
Chapter 7: Logical Consistency.
Chapter 8: Installing Oracle and Creating a Database.
Chapter 9: Reporting Techniques.
Chapter 10: Creating and Maintaining Database Objects.
Chapter 11: Users and Security.
Chapter 12: Making Things Run Fast (Enough).
Chapter 13: Saving Your Stuff (Backups).
Chapter 14: Troubleshooting.
Appendix A Answers to Review Questions.
Appendix B Common Database Platforms.
Glossary.
Index.

Nota biograficzna:
Bob Bryla, OCP, has worked with Oracle databases for over 10 years. He currently works as an Oracle DBA and Analyst for Lands′ End in Dodgeville, Wisconsin.

Okładka tylna:
The world of IT is always evolving, but in every area there are stable, coreconcepts that anyone just setting out needed to know last year, needs to knowthis year, and will still need to know next year. The purpose of theFoundations series is to identify these concepts and present them in a waythat gives you the strongest possible starting point, no matter what yourendeavor.
Oracle Database Foundations provides essentialknowledge about installing, configuring, maintaining, and querying Oracle9i and 10g databases. What you learn here will benefit you in theshort term, as you acquire and practice your skills, and in the long term, as youuse them. Topics covered include:
Basic relationaldatabase conceptsReporting and querying using SQL∗Plus andiSQL∗PlusCreating and maintaining a databaseManaging user access andsecurityUnderstanding Oracle database functionsUsing multiple tables ina queryRestricting, sorting, and grouping dataOptimizing databaseperformanceCreating backupsTroubleshooting database errors