1

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