SQL Query for Beginners: A Beginner's Guide to Data Processing with SQL Queries

Author: (USA) Michael J. Hernandez / (USA) John L. Viescas / 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 easily. However, most existing books on databases focus on database programming and development. Most programmers do not engage in database programming and 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 needs to the database and translating those needs into a language the database system uses (usually SQL). To successfully complete these two steps, one must not only have a certain foundation 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 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.
Author Bio: 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 multiple database associations and the author of Database Design for Mere Mortals. John L. Viescas is the CEO of Viescas Consulting and a respected database consulting provider. He is also the author of the best-selling book Running Microsoft Access 2000 and Programmer's Quick Reference Guide to SQL.