Logo

 компьютерные курсы для профи и новичков

"Databases"

 s u b j e c t s

 WEB | NET | SYS | DBS | SEC 

 Lectures  Labworks  Library  ExcaliDraw 

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.

2. DATA MODELING & DATABASE DESIGN

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

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

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.

3. SQL DDL BASICS

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

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

4. SQL DML BASICS

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

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

5. SQL DML EXTENDED

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

LS-13EN. SQL Joining Multiple Tables.

LS-14EN. SQL Views.

LS-15EN. SQL TCL. Transactions.

6. DBMS EFFICIENCY

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

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


7a. ADDITIONAL LECTURES on EN

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

7c. PAPILDU LEKCIJAS par LV

Top

Quizzes, Exercises & Exam

Pre-Exam Practice Testing


IT ACADEMY Online Testing System (.htm).

Top

Data Normalization Pray.
"The data depends on the key [1NF],
the whole key [2NF]
and nothing but the key [3NF].
So help me Codd!
Amen!"


dbs

dbs-design

Lectures | Labworks | Library | Contacts 

  (+371) 270-70-100
  info@academy.lv

Valid HTML 4.01 Transitional  Valid CSS 3!  Valid Links!    Яндекс.Метрика

© 1998-2024 IT.ACADEMY.LV  
All Rights Reserved  

Bottom