The Leanpub 60 Day 100% Happiness Guarantee
Within 60 days of purchase you can get a 100% refund on any Leanpub purchase, in two clicks.
See full terms...
SQL for Data Analysis — Complete Practical Manual
A practical 62-page manual to master SQL for data analysis from scratch. Covers SELECT, JOINs, CTEs, Window Functions, and a complete RFM final project. Includes exercises, cheatsheets, and a real dataset.
Minimum price
$9.99
$15.00
You pay
Author earns
PDF
About
About the Book
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.
Author
About the Author
Tenabal
Technical educator and developer passionate about making data science accessible. Creator of practical handbooks that focus on real code and applied examples over unnecessary theory.
Get the free sample chapters
Click the buttons to get the free sample in PDF or EPUB, or read the sample online here
Earn $8 on a $10 Purchase, and $16 on a $20 Purchase
We pay 80% royalties on purchases of $7.99 or more, and 80% royalties minus a 50 cent flat fee on purchases between $0.99 and $7.98. You earn $8 on a $10 sale, and $16 on a $20 sale. So, if we sell 5000 non-refunded copies of your book for $20, you'll earn $80,000.
(Yes, some authors have already earned much more than that on Leanpub.)
In fact, authors have earned over $15 million writing, publishing and selling on Leanpub.
Learn more about writing on Leanpub
Free Updates. DRM Free.
If you buy a Leanpub book, you get free updates for as long as the author updates the book! Many authors use Leanpub to publish their books in-progress, while they are writing them. All readers get free updates, regardless of when they bought the book or how much they paid (including free).
Most Leanpub books are available in PDF (for computers) and EPUB (for phones, tablets and Kindle). The formats that a book includes are shown at the top right corner of this page.
Finally, Leanpub books don't have any DRM copy-protection nonsense, so you can easily read them on any supported device.
Learn more about Leanpub's ebook formats and where to read them
Write and Publish on Leanpub
You can use Leanpub to easily write, publish and sell in-progress and completed ebooks and online courses!
Leanpub is a powerful platform for serious authors, combining a simple, elegant writing and publishing workflow with a store focused on selling in-progress ebooks.
Leanpub is a magical typewriter for authors: just write in plain text, and to publish your ebook, just click a button. (Or, if you are producing your ebook your own way, you can even upload your own PDF and/or EPUB files and then publish with one click!) It really is that easy.