Introduction to Relational Databases [ILLUSTRATED] (Paperback)

by Christopher Allen (Author), Catherine Creary (Author), Simon Chatwin (Author) "Stripped down to its most basic form, a database is a list of information, or a set of lists that work together..." (more)
Key Phrases: Clapham Specialty Store, Medium Wodget, Lab Project (more...)

Editorial Reviews

Product Description
This text provides hands-on instruction to relational database design and management using Oracle examples. The proven format features step-by-step tutorials, end-of-chapter reviews, practice questions, key term lists, and lab projects.

From the Back Cover
Essential IT Skills for On-the-Job Success

Learn to use a database to transform vast amounts of information into orderly, correlated data. Introduction to Relational Databases and SQL Programming introduces fundamental database concepts, then teaches you how to store, retrieve, and manipulate data and how to use SQL and PL/SQL. Using Oracle9i as an example, the book offers hands-on tutorials and exercises, including the Clapham Specialty Store case study, so you can apply your skills to real-world business scenarios. Inside this book, you will learn how to:

• Work with key database components--tables, rows, records, columns, and fields
• Store and retrieve data
• Perform advanced data manipulation
• Control SQL*Plus
• Apply Oracle SQL built-in functions
• Determine when to use an index
• Create PL/SQL programs
• Read data models
• Design a database structure
• Normalize your database and correct data anomalies
• Analyze data quality issues

Each chapter includes:

• Learning Objectives
• Many Figures and Illustrations
• Clapham Specialty Store Case
• Step-by-Step Tutorials
• Real-World Examples
• Cross Check Exercises
• Inside Information Sidebars
• Helpful Notes, Tips, and Warnings
• Chapter Summaries and Key Term Lists
• End-of-Chapter Quizzes and Lab Projects

CD-ROM includes trial version of Oracle 9i Standard Edition

See all Editorial Reviews

Product Details

• Paperback: 416 pages
• Publisher: McGraw-Hill Osborne Media; 1 edition (November 27, 2003)
• Language: English
• ISBN-10: 0072229241
• ISBN-13: 978-0072229240
• Product Dimensions: 10.7 x 8.4 x 0.8 inches
• Shipping Weight: 2 pounds (View shipping rates and policies)
• Average Customer Review: 5.0 out of 5 stars See all reviews (1 customer review)
• Amazon.com Sales Rank: #988,049 in Books (See Bestsellers in Books)

Customer Reviews

Most Helpful Customer Reviews

5.0 out of 5 stars Outstanding, December 28, 2003

By	Randy Halston (Chicago, IL) - See all my reviews

This is an excellent book. The explanations are clear, to the point, and illustrated by great examples. The only book I've ever seen that explains relational database design clearly AND shows how to implement it in Oracle. Outstanding! Best purchase I've made in a long time.