4.35 (21 reviews)

Regular Price

What you will learn

☑ solve over 150 exercises in SQL and databases

☑ test yourself in DDL (Data Definition Language) and DML (Data Manipulation Language)

☑ test yourself in creating tables

☑ test yourself in defining column/table constraints

☑ test yourself in working with master and foreign keys

☑ test yourself in inserting, modifying and deleting records

☑ test yourself in creating views, triggers

☑ work with documentation and Stack Overflow

☑ deal with real programming problems

☑ 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 II**

Welcome to the course** SQL Bootcamp - Hands-On Exercises - SQLite - Part II**, where you can test your SQL programming skills.

This is the second part of the **SQL Bootcamp - Hands-On Exercises** series. The exercises in this part are mainly focused on creating DDL and DML 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

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

Exercise 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

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

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

Bonus

Discount coupons

Coupons

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

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

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

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

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

Bot

Course Submitted by