Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.SQL Aliases | Filtering Statements
SQL Tutorial for Beginners
course content

Conteúdo do Curso

SQL Tutorial for Beginners

SQL Tutorial for Beginners

1. Database & Introduction to Syntax
Meet the SQLSelect the Songs!SQL Select ColumnSQL DistinctSQL WhereChallenge WhereSQL And, Or, Not
2. SQL Aggregate Functions
SQL Min and MaxChallenge Min and MaxSQL Count, Sum, AvgChallenge Count
3. Filtering Statements
SQL NullSQL LikeChallenge LikeSQL BetweenSQL Order ByChallenge Order BySQL Group ByChallenge Group BySQL Top and LimitSQL AliasesSQL HavingChallenge HavingSQL Comments

bookSQL Aliases

Ususally in database tables and columns can have long names. When you work with multiple tables, you should write the name of the column with the name of the table to define the column, for example, users.user_id and messages.date_created. To avoid overtyping, in SQL we use Aliases. They allow us to give temporary names to column or tables.

For example, for our table:


              
123

            
SELECT album, singer as some_label
FROM songs as t
WHERE t.album = 'The Dark Side of the Moon' OR t.singer = 'Mushmellow'
copy

Here you use table songs as t. In the console, instead of singer, your column has a label some_label. This example is not demonstrative enough, but in the next section we'll work with multiple tables, and temporary names may be useful.

Tarefa

Find top-3 newest songs, their singers, and years, but use songs table as s. Make the column title displayed with the label name.

Switch to desktopMude para o desktop para praticar no mundo realContinue de onde você está usando uma das opções abaixo
Tudo estava claro?

Como podemos melhorá-lo?

Obrigado pelo seu feedback!

Seção 3. Capítulo 10
toggle bottom row

bookSQL Aliases

Ususally in database tables and columns can have long names. When you work with multiple tables, you should write the name of the column with the name of the table to define the column, for example, users.user_id and messages.date_created. To avoid overtyping, in SQL we use Aliases. They allow us to give temporary names to column or tables.

For example, for our table:


              
123

            
SELECT album, singer as some_label
FROM songs as t
WHERE t.album = 'The Dark Side of the Moon' OR t.singer = 'Mushmellow'
copy

Here you use table songs as t. In the console, instead of singer, your column has a label some_label. This example is not demonstrative enough, but in the next section we'll work with multiple tables, and temporary names may be useful.

Tarefa

Find top-3 newest songs, their singers, and years, but use songs table as s. Make the column title displayed with the label name.

Switch to desktopMude para o desktop para praticar no mundo realContinue de onde você está usando uma das opções abaixo
Tudo estava claro?

Como podemos melhorá-lo?

Obrigado pelo seu feedback!

Seção 3. Capítulo 10
toggle bottom row

bookSQL Aliases

Ususally in database tables and columns can have long names. When you work with multiple tables, you should write the name of the column with the name of the table to define the column, for example, users.user_id and messages.date_created. To avoid overtyping, in SQL we use Aliases. They allow us to give temporary names to column or tables.

For example, for our table:


              
123

            
SELECT album, singer as some_label
FROM songs as t
WHERE t.album = 'The Dark Side of the Moon' OR t.singer = 'Mushmellow'
copy

Here you use table songs as t. In the console, instead of singer, your column has a label some_label. This example is not demonstrative enough, but in the next section we'll work with multiple tables, and temporary names may be useful.

Tarefa

Find top-3 newest songs, their singers, and years, but use songs table as s. Make the column title displayed with the label name.

Switch to desktopMude para o desktop para praticar no mundo realContinue de onde você está usando uma das opções abaixo
Tudo estava claro?

Como podemos melhorá-lo?

Obrigado pelo seu feedback!

Ususally in database tables and columns can have long names. When you work with multiple tables, you should write the name of the column with the name of the table to define the column, for example, users.user_id and messages.date_created. To avoid overtyping, in SQL we use Aliases. They allow us to give temporary names to column or tables.

For example, for our table:


              
123

            
SELECT album, singer as some_label
FROM songs as t
WHERE t.album = 'The Dark Side of the Moon' OR t.singer = 'Mushmellow'
copy

Here you use table songs as t. In the console, instead of singer, your column has a label some_label. This example is not demonstrative enough, but in the next section we'll work with multiple tables, and temporary names may be useful.

Tarefa

Find top-3 newest songs, their singers, and years, but use songs table as s. Make the column title displayed with the label name.

Switch to desktopMude para o desktop para praticar no mundo realContinue de onde você está usando uma das opções abaixo
Seção 3. Capítulo 10
Switch to desktopMude para o desktop para praticar no mundo realContinue de onde você está usando uma das opções abaixo
some-alt