A series of SQL tutorials for data analysts
Click on any image in the table below to view the tutorial.
| PROJECT – build a basic data warehouse A series of tutorials where we build a basic data warehouse from the Tableau Superstore dataset (Basic-intermediate) |  |
| SQL Window Functions – Intro to window functions A quick run through of what window functions are, how they work and when to use them. (Intermediate) |  |
| SQL Window Functions – FIRST_VALUE An introduction to the FIRST_VALUE function, using a practical example with a real world use case. (Intermediate) |  |
| SQL Window Functions – RANK, DENSE_RANK, ROW_NUMBER An introduction to RANK and DENSE_RANK, also introducing CTEs and QUALIFY (Intermediate) |