Narrative SQL

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.

  Evolve from analyst to data storyteller and decision influencer Apply concepts to real-world scenarios mimicking business cases and data puzzles Gain marketable skills in big data and analytics for business professionals

  Autorentext

  Hamed Tabrizchi is an experienced data analyst and engaging storyteller who has more than five years of experience turning complex data into compelling narratives. Passionate about educating others, Hamed lectures at universities, leads workshops, and contributes to leading scientific journals. As a result of his observations in the professional community, he decided to write this book to fill a void he observed: the need for a resource that weaves SQL technicalities with narrative to empower analysts in delivering insights that resonate and drive action.

  Inhalt

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