Home
Philosophy
The Books
Database Design
Microsoft Project
Project Management
SQL Queries
UML
User Interface Design
VSTO

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. This new edition of SQL Queries for Mere Mortals helps new users learn the foundations of SQL queries, and is 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.

 

You can find further information about this book on the informIT publisher site and can purchase this book from Amazon.

John L. Viescas is an independent consultant with over 40 years of industry experience. He began as a systems analyst, designing large database applications for IBM mainframe systems, and then spent six years at Applied Data Research, where he was responsible for research, product development, and customer support of database products for IBM mainframe computers. John later joined Tandem Computers, Inc. and was responsible for the development and implementation of their Western Sales region’s database marketing programs. His first book, A Quick Reference Guide to SQL, was a research project that documented the similarities in the syntax among ANSI-86 SQL, IBM's DB2, Microsoft's SQL Server, Oracle Corporation's Oracle, and Tandem's NonStop SQL. John now provides information systems management consulting for a variety of small to large businesses around the world, specializing in Microsoft Access and SQL Server database management products. He maintains offices in Nashua, New Hampshire, and Paris, France. Microsoft Product Support Services has recognized him as a "Most Valuable Professional" every year since 1993.