Logo ČVUT
CZECH TECHNICAL UNIVERSITY IN PRAGUE
STUDY PLANS
2024/2025

Database 2

The course is not on the list Without time-table
Code Completion Credits Range Language
818DTB2 KZ 2 2C Czech
Vztahy:
In order to register for the course 818DTB2, the student must have registered for the course 818DTB1 in a previous semester.
Garant předmětu:
Lecturer:
Tutor:
Supervisor:
Department of Software Engineering
Synopsis:

The course „Database 2“ is devoted to the SQL language. Students will learn the basic SQL commands (creating tables, inserting/updating and deleting data), the various options for selecting data (including aggregation) and creating views. Students will also learn about programming on the database system side (triggers, stored procedures).

Requirements:
Syllabus of lectures:
Syllabus of tutorials:

1. Database languages and their divisions. Basic data types, constants and operators in SQL. Creating domains.

2. Creating tables including foreign keys. Inserting, updating and deleting data in a table.

3-6. Selecting data from tables: general SELECT statement syntax, joining tables, conditions, aggregation functions. Unifying tables using UNION.

7. Subqueries.

8.-9. Views.

10.-11. Transactions. Triggers and stored procedures.

12.-13. Summary examples (database implementation).

Study Objective:
Study materials:
Note:
Further information:
No time-table has been prepared for this course
The course is a part of the following study plans:
Data valid to 2024-06-16
Aktualizace výše uvedených informací naleznete na adrese https://bilakniha.cvut.cz/en/predmet7606906.html