BGE Hallgatóknak

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 5*45 minutes (5 lessons) +1 day 4*45 minutes (4 lesson)

Recognition / credits 

3 credits

Students we recommend 

Any undergraduate or graduate student at BGE

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

-