A Guide to SQL 8th Edition International Student Edition

Description

A GUIDE TO SQL, 8E, International Edition continues to be the essential SQL reference. It builds on the success of previous editions by presenting basic SQL commands in the context of a running case in which a business uses SQL to manage orders, parts, customers, and sales reps. The book covers the fundamentals of SQL programming using straightforward instruction and extensive hands-on exercises. Continuing with its focus on learning the basics regardless of the database environment chosen, this edition features examples from the latest databases: Oracle 11g, Access 2007, and MySQL. The eighth edition expands on the use of running case studies by adding a third running case to the extensive hands-on pedagogy at the end of every chapter.

CONTENTS:

1. An Introduction to Premiere Products, Henry Books, and Alexamara Marina Group.

2. Database Design Fundamentals.

3. An Introduction to SQL.

4. Single-Table Queries.

5. Multiple-Table Queries.

6. Updating Data.

7. Database Administration.

8. SQL Functions and Procedures.

Appendix A: SQL Reference.

Appendix B: "How do I" Reference.

Appendix C: Answers to Odd-Numbered Review Questions.