Start your adventure with SQL and databases. Solve over 270 exercises and jump into the IT world!
What you will learn
solve over 270 exercises
deal with real programming problems
work with documentation and Stack Overflow
guaranteed instructor support
Description
Welcome to the SQL Bootcamp – SQLite- Hands-On Exercises course where you can test your SQL programming skills. The course is designed for people who have basic knowledge in SQL and it consists of over 270 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.
SQLite
‘;
}});
SQLite is an in-process library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. The code for SQLite is in the public domain and is thus free for use for any purpose, commercial or private. SQLite is the most widely deployed database in the world with more applications than we can count, including several high-profile projects.
SQLite is an embedded SQL database engine. Unlike most other SQL databases, SQLite does not have a separate server process. SQLite reads and writes directly to ordinary disk files. A complete SQL database with multiple tables, indices, triggers, and views, is contained in a single disk file. The database file format is cross-platform – you can freely copy a database between 32-bit and 64-bit systems.
Intro
A few words from the author
Tip
—– DDL – Data Definition Language —–
Intro
Working with tables
Exercise 1
Solution 1
Exercise 2
Solution 2
Exercise 3
Solution 3
Exercise 4
Solution 4
Exercise 5
Solution 5
Temporary tables
Exercise 1
Solution 1
Exercise 2
Solution 2
PRIMARY KEY + ROWID
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
Indexes
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
DEFAULT constraint
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
UNIQUE constraint
Exercise 1
Solution 1
Exercise 2
Solution 2
Exercise 3
Solution 3
Exercise 4
Solution 4
CHECK constraint
Exercise 1
Solution 1
Exercise 2
Solution 2
Exercise 3
Solution 3
NOT NULL constraint
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
FOREIGN KEY
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
Relations
Exercise 1
Solution 1
Exercise 2
Solution 2
Exercise 3
Solution 3
Modification of tables
Exercise 1
Solution 1
Exercise 2
Solution 2
Exercise 3
Solution 3
Exercise 4
Solution 4
Exercise 5
Solution 5
—– DML – Data Manipulation Language —–
Intro
Inserting data into tables
Exercise 1
Solution 1
Exercise 2
Solution 2
Exercise 3
Solution 3
Data modification
Exercise 1
Solution 1
Exercise 2
Solution 2
Exercise 3
Solution 3
Exercise 4
Solution 4
Data deletion
Exercise 1
Solution 1
Exercise 2
Solution 2
Exercise 3
Solution 3
—– Views —–
Intro
Views
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
—– Triggers —–
Intro
Triggers
Exercise 1
Solution 1
Exercise 2
Solution 2
—– Summary —–
Intro
Summary I
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
Summary II
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
Summary III
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
—– 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 —–
Intro
Summary IV
SQL code for exercises
Exercise 1
Solution 1
Exercise 2
Solution 2
Summary V
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
—– SQLite + Python —–
Intro
Configuation
SQLite + Python
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
Configuration (optional)
Info
Google Colab + Google Drive
Google Colab + GitHub
Google Colab – Intro
Anaconda installation – Windows 10
Introduction to Spyder
Anaconda installation – Linux
Spyder
