SQL Training, Conceptual Data Modeling
Introduction to SQL training
Definition of a database
Definition of a Database Management System
Define a relational model
Presentation of different SQL languages: LID, DML, LDD
Module 1: Course on LID
SELECT FROM
SELECT WHERE
SELECT ORDER
SELECT LIMIT
SELECT EXPR …
SELECT FROM JOIN
SELECT AGGR GROUP
SELECT AGGR GROUP HAVING
Module 2: Course on data manipulation (LMD)
Beginning of the DML
INSERT
INSERT SELECT
MULTI TABLE INSERT
UPDATE
UPDATE MULTI TABLE
DELETE
DELETE MULTI TABLE
Module 2: Course on the Basics of Data Definition (DDL)
CREATE TABLE
DROP TABLE
ALTER TABLE
Module 3: Theory
Indexes and types of indexes
FK constraints
Basic modeling, explanation of normal forms 1, 2 and 3
Natural key versus complex key