HireSol
← All courses

CourseData AnalysisBeginner

SQL and databases, from first query to interview-ready

Everything SQL interviews test, for analysts and developers alike: filtering and aggregation, every kind of join, subqueries and CTEs, window functions, indexes, transactions and normalisation, with practice queries on a realistic dataset.

10 min · 4 lessons

Lessons

  1. 1Querying basics: SELECT, WHERE, ORDER BY and aggregation2 min
  2. 2Joins, subqueries and set operations3 min
  3. 3Window functions: the interview favourite2 min
  4. 4Database design: keys, normalisation, indexes and transactions3 min

Keep going

Interview questionsIntermediate

Top 10 SQL interview questions

10 min · 10 questions

Interview questionsBeginner

Top 10 data analyst interview questions

10 min · 10 questions

CourseBeginner

Data analysis with Python, pandas and dashboards

8 min · 4 lessons

CourseBeginner

Excel and Google Sheets for every job

7 min · 4 lessons