Name: CS50 2019 - リーディング7 - SQL (CS50 2019 - Lecture 7 - SQL)
Uploaded: 2021-01-14T10:20:27.000Z
Duration: 1 h 46 min 23 s
Description: VoiceTubeの動画で発音を聞きながら英語表現を覚えよう！学べる英語：

So this is CS50, and this day we continue our look at Python,

This one is called SQL, or Structured Query Language,

and it's going to allow us to solve some different problems as well

But to do this, let's try to motivate some of the problems initially.

So this, of course, is just an example of a spreadsheet.

Odds are you use these pretty frequently,

whether it's in the form of Google Spreadsheets or Excel

And this is actually the simplest form of what we might call a database,

just some kind of application that stores lots of data.

And odds are if you've ever taken registrations for a student group

or had people sign up or fill out a form or a survey,

odds are you've used Google Forms to get your data into a Google Spreadsheet.

And so we thought we would begin there today,

a representative problem whereby you might want to collect a lot of data

from users and then do something with it,

but ideally more powerfully than you could do as a human on your own.

So we've put into place a Google Form that quite simply

And we ask you for the title of your favorite show and the genre

So if you wouldn't mind, go ahead and open up this URL here

You can use the person's next to you, if I may.

And take just a moment to go to that URL there and answer those two questions.

What is the title of your favorite TV show, and into what genre or genres

And when you go to that URL, you'll find yourself at, again, this form here,

asking for your title and for your favorite show.

So by the look of my own screen here we've

got some 62 responses, 74 responses coming in already,

We'll give it another few seconds, but suffice it to say,

And if the next step in this process were

for me to analyze the data because I'm curious to know

what's the most popular show on campus or if I wanted

to do some other analytical work on this,

it'll be useful to have all of this data,

not in Google Form's proprietary interface,

but in Google Spreadsheet form with rows and columns, a format you're probably

So we'll let this counter keep going up and up and up,

and I'm going to go ahead and click on responses.

And if we really wanted to, we could look through--

The Office is up there, followed by Games of Thrones, Friends, OK.

Let me go ahead and click this icon, which

is going to open the Google Spreadsheet version of this.

And you'll see that there's three columns by default.

Now-- so you'll see that by default we got three columns.

Timestamp, Google Forms just does automatically

And if we kept scrolling and scrolling, odds

Let's propose that we have enough of these rows already,

and how might we go about analyzing the data?

Well, if you're pretty expert with Google Spreadsheets or Excel

or Numbers, maybe you could use some functions that

are built into these programs or you could do some Command-F or Control-F

and search for the favorite show that you're

But we have programming abilities nowadays.

And if you haven't used this feature already,

if you go to Google Spreadsheet's file menu.

You can go to download, and you can download your data

And the most useful one I'd propose for now

is going to be this one, Comma-Separated Values or CSV.

So if I go ahead and do that, it pretty quickly downloaded a CSV file

that I really wanted to I could open in Excel or Apple Numbers or the like.

But let's do something instead with that, and go ahead and put it into,

for instance, my IDE so that I can actually do something with it.

字幕リスト動画再生

CS50 2019 - リーディング7 - SQL (CS50 2019 - Lecture 7 - SQL)

literally

sort

bunch

structure