Query Fusion, Nested Queries | EPFL Graph Search

Introduces the relational model, SQL, keys, integrity constraints, ER translation, weak entities, ISA hierarchies, and SQL vs. noSQL.

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

Introduces the relational model and algebra, essential for understanding data-intensive systems and effective database management.

Covers the basics of SQL, including components of the language and syntax of SELECT clause.

Covers the functioning of conditional queries based on the WHERE clause.