Prof. Dr. Jens Dittrich, Big Data Analytics

Elements of Data Science and Artificial Intelligence: Coronainzidenzen und ML in Python

What are Data Science and Artificial Intelligence?

13.49 PRIMARY KEY, UNIQUE, FOREIGN KEY, REFERENCES, CONSTRAINT

Database Systems: Multi-Version Concurrency Control (MVCC)

14.122 Nested RAID Levels 1+0; 10; 0+1; 01

14.502 Challenges in Query Optimization: Rule-Based Optimization

13.16 Relationen versus Tabellen

External Sorting

Database Systems: Indexing (Part 2)

14.300 Motivation for Index Structures, Selectivities, Scan vs. Index Access on Disk and Main Memory

Big Data Engineering: Course Summary

Ethical Aspects of Metadata Analysis with SQL (NSA Part 2)

Data in the Wild (Databases at University vs Databases in Reality)

SQLite: How it works, by Richard Hipp

SQL (NSA Part 1)

14.113 Hard Disks, Sectors, Zone Bit Recording, Sectors vs Blocks, CHS, LBA, Sparing

Python Einführung: List Comprehensions und Funktionale Programmierung

ACID and Concurrency Control (Part 2)

Developing Web Applications with Django, Project: Fame Social Network

Query Optimization (Part 2), operator models, blocking, push vs pull, late materialization

Query Optimization (Part 1)

Ethical Implications of Metadata Analysis

Database Systems: Indexing (Part 1)

Database Systems: Data Layouts (Part 1)

Database Systems: Crash Recovery (Part 2), Elasticity

Relational Algebra (IMDb Part 2)

14.003 Architecture of a DBMS

Query Optimization (Part 2)

Entity Relationship Modelling and the Relational Model

14.242 Dictionary Compression, Domain Encoding

13.18a Relationale Algebra: Schnitt, Theta Join, Equi Join, Natural Join

Big Data Engineering: Introduction and Administrative Matters

14.157 The Copy On Write Pattern (COW)

14.316 Covering and Composite Index, Duplicates, Overflow Pages, Composite Keys

Data Journalism (Modelling and Querying Graphs in SQL vs Cypher)

14.163 Logged Writes, Differential Files vs Logging

Elements of Data Science and Artificial Intelligence: Data Handling and Cleaning in Python

Concurrency Control (Part 1)

Big Data Engineering: Anfrageoptimierung (Teil 2)

14.157 The Copy On Write Pattern (COW) V2

Data in the Wild

Introduction to Django

Database Systems: Crash Recovery with ARIES (Part 1)

14.602 Log-Based Recovery, Stable Storage, Write-Ahead Logging (WAL)

Entity-Relationship Modelling and the Relational Model (IMDb Part 1)

Relational Algebra

14.158 The Merge on Write Pattern (MOW) V2

13.47 CREATE, ALTER, DROP, DESCRIBE TABLE, Katalog, psql Shell (Datendefinitionssprache, DDL)

Database Systems: Data Layouts (Part 2)

14.172 Virtual Memory Management, Page Table, Prefix Addressing

14.416 Sort-Merge Join, Co-Grouping