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

Зміст курсу

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.

Завдання

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 desktopПерейдіть на комп'ютер для реальної практикиПродовжуйте з того місця, де ви зупинились, використовуючи один з наведених нижче варіантів
Все було зрозуміло?

Як ми можемо покращити це?

Дякуємо за ваш відгук!

Секція 3. Розділ 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.

Завдання

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 desktopПерейдіть на комп'ютер для реальної практикиПродовжуйте з того місця, де ви зупинились, використовуючи один з наведених нижче варіантів
Все було зрозуміло?

Як ми можемо покращити це?

Дякуємо за ваш відгук!

Секція 3. Розділ 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.

Завдання

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 desktopПерейдіть на комп'ютер для реальної практикиПродовжуйте з того місця, де ви зупинились, використовуючи один з наведених нижче варіантів
Все було зрозуміло?

Як ми можемо покращити це?

Дякуємо за ваш відгук!

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.

Завдання

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 desktopПерейдіть на комп'ютер для реальної практикиПродовжуйте з того місця, де ви зупинились, використовуючи один з наведених нижче варіантів
Секція 3. Розділ 10
Switch to desktopПерейдіть на комп'ютер для реальної практикиПродовжуйте з того місця, де ви зупинились, використовуючи один з наведених нижче варіантів
some-alt