Logo

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

"Databases"

 s u b j e c t s

 WEB | NET | SYS | DBS | SEC 

 Lectures  Labworks  Library  ExcaliDraw 

LAB WORKS & SOFTWARE

Lab Works

I. Conceptual DB Design.

LW-01EN. Creation ER Diagrams with Online CASE Tools.

II. Logical DB Design.

LW-02EN. Creation Relation Data Model with Online CASE Tools.

III. Physical DB Design.

LW-03EN. Creation MySQL Database on a XAMPP Stack or DBMS Hosting.
LW-03ENa. MySQL Command Line Client Exercises.

Top

Practice Works

IV. SQL Training Skill.

PW-01EN. SQL: Interactive Tutorial on SQL Bolt Site. (online)

  • Without any Report.

  • Complete 18 Lessons and 18 Exercises on SQL Bolt Site (https://sqlbolt.com/).

PW-02EN. SQL: Training Quizzes on SQL Zoo Site.

PW-03EN. SQL: Data Selection Practice on SQL Exercises Site.

PW-04EN. SQL: Data Modification Practice on SQL Exercises Site.

PW-05EN (Optional). Free Querys Training on SQL Tutorial Site. (online)

PW-06EN (Optional). SQL Quizzes and Exercises on w3schools Site (online).

Top

Home Works

HW-01,02,03,04,05EN. Relational Database Design. Guideline.

  • HW-01,02,03,04,05EN. Task Variants.

  • Names homework parties (you consistently solve one problem for all parts):
  • HW-01EN. Conceptual Database Design. Subject Area Analyze, ERD.
  • HW-02EN. Logical Database Design. Data Dictionary, RDM, Normalization.
  • HW-03EN. Physical Database Design. SQL DDL/DML: Create, Insert Design.
  • HW-04EN. SQL DML: Select Design.
  • HW-05EN (Optional). SQL DDL/DML: View, Update, Delete Design.
  • HW-06EN (Optional). Web Application Design for Databases.

Top

Softwares

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