
- Home
- Books
- Data Engineering & Databases
- SQL & Relational Databases
- SQL for Data Analysis
SQL & Relational DatabasesIn Stock
SQL for Data Analysis
Advanced Techniques for Transforming Data into Insights 80 GSM
Price৳ 290
SQL for Data Analysis by Cathy Tanimura is a comprehensive guide to writing advanced SQL queries for analytical modeling and business reporting. Extracting meaningful insights from relational databases requires techniques beyond simple SELECT statements and basic joins. Tanimura demonstrates how to solve real analytical problems using window functions, cohort breakdowns, and time series transformations.
What you will learn
- Transform raw transactional tables into clean datasets using window functions and CTEs
- Conduct cohort analysis and retention calculations to measure user behavior over time
- Build sales and marketing conversion funnels across multi-step user journeys
- Calculate rolling averages, period-over-period growth, and time series aggregations
- Analyze A/B test experiments and evaluate statistical significance directly inside SQL
- Detect anomalous records and data outliers using distribution metrics
Who this is for
Data analysts, business intelligence developers, and data scientists who want to perform sophisticated analytics directly in the database. Basic knowledge of SQL syntax is assumed.


