Conditional Queries: Overview

About
Privacy
Disclaimer

Graph Chatbot

Related lectures (33)

Query Fusion, Nested Queries MOOC: Geographical Information Systems 1

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

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.

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

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

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.

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.

DDL, DML, Views MOOC: Geographical Information Systems 1

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

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 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.

Data-Intensive Systems: Relational Model and Algebra Log in to Mediaspace to watch this video

Introduces the relational model and algebra, essential for understanding data-intensive systems and effective database management.

Query Processing: Relational Operations and Models Log in to Mediaspace to watch this video

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

SQL Client-Server Architecture + IDE Log in to Mediaspace to watch this video

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

DBMS Principles and Operators Log in to Mediaspace to watch this video

Covers the fundamentals of DBMS, relational algebra operators, and their importance in managing large datasets.

Relational Algebra and SQL: Foundations of Database Management Log in to Mediaspace to watch this video

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

Introduction to Streams Log in to Mediaspace to watch this video

Covers data streams, real-time analytics, challenges, data stream model, and efficient management.

Query Operators: Joins and Query Processing Techniques Log in to Mediaspace to watch this video

Discusses advanced query operators, focusing on join techniques and their processing methods in relational databases.

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

Covers the basics of the relational model in database management systems, including data models, primary and foreign keys.

Query Optimization: Improving Database Performance Log in to Mediaspace to watch this video

Discusses query optimization in database systems, emphasizing the impact on performance and the decisions involved in improving database performance.

Views: SQL Queries Simplification Log in to Mediaspace to watch this video

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

Efficient GPU Join Optimization Log in to Mediaspace to watch this video

Covers efficient GPU-accelerated join optimization for complex queries, focusing on improving optimization times and heuristic plan quality.

Page 1 of 2