Database SQL - AISPV3003

• Title: Databáze SQL (PVP3 - 2. ročník Bc.)
• Guaranteed by: Institute of Information Studies and Librarianship (21-UISK)
• Faculty: Faculty of Arts
• Actual: from 2021
• Semester: winter
• Points: 0
• E-Credits: 4
• Examination process: winter s.:
• Hours per week, examination: winter s.:0/2, C [HT]
• Capacity: unknown / unlimited (unknown)
• Min. number of students: unlimited
• 4EU+: no
• Virtual mobility / capacity: no
• State of the course: taught
• Language: Czech
• Teaching methods: full-time
• Teaching methods: full-time
• Note: course can be enrolled in outside the study plan; enabled for web enrollment
• Guarantor: Ing. Jitka Novotná, Ph.D.
• Teacher(s): Dipl.-Math. Jana Javůrková

Annotation

English

Last update: Mgr. Adéla Jarolímková, Ph.D. (22.09.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.<br>
<br>
Students will get acquainted with data modeling with the help of a SW tool and they will get acquainted with the <br>
principle of three architectures, data integrity, relationship cardinality and data normalization. They will also work <br>
with relational database and SQL query language (MySQL), they will get to know with commands for data definition <br>
(DDL) and data manipulation language (DML). Emphasis is placed on practical practice of the subject matter on <br>
specific examples.<br>
<br>
For literature reference and information see Moodle.<br>
<br>
Distance learning: The course will be teached onlline via Zoom and Moodle in 2020/2021. Students will need a <br>
PC/ntb with microphone and camera (phone is not adequate). All teaching tools will be available online via the <br>
web interface, so you won't need to install special SW. I only recommend to have at your disposal text editor that <br>
controls SQL syntax (e.g. Notepad++, Visual Studio, etc.), but is not necessary.The evaluation of the course will be <br>
based on the preparation of a seminar thesis and an online test.<br>

Czech

Last update: Mgr. Adéla Jarolímková, Ph.D. (22.09.2022)

Předmět je součástí oboru softwarového inženýrství a jeho cílem je seznámit studenty se základy relačních <br>
databází a datového modelování. <br>
<br>
Studenti se seznámí s datovým modelováním, seznámí se s principem tří architektur, datovou integritou, <br>
kardinalitou vztahů a datovou normalizací. Dále budou pracovat s relační databází a dotazovacím jazykem SQL <br>
(MySQL), seznámí se s příkazy pro definici dat (DDL) a manipulaci s daty (DML). Důraz je kladen na praktické <br>
procvičení probírané látky na konkrétních příkladech. <br>
<br>
Literatura a bližší informace viz Moodle. <br>
<br>

Course completion requirements

Last update: Mgr. Adéla Jarolímková, Ph.D. (22.09.2022)

Hodnocení předmětu bude založeno na vypracování seminární práce a online testu.