Tibixa
English

Beginner · free

Practical SQL for Analysts

Move from Excel to SQL and write your first real report query, with nothing to install.

For business analysts who use Excel daily and have never written SQL..

Start the course See all lessons

Start here

1 lesson
  1. Welcome to the course: what you will learn Welcome 5 min

Module 1: Practical SQL with SQLite

5 lessons
  1. Track overview: SQL for Excel Users Introduction 5 min
  2. Your first query: SELECT, WHERE and ORDER BY on the orders table Lesson 1 9 min quiz 2 exercises
  3. Summarizing like a pivot table: GROUP BY with COUNT, SUM and AVG Lesson 2 8 min quiz 2 exercises
  4. Combining tables like VLOOKUP: JOIN orders with customers and products Lesson 3 9 min quiz 2 exercises
  5. Project: a monthly sales report query for the online shop Lesson 4 8 min quiz 2 exercises