Querying a database: the SQL language

About
Privacy
Disclaimer

Graph Chatbot

Related lectures (37)

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.

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.

DDL, DML, Views MOOC: Geographical Information Systems 1

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

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.

Data Wrangling with Hadoop: Storage Formats and Hive

Explores data wrangling with Hadoop, emphasizing storage formats and Hive for big 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.

Data Wrangling with Hadoop

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

Data Modeling: Concepts and Applications

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

NoSQL Databases: Overview MOOC: Geographical Information Systems 1

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

Query Fusion, Nested Queries MOOC: Geographical Information Systems 1

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

NoSQL Databases: Origins and Types MOOC: Geographical Information Systems 1

Covers the origins and types of NoSQL databases, focusing on MongoDB and CRUD operations.

Data Wrangling with Hive: Managing Big Data Efficiently

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

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

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

Aggregation queries and sorting MOOC: Geographical Information Systems 1

Covers aggregation queries and sorting of results in Geographic Information Systems.

Data: Clouds and Things

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

Vector-Vector Interactions

Covers interactions between vector layers in GIS using QGIS tools.

Aggregation Query and Result Sorting MOOC: Geographical Information Systems 1

Covers aggregation logic, sorting results, and writing SQL queries based on specific attributes.

Relational Databases: Summary MOOC: Geographical Information Systems 1

Concludes the exploration of relational databases and introduces database management systems.

Relational Model: Basics Log in to Mediaspace to watch this video

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

Page 1 of 2