Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.
The very first meet with the database | Selecting
SQL Basics
course content

Contenido del Curso

SQL Basics

SQL Basics

1. Selecting
2. Filtering
3. Aggregating
4. Sorting
5. Grouping
6. Practicing

bookThe very first meet with the database

Welcome on board! SQL (Structured Query Language) is the programming language used for manipulating and extracting data from databases. Usually, the code used to extract some data is called a query. In this course, you will learn how to build different queries: from the simplest to more complex. Over this course, you will work with the audi_cars database which contains information on price, model, and different characteristics of used Audi cars.

The very first query

The simplest query in SQL looks like a sentence: select something from somewhere. To select all the rows from the database write

12
SELECT * FROM table_name
copy

Please note, that SQL is case-insensitive, i.e. SELECT and select will be equally interpreted by SQL.

Tarea
test

Swipe to show code editor

Extract all the rows from the audi_cars table.

Switch to desktopCambia al escritorio para practicar en el mundo realContinúe desde donde se encuentra utilizando una de las siguientes opciones
¿Todo estuvo claro?

¿Cómo podemos mejorarlo?

¡Gracias por tus comentarios!

Sección 1. Capítulo 1
toggle bottom row

bookThe very first meet with the database

Welcome on board! SQL (Structured Query Language) is the programming language used for manipulating and extracting data from databases. Usually, the code used to extract some data is called a query. In this course, you will learn how to build different queries: from the simplest to more complex. Over this course, you will work with the audi_cars database which contains information on price, model, and different characteristics of used Audi cars.

The very first query

The simplest query in SQL looks like a sentence: select something from somewhere. To select all the rows from the database write

12
SELECT * FROM table_name
copy

Please note, that SQL is case-insensitive, i.e. SELECT and select will be equally interpreted by SQL.

Tarea
test

Swipe to show code editor

Extract all the rows from the audi_cars table.

Switch to desktopCambia al escritorio para practicar en el mundo realContinúe desde donde se encuentra utilizando una de las siguientes opciones
¿Todo estuvo claro?

¿Cómo podemos mejorarlo?

¡Gracias por tus comentarios!

Sección 1. Capítulo 1
toggle bottom row

bookThe very first meet with the database

Welcome on board! SQL (Structured Query Language) is the programming language used for manipulating and extracting data from databases. Usually, the code used to extract some data is called a query. In this course, you will learn how to build different queries: from the simplest to more complex. Over this course, you will work with the audi_cars database which contains information on price, model, and different characteristics of used Audi cars.

The very first query

The simplest query in SQL looks like a sentence: select something from somewhere. To select all the rows from the database write

12
SELECT * FROM table_name
copy

Please note, that SQL is case-insensitive, i.e. SELECT and select will be equally interpreted by SQL.

Tarea
test

Swipe to show code editor

Extract all the rows from the audi_cars table.

Switch to desktopCambia al escritorio para practicar en el mundo realContinúe desde donde se encuentra utilizando una de las siguientes opciones
¿Todo estuvo claro?

¿Cómo podemos mejorarlo?

¡Gracias por tus comentarios!

Welcome on board! SQL (Structured Query Language) is the programming language used for manipulating and extracting data from databases. Usually, the code used to extract some data is called a query. In this course, you will learn how to build different queries: from the simplest to more complex. Over this course, you will work with the audi_cars database which contains information on price, model, and different characteristics of used Audi cars.

The very first query

The simplest query in SQL looks like a sentence: select something from somewhere. To select all the rows from the database write

12
SELECT * FROM table_name
copy

Please note, that SQL is case-insensitive, i.e. SELECT and select will be equally interpreted by SQL.

Tarea
test

Swipe to show code editor

Extract all the rows from the audi_cars table.

Switch to desktopCambia al escritorio para practicar en el mundo realContinúe desde donde se encuentra utilizando una de las siguientes opciones
Sección 1. Capítulo 1
Switch to desktopCambia al escritorio para practicar en el mundo realContinúe desde donde se encuentra utilizando una de las siguientes opciones
We're sorry to hear that something went wrong. What happened?
some-alt