SQL Basics: Select Queries

Related lectures (32)

Page 1 of 4

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

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 selection requests.

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

Covers data wrangling techniques using Apache Hive for efficient big data management.

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

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

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

Covers efficient GPU-accelerated join optimization for complex queries, focusing on improving optimization times and heuristic plan quality.