“Given the authors’ reputations, I expected to be impressed. I was blown away! . . . Most SQL books sit on my shelf. This one will live on my desk.” –Roger Carlson, Microsoft Access MVP (2006-2015) “Rather than stumble around reinventing wheels or catching glimpses of the proper approaches, do yourself a favor: Buy this book.” —Dave Stokes, MySQL Community Manager, Oracle Corporation Effective SQL brings together practical solutions and insights so you can solve complex problems with SQL and design databases that simplify data management in the future. It’s the only modern book that brings together advanced best practices and realistic example code for all of these versions of SQL: IBM DB2, Microsoft Access, Microsoft SQL Server, MySQL, Oracle Database, and PostgreSQL. Drawing on their immense experience as world-class database consultants and instructors, the authors identify 61 proven approaches to writing better SQL. Wherever SQL versions vary, the authors illuminate the key nuances, so you can get the most out of whatever version you prefer. This full-color guide provides clear, practical explanations; expert tips; and plenty of usable code. Going far beyond mere syntax, it addresses issues ranging from optimizing database designs to managing hierarchies and metadata. If you already know SQL’s basics, this guide will help you become a world-class SQL problem-solver. 
<ul>
<li>Craft better logical data models, and fix flawed models</li> <li>Implement indexes that improve query performance</li> <li>Handle external data from sources you don’t control</li> <li>Extract and aggregate the information you need, as efficiently as possible</li> <li>Write more flexible subqueries</li> <li>Analyze and retrieve metadata using your database platform of choice</li> <li>Use Cartesian Products and Tally Tables to solve problems you can’t address with conventional JOINs</li> <li>Model hierarchical data: managing SQL’s tradeoffs and shortcomings</li> </ul>

Effective SQL: 61 Specific Ways to Write Better SQL (Effective Software Development Series)

Computers & Technology

Viescas, John

Clothier, Ben

Steele, Douglas

Programming Languages

Addison-Wesley Professional

The #1 Easy, Common-Sense Guide to SQL Queries—Updated with More Advanced Techniques and Solutions Foreword by Keith W. Hare, Vice Chair, USA SQL Standards Committee SQL Queries for Mere Mortals has earned worldwide praise as the clearest, simplest tutorial on writing effective queries with the latest SQL standards and database applications. Now, author John L. Viescas has updated this hands-on classic with even more advanced and valuable techniques. Step by step, Viescas guides you through creating reliable queries for virtually any current SQL-based database. He demystifies all aspects of SQL query writing, from simple data selection and filtering to joining multiple tables and modifying sets of data. Building on the basics, Viescas shows how to solve challenging real-world problems, including applying multiple complex conditions on one table, performing sophisticated logical evaluations, and using unlinked tables to think “outside the box.” In two brand-new chapters, you learn how to perform complex calculations on groups for sophisticated reporting, and how to partition data into windows for more flexible aggregation. Practice all you want with downloadable sample databases for today’s versions of Microsoft Office Access, Microsoft SQL Server, and the open source MySQL and PostgreSQL databases. Whether you’re a DBA, developer, user, or student, there’s no better way to master SQL. Coverage includes: <ul>
<li>Getting started: understanding what relational databases are, and ensuring that your database structures are sound</li> <li>SQL basics: using SELECT statements, creating expressions, sorting information with ORDER BY, and filtering data using WHERE</li> <li>Summarizing and grouping data with GROUP BY and HAVING clauses</li> <li>Drawing data from multiple tables: using INNER JOIN, OUTER JOIN, and UNION operators, and working with subqueries</li> <li>Modifying data sets with UPDATE, INSERT, and DELETE statements</li> <li>Advanced queries: complex NOT and AND, conditions, if-then-else using CASE, unlinked tables, driver tables, and more</li> <li>NEW! Using advanced GROUP BY keywords to create subtotals, roll-ups, and more</li> <li>NEW! Applying window functions to answer more sophisticated questions, and gain deeper insight into your data</li> </ul>
Software-Independent Approach! If you work with database software such as Access, MS SQL Server, Oracle, DB2, MySQL, Ingres, or any other SQL-based program, this book could save you hours of time and aggravation—before you write a single query!

SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL

Programming

Two programming products are included in this set: ""Running Microsoft Access 2000, "" which takes readers through the most used tasks and functions, and ""The Mastering Database Fundamentals Using Access 2000, "" which teaches the desktop application skills. Users can deploy these products in tandem or individually to learn how to maximize productivity with this popular relational database. Interactive CD-ROM included.

