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.
🐦 Follow Professor Trummer on Twitter: / immanueltrummer
🎥 Watch part 2 of this course here (8 more hours): • Database Systems - Cor...
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: cdn.freecodecam...
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 Systems - Cor... ) Database Design
⌨️ ( • Database Systems - Cor... ) 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: www.freecodeca...
Read hundreds of articles on programming: freecodecamp.o...

[@freecodecamp]

You're probably thinking: "Only 17 hours?" Actually the course is 25 hours. 😀Watch part 2 here: kzbin.info/www/bejne/oqmolZR7odCEnrM

[@santigogaming8630]

U are the best. Thank You!

[@freecodecamp]

@KEV IN The lectures are from a Fall 2020 online lecture at Cornell.

[@weeyakkawonga6243]

Some animals don't even live that long... 🤣

[@weeyakkawonga6243]

Nice & Great Resources...

[@muhamadrafipamungkas4465]

Damn

[@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

[@Muhammed-zn7ft]

Thanks

[@vinayvupparapalli4782]

thank you sooo much mate.!!!!

[@girinskate4269]

thank You

[@oneManDev]

Awesome, thanks!

[@manishsalve9060]

Thank you man

[@jakedeng2288]

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

[@prakash_77]

You can support them too :)

[@BiP00]

@@prakash_77 indeed

[@johnwig285]

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

[@gavingonzalez7174]

Yeah, I hate that people just take it for granted

[@carrot5040]

@@gavingonzalez7174 yeah me too

[@aronferix4295]

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

[@Cute-dancer859]

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

[@johnboikov1360]

I am so thankful this is out in the public domain!

[@lukmanabrahim9522]

@@johnboikov1360 80 wee. %kids

[@cathlandemmanuel831]

Amen

[@detagabi7828]

I swear when i get a job i will donate to this amazing site🙏

[@acrobat8233]

Gotten a job yet?

[@Mahakaal1221]

@@acrobat8233He is still watching I guess 😂😂

[@alrashidtowmir1099]

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

[@mso4324]

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.

[@amirjayousi149]

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

[@programmer9809]

it's not on a single day tho

[@harshparikh7898]

are you british?

[@YarikASMRPOMIRCHIY]

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

[@bishnudas3562]

I mean 3-4 ads won't hurt, Free content without ads, hatsoff

[@Zorojuro6768]

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

[@shizs8956]

How is it ? Did you watched it full ?

[@sevoysans1215]

Hey Shubham can you please tell me will this course completely cover all DBMS for gate exam?...

[@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 '/var/lib/postgresql/data/yourfile.csv' DELIMITER ',' NULL AS '' CSV HEADER; which should result in success.

[@flashbao1922]

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

[@AmrMohamed-rp8oi]

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

[@tytusgierycz5563]

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

[@programmer4042]

Free code camp saved the day again 'cause I have database systems exam tomorrow.

[@freecodecamp]

Better watch on double speed then. 😀 Good luck!

[@942255835]

14:09 DDL Commands 42:57 DML Commands 59:17 SQL Simple Analysis 2:08:15 Null Value Discussion 5:39:40 Linear Hashing

[@some1503]

0:00 introduction to database Systems 7:32 Resources 8:40 there website 9:50 intro SQL

[@jacklion109]

Bro gave up 💀

[@JulioTex]

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

[@azizjihan]

I'm literally running out of reasons to go to college.

[@orangemancometh]

Good. You can save $200,000 and avoid Marxist brainwashing all in one move.

[@outhouse.wholesaler]

except for the companies that only hire you if you have a piece of paper saying you went to college

[@rayaanhussain7279]

@@outhouse.wholesaler true That's probably the only reason to go to college . To get that piece of paper that can be extremely valuable I'd say

[@sanjayraju988]

Wish i’d found this before I’d have saved £9.25K

[@orangemancometh]

_"Educating for free"_ Inbound marketing for a four-year degree: $234,344.00. Classes on Decentering whiteness, Critical race theory, and Evils of capitalism: priceless.

[@TineshSakthiR]

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

[@omairmajid6072]

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!

[@AhmadFIksan]

Check the description, they always put the timestamp in there.

[@rodnehmofan8242]

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

[@mrTiberiuDubau]

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

[@oceanview3165]

If I knew what I know now after spending thousands of dollars on a CS degree, I would start teaching myself front end development and data base back in freshman year and gradually learn data structure and algorithms along the way. Because now that I am a senior with no knowledge of web development just except copying and pasting of react code to get the project done, I feel pretty dumb compared to other self taught programmers who are actually familiar with different frameworks.

[@alb12345672]

CS degrees teach fundamentals. I graduated with an EE/CS degree in 1995. The stuff today is very similar (Maybe a step down, we used C++, now they use Python or Java). No school is going to teach you react. Same way back then they wouldn't teach you Visual Basic or even MFC. They are teaching you academic CS, which gives you the power to quickly pick things up. But we did have an SQL course like this (I just jumped around in it, I'm using SQL now for all that time!). I did use FCC to learn React though!

