Large-scale SQL Processing

Related lectures (32)

Page 2 of 4

Introduces the Entity-Relationship model for designing databases with a focus on conceptual and relational aspects.

Covers the architecture of a typical DBMS and SQL interfaces like SQL Developer and DataGrip.

Explores data modeling concepts, SQL implementations, and practical applications in handling missing data.

Covers relational databases, transactions, and data consistency in the context of historical database typologies.

Covers the SQL language for interacting with databases through structured queries, including selecting, filtering, aggregating, and sorting data.

Explains OLAP data models, focusing on multidimensional and relational approaches.

Discusses query processing models and relational operations, focusing on selections, projections, and joins in data-intensive systems.

Covers query processing with relational operations, including query optimization and different join algorithms.

Concludes the exploration of relational databases and introduces database management systems.

Covers relational databases and database management systems basics for upcoming lessons.