Running Microsoft Access 2000 (Training Kit)

Microsoft, Corporation

Certification

Microsoft Press

You’re beyond the basics, so dive right in and really put your database skills to work! This supremely organized reference is packed with hundreds of timesaving solutions, troubleshooting tips, and workarounds. It’s all muscle and no fluff. Discover how the experts tackle Access 2007—and challenge yourself to new levels of mastery! 
<ul>
<li>Create tables that support your database design strategy </li>
<li>Import and link to data from spreadsheets, text files, databases, and other ODBC data sources </li>
<li>Build simple to complex queries to manipulate data </li>
<li>Learn advanced techniques for building and customizing user interface forms </li>
<li>Design attractive reports to calculate and analyze large sets of data </li>
<li>Automate your application with Microsoft Visual Basic(R) for Applications </li>
<li>Customize the Office Fluent Ribbon </li>
<li>Explore using XML and Windows(R) SharePoint(R) Services to create Web-based applications </li>
</ul>
 CD includes: <ul>
<li>Fully searchable eBook—plus bonus chapters </li>
<li>Sample database applications—including query, form, and report examples </li>
<li>Articles from the experts: designing databases, understanding SQL, exporting data, and more </li>
<li>Links to demos, blogs, and user communities </li>
<li>References for finding Access 2003 commands in Access 2007 </li>
<li>Windows Vista(R) Product Guide eReference and other eBooks </li>
</ul>
 For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.

Microsoft Office Access 2007 Inside Out

CONRAD, JEFF

Computer Science

You're beyond the basics, so dive right in and really put your database skills to work! This supremely organized reference is packed with hundreds of timesaving solutions, troubleshooting tips, and workarounds. It's all muscle and no fluff. Discover how the experts tackle Access 2010 -- and challenge yourself to new levels of mastery! 
<ul>
<li>Master essential data management and design techniques </li>
<li>Import and link to data from spreadsheets, databases, text files, and other sources </li>
<li>Use action queries to quickly insert, update, or delete entire sets of data </li>
<li>Create custom forms to capture and display data </li>
<li>Design reports to calculate, summarize, and highlight critical data--and learn advanced techniques </li>
<li>Automate your application with macros and Visual Basic for Applications (VBA) </li>
<li>Use Access Services to extend your database application to the Web </li>
<li>Try out the sample client and web database applications in both 32-bit and 64-bit versions </li>
</ul> A Note Regarding the CD or DVD The print version of this book ships with a CD or DVD. The sample client and web database applications are provided in both 32-bit and 64-bit versions. Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.

Microsoft Access 2010 Inside Out

Explains how to use the features of the SQL relational data base language and lists each command and function

Quick Reference Guide to SQL

Presents and examines--for beginning and intermediate database users--scenarios for setting up databases and assessing and analyzing data in a Windows environment. Original.

Running Microsoft Access

Reference

Foreign Language Study & Reference

The complete reference—made by Microsoft—to help you be more productive with this bestselling relational database. This authoritative handbook has the answers you need for learning how to use Access 2000 for everything from personal desktop applications and workgroup systems to scalable back-end enterprise databases. Comprehensive <ul>
<li>Take advantage of enhanced integration with the Web for seamless data-sharing across platforms and user levels</li> <li>Publish live data to the Web with new data access pages</li> <li>Use the built-in programming language, Microsoft Visual Basic for Applications, to automate tasks, customize menus and toolbars, connect applications to the Internet, and more</li> <li>Gain insight into using Microsoft Access 2000 as a component within Microsoft Office 2000</li> <li>Easy Access to Information</li> <li>“Chapters at a Glance” for quick reference</li> <li>Master table of contents</li> <li>Extensive cross-referenced index</li> <li>Two-color interior for easier navigation</li> <li>Everything Is Clear</li> <li>Step-by-step instructions</li> <li> Hundreds of screen illustrations</li> <li>Real-world examples</li> <li>Tips and advice from the experts</li> </ul>
The CD contains all sample databases from the book, which you can study and reuse. For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.

Running Microsoft® Access 2000

Software

See the best price to sell, buy, or rent books by Viescas, John. BookScouter helps to compare book prices from 25+ online bookstores and 30+ buyback vendors with a single search.

Books by Viescas, John