Description:
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.