The Complete Idiot's Guide to SQL

Everything you would want to know about SQL, ever

The Complete Idiot's Guide® to SQL provides a practical overview of the most common database management tasks for those who need to manage data in a database management system (DBMS). Structured Query Language is the worldwide standard programming language for managing data in a relational DBMS.

As more and more websites become dynamic in nature, driven by content derived by databases rather than static text and images, SQL is growing in popularity. This guide provides a practical overview of the most common database management tasks, including inserting, retrieving and sorting, filtering and updating data. You'll also learn how to manipulate, summarise and group it.

Unlike other books on the subject that focus on just one area of SQL, The Complete Idiot's Guide® to SQL provides the syntax for all of the major DBMSes, including MySQL, Oracle, Microsoft SQL, PostgreSQL, DB2, Macromedia ColdFusion, Microsoft Access, and Sybase.

The Complete Idiot's Guide® to SQL is a practical overview of the most common database management tasks for programmers new to SQL, accountants, students, and anyone who needs to manage data.