Beginners guide to storytelling with data.

This is a summary of Practical SQL a book written in plain-English which is an introduction to programming with SQL. Covering SQL basics, database fundamentals, pgAdmin interface and PostgreSQL database system to define, organise and analyse real-world data sets.

Querying a Subset of Columns

Using DISTINCT to find unique values

Filtering Rows with WHERE

Filtering with LIKE AND ILIKE

Combining operators using AND and OR

Putting it all together

Understanding Data Types

Data types

Basic Math and Stats with SQL

Adding and Subtracting Columns

Percentage of the Whole / Tracking Percent Change

Aggregate Functions for Averages and Sums

Finding the Median

Finding Other Quartiles with Percentile Functions