Back to skip links

Additional product details

eText: 
ISBN-13 9780132653831ISBN-10 0132653834
Print: 
ISBN-10 0-672-33541-7ISBN-13 978-0-672-33541-9
Author(s): Arie D. Jones, Ryan Stephens, Ron D. Plew
Publisher: Sams
Copyright year: © 2011 Pages: 504
Description

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.

    Three Ways to Study
    with eTextbooks!

    • Read online from your computer or mobile device.
    • Read offline on select browsers and devices when the internet won't be available.
    • Print pages to fit your needs.

    CourseSmart eTextbooks let you study the best way – your way.