Course | Data and SQL for Business course |
Neptun Code | DASE0PA02 |
Organiser | Department of Business Information Technology |
Type of the course | Elective subject |
Short summary | Topic outline and schedule: 1. Introduction • Install MySQL Workbench • What is SQL? • What is a database and its types? • Basic queries. 2. WHERE, ORDER BY, LIMIT, Aliases • Where conditions • Order by logics / limitations • Use aliases 3. Scalar Functions, Dates • Use scalar functions to manipulate the data • Use data functions and different formats 4. Subqueries • Use subqueries for gaining complex dataset 5. GROUP BY, HAVING • Use grouping logic and aggregate functions to create complex results 6. CASE WHEN, UNION • Useful techniques to sophisticate the result 7. JOINs • Understand the different types of join logics 8. JOINs • Create complex join strategy to gain data from various tables / Practicing 9. Exercise • Review some business examples / Practicing 10. Exercise • Practicing for the exam |
Semester | 2022/2023/2 |
Lecturer | Micskó Krisztián / Morgan Stanley (Dr. Dobák Dóra) |
Language | English |
Duration | March 20.-24., 4 days 5*45 minutes (5 lessons) +1 day 4*45 minutes (4 lesson) |
For students | interested in the fields of Finance / Analitics |
Number of students | 30 persons |
Assessment | Exam |
Further information | |
Other |
Data and SQL for Business course - 2022/2023 II.