Interactive Data Transformation (320099-M-6)

Includes everything from: Lecture 1: Data Management Systems, Relational, and SQL Lecture 2: Entity Relationships, and Translating from a Natural Lecture 3: Translating ERD to DB Schema, and Database Normalization Lecture 4: Evolution of Data Management, Big Data, and Data Intensive Systems Lecture 5: The Spark Ecosystem, RDDs, Programming Model, and PySpark Lecture 6: Data Transformations with SQL, Entity Recognition, Data Cleaning Tools

A complete summary of the lecture slides, recorded videos, and live lectures. Passed the course with a 7.5 by only studying this summary.

all necessary info

Detailed summary of all lectures and additional notes, explanations and examples for the course "Interactive Data Transformation" at Tilburg University which is part of the Master Data Science and Society. Course was given by : E. Ioannou during the second semester, block four of the academic year 2021 / 2022 (April to June 2022).

Een samenvatting van het vak IDT inclusief oefen vragen en antwoorden. Ook alle colleges zijn bijgewoond en uitgewerkt. Inclusief ook voorbeelden van alle SQL statements.

Detailed lecture notes of all lectures. Assignments (+answers!) also included.

Summary of all lectures of the course 'Interactive Data Transformation'. Table of contents: Lecture 1: Intro + data management systems + SQL Topics: database management systems; single table queries using SQL. Lecture 2: Entity-relationship model Topics: Entity-relationship model Lecture 3: Advanced SQL operators and functions Topics: Processing multiple tables: relationship and joins; aggregation, views, and functions; table creation and population. Lecture 4: Data types +...