Udemy

Platform

English

Language

Databases

Category

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

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

4.35 (21 reviews)

Students

4 hours

Content

Sep 2021

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

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

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

DateDiscountStatus
4/1/2021100% OFFExpired
4/12/202150% OFFExpired
5/13/202150% OFFExpired
7/22/2021100% OFFExpired

3880742

Udemy ID

2/28/2021

Course created date

3/8/2021

Course Indexed date
Bot
Course Submitted by