MPE_PSDA Working with data

Faculty of Economics and Administration
Spring 2024
Extent and Intensity
0/2/0. 5 credit(s). Type of Completion: zk (examination).
Teacher(s)
Mgr. Jiří Poláček, Ph.D. (seminar tutor)
Guaranteed by
Mgr. Jiří Poláček, Ph.D.
Department of Economics – Faculty of Economics and Administration
Contact Person: Mgr. Jarmila Šveňhová
Supplier department: Department of Economics – Faculty of Economics and Administration
Timetable of Seminar Groups
MPE_PSDA/01: Thu 12:00–13:50 VT314, except Thu 4. 4., J. Poláček
Prerequisites
Advanced computer user skills.
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 26 student(s).
Current registration and enrolment status: enrolled: 20/26, only registered: 0/26, only registered with preference (fields directly associated with the programme): 0/26
fields of study / plans the course is directly associated with
Course objectives
The aim of the course is to teach students how to manipulate data in such a way that it can be easily analysed. The primary focus is on explaining and practicing regular expressions and the SQL database language, including basic relational database administration. The class may also include a lecture by an outside practitioner.
Learning outcomes
Upon completion of the course, the student will be able to:
- effectively search for errors in data;
- check the accuracy of saved or entered data;
- construct a description of a database table;
- import data into a database and export data from it;
- combine data from different sources into new meaningful units;
- group and aggregate data in the database into spreadsheets;
- prepare data into an optimal form for subsequent statistical testing;
- navigate the administration of a relational database, including setting access permissions
- make a lot of work with data easier.
Syllabus
  • Introduction to data issues
  • Regular expressions
  • Relational databases - theory
  • Querying with SQL
  • Manipulating data in a relational database
  • Useful SQL language functions
  • Programming in SQL
  • Relational database administration
Literature
    recommended literature
  • PETTIT, Thomas and Scott COSENTINO. The MySQL workshop : a practical guide to working with data and managing databases with MySQL. First edition. Birmingham: Packt, 2022, 1 online. ISBN 9781839215476. URL info
  • GRIPPA, Vinicius M. and Sergey KUZMICHEV. Learning MySQL : get a handle on your data. Second edition. Boston: O'Reilly, 2021, 1 online. ISBN 9781492085898. URL info
  • MOLINARO, Anthony and Robert W. DE GRAAF. SQL cookbook : query solutions and techniques for all SQL users. Second edition. Boston: O'Reilly, 2020, 1 online. ISBN 9781492077398. URL info
  • JARMAN, Kristin H. Beyond basic statistics : tips, tricks, and techniques every data analyst should know. Hoboken, New Jersey: Wiley, 2015, 1 online. ISBN 9781118856093. URL info
  • FITZGERALD, Michael and Simon ST. LAURENT. Introducing regular expressions. First edition. Sebastopol, CA: O'Reilly, 2012, 1 online. ISBN 9781449338909. URL info
  • STUBBLEBINE, Tony. Regular expression : pocket reference. Second edition. Sebastopol, California: O'Reilly, 2007, 1 online. ISBN 9780596517090. URL info
  • FRIEDL, Jeffrey E. F. Mastering regular expressions. Third edition. Boston: O'Reilly, 2006, 1 online. ISBN 9780596550028. URL info
Teaching methods
Lecture and practicing on the computer.
Assessment methods
Final written test verifying understanding of computer code. Students who are studying abroad during the semester can also apply for the test.
Language of instruction
Czech
Further Comments
Study Materials
The course is taught annually.
Listed among pre-requisites of other courses
The course is also listed under the following terms Spring 2023, Spring 2025.
  • Enrolment Statistics (Spring 2024, recent)
  • Permalink: https://is.muni.cz/course/econ/spring2024/MPE_PSDA