Udemy

Platform

English

Language

Databases

Category

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

Start your journey with SQL and databases. Solve over 150 exercises and open the door to a career in IT! (DQL)

4.36 (66 reviews)

Students

2 hours

Content

Sep 2021

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

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

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

DateDiscountStatus
3/16/2021100% OFFExpired
4/12/202150% OFFExpired
5/13/202150% OFFExpired
6/1/2021100% OFFExpired
7/13/2021100% OFFExpired

3880738

Udemy ID

2/28/2021

Course created date

3/8/2021

Course Indexed date
Bot
Course Submitted by