Conteúdo do Curso

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 And, Or, Not

To combine multiple conditions, use AND, OR, and NOT keywords, and also brackets (, ) to set the priority.

For example, you want to select all songs' titles, that were produced between 1970 and 1990 years:


              12
            
SELECT title FROM songs
WHERE year >= 1970 AND year <= 1990

Or you can select all records where singer is not Pink Floyd:


              12
            
SELECT * FROM songs
WHERE NOT singer = 'Pink Floyd'

You can combine conditions for different columns, but not forget about brackets to define the priority:


              12
            
SELECT * FROM songs
WHERE NOT (singer = 'Pink Floyd' AND price = 100)

Tarefa

Find all songs titles and prices of 20th century, where the price is less than 500, or where the singer is AC/DC.

Tarefa

Find all songs titles and prices of 20th century, where the price is less than 500, or where the singer is AC/DC.

Mude para o desktop para praticar no mundo realContinue de onde você está usando uma das opções abaixo

Tudo estava claro?

Seção 1. Capítulo 7

SQL And, Or, Not

To combine multiple conditions, use AND, OR, and NOT keywords, and also brackets (, ) to set the priority.

For example, you want to select all songs' titles, that were produced between 1970 and 1990 years:


              12
            
SELECT title FROM songs
WHERE year >= 1970 AND year <= 1990

Or you can select all records where singer is not Pink Floyd:


              12
            
SELECT * FROM songs
WHERE NOT singer = 'Pink Floyd'

You can combine conditions for different columns, but not forget about brackets to define the priority:


              12
            
SELECT * FROM songs
WHERE NOT (singer = 'Pink Floyd' AND price = 100)

Tarefa

Find all songs titles and prices of 20th century, where the price is less than 500, or where the singer is AC/DC.

Tarefa

Find all songs titles and prices of 20th century, where the price is less than 500, or where the singer is AC/DC.

Mude para o desktop para praticar no mundo realContinue de onde você está usando uma das opções abaixo

Tudo estava claro?

Seção 1. Capítulo 7

SQL And, Or, Not

To combine multiple conditions, use AND, OR, and NOT keywords, and also brackets (, ) to set the priority.

For example, you want to select all songs' titles, that were produced between 1970 and 1990 years:


              12
            
SELECT title FROM songs
WHERE year >= 1970 AND year <= 1990

Or you can select all records where singer is not Pink Floyd:


              12
            
SELECT * FROM songs
WHERE NOT singer = 'Pink Floyd'

You can combine conditions for different columns, but not forget about brackets to define the priority:


              12
            
SELECT * FROM songs
WHERE NOT (singer = 'Pink Floyd' AND price = 100)

Tarefa

Find all songs titles and prices of 20th century, where the price is less than 500, or where the singer is AC/DC.

Tarefa

Find all songs titles and prices of 20th century, where the price is less than 500, or where the singer is AC/DC.

Mude para o desktop para praticar no mundo realContinue de onde você está usando uma das opções abaixo

Tudo estava claro?

To combine multiple conditions, use AND, OR, and NOT keywords, and also brackets (, ) to set the priority.

For example, you want to select all songs' titles, that were produced between 1970 and 1990 years:


              12
            
SELECT title FROM songs
WHERE year >= 1970 AND year <= 1990

Or you can select all records where singer is not Pink Floyd:


              12
            
SELECT * FROM songs
WHERE NOT singer = 'Pink Floyd'

You can combine conditions for different columns, but not forget about brackets to define the priority:


              12
            
SELECT * FROM songs
WHERE NOT (singer = 'Pink Floyd' AND price = 100)

Tarefa

Find all songs titles and prices of 20th century, where the price is less than 500, or where the singer is AC/DC.

Mude para o desktop para praticar no mundo realContinue de onde você está usando uma das opções abaixo

Seção 1. Capítulo 7

Mude para o desktop para praticar no mundo realContinue de onde você está usando uma das opções abaixo