Relational Databases: Fundamentals

About
Privacy
Disclaimer

Graph Chatbot

Related lectures (32)

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.

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.

Data: Clouds and Things

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

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: Storage Formats and Hive

Explores data wrangling with Hadoop, emphasizing storage formats and Hive for big data processing.

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.

Handling Data: Intro to Pandas

Introduces the fundamentals of handling data, emphasizing the importance of Pandas and data modeling for effective analysis.

Learning Models over Relational Databases

Explores learning models over relational databases, emphasizing prediction quality and the importance of structure-aware learning.

NoSQL Databases: Overview MOOC: Geographical Information Systems 1

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

DDL, DML, Views MOOC: Geographical Information Systems 1

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

Relational Databases: Summary MOOC: Geographical Information Systems 1

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

Relational Databases: Summary MOOC: Geographical Information Systems 1

Covers relational databases and database management systems basics for upcoming lessons.

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.

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.

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.

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.

Entity-Relationship Model Log in to Mediaspace to watch this video

Introduces the Entity-Relationship model for designing databases with a focus on conceptual and relational aspects.

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.

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.

Page 1 of 2