3rd Hour

Theory:

• Relational Databases / Entity-Relationship Model
• SQL Language basics / Oracle APEX
• Data Types
• Big Data
• Excel ODBC to connect to a database
• Microsoft Power Query - M-Language, Table data transformation, Pivot and Unpivot
• Microsoft Power BI   

Practical tasks:

• Create, query and delete table in Oracle APEX
• Pivot and unpivot data with Power Query and PowerBI 

Preparation references:

• SQL: https://en.wikipedia.org/wiki/SQL
• Developing SQL Databases: https://courses.edx.org/courses/course-v1:Microsoft+DAT215.1x+3T2018/course/

Preparation - video:

Relational Database Concept
https://www.youtube.com/watch?v=NvrpuBAMddw (5.24)

Intro to SQL: Querying and managing data | Computer programming | Khan Academy

https://www.youtube.com/watch?v=IXycPq7MnwE (2.04)

Normalization Key Terms:

https://youtu.be/FFg3UFgz3AE (4.14)