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

Course Content

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.

Task

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 desktopSwitch to desktop for real-world practiceContinue from where you are using one of the options below
Everything was clear?

How can we improve it?

Thanks for your feedback!

Section 3. Chapter 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.

Task

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 desktopSwitch to desktop for real-world practiceContinue from where you are using one of the options below
Everything was clear?

How can we improve it?

Thanks for your feedback!

Section 3. Chapter 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.

Task

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 desktopSwitch to desktop for real-world practiceContinue from where you are using one of the options below
Everything was clear?

How can we improve it?

Thanks for your 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.

Task

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 desktopSwitch to desktop for real-world practiceContinue from where you are using one of the options below
Section 3. Chapter 10
Switch to desktopSwitch to desktop for real-world practiceContinue from where you are using one of the options below
some-alt