國立虎尾科技大學 |

Narrative SQL = crafting data analysis queries that tell stories /

紀錄類型:	書目-語言資料,印刷品 : Monograph/item
正題名/作者:	Narrative SQL/ by Hamed Tabrizchi.
其他題名:	crafting data analysis queries that tell stories /
作者:	Tabrizchi, Hamed.
出版者:	Berkeley, CA :Apress : : 2025.,
面頁冊數:	xxiv, 404 p. :ill., digital ; : 24 cm.;
Contained By:	Springer Nature eBook
標題:	Quantitative research. -
電子資源:	https://doi.org/10.1007/979-8-8688-1560-7
ISBN:	9798868815607

Narrative SQL = crafting data analysis queries that tell stories /
Tabrizchi, Hamed.

Narrative SQLcrafting data analysis queries that tell stories /[electronic resource] :by Hamed Tabrizchi. - Berkeley, CA :Apress :2025. - xxiv, 404 p. :ill., digital ;24 cm.

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.

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.

ISBN: 9798868815607

Standard No.: 10.1007/979-8-8688-1560-7doiSubjects--Topical Terms:

635913
Quantitative research.

LC Class. No.: QA76.9.Q36 / T33 2025

Dewey Class. No.: 001.42

Narrative SQL = crafting data analysis queries that tell stories /
LDR:04255nam a2200325 a 4500 001 1167003
003 DE-He213
005 20250711141826.0
006 m d
007 cr nn 008maaau
008 251217s2025 cau s 0 eng d
020 $a 9798868815607 $q (electronic bk.)
020 $a 9798868815591 $q (paper)
024 7 $a 10.1007/979-8-8688-1560-7 $2 doi
035 $a 979-8-8688-1560-7
040 $a GP $c GP
041 0 $a eng
050 4 $a QA76.9.Q36 $b T33 2025
072 7 $a UN $2 bicssc
072 7 $a COM021000 $2 bisacsh
072 7 $a UN $2 thema
082 0 4 $a 001.42 $2 23
090 $a QA76.9.Q36 $b T114 2025
100 1 $a Tabrizchi, Hamed. $3 1488747
245 1 0 $a Narrative SQL $h [electronic resource] : $b crafting data analysis queries that tell stories / $c by Hamed Tabrizchi.
260 $a Berkeley, CA : $b Apress : $b Imprint: Apress, $c 2025.
300 $a xxiv, 404 p. : $b ill., digital ; $c 24 cm.
505 0 $a 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.
520 $a 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.
650 0 $a Quantitative research. $3 635913
650 0 $a SQL (Computer program language) $3 561599
650 0 $a Querying (Computer science) $3 785780
650 1 4 $a Data Analysis and Big Data. $3 1366136
650 2 4 $a Data and Information Visualization. $3 1366914
650 2 4 $a Database Management. $3 669820
710 2 $a SpringerLink (Online service) $3 593884
773 0 $t Springer Nature eBook
856 4 0 $u https://doi.org/10.1007/979-8-8688-1560-7
950 $a Professional and Applied Computing (SpringerNature-12059)