| Course title | Database Systems in Practice |
|---|---|
| Course code | KI/PDSY |
| Organizational form of instruction | Seminary |
| Level of course | Bachelor |
| Year of study | not specified |
| Semester | Summer |
| Number of ECTS credits | 2 |
| Language of instruction | Czech |
| Status of course | Compulsory-optional |
| Form of instruction | unspecified |
| Work placements | unspecified |
| Recommended optional programme components | None |
| Lecturer(s) |
|---|
|
| Course content |
|
1. Database design. 2. DDL commands. 3. DML commands. 4. Agregational functions, tables, views 5. Reference integrity, domain integrity, entity integrity. 6. Object-oriented extension of design. 7. Access rights. 8. Transactions, locking. 9. Optimization of SQL queries.
|
| Learning activities and teaching methods |
| unspecified |
| Learning outcomes |
|
Aim of this course is to extend theoretical and mostly practical skills oriented to database systems creation. Emphasis is put on concrete design of database on a selected platform (i.e. MS Access, MySQL, MS SQL server).
|
| Prerequisites |
|
unspecified
|
| Assessment methods and criteria |
|
unspecified
|
| Recommended literature |
|
| Study plans that include the course |
| Faculty | Study plan (Version) | Category of Branch/Specialization | Recommended semester | |
|---|---|---|---|---|
| Faculty: Faculty of Science | Study plan (Version): Information Sciences (double subject) (A14) | Category: Informatics courses | - | Recommended year of study:-, Recommended semester: - |
| Faculty: Faculty of Science | Study plan (Version): - (A14) | Category: Informatics courses | - | Recommended year of study:-, Recommended semester: - |
| Faculty: Faculty of Science | Study plan (Version): Information Sciences (double subject) (A14) | Category: Informatics courses | - | Recommended year of study:-, Recommended semester: - |