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 iPad
23chapters in 4 course parts
119lessons with a video
357automatically checked exercises
1182quiz questions
46role plays and practical projects
9languages

A 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)

branches (8)employees (70)absences (169)categories (10)products (48)campaigns (7)customers (2’196)orders (7’405)order_items (14’705)inventory (319)budget (240)web_events (11’833)

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
  1. This is how this course works
  2. What is a database?
  3. Tables, rows, columns
  4. The practice database: a Swiss trading company
  5. Your first query
  6. SQL dialects: SQLite, MySQL, PostgreSQL, SQL Server
02SELECT: Query dataThe most important instruction6 lessons
  1. SELECT and FROM
  2. Select and rename columns
  3. DISTINCT: remove duplicate values
  4. Arithmetic in the query
  5. LIMIT: only the first lines
  6. Readable SQL style and comments
03Filter with WHEREOnly the lines that count6 lessons
  1. WHERE and comparison operators
  2. AND, OR and NOT
  3. IN and BETWEEN
  4. LIKE and search pattern
  5. NULL: the missing value
  6. Typical filter errors
04SortOrder in the results5 lessons
  1. ORDER BY
  2. Sort by multiple columns
  3. Top-N queries
  4. NULL values in sorting
  5. Page by page with OFFSET
05Text, number, and date featuresTransform values6 lessons
  1. Text Functions
  2. Round and format numbers
  3. Date and time
  4. Year, month and day of the week
  5. Convert data types with CAST
  6. COALESCE and NULLIF
06Conditions with CASEIf, then, otherwise4 lessons
  1. CASE WHEN understand
  2. Form categories
  3. CASE in calculations
  4. Traffic light logic for reports

BSummarising and joiningChapters 7–12

07Aggregate and GroupFrom lines to key figures7 lessons
  1. COUNT, SUM, AVG, MIN, MAX
  2. GROUP BY
  3. Group by multiple columns
  4. HAVING: Filter groups
  5. WHERE or HAVING?
  6. Conditional aggregation
  7. Case study: Key figures at a glance
08Connect tables with JOINData from multiple tables8 lessons
  1. Why multiple tables?
  2. Primary and external key
  3. INNER JOIN
  4. LEFT JOIN
  5. Find datasets without partners
  6. Connect three and more tables
  7. Self-Join
  8. Double lines after the JOIN
09Volume operationsCombine results3 lessons
  1. UNION and UNION ALL
  2. INTERSECT and EXCEPT
  3. Merging data from multiple sources
10Sub-queryQueries in Queries5 lessons
  1. Sub-query in WHERE
  2. Sub-query in FROM
  3. Correlated sub-query
  4. EXISTS
  5. IN, EXISTS or JOIN?
11Common Table ExpressionsAnalyzes step by step4 lessons
  1. WITH: the first CTE
  2. Chaining several CTEs
  3. Readable analyzes in steps
  4. Recursive CTE: a calendar
12Window FunctionsArithmetic across lines8 lessons
  1. OVER: open the window
  2. PARTITION BY
  3. ROW_NUMBER, RANK and DENSE_RANK
  4. Current totals
  5. LAG and LEAD
  6. Moving average
  7. Share of total value
  8. NTILE: Forming groups

CBusiness analysesChapters 13–19

13Key figures and KPIWhat management wants to know4 lessons
  1. Sales, margin and shopping cart
  2. Customers are counting, but right
  3. A KPI report in a query
  4. Key figures per branch and channel
14Time series and trendsDevelopment over time5 lessons
  1. Evaluate by month and quarter
  2. Previous year's comparison
  3. Calculate growth rates
  4. Recognize seasonality
  5. Fill in the gaps in the calendar
15Ranking and ParetoThe most important first4 lessons
  1. Top-N per group
  2. Rank changes over time
  3. Pareto: the 80/20 rule
  4. ABC analysis in the range
16Customer analysisWho buys, who stays, who leaves?6 lessons
  1. New customers and regular customers
  2. Cohort analysis
  3. Measure customer loyalty
  4. RFM segmentation
  5. Customer value over time
  6. Recognize emigration
17Funnels and experimentsFrom visit to purchase4 lessons
  1. Understanding event data
  2. Building a funnel
  3. Conversion rates
  4. Evaluating an A/B test
18Plan and IsDeviations in the handle3 lessons
  1. Budget against Is
  2. Absolute and relative deviation
  3. Traffic light report with SQL
19Data qualityTrust in the numbers5 lessons
  1. Find duplicates
  2. Missing values
  3. Recognize outliers
  4. Plausibility checks
  5. Sanify data with UPDATE

DPracticeChapters 20–23

20Change and model dataCreate and maintain tables7 lessons
  1. CREATE TABLE and data types
  2. INSERT: Insert data
  3. UPDATE and DELETE safely insert
  4. Transactions
  5. Normalization simply explained
  6. Indices and speed
  7. Views: saved queries
21SQL in everyday workWith other tools5 lessons
  1. SQL and Excel
  2. SQL and Python
  3. SQL and BI tools
  4. AI as SQL Assistant: useful, but check
  5. Data protection for data queries
22Case studiesApply what you have learned4 lessons
  1. Monthly report sales
  2. Warehouse handling and shopkeeper
  3. Personnel: fluctuation and absences
  4. Evaluate marketing campaign
23ConclusionYour SQL Toolbox4 lessons
  1. The analysis process in seven steps
  2. Interview SQL Tasks
  3. Final project
  4. What's next?

Eight exercise types

1
Write a query

You write the query yourself; the app checks the result.

2
Fix the query

Repair a broken query, just like at work.

3
Predict the result

What does this query return? Think first, then check.

4
Classify

Sort terms, commands or cases into the right group.

5
Match

Connect tasks with the matching SQL building block.

6
Spot the errors

Find logic errors in an analysis, such as double-counted rows.

7
Order the steps

Put an analysis into the right order.

8
Fill the gaps

Complete a query with the right building blocks.

Editor, schema and cheat sheet

1
SQL editor

An editor with a symbol bar, result table and readable error messages, made for keyboard and touchscreen.

2
Schema viewer

Look up tables, columns and relationships at any time without leaving the exercise.

3
Cheat sheet

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

</>
Babala Software Netzwerk — Apps, Websites & KI-Lösungen aus Füllinsdorf BL
© 2026 Babala Özdemir · UID CHE-322.105.560 babala.ch info@babala.ch 076 792 63 50 Facebook Instagram