Name: SQL BASICS - CS50 on Twitch, EP.6 (SQL BASICS - CS50 on Twitch, EP. 6)
Uploaded: 2021-01-14T10:20:58.000Z
Duration: 1 h 29 min 39 s
Description: VoiceTubeの動画で発音を聞きながら英語表現を覚えよう！学べる英語：

And I'm joined by CS50's own David Malan.

Hello to the viewers in the chat room right now.

We got to see [? Bavick ?] [? Knights. ?]

Scotty529 says, I don't have SQL experience but I'm excited to learn.

Or I'm going to be learning some SQL today.

Yeah, Colton is going to be pretending not to know much about SQL.

DAVID MALAN: --you can experience vicariously

what it's like to learn a little bit of structured query language today.

Good to see [? Bavick ?] [? Knight, ?] Zodiac.

And [? Nuwanda, ?] that's [INAUDIBLE] from last when

DAVID MALAN: Yes, good to see some familiar usernames here.

Some of which are a little hard to pronounce,

But I hope you'll forgive just a little wave from us here.

COLTON OGDEN: All right, and so what are we going to be talking about today?

DAVID MALAN: So why don't we just talk about databases?

We actually, in CS50, of course every semester talk about SQL

But we tend to move through it really quickly.

We don't necessarily get too much into the weeds of doing things hands on.

And in fact, even when we do, we tend to use CS50 IDE.

But for the more comfortable audience that might be tuning in via Twitch,

thought we could play a little more hands on the terminal window

on my own Mac, which you can certainly do on your own PC

as well, so that it feels a little more real-world representative and less

Do you want me to move on into your laptop on the screen?

I pulled up a little throwback from 1999.

DAVID MALAN: Let's see if we're plugged in here.

DAVID MALAN: So what you're about to see is a screenshot from a website

that I think I first created back in, like, 1997.

I was a sophomore or junior in college at the time.

And I was part of the freshman intramural sports program,

COLTON OGDEN: I think you might need to-- are you on--

We're just going to go into my system preferences here on Mac OS

and make sure I'm in the right resolution.

DAVID MALAN: Let me go ahead and mirror my display here.

DAVID MALAN: Now that we have that, let's go ahead and give you 720p.

Everything is happening incorrectly here in Cambridge, Massachusetts,

So what you're seeing on the screen now behind me and Colton is Frosh IMS,

COLTON OGDEN: Who designed that great background?

Though to be fair, it was probably something we found on Google images

before there was even Google images back in the day.

COLTON OGDEN: How did you find images back then, if it--

DAVID MALAN: I think I had to call someone on the phone

Someone would deliver it to you in the mail.

Yeah, no, I don't remember where the image came from.

But clearly it's all in its 1990s glory here.

And at the time, like, so Harvard for the students

had an internal sports program, which just

means sports for those of us like myself who

couldn't compete at the varsity or junior varsity or really any level.

But at the time, if you wanted to sign up for sports,

you would literally fill out a piece of paper, walk across campus,

and then hand it to someone physically or slide it under their door.

字幕リスト動画再生

SQL BASICS - CS50 on Twitch, EP.6 (SQL BASICS - CS50 on Twitch, EP. 6)

specific

familiar

unique

frankly