All language subtitles for 15 - What Is SQL English

All right, so now we're getting to the core of the course, what is askew?

Well, and there may be a lot of questions surrounding what a school is.

Well, school is a language that we will be using to talk to our databases.

It's a programming language and a programming language, in essence, is a set of instructions that

we are using to talk to a system to get a specific output and output being an answer.

In this case, we're asking for data.

And with a school, we are mainly talking to databases.

Now, a database is nothing more than a structured set of data.

Now, you may ask yourself, what kind of structure are we talking about here, right?

There are different structures that you could basically apply to data.

Well, heck, we could take a notepad and we could write a book in there, or we could take an Excel

sheet and make a personal budget.

And all of these ways of storing data are your own structure, right?

Like you determine in a notepad.

This is my headline.

This is my body.

This is my paragraph.

In an Excel sheet, you can say these are my columns, these are my rows.

This is how I'm going to put the data in here.

But when we go off to database country, we're looking at these huge companies like Amazon and Microsoft

and all of these big corporations that are basically helping out millions and millions and millions

of people.

And when you have that much data, you can't just go into a flat file or an Excel sheet and store that

much data.

You need a larger system and a database.

In essence, is that larger system?

Now, what determines, like, how we're going to store data in a database and what makes a database?

Right.

Well, there are different models you can follow.

And throughout the course, we're going to talk about these different models, mainly focusing on one.

And Eskil is going to be the language that we're going to be utilizing to talk to the database, to

pull data, to insert data and so forth, and when we use a school, we are going to be writing statements,

statements, being instructions that we're going to give to the database to give us back data.

These are called queries.

Now, let's dive a bit deeper into what a query exactly is.