Cover image for A guide to SQL
Title:
A guide to SQL
Author:
Pratt, Philip J., 1945-
ISBN:
9780538747677

9780324597684
Personal Author:
Edition:
8th ed.
Publication Information:
Boston : Course Technology/Cengage Learning, ©2009.
Physical Description:
xvii, 309 pages : illustrations ; 24 cm
General Note:
Includes index.
Contents:
Introduction to Premier Products, Henry Books, and Alexamara Marina Group -- Database design fundamentals -- Creating tables -- Single-table queries -- Multiple-table queries -- Updating data -- Database administration -- SQL functions and procedures.
Abstract:
A Guide to SQL, 8th 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 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. - Publisher.
Added Author:
Copies: