Data Definition and Manipulation Languages

Related lectures (12)

Page 1 of 2

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

Covers SQL data manipulation language, including DDL and DML commands.

Covers creating, modifying, and deleting tables, inserting, updating, and deleting data, and briefly discusses views.

Covers the SQL language for interacting with databases through structured queries, including selecting, filtering, aggregating, and sorting data.

Explores views in SQL, covering creation, materialization, maintenance, cube building, and top-k queries optimizations.

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

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

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

Explores the data ingestion process in SmartDataLake, including datasets and the RAW platform.

Explores how views simplify query writing and are key in data warehouses.