Querying a database: the SQL language

Related lectures (32)

Page 2 of 4

Discusses query processing models and relational operations, focusing on selections, projections, and joins in data-intensive systems.

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

Introduces the fundamentals of handling data, emphasizing the importance of Pandas and data modeling for effective analysis.

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

Explores query processing steps, physical plans, pipelined execution, and hashing for projections and joins.

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

Introduces relational query languages, focusing on algebra operators and query optimization.

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

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

Explores the world of NoSQL databases and MongoDB's key features.