DDL, DML, Views

About
Privacy
Disclaimer

Graph Chatbot

Description

This lecture introduces SQL data definition and manipulation functions, teaching how to create or modify data structures and manipulate data stored in a database. It covers topics such as creating tables, inserting data, updating existing data, and creating views.

Official source

Practice

Ontological neighbourhood

Computer engineering

Databases: Relational databases

Related lectures (32)

https://mediaspace.epfl.ch/media/0_fvvny07t

About this result

This page is automatically generated and may contain information that is not correct, complete, up-to-date, or relevant to your search query. The same applies to every other page on this website. Please make sure to verify the information with EPFL's official sources.

Ontological neighbourhood

Computer engineering

Databases: Relational databases

Related lectures (32)

SQL: Data Manipulation and Views

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

Data Wrangling with Hive: Managing Big Data Efficiently

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

Relational Model: Basics

Introduces the relational model, SQL, keys, integrity constraints, ER translation, weak entities, ISA hierarchies, and SQL vs. noSQL.

Data Wrangling with Hadoop

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

Relational Algebra and SQL: Foundations of Database Management

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