SQL Bootcamp - Hands-On Exercises - SQLite - Part I

Dive into Hands-On Exercises with SQLite and DQL - Unlock the Power of Data Querying and Manipulation!

4.60 (165 reviews)
Udemy
platform
English
language
Databases
category
Paweł Krakowiak
instructor
SQL Bootcamp - Hands-On Exercises - SQLite - Part I
54,720
students
2.5 hours
content
Oct 2023
last update
$64.99
regular price

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

Why take this course?

"SQL Bootcamp - Hands-On Exercises - SQLite - Part I" is a robust, hands-on course designed to impart practical knowledge of the Data Query Language (DQL) aspect of SQL using SQLite. This course is perfect for learners at all levels seeking to solidify their understanding of SQL and database interactions using SQLite.

The DQL portion of SQL is concerned primarily with retrieving data from a database. This is a critical skill for any database interaction, including roles like database administrators, data analysts, and back-end developers.

The course is divided into several sections, each focusing on different aspects of DQL such as SELECT statements, WHERE clause, ORDER BY clause, LIMIT clause, and various SQL functions. The course starts with the basics of retrieving data from a single table, and progressively covers more complex queries involving multiple tables and subqueries.

Every section includes a plethora of hands-on exercises designed to apply and reinforce the principles taught. The exercises present a mix of simple to complex real-world scenarios, ensuring learners thoroughly understand how to retrieve and manipulate data using DQL.

Upon completion of each exercise, learners are provided with detailed solutions, allowing them to compare their approach with the provided solution, further enhancing their understanding and command of DQL in SQLite.

The "SQL Bootcamp - Hands-On Exercises - SQLite - Part I" course is ideal for anyone looking to master the art of querying data from a relational database using SQL. Whether you're a total beginner, a data enthusiast, or a seasoned professional looking to refresh your DQL skills, this course offers an immersive learning experience.


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

Tip

----- 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 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

Bonus

Discount coupons

Screenshots

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

Reviews

CHAGANTI
July 22, 2023
Everything is good regarding the practice exercises. It follows a sequence. If all the 140 exercises are done, you could have strong grasp on the fundamentals of MySQL (even till intermediate) . It is also a good course for those who want to brush up. Now you learnt the skill, If you still want some more knowledge or apply the skill do a project where implementing and working around a database is a task in that. It would make you much more confident. The only issue sometimes it takes so much time to run the query. It is not the fault of instructor maybe the Udemy backend... Everyone download the SQLite Software ( A small software takes around 100 - 150 MB). Practice the queries there. Paste the query here. small minor things... That's it.
George
July 29, 2022
The exercises have a variety of topics that they cover but with some of them the solution purposed isn't the correct. The optional videos at the end of the course could have a been made with a better insight. Overall the course is good for someone getting a first look at SQLite, just needs a little adjusting.
Mrproductive
November 25, 2021
The author of the course only has an article in each exercise saying "The Stock table is given." He is not asking for a specific task to be done, this is a rip-off, and I definitely have buyer's remorse.
Stefano
October 28, 2021
practical examples gradually challenging step by step, ideal for beginners and intermediate students. Questions are well explained and solutions always avaialble to check the expected result. 5th star if it were faster in checking results: Satisfied user.
Ari
August 11, 2021
really good. i hpope you and your familly always health and happy forever. thankyou for the knowledge
Joseph
July 21, 2021
I found this course extremely useful to revise my concepts on SQL and got more insights on how to tackle the problems. Definitely recommending it to my friends.
Durga
March 21, 2021
I really Loved this Course, This is the perfect course for any Beginner to Intermediate learner who wants to practice and brush up their skills. Thanks a Lot for the Trainer he really put so much efforts in bringing this course.

Coupons

DateDiscountStatus
3/16/2021100% OFF
expired
4/12/202150% OFF
expired
5/13/202150% OFF
expired
6/1/2021100% OFF
expired
7/13/2021100% OFF
expired
1/30/2022100% OFF
expired
1/31/2022100% OFF
expired
2/4/202230% OFF
expired
2/26/2022100% OFF
expired
5/26/2022100% OFF
expired
6/3/2022100% OFF
expired
6/20/2022100% OFF
expired
7/4/2022100% OFF
expired
7/15/2022100% OFF
expired
8/2/2022100% OFF
expired
8/3/2022100% OFF
expired
8/8/2022100% OFF
expired
9/9/2022100% OFF
expired
10/24/2022100% OFF
expired
11/6/2022100% OFF
expired
12/1/2022100% OFF
expired
1/15/2023100% OFF
expired
2/10/2023100% OFF
expired
3/18/2023100% OFF
expired
4/9/2023100% OFF
expired
5/9/2023100% OFF
expired
6/10/2023100% OFF
expired
10/28/2023100% OFF
expired
12/23/2023100% OFF
expired

Charts

Price

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

Rating

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

Enrollment distribution

SQL Bootcamp - Hands-On Exercises - SQLite - Part I - Distribution chart

Related Topics

SQL
Database Management
Database Programming
SQLite
3880738
udemy ID
2/28/2021
course created date
3/8/2021
course indexed date
Bot
course submited by