Learn SQL with a real database – right on iPhone and iPad
You write real queries for a trading company, the app runs them and checks your result at once. This is how you learn to turn raw data into answers for everyday business: from SELECT to window functions and business analyses.
Coming soon to the App Store for iPhone and iPadA real database instead of dry drills
All exercises run on the database of the fictional Alpina Outdoor AG, a Swiss retailer of outdoor gear with branches and an online shop. The data is deliberately realistic, including messy: missing emails, duplicates, outliers. That is exactly what you deal with on the job.
The twelve tables (rows in brackets)
Checked automatically, on two databases
The app runs your query on the practice database and compares the result. Then it also runs on a check database with the same schema but different values. Anyone who just types in the numbers instead of understanding the query fails. When you make a mistake you get a hint, not just a red message.
Four course parts, 23 chapters
ABasicsChapters 1–6
01Start: SQL for data analysisWhy SQL and how this course works6 lessons
- This is how this course works
- What is a database?
- Tables, rows, columns
- The practice database: a Swiss trading company
- Your first query
- SQL dialects: SQLite, MySQL, PostgreSQL, SQL Server
02SELECT: Query dataThe most important instruction6 lessons
- SELECT and FROM
- Select and rename columns
- DISTINCT: remove duplicate values
- Arithmetic in the query
- LIMIT: only the first lines
- Readable SQL style and comments
03Filter with WHEREOnly the lines that count6 lessons
- WHERE and comparison operators
- AND, OR and NOT
- IN and BETWEEN
- LIKE and search pattern
- NULL: the missing value
- Typical filter errors
04SortOrder in the results5 lessons
- ORDER BY
- Sort by multiple columns
- Top-N queries
- NULL values in sorting
- Page by page with OFFSET
05Text, number, and date featuresTransform values6 lessons
- Text Functions
- Round and format numbers
- Date and time
- Year, month and day of the week
- Convert data types with CAST
- COALESCE and NULLIF
06Conditions with CASEIf, then, otherwise4 lessons
- CASE WHEN understand
- Form categories
- CASE in calculations
- Traffic light logic for reports
BSummarising and joiningChapters 7–12
07Aggregate and GroupFrom lines to key figures7 lessons
- COUNT, SUM, AVG, MIN, MAX
- GROUP BY
- Group by multiple columns
- HAVING: Filter groups
- WHERE or HAVING?
- Conditional aggregation
- Case study: Key figures at a glance
08Connect tables with JOINData from multiple tables8 lessons
- Why multiple tables?
- Primary and external key
- INNER JOIN
- LEFT JOIN
- Find datasets without partners
- Connect three and more tables
- Self-Join
- Double lines after the JOIN
09Volume operationsCombine results3 lessons
- UNION and UNION ALL
- INTERSECT and EXCEPT
- Merging data from multiple sources
10Sub-queryQueries in Queries5 lessons
- Sub-query in WHERE
- Sub-query in FROM
- Correlated sub-query
- EXISTS
- IN, EXISTS or JOIN?
11Common Table ExpressionsAnalyzes step by step4 lessons
- WITH: the first CTE
- Chaining several CTEs
- Readable analyzes in steps
- Recursive CTE: a calendar
12Window FunctionsArithmetic across lines8 lessons
- OVER: open the window
- PARTITION BY
- ROW_NUMBER, RANK and DENSE_RANK
- Current totals
- LAG and LEAD
- Moving average
- Share of total value
- NTILE: Forming groups
CBusiness analysesChapters 13–19
13Key figures and KPIWhat management wants to know4 lessons
- Sales, margin and shopping cart
- Customers are counting, but right
- A KPI report in a query
- Key figures per branch and channel
14Time series and trendsDevelopment over time5 lessons
- Evaluate by month and quarter
- Previous year's comparison
- Calculate growth rates
- Recognize seasonality
- Fill in the gaps in the calendar
15Ranking and ParetoThe most important first4 lessons
- Top-N per group
- Rank changes over time
- Pareto: the 80/20 rule
- ABC analysis in the range
16Customer analysisWho buys, who stays, who leaves?6 lessons
- New customers and regular customers
- Cohort analysis
- Measure customer loyalty
- RFM segmentation
- Customer value over time
- Recognize emigration
17Funnels and experimentsFrom visit to purchase4 lessons
- Understanding event data
- Building a funnel
- Conversion rates
- Evaluating an A/B test
18Plan and IsDeviations in the handle3 lessons
- Budget against Is
- Absolute and relative deviation
- Traffic light report with SQL
19Data qualityTrust in the numbers5 lessons
- Find duplicates
- Missing values
- Recognize outliers
- Plausibility checks
- Sanify data with UPDATE
DPracticeChapters 20–23
20Change and model dataCreate and maintain tables7 lessons
- CREATE TABLE and data types
- INSERT: Insert data
- UPDATE and DELETE safely insert
- Transactions
- Normalization simply explained
- Indices and speed
- Views: saved queries
21SQL in everyday workWith other tools5 lessons
- SQL and Excel
- SQL and Python
- SQL and BI tools
- AI as SQL Assistant: useful, but check
- Data protection for data queries
22Case studiesApply what you have learned4 lessons
- Monthly report sales
- Warehouse handling and shopkeeper
- Personnel: fluctuation and absences
- Evaluate marketing campaign
23ConclusionYour SQL Toolbox4 lessons
- The analysis process in seven steps
- Interview SQL Tasks
- Final project
- What's next?
Eight exercise types
You write the query yourself; the app checks the result.
Repair a broken query, just like at work.
What does this query return? Think first, then check.
Sort terms, commands or cases into the right group.
Connect tasks with the matching SQL building block.
Find logic errors in an analysis, such as double-counted rows.
Put an analysis into the right order.
Complete a query with the right building blocks.
Editor, schema and cheat sheet
An editor with a symbol bar, result table and readable error messages, made for keyboard and touchscreen.
Look up tables, columns and relationships at any time without leaving the exercise.
A short syntax summary for every lesson, for looking things up and revising.
Role plays, tests, certificate
Every chapter ends with a practical project, a role play and a chapter test. In the role play you are a data analyst at Alpina Outdoor AG answering questions from a management team that has little time. Once everything is done, the final exam unlocks (50 questions, 75 minutes, pass mark 80 percent). The certificate "Certified SQL Data Analyst" is a learning record of this app, not an officially recognised qualification.
Privacy
Buy once: no subscription, no ads, no account. The app collects no data and contains no tracking. All lessons, exercises and the database are inside the app. Only the lesson videos are loaded from sql.babala.ch when needed. Privacy policy
FAQ
Does the app work offline?
Yes. Lessons, database, exercises, quizzes and role plays are inside the app. Only the lesson videos need a connection.
Do I need an account?
No. You open the app and start. Your progress stays on your device.
Is there a subscription?
No. You buy the app once, with no subscription and no ads.
Which language are the videos in?
The videos are in English in every app language. Lessons, exercises and explanations are in your language.
Which SQL dialect do I learn?
SQLite. It is built into every iPhone and covers almost everything data analysis needs. Where MySQL, PostgreSQL or SQL Server work differently, the course explains the differences.
Who is the course for?
For everyone who works with data or wants to: office, controlling, marketing, studies. No prior knowledge is needed.
Support
Questions, ideas or a mistake in a lesson? Write to us. info@babala.ch · babala.ch