You're probably thinking: "Only 17 hours?" Actually the course is 25 hours. 😀Watch part 2 here: kzitem.info/news/bejne/za57ypV7pZ2Cm4Y
@santigogaming8630
3 жыл бұрын
U are the best. Thank You!
@freecodecamp
3 жыл бұрын
@KEV IN The lectures are from a Fall 2020 online lecture at Cornell.
@weeyakkawonga6243
3 жыл бұрын
Some animals don't even live that long... 🤣
@weeyakkawonga6243
3 жыл бұрын
Nice & Great Resources...
@muhamadrafipamungkas4465
3 жыл бұрын
Damn
@dimangk
3 жыл бұрын
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
3 жыл бұрын
Thanks
@vinayvupparapalli4782
3 жыл бұрын
thank you sooo much mate.!!!!
@girinskate4269
3 жыл бұрын
thank You
@oneManDev
3 жыл бұрын
Awesome, thanks!
@manishsalve9060
3 жыл бұрын
Thank you man
@jakedeng2288
3 жыл бұрын
The fact that we are getting these courses for free is just amazing
@prakash_77
3 жыл бұрын
You can support them too :)
@BiP00
3 жыл бұрын
@@prakash_77 indeed
@johnwig285
3 жыл бұрын
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
3 жыл бұрын
Yeah, I hate that people just take it for granted
@carrot5040
3 жыл бұрын
@@gavingonzalez7174 yeah me too
@aronferix4295
3 жыл бұрын
Where money is everything then there are some people really teach for free. I wish these people succeed in life.
@amirjayousi149
3 жыл бұрын
man did a 25-hour course in a library using a laptop and earphones what a legend
@programmer9809
3 жыл бұрын
it's not on a single day tho
@harshparikh7898
3 жыл бұрын
are you british?
@YarikASMRPOMIRCHIY
2 жыл бұрын
@@programmer9809 yeah duh, it's 25 hours, definetely took him more than one day. 1 hour more
@Cute-dancer859
3 жыл бұрын
GOD BLESS YOU ALL .... teachers who are enlighting the world with knowledge....
@johnboikov1360
2 жыл бұрын
I am so thankful this is out in the public domain!
@lukmanabrahim9522
2 жыл бұрын
@@johnboikov1360 80 wee. %kids
@cathlandemmanuel831
Жыл бұрын
Amen
@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.
@marthinus.x
2 жыл бұрын
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.
@alrashidtowmir1099
3 жыл бұрын
what more can I say? You guys are blessed, sharing these valuable courses with us for free!
@detagabi7828
3 жыл бұрын
I swear when i get a job i will donate to this amazing site🙏
@acrobat8233
Жыл бұрын
Gotten a job yet?
@Mahakaal1221
6 ай бұрын
@@acrobat8233He is still watching I guess 😂😂
@AmrMohamed-rp8oi
3 жыл бұрын
Such an amazing effort by FCC in the e-learning space Thanks Guys it is really appreciated 🤝 🙏
@Zorojuro6768
3 жыл бұрын
This is amazing, a full-fledged database course for free!
@shizs8956
3 жыл бұрын
How is it ? Did you watched it full ?
@sevoysans1215
3 жыл бұрын
Hey Shubham can you please tell me will this course completely cover all DBMS for gate exam?...
@bishnudas3562
3 жыл бұрын
I mean 3-4 ads won't hurt, Free content without ads, hatsoff
@tytusgierycz5563
3 жыл бұрын
It's wonderfull that there are people witch share wisdom. Now people with iron will and briliant mind could learn this beautifull concepts.
@programmer4042
3 жыл бұрын
Free code camp saved the day again 'cause I have database systems exam tomorrow.
@freecodecamp
3 жыл бұрын
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
@user-qq4pq8os6x
2 ай бұрын
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........
@flashbao1922
3 жыл бұрын
This was the course I was missing for my interview 🥺! Thanks to you!
@rabbitazteca23
3 жыл бұрын
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
@some1503
3 жыл бұрын
0:00 introduction to database Systems 7:32 Resources 8:40 there website 9:50 intro SQL
@jacklion109
10 ай бұрын
Bro gave up 💀
@azizjihan
3 жыл бұрын
I'm literally running out of reasons to go to college.
@orangemancometh
3 жыл бұрын
Good. You can save $200,000 and avoid Marxist brainwashing all in one move.
@outhouse.wholesaler
3 жыл бұрын
except for the companies that only hire you if you have a piece of paper saying you went to college
@rayaanhussain7279
3 жыл бұрын
@@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
3 жыл бұрын
Wish i’d found this before I’d have saved £9.25K
@orangemancometh
3 жыл бұрын
_"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.
@oceanview3165
3 жыл бұрын
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
3 жыл бұрын
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!
@rodnehmofan8242
3 жыл бұрын
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
@JulioTex
3 жыл бұрын
17 hours, let’s go! Thanks for always sharing amazing resources!
@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
@mrTiberiuDubau
3 жыл бұрын
awesome! thank you FCC, for this and for everything else! your efforts are highly appreciated!
@omairmajid6072
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!
@AhmadFIksan
3 жыл бұрын
Check the description, they always put the timestamp in there.
@vigneshsenthil7980
3 жыл бұрын
i have this course this semester.Timing could have never been so perfect.
@manthanthakkar6406
3 жыл бұрын
Same here!
@sevoysans1215
3 жыл бұрын
Hey Vinesh and manthan can you please tell does this cover complete DBMS syllabus for gate exam?
@sevoysans1215
3 жыл бұрын
@@manthanthakkar6406 .
@vigneshsenthil7980
3 жыл бұрын
@@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
3 жыл бұрын
@@vigneshsenthil7980 yeah I am in dilemma whether to do gate smasher course or this one....the univ name is attracting me
@ronicave8522
3 жыл бұрын
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.
@aushafy
3 жыл бұрын
This course is better than my course on College.
@anshulmanapure1980
2 жыл бұрын
it's from cornell lol
@berendvanbeerschot1472
Жыл бұрын
KZitem video player diff imo
@rishabhkumar6535
3 жыл бұрын
Salute to your effort FCC, always provide new content to learn.
@shizs8956
3 жыл бұрын
How is it ? Did you watched it full ?
@ayazahmad8431
Жыл бұрын
Thanks free code camp for sharing this awsome course to people for free. You're awesome 😚
@epicgameryt4052
2 жыл бұрын
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
7 ай бұрын
is this course for begainers/engineers or is it a reffresh for concepts for studnets??
@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🤮
@piyushmahapatra5402
3 жыл бұрын
Aah, Shivaratri well spent !
@AmarKumar-zf7vk
3 жыл бұрын
😊
@Oldstoryhouse
3 жыл бұрын
And my garmiyo ki chutti too🤣🤣
@eloscarc5782
5 ай бұрын
Fortunately I took Harvard's CS50 Course, I can understand everything he is talking about.
@ritikagupta8530
8 ай бұрын
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.
@JorgeEscobarMX
2 жыл бұрын
Introduction to Database Systems, 17 hours. Let that sink in.
@SQL
2 жыл бұрын
It's a great lecture. Thank you! 🥰
@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
@manassricharanvarri
3 жыл бұрын
Thanks alot and God bless you all who are working selflessly
@Rojopaal
3 жыл бұрын
This is the playlist of the course: kzitem.info/door/PLXPbT_PYOiRipfX8zrv_9EpnSOpK9P__j
@ME-oe9gq
3 жыл бұрын
Well well well, they have 8 hours part 2 also,
@elieldedeazevedosantos8533
3 жыл бұрын
Deus abençoe vocês, God blessed you!!!
@AkhilNairjedi18
3 жыл бұрын
Thank you so much! Please make more videos on comp sci subjects like this!
@sevoysans1215
3 жыл бұрын
Hey akhil...can you please tell me about the course...does it covers all the syllabus (DBMS) for gate exam
@neenus
3 жыл бұрын
Am I seeing this correct it's a 17+ hours of database course?! Awesome 😎 thank you!
@basingumarma479
3 жыл бұрын
I wonder when they will give us DSA course with Python..I am looking forward to that day 🤠🤠🤠
@elluruveeranjaneyulu7651
3 жыл бұрын
🔥
@indraxios
3 жыл бұрын
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
2 жыл бұрын
@@indraxios nonsense
@varunnarayanan8720
2 жыл бұрын
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
@hemantsinghjadon849
2 жыл бұрын
At 02:27:35, he missed the 'Group by' clause on the student name.
@helloh4736
3 жыл бұрын
Thank You So Much!
@nidhishshanker8081
3 жыл бұрын
Please do a course on system design and software architecture
@bhartityagi8183
3 жыл бұрын
They hv some of the best teacher.
@sirisaksirisak6981
3 жыл бұрын
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.
@Laliesposito578
3 жыл бұрын
So thankful with this channel 💜 thank you so much!
@Abd-ov7ef
3 жыл бұрын
The least thing that I can say about this channel, it's amazing and generous
@bidhanbhattarai8863
3 жыл бұрын
I have said this before and I will say this again, this channel is a godsend
@shizs8956
3 жыл бұрын
How is it ? Did you watched it full ?
@bidhanbhattarai8863
3 жыл бұрын
@@shizs8956 Didn't watch in full. I covered the SQL part. It is great.
@shizs8956
3 жыл бұрын
@@bidhanbhattarai8863 thanks bro
@eloscarc5782
3 ай бұрын
With utmost sincerity, I didn't grasp anything, this was more words and letters than hands on. But I appreciate the upload
@muskaanpuri4911
3 жыл бұрын
I am happy that i found this course!! BUT ! I kinda need subtitles😌
@jyrj
3 жыл бұрын
Traditional Universities: "Our end is near, I can see it"😂 Good work freecodecamp. Keep up!
@obi3kenobi
3 жыл бұрын
You do realize that this course was posted by "Traditional University" right? Thanks to Cornell University too.
@anshulmanapure1980
2 жыл бұрын
@@obi3kenobi lol exactly
@BcomingHIM
3 жыл бұрын
Alexa, what is the definition of generosity?: Alexa: FCC
@11vag
3 жыл бұрын
Thank you again freeCodeCamp. Thank you.
@digigoliath
3 жыл бұрын
Awesome!!! And this is just part 1.
@bobbush5339
3 жыл бұрын
Very nice for the new student in database
@nitin992vij
3 жыл бұрын
this is it, what a good time to learn. BIG THANKS !!!!!!
@shizs8956
3 жыл бұрын
How is it ? Did you watched it full ?
@mayanksinha7160
3 жыл бұрын
Helped me in My PhD thesis thank you
@user-rz5uc7kq7s
Жыл бұрын
this is so beautifully made
@ruddyfelipecadenillasalbor8687
3 жыл бұрын
Very good
@Zahra-tx7pw
3 жыл бұрын
I can't say how much I'm thankful. Thank you so much, really thank you^^
@witkas5484
3 жыл бұрын
It's cool how his vest colour changes over time
@hueydo3522
2 жыл бұрын
it would be great if this comes with practice problems
@virterra
2 жыл бұрын
Incredible resource. Thank you!
@uvwxyz36
2 жыл бұрын
Thanks!
@marykatherine4080
Жыл бұрын
The whole 17 hours with broke throat 😅awesome presentation.
@danieles6325
3 жыл бұрын
Wow, what an upload!! 💪❤️
@lifeisbeautifu1
2 жыл бұрын
Thank you for sharing this!
@IshanKesharwani
3 жыл бұрын
17 hours course on KZitem. A month of headache for me to complete it . 😂
@AioriaPoderoso
3 жыл бұрын
probably 3 months for me
@mushifalinawaz
3 жыл бұрын
If you watch 2 hours daily then it can be completed within 10 days.
@shizs8956
3 жыл бұрын
How is it ? Did you watched it full ?
@fahadbawazir1771
3 жыл бұрын
Good & Awesome & waiting for the next part of 8 hours course
@victorabugu6196
3 жыл бұрын
Thanks. This platform is amazing
@danielrocha5774
3 жыл бұрын
Thank you for this knowledge. I appreciate it very much 🤗
@MrDFJohnson
3 жыл бұрын
Thank You👍👍👍👍👍 Free Code Camp !!!!!
@pranjal204
3 жыл бұрын
Thanks
@aluwala2286
3 жыл бұрын
Thank you so much. Alway valuable .
@rajanmahawar442
3 жыл бұрын
Amazing course keep going
@shizs8956
3 жыл бұрын
How is it ? Did you watched it full ?
@TheSchmed
2 жыл бұрын
All our storage is SSD these days, rarely a magnetic disk, and associated I/O lag, involved anymore.
@nikolamicic5046
3 жыл бұрын
Thank you freeCodeCamp and thanks to The Professor from the Money Heist! :D
@shizs8956
3 жыл бұрын
How is it ? Did you watched it full ?
@hasanfuad6631
3 жыл бұрын
Nothing to say. Just love this org.
@tnustv4687
3 жыл бұрын
I hope you can translate it into many other languages to make it easier for us to understand
@berendvanbeerschot1472
Жыл бұрын
Learn english like the rest of the world
@mrbilchalan
2 жыл бұрын
whenever i watch any university professor lecture, i feel safe. i know i will never be misguided or misinformed.
@NinoRUE
2 жыл бұрын
Can you add subtiles in english please ??
@Teewaree13
3 жыл бұрын
My computer science teacher told me I wasn’t gonna be a good student, so now I’m here.
@luketetteh3561
3 жыл бұрын
FreeCodeCamp is always saving lives
@BcomingHIM
3 жыл бұрын
Can you please bring a video on GCP certification? Associate engineer or professional architect. There is very few resources on internet other than the official docs. Google suggests following courses on Coursera which are quite expensive and acloudguru is also charging a lot.
@shashwatkumar6536
3 жыл бұрын
Eak hi dil hai, kitni baar jeetoge
@ihsannuruliman3656
2 жыл бұрын
lack of visualization... I literally slept watching this.
@Iglum
3 жыл бұрын
im gonna do it!
@loveworthfinding802
3 жыл бұрын
Excellent !
@cwtiwari9242
3 жыл бұрын
Make this type video for Computer Network,Software Engineering,Web Technology
@danhle7999
3 жыл бұрын
This si awesome for a rookie like me, once I got the job I'll donate FCC. (just a little thing, this course could have been much better with subtitle, some time I don't really understand what he said (a non English speaker))
Пікірлер: 530