SubjectsSubjects(version: 945)
Course, academic year 2023/2024
   Login via CAS
Database SQL - AISV10075
Title: Databáze SQL
Guaranteed by: Institute of Information Studies and Librarianship (21-UISK)
Faculty: Faculty of Arts
Actual: from 2021
Semester: winter
Points: 2
E-Credits: 4
Examination process: winter s.:
Hours per week, examination: winter s.:0/2, C [HT]
Capacity: unknown / unknown (10)
Min. number of students: unlimited
4EU+: no
Virtual mobility / capacity: no
Key competences:  
State of the course: taught
Language: Czech
Teaching methods: full-time
Teaching methods: full-time
Level:  
Is provided by: AISPV3003
Note: course can be enrolled in outside the study plan
enabled for web enrollment
Guarantor: Ing. Jitka Novotná, Ph.D.
Annotation -
Last update: Ing. Jitka Novotná, Ph.D. (18.07.2022)
The course is part of the field of software engineering and its aim is to acquaint students with the basics of <br>
relational databases and data modeling.

Students will get acquainted with data modeling with the help of a SW tool and they will get acquainted with the
principle of three architectures, data integrity, relationship cardinality and data normalization. They will also work
with relational database and SQL query language (MySQL), they will get to know with commands for data definition
(DDL) and data manipulation language (DML). Emphasis is placed on practical practice of the subject matter on
specific examples.

For literature reference and information see Moodle.

 
Charles University | Information system of Charles University | http://www.cuni.cz/UKEN-329.html