A Guide to SQL

Front Cover
Cengage Learning, Oct 2, 2008 - Computers - 360 pages
2 Reviews
A GUIDE TO SQL, 8E, 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 students 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.
Important Notice: Media content referenced within the product description or the product text may not be available in the ebook version.
 

What people are saying - Write a review

User Review - Flag as inappropriate

gghhhhhhhhhhhhhhhhhhhhhh

User Review - Flag as inappropriate

It's amazing that my name is listed in the acknowledgements as someone who has reviewed the manuscript and made many helpful suggestions. I've never read this book, I don't know the authors and I've never been contacted by the publishers.

Contents

INTRODUCTION TO PREMIERE PRODUCTS HENRY BOOKS AND ALEXAMARA MARINA GROUP ...
1
DATABASE DESIGN FUNDAMENTALS
23
CREATING TABLES
61
SINGLETABLE QUERIES
97
MULTIPLETABLE QUERIES
135
UPDATING DATA
171
DATABASE ADMINISTRATION
195
SQL FUNCTIONS AND PROCEDURES
233
SQL REFERENCE
273
HOW DO I REFERENCE
289
ANSWERS TO ODDNUMBERED REVIEW QUESTIONS
293
INDEX
299
Copyright

Other editions - View all

Common terms and phrases

About the author (2008)

Philip J. Pratt is Professor Emeritus of Mathematics and Computer Science at Grand Valley State University, where he taught for 33 years. His teaching interests include database management, systems analysis, complex analysis, and discrete mathematics. He has authored more than 75 textbooks and has co-authored three levels of Microsoft Office Access 2013 books for this popular Shelly Cashman Series and A Guide to SQL.

Mary Z. Last has taught computer information systems since 1984. She retired from the University of Mary Hardin-Baylor, Belton, Texas, where she was an Associate Professor and the Director of the Center for Effectiveness in Learning and Teaching. Ms. Last is actively involved in the Computing Educator's Oral History Project that encourages young women to pursue careers in math and science. She has been a contributing author to the Shelly Cashman Series since 1992. She also authors many instructor resources for database texts.

Bibliographic information