The complete idiot's guide to SQL
By: by Steven Holzner
Publisher: Alpha
Published: 2011
Place of publication: New York
Language: eng
Number of pages: 282
ISBN-13: 9781615641093
Subjects: Relational databases; SQL (Computer program language)
Other titles: Complete idiot's guide to Structured Query Language; SQL; Structured Query Language
Description: This helpful guide give you practical information you can apply to your specific relational database management system.
Notes: "Provides the syntax for all of the DBMSes including MySQL, Oracle, Microsoft SQL Server, and PostgreSQL" -- Cover

Includes index.
Table of contents: title: Mastering the SQL basics. Getting into SQL ; Storing data in tables ; Retrieving your data; title: Crunching your data. Sorting your data ; Filtering your data ; Getting more filtering power ; Updating your data ; SQL's built-in functions; title: In-depth data handling. Joining tables ; Aggregating and grouping data ; Views, unions, and variables; title: Power techniques. Stored procedures and cursors ; Using transactions ; Understanding constraints and triggers ; Advanced SQL topics ; Creating and administering user accounts in SQL.