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

Informatics 2

Login to KOS for course enrollment Display time-table
Code Completion Credits Range Language
155IN2G Z,ZK 5 2P+2C Czech
Garant předmětu:
Jan Pytel
Lecturer:
Jan Pytel
Tutor:
Jan Pytel
Supervisor:
Department of Geomatics
Synopsis:

In the course, students are introduced to the relational model, session normalization, integrity constraints, logical and physical database schema, conceptual schema, as well as database model design methodology, E-R diagrams and data flow diagrams.

Requirements:

no prerequisities

Syllabus of lectures:

Relational databases and SQL language - introduction and brief history

First introduction to SQL

JOIN conditions and clauses

ANSI JOIN, repetition and examples

Aggregation functions, merging gifts and sorting

Subqueries and derived tables

Recursive queries

Creating and editing tables

Database design, ER modeling, normalization

Syllabus of tutorials:

Relational databases and SQL language - introduction and brief history

First introduction to SQL

JOIN conditions and clauses

ANSI JOIN, repetition and examples

Aggregation functions, merging gifts and sorting

Subqueries and derived tables

Recursive queries

Creating and editing tables

Database design, ER modeling, normalization

Study Objective:

The aim of the course is to introduce students to database systems based on the relational database model and the Structured Query Language (SQL). Database design and work with databases are practically demonstrated using the PostgreSQL relational database.

Study materials:

:PostgreSQL, http://www.postgresql.org/docs

:SQLtutor, http://sqltutor.fsv.cvut.cz/

Note:
Further information:
https://geo.fsv.cvut.cz/gwiki/155IN2G_Informatika_2
Time-table for winter semester 2023/2024:
06:00–08:0008:00–10:0010:00–12:0012:00–14:0014:00–16:0016:00–18:0018:00–20:0020:00–22:0022:00–24:00
Mon
Tue
roomTH:B-870

08:00–09:50
(lecture parallel1
parallel nr.101)

Thákurova 7 (budova FSv)
B870
roomTH:B-870

14:00–15:50
(lecture parallel1
parallel nr.102)

Thákurova 7 (budova FSv)
B870
roomTH:C-208

12:00–13:50
(lecture parallel1)
Thákurova 7 (budova FSv)
C208
Wed
Thu
Fri
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-03-16
Aktualizace výše uvedených informací naleznete na adrese https://bilakniha.cvut.cz/en/predmet5630106.html