SQL Cheat Sheet Power Pack: 4 Cheat Sheets in 1 (SQL Server / T-SQL)

Get all four cheat sheets for £4.99 instead of £7.96.

That’s a saving of £2.97, or 37%, compared with buying them one by one.

Four printable cheat sheets that pick up where the basics stop.

Each one is packed with ready-to-use T-SQL for real jobs, from medians and streaks to messy text and duplicate data.

All four come together in one 9-page PDF.

01 · Advanced Window Functions

Percent of total, comparing rows with their group, new vs returning customers, record highs, paging totals, medians and quartiles, Pareto 80/20, filling gaps with the last known value, finding streaks, and frame tricks.

02 · Dates & Times

Exact ages, quarters, week starts, weekday or weekend, working days, date formats, UK vs US dates, building a calendar, showing days with no sales as 0, and converting time zones with BST handled.

03 · String Functions

Trimming any characters, searching by position or pattern, capitalising names, cleaning phone numbers, splitting names, padding and stripping zeros, masking emails, message templates, and finding unwanted characters.

04 · Data Cleaning

Profiling columns, counting missing values, finding and safely deleting duplicates, spotting near-duplicates and stray spaces, catching rows that break a rule, standardising messy values, and backing up before you fix.

Who it’s for?

Analysts and developers who already know the basics and want to go further

Anyone building reports in SQL Server

Job seekers preparing for SQL interviews

Format

One 9-page A4 PDF with a cover and contents, ready to print or keep open on a second screen.

Every sheet has example tables and results shown beside the queries.

For personal use only.

From Rosleecia Productions.