LECTURES

Syllabus

LS-00EN. Databases - Syllabus 2024.

Online consultation in BBB, Tuesday 19:00-20:30 (login to ISMA Moodle and select Join session).

Lecture Slides

1. DATABASES OVERVIEW

LS-01EN. Database Management System (DBMS) Introduction.

LS-02ENa. Databases History.

LS-02ENb. Traditional and NoSQL Database Models.

1. Look. Seven Database Paradigms. [video 10 min]

2. DATA MODELING & DATABASE DESIGN

LS-03EN. Database Development Life Cycle. Subject Area Analysis.

LS-04EN. Conceptual Database Design. Entity Relationship Diagram (ERD).

1. Read. What is Entity Relationship Diagram (ERD)? [link]
2. Look. Entity Relationship Diagram (ERD) Tutorial - Part 1. [video 7 min]
3. Look. Entity Relationship Diagram (ERD) Tutorial - Part 2. [video 14 min]

LS-05EN. Logical Database Design. Relation Data Model (RDM). Relation Algebra.

LS-05ENa. Relation Algebra and Calculus.

LS-06EN. Mapping ER Diagrams to Relation Data Model.

LS-06ENa. RDM Best Practices. Naming Convention. Data Dictionary. Data Types. Constraints. Indexes.

LS-07EN. RDM Normalization. Data Anomalies. Functional Dependency. Normal Forms.

LS-07ENa. Data Normalization.

1. Look. Normalization - 1NF, 2NF, 3NF and 4NF. [video 19 min]

3. SQL DDL BASICS

LS-08EN. SQL Overview. SQL DDL. Data Types.

1. Read. MySQL Data Definition Statements: CREATE/ALTER/DROP for DATABASE/TABLE.
2. Look. MySQL CREATE TABLE. [video 13 min]
3. Look. MySQL ALTER TABLE. [video 10 min]
4. Look. MySQL DROP TABLE. [video 3 min]
5. Look. MySQL Numeric Data Types. [video 6 min]
6. Look. MySQL String & Binary Data Types. [video 9 min]
7. Look. MySQL Date & Time Data Types. [video 5 min]
8. Look. MySQL Enum Data Type. [video 5 min]

LS-09EN. SQL DDL. Database Integrity Constraints.

1. Look. MySQL FOREIGN KEY Constraints. [video 7 min]
2. Look. MySQL TRIGGERS. [video 10 min]

4. SQL DML BASICS

LS-10EN. SQL DML. INSERT, UPDATE, DELETE, SELECT Statements Overview.

1. Look. MySQL INSERT Statements. [video 9 min]
2. Look. MySQL UPDATE Statements. [video 7 min]
3. Look. MySQL DELETE Statements. [video 6 min]
4. Look. MySQL SELECT Statements. [video 15 min]
5. Read. MySQL Numeric Function Documentation. [link]
6. Look. MySQL Numeric Functions. [video 9 min]
7. Read. MySQL String Function Documentation. [link]
8. Look. MySQL String Functions. [video 11 min]

LS-11EN. SQL DML. SELECT Constructions 1.

1. Look. MySQL SELECT Statements. WHERE, ORDER BY. [video 15 min]
2. Look. MySQL Filtering with BETWEEN. [video 4 min]
3. Look. MySQL Filtering with IN vs Equals. [video 5 min]

5. SQL DML EXTENDED

LS-12EN. SQL DML. SELECT Constructions 2.

1. Read. MySQL Aggregate Function Documentation. [link]
2. Look. MySQL Aliasing. [video 8 min]
3. Look. MySQL GROUP BY. [video 9 min]
4. Look. MySQL Aggregate Functions. [video 7 min]

LS-13EN. SQL Joining Multiple Tables.

1. Look. MySQL UNION Statements. [video 6 min]
2. Look. MySQL Subqueries. [video 7 min]
3. Look. MySQL INNER JOINs. [video 10 min]
4. Look. MySQL LEFT, RIGHT, SELF JOINs. [video 11 min]
5. Look. MySQL Multiple JOINs. [video 16 min]

LS-14EN. SQL Views.

1. Look. MySQL CREATE VIEW. [video 9 min]

LS-15EN. SQL TCL. Transactions.

6. DBMS EFFICIENCY

LS-16EN. DBMS Efficiency. Storage and Indexing.

LS-16ENa. DBMS Efficiency. Indexing. Tuning.

1. Look. MySQL Using Indexes. [video 15 min]

7a. ADDITIONAL LECTURES on EN

7b. ДОПОЛНИТЕЛЬНЫЕ ЛЕКЦИИ на RU

7c. PAPILDU LEKCIJAS par LV

Datubāzes iesācējiem - datubazes.wordpress.com
SQL pamati - datubazes.wordpress.com

Top

Quizzes, Exercises & Exam

Pre-Exam Practice Testing

Отчётности перед экзаменом (PDF 67 KB).

IT ACADEMY Online Testing System (.htm).