Contenido del Curso
TEST SQL COURSE E2E
TEST SQL COURSE E2E
Retrieving Individual Columns
A database is an organized structure designed to store, modify, and process large amounts of data.
What is SQL?
SQL is a programming language for user interaction with databases, used to query, update, and manage databases.
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 language that returns a data set (sample) from the database. In order to use the SELECT operator, we should specify what exactly we want to select and where we want to select it from.
SELECT continent FROM country;
We used the SELECT statement in the previous query to get a single continent column from the country table. We need to specify the column name immediately after the SELECT keyword, and the FROM keyword specifies the name of the table from which we want to retrieve data.
Tarea
You have to retrieve a capital column from the country table.
Cambia al escritorio para practicar en el mundo realContinúe desde donde se encuentra utilizando una de las siguientes opciones¡Gracias por tus comentarios!
Retrieving Individual Columns
A database is an organized structure designed to store, modify, and process large amounts of data.
What is SQL?
SQL is a programming language for user interaction with databases, used to query, update, and manage databases.
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 language that returns a data set (sample) from the database. In order to use the SELECT operator, we should specify what exactly we want to select and where we want to select it from.
SELECT continent FROM country;
We used the SELECT statement in the previous query to get a single continent column from the country table. We need to specify the column name immediately after the SELECT keyword, and the FROM keyword specifies the name of the table from which we want to retrieve data.
Tarea
You have to retrieve a capital column from the country table.
Cambia al escritorio para practicar en el mundo realContinúe desde donde se encuentra utilizando una de las siguientes opciones¡Gracias por tus comentarios!
Retrieving Individual Columns
A database is an organized structure designed to store, modify, and process large amounts of data.
What is SQL?
SQL is a programming language for user interaction with databases, used to query, update, and manage databases.
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 language that returns a data set (sample) from the database. In order to use the SELECT operator, we should specify what exactly we want to select and where we want to select it from.
SELECT continent FROM country;
We used the SELECT statement in the previous query to get a single continent column from the country table. We need to specify the column name immediately after the SELECT keyword, and the FROM keyword specifies the name of the table from which we want to retrieve data.
Tarea
You have to retrieve a capital column from the country table.
Cambia al escritorio para practicar en el mundo realContinúe desde donde se encuentra utilizando una de las siguientes opciones¡Gracias por tus comentarios!
A database is an organized structure designed to store, modify, and process large amounts of data.
What is SQL?
SQL is a programming language for user interaction with databases, used to query, update, and manage databases.
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 language that returns a data set (sample) from the database. In order to use the SELECT operator, we should specify what exactly we want to select and where we want to select it from.
SELECT continent FROM country;
We used the SELECT statement in the previous query to get a single continent column from the country table. We need to specify the column name immediately after the SELECT keyword, and the FROM keyword specifies the name of the table from which we want to retrieve data.
Tarea
You have to retrieve a capital column from the country table.
Cambia al escritorio para practicar en el mundo realContinúe desde donde se encuentra utilizando una de las siguientes opcionesCambia al escritorio para practicar en el mundo realContinúe desde donde se encuentra utilizando una de las siguientes opciones