Introduction to Relational Databases - Softcover

Christopher Allen; Catherine Creary; Simon Chatwin

Softcover

ISBN 10: 0072229241 ISBN 13: 9780072229240

Publisher: McGraw-Hill Osborne Media, 2003

Synopsis

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.

About this title

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

About the Author

Christopher Allen (Santa Monica, CA) has been a database professional for almost 20 ears. He is an OCP DBA and an OCP Application Developer and has worked on numerous Oracle Financials implementations. In addition, he has taught several hundred computer classes to adults, resulting in extensive experience communicating technical information in ways that are easy to absorb and easy to remember. His published works include the Oracle Certified Professional Application Developer Exam Guide (co-author, Oracle Press), Hard Disk Smarts (John Wiley Publishing), and four books on Lotus (Que). He also served as technical editor for Microsoft's DOS 5 and DOS 6 manuals. He is currently employed at Metier, an Oracle partner company that provides consulting services in the Los Angeles area.

Edition details

• Publisher: McGraw-Hill Osborne Media
• Publication date: 2003
• ISBN 10: 0072229241
• ISBN 13: 9780072229240
• Binding: Paperback
• Language: English
• Edition number: 1
• Number of pages: 416