Logo ČVUT
CZECH TECHNICAL UNIVERSITY IN PRAGUE
STUDY PLANS
2023/2024
UPOZORNĚNÍ: Jsou dostupné studijní plány pro následující akademický rok.

Database 2

Login to KOS for course enrollment Display 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:
Josef Nový
Lecturer:
Josef Nový
Tutor:
Josef Nový
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:
Time-table for winter semester 2023/2024:
Time-table is not available yet
Time-table for summer semester 2023/2024:
Time-table is not available yet
The course is a part of the following study plans:
Data valid to 2024-05-27
Aktualizace výše uvedených informací naleznete na adrese https://bilakniha.cvut.cz/en/predmet7606906.html