國立高雄大學圖資館 |

Language: English

Back

Narrative SQLcrafting data analysis ...

SpringerLink (Online service)

Narrative SQLcrafting data analysis queries that tell stories /

Record Type:	Electronic resources : Monograph/item
Title/Author:	Narrative SQLby Hamed Tabrizchi.
Reminder of title:	crafting data analysis queries that tell stories /
Author:	Tabrizchi, Hamed.
Published:	Berkeley, CA :Apress :2025.
Description:	xxiv, 404 p. :ill., digital ;24 cm.
Contained By:	Springer Nature eBook
Subject:	Quantitative research.
Online resource:	https://doi.org/10.1007/979-8-8688-1560-7
ISBN:	9798868815607$q(electronic bk.)

Narrative SQLcrafting 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$q(electronic bk.)

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

367894
Quantitative research.

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

Dewey Class. No.: 001.42

Narrative SQLcrafting data analysis queries that tell stories /
LDR:04256nmm a2200325 a 4500 001 682890
003 DE-He213
005 20250711141826.0
006 m d
007 cr nn 008maaau
008 251209s2025 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 990975
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 367894
650 0 $a SQL (Computer program language) $3 189402
650 0 $a Querying (Computer science) $v Congresses. $3 387170
650 1 4 $a Data Analysis and Big Data. $3 913147
650 2 4 $a Data and Information Visualization. $3 913414
650 2 4 $a Database Management. $3 273994
710 2 $a SpringerLink (Online service) $3 273601
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)