Mediaspace scheduled maintenance: Aug 25, 2026 07:00 - 12:00 AM. During this time, videos will be temporarily unavailable. Check status updates.

Home

Lecture

SQL Basics: Select Queries

About
Privacy
Disclaimer

Graph Chatbot

Related lectures (34)

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.

Digital Archives and Virtual Museums Log in to Mediaspace to watch this video

Delves into the transition from traditional to virtual museums, exploring digital archives and historical practices.

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.

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.

Introduction to Database Systems Log in to Mediaspace to watch this video

Covers the basics of database systems, including data modeling, DBMS, data independence, and the course overview.

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

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

Database Management Systems: Fundamentals Log in to Mediaspace to watch this video

Introduces the fundamentals of database management systems, covering relational model, storage options, data integrity, queries, and data manipulation languages.

Blockchain Fundamentals: Structure and Transactions Log in to Mediaspace to watch this video

Introduces blockchain fundamentals, covering structure, transactions, Proof-of-Work, security assumptions, Bitcoin transactions, Ethereum smart contracts, and limitations.

Transaction Management & Concurrency Control Log in to Mediaspace to watch this video

Explores transaction management, concurrency control, ACID properties, anomalies, and conflict serializability in database systems.

Transactions: Concepts and Implementations Log in to Mediaspace to watch this video

Explores the elegance and challenges of transactions, including ACID properties and transactional memory benefits in concurrent programming.

Introduction to Database Systems Log in to Mediaspace to watch this video

Covers the fundamentals of database systems, including data modeling, information processing, and the challenges of managing large volumes of data.

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.

Transactions and Concurrency Control Log in to Mediaspace to watch this video

Explores transactions, concurrency control, conflict resolution, and snapshot isolation in databases, emphasizing consistency and performance.

MLIR: Compiler Infrastructure Log in to Mediaspace to watch this video

Covers MLIR, a compiler infrastructure for domain-specific computation, emphasizing the importance of multiple abstraction levels and higher-level semantics.

Page 2 of 2