Introduction to SQL

- Relational databases: Terms, database design, entity sets and relations, data modelling, normalisation, referential integrity, indexes - Command group DDL (Data Definition Language): Creating databases and tables / relations (CREATE) - Data definitions - Editing tables - Key fields and indexes - Command group DML (Data Manipulation Language): Creating (INSERT), changing (UPDATE), deleting (DELETE) data sets - Command group DQL (Data Query Language): Querying data (SELECT), defining conditions (WHERE, HAVING), sorting (ORDER BY) and grouping (GROUP BY) results, functions in queries, cross-table queries / joining tables (JOIN) - Views - Command group DCL (Data Control Language): Security concepts - Creating users - Assigning access rights, transaction management (START TRANSACTION, SAVEPOINT, COMMIT, ROLLBACK)