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:
This is amazing, a full-fledged database course for free!
How is it ? Did you watched it full ?
Hey Shubham can you please tell me will this course completely cover all DBMS for gate exam?…
This was the course I was missing for my interview 🥺! Thanks to you!
The fact that we are getting these courses for free is just amazing
@Prakash Arora indeed
Waiting for kids to argue that it isnt free because they get paid via ads…like bruh u are still watching it for free
Yeah, I hate that people just take it for granted
@Gavin Gonzalez yeah me too
Such an amazing effort by FCC in the e-learning space
Thanks Guys it is really appreciated 🤝 🙏
amazing course sir 👍
awesome! thank you FCC, for this and for everything else! your efforts are highly appreciated!
Thank you so much! Please make more videos on comp sci subjects like this!
Hey akhil…can you please tell me about the course…does it covers all the syllabus (DBMS) for gate exam
17 hours, let’s go! Thanks for always sharing amazing resources!
You’re probably thinking: “Only 17 hours?” Actually the course is 25 hours. 😀Watch part 2 here: https://youtu.be/lxEdaElkQhQ
Slides?
can you put captions on the video….(youtube default) i think it is helpful
Мама привет в общем на согласование и утверждение и утверждение что он тебе за это деньги на согласование и утверждение что он будет к вечеру или завтра с на н Егор я шлю
Lmao.
😀
GOD BLESS YOU ALL …. teachers who are enlighting the world with knowledge….
I am so thankful this is out in the public domain!
Salute to your effort FCC, always provide new content to learn.
How is it ? Did you watched it full ?
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!
Check the description, they always put the timestamp in there.
Thank you for this knowledge. I appreciate it very much 🤗
It’s wonderfull that there are people witch share wisdom. Now people with iron will and briliant mind could learn this beautifull concepts.
0:00 introduction to database Systems
7:32 Resources
8:40 there website
9:50 intro SQL
man did a 25-hour course in a library using a laptop and earphones
what a legend
it’s not on a single day tho
are you british?
@Programmer yeah duh, it’s 25 hours, definetely took him more than one day. 1 hour more
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
God’s work friend
thanks sir for help
Smooth!
Thank you ☺️
Thanks
what more can I say? You guys are blessed, sharing these valuable courses with us for free!
I hope you can translate it into many other languages to make it easier for us to understand
Incredible resource. Thank you!