Querying a database: the SQL language

Related lectures (32)

Page 1 of 4

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

Introduces the relational model and relational algebra, focusing on SQL and its operations for effective database management.

Covers the basic principles of the SQL language and select queries.

Covers SQL data definition, manipulation, and views in databases.

Covers data wrangling techniques using Hadoop, focusing on row versus column-oriented databases, popular storage formats, and HBase-Hive integration.

Covers the modeling of hydrological systems, focusing on the retention of floods and the example of the Routing System.

Delves into the transition from traditional to virtual museums, exploring digital archives and historical practices.

Explores the complexity of data in databases and methods for extracting information.

Discusses the logistics of the final assignment, focusing on forming groups and choosing topics.

Covers experiments on seed sizes and colors in the history of databases.