Practical SQL, 2nd Edition cover

Practical SQL, 2nd Edition

A Beginner's Guide to Storytelling with Data

by Anthony DeBarros

Price৳ 800
Price৳ 800

Have a question? Ask on WhatsApp or Message on Messenger

Call 01963 822422 / 01817 506044 for help with your order

Practical SQL by Anthony DeBarros is a hands-on guide to querying, analyzing, and transforming real-world datasets using PostgreSQL and pgAdmin. Working with actual datasets requires more than textbook query theory, as real data contains inconsistencies, missing attributes, and messy formats. DeBarros guides readers through practical data exploration, statistical analysis, and spatial mapping using PostgreSQL.

What you will learn

  • Create databases, define structured tables, and import messy CSV files using PostgreSQL
  • Query and filter records using aggregation, grouping, conditional logic, and subqueries
  • Clean and normalize malformed strings, dates, and numbers with SQL functions
  • Perform statistical calculations, including median, percentile ranks, and correlation
  • Query semi-structured data formats using PostgreSQL native JSON and JSONB operators
  • Store and analyze geospatial data using PostGIS location functions and spatial queries

Who this is for

Beginners, journalists, data analysts, and developers looking to learn SQL through practical data projects. No previous database administration or programming experience is required.