Learn SQL Through Real Data and Practical Analysis
Turn databases into useful information and learn how to uncover meaningful patterns through practical SQL techniques.
Practical SQL, 2nd Edition provides an approachable introduction to Structured Query Language (SQL), giving beginners a practical path into working with relational databases and analyzing real-world information.
The guide uses PostgreSQL and its companion pgAdmin interface for examples and exercises, while the underlying concepts can be applied across many database management systems, including MySQL, Oracle, SQLite, and others.
Rather than treating SQL as a collection of complicated commands, the book focuses on using data to answer questions and uncover useful stories. You begin with fundamental database and SQL concepts before progressing toward more advanced techniques for analyzing, organizing, cleaning, and exploring information.
Build Your SQL Skills Step by Step
Real-world datasets provide practical opportunities to apply what you learn. Examples include US Census demographics, New York City taxi rides, and earthquake data from the US Geological Survey.
Each chapter combines explanations, examples, and exercises to help learners gradually develop the skills needed to work with databases and retrieve information efficiently.
Database Fundamentals
- Understand relational databases
- Create databases and tables
- Organize your own data
- Work with PostgreSQL and pgAdmin
Data Analysis
- Filter and sort information
- Aggregate data
- Find patterns and relationships
- Perform mathematical and statistical operations
What You’ll Learn
- Create databases and related tables using your own data.
- Aggregate, sort, and filter information to identify useful patterns.
- Use SQL functions for basic mathematical calculations and advanced statistical operations.
- Recognize data problems and apply techniques to clean and improve datasets.
- Build more advanced queries for deeper data analysis.
- Analyze spatial information using geographic information systems and PostGIS.
- Automate repetitive database tasks.
- Work with PostgreSQL and the JSON data interchange format.
Updated for Modern SQL Workflows
The second edition has been revised to include additional advanced query techniques for working with and transforming data. It also introduces expanded system setup instructions and a dedicated chapter covering PostgreSQL and JSON.
These additions provide learners with a broader foundation for working with modern data formats and more advanced SQL workflows.
Ideal for Beginners and Aspiring Data Professionals
This guide is particularly useful for readers who are new to programming or databases and want to develop practical SQL skills through clear explanations and hands-on examples.
Whether you’re learning SQL for data analysis, database development, programming, research, or professional work, this book provides a structured foundation for understanding how data can be stored, explored, cleaned, and analyzed.
Note: The examples in this guide use PostgreSQL. Microsoft SQL Server uses a variant of SQL called T-SQL, which is not covered by this guide.
