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

SQL Queries for Mere Mortals, 4th Edition
Price$24.02 - $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 117

Similar Books


Mastering SQL Queries for SAP Business One

Mastering SQL Queries for SAP Business One

Practical SAP query examples from an SAP Business One expert. Detailed steps to create and troubleshoot SQL queries for Alerts, Approvals, Formatted Searches, and Crystal Reports. Understand the importance and benefit of keeping SQL queries simple and easy to understand. Benefit from special tips and tricks related directly to SQL queries...
Pro SQL Database for Windows Azure, 2nd Edition

Pro SQL Database for Windows Azure, 2nd Edition

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...
Objective-C for Absolute Beginners, 4th Edition

Objective-C for Absolute Beginners, 4th Edition

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 ...
Beginning SQL Server for Developers, 4th Edition

Beginning SQL Server for Developers, 4th Edition

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...
Beginning SQL Queries, 2nd Edition

Beginning SQL Queries, 2nd Edition

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...
PHP and MySQL For Dummies, 4th Edition

PHP and MySQL For Dummies, 4th Edition

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...