A Guide to SQL

Paperback
from $0.00

Author: Philip J. Pratt

ISBN-10: 0324597681

ISBN-13: 9780324597684

Category: Applications & Languages - Databases

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 learning the basics regardless of the database environment chosen, this edition features...

Search in google:

A GUIDE TO SQL, 8E, illustrates the basics of SQL programming using straightforward instruction and extensive hands-on exercises. Phil Pratt and Mary Last continue to present basic SQL commands in a business context using Oracle. A new running case, for a total of three, presents lessons in a real-world context for managing orders, parts, customers, and sales reps. The text provides hands-on projects at the end of each chapter, including review questions, running cases, and extensive exercises, providing students with the opportunity to solve problems and apply skills from each chapter.

Preface1Introduction to Database Management12An Introduction to SQL173Single-Table Queries434Multiple-Table Queries735Updating Data996Database Administration1177Reports1518Embedded SQL173ASQL Reference201B"How do I" Reference217C: Answers to Odd-Numbered Exercises221Index251