Database Systems – Cornell University Course (SQL, NoSQL, Large-Scale Data Analysis)

Wordpress sites

Learn about relational and non-relational database management systems in this course.

This course was created by Professor Immanuel Trummer, PhD. He is an assistant professor for computer science at Cornell University.
🐦 Follow Professor Trummer on Twitter:

🎥 Watch part 2 of this course here (8 more hours):

You will learn how to query database systems via languages such as SQL (the structured query language). Then, you will see how database systems work internally, how they store and index data, how they process and optimize queries, and how they process transactions while providing guarantees such as isolation, atomicity, and durability (ACID guarantees).

The course addresses questions of database design and discusses novel approaches to data management via NoSQL or NewSQL systems. Finally, the course will discuss about graph, stream, and spatial data, and about systems that are specialized for those data types. The lectures are from the Fall 2020 online lecture at Cornell by Prof. Trummer (www.itrummer.org).

🔗 Slides:
To download the slides, you may have to right-click the link and select "Save link as…". After clicking 'Save' you may have to look at the bottom of your browser window, click the up arrow, and then select 'Keep'.

⭐️ Course Contents ⭐️
⌨️ (0:00:00) The Structured Query Language (SQL)
⌨️ (3:04:52) Storing and Indexing Data
⌨️ (5:52:44) Relational Data Processing
⌨️ (10:40:23) Transaction Processing
⌨️ ( ) Database Design
⌨️ ( ) Beyond Relational Data

⭐️ Additional Reading ⭐️
About the first two thirds of the course are based on the textbook "Database Management Systems" by Raghu Ramakrishnan and Johannes Gehrke. The last third of the course discusses recently proposed systems, more details about them can be found in the corresponding research papers.

Learn to code for free and get a developer job:

Read hundreds of articles on programming:

And subscribe for new videos on technology every day:

43 thoughts on “Database Systems – Cornell University Course (SQL, NoSQL, Large-Scale Data Analysis)”

    1. Waiting for kids to argue that it isnt free because they get paid via ads…like bruh u are still watching it for free

  1. Such an amazing effort by FCC in the e-learning space
    Thanks Guys it is really appreciated 🤝 🙏

  2. awesome! thank you FCC, for this and for everything else! your efforts are highly appreciated!

    1. Hey akhil…can you please tell me about the course…does it covers all the syllabus (DBMS) for gate exam

    1. Kristina Zhekova

      Мама привет в общем на согласование и утверждение и утверждение что он тебе за это деньги на согласование и утверждение что он будет к вечеру или завтра с на н Егор я шлю

  3. As much as I would love to watch all this in one sitting, it’d be nice to have timestamps, so that I can chunk my learning. Thanks, FCC!

  4. It’s wonderfull that there are people witch share wisdom. Now people with iron will and briliant mind could learn this beautifull concepts.

    1. @Programmer yeah duh, it’s 25 hours, definetely took him more than one day. 1 hour more

  5. The Structured Query Language (SQL)
    00:00 – Introduction to Database Systems
    11:47 – SQL intro
    59:31 – SQL: Simple Analysis
    1:46:30 – Advanced SQL Features

    Storing and Indexing Data
    3:04:52 – Data Storage
    3:54:05 – Tree Indexes
    5:03:28 – Hash Indexes

    Relational Data Processing
    5:52:44 – Query Processing Overview
    6:20:53 – Operator Implemenations
    7:30:28 – Hash Join, Sort-Merge Join
    8:30:34 – More Operators and Query Plans
    9:06:02 – Query Optimization

    Transaction Processing
    10:40:23​ – Transactions
    11:00:22 – Isolation via Concurrency Control
    12:16:03 – Two-Phase Locking
    13:08:30 – More on Locking
    14:12:53 – Concurrency Control Without Locking
    15:06:23 – Recovery After System Crashes 1
    15:59:12 – Recovery After System Crashes 2

  6. alrashid Towmir

    what more can I say? You guys are blessed, sharing these valuable courses with us for free!

Comments are closed.