290 : Querying and modifying databases

Literature

Modulidentifikation: M290
W3School-MySQL-Tutorial
MySQL.com-Documentation

Learning material content

The content of this modul is taught in learning units:

LU01 - Modul introduction & administration
LU02 - Exams (LB1, LB2, LB3)
LU03 - Database basics & technical terms
LU04 - RDB: concept & notation (ERM, ERD)
LU05 - W3School Learning Material
LU06 - SQL | DQL commands in MySQL
LU07 - SQL | DDL commands in MySQL
LU08 - SQL | DML commands in MySQL
LU09 - SQL | DCL commands in MySQL
LU10 - Node Server
LU11 - CRUD-Requests via frontend simulation with Postman App
LU12 - FAQs (Troubleshooting)