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


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

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


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

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.

English
language

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