Contenido del 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)

Tarea

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

Tarea

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

Cambia al escritorio para practicar en el mundo realContinúe desde donde se encuentra utilizando una de las siguientes opciones

¿Todo estuvo claro?

Sección 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)

Tarea

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

Tarea

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

Cambia al escritorio para practicar en el mundo realContinúe desde donde se encuentra utilizando una de las siguientes opciones

¿Todo estuvo claro?

Sección 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)

Tarea

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

Tarea

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

Cambia al escritorio para practicar en el mundo realContinúe desde donde se encuentra utilizando una de las siguientes opciones

¿Todo estuvo 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)

Tarea

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

Cambia al escritorio para practicar en el mundo realContinúe desde donde se encuentra utilizando una de las siguientes opciones

Sección 1. Capítulo 7

Cambia al escritorio para practicar en el mundo realContinúe desde donde se encuentra utilizando una de las siguientes opciones