SQL Queries for Mere Mortals, 4th Edition
A Hands-On Guide to Data Manipulation in SQL
Price | $18.13 - $35.81
|
Rating | |
Author | John L. Viescas |
Publisher | Addison-Wesley |
Published | 2018 |
Pages | 960 |
Language | English |
Format | Paper book / ebook (PDF) |
ISBN-10 | 0134858336 |
ISBN-13 | 9780134858333 |
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.
- John L. Viescas
4 5 298
Similar Books
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
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
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
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
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
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
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
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