SQL-Courses-2026

SQL introduction courses – AMSE 2025/26

SQL introduction course, first part of the UE "Programming for data science", 5 sessions <-> 5 notebooks.

S1 - SQL basics (part 1)

notebook #1

• definitions and principles of relational models
• entities relationships diagram (ERD)
• database management systems (DBMS)
• introduction to SQLite
• SELECT … FROM, DISTINCT, LIMIT, etc.
• COUNT(), SUM(), AVG(), etc.
• WHERE, BETWEEN, LIKE, IS NOT, etc.
• GROUP BY, ORDER BY, HAVING, etc.

S2 - SQL basics (part 2)

notebook #2

• PRAGMAS
• CREATE TABLE, INSERT INTO, VALUES, etc.
• import .csv into DB, pandas.DataFrame.to_sql(), pandas.read_sql(), etc.
• UPDATE, DELETE, DROP
• UNION
• string functions
• datetime functions
• joins
• CASE WHEN, WITH,
• windows functions, OVER

S3 - exercises corrected (S1 & S2)

Empty notebook (with questions)

S4 - exercises

• Exercise a : orders (+ some notes about ALTER TABLE and CRUD)
• Exercise b : hospitals (recap). Correction.