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

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.

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

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

⭐️ 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.

--

[dimangk]

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

[jakedeng]

The fact that we are getting these courses for free is just amazing

[aronferix]

Where money is everything then there are some people really teach for free. I wish these people succeed in life.

[alrashidtowmir]

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

[mso]

From the bottom of my heart, THANK YOU for publishing this course. It has helped clarify so many concepts for me and helped build a very strong DBMS foundation.

[mrTiberiuDubau]

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

[AmrMohamed-rpoi]

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

[Cute-dancer]

GOD BLESS YOU ALL .... teachers who are enlighting the world with knowledge....

[JulioTex]

17 hours, let’s go! Thanks for always sharing amazing resources!

[rodnehmofan]

Thank you for this!! this can help a lot people who are interested in this course but with no means to enroll to any university or online courses

[amirjayousi]

man did a 25-hour course in a library using a laptop and earphones
what a legend

[flashbao]

This was the course I was missing for my interview 🥺! Thanks to you!

[marthinus.x]

1:55:46 - For anyone following along. The video games database from Kaggle has been updated, so column order will be different. Also notice: Professor Trummer is using NULL AS 'N/A', You might encounter an error where you cannot copy the CSV data into Postgres because of empty delimiters (, , , , ), I suggest cleaning up the CSV file by issuing: sed -i -e 's/N\/A//g' yourfile.csv and using COPY yourtable FROM DELIMITER ', ' NULL AS '' CSV HEADER; which should result in success.

[tytusgierycz]

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

[rabbitazteca]

Yay! I am literally starting my college course on Database Management System in a week after finsihed my Data Struct and Algo course. Now I can study in advance lol. Thank you for this

[Zorojuro]

This is amazing, a full-fledged database course for free!

[Laliesposito]

So thankful with this channel 💜 thank you so much!

[qqpqosx]

This video really helped me to get the clear understanding of the core concepts of the SQL.
After watching this i solved two medium level SQL questions on leetcode, which i tried already but couldn't get the intuition before watching this video.

This is a valuable

[rishabhkumar]

Salute to your effort FCC, always provide new content to learn.

[epicgameryt]

Good short video, straight to the point! I'm kidding, but this video is of tremendous values. Thankyou everyone who has participated in this. Students, the teacher, the people working behind the scene, the editors. Thankyou from the bottom of my heart.