Practical Sql: A Beginnerвђ™s Guide To Storytelli... Guide
Identify and fix errors before they ruin your analysis.
The book primarily uses PostgreSQL and the pgAdmin interface, but the skills translate to other systems like MySQL, Oracle, and SQLite.
Use aggregation, sorting, and filtering to spot trends. Practical SQL: A Beginner’s Guide to Storytelli...
You won't be practicing on "dummy" data. Instead, you'll work with real datasets like U.S. Census demographics , New York City taxi rides, and global earthquake data.
Explore the world through Geographic Information Systems (PostGIS). Who Should Read It? Identify and fix errors before they ruin your analysis
Most SQL guides focus on the syntax of "how." DeBarros, a journalist and data analyst, focuses on the "why". He treats every database like a crime scene or a news lead, guiding you through the process of finding the story hidden within the rows.
Go beyond basic math to use advanced statistical functions. You won't be practicing on "dummy" data
Reviews often compare reading this book to a "novel" or a "travelogue" because of its engaging, logical progression. Key Skills You'll Gain
