Relational Algebra and SQL: Foundations of Database Management

About
Privacy
Disclaimer

Graph Chatbot

Related lectures (32)

Page 1 of 4

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

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

Database Management Systems: Fundamentals

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

Relational Databases: Fundamentals

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

Relational Model: Basics

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

Relational Databases: Fundamentals and ACID Properties

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

Relational Algebra

Introduces relational query languages, focusing on algebra operators and query optimization.

Query Processing: Relational Operations and Models

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

Query Processing with Relational Operations

Covers query processing with relational operations, including query optimization and different join algorithms.

SQL Client-Server Architecture + IDE

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