Back to skip links

Purchase eTextbooks at the new VitalSource web site. Product options and pricing may differ. Shop Now

Additional product details

ISBN-10 0132653834ISBN-13 9780132653831
ISBN-10 0672335417ISBN-13 9780672335419
Author(s): Arie D. Jones, Ryan Stephens, Ron D. Plew
Publisher: Sams
Copyright year: © 2011 Pages: 504

Master all the fundamentals of modern SQL -- hands-on, step-by-step!

  • The up-to-the-minute SQL tutorial for everyone who wants to create applications, query data, or manage databases

  • Updated to cover the latest ANSI/ISO standards, plus powerful Oracle and SQL Server extensions

  • Covers everything from the basics through optimization, security, and enterprise techniques

  • Step-by-step instructions, examples, quizzes, exercises, and tips

  • In just 24 sessions of one hour or less, beginning-to-intermediate-level readers learn how to use SQL to build effective databases, efficiently retrieve data, and manage everything from performance to security! Using this book's straightforward, step-by-step approach, readers learn hands-on, through practical examples. The previous edition showed examples in MySQL; this edition adds coverage of Oracle and Microsoft SQL Server.

    One step at a time, readers discover how to define efficient database structures, objects, and tables; edit data and tables; manage transactions; write effective queries; categorize, summarize, sort, group, and restructure data; use joins and subqueries; manage databases, users, and security; use views, synonyms, and system catalogs; and extend SQL to the enterprise and Internet.