Practical SQL, 2nd Edition
A Beginner's Guide to Storytelling with Data
| Price | $30.94 - $38.99
|
| Rating |  |
| Author | Anthony DeBarros |
| Publisher | No Starch Press |
| Published | 2022 |
| Pages | 392 |
| Language | English |
| Format | Paper book / ebook (PDF) |
| ISBN-10 | 1718501064 |
| ISBN-13 | 9781718501065 |
Practical SQL is an approachable and fast-paced guide to SQL (Structured Query Language), the standard programming language for defining, organizing, and exploring data in relational databases. Anthony DeBarros, a journalist and data analyst, focuses on using SQL to find the story within your data. The examples and code use the open-source database PostgreSQL and its companion pgAdmin interface, and the concepts you learn will apply to most database management systems, including MySQL, Oracle, SQLite, and others.
You'll first cover the fundamentals of databases and the SQL language, then build skills by analyzing data from real-world datasets such as US Census demographics, New York City taxi rides, and earthquakes from US Geological Survey. Each chapter includes exercises and examples that teach even those who have never programmed before all the tools necessary to build powerful databases and access information quickly and efficiently.
You'll learn how to: Create databases and related tables using your own data; Aggregate, sort, and filter data to find patterns; Use functions for basic math and advanced statistical operations; Identify errors in data and clean them up; Analyze spatial data with a geographic information system (PostGIS); Create advanced queries and automate tasks.
This updated second edition has been thoroughly revised to reflect the latest in SQL features, including additional advanced query techniques for wrangling data. This edition also has two new chapters: an expanded set of instructions on for setting up your system plus a chapter on using PostgreSQL with the popular JSON data interchange format.
Learning SQL doesn't have to be dry and complicated. Practical SQL delivers clear examples with an easy-to-follow approach to teach you the tools you need to build and manage your own databases.
Chapter 3:
→ https://itbook.store/files/9781718501065/chapter3.pdf
Source Code:
→ https://github.com/anthonydb/practical-sql-2/
- Anthony DeBarros (2 books)
5 5 173
Similar Books
Practical Data Science with R, 2nd Edition
by Nina Zumel, John Mount
Practical Data Science with R, Second Edition takes a practice-oriented approach to explaining basic principles in the ever expanding field of data science. You'll jump right to real-world use cases as you apply the R programming language and statistical analysis techniques to carefully explained examples based in marketing, business...
Price: $39.99 | Publisher: Manning | Release: 2019
by Chris Snyder, Thomas Myer, Michael Southwell
PHP security, just like PHP itself, has advanced. Updated for PHP 5.3, the 2nd edition of this authoritative PHP security book covers foundational PHP security topics like SQL injection, XSS, user authentication, and secure PHP development. Chris Snyder and Tom Myer also delve into recent developments like mobile security, the impact of J...
Price: $39.99 | Publisher: Apress | Release: 2010
Expert Oracle Application Express, 2nd Edition
by Doug Gault, Tom Petrus, Denes Kubicek, Dan McGhan, Francis Mignault, Roel Hartman, Raj Mattamal, Jorge Rimblas, Martin D'Souza, Christoph Ruepprich, Dimitri Gielis, Nick Buytaert, Karen Cannell, John Scott, Sharon Kennedy
Expert Oracle Application Express, 2nd Edition is newly updated for APEX 5.0 and brings deep insight from some of the best APEX practitioners in the field today. You'll learn about important features in APEX 5.0, and how those can be applied to make your development work easier and with greater impact on your business. Oracle Applica...
Price: $16.00 | Publisher: Apress | Release: 2015
Beginning Python Games Development, 2nd Edition
by Harrison Kinsley, Will McGugan
Learn how to create compelling games using Python and the PyGame games development library. Beginning Python Games Development, 2nd Edition will teach you how to create visuals, do event handling, create 3D games, add media elements, and integrate OpenGL into your Python game.In this update to the first ever book to cover the popular open...
Price: $39.49 | Publisher: Apress | Release: 2015
PostGIS in Action, 2nd Edition
by Regina O. Obe, Leo S. Hsu
Processing data tied to location and topology requires specialized know-how. PostGIS is a free spatial database extender for PostgreSQL, every bit as good as proprietary software. With it, you can easily create location-aware queries in just a few lines of SQL code and build the back end for a mapping, raster analysis, or routing applicat...
Price: $4.40 | Publisher: Manning | Release: 2015
Node.js in Action, 2nd Edition 
by Alex Young, Bradley Meck, Mike Cantelon, Tim Oxley, Marc Harter, T.J. Holowaychuk, Nathan Rajlich
You already know JavaScript. The trick to mastering Node.js is learning how to build applications that fully exploit its powerful asynchronous event handling and non-blocking I/O features. The Node server radically simplifies event-driven real-time apps like chat, games, and live data analytics, and with its incredibly rich ecosystem of m...
Price: $25.18 | Publisher: Manning | Release: 2017
Getting MEAN with Mongo, Express, Angular, and Node, 2nd Edition
by Simon Holmes, Clive Harber
Getting MEAN, Second Edition teaches you how to develop full-stack web applications using the MEAN stack. This edition was completely revised and updated to cover MongoDB 4, Express 4, Angular 7, Node 11, and the latest mainstream release of JavaScript ES2015.Juggling languages mid-application can radically slow down a full-stack web proj...
Price: $38.99 | Publisher: Manning | Release: 2019
Docker in Practice, 2nd Edition
by Ian Miell, Aidan Hobson Sayers
Docker in Practice, 2ond Edition presents over 100 practical techniques, hand-picked to help you get the most out of Docker. Following a Problem/Solution/Discussion format, you'll walk through specific examples that you can use immediately, and you'll get expert guidance on techniques that you can apply to a whole range of scena...
Price: $46.45 | Publisher: Manning | Release: 2019