Narrative SQL

Crafting Data Analysis Queries That Tell Stories

Hamed Tabrizchi

• Publisher: Apress
• Year: 2025
• Print ISBN: 9798868815591
• eBook ISBN: 9798868815607
• Topic: Computer Science
• Subtopic: Databases
• Index: Computer Science

This book addresses an important gap in data analytics education: the interplay between complex query-making and storytelling. While many resources cover the fundamentals of SQL queries and the technical skills required to manipulate data, few also explore moving beyond the numbers and figures to tell stories that drive strategic business decisions. By weaving together both SQL and narrative mechanics, author Hamed Tabrizchi has assembled a powerful tool for data analysts, aspiring database professionals, and business intelligence specialists.

A strong foundation is laid in the first part of the book, which examines the technical skills necessary to access and manipulate data. You’ll explore foundational SQL commands, advanced querying techniques, data manipulation, data integrity, and optimization of queries for performance. The second half moves from the "how" of SQL to the "why," examining the meaning-making practices we can apply to data, and the stories data can tell. You'll learn how SQL queries can be interpreted, how to prepare data for visualization, and most importantly, how to convey the findings in a way that engages and informs the audience. In each chapter, practical exercises reinforce the techniques learned and help you apply them in real-world situations. In addition to strengthening technical skills, these exercises encourage readers to take a critical view of the data they are studying, considering the larger story it represents.

Upon completing this book, you will not only be proficient in SQL, but also possess the key skill of converting data into narratives that can influence strategic direction and operational decisions in the modern workplace.

What You Will Learn 

• Advanced SQL Techniques: Master data manipulation and retrieval skills using advanced SQL queries
• Data Analysis Proficiency: Develop analytical skills to uncover key insights and understand significant data patterns
• Storytelling with Data: Learn to translate data analytics into compelling narratives for effective stakeholder communication
• Complex Querying Skills: Understand advanced SQL concepts such as common table expressions (CTEs), subqueries, and window functions
• Query Optimization: Optimize query execution time, resource usage, and scalability by mastering Indexes and Views
• Practical Application of Techniques: Gain hands-on experience with practical examples of advanced SQL techniques in real-world data analysis scenarios
• Effective Data Presentation: Discover strategies for visually presenting data stories to enhance engagement and understanding among diverse audiences

Who This Book Is For

Data analysts and business analysts, SQL developers, data-driven managers and executives and academics and students looking to enhance advanced querying and narrative building skills to better interpret and convey data.

Table of contents

• Narrative SQL
• Introduction
• Chapter Overviews
• Acknowledgments
• Table of Contents
• About the Author
• About the Technical Reviewer
• 1. The Storyteller’s Database
• 2. Starting with SELECT
• 3. Filtering Facts with WHERE
• 4. Complex Characters with JOINs
• 5. Aggregating Acts
• 6. Ordering the Plot with ORDER BY and LIMIT
• 7. Dynamic Dialogues with Subqueries
• 8. Conditional Logic in Data Plotting
• 9. Optimizing Your Script with Indexes and Views
• 10. Analytics Alchemy: Turning Data into Gold
• 11. The Grand Finale: Presenting Your Data Story
• Appendix A: SQL Syntax Reference Guide
• Appendix B: Glossary of Terms
• Appendix C: PostgreSQL Elements Reference
• Index