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

  • Post category:StudyBullet-5
  • Reading time:21 mins read


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:

  • 200+ Exercises – Programming in Python – from A to Z

  • 210+ Exercises – Python Standard Libraries – from A to Z

  • 150+ Exercises – Object Oriented Programming in Python – OOP

  • 150+ Exercises – Data Structures in Python – Hands-On

  • 100+ Exercises – Advanced Python Programming

  • 100+ Exercises – Unit tests in Python – unittest framework

  • 100+ Exercises – Python Programming – Data Science – NumPy

  • 100+ Exercises – Python Programming – Data Science – Pandas

  • 100+ Exercises – Python – Data Science – scikit-learn

  • 250+ Exercises – Data Science Bootcamp in Python

  • 110+ Exercises – Python + SQL (sqlite3) – SQLite Databases

  • 250+ Questions – Job Interview – Python Developer

SQL DEVELOPER:

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

  • SQL Bootcamp – Hands-On Exercises – SQLite – Part II

  • 110+ Exercises – Python + SQL (sqlite3) – SQLite Databases

  • 200+ Questions – Job Interview – SQL Developer

JOB INTERVIEWΒ SERIES:

  • 250+ Questions – Job Interview – Python Developer

  • 200+ Questions – Job Interview – SQL Developer

  • 200+ Questions – Job Interview – Software Developer – Git

  • 200+ Questions – Job Interview – Data Scientist

——————————————————————————

COURSE DESCRIPTION


Get Instant Notification of New Courses on our Telegram channel.

Noteβž› Make sure your π”ππžπ¦π² cart has only this course you're going to enroll it now, Remove all other courses from the π”ππžπ¦π² cart before Enrolling!


——————————————————————————

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.

English
language

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
Enroll for Free

πŸ’  Follow this Video to Get Free Courses on Every Udemy Topics! πŸ’ 

Tags: , , , , ,