Introduction to Database Systems

About
Privacy
Disclaimer

Graph Chatbot

Related lectures (32)

Relational Algebra and SQL: Foundations of Database Management

Introduces the relational model and relational algebra, focusing on SQL and its operations for effective database management.

SQL Client-Server Architecture + IDE

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

Data Wrangling with Hadoop: Storage Formats and Hive

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

Handling Data: Intro to Pandas

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

Modeling Hydrological Systems: Routing and Flood Retention

Discusses modeling hydrological systems, focusing on routing and flood retention using a new database.

General Introduction to Big Data

Covers data science tools, Hadoop, Spark, data lake ecosystems, CAP theorem, batch vs. stream processing, HDFS, Hive, Parquet, ORC, and MapReduce architecture.

Stockage et transmission des données 1: introduction; besoin de structure

Discusses the importance of structuring data for efficient storage and retrieval.

Data Modeling: Concepts and Applications

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

Big Data Best Practices and Guidelines

Covers best practices and guidelines for big data, including data lakes, architecture, challenges, and technologies like Hadoop and Hive.

Transactions and Concurrency Control

Delves into transactions, ACID properties, schedules, locking protocols, and concurrency control in database systems.

Database Management Systems: Overview

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

Buffer Management in DBMS

Discusses buffer management in a DBMS, covering challenges, buffer pool, and replacement policies.

Page 2 of 2