LAB WORKS & SOFTWARE

• Lab Works
• Practice Works
• Home Works
• Softwares

Lab Works

I. Conceptual DB Design.

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

• LW-01EN. Report Blank Form.


• 0. Read. ERD Introduction. [pdf]
• 1. Soft. Draw.io [online]
• 2. Look. Draw.io - Creating ERD. [video 11 min]
• 3. Look. Draw.io - Creating ERD from SQL. [animation]
• 4. Look. Draw.io - ERD Example
• 5. Soft. LucidChart [online]
• 6. Look. LucidChart - ER diagram Tool [topic]
• 7. Look. LucidChart - ERD Example
• 8. Soft. VisualParadigm Online ERD Tool [online]

II. Logical DB Design.

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

• LW-02EN. Report Blank Form.


• 1. Look. Convert ERD to RDM on draw.io. [video 11 min]
• 2. Soft. DbDesigner.net - design RDM and generate SQL script for SQLite, MySQL, MSSql, Oracle.
  
• 3. Read. DBDesigner Support
  

III. Physical DB Design.

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

• LW-03EN. Report Blank Form.


• 1. Soft. XAMPP Stack - Apache+MariaDB+PHP+Perl+phpMyAdmin.
• 2. Read. MySQL Client - Some Basic Operations with Command Line Client.
• 3. Read. MySQL Tutorial.
• 4. Soft. Db4free.net - free database hosting MySQL+phpMyAdmin.
• 5. Soft. Avardspace.com - free web hosting (MySQL+phpMyAdmin+CPanel+domain+LAMP+email+ZackyAppInstaller).
• 6. Soft. Paizer.io - online MySQL (Free).
• 7. Soft. RexTester.com - online MySQL (Free).Register
• 8. Adminer.org - online demo.

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-02EN. Report Blank Form.


• Complete next 8 Tutorials and 6 Quizzes on SQL Zoo Site (https://sqlzoo.net/):
0. SELECT basics Tutorial. (3 tasks + 7 quiz questions)
1. SELECT names Tutorial. (15 tasks + 0 quiz questions)
2. SELECT from WORLD Tutorial. (13 tasks + 7 quiz questions)
3. SELECT from Nobel Tutorial. (14 tasks + 7 quiz questions)
4. SELECT within SELECT Tutorial. (10 tasks + 7 quiz questions)
5. SUM and COUNT Tutorial. (8 tasks + 8 quiz questions)
6. The JOIN operation Tutorial. (13 tasks + 7 quiz questions)
8+. Numeric Examples Tutorial. (8 tasks + 0 quiz questions)

• Register on SQL Zoo. (link)
• Video-instruction. Analysis for Wrong Answer. [video 3 min]
• Video-instruction. Solution Example for Select in Select Nr 5 Solution. [video 5 min]

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

• PW-03EN. Report Blank Form.


• SQL Exercises. DML: SELECT (learning stage). Make only 31 from 155 tasks.
• Интерактивный учебник по SQL Full (EN=RU) (link)
• Упражнения и Сертификация к Интерактивному учебнику по SQL (EN=RU) (link)
• Краткий Интерактивный учебник по SQL (EN=RU) (link)
• Схемы БД для Интерактивного учебника по SQL (EN=RU) (link)

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

• PW-04EN. Report Blank Form.


• SQL Exercises. DML: INSERT, UPDATE, DELETE. Make only 11 from 44 tasks.
• Интерактивный учебник по SQL Full (EN=RU) (link)
• Упражнения и Сертификация к Интерактивному учебнику по SQL (EN=RU) (link)
• Краткий Интерактивный учебник по SQL (EN=RU) (link)
• Схемы БД для Интерактивного учебника по SQL (EN=RU) (link)

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

• Without any Report.

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

• Without any Report.


• W3schools registration.
• 1. W3schools SQL Quiz. (25q/20min)
• 2. W3schools MySQL Quiz. (25q/20min)
• 3. W3schools SQL Exercises. (52 exercises in 16 groups)
• Make Your score ScreenShot.

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

• WWW SQL Designer [online] - similar to DbDesigner, but worse.
phpMyAdmin and Adminer
• phpMyAdmin [online] работа со своей БД mySQL на academy.lv.
• Adminer - Home Page. [link]
• Adminer [online] - работа со своей БД mySQL на academy.lv и визуальная разработка схемы БД (E-R диаграммы). Лёгкая замена для phpMyAdmin.
• Adminer - краткое описание. [link]
All Model in One APP
• MySQL Workbench [link] - инструмент для визуального проектирования, моделирования, создания и эксплуатации баз данных MySQL.
• MySQL Workbench for Mac [link] - инструмент для визуального проектирования, моделирования, создания и эксплуатации баз данных MySQL.

Server connection
• PuTTY 0.70 Portable [exe, 1.4 MiB]
• WinSCP 5.11.3 Portable [exe, 7.7 MiB]

Top