| Dozent/in |
Dr. Nicolas Attalides |
| Veranstaltungsart |
Workshop |
| Code |
HS261723 |
| Semester |
Herbstsemester 2026 |
| Durchführender Fachbereich |
Diverse |
| Studienstufe |
Master
Doktorat |
| Termin/e |
Fr, 04.12.2026, 09:30 - 16:30 Uhr
Sa, 05.12.2026, 09:30 - 16:30 Uhr
Sa, 12.12.2026, 09:30 - 16:30 Uhr |
| Umfang |
Blockveranstaltung |
| Inhalt |
The SQL language provides a standardised way to work with structured data across virtually every field, from business reporting to scientific research. Whether you’re querying millions of rows in a data warehouse or building reproducible analysis pipelines, SQL remains the go-to tool for reliable, high-performance data management and is a key skill that is used in data science, analytics, and engineering.
This course focuses on introducing the participants to the core concepts and techniques of SQL through practical hands-on exercises on realistic datasets.
|
| Lernziele |
The course is structured to cover the following topics:
• Relational fundamentals: What a database is, the relational model, tables, and keys
• Create, modify, and delete tables; define columns and data types
• Insert, update, and delete records
• Basic querying: Retrieve data, compute new columns, and work with dates
• Filter data, sort data and deal with missing values
• Aggregations and grouping in SQL
• Merge information across two or more tables by performing joins (inner, left/right outer, etc.)
• Build subqueries, Common Table Expressions (CTEs), and apply window functions
|
| Voraussetzungen |
No prior knowledge of SQL is required. Depending on time we might use SQL within R. No prior knowledge of R programming or RStudio is required.
Participants should have their own laptop with an internet connection. |
| Sprache |
Englisch |
| Begrenzung |
Only Master or doctoral students (postdoctoral researchers can sign up via lumacss@unilu.ch). Priority for LUMACSS students if there are too many registrations. |
| Anmeldung |
***Important*** To earn credits, you must register for the course via UniPortal. Registration is open from two weeks before to two weeks after the start of the semester. You can withdraw from the course after this period by notifying the lecturer and lumacss@unilu.ch. You can find the registration details here: http://www.unilu.ch/ksf/semesterdaten |
| Leistungsnachweis |
There is no examination. Participants are expected to actively engage in the hands-on components of the workshop. Successful participation is awarded 1.5 ECTS. |
| Abschlussform / Credits |
Bestätigte Teilnahme / 1.5 Credits
|
| Hörer-/innen |
Nein |
| Kontakt |
lumacss@unilu.ch |
| Material |
The course material and any necessary data as well as instructions for the technical setup will be circulated by the instructor via e-mail before the (first session of the) course. Code and solutions to exercises will be circulated by the instructor after the course. |