Querying a database: the SQL language

About
Privacy
Disclaimer

Graph Chatbot

Related lectures (34)

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.

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.

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.

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.

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.

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.

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.

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.

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

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

Tree-Structured Indexing: B+ Tree Log in to Mediaspace to watch this video

Explores tree-structured indexing with a focus on B+ trees in databases.

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.

Data Management: Overview Log in to Mediaspace to watch this video

Introduces fundamental concepts of data management, including data models, databases, and key tasks.

Concurrency Control & Recovery in Databases Log in to Mediaspace to watch this video

Delves into transaction management, concurrency control, and recovery in databases to ensure data integrity and system resilience.

Hashing and Sorting Techniques in Database Systems Log in to Mediaspace to watch this video

Provides an overview of hashing and sorting techniques in database management systems, focusing on their implementation and performance optimization.

Page 2 of 2