Shop Biotyspa
Buy New
To see product details, add this item to your cart.
Ships from: Amazon.com
Sold by: Amazon.com
To see product details, add this item to your cart. You can always remove it later.
Shipper / Seller
Amazon.com
Amazon.com
Shipper / Seller
Amazon.com
Returns
30-day refund / replacement
30-day refund / replacement
This item can be returned in its original condition for a full refund or replacement within 30 days of receipt.
Read full return policy
Payment
Secure transaction
Your transaction is secure
We work hard to protect your security and privacy. Our payment security system encrypts your information during transmission. We don’t share your credit card details with third-party sellers, and we don’t sell your information to others. Learn more
Gift options
Available at checkout
Available at checkout This item is a gift. Change
At checkout, you can add a custom message, a gift receipt for easy returns and have the item gift-wrapped
To see product details, add this item to your cart. You can always remove it later.
FREE Returns
Item may have minor cosmetic defects. This book is in very good condition. Ships from Amazon Item may have minor cosmetic defects. This book is in very good condition. Ships from Amazon See less
Access codes and supplements are not guaranteed with used items.
Added to

Sorry, there was a problem.

There was an error retrieving your Wish Lists. Please try again.

Sorry, there was a problem.

List unavailable.
Kindle app logo image

Download the free Kindle app and start reading Kindle books instantly on your smartphone, tablet, or computer - no Kindle device required.

Read instantly on your browser with Kindle for Web.

Using your mobile phone camera - scan the code below and download the Kindle app.

QR code to download the Kindle App

  • Practical SQL, 2nd Edition: A Beginner's Guide to Storytelling with Data

Follow the author

Get new release updates & improved recommendations
Anthony DeBarros
Follow
Something went wrong. Please try your request again later.

Practical SQL, 2nd Edition: A Beginner's Guide to Storytelling with Data

by Anthony DeBarros (Author) Format: Paperback
4.7 out of 5 stars (303)

Purchase options and add-ons

Analyze data like a pro, even if you’re a beginner.

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.

* Microsoft SQL Server employs a variant of the language called T-SQL, which is not covered by Practical SQL.
Read more
Previous slide of product details
  1. ISBN-10
    1718501064
  2. ISBN-13
    978-1718501065
  3. Edition
    2nd
  4. Publisher
    No Starch Press
  5. Publication date
    January 25, 2022
  6. Language
    English
  7. Dimensions
    7.01 x 0.98 x 9.25 inches
  8. Print length
    464 pages
Next slide of product details

Frequently bought together

This item: Practical SQL, 2nd Edition: A Beginner's Guide to Storytelling with Data
$19.99
Get it as soon as Saturday, Sep 26
In Stock
Ships from and sold by Amazon.com.
+
Python Crash Course, 3rd Edition: A Hands-On, Project-Based Introduction to Programming
$27.53
Get it as soon as Saturday, Sep 26
In Stock
Ships from and sold by Amazon.com.
+
Automate the Boring Stuff with Python, 3rd Edition
$29.30
Get it as soon as Saturday, Sep 26
In Stock
Ships from and sold by Amazon.com.
Total price: $00
To see our price, add these items to your cart.
Details
Added to Cart
Choose items to buy together.

Customers who viewed this item also viewed

Page 1 of 1 Start over
Previous set of slides
  3. SQL Programming: a QuickStudy Laminated Reference Guide
    Robin Nixon
     
    Pamphlet
    #1 Best Seller
    $7.95
    Get it as soon as Saturday, Sep 26
    FREE Shipping on orders over $35 shipped by Amazon
  4. Automate the Boring Stuff with Python, 3rd Edition
    Al Sweigart
     
    Paperback
    -51%$29.30
    List: $59.99
    Get it as soon as Saturday, Sep 26
    FREE Shipping on orders over $35 shipped by Amazon
  5. Learning SQL: Generate, Manipulate, and Retrieve Data
    Alan Beaulieu
     
    Paperback
    -45%$36.49
    List: $65.99
    Get it as soon as Saturday, Sep 26
    FREE Shipping by Amazon
    Only 14 left in stock (more on the way).
  6. SQL for Data Analysis: Advanced Techniques for Transforming Data into Insights
    Cathy Tanimura
     
    Paperback
    -45%$36.49
    List: $65.99
    Get it as soon as Saturday, Sep 26
    FREE Shipping by Amazon
    Only 18 left in stock (more on the way).
Next set of slides

Customers also bought or read

