Course Content
Introduction to SQL
Introduction to SQL
Retrieving Individual Columns
What is SQL?
SQL is a programming language for user interaction with databases, used to query, update, and manage databases.
Database
A database is an organized structure designed to store, modify, and process large amounts of data.
Let’s get started! In this course, we will work with a country
database containing a country
table. Let's look at this table.
SELECT
is an operator in the SQL language that retrieves a data set (sample) from the database. To use the SELECT
operator effectively, we need to specify exactly what we want to select and where we want to select it from.
SELECT continent FROM country;
In our previous query, we utilized the SELECT
to retrieve a single continent column from the country table.
It's important to note that you must specify the column name immediately after the SELECT
keyword, and the FROM
keyword specifies the name of the table from which we wish to retrieve data.
Task
Now, let's retrieve a capital
column from the country
table.
Once you've completed this task, click the button below the code to check your solution.
Thanks for your feedback!
Retrieving Individual Columns
What is SQL?
SQL is a programming language for user interaction with databases, used to query, update, and manage databases.
Database
A database is an organized structure designed to store, modify, and process large amounts of data.
Let’s get started! In this course, we will work with a country
database containing a country
table. Let's look at this table.
SELECT
is an operator in the SQL language that retrieves a data set (sample) from the database. To use the SELECT
operator effectively, we need to specify exactly what we want to select and where we want to select it from.
SELECT continent FROM country;
In our previous query, we utilized the SELECT
to retrieve a single continent column from the country table.
It's important to note that you must specify the column name immediately after the SELECT
keyword, and the FROM
keyword specifies the name of the table from which we wish to retrieve data.
Task
Now, let's retrieve a capital
column from the country
table.
Once you've completed this task, click the button below the code to check your solution.
Thanks for your feedback!
Retrieving Individual Columns
What is SQL?
SQL is a programming language for user interaction with databases, used to query, update, and manage databases.
Database
A database is an organized structure designed to store, modify, and process large amounts of data.
Let’s get started! In this course, we will work with a country
database containing a country
table. Let's look at this table.
SELECT
is an operator in the SQL language that retrieves a data set (sample) from the database. To use the SELECT
operator effectively, we need to specify exactly what we want to select and where we want to select it from.
SELECT continent FROM country;
In our previous query, we utilized the SELECT
to retrieve a single continent column from the country table.
It's important to note that you must specify the column name immediately after the SELECT
keyword, and the FROM
keyword specifies the name of the table from which we wish to retrieve data.
Task
Now, let's retrieve a capital
column from the country
table.
Once you've completed this task, click the button below the code to check your solution.
Thanks for your feedback!
What is SQL?
SQL is a programming language for user interaction with databases, used to query, update, and manage databases.
Database
A database is an organized structure designed to store, modify, and process large amounts of data.
Let’s get started! In this course, we will work with a country
database containing a country
table. Let's look at this table.
SELECT
is an operator in the SQL language that retrieves a data set (sample) from the database. To use the SELECT
operator effectively, we need to specify exactly what we want to select and where we want to select it from.
SELECT continent FROM country;
In our previous query, we utilized the SELECT
to retrieve a single continent column from the country table.
It's important to note that you must specify the column name immediately after the SELECT
keyword, and the FROM
keyword specifies the name of the table from which we wish to retrieve data.
Task
Now, let's retrieve a capital
column from the country
table.
Once you've completed this task, click the button below the code to check your solution.