SQL Queries for Mere Mortals

By John Viescas & Michael J. Hernandez


SQL Queries for Mere Mortals - John Viescas & Michael J. Hernandez

Primary: SQL Queries for Mere Mortals.pdf - 34,859 KB/Sec

Mirror [#1]: SQL Queries for Mere Mortals.pdf - 33,816 KB/Sec

Mirror [#2]: SQL Queries for Mere Mortals.pdf - 27,649 KB/Sec

More by John Viescas & Michael J. Hernandez : SQL Queries for Mere Mortals


Related Books

This is the Rough Cut version of the printed book.

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


Search
Recent Posts
Microsoft Office Access 2007 All-in-One Desk Reference For Dummies
Starting Database Administration: Oracle DBA
Database MS Access 2016 Level 1
SQL QuickStart Guide
Beginning Database Design
MySQL 5 Essentials
SQL All-in-One For Dummies
Data Science and Analytics with Python
Take Control of Getting Started with DEVONthink 2, Third Edition
DAX Patterns 2015
Statistics for Big Data For Dummies
Access 2010 All-in-One For Dummies
Blockchain For Dummies
Microsoft Access 2010 In Depth
Access 2013 All-in-One For Dummies
FileMaker Pro Design and Scripting For Dummies
FileMaker 12 In Depth, 2/e
Oracle 11g For Dummies
FileMaker 12 Developers Reference: Functions, Scripts, Commands, and Grammars
SQL in 30 Pages
Access 2010 Bible
Microsoft SQL Server 2008 All-in-One Desk Reference For Dummies
The Data Warehouse Toolkit
Learning SQL
Crystal Reports 10 For Dummies
The Definitive Guide to DAX
Teradata 14 Certification Study Guide - Basics
Sams Teach Yourself Microsoft SQL Server T-SQL in 10 Minutes
FileMaker & You
Using Microsoft Access 2010, Enhanced Edition
The Data Warehouse Lifecycle Toolkit
Developing Analytic Talent
Crystal Reports 2008 For Dummies
High Performance MySQL
Microsoft® Access® 2013 Step by Step
Access 2013 For Dummies
Learning MySQL
R for Everyone
Beginning Database Design Solutions
Agile Analytics: A Value-Driven Approach to Business Intelligence and Data Warehousing
Professional Microsoft SQL Server 2014 Integration Services
Oracle SQL By Example, 4/e
The Power of People
Databases Demystified, 2nd Edition
Blockchain Basics
The Data Warehouse ETL Toolkit
The Microsoft Data Warehouse Toolkit
Fundamentals of Deep Learning
SQL Queries for Mere Mortals
Microsoft Office Access 2007 Forms, Reports, and Queries
Teach Yourself VISUALLY Access 2013
Data Mining
Marketing Analytics
Delivering Business Intelligence with Microsoft SQL Server 2016, Fourth Edition
Database MS Access 2016 Level 2
Beginning Microsoft SQL Server 2012 Programming
FileMaker Pro 13 Absolute Beginner's Guide
Access 2013 Absolute Beginner's Guide
Practical PostgreSQL
Microsoft Access 2013 Plain & Simple
The Data Model Resource Book
SysML Distilled
Data Mining For Dummies
Microsoft SQL Server 2016: A Beginner's Guide, Sixth Edition
Microsoft® SQL Server® 2012 T-SQL Fundamentals
Confident Data Skills
MASTER DATA MANAGEMENT AND DATA GOVERNANCE, 2/E
RabbitMQ in Action
아마존 웹 서비스를 다루는 기술
Database Design for Mere Mortals®: A Hands-On Guide to Relational Database Design, 2/e
Crystal Reports XI Official Guide
Data Warehousing For Dummies
Professional Microsoft SQL Server 2014 Administration
Microsoft® Access® 2013 Inside Out
Professional Microsoft SQL Server 2012 Integration Services
Mastering PostgreSQL 10
Big Data MBA
Mastering Blockchain
가장 빨리 만나는 Docker
Professional Microsoft SQL Server 2012 Reporting Services
Applied Predictive Analytics
Microsoft® Access® 2010 VBA Programming Inside Out
Super Charge Power BI
SharePoint 2010 Issue Tracking System Design, Create, and Manage
Oracle Database 11g & MySQL 5.6 Developer Handbook
Big Data, Data Mining, and Machine Learning
Database Design and Relational Theory
Building Blockchain Projects
Tableau 9: The Official Guide (Enhanced Edition)
T-SQL Querying
Microsoft SQL Server 2014 Business Intelligence Development Beginner’s Guide
Rapid Development
Oracle Database 11g A Beginner's Guide
Microsoft SQL Server 2012 Unleashed
Scientific Database And Programming Examples Using Php,mysql,xml,matlab,python,perl
Web Publishing with PHP and FileMaker 9
Data Mining and Statistics for Decision Making
R for Everyone: Advanced Analytics and Graphics, 2/e
Oracle PL/SQL in 10 Minutes, Sams Teach Yourself
Modeling Techniques in Predictive Analytics with Python and R