SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL
The #1 Easy, Common-Sense Guide to SQL Queries€"Updated for Today€s Databases, Standards, and Challenges
Â
SQL Queries for Mere Mortals 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.
Â
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.
Â
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.
Â
Coverage includes
-- Getting started: understanding what relational databases are, and ensuring that your database structures are sound
-- SQL basics: using SELECT statements, creating expressions, sorting information with ORDER BY, and filtering data using WHERE
-- Summarizing and grouping data with GROUP BY and HAVING clauses
-- Drawing data from multiple tables: using INNER JOIN, OUTER JOIN, and UNION operators, and working with subqueries
-- 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
Â
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.
Â
informit.com/aw
forMereMortals.com