DDL, DML, Views

About
Privacy
Disclaimer

Graph Chatbot

Related lectures (35)

SQL: Data Manipulation and Views MOOC: Geographical Information Systems 1

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.

Data Wrangling with Hadoop

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

Querying a database: the SQL language MOOC: Geographical Information Systems 1

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

Relational Databases: Fundamentals MOOC: Geographical Information Systems 1

Covers relational and spatial databases, including storage, management systems, ACID properties, historical typologies, primary and foreign keys, and spatial functions.

SQL Queries and Syntax MOOC: Geographical Information Systems 1

Covers the basics of SQL, including components of the language and syntax of SELECT clause.

Handling Data: Intro to Pandas

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

SQL Basics: Select Queries MOOC: Geographical Information Systems 1

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

Data Modeling: Concepts and Applications

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

Data modeling: Geographic Information Systems MOOC: Geographical Information Systems 1

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

Relational Databases: Fundamentals and ACID Properties MOOC: Geographical Information Systems 1

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

Hydrology Modeling: Routing System

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

Data formats and data wrangling with Hadoop

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

Data, big data, clouds and IoT

Explores data representation, databases, cloud computing, and challenges in the cloud environment.

Querying a database: the SQL language MOOC: Geographical Information Systems 1

Covers the basic principles of the SQL language and selection requests.

Query Fusion, Nested Queries MOOC: Geographical Information Systems 1

Covers query fusion, nested queries, and SQL operators in a geographical context.

Data Definition and Manipulation Languages MOOC: Geographical Information Systems 1

Covers the creation, modification, and deletion of tables, data manipulation, and views.

Modeling Hydrological Systems: Routing and Flood Retention

Discusses modeling hydrological systems, focusing on routing and flood retention using a new database.

Data: Clouds and Things

Covers the fundamentals of data, cloud storage, and the Internet of Things.

Data Wrangling with Hadoop: Storage Formats and Hive

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

Page 1 of 2