It starts from what you know
Before it plans, Tessorio asks what you want and what you already know, and a short check skips what you have. The course starts where you're shaky.
Subjects · SQL for data analysis
SQL for data analysis, from zero.
Learn the entry-level analyst's workflow on one small coffee shop sales dataset: clean it, answer questions with spreadsheet formulas and SQL, chart the answer, and finish with a case study you can show.
The ready-made course · 7 units, 20 lessons
Data Analytics with Excel and SQL: From Raw Data to Answers
Learn the entry-level data analyst workflow end to end on one small coffee shop sales dataset, from a messy spreadsheet to a clean answer a manager can act on. Every lesson shows the real formulas, SQL queries and charts on screen, starting from zero vocabulary and building to a portfolio-ready case study.
Unit 1The Analyst's Job and the Six Steps3 lessons
- 1.1A Week in the Life of an Entry-Level Analyst (and the Three Portfolio Pieces That Get You Hired)
- 1.2Ask, Prepare, Process, Analyze, Share, Act: Sorting Coffee Shop Tasks Into the Six Steps
- 1.3Turning "Sales Feel Down Lately" Into One Answerable Question
Unit 2Getting the Coffee Shop Data Clean3 lessons
- 2.1Reading a Raw Sales Export: Grain and Red Flags
- 2.2Fixing Duplicates, Stray Text, Dates and Dollar Signs
- 2.3The Six Blank Quantities: Deciding and Logging Your Choices
Unit 3Spreadsheet Answers: Formulas, Lookups and Pivot Tables4 lessons
- 3.1Adding Up Only the Lattes: SUM, AVERAGE, COUNTIF and SUMIF
- 3.2IF Labels and the $ That Locks a Cell
- 3.3Pulling in Each Item's Category with VLOOKUP
- 3.4Building a Pivot Table That Answers "Which Hour Is Busiest?"
Unit 4Asking the Database: SELECT to JOIN4 lessons
- 4.1Tables, Rows and Columns: Your First SELECT and WHERE
- 4.2Biggest First, Top 20 Only: ORDER BY and LIMIT
- 4.3One Row Per Item: GROUP BY, COUNT, SUM, AVG and HAVING
- 4.4Matching Two Tables: INNER JOIN, LEFT JOIN and Counting the Rows
Unit 5Numbers That Tell the Truth2 lessons
- 5.1Five Numbers That Describe a Week of Coffee Sales
- 5.2Why That $9.80 Average Slide Isn't Safe
Unit 6Charts and a Dashboard That Answer the Question2 lessons
- 6.1Line, Bar, Stacked or Scatter: Matching the Chart to the Coffee Shop Question
- 6.2One Screen for 'Should I Add a Second Barista?'
Unit 7Case Study: One Question, Start to Finish2 lessons
- 7.1Chasing One Question: "Why Are Our Afternoons Quiet?"
- 7.2The 200-Word Finding: Evidence, Limits and a 30-Day Measure
How the course works
Learned, not just watched
Each idea is shown, then checked
Lessons are narrated, and the picture draws itself as each part is named. After each idea the lesson stops and asks you a question.
What you miss comes back
A wrong answer gets an explanation of why. Topics you keep missing become catch-up lessons.
A tutor beside every lesson
Pause and ask about what's on screen. A big question can become a lesson of its own.
Which plan
Questions
Asked often
What is SQL?
SQL (Structured Query Language) is how you ask a database a question: which items sold most, which hours are quiet, how two tables match up. Analysts use it to pull exactly the rows and totals they need.
Do I need math or coding first?
No. The course assumes nothing beyond arithmetic and explains every term the first time it appears. Every formula and query is shown on screen.
Why Excel and SQL together?
Most analyst work moves between the two: a spreadsheet for quick answers and pivot tables, SQL when the data lives in a database. The course uses the same dataset for both so you see how they connect.
Will this get me a job?
It walks through the work an entry-level analyst does and ends with a case study you can show. It can't promise a job, but you'll be able to explain and demonstrate the workflow.
What does it cost?
The free courses in the Tessorio Library need no account and cost nothing. Plans are Self-learning $19.99 a month, Family $29.99, Teacher $19.99 and Course Creator $79. Paying yearly costs ten times the monthly price, so two months are free. Each plan includes the whole Library and a set number of new lesson minutes a month; watching and rewatching never use them.
Want to learn SQL this way?
Start with a free account, and pick a plan when you're ready.