Зміст курсу

SQL Tutorial for Beginners

1. Database & Introduction to Syntax

Meet the SQL Select the Songs!SQL Select Column SQL Distinct SQL Where Challenge Where SQL And, Or, Not

2. SQL Aggregate Functions

SQL Min and Max Challenge Min and Max SQL Count, Sum, Avg Challenge Count

3. Filtering Statements

SQL Null SQL Like Challenge Like SQL Between SQL Order By Challenge Order By SQL Group By Challenge Group By SQL Top and Limit SQL Aliases SQL Having Challenge Having SQL Comments

SQL Like

The LIKE operator is used with WHERE to search for some pattern in a string.

The pattern is usually some kind of Regular Expression that is built with some rules, but we won't dive deep into it. In the meantime, the following rules are enough for you:

% means 0 or more symbols: a% matches a, aa, aaaaa, etc. b%d matches bd, bad, bored, etc.
_ matches single symbol. t_ee matches tree, twee etc, and _o%_ match wow, coooow, soap etc., but not so for example.

In this example all singers with the naming of two separate words, both consist of at least one symbol.


              12
            
SELECT singer FROM songs
WHERE singer LIKE '_% _%'

Завдання

Select all singers with naming starting with A.

Завдання

Select all singers with naming starting with A.

Перейдіть на комп'ютер для реальної практикиПродовжуйте з того місця, де ви зупинились, використовуючи один з наведених нижче варіантів

Все було зрозуміло?

Секція 3. Розділ 2

SQL Like

The LIKE operator is used with WHERE to search for some pattern in a string.

The pattern is usually some kind of Regular Expression that is built with some rules, but we won't dive deep into it. In the meantime, the following rules are enough for you:

% means 0 or more symbols: a% matches a, aa, aaaaa, etc. b%d matches bd, bad, bored, etc.
_ matches single symbol. t_ee matches tree, twee etc, and _o%_ match wow, coooow, soap etc., but not so for example.

In this example all singers with the naming of two separate words, both consist of at least one symbol.


              12
            
SELECT singer FROM songs
WHERE singer LIKE '_% _%'

Завдання

Select all singers with naming starting with A.

Завдання

Select all singers with naming starting with A.

Все було зрозуміло?

Секція 3. Розділ 2

SQL Like

The LIKE operator is used with WHERE to search for some pattern in a string.

The pattern is usually some kind of Regular Expression that is built with some rules, but we won't dive deep into it. In the meantime, the following rules are enough for you:

% means 0 or more symbols: a% matches a, aa, aaaaa, etc. b%d matches bd, bad, bored, etc.
_ matches single symbol. t_ee matches tree, twee etc, and _o%_ match wow, coooow, soap etc., but not so for example.

In this example all singers with the naming of two separate words, both consist of at least one symbol.


              12
            
SELECT singer FROM songs
WHERE singer LIKE '_% _%'

Завдання

Select all singers with naming starting with A.

Завдання

Select all singers with naming starting with A.

Все було зрозуміло?

The LIKE operator is used with WHERE to search for some pattern in a string.

The pattern is usually some kind of Regular Expression that is built with some rules, but we won't dive deep into it. In the meantime, the following rules are enough for you:

% means 0 or more symbols: a% matches a, aa, aaaaa, etc. b%d matches bd, bad, bored, etc.
_ matches single symbol. t_ee matches tree, twee etc, and _o%_ match wow, coooow, soap etc., but not so for example.

In this example all singers with the naming of two separate words, both consist of at least one symbol.


              12
            
SELECT singer FROM songs
WHERE singer LIKE '_% _%'

Завдання

Select all singers with naming starting with A.

Секція 3. Розділ 2