Course Content

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)

Task

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

Task

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

Switch to desktop for real-world practiceContinue from where you are using one of the options below

Everything was clear?

Section 1. Chapter 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)

Task

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

Task

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

Switch to desktop for real-world practiceContinue from where you are using one of the options below

Everything was clear?

Section 1. Chapter 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)

Task

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

Task

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

Switch to desktop for real-world practiceContinue from where you are using one of the options below

Everything was clear?

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)

Task

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

Switch to desktop for real-world practiceContinue from where you are using one of the options below

Section 1. Chapter 7

Switch to desktop for real-world practiceContinue from where you are using one of the options below