DDL, DML, Views

Related lectures (32)

Page 2 of 4

Introduces fundamental concepts of data management, including data models, databases, and key tasks.

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

Introduces data modeling concepts, SQL usage, and Pandas library applications for efficient data processing.

Introduces data modeling in the context of Geographic Information Systems, covering the added value and methods used.

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

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

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

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

Explores Apache Hive for data warehousing, data formats, and partitioning, with practical exercises in querying and connecting to Hive.

Covers the fundamentals of database systems, including data modeling, information processing, and the challenges of managing large volumes of data.