What you will learn
solve 150 exercises using the SQL language
test yourself in DQL (Data Query Language)
test yourself in creating and executing database queries
test yourself in sorting, filtering and grouping data
test yourself in joining tables and creating subqueries.
test yourself in creating complex queries
deal with real programming problems
work with documentation and Stack Overflow
guaranteed instructor support
Description
——————————————————————————
RECOMMENDED LEARNING PATH
——————————————————————————
PYTHON DEVELOPER:
SQL DEVELOPER:
JOB INTERVIEW SERIES:
——————————————————————————
COURSE DESCRIPTION
‘;
}});
——————————————————————————
SQL Bootcamp – Hands-On Exercises – SQLite – Part I
Welcome to the course SQL Bootcamp – Hands-On Exercises – SQLite – Part I where you can test your SQL programming skills.
This is the first part of the SQL Bootcamp – Hands-On Exercises series. The exercises in this part are mainly focused on creating DQL queries to the database.
The course is designed for people who have basic knowledge in SQL and it consists of over 150 exercises with solutions.
This is a great test for people who are learning SQL and are looking for new challenges. Exercises are also a good test before the interview. Many popular topics were covered in this course.
Knowledge of SQL is one of the most desirable technical skills on the job market. If you’re wondering if it’s worth taking a step towards SQL and databases, don’t hesitate any longer and take the challenge today.
—– DQL – Data Query Language —–
Intro
SELECT …
Exercise 1
Solution 1
Exercise 2
Solution 2
SELECT … FROM …
SQL code for exercises
Exercise 1
Solution 1
Exercise 2
Solution 2
Exercise 3
Solution 3
Exercise 4
Solution 4
Exercise 5
Solution 5
SQL code for exercises
Exercise 6
Solution 6
Data sorting – ORDER BY
SQL code for exercises
Exercise 1
Solution 1
Exercise 2
Solution 2
Exercise 3
Solution 3
Exercise 4
Solution 4
SQL code for exercises
Exercise 5
Solution 5
Exercise 6
Solution 6
Exercise 7
Solution 7
Exercise 8
Solution 8
Exercise 9
Solution 9
SQL code for exercises
Exercise 10
Solution 10
Exercise 11
Solution 11
Exercise 12
Solution 12
Exercise 13
Solution 13
LIMIT + OFFSET
SQL code for exercises
Exercise 1
Solution 1
Exercise 2
Solution 2
Exercise 3
Solution 3
Exercise 4
Solution 4
Exercise 5
Solution 5
Exercise 6
Solution 6
Exercise 7
Solution 7
Exercise 8
Solution 8
SQL code for exercises
Exercise 9
Solution 9
Exercise 10
Solution 10
Exercise 11
Solution 11
Exercise 12
Solution 12
SELECT DISTINCT
SQL code for exercises
Exercise 1
Solution 1
SQL code for exercises
Exercise 2
Solution 2
Exercise 3
Solution 3
Data filtering – WHERE
SQL code for exercises
Exercise 1
Solution 1
Exercise 2
Solution 2
Exercise 3
Solution 3
Exercise 4
Solution 4
Exercise 5
Solution 5
Exercise 6
Solution 6
Exercise 7
Solution 7
Exercise 8
Solution 8
Exercise 9
Solution 9
Exercise 10
Solution 10
Exercise 11
Solution 11
Exercise 12
Solution 12
Exercise 13
Solution 13
Exercise 14
Solution 14
Exercise 15
Solution 15
Exercise 16
Solution 16
Exercise 17
Solution 17
Exercise 18
Solution 18
SQL code for exercises
Exercise 19
Solution 19
Exercise 20
Solution 20
Exercise 21
Solution 21
Exercise 22
Solution 22
Functions
SQL code for exercises
Exercise 1
Solution 1
Exercise 2
Solution 2
Exercise 3
Solution 3
Exercise 4
Solution 4
Exercise 5
Solution 5
Exercise 6
Solution 6
Exercise 7
Solution 7
Data grouping – GROUP BY
SQL code for exercises
Exercise 1
Solution 1
Exercise 2
Solution 2
Exercise 3
Solution 3
SQL code for exercises
Exercise 4
Solution 4
Exercise 5
Solution 5
SQL code for exercises
Exercise 6
Solution 6
Exercise 7
Solution 7
Data grouping – GROUP BY + HAVING
SQL code for exercises
Exercise 1
Solution 1
SQL code for exercises
Exercise 2
Solution 2
Exercise 3
Solution 3
SQL code for exercises
Exercise 4
Solution 4
SELECT CASE …
SQL code for exercises
Exercise 1
Solution 1
Exercise 2
Solution 2
SQL code for exercises
Exercise 3
Solution 3
Subqueries
SQL code for exercises
Exercise 1
Solution 1
Exercise 2
Solution 2
SQL code for exercises
Exercise 3
Solution 3
Exercise 4
Solution 4
Exercise 5
Solution 5
Exercise 6
Solution 6
Exercise 7
Solution 7
Joining tables – LEFT JOIN
SQL code for exercises
Exercise 1
Solution 1
Exercise 2
Solution 2
Exercise 3
Solution 3
Exercise 4
Solution 4
Exercise 5
Solution 5
Exercise 6
Solution 6
Exercise 7
Solution 7
Exercise 8
Solution 8
Exercise 9
Solution 9
Exercise 10
Solution 10
Exercise 11
Solution 11
Exercise 12
Solution 12
Joining tables – INNER JOIN
SQL code for exercises
Exercise 1
Solution 1
Exercise 2
Solution 2
Exercise 3
Solution 3
SQL code for exercises
Exercise 4
Solution 4
Exercise 5
Solution 5
Joining tables – UNION
SQL code for exercises
Exercise 1
Solution 1
Exercise 2
Solution 2
Exercise 3
Solution 3
Exercise 4
Solution 4
Exercise 5
Solution 5
Joining tables – UNION ALL
SQL code for exercises
Exercise 1
Solution 1
Exercise 2
Solution 2
Exercise 3
Solution 3
Joining tables – EXCEPT
SQL code for exercises
Exercise 1
Solution 1
Exercise 2
Solution 2
Joining tables – INTERSECT
SQL code for exercises
Exercise 1
Solution 1
Summary I
SQL code for exercises
Exercise 1
Solution 1
Exercise 2
Solution 2
Summary II
SQL code for exercises
Exercise 1
Solution 1
Exercise 2
Solution 2
Exercise 3
Solution 3
Exercise 4
Solution 4
Exercise 5
Solution 5
Exercise 6
Solution 6
Exercise 7
Solution 7
Exercise 8
Solution 8
Exercise 9
Solution 9
Exercise 10
Solution 10
Exercise 11
Solution 11
Exercise 12
Solution 12
Exercise 13
Solution 13
Exercise 14
Solution 14
Exercise 15
Solution 15
Exercise 16
Solution 16
Exercise 17
Solution 17
Exercise 18
Solution 18
Exercise 19
Solution 19
Exercise 20
Solution 20
Exercise 21
Solution 21
Exercise 22
Solution 22
Exercise 23
Solution 23
Exercise 24
Solution 24
—– Bonus: SQLite + Python —–
Intro
Configuration (optional)
Info
Google Colab + Google Drive
Google Colab + GitHub
Google Colab – Intro
Anaconda installation – Windows 10
Introduction to Spyder
Anaconda installation – Linux
SQLite + Python
Database for exercises
Exercise 1
Solution 1
Exercise 2
Solution 2
Exercise 3
Solution 3
Exercise 4
Solution 4
Exercise 5
Solution 5
Exercise 6
Solution 6
Exercise 7
Solution 7
