BGE Hallgatói fiók

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

Further information

Other