The outro track for this video is Shaolin Brew by Wu-Tang Clan. After trying to hunt down this unfamiliar track on the frequently mentioned 36 Chambers and Shazam without success, I ended up finding it was released on the St. Ides Mixtape in 1994, which is also referenced in this video at 21:14. Nice touch.
is that what he was talking about at the very end where he said the most important thing to remember about databases? he was giving a history about Wu-Tang Clan? prof is funny
This guy is a really good teacher. Db was one of my least favorite classes during CS, but at the end of this lecture I'm looking forward to the next video.
@49:12 I think a set MUST have unique values, as stated in the video "CANNOT have duplicate values", however - I have seen many tables of data with duplicate data.
The most important thing you need to understand about databases throughout this, through the rest of your life is the following: when you look back at the 36 Chambers, understand who were the original 9 involved in it. You have the RZA, the GZA, Inspectah Deck, Ghostface Killah, Masta Killa, U-God, Method Man, Ol' Dirty Bastard, Raekwon. But, the other important thing too is Cappadonna was in jail at the time, so he was actually an original member of the clan. But because he was in jail, he couldn't be on the 36 Chambers. So, that's the most important thing you need to understand throughout this entire semester.
@@sahinsarkar7293 He really likes the wu-tang clan and it's joke that he does references to it. He even had given students final exam to name all the members in the 36 chambers album in five minutes.
اللهم صل على محمد وعلى ال محمد كما صليت على ابراهيم وعلى ال ابراهيم انك حميد مجيد اللهم بارك على محمد وعلى ال محمد كما باركت على ابراهيم وعلى ال ابراهيم انك حميد مجيد 😍😍😍😍
@48:34 What is the difference between a Data Manipulation Language and a Query Language? I read in Silverschatz book Ch2.5 A query language is a language in which a user requests information from the database. For which they mention SQL to be a Query Language.
A data-manipulation language (DML) is a language that enables users to access or manipulate data as organized by the appropriate data mode. The types of access are: a. Retrieval of information stored in the database; b. Insertion of new information into the database; c. Deletion of information from the database; d. Modification of information stored in the database. A query is a statement requesting the retrieval of information. The portion of a DML that involves information retrieval is called a query language. Although technically incorrect, it is common practice to use the terms query language and data-manipulation language synonymously.
I want to do the course assignments and homework. I see that piazza is for CMU students. I understand that. Is there any interest in community backed discussion forum ? for questions and help during working on assignments ..
Why are these the tradeoffs for the course? IMO the storage aspect is overemphasized (esp. that it's said to be disk based, which is getting historical) while some others are ignored for the time being (eg. a level of SQL compatibility)
Disk based storage is still used very frequently due to the cost and capacity constraints on SSDs. The industry is a little slower than most others, so I don't think the material you learn here will be obsolete as soon as you might be thinking.
It seems to me that from the relational algebra standpoint there is no such thing as _inner join_ or _natural join_ , just "join", which is a _natural join_ in SQL. In SQL, the difference is: (1) For inner join you have to specify the join condition, and it does not have to be the equality. In natural join, it is always equality, and it requires similar named columns in both tables. (2) Natural join outputs a join column only once, whereas inner join outputs this column twice - from each of the input tables. At least I know that Oracle Database does just that.
Need to change career path due to current circumstances and considering to work from home. What class should I enroll in since I have no tech oriented CV.
god!!!!????? is this guy in the .....bathroom??????? I dont even know CMU before this video but when i search it online....god....dont even know what should i say...crazy man......
this is Carnegie Mellon University, right? the 70k a year Carnegie Mellon University? And the teacher for one of the most important subjects in CS sits in a bathtub and drops lines like "your shitty C++ code...". not that the content of the lecture is no good just the looks of it are .... you know.
If the purpose of paying institutions money is to gain knowledge to get a job, what kind of employer is going to make a hiring decision based on the fact the instructor isn't in a classroom? Like where do you put on a CV or resume or job application "took x course where instructor did not deliver content from an Ivory tower?" Its 2021, not 1901. Get off your privileged high horse and stop worrying about the optics and reputation of what _surrounds_ knowledge and worry more about the value of the knowledge itself.
The outro track for this video is Shaolin Brew by Wu-Tang Clan. After trying to hunt down this unfamiliar track on the frequently mentioned 36 Chambers and Shazam without success, I ended up finding it was released on the St. Ides Mixtape in 1994, which is also referenced in this video at 21:14. Nice touch.
This is so cool
is that what he was talking about at the very end where he said the most important thing to remember about databases? he was giving a history about Wu-Tang Clan? prof is funny
2:10 Today's agenda
2:35 Wait list
3:48 Course overview
5:26 Course outline
6:45 Course logistics
8:09 Textbook
9:24 Course rubric
10:03 Homeworks
11:02 Projects
12:55 BusTub
14:50 Late policy
15:40 Plagiarism warning
16:45 Database research
Actual content:
18:12 Databases
19:30 Database example (digital music store)
20:05 Flat file strawman (CSV)
22:37 Flat files: data integrity
24:32 Flat files: implementation [problems]
26:20 Flat files: durability
27:14 Database management system
30:00 Early DBMSs
32:49 Relational model (Edgar F. Codd)
36:48 Data models
37:48 Data model
40:08 Relational model
43:13 Relational model: primary keys
44:58 Relational model: foreign keys
46:36 Data manipulation languages (DML
48:40 Relational algebra
50:00 Relational algebra: select σ
51:50 Relational algebra: projection Π
53:07 Relational algebra: union ∪ (UNION ALL)
54:09 Relational algebra: intersection ∩
54:49 Relational algebra: difference − (EXCEPT)
55:21 Relational algebra: product × (CROSS JOIN)
56:16 Relational algebra: natural join ⋈
57:55 Relational algebra: extra operators (rename ρ, assignment R←S, duplicate elimination δ, aggregation γ, sorting τ, division R÷S)
58:46 Observation: relational algebra still defines the high-level steps of how to compute a query
1:02:03 Relational model: queries
1:04:02 Conclusion
1:05:18 One last thing
Thanks dude!
Thanks bud..you made things easy ~
Prof. Andy most humble teacher out there, he is literally recording from the bathtub. Respect!
Why was he in the bathtub???
@@davidcmpeterson Because the bathroom is a man's castle.
@@kicksomeup6998 ya that 👍🏻
This guy is a really good teacher. Db was one of my least favorite classes during CS, but at the end of this lecture I'm looking forward to the next video.
Recording in the bathtub is the perfect punchline for the name BusTub
That's really vivid and homophonic.. Ha Ha Ha
starts at 18:20
tysm
thx
57:28 I think the professor meant to say "the reason why Natural Join is different than the Intersection" not than difference...?
yes. thanks. I got confused.
DAMN!!!! I wish I had a professor like him in my college. He is just freaking awesome
@49:12 I think a set MUST have unique values, as stated in the video "CANNOT have duplicate values", however - I have seen many tables of data with duplicate data.
The most important thing you need to understand about databases throughout this, through the rest of your life is the following: when you look back at the 36 Chambers, understand who were the original 9 involved in it. You have the RZA, the GZA, Inspectah Deck, Ghostface Killah, Masta Killa, U-God, Method Man, Ol' Dirty Bastard, Raekwon. But, the other important thing too is Cappadonna was in jail at the time, so he was actually an original member of the clan. But because he was in jail, he couldn't be on the 36 Chambers. So, that's the most important thing you need to understand throughout this entire semester.
I'm missing the story here. What pop culture he is referring to?
@@danielkurniadi8805 Wu-Tang clan
And why is this important? or was it a sarcasm and he just wanted to insert a random anecdote for some reason
@@sahinsarkar7293 He really likes the wu-tang clan and it's joke that he does references to it.
He even had given students final exam to name all the members in the 36 chambers album in five minutes.
dude is literally in his bathtub, mad respect
swyx in the bildin
@@420_gunna sup
This is my favourite course after David J Malan's Cs50 and I have taken 70+ courses till now
You must be really knowledgeable :)
اللهم صل على محمد وعلى ال محمد كما صليت على ابراهيم وعلى ال ابراهيم انك حميد مجيد اللهم بارك على محمد وعلى ال محمد كما باركت على ابراهيم وعلى ال ابراهيم انك حميد مجيد
😍😍😍😍
I was just a freshman by the time this lecture happened. Time passed so fast
49:03 he must’ve meant cannot have duplicates?
Is he, in the bathtub ?!!
Yah bro it's style 😎
@48:34 What is the difference between a Data Manipulation Language and a Query Language? I read in Silverschatz book Ch2.5 A query language is a language in which a user requests information from the database. For which they mention SQL to be a Query Language.
A data-manipulation language (DML) is a language that enables users to access or manipulate data as organized by the appropriate data mode. The types of access are: a. Retrieval of information stored in the database; b. Insertion of new information into the database; c. Deletion of information from the database; d. Modification of information stored in the database. A query is a statement requesting the retrieval of information. The portion of a DML that involves information retrieval is called a query language. Although technically incorrect, it is common practice to use the terms query language and data-manipulation language synonymously.
He is back baby!
Amazing way to teach. It’s a good revision for me.
You guys are the best!
Great stuff brah, much love and appreciation
He says that the NULL value is a member of every domain. But what if i define a column as NOT NULL?
to get comfortable with lecture, what prerequisites we must have to get catch up?
if you found out let me know
is it possible to access to the c++ self-assessment/exam that he was talking about?
can you make your cam smaller because it take a lot of space and hide some content of the video thanks!
is he... is he lecturing from the bathroom?
i luv the new intro theme
Great! I could almost fall in love with DBMS now...
I want to do the course assignments and homework. I see that piazza is for CMU students. I understand that.
Is there any interest in community backed discussion forum ? for questions and help during working on assignments ..
I'm interested
@@charlesfleetwood3914 discord.gg/WE2T7FYN
@@AshishNegi1618 hey would ya mind sending the invite again?
What amazing explanation !! 😍😍😍
Would you please upload the lecture video of CMU 15-445/645 Fall 2020? Thank you !
I'm trying to use this video to fresh up my memory of elementary DBMS course but I'm so confused about what Andy said at the end
Is intersection and natural join the same?
This professor is really amazing, especially when you consider that he's prolly sitting in his bathtub.
Why are these the tradeoffs for the course? IMO the storage aspect is overemphasized (esp. that it's said to be disk based, which is getting historical) while some others are ignored for the time being (eg. a level of SQL compatibility)
Disk based storage is still used very frequently due to the cost and capacity constraints on SSDs. The industry is a little slower than most others, so I don't think the material you learn here will be obsolete as soon as you might be thinking.
What is the Intro Track ?
is any different between videos from 2018 and this videos and what i can see 2018 or 2019? Thanks
2020: Pay me for your bathtub videos!
2109: LOL
Hi all, just wonder if I need the SQL knowledge and experience before this course?
Maybe just a little knowledge or experience is enough (hope it's not too late for u)
What is the difference between Natural Join and Inner Join?
It seems to me that from the relational algebra standpoint there is no such thing as _inner join_ or _natural join_ , just "join", which is a _natural join_ in SQL. In SQL, the difference is:
(1) For inner join you have to specify the join condition, and it does not have to be the equality. In natural join, it is always equality, and it requires similar named columns in both tables.
(2) Natural join outputs a join column only once, whereas inner join outputs this column twice - from each of the input tables. At least I know that Oracle Database does just that.
is this course good for someone who doesn't know anything about database ?
I don't get his last thing, can anyone explain it :)
He is explaining the original members of the music group Wu-Tang Clan which some of the previous examples mentioned.
do I need to learn this to get a data engineer job?
You probably need other courses he mentioned.
why is he in a bathtub? how has he not mentioned anything about sitting in a bathtub?
I know, I was wondering too!!
Need to change career path due to current circumstances and considering to work from home. What class should I enroll in since I have no tech oriented CV.
Cs61b
Mad Respect !
Who's Matt?
Is that a bathroom? Lmao 😂
welcome back
EPIC!! - UnReAL ...
This. F&$%ing .RULES.
awesome
The guy in the bathtub anyone is thinking about breaking bad ?
god!!!!????? is this guy in the .....bathroom??????? I dont even know CMU before this video but when i search it online....god....dont even know what should i say...crazy man......
Thug Prof
11:49
36:00
Is he sitting in a bathtub ?
😂😂😂😂
That's a valid question
Excellent lecture. Our of curiosity, are you sitting in a bath tub ?
Boss.
Wu-Tang !!!
Am I trippin, or this guy teaching from a bathtub?
wu tang
:)
Are you sitting in the bathroom? Wth is this?
this is Carnegie Mellon University, right? the 70k a year Carnegie Mellon University? And the teacher for one of the most important subjects in CS sits in a bathtub and drops lines like "your shitty C++ code...". not that the content of the lecture is no good just the looks of it are .... you know.
> not that the content of the lecture is no good just the looks of it are .... you know.
No, I don't know. Please explain what you mean.
If the purpose of paying institutions money is to gain knowledge to get a job, what kind of employer is going to make a hiring decision based on the fact the instructor isn't in a classroom? Like where do you put on a CV or resume or job application "took x course where instructor did not deliver content from an Ivory tower?"
Its 2021, not 1901. Get off your privileged high horse and stop worrying about the optics and reputation of what _surrounds_ knowledge and worry more about the value of the knowledge itself.
@sing1609