Курс по базам данных



Краткое описание курса

Overview: During this course, you will receive theoretical knowledge about databases world and practical experience in designing and programming database level objects and business requirements. All course long, lecturer would provide multiple real project use case examples based on his 10 years’ experience working with largest enterprise level ERP systems.
Level: Beginner
Tools: Oracle XE database, SQL developer, GitHub account. Student could proceed with his/her own preferred relational database and development IDE. GitHub account is needed only if student would like to contribute outside course hours with homework activities checked by a lecturer.
Audience: Students, business analysts and web developers interested in databases.
Language: Russian – main, English and Latvian by a need.


Подробная программа курса


Introduction lection. Discussion about course content, structure, used tools. Main topics: what
is a database, where it is used, and what kind of databases exist. Roles description – who are
database administrators, database developers and consultants. – 1.5h
Relation model and basic database objects introduction (tables, columns, datatypes).
Explanation how to design a database model in scope of e-shop example. – 1.5h
Homework: Imagine a system you are planning to develop where relational database should
exist (e-shop, ERP, CRM, …). Draw a database design picture and put it to your github account.
Install course required tools and a database.

Common issues with published GitHub homework discussion. – 0.5h
Relation model and database objects introduction part 2. Security with grants and synonyms. –1.5h
Purpose of DDL (data definition language) explanation. (CREATE, DROP, ALTER, TRUNCATE, COMMENT, RENAME). – 1h
Homework: Implement your designed system DB model using CREATE DDL command. Play with drop, alter, truncate, and re-name commands. Put scripts used to your GitHub account.

Common issues with published GitHub homework discussion. – 0.5h

DML (data manipulation language) commands introduction (SELECT, INSERT, UPDATE, DELETE).
DCL (data control language) commands introduction (GRANT, REVOKE).
TCL (transaction control language) commands introduction (COMMIT, ROLLBACK, SAVEPOINT) – 1.5h
Explanation the way data could be imported to a database (sql*loader, excel loading with tools
features) – 1h
Homework: Fill your designed system tables with actual data. Play with inserts, update, delete
statements. Put scripts to GitHub.

Common issues with published GitHub homework discussion. – 0.5h
SQL language introduction part 1. Learn how to join tables, filter data, group data… — 2.5h
Homework: Lecturer would provide 10 tasks within learned SQL topics. Prepare queries, test
them with your database and publish to GitHub account.

Common issues with published GitHub homework discussion. – 0.5h
SQL language introduction part 2 (more advanced features). Usage of more complex conditions,
like regexp. – 2.5h
Homework: Lecturer would provide 10 tasks within learned more advanced SQL topics. Prepare
queries, test them with your database and publish to GitHub account.

Common issues with published GitHub homework discussion. – 0.5h
Queries performance measurement principles. Indexation and queries optimizations. -1.5h
Introduction to main database issues, like db locks. – 1h
Homework: Measure lecture 4 and lecture 5 developed views performance create indexes.
Scripts publish to GitHub account.

Common issues with published GitHub homework discussion. – 0.5h
PL/SQL programming language introduction for implementing business logic on a database level
part 1. — 2.5h

Homework: Lecturer would provide a task describing business logic needed to be implemented
in a database using pl/sql and stored procedures/functions way. Implement needed
requirements to your database, put code to GitHub.

Common issues with published GitHub homework discussion. – 1h
PL/SQL programming language introduction for implementing business logic on a database level
part 2 (theory part)– 1h
Working with a code and implementing more logic to your database packages based on lecturer
provided requirements. – 1h.
In addition, concurrency principle could be discussed.
Homework: none

Introduction how application developers (Java or .NET) see a database through ORM on a
hibernate example. Lecturer will show how database is used using simple spring boot
application with ORM defined classes and simple CRUD operations using REST calls. Thinking in
object-oriented way. -3h
Homework: Download project provided by a lecturer, modify code based on your table
structures and play with your application by running REST calls. Put your code version to
GitHub.

Ending lecture.
Common issues with published GitHub homework discussion. – 0.5h
PL/SQL APIs for external usage. Data integration using a database way. – 1h
Introduction into Enterprise Level database oriented systems on an Oracle ERP application
example. -1h
Diplomas and final word – 0.5h

Introduction To Databases

Язык: русский
Начало: 05.10.2019
Время: 11:00 — 14:00
День недели: Суббота
Продолжительность: 3 месяца
Цена: 130 Euro/месяц
Адрес: Сколас 21

  • 05.10.2019
  • 12.10.2019
  • 19.10.2019
  • 26.10.2019
  • 02.11.2019
  • 09.11.2019
  • 16.11.2019
  • 23.11.2019
  • 30.11.2019
  • 07.12.2019

Заинтересовал курс?

Оставь информацию о себе и мы с тобой свяжемся!