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$18.13 - $35.81
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 298

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:  $22.49  |  Free ebook  |  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 Databa...

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

Core Java SE 9 for the Impatient, 2nd Edition

Core Java SE 9 for the Impatient, 2nd Edition

by Cay S. Horstmann

Modern Java introduces major enhancements that impact the core Java technologies and APIs at the heart of the Java platform. Many old Java idioms are no longer needed and new features such as modularization make you far more effective. However, navigating these changes can be challenging.Core Java SE 9 for the Impatient, Second Edition, i...

Price:  $40.48  |  Publisher:  Addison-Wesley  |  Release:  2017

Linux and Solaris Recipes for Oracle DBAs, 2nd Edition

Linux and Solaris Recipes for Oracle DBAs, 2nd Edition

by Darl Kuhn, Charles Kim, Bernard Lopuz

Linux and Solaris Recipes for Oracle DBAs, 2nd Edition is an example-based book on managing Oracle Database under Linux and Solaris. The book is written for database administrators who need to get work done and lack the luxury of curling up fireside with a stack of operating-system documentation. What this book provides instead is task-or...

Price:  $42.49  |  Publisher:  Apress  |  Release:  2015

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

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

SQL Pocket Guide, 4th Edition

SQL Pocket Guide, 4th Edition

by Alice Zhao

If you use SQL in your day-to-day work as a data analyst, data scientist, or data engineer, this popular pocket guide is your ideal on-the-job reference. You'll find many examples that address the language's complexities, along with key aspects of SQL used in Microsoft SQL Server, MySQL, Oracle Database, PostgreSQL, and SQLite.I...

Price:  $28.14  |  Publisher:  O'Reilly Media  |  Release:  2021

Database Systems, 4th Edition

Database Systems, 4th Edition

by Carolyn Begg, Thomas Connolly

This book places a strong emphasis on good design practice, allowing readers to master design methodology in an accessible, step-by-step fashion. In this book, database design methodology is explicitly divided into three phases: conceptual, logical, and physical. Each phase is described in a separate chapter with an example of the methodo...

Price:  $5.72  |  Publisher:  Addison-Wesley  |  Release:  2004

Linux All-in-One For Dummies, 4th Edition

Linux All-in-One For Dummies, 4th Edition

by Emmett Dulaney

Linux continues to grow in popularity worldwide as a low-cost, reliable operating system for enterprise use. Nine minibooks in this guide cover everything administrators need to know about the five leading versions: Ubuntu, Fedora Core, OpenSUSE, Mint, and Mandriva.The open source Linux operating system is gaining market share around the ...

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