- Shopping Bag ( 0 items )
From Barnes & NobleThe Barnes & Noble Review
Whether you’re writing fancy new web database applications or simply need accurate (if boring) business reports, there’s no way around it: You need at least moderate fluency in SQL. Fortunately, SQL needn’t be intimidating. Mastering it doesn’t require you to spend a semester in a classroom -- not when there’s Sams Teach Yourself SQL in 24 Hours, Third Edition.
Ronald Plew and Ryan Stephens cover all the basics, starting with building databases that can be effectively queried, updated, and managed. They clearly introduce queries and the SELECT statement; then explain operators, aggregate functions, sorting, grouping, dates/times, joins, subqueries, and restructuring the appearance of your reported data.
You might be surprised just how far this book takes you. For example, in addition to a lesson on basic performance tuning, you’ll find individual lessons on using indexes, views, and the system catalog (a.k.a. data dictionary).
This edition reflects the current ANSI SQL 3 standard, includes improved examples and explanations, and provides hands-on exercises using the free, open source MySQL database wherever possible (i.e., everywhere MySQL is ANSI SQL compliant). Suddenly, it easy to practice even if you don’t happen to have Oracle 9i or SQL Server 2000 handy. Bill Camarda
Bill Camarda is a consultant, writer, and web/multimedia content developer. His 15 books include Special Edition Using Word 2000 and Upgrading & Fixing Networks For Dummies®, Second Edition.