Database Management Systems: Fundamentals

About
Privacy
Disclaimer

Graph Chatbot

Related lectures (35)

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.

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.

Handling Data: Intro to Pandas

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

Data Modeling: Concepts and Applications

Introduces data modeling concepts, SQL usage, and Pandas library applications for efficient data processing.

Data: Clouds and Things

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

Data Wrangling with Hadoop: Storage Formats and Hive

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

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.

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

Covers data wrangling techniques using Hadoop, focusing on row versus column-oriented databases, popular storage formats, and HBase-Hive integration.

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.

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.

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.

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.

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

Covers database management systems principles, design, implementation, and storage options like flat CSV files.

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.

Page 1 of 2