SQL Queries for Mere Mortals, 4th Edition

A Hands-On Guide to Data Manipulation in SQL



Bookstore > Books > SQL Queries for Mere Mortals, 4th Edition

Price$22.30 - $42.49
Rating
AuthorJohn L. Viescas
PublisherAddison-Wesley
Published2018
Pages960
LanguageEnglish
FormatPaper book / ebook (PDF)
ISBN-100134858336
ISBN-139780134858333
EBook Hardcover Paperback

SQL Queries for Mere Mortals has earned worldwide praise as the clearest, simplest tutorial on writing effective queries with the latest SQL standards and database applications. Now, author John L. Viescas has updated this hands-on classic with even more advanced and valuable techniques.

Step by step, Viescas guides you through creating reliable queries for virtually any current SQL-based database. He demystifies all aspects of SQL query writing, from simple data selection and filtering to joining multiple tables and modifying sets of data.

Building on the basics, Viescas shows how to solve challenging real-world problems, including applying multiple complex conditions on one table, performing sophisticated logical evaluations, and using unlinked tables to think "outside the box".

In two brand-new chapters, you learn how to perform complex calculations on groups for sophisticated reporting, and how to partition data into windows for more flexible aggregation.

Practice all you want with downloadable sample databases for today's versions of Microsoft Office Access, Microsoft SQL Server, and the open source MySQL and PostgreSQL databases. Whether you're a DBA, developer, user, or student, there's no better way to master SQL.





4 5 123

Similar Books


Mastering SQL Queries for SAP Business One

Mastering SQL Queries for SAP Business One

by Gordon Du

SAP Business One is an integrated Enterprise Resource Planning (ERP) software which offers an ideal solution for growing small to midsized businesses. For such companies, retrieving the most relevant information from their business data can be key to standing out from the competition. SAP Business One is a rapidly growing software package...

Price:  $30.00  |  Publisher:  Packt Publishing  |  Release:  2011

Pro SQL Database for Windows Azure, 2nd Edition

Pro SQL Database for Windows Azure, 2nd Edition

by Scott Klein, Herve Roggero

Pro SQL Database for Windows Azure, 2nd Edition shows how to create enterprise-level database deployments without the usual investment in datacenter and other infrastructure. Take advantage instead of Microsoft's worldwide backbone for cloud computing that delivers all the power of SQL Server in the form of the cloud-based SQL Database fo...

Price:  $49.99  |  Publisher:  Apress  |  Release:  2012

Objective-C for Absolute Beginners, 4th Edition

Objective-C for Absolute Beginners, 4th Edition

by Stefan Kaczmarek, Brad Lees, Gary Bennett, Mitch Fisher

Learn Objective-C and its latest release, and learn how to mix Swift with it. You have a great idea for an app, but how do you bring it to fruition? With Objective-C, the universal language of iPhone, iPad, and Mac apps. Using a hands-on approach, you'll learn how to think in programming terms, how to use Objective-C to construct program ...

Price:  $34.99  |  Publisher:  Apress  |  Release:  2018

Beginning SQL Server for Developers, 4th Edition

Beginning SQL Server for Developers, 4th Edition

by Robin Dewson

Beginning SQL Server for Developers is the perfect book for developers new to SQL Server and planning to create and deploy applications against Microsoft's market-leading database system for the Windows platform. Now in its fourth edition, the book is enhanced to cover the very latest developments in SQL Server, including the in-memory fe...

Price:  $36.98  |  Publisher:  Apress  |  Release:  2014

Beginning SQL Queries, 2nd Edition

Beginning SQL Queries, 2nd Edition

by Clare Churcher

Get started on mastering the one language binding the entire database industry. That language is SQL, and how it works is must-have knowledge for anyone involved with relational databases, and surprisingly also for anyone involved with NoSQL databases. SQL is universally used in querying and reporting on large data sets in order to genera...

Price:  $21.45  |  Publisher:  Apress  |  Release:  2016

PHP and MySQL For Dummies, 4th Edition

PHP and MySQL For Dummies, 4th Edition

by Janet Valade

To be on the cutting edge, Web sites need to serve up HTML, CSS, and products specific to the needs of different customers using different browsers. An effective e-commerce site gathers information about users and provides information they need to get the desired result.PHP scripting language with a MySQL back-end database offers an effec...

Price:  $14.47  |  Publisher:  Wiley  |  Release:  2009

Building a Web Site For Dummies, 4th Edition

Building a Web Site For Dummies, 4th Edition

by David A. Crowder

An effective Web site is the key to success for every venture from class reunions to major corporations. And since Web technology changes rapidly, Building a Web Site For Dummies, 4th Edition is fully updated for the cutting-edge tools and trends.If you need to build and maintain a Web site, even if your experience is severely limited, th...

Price:  $15.39  |  Publisher:  Wiley  |  Release:  2010

Hacking For Dummies, 4th Edition

Hacking For Dummies, 4th Edition

by Kevin Beaver

The best way to stay safe online is to stop hackers before they attack - first, by understanding their thinking and second, by ethically hacking your own site to measure the effectiveness of your security. This practical, top-selling guide will help you do both. Fully updated for Windows 8 and the latest version of Linux, Hacking For Dumm...

Price:  $4.22  |  Publisher:  Wiley  |  Release:  2013