Page 1 of 1Start over
Previous page
  2. Book cover Automate the Boring Stuff with Python, 3rd Edition
    Automate the Boring Stuff with Python, 3rd Edition
    Paperback
    $29.30
    Delivery Sat, Sep 26
  4. Book cover Learning SQL: Generate, Manipulate, and Retrieve Data
    Learning SQL: Generate, Manipulate, and Retrieve Data
    Paperback
    $36.49
    FREE delivery Sat, Sep 26
  7. Book cover Introducing Python: Modern Computing in Simple Packages
    Introducing Python: Modern Computing in Simple Packages
    Paperback
    $41.22
    FREE delivery Sat, Sep 26
  13. Book cover SQL Pocket Guide: A Guide to SQL Usage
    SQL Pocket Guide: A Guide to SQL Usage
    Paperback
    $21.34
    Delivery Sat, Sep 26
  16. Book cover SQL Cookbook: Query Solutions and Techniques for All SQL Users
    SQL Cookbook: Query Solutions and Techniques for All SQL Users
    Paperback
    $41.99
    FREE delivery Sat, Sep 26
  19. Book cover Python for Data Science: A Hands-On Introduction
    Python for Data Science: A Hands-On Introduction
    Paperback
    $51.36
    FREE delivery Sun, Sep 27
  23. Book cover The Book of R: A First Course in Programming and Statistics
    The Book of R: A First Course in Programming and Statistics
    Paperback
    $44.95
    FREE delivery Sun, Sep 27
  24. Book cover Just Use Postgres!: All the database you need
    Just Use Postgres!: All the database you need
    Paperback
    $59.99
    FREE delivery Sat, Sep 26
  28. Book cover Introducing Python: Modern Computing in Simple Packages
    Introducing Python: Modern Computing in Simple Packages
    Paperback
    $32.60
    Delivery Sat, Sep 26
Next page
Loading...

From the Publisher

Copy of Practical SQL, 2nd Edition on a black background with No Starch Press logo
Review of Practical SQL, 2nd Edition on black background
Review of Practical SQL, 2nd Edition on black background

About the Author

Anthony DeBarros is a longtime journalist who has combined his interests in data analysis, coding, software product development, and storytelling for much of his career. He is a data news editor for The Wall Street Journal, focusing on topics such as the economy, trade, the U.S. Census, and politics. He previously held positions with USA TODAY, the Poughkeepsie Journal, and the DocumentCloud project for Investigative Reporters and Editors. His work has received multiple honors, including a prestigious Silver Baton from the Alfred I. duPont-Columbia University Awards.

No Starch Press logo. A black circle with a white iron and a star in the center.

About the Publisher

No Starch Press has published the finest in geek entertainment since 1994, creating both timely and timeless titles like Python Crash Course, Python for Kids, How Linux Works, and Hacking: The Art of Exploitation. An independent, San Francisco-based publishing company, No Starch Press focuses on a curated list of well-crafted books that make a difference. They publish on many topics, including computer programming, cybersecurity, operating systems, and LEGO. The titles have personality, the authors are passionate experts, and all the content goes through extensive editorial and technical reviews. Long known for its fun, fearless approach to technology, No Starch Press has earned wide support from STEM enthusiasts worldwide.

Editorial Reviews

Review

"Even better than the previous edition!"
—Jakub Romanowski, LearnSQL.com

"This book is comprehensive, well organized, and contains almost everything a new developer needs to learn SQL using Postgres. Besides, the arrangement of the sections is logical, and the writing style is not complicated where information is supported by the required examples and images, in addition to evidence from the writer's practical experiences."
—Hadi Fadlallah, SQLShack

"[W]ell-written and informative . . . an extremely enjoyable book that will keep the reader engaged with interesting, thought-provoking exercises . . . I highly recommend Practical SQL, 2nd Edition to anyone wanting to learn PostgreSQL and how to tell stories with data."
—Joshua Allen Holm, Opensource.com


REVIEWS FOR THE FIRST EDITION:

"This book is comprehensive, well organized, and contains almost everything a new developer needs to learn SQL using Postgres. Besides, the arrangement of the sections is logical, and the writing style is not complicated where information is supported by the required examples and images, in addition to evidence from the writer's practical experiences."
—Hadi Fadlallah, SQLShack

“One of the best-organized travelogues we've seen into the SQL realm.”
—Newstips Bulletin

"More fun and more engaging [than Learning SQL from O'Reilly]."
—Giles McMullen-Klein, Python Programmer, YouTuber

