4.36 (66 reviews)

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

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

**SQL DEVELOPER:**

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

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

**------------------------------------------------------------------------------**

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

Screenshots

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

Reviews

A

Ari11 August 2021

really good. i hpope you and your familly always health and happy forever. thankyou for the knowledge

J

Joseph21 July 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.

D

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

Date | Discount | Status |
---|---|---|

3/16/2021 | 100% OFF | Expired |

4/12/2021 | 50% OFF | Expired |

5/13/2021 | 50% OFF | Expired |

6/1/2021 | 100% OFF | Expired |

7/13/2021 | 100% OFF | Expired |

Bot

Course Submitted by