Simulator «SQL for data analysis»

This is not a course. This is a simulator of the work of a data analyst in a real company with training elements. You will calculate retention and LTV, write multi-story CTEs and do other useful things for business using SQL.

Simulator goals

1. Teach not basic “SQL queries”, but useful features, ecosystem and production-level code
2. Teach how to write queries that business needs. You will not study cats - you will calculate LTV, do complex aggregations and ad-hoc
3. Immerse in the environment. You will work with professional tools - PostgreSQL, DBeaver, MySQL, Power BI and schedulers

What you will do

• Write numerous ad-hoc SQL queries: collection and validation of email addresses, calculation of user activity statistics and much more
• Collect cohorts, analyze retention, LTV, CR and other product metrics using high-level SQL queries
• Automate data import/export on a Windows/Linux server using SQL + Python + psycopg2 + cron