₹0 for students · Certificate · Beginner

Databases and SQL

10 lessons: query, filter, combine and create data with SQL

Start free in the app

10 lessons · ~4 hours · 20-question final exam · pass mark 70%

About the course

What you’ll learn

SQL is asked for in almost every data and backend job. Using a real field-survey database, learn to select, sort and filter records, calculate new values, handle missing data, aggregate, join tables, keep data tidy, create and modify tables, and run queries from Python. Each lesson has a study guide, the full Software Carpentry episode with exercises, and a quiz. Pass every quiz and the final exam to earn a verifiable certificate.

SQLSQLiteJoinsAggregationNULL handlingDatabase designPython sqlite3

Part of the career tracks: Web Developer, Data Analyst

How the certificate works

  1. Read each lesson’s study guide, then the full lesson and any notebooks or exercises.
  2. Pass every lesson quiz with 70% or more.
  3. Pass the final exam: 20 questions in 30 minutes.
  4. Get a certificate with a public verification link, and add it to LinkedIn.

Syllabus

10 lessons in 3 parts

Querying one table

1
Selecting Data
25 min · Relational databases store data in tables of columns (fields) and rows (records).
2
Sorting and Removing Duplicates
20 min · SELECT DISTINCT removes duplicate rows (whole-row combinations).
3
Filtering
25 min · WHERE filters rows by a condition.
4
Calculating New Values
20 min · Expressions in SELECT compute new values per row.

Combining and summarising

5
Missing Data
20 min · NULL means unknown, not zero or empty.
6
Aggregation
30 min · Aggregates: COUNT, SUM, AVG, MIN, MAX.
7
Combining Data with Joins
35 min · Tables are split to avoid repetition; joins recombine them.

Designing and using databases

8
Data Hygiene and Database Design
25 min · Atomic values: one piece of information per field.
9
Creating and Modifying Data
30 min · CREATE TABLE defines columns and types; DROP TABLE deletes a table.
10
Programming with Databases in Python
30 min · sqlite3: connect → cursor → execute → fetchall/fetchone → close.

Course content is derived from Software Carpentry's "Databases and SQL" lesson (https://swcarpentry.github.io/sql-novice-survey/), Copyright (c) The Carpentries (https://carpentries.org/), licensed under CC BY 4.0. Vikosha wrote new study guides and quiz questions; changes were made. Certificates are issued by Vikosha and are not issued or endorsed by The Carpentries. Licence: CC BY 4.0, Copyright (c) The Carpentries. View the original curriculum