SQL Queries for Mere Mortals

The description below is the publishers own description.

Title: SQL Queries for Mere Mortals ISBN: 0201433362 Pub Date: August 2000 Pages: 528

Book Description

In the past few years, SQL has evolved from a language known only to computer specialists to a widely used, international standard of the computer industry. The number of SQL-compatible databases shipping each year 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 an essential reference guide for intermediate and advanced users.

The accompanying CD contains five sample databases used for the example queries throughout the book, plus an evaluation copy of Microsoft SQL Server version 7.

Table of Contents

Foreword.
Preface and Acknowledgments. 
About the Authors.
Introduction.

Are You a Mere Mortal? 
About This Book. 
How to Use This Book. 
Reading the Diagrams Used in This Book. 
Sample Databases Used in This Book. 
"Follow the Yellow Brick Road". 

I. RELATIONAL DATABASES AND SQL. 

1. What Is "Relational?" 
2. Ensuring Your Database Structure Is Sound. 
3. A Concise History of SQL. 

II. SQL BASICS. 

4. Creating a Simple Query. 
5. Getting More Than Simple Columns. 
6. Filtering Your Data. 

III. WORKING WITH MULTIPLE TABLES. 

7. Thinking in Sets. 
8. INNER JOINs. 
9. OUTER JOINs. 
10. UNIONs. 
11. Subqueries. 

IV. SUMMARIZING AND GROUPING DATA. 

12. Summarizing Data. 
13. Grouping Data. 
14. Filtering Grouped Data. 

APPENDICES. 

A. SQL Standard Diagrams. 
B. Schema for the Sample Databases. 
C. Recommended Reading References. 

Buy this book at Amazon USA

Buy this book at Amazon UK

Jump to: Top of Page or HOME or Printer friendly page

Search W3Schools:

What Others Say About Us

Does the world know about us? Check out these places:

Dogpile Alta Vista MSN Google Excite Lycos Yahoo Ask Jeeves

We Help You For Free. You Can Help Us!

• Tell your newsgroup or mailing list
• Link to us from your pages
• Help us correct errors and broken links
• Help us with spelling and grammar
• Validate the XHTML code of this page

W3Schools is for training only. We do not warrant its correctness or its fitness for use. The risk of using it remains entirely with the user. While using this site, you agree to have read and accepted our terms of use and privacy policy.

Copyright 1999-2002 by Refsnes Data. All Rights Reserved

How we converted to XHTML