Skip to content
Edition NigeriaGlobal
Country: Serbia

You are in the Serbia edition. Type your country to switch.

Set up your profile

You are learning in the Serbia edition, with examples in dinars and from Serbia.

Beginner path · Free course

Data skills: SQL and Python basics

Data skills for non-programmers: how tables, rows and keys work, SQL from SELECT and WHERE to GROUP BY and JOIN on a small sales table, Python variables, lists and loops, pandas basics and a first chart, and how to use AI as a coding partner by reading, testing and fixing its code.

  • Beginner level
  • 7 lessons
  • 1 hour of study
  • 1 final test
  • $3 certificate
  • Serbia edition

Education, not advice: this course explains how products and rules work. It does not recommend any product, trade or provider.

Start the free courseSign in with your free Stockertim account to enrol.

What you will learn

  • By the end you can describe a table in terms of rows, columns and data types.
  • By the end you can write a query that chooses columns with SELECT and rows with WHERE.
  • By the end you can summarise a whole table with COUNT, SUM and AVG.
  • By the end you can join two tables on a shared key and read the result.
  • By the end you can create variables and say which type of value each holds.
  • By the end you can load a CSV file into pandas and take a first look at it.
  • By the end you can write a clear request for SQL or Python code to a chat assistant.

Skills you will practise

Syllabus

7 lessons · about 1 hour · a short test after every step, a quiz after every lesson and one final test.

  1. How data is organised: tables, rows, columns and keysAlmost all business data lives in tables: one row per thing, one column per fact about it. This lesson explains rows, columns, data types, primary an… 11 min · 6 steps
    1. Why almost all data is a table
    2. Meet the example tables
    3. Columns have data types
    4. Primary keys and foreign keys
    5. One fact, one place
    6. Tables as plain text: CSV files
    7. Lesson quiz
  2. SQL basics: SELECT, WHERE and ORDER BYSQL is the language for asking questions of tables. This lesson writes your first queries on a small example sales table: choosing columns with SELEC… 10 min · 6 steps
    1. Your first query
    2. Filtering rows with WHERE
    3. Combining conditions: AND, OR and IN
    4. BETWEEN, LIKE and missing values
    5. Sorting with ORDER BY and taking the top few
    6. Common slips and how to check your answer
    7. Lesson quiz
  3. Summarising with SQL: GROUP BY, COUNT, SUM and AVGSummaries turn many rows into a few answers: how many orders, how many units, how much revenue per region. This lesson covers COUNT, SUM and AVG, gro… 9 min · 6 steps
    1. Summing up a whole table
    2. One row per group with GROUP BY
    3. Averages and what they hide
    4. WHERE filters rows, HAVING filters groups
    5. The order a query is read in
    6. Checking a summary before you share it
    7. Lesson quiz
  4. Joining tables: SQL JOIN for beginnersA join brings facts from two tables together using a shared key. This lesson joins the example sales table to products and regions, compares inner an… 9 min · 5 steps
    1. Why tables need joining
    2. Inner join and left join
    3. Finding rows with no match
    4. Joining a third table
    5. When a join duplicates rows
    6. Lesson quiz
  5. Python basics: variables, lists, loops and functionsPython is a readable programming language that many analysts use alongside SQL. This lesson covers variables and types, lists and dictionaries, loops… 9 min · 6 steps
    1. Variables and types
    2. Lists: many values in order
    3. Loops and decisions
    4. Dictionaries: look-ups by key
    5. A small function
    6. Reading an error message
    7. Lesson quiz
  6. pandas basics and a first chartpandas is a Python library that handles whole tables at once. This lesson reads the example sales file, looks at it, filters rows, groups and totals … 9 min · 6 steps
    1. Loading a file and looking at it
    2. Columns and a calculated column
    3. Filtering rows
    4. Grouping and joining
    5. A first chart, saved as an image
    6. Two tools, one answer
    7. Lesson quiz
  7. AI as a coding partner: read, test and fix its codeA chat assistant can write SQL and Python in seconds, but it can also be confidently wrong. This lesson shows how to ask for code well, read it line … 12 min · 6 steps
    1. Asking for code well
    2. Reading the code line by line
    3. Testing on a known answer
    4. The four errors to look for
    5. Fixing it, with or without the assistant
    6. Keeping data safe
    7. Lesson quiz

Final test

A fresh set of questions drawn from every lesson of this course, timed, with the options in a new order every time. You need 85% to pass, and passing earns your certificate.

Enrol to unlock the final test.

English