[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8},"actionData","errors","root",{"_28":-5,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_49":50,"_51":52,"_53":54,"_55":56,"_57":58},"routes/_store+/_readers+/email_author.$slug/route",{"_9":10,"_11":-5},"book",{"_12":13,"_14":15,"_16":17,"_18":19,"_20":21,"_22":23},"currentUser","id","Z2lkOi8vbGVhbnB1Yi9TdG9yZTo6Qm9va1Byb2R1Y3QvNzk3NjE","title","SQL for Data Analysis — Complete Practical Manual","state","published","contactAuthorMethod","email","aboutText","

Want to query and analyse data directly in the database without depending on anyone else? This manual takes you step by step from your first SELECT to professional-grade analysis with Window Functions and real-world projects, with ready-to-run SQL examples in every chapter.

What you'll learn:

- Advanced SELECT — filters, aliases, CASE WHEN, text and date functions

- Aggregation — GROUP BY, HAVING and the 5 essential summary functions

- JOINs — combine tables with INNER, LEFT, SELF and CROSS JOIN

- Subqueries and CTEs — nested queries and common table expressions

- Window Functions — ROW_NUMBER, LAG, LEAD, running totals and rankings

- Data manipulation — INSERT, UPDATE, DELETE, indexes and views

- Final project — complete RFM analysis and data mart construction

What's included:

→ 62-page PDF ready to read on any device

→ ShopDB dataset included to practise all examples

→ Quick-reference cheatsheets (SELECT, functions, Window Functions)

→ Cross-engine equivalence table (SQLite, PostgreSQL, MySQL, BigQuery)

→ Full SQL glossary

→ Permanent access with future updates included

Ideal for business analysts, data scientists, developers, and anyone who works with data and wants to stop waiting for others to pull it for them.

","authors",[24],{"_12":25,"_26":27,"_28":29},"Z2lkOi8vbGVhbnB1Yi9TdG9yZTo6UHJvZHVjdEF1dGhvci84NTMzMA","name","Tenabal","user",{"_30":31},"avatar",{"_32":33,"_34":35,"_36":37},"url","https://d39qdlcrvnra4b.cloudfront.net/avatars/3730716/medium/avatar.jpg?1780262408","styleName","medium","exists",true,"shoppingCartId","shoppingCart",{"_12":71,"_72":73,"_74":37,"_75":76,"_77":78,"_79":80,"_81":37},"locale","en","readerTheme","light","constants",{"_69":70},"publishers",{"_65":66,"_67":68},"learnerOrganizations",[],"needsLocaleCookieSync",false,"announcements",{"_59":60,"_61":-5},"sentryEnvironment","production","sentryRelease","06fff6bf2a3f19ff2ef76f94f389bccdbec7f9bd","announcement_store",{"_62":52,"_63":64},"announcement_authors","flag","text","

Kick off your book project, get started with GhostAI, get better at marketing, or spend the day doing all three! Free live workshops on Zoom. Saturday, June 27, 2026.

\n","companies",[],"universities",[],"paypalClientId","AX53Cwz8jR6rVVzzZiZNWWXl0dGagi-GZrjG-S3Ua14E5nrKMn7DxDQ730O4R8LusLPp49ALn6aRVaEy","no-cart","count",0,"free","updatedAt","","paymentGateway","STRIPE","cartItems",[],"loading"]

Email the Author