
- Home
- Books
- Data Engineering & Databases
- SQL & Relational Databases
- Practical SQL, 2nd Edition
SQL & Relational DatabasesIn Stock
Practical SQL, 2nd Edition
A Beginner's Guide to Storytelling with Data
Price৳ 800
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.


