The Complete Idiot's Guide to SQL (Complete Idiot's Guides)

This beginner's guide to SQL provides detailed information on getting started performing common tasks with this relational database query language. Covering all major SQL-based distributions, including MySQL, Oracle, Microsoft SQL Server, and PostgreSQL, the work provides basic information on topics such as storing data, sorting and filtering, updating, using built-in functions, joining tables, aggregating and grouping data, and query variables. The work also covers advanced topics such as transactions, constraints and triggers, and account and database administration. Chapters include code examples, tips and tricks, and concise summaries. Holzner is the author of over one hundred computer related technical books. Annotation ©2012 Book News, Inc., Portland, OR (booknews.com)