Data and SQL for Business course


Neptun Code	DASE0PA02
Organiser	Department of Business Information Technology
Subject Type	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
Language	English
Days	October 24.-28. 4 days 545 minutes (5 lessons) +1 day 445 minutes (4 lesson)
Recognition / credits	3 credits
Students we recommend	Any undergraduate or graduate student at BUEB
Number of Students	35 persons
Assessment Methods	Exam (04. 11. 2022)
Lecturer	Micskó Krisztián / Morgan Stanley (Dr. Dobák Dóra)
Further information	Primary target group Students interested in the fields of Finance / Analitics PC room required
Other	-