Introduction to Relational Databases and SQL Programming

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: bull; bull;Work with key database components--tables, rows, records, columns, and fields bull;Store and retrieve data bull;Perform advanced data manipulation bull;Control SQL*Plus bull;Apply Oracle SQL built-in functions bull;Determine when to use an index bull;Create PL/SQL programs bull;Read data models bull;Design a database structure bull;Normalize your database and correct data anomalies bull;Analyze data quality issues Each chapter includes: bull; bull;Learning Objectives bull;Many Figures and Illustrations bull;Clapham Specialty Store Case bull;Step-by-Step Tutorials bull;Real-World Examples bull;Cross Check Exercises bull;Inside Information Sidebars bull;Helpful Notes, Tips, and Warnings bull;Chapter Summaries and Key Term Lists bull;End-of-Chapter Quizzes and Lab Projects CD-ROM includes trial version of Oracle 9i Standard EditionAllen, Christopher is the author of 'Introduction to Relational Databases and SQL Programming' with ISBN 9780072229240 and ISBN 0072229241.