SQL Query for Beginners -- A Practical Guide to Data Processing with SQL Queries

Author: (USA) Michael J. Hernandez, (USA) John L. Viescas, translated by Wang Xiaoyan
Publisher:
Publish Date: 2005-08-01
Features: With the development of network technology, the application of databases is becoming increasingly widespread, such as in e-government and online shopping systems. More and more people need to know how to query information from databases smoothly and conveniently. However, most existing books on databases focus on database programming and development. Most programmers do not engage in database programming or development but rather in SQL queries and retrieval. This book explains how to effectively retrieve information from databases from the perspective of a "simple user." Database query and retrieval is a complex process, with the key steps being: clearly stating the requirements to the database and translating those requirements into a language the database system uses (usually SQL). To successfully complete these two steps, one must not only have a certain level of foundational knowledge but also master the adjustment and simplification of statements. This book specifically introduces both of these aspects, effectively helping database users improve their work efficiency and professional skills. The book is divided into four parts: the first part covers the brief history of database development and SQL; the remaining three parts discuss basic query statement syntax, basic SQL statement construction, retrieving information from multiple tables, how to use joins, the use of subqueries, data summarization, and the application of functions. The book includes numerous examples to help readers better understand and master SQL query knowledge.
About the Authors: Michael J. Hernandez is a well-known relational database consultant and the owner of DataTex Consulting Group in Seattle. He is also a key speaker in several database associations and the author of Database Design for Mere Mortals. John L. Viescas is the managing director of Viescas Consulting and a respected database consulting service provider. He is also the author of the best-selling book Running Microsoft Access 2000 and Programmer's Quick Reference Guide to SQL.