Introduction to Relational Databases and SQL Programming

Introduction to Relational Databases and SQL Programming




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.

Product Details

ISBN-13: 9780072229240
Publisher: McGraw-Hill Osborne
Publication date: 09/24/2003
Series: Concepts Series
Edition description: BK&CD-ROM
Pages: 416
Product dimensions: 8.32(w) x 10.74(h) x 0.77(d)

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.

McGraw-Hill authors represent the leading experts in their fields and are dedicated to improving the lives, careers, and interests of readers worldwide

Table of Contents

1: Introducing Relational Databases

2: Storing and Retrieving Data: The Basics

3: Performing Advanced Data Manipulation

4: Controlling SQL*Plus

5: Oracle SQL Built-in Functions

6: Indexes, Joins, and Subqueries

7: Creating a Program with PL/SQL

8: Reading a Data Model

9: Basics of Designing a Database’s Structure

10: Normalization

11: Analyzing Data Quality Issues

12: Other Useful Oracle Techniques

Appendix: On the CD-ROMs

Customer Reviews

Most Helpful Customer Reviews

See All Customer Reviews