ESF:BKM_USQL Introduction to SQL - Course Information
BKM_USQL Introduction to SQL
Faculty of Economics and AdministrationSpring 2024
- Extent and Intensity
- 0/0/0. 6 credit(s). Type of Completion: z (credit).
- Teacher(s)
- Ing. Pavel Lasák (seminar tutor)
- Guaranteed by
- Ing. Pavel Lasák
Division of Applied Mathematics and Computer Science – Faculty of Economics and Administration
Contact Person: Lenka Hráčková
Supplier department: Division of Applied Mathematics and Computer Science – Faculty of Economics and Administration - Timetable
- Fri 15. 3. 12:00–15:50 VT204, Fri 12. 4. 16:00–19:50 VT204, Fri 3. 5. 16:00–19:50 VT204
- Prerequisites (in Czech)
- FORMA(K)
- Course Enrolment Limitations
- The course is also offered to the students of the fields other than those the course is directly associated with.
- fields of study / plans the course is directly associated with
- Business Analytics (programme ESF, B-BA)
- Course objectives
- SQL language from the basics to advanced clause (introduction sorting and searching data optimization).
- Learning outcomes
- Student can work with MySQL database. Create, Insert, Delete, Select.
- Syllabus
- 1. Introduction to SQL.
- 2. Create databases and tables
- 3. Creating, deleting data in the tables
- 4. Selection (search) data
- 5. Order, Limit and aggregate functions
- 6. Data types and NULL
- 7. Multiple tables (JOIN), M: N
- 8. Subqueries
- 9. Change the structure, transactions and views
- 10. Trigger (DML)
- 11. Optimalizace výkonu databáze
- 12. Function (UDF)
- Literature
- required literature
- Všechny studijní materiály budou aktualizovány v ISu.
- recommended literature
- STEPHENS, Ryan K. and Ronald R. PLEW. Naučte se SQL za 21 dní. Vyd. 1. Brno: Computer Press, 2004, 581 s. ISBN 8072268708. info
- Teaching methods
- Practical work in SQL database. Online or off-line. Book in czechlanguage: Naučte se SQL za 28 dní
- Assessment methods
- Practically oriented tutorials with an emphasis on the active students' approach. Study of recommended literature, autokorection tests, individual work on assigned tasks.
- Language of instruction
- Czech
- Further comments (probably available only in Czech)
- Study Materials
The course is taught annually.
Information on the extent and intensity of the course: tutorial 12 hodin.
- Enrolment Statistics (Spring 2024, recent)
- Permalink: https://is.muni.cz/course/econ/spring2024/BKM_USQL