Logo

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

"Databases"

 предметы

 WEB | NET | SYS | DBS | SEC 

 Lectures  Labworks  Library 

LECTURES

Syllabus

LS-00EN. Databases - Syllabus 2021.

Due to the 3th wave of COVID-19, lectures will be held remotely via Zoom
from 11.10.2021 to 31.12.2021.

For lectures in Zoom, you need a computer or tablet (at least a smartphone) with the Internet, preferably with a microphone (a camera is not required). How to master Zoom:

  1. Install Zoom for your system;
  2. Look Zoom Joining & Configuring Audio & Video;
  3. Testing your internet connection for Zoom;
  4. Connect to the lecture in Zoom by entering your Name-Surname and passcode: you know what.

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 & Exam

IT ACADEMY Online Testing System (.htm).

Top

dbs

Lectures | Labworks | Library | Contacts 

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

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

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

Bottom