SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL

SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL

• Great product!

<P style="MARGIN: 0px">The #1 Easy, Common-Sense Guide to SQL Queries€"Updated for Today€s Databases, Standards, and Challenges</P> <P style="MARGIN: 0px"> </P> <P style="MARGIN: 0px"> <I>SQL Queries for Mere Mortals</I> <I></I> has earned worldwide praise as the clearest, simplest tutorial on writing effective SQL queries. The authors have updated this hands-on classic to reflect new SQL standards and database applications and teach valuable new techniques.</P> <P style="MARGIN: 0px"> </P> <P style="MARGIN: 0px">Step by step, John L. Viescas and Michael J. Hernandez guide you through creating reliable queries for virtually any modern SQL-based database. They demystify all aspects of SQL query writing, from simple data selection and filtering to joining multiple tables and modifying sets of data.</P> <P style="MARGIN: 0px"> </P> <P style="MARGIN: 0px">Three brand-new chapters teach you how to solve a wide range of challenging SQL problems. You€ll learn how to write queries that apply multiple complex conditions on one table, perform sophisticated logical evaluations, and think €œoutside the box€ using unlinked tables.</P> <P style="MARGIN: 0px"> </P> <P style="MARGIN: 0px">Coverage includes</P> <P style="MARGIN: 0px">-- Getting started: understanding what relational databases are, and ensuring that your database structures are sound</P> <P style="MARGIN: 0px">-- SQL basics: using SELECT statements, creating expressions, sorting information with ORDER BY, and filtering data using WHERE</P> <P style="MARGIN: 0px">-- Summarizing and grouping data with GROUP BY and HAVING clauses</P> <P style="MARGIN: 0px">-- Drawing data from multiple tables: using INNER JOIN, OUTER JOIN, and UNION operators, and working with subqueries</P> <P style="MARGIN: 0px">-- Modifying data sets with UPDATE, INSERT, and DELETE statements Advanced queries: complex NOT and AND, conditions, if-then-else using CASE, unlinked tables, driver tables, and more</P> <P style="MARGIN: 0px"> </P> <P style="MARGIN: 0px">Practice all you want with downloadable sample databases for today€s versions of Microsoft Office Access, Microsoft SQL Server, and the open source MySQL database. Whether you€re a DBA, developer, user, or student, there€s no better way to master SQL.</P> <P style="MARGIN: 0px"> </P> <P style="MARGIN: 0px">informit.com/aw</P> <P style="MARGIN: 0px">forMereMortals.com</P>