MPM_SQLA Big Data with SQL

Faculty of Economics and Administration
Spring 2019
Extent and Intensity
0/2/0. 5 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 of Seminar Groups
MPM_SQLA/01: Tue 12:00–13:50 VT206, P. Lasák
MPM_SQLA/02: Mon 14:00–15:50 VT204, P. Lasá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 48 student(s).
Current registration and enrolment status: enrolled: 22/48, only registered: 0/48, only registered with preference (fields directly associated with the programme): 0/48
fields of study / plans the course is directly associated with
Course objectives
SQL language from the basics to advanced clause (introduction sorting and searching data optimization).
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)
  • 13. Test
Literature
    required literature
  • Všechny studijní materiály budou aktualizovány v ISu.
Teaching methods (in Czech)
Naučte se SQL za 28 dní
Assessment methods
Continuous tests, practical exercises
Language of instruction
Czech
Further Comments
Study Materials
The course is taught annually.
The course is also listed under the following terms Spring 2017, Spring 2018, Spring 2020, Spring 2021.
  • Enrolment Statistics (Spring 2019, recent)
  • Permalink: https://is.muni.cz/course/econ/spring2019/MPM_SQLA