ESF:BKM_USQL Introduction to SQL - Course Information
BKM_USQL Introduction to SQL
Faculty of Economics and AdministrationSpring 2023
- 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
Department of Applied Mathematics and Computer Science – Faculty of Economics and Administration
Contact Person: Lenka Hráčková
Supplier department: Department of Applied Mathematics and Computer Science – Faculty of Economics and Administration - Timetable
- Fri 17. 3. 12:00–15:50 VT204, Fri 14. 4. 16:00–19:50 VT204, Fri 5. 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.
The capacity limit for the course is 45 student(s).
Current registration and enrolment status: enrolled: 15/45, only registered: 0/45, only registered with preference (fields directly associated with the programme): 0/45 - 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., Ronald R. PLEW and Arie JONES. Naučte se SQL za 28 dní. Translated by Lukáš Krejčí. Vyd. 1. Brno: Computer Press, 2010, 728 s. ISBN 9788025127001. 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 2023, recent)
- Permalink: https://is.muni.cz/course/econ/spring2023/BKM_USQL