Course

CS-322: Introduction to database systems

Summary

This course provides a deep understanding of the concepts behind data management systems. It covers fundamental data management topics such as system architecture, data models, query processing and optimization, database design, storage organization, and transaction management.

Lectures

Instructor

Christoph Koch

Expertise knows everything ;-) Publications My publications in Google ScholarMy publications in DBLPMy papers on EPFL's publications server (InfoScience)Prospective PhD students and postdocs please read this before contacting me. Christoph Koch is a professor of Computer Science at EPFL, specializing in data management. Until 2010, he was an Associate Professor in the Department of Computer Science at Cornell University. Previously to this, from 2005 to 2007, he was an Associate Professor of Computer Scienc

Official source

https://edu.epfl.ch/coursebook/en/introduction-to-database-systems-CS-322

Moodle Page

http://go.epfl.ch/CS-322

About this result

This page is automatically generated and may contain information that is not correct, complete, up-to-date, or relevant to your search query. The same applies to every other page on this website. Please make sure to verify the information with EPFL's official sources.

Graph Chat

Chat with Graph Search

Ask any question about EPFL courses, lectures, exercises, research, news, etc. or try the example questions below.

DISCLAIMER: The Graph Chatbot is not programmed to provide explicit or categorical answers to your questions. Rather, it transforms your questions into API requests that are distributed across the various IT services officially administered by EPFL. Its purpose is solely to collect and recommend relevant references to content that you can explore to help you answer your questions.

Summary

Lectures

Instructor

Christoph Koch

Official source

https://edu.epfl.ch/coursebook/en/introduction-to-database-systems-CS-322

Moodle Page

http://go.epfl.ch/CS-322

About this result

Lectures in this course (15)

Introduction to Database Systems

Covers the basics of database systems, including data modeling, DBMS, data independence, and the course overview.

Entity-Relationship Model

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

Relational Model: Basics

Introduces the relational model, SQL, keys, integrity constraints, ER translation, weak entities, ISA hierarchies, and SQL vs. noSQL.

Relational Algebra

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

File Organization and Indexing

Explores file organization, record formats, indexing techniques, and index classifications in databases, emphasizing the importance of efficient data storage and access.

Related courses (28)

COM-490: Large-scale data science for real-world data

This hands-on course covers tools and methods used by data scientists, from researching solutions to scaling prototypes on Spark clusters. Students engage with the full data engineering and data science pipeline, from data acquisition to extracting insight ...

CS-423: Distributed information systems

This course introduces the foundations of information retrieval, data mining and knowledge bases, which constitute the foundations of today's Web-based distributed information systems. ...

CS-300: Data-intensive systems

This course covers the data management system design concepts using a hands-on approach. ...

CS-401: Applied data analysis

This course teaches the basic techniques, methodologies, and practical skills required to draw meaningful insights from a variety of data, with the help of the most acclaimed software tools in the data science world (pandas, scikit-learn, Spark, etc.) ...

BIO-378: Physiology lab I

Le TP de physiologie introduit les approches expérimentales du domaine biomédical, avec les montages de mesure, les capteurs, le conditionnement des signaux, l'acquisition et traitement de données. Les résultats physiologiques finaux illustrent le contenu ...