“Practical SQL will take you from an absolute databases beginner towards becoming a database and SQL master. This book is one of those books that you feel like [you're] reading a novel, not a technical book. It uses an easy to follow and [understandable] approach that makes it easy to read for people from all backgrounds.”
—Sara A. Metwalli, Towards Data Science

"I recommend reading Practical SQL by Anthony DeBarros for a more in-depth look on how to implement regression analysis and other analytical tools using SQL."
—Michael Grogan, Towards Data Science

"One of the most interesting books about SQL I've ever read. At first glance, it looks like a guide for complete rookies. But the author raises topics that will interest advanced users."
—Jakub Romanowski, LearnSQL.com

About the Author

Anthony DeBarros is a longtime journalist who has combined his interests in data analysis, coding, software product development, and storytelling for much of his career. He is a data news editor for The Wall Street Journal, focusing on topics such as the economy, trade, the U.S. Census, and politics. He previously held positions with USA TODAY, the Poughkeepsie Journal, and the DocumentCloud project for Investigative Reporters and Editors. His work has received multiple honors, including a prestigious Silver Baton from the Alfred I. duPont-Columbia University Awards.

Product details

  • Publisher ‏ : ‎ No Starch Press
  • Publication date ‏ : ‎ January 25, 2022
  • Edition ‏ : ‎ 2nd
  • Language ‏ : ‎ English
  • Print length ‏ : ‎ 464 pages
  • ISBN-10 ‏ : ‎ 1718501064
  • ISBN-13 ‏ : ‎ 978-1718501065
  • Item Weight ‏ : ‎ 1.85 pounds
  • Dimensions ‏ : ‎ 7.01 x 0.98 x 9.25 inches
  • Best Sellers Rank: #60,687 in Books (See Top 100 in Books)
  • Customer Reviews:
    4.7 out of 5 stars (303)

About the author

Follow authors to get new release updates, plus improved recommendations.
Anthony DeBarros

Anthony DeBarros

Brief content visible, double tap to read full content.
Full content visible, double tap to read brief content.

Anthony DeBarros is a longtime journalist who has combined his interests in data analysis, coding, software product development, and storytelling for much of his career. He is a data news editor for The Wall Street Journal, focusing on topics such as the economy, trade, the U.S. Census, and politics. He previously held positions with USA Today, the Poughkeepsie Journal, and the DocumentCloud project for Investigative Reporters and Editors. He holds a Master of Science degree in Information Systems from Marist College, and his work has received multiple honors including a Silver Baton from the Alfred I. duPont-Columbia University Awards.

Related books

Page 1 of 1Start Over
Sponsored
Previous page
  1. Shop the Store on Amazon ›
    Excel for Busy Professionals: A 7-Minute-a-Day Crash Course to Reduce Workload, Eliminate Costly Errors and Accelerate Career Growth | Pivot Tables, VLOOKUP, XLOOKUP, Dashboards, Data Analysis, KPI
    Excel for Busy Professionals: A 7-Minute-a-Day Crash Course to Reduce Workload, Eliminate Costly Errors and Accelerate Career Growth | Pivot Tables, VLOOKUP, XLOOKUP, Dashboards, Data Analysis, KPI
    4.74.7 out of 5 stars127
    $21.97
  2. Shop the Store on Amazon ›
    The Options Trading Bible [50 in 1]: Unlock Proven Tactics to Read Markets, Spot High-Probability Entries, and Manage Risk Like a Pro. For Beginners Seeking Clarity, Confidence, and Consistent Profits
    The Options Trading Bible [50 in 1]: Unlock Proven Tactics to Read Markets, Spot High-Probability Entries, and Manage Risk Like a Pro. For Beginners Seeking Clarity, Confidence, and Consistent Profits
    4.54.5 out of 5 stars133
    $36.99
  3. Shop the Store on Amazon ›
    Machine Learning, Python & Data Analytics Essentials: Master AI, Data Science, and Analytics for Career Growth | Comprehensive Combo for Beginners & Professionals (Set of 3 Books)
    Machine Learning, Python & Data Analytics Essentials: Master AI, Data Science, and Analytics for Career Growth | Comprehensive Combo for Beginners & Professionals (Set of 3 Books)
    3.93.9 out of 5 stars31
    $89.99 List:$149.97
  4. Shop the Store on Amazon ›
    Excel for Seniors: A Simple Step-by-Step Guide to Microsoft Excel for Beginners in 1 Week
    Excel for Seniors: A Simple Step-by-Step Guide to Microsoft Excel for Beginners in 1 Week
    5.05.0 out of 5 stars5
    $19.99
  5. Shop the Store on Amazon ›
    The Software Architecture Bible: Master Enterprise Patterns, Clean Architecture Programming, and Scalable System Design with Modern C# and .NET 14. Includes Hands-On Exercises
    The Software Architecture Bible: Master Enterprise Patterns, Clean Architecture Programming, and Scalable System Design with Modern C# and .NET 14. Includes Hands-On Exercises
    4.14.1 out of 5 stars29
    $34.12 List:$49.99
Next page