 |
SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL Second Edition
Be the First to Write a Review and tell the world about this title!People who purchase this book frequently purchase: - Pro C# 2008 and the .NET 3.5 Platform 4th Edition; Andrew Troelsen, $36.95, 38% Off!
- Core Java, Vol. I: Fundamentals, 8th Edition; Cay S. Horstmann, et al, $29.95, 46% Off!
- High Performance Web Sites; Steve Souders, $18.50, 38% Off!
- Head First SQL; Lynn Beighley, $28.50, 37% Off!
Books on similar topics, in best-seller order:Books from the same publisher, in best-seller order:
Over the last several decades, SQL has evolved from a language known only
to computer specialists to a widely used international standard of the computer
industry. The number of new applications deployed each year using SQL now
totals in the millions. If you are accessing corporate information from
the Internet or from an internal network, you are probably using SQL. SQL
Queries for Mere Mortals will help new users learn the foundations
of SQL queries, and will prove to be an essential reference guide for intermediate
and advanced users.
The accompanying CD contains five sample databases used for the example
queries throughout the book in four different formats: Microsoft SQL Server
2000 and later, Microsoft Access 2000 and later, MySQL version 5.0 and later,
and SQL scripts that can be used with most other implementations of the
language.
Table of Contents
Foreword by Keith W. Hare
Preface
About the Authors
Introduction
Part I: Relational Databases and SQL
Chapter 1: What Is Relational?
Chapter 2: Ensuring Your Database Structure Is Sound
Chapter 3: A Consise History of SQL
Part II: SQL Basics
Chapter 4: Creating a Simple Query
Chapter 5: Getting More Than Simple Columns
Chapter 6: Filtering Your Data
Part III: Working with Multiple Tables
Chapter 7: Thinking In Sets
Chapter 8: INNER JOINs
Chapter 9: OUTER JOINs
Chapter 10: UNIONs
Chapter 11: Subqueries
Part IV: Summarizing and Grouping Data
Chapter 12: Simple Totals
Chapter 13: Grouping Data
Chapter 14: Filtering Grouped Data
Part V: Modifying Sets of Data
Chapter 15: Updating Sets of Data
Chapter 16: Inserting Sets of Data
Chapter 17: Deleting Sets of Data
In Closing
Index
About the Authors
John L. Viescas is President of Viescas Consulting, Inc., a respected provider
of database consulting services. He is also the author of the best-selling Running
Microsoft Access 2000 and Programmer's Quick Reference Guide to SQL.
Michael J. Hernandez is a program manager for the Visual Studio .NET group
at Microsoft, and is a veteran relational database developer with more than
fourteen years of experience. He has been a premiere instructor with training
organizations such as AppDev Training Co., Focal Point, Inc., and Deep Training,
and was one of the first two hundred Microsoft-authorized .NET instructors.
He speaks regularly at conferences.
|
|
