Welcome to the course: what you will learn

From spreadsheet to answers. Welcome to Practical SQL for Analysts course. Picture a Monday morning. Your manager asks how much the online shop sold last month, broken down by product. The orders sit in a database with thousands of rows, and exporting them to Excel is slow and messy. What if you could ask the database directly and get the answer in seconds? By the end, you'll write that query yourself: a monthly sales report you can run again any time. That's what Practical SQL for Analysts is here to teach you.

Who this is for. This is for analysts who use Excel every day and have never written a line of SQL. SQL stands for Structured Query Language. It's simply a way of asking a database questions in short, readable sentences. If you've used filters, pivot tables or VLOOKUP, you already understand most of the ideas. We'll use SQLite, a free database that lives in a single file on your computer. There's no server to set up and nothing to pay for. Bring your Excel instincts, and we'll translate them one by one.

How the course fits together. The course has one track, SQL for Excel Users, and inside it one course, Practical SQL with SQLite. It moves in four steps. First you learn to pick, filter and sort rows. Then you summarize them, the way a pivot table does. Next you combine tables, the way VLOOKUP pulls data from another sheet. Finally you put all three together in a project. Each step uses only what came before, so you never face something new without the ground under it.

Your first query. The first lesson is your first query. You'll work with the shop's orders table and learn three words. SELECT picks the columns you want to see, like hiding the ones you don't need. WHERE keeps only the rows that match a condition, just like an Excel filter, for example orders over fifty dollars. ORDER BY sorts the result, largest first or newest first. After this lesson, you can pull exactly the orders you need, cleanly sorted, without touching a spreadsheet.

Summarize like a pivot table. The second lesson turns raw rows into summaries. GROUP BY works like the rows area of a pivot table: it gives you one line per customer, per product or per month. Then you add COUNT to see how many orders, SUM for total sales, and AVG for the average order value. An average is just the total divided by the number of items. The best part is that one short query replaces a pivot table you'd otherwise rebuild every week.

Combine tables like VLOOKUP. In the third lesson you combine tables. The orders table only stores a customer ID and a product ID, not the names. In Excel you'd write a VLOOKUP to fetch them. In SQL you use JOIN, which matches rows in two tables that share the same ID. You'll join orders with customers and products to see who bought what, and at what price. It's the most powerful idea in the course, so we'll take it slowly, with plenty of examples.

Project: monthly sales report. The course ends with a project: a monthly sales report query for the online shop. You'll join orders with customers and products, group the results by month, add up the sales, and sort them so the best months and products stand out. This is the exact question from the start of this video. When you finish it, you'll have a real, reusable report, and the confidence that you can build the next one on your own.

Get the most out of it. A few tips to make this stick. Keep a steady pace, one lesson at a time, and don't rush ahead. Type every query yourself rather than just watching, because your fingers learn faster than your eyes. Then change something: a different filter, another column, a new sort order, and see what happens. Mistakes are cheap here, since you can't break anything. And please do the project. It's where the separate pieces click into one working skill.

Recap and next steps. Let's recap Practical SQL for Analysts. You'll learn to select, filter and sort orders, summarize them like a pivot table, combine tables like VLOOKUP, and finish with a monthly sales report for the online shop. Four steps, each built on the last, all in free SQLite. That's a skill you can use at work the very next day. Up next is your first query, where you'll open the orders table and start asking it questions.