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
- Copyright
- Dedication
- Acknowledgments
- Introduction
- Relational Database Concepts
- SQL*Plus and iSQL*Plus Basics
- Oracle Database Functions
- Restricting, Sorting, and Grouping Data
- Using Multiple Tables
- Advanced SQL Queries
- Logical Consistency
- Installing Oracle and Creating a Database
- Reporting Techniques
- Creating and Maintaining Database Objects
- Users and Security
- Making Things Run Fast (Enough)
- Saving Your Stuff (Backups)
- Troubleshooting
- Answers to Review Questions
- Common Database Platforms
- Glossary
Product information
- Title: Oracle Database Foundations
- Author(s):
- Release date: October 2004
- Publisher(s): Sybex
- ISBN: 9780782143720
You might also like
book
Oracle RMAN Database Duplication
RMAN is Oracle’s flagship backup and recovery tool, but did you know it’s also an effective …
book
Oracle Database 12c Oracle RMAN Backup & Recovery
This authoritative Oracle Press resource on RMAN has been thoroughly revised to cover every new feature, …
book
Expert Oracle Database Architecture: Oracle Database 9
Now in its second edition, this best-selling book by Tom Kyte of Ask Tom fame continues …
book
Oracle Database 11g SQL
Write powerful SQL statements and PL/SQL programs Learn to access Oracle databases through SQL statements and …