Module 06
SQL for analytics
Relational modelling, joins, aggregates, subqueries and window functions — the SQL course every Magnimind analyst finishes before touching modelling.
Outcome
What you will be able to do
You can answer real business questions against a relational database without exporting to a spreadsheet.
Lessons
Work through these in order
- 01Introduction to DatabaseA database is an organized collection of interrelated data used to model some type of organization or organizational process. You have a database as long as you’re collecting and storing data in some… 8 min
- 02SQL StatementsThe key to SQL is understanding the statements which could be categorized into five groups: 8 min
- 03Before JoinsINTERSECT statement will return only those rows which will be common to both of the SELECT statements. 8 min
- 04SQL AggregatesBefore aggregations, let us summarize NULL concept in SQL. NULLs are datatypes that specifies “no data” exists. NULLs are often ignored in aggregate functions. NULLs are different than a zero - they… 8 min
- 05Subqueries1. Find the number of events that occur for each day for each channel. 8 min
- 06SQL Window FunctionsThe PARTITION BY clause divides rows into multiple groups or partitions to which the window function is applied. Some window functions don’t accept any arguments. 8 min
Assessment
Module quiz — 70% to pass
6 questions mixing concept checks and short code-output problems. Graded on the server with per-question explanations afterwards, unlimited retakes, and a badge with a verification code the moment you pass.