Relational Model: Basics

Related lectures (32)

Page 2 of 4

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

Covers the basics of database systems, including data modeling, DBMS, data independence, and the course overview.

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 SQL language for interacting with databases through structured queries, including selecting, filtering, aggregating, and sorting data.

Explores file organization, indexing methods, and database storage design, including record formats, page formats, and index classification.

Explores data wrangling with Hadoop, emphasizing storage formats and Hive for big data processing.

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

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

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