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

[MUSIC - FERGIE & Q TIP & GOONROCK, "A LITTLE PARTY NEVER KILLED NOBODY"]

程度の副詞

FERGIE & Q-TIP & GOONROCK: (SINGING) Just one night,

all we got, just one nigh, all we got, just one night, all we

So we going to dance until we drop, drop, drop.

Right here, right now, is all we got. skeeten-bod-op-bop.

GOONROCK, "A LITTLE PARTY NEVER KILLED NOBODY"]

(SINGING) A little party never killed nobody.

And that was a look at the so-called CS50 hackathon, this annual tradition

with which we nearly end the semester that will start around 7:00 PM here

in Cambridge, will then end around 7:00 AM the next day in Cambridge.

And punctuating the evening will be quite a bit of work

on final projects, which is the overarching goal of the evening

to give students, both an academic and a very

social and collaborative environment in which to tackle

But also, as you gleaned there will be a bit of distraction, a bit of food

from Felipe's, typically, around 9:00 PM, a little bit of Domino's Pizza

And for those still standing as in the muppet there,

we'll treat you to breakfast at IHOP if you still have the energy.

Thereafter, we'll be the so-called CS50 Fair, the climax of everything

So without further ado, where have we been these past several weeks?

Well, recall that, over the past couple of weeks,

And most recently, did we try to tie together a lot of the topics

HTML and CSS and JavaScript, and then Python, and then another framework,

another piece of software called Flask that

just made it easier and more possible to build web-based applications.

And the simplest example of that last week, recall,

And this past week with the problems on similarities and survey,

have you been building your own web-based applications.

But they haven't quite had all of the pieces

that you might want to assemble into a web-based app.

And so today, we'll fill in those final blanks.

But recall that we've been trying to frame these applications, not

as one-offs or just tools that you built, but as part

And indeed, when you're learning computer science and software

engineering, you start to notice patterns in the software,

And humans tend to adopt these patterns because they save you time.

And then everyone can speak the same language, so to speak.

So MVC was the acronym we introduced last week, Model View Controller.

And that just speaks to this paradigm whereby

you organized certain type of code in one file, certain types of other code

So your Python code goes in application.py.

Your HTML goes in your HTML files, your CSS in your CSS files, and so forth.

But what we didn't have last week was this thing here, really.

And while survey, your most recent problem,

did have data, a CSV file that's arguably a model,

You can pretty much just write rows to a text file, not unlike a spreadsheet.

You pretty much would have to reconstruct the whole file.

And indeed, that's exactly what I did back in the day.

The very first web-based application I wrote back in sophomore or junior year

And all I had available to me, both technologically and conceptually,

I had no idea what databases were, didn't realize how much easier they

So I stored all of the data behind these links here just

But today, will give you so much more power.

And especially, if you're coming into the class with an interest

in applying CS to other fields in medicine or the arts

or any world in which there's data, particularly,

in STEM and data science and the like, realize

that SQL has really become this incredibly powerful language

with which to solve problems in those and so many domains.

And ultimately, what your build, this coming week--

you have now peaked just about-- will be CD50

Finance, a web-based application by which you can buy,

And so what you're going to do this coming week is write code

字幕リスト動画再生

CS50 2018 - リーディング8 - SQL (CS50 2018 - Lecture 8 - SQL)

literally

audience

random

fancy