BKM_USQL Introduction to SQL

Faculty of Economics and Administration
Spring 2025
Extent and Intensity
0/0/0. 6 credit(s). Type of Completion: z (credit).
In-person direct teaching
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 7. 3. 12:00–15:50 VT204, Fri 11. 4. 16:00–19:50 VT204, Fri 16. 5. 12:00–15: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
Abstract
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.
Key topics
  • 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)
Study resources and 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
Approaches, practices, and methods used in teaching
Practical work in SQL database. Online or off-line. Book in czechlanguage: Naučte se SQL za 28 dní
Method of verifying learning outcomes and course completion requirements
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
Study Materials
The course is taught annually.
The course is also listed under the following terms Spring 2022, Spring 2023, Spring 2024, Spring 2026.
  • Enrolment Statistics (Spring 2025, recent)
  • Permalink: https://is.muni.cz/course/econ/spring2025/BKM_USQL