[@rabbitazteca23]

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

[@rishabhkumar6535]

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

[@shizs8956]

How is it ? Did you watched it full ?

[@aushafy]

This course is better than my course on College.

[@anshulmanapure1980]

it's from cornell lol

[@berendvanbeerschot1472]

KZbin video player diff imo

[@vigneshsenthil7980]

i have this course this semester.Timing could have never been so perfect.

[@manthanthakkar6406]

Same here!

[@sevoysans1215]

Hey Vinesh and manthan can you please tell does this cover complete DBMS syllabus for gate exam?

[@sevoysans1215]

@@manthanthakkar6406 .

[@vigneshsenthil7980]

@@sevoysans1215 no this is based on the foreign syllabus i studied from "gate smashers" I was able to get good marks in my finals last sem for dbms

[@sevoysans1215]

@@vigneshsenthil7980 yeah I am in dilemma whether to do gate smasher course or this one....the univ name is attracting me

[@JorgeEscobarMX]

Introduction to Database Systems, 17 hours. Let that sink in.

[@epicgameryt4052]

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.

[@abdullahalalif9728]

is this course for begainers/engineers or is it a reffresh for concepts for studnets??

[@Abd-ov7ef]

The least thing that I can say about this channel, it's amazing and generous

[@amazhobner]

BST type of index improves results by a factor of two, this factor can be increased using tree indexes and hash indexes. B+ Trees Index. Tree Index: Traverse search tree to find interesting leaf. Hash Index: Evaluate Hash functions to find buckets. Where to use Tree Indexes? Can be used if where clause uses equal or not equal predicate. Works if predicate references index key. Tree Indexes store data in root-leaf format. Similar data is stored closed together. Hence useful for both equality and inequality predicate. Hash Indexed store data in key:hash pair, similar value may hence be far apart. Hence useful for only equality predicate. Hash Index Variants: 1) Static Hashing(Bad for dynamic data) SS in folder. 2) Extendible Hashing (Expands with few high-overhead operations) 3) Lnear Hashing (Expands more "smoothly") About Data Storage: Data is stored in some physical hardware. More the memory of that, less is the volatility but so is the query time. Lesser the memory, more the volatility but lesser the query time. Volatility refers to recovery after failure. Data is stored as files, each file is further divided into slots which are further divided into fields. Buffer stores the most frequently possible used data to reduce the query time, it retains count of how many times the data was retrieved and if it goes below say 0 or a specified amount then that data is removed from buffer. Indexes- Refer to SS. Query Processing: Input query is parsed and simplified(Rewriter). Query optimizer generates optimized execution plan. Executing plan(Executor) produces query result. Operators in Query: 6:13:20

[@piyushmahapatra5402]

Aah, Shivaratri well spent !

[@AmarKumar-zf7vk]

😊

[@Oldstoryhouse]

And my garmiyo ki chutti too🤣🤣

[@BcomingHIM]

Alexa, what is the definition of generosity?: Alexa: FCC

[@witkas5484]

It's cool how his vest colour changes over time

[@ritikagupta8530]

The course is informative and well structured but could you provide us with subtitles or enable the auto-generated subtitles. It would be very helpful.

[@ronicave8522]

Neat , now I find out this course existed a week after I had an exam about Transactions.... welp atleast il get to use it for the final.

[@lazywarrior]

I dropped this course on the first week. Looking back, this is the best decision I have ever made. Congradulations for making such an easy course so hard to understand.

[@scottzeta3067]

As usual for those pedants in the uni would do🤮

[@eloscarc5782]

Fortunately I took Harvard's CS50 Course, I can understand everything he is talking about.

[@ME-oe9gq]

Well well well, they have 8 hours part 2 also,

[@manassricharanvarri]

Thanks alot and God bless you all who are working selflessly

[@ClaytonTownley]

Thanks for the slides, too!

[@ayazahmad8431]

Thanks free code camp for sharing this awsome course to people for free. You're awesome 😚

[@bhartityagi8183]

They hv some of the best teacher.

[@AkhilNairjedi18]

Thank you so much! Please make more videos on comp sci subjects like this!

[@sevoysans1215]

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

[@neenus]

Am I seeing this correct it's a 17+ hours of database course?! Awesome 😎 thank you!

[@nidhishshanker8081]

Please do a course on system design and software architecture

[@PatriciaGarcia-u5f]

this is so beautifully made

[@jyrj]

Traditional Universities: "Our end is near, I can see it"😂 Good work freecodecamp. Keep up!

[@obi3kenobi]

You do realize that this course was posted by "Traditional University" right? Thanks to Cornell University too.

[@anshulmanapure1980]

@@obi3kenobi lol exactly

[@Laliesposito578]

So thankful with this channel 💜 thank you so much!

[@bidhanbhattarai8863]

I have said this before and I will say this again, this channel is a godsend

[@shizs8956]

How is it ? Did you watched it full ?

[@bidhanbhattarai8863]

@@shizs8956 Didn't watch in full. I covered the SQL part. It is great.

[@shizs8956]

@@bidhanbhattarai8863 thanks bro

[@basingumarma479]

I wonder when they will give us DSA course with Python..I am looking forward to that day 🤠🤠🤠

[@elluruveeranjaneyulu7651]

🔥

[@indraxios]

DSA cannot be understood with python I would say not even with java C++ is the best language maybe the only language to truly understand dsa

[@kuzonkatekar7706]

@@indraxios nonsense

[@digigoliath]

Awesome!!! And this is just part 1.

[@Rojopaal]

This is the playlist of the course: kzbin.info/aero/PLXPbT_PYOiRipfX8zrv_9EpnSOpK9P__j

[@hemantsinghjadon849]

At 02:27:35, he missed the 'Group by' clause on the student name.

[@SQL]

It's a great lecture. Thank you! 🥰

[@danieles6325]

Wow, what an upload!! 💪❤️

[@nitin992vij]

this is it, what a good time to learn. BIG THANKS !!!!!!

[@shizs8956]

How is it ? Did you watched it full ?

[@virterra]

Incredible resource. Thank you!

[@mayanksinha7160]

Helped me in My PhD thesis thank you

[@bobbush5339]

Very nice for the new student in database

[@luketetteh3561]

FreeCodeCamp is always saving lives

[@eloscarc5782]

With utmost sincerity, I didn't grasp anything, this was more words and letters than hands on. But I appreciate the upload

[@lifeisbeautifu1]

Thank you for sharing this!

[@11vag]

Thank you again freeCodeCamp. Thank you.

[@victorabugu6196]

Thanks. This platform is amazing

[@muskaanpuri4911]

I am happy that i found this course!! BUT ! I kinda need subtitles😌

[@varunnarayanan8720]

The Query Optimizer chooses the type of join, whether to use index etc..Basically we cant choose anything with regard to the method of execution other than making a key right? So basically we can skip 6.20 to 9.06

[@helloh4736]

Thank You So Much!

[@fahadbawazir1771]

Good & Awesome & waiting for the next part of 8 hours course

[@mrbilchalan]

whenever i watch any university professor lecture, i feel safe. i know i will never be misguided or misinformed.

[@Zahra-tx7pw]

I can't say how much I'm thankful. Thank you so much, really thank you^^

[@marykatherine4080]

The whole 17 hours with broke throat 😅awesome presentation.

[@aryanpokharel1181]

Massive respect to you guys!

[@sevoysans1215]

Hey Aryan is this course cover complete DBMS for gate exams

[@aryanpokharel1181]

@@sevoysans1215 yes bro

[@sevoysans1215]

@@aryanpokharel1181 thankyou bro...is it good for gates though?

[@sirisaksirisak6981]

X-ray problem.In quality control symtem if there're no defect outcome show that there's some thing missing in system of productivity alpha risk or beta risk, so we look at optimum point matter.

[@luislopes806]

I want to say that I appreciate your Video it is very informative and explanatory. I have two questions: What is the Database Management for? What are SQL Command Types used for

[@joejoeliu3185]

where can i see the solutions to the exercises 🙏

[@TheSchmed]

All our storage is SSD these days, rarely a magnetic disk, and associated I/O lag, involved anymore.

[@IshanKesharwani]

17 hours course on KZbin. A month of headache for me to complete it . 😂

[@AioriaPoderoso]

probably 3 months for me

[@mushifalinawaz]

If you watch 2 hours daily then it can be completed within 10 days.

[@shizs8956]

How is it ? Did you watched it full ?

[@hueydo3522]

it would be great if this comes with practice problems

[@codeitlikemiley]

this should have done in chunks and direct to the point, no one in their right mind would watch 17 hrs straight

[@uvwxyz36]

Thanks!

[@shashwatkumar6536]

Eak hi dil hai, kitni baar jeetoge

[@loveworthfinding802]

Excellent !

[@tanayjoshi7269]

I could finally say, "You know, I went to Cornell Dwight!"

[@MrDFJohnson]

Thank You👍👍👍👍👍 Free Code Camp !!!!!

[@ihsannuruliman3656]

lack of visualization... I literally slept watching this.

[@Iglum]

im gonna do it!

[@akkni9823]

Thank you!

[@draenog96]

Thank you for this

[@rajanmahawar442]

Amazing course keep going

[@shizs8956]

How is it ? Did you watched it full ?

[@NinoRUE]

Can you add subtiles in english please ??

[@hasanfuad6631]

Nothing to say. Just love this org.

[@elieldedeazevedosantos8533]

Deus abençoe vocês, God blessed you!!!

[@tangweizhi4701]

Please enable auto subtitles option!

[@cwtiwari9242]

Make this type video for Computer Network,Software Engineering,Web Technology

[@simplet3306]

17 hours free course ❤️

[@lyndon2487]

Thank you.

[@teddymills1188]

Dang. Every time I goto youtube it says here is a 11 or 15 hour CBT video. So of course I DL it. Do I watch it ? Im working on it :)