SQL Bootcamp - SQLite - Hands-On Exercises

Master SQL with Hands-On Exercises - Build Strong Data Management Skills and Excel in Database Development!

4.75 (36 reviews)
Udemy
platform
English
language
Databases
category
27,162
students
4.5 hours
content
Oct 2023
last update
$64.99
regular price

What you will learn

solve over 270 exercises

deal with real programming problems

work with documentation and Stack Overflow

guaranteed instructor support

Description

The "SQL Bootcamp - SQLite - Hands-On Exercises" course is an immersive, practical introduction to SQL programming using SQLite, a popular relational database system. This course is designed for both beginners with no prior knowledge of SQL, and seasoned developers looking to refine their skills or learn a new database system.

The course begins with a thorough introduction to SQLite, its architecture, and its place within the realm of SQL databases. You will learn how to set up and configure SQLite on your system, followed by an overview of database design principles and the SQL language.

The core part of the course comprises of extensive hands-on exercises. These exercises are specifically designed to facilitate learning through practice, enabling you to apply SQL concepts in real-world situations. You will learn how to create, update, and manipulate databases using SQLite, understand and implement complex queries, and get hands-on experience with transactions, indexing, and optimization for performance.

An essential feature of this course is its practical approach to learning. Rather than simply reading or listening to lectures, you will actively engage with the material by writing and executing SQL code. This allows for immediate feedback and iterative learning, helping to solidify your understanding of SQLite and SQL in general.

By the end of the "SQL Bootcamp - SQLite - Hands-On Exercises" course, you will have a strong grasp of SQL fundamentals, be confident in your ability to work with SQLite databases, and be well-equipped to tackle more complex SQL tasks and projects.


SQLite - Lightweight Database Powerhouse!

SQLite is a lightweight, serverless, and self-contained relational database management system. It is widely used as an embedded database in various applications due to its simplicity, small footprint, and high performance. SQLite stores the entire database in a single file, making it easy to deploy and manage without requiring a separate server process.

Despite its compact size, SQLite supports a full range of SQL features and provides ACID (Atomicity, Consistency, Isolation, Durability) compliance. It offers a reliable and efficient way to store and retrieve structured data, making it suitable for small to medium-sized applications, mobile devices, and embedded systems.

With SQLite, developers can create tables, define relationships, and execute SQL queries to perform various operations such as inserting, updating, deleting, and querying data. It supports common data types, transactions, indexes, and triggers, enabling efficient data manipulation and retrieval.

SQLite integrates seamlessly with different programming languages, including Python, C, C++, and more, making it highly versatile and widely adopted. It is used in a wide range of applications, such as mobile apps, desktop software, web browsers, IoT devices, and data analysis tools.

In summary, SQLite provides a lightweight and efficient solution for managing relational databases without the need for a dedicated database server. It offers simplicity, flexibility, and reliability, making it a popular choice for applications that require local data storage and retrieval.

Content

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

Screenshots

SQL Bootcamp - SQLite - Hands-On Exercises - Screenshot_01SQL Bootcamp - SQLite - Hands-On Exercises - Screenshot_02SQL Bootcamp - SQLite - Hands-On Exercises - Screenshot_03SQL Bootcamp - SQLite - Hands-On Exercises - Screenshot_04

Coupons

DateDiscountStatus
5/21/2022100% OFF
expired
5/25/2022100% OFF
expired
5/27/2022100% OFF
expired
6/2/2022100% OFF
expired
6/16/2022100% OFF
expired
7/3/2022100% OFF
expired
7/13/2022100% OFF
expired
8/2/2022100% OFF
expired
8/4/2022100% OFF
expired
8/7/2022100% OFF
expired
9/3/2022100% OFF
expired
10/21/2022100% OFF
expired
11/12/2022100% OFF
expired
12/14/2022100% OFF
expired
1/12/2023100% OFF
expired
2/5/2023100% OFF
expired
3/12/2023100% OFF
expired
4/7/2023100% OFF
expired
5/9/2023100% OFF
expired
6/10/2023100% OFF
expired
8/11/202383% OFF
expired
9/4/2023100% OFF
expired
9/18/2023100% OFF
expired
10/5/2023100% OFF
expired
11/4/2023100% OFF
expired
11/25/2023100% OFF
expired
12/24/2023100% OFF
expired
2/27/2024100% OFF
expired

Charts

Price

SQL Bootcamp - SQLite - Hands-On Exercises - Price chart

Rating

SQL Bootcamp - SQLite - Hands-On Exercises - Ratings chart

Enrollment distribution

SQL Bootcamp - SQLite - Hands-On Exercises - Distribution chart
4680164
udemy ID
5/10/2022
course created date
5/21/2022
course indexed date
Bot
course submited by