A Guide to SQL, Ninth Edition

Description

A GUIDE TO SQL, Ninth Edition, provides an effective introduction to SQL programming using straightforward instruction, extensive hands-on exercises, and a strong foundation in real-world business applications. The Ninth Edition builds on the longstanding success of this proven text by presenting basic SQL commands in the context of a running case, in which a business uses SQL to manage orders, items, customers, and sales reps. The authors emphasize that fundamental principles and practices apply regardless of the database environment chosen, and they include examples from the latest versions of Oracle and Microsoft Access, and SQL Server throughout the text. Cover Table of Contents Preface Chapter 1 - Introduction Ch 1 - Summary Ch 1 - Exercises Chapter 2 - Database Design Fundamentals Ch 2 - Summary Ch 2 - Exercises Chapter 3 - Creating Tables Ch 3 - Summary Ch 3 - Exercises Chapter 4 - Single-Table Queries Ch 4 - Summary Ch 4 - Exercises Chapter 5 - Multiple-Table Queries Ch 5 - Summary Ch 5 - Exercises Chapter 6 - Updating Data Ch 6 - Summary Ch 6 - Exercises Chapter 7 - Database Administration Ch 7 - Summary Ch 7 - Exercises Chapter 8 - SQL Functions and Procedures Ch 8 - Summary Ch 8 - Exercises Appendix A - SQL Reference Appendix B - How Do I Reference Appendix C - Answers to Odd-Numbered Review Questions Index