tailieunhanh - SQL Queries for Mere Mortal

In the 20 years since the database language SQL was adopted as an international standard, and the 25 years since SQL database products appeared on the market, SQL has become the predominant language for storing, modifying, retrieving, and deleting data. Today, a significant portion of the world’s data—and the world’s economy—is tracked using SQL databases. | John L. Viescas Michael J. Hernandez Foreword by Keith w. Hare Convenor ihternational SỌL standards Committ SQL Queries for Mere Mortals Second Edition A Hands-On Guide to Data Manipulation in SQL Software-independent approach If you work with database software such as Access MS SOL Server Oracle DB2 MySQL Ingres or any other SQL-based program this book could save you hburs of time and aggravation before you write a single query Praise for SQL Queries for Mere Mortals Second Edition Unless you are working at a very advanced level this is the only SQL book you will ever need. The authors have taken the mystery out of complex queries and explained principles and techniques with such clarity that a Mere Mortal will indeed be empowered to perform the superhuman. Do not walk past this book Graham Mandeno Database Consultant I learned SQL primarily from the first edition of this book and I am pleased to see a second edition of this book so that others can continue to benefit from its organized presentation of the language. Starting from how to design your tables so that SQL can be effective a common problem for database beginners and then continuing through the various aspects of SQL construction and capabilities the reader can become a moderate expert upon completing the book and its samples. Learning how to convert a question in English into a meaningful SQL statement will greatly facilitate your mastery of the language. Numerous examples from real life will help you visualize how to use SQL to answer the questions about the data in your database. Just one of the watch out for this trap items will save you more than the cost of the book when you avoid that problem when writing your queries. I highly recommend this book if you want to tap the full potential of your database. Kenneth D. Snell . Database Designer Programmer I don t think they do this in public schools any more and it is a shame but do you remember in the seventh and eighth grades when you learned to .