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

Advance Your SQL Skills with Hands-On Exercises - Master DDL and DML for Effective Data Management and Manipulation!

4.20 (51 reviews)

Udemy

platform

English

language

Databases

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

The "SQL Bootcamp - Hands-On Exercises - SQLite - Part II" course is a comprehensive learning resource intended to impart hands-on knowledge of the Data Definition Language (DDL) and Data Manipulation Language (DML) components of SQL, using the SQLite database engine. This course is perfect for students at any stage of their SQL journey, aiming to bolster their understanding and skills in handling databases.

DDL is used for defining and managing structures of databases and objects, including operations like CREATE, ALTER, and DROP. On the other hand, DML focuses on managing data within these structures, involving operations like SELECT, INSERT, UPDATE, and DELETE.

The course is divided into several sections, each tackling a specific aspect of DDL or DML. It starts with creating and modifying database structures with DDL, then transitions to data insertion, retrieval, and modification using DML.

To provide a robust learning experience, each section comes packed with numerous hands-on exercises designed to apply and reinforce the principles learned. These exercises cover various scenarios, ranging from simple data retrieval to complex data manipulation tasks. Each exercise is accompanied by a detailed solution to enhance your understanding and proficiency in DDL and DML.

The "SQL Bootcamp - Hands-On Exercises - SQLite - Part II" course is a valuable resource for anyone looking to enhance their skills in managing database structures and manipulating data. Whether you're a novice to SQL, a data enthusiast, or a professional developer, this course offers an enriching learning experience.

SQLite - Lightweight Database Powerhouse!

SQLite is a lightweight, serverless, and self-contained relational database management system. It is widely used as an embedded database in various applications due to its simplicity, small footprint, and high performance. SQLite stores the entire database in a single file, making it easy to deploy and manage without requiring a separate server process.

Despite its compact size, SQLite supports a full range of SQL features and provides ACID (Atomicity, Consistency, Isolation, Durability) compliance. It offers a reliable and efficient way to store and retrieve structured data, making it suitable for small to medium-sized applications, mobile devices, and embedded systems.

With SQLite, developers can create tables, define relationships, and execute SQL queries to perform various operations such as inserting, updating, deleting, and querying data. It supports common data types, transactions, indexes, and triggers, enabling efficient data manipulation and retrieval.

SQLite integrates seamlessly with different programming languages, including Python, C, C++, and more, making it highly versatile and widely adopted. It is used in a wide range of applications, such as mobile apps, desktop software, web browsers, IoT devices, and data analysis tools.

In summary, SQLite provides a lightweight and efficient solution for managing relational databases without the need for a dedicated database server. It offers simplicity, flexibility, and reliability, making it a popular choice for applications that require local data storage and retrieval.

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

Screenshots

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

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

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

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

Reviews

Gagan

November 10, 2022

if there is inbuilt coding ide is available for code then it is quite effective as well as attractive and engaging

Coupons

Submit by	Date	Coupon Code	Discount	Emitted/Used	Status
-	4/1/2021	FREECODE	100% OFF	40000/9944	expired
ERCUMENT.KAYA	4/12/2021	APR_DROP	50% OFF		expired
-	5/13/2021	MAYDROP21	50% OFF		expired
-	7/22/2021	FREEDROP	100% OFF	40000/10782	expired
-	1/30/2022	DROPJAN22	100% OFF	1000/831	expired
-	1/31/2022	DROPJAN2022	100% OFF	1000/828	expired
-	2/4/2022	NEWYEAR22	30% OFF		expired
Angelcrc Seven	2/26/2022	SQLDROP22	100% OFF	1000/897	expired
-	5/26/2022	BIGDROP2	100% OFF	1000/940	expired
Facialix	6/3/2022	JUNEDROP	100% OFF	1000/811	expired
-	6/20/2022	JUNEDROP2	100% OFF	1000/741	expired
-	7/4/2022	JULDROP	100% OFF	1000/978	expired
-	7/15/2022	JULDROP2	100% OFF	1000/980	expired
-	8/2/2022	AUGDROP	100% OFF	1000/903	expired
-	8/3/2022	AUGDROP2	100% OFF	1000/944	expired
-	8/8/2022	AUGDROP3	100% OFF	1000/996	expired
-	9/9/2022	SEPDROP	100% OFF	1000/995	expired
-	10/24/2022	OCTDROP	100% OFF	1000/872	expired
-	11/6/2022	NOVDROP	100% OFF	1000/882	expired
-	12/1/2022	DECDROP	100% OFF	1000/921	expired
-	1/15/2023	95C75633D6A861D23EA8	100% OFF	1000/893	expired
-	2/10/2023	2BA392BA63C79E9CE8F5	100% OFF	1000/961	expired
-	3/18/2023	F9E227D7CC529D888827	100% OFF	1000/928	expired
-	4/9/2023	B5F24F1206803EB6B589	100% OFF	1000/953	expired
-	5/9/2023	DROP0905	100% OFF	1000/691	expired
-	6/10/2023	A7AC2B3FFF4418A430C8	100% OFF	1000/987	expired
-	10/28/2023	FREEDROP2	100% OFF	1000/769	expired
-	12/30/2023	FREEDROP3	100% OFF	1000/913	expired

Charts

Price

Rating

Enrollment distribution

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

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

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

Content

Intro

----- DDL - Data Definition Language -----

Working with tables

Temporary tables

PRIMARY KEY + ROWID

Indexes

DEFAULT constraint

UNIQUE constraint

CHECK constraint

NOT NULL constraint

FOREIGN KEY

Relations

Modification of tables

----- DML - Data Manipulation Language -----

Inserting data into tables

Data modification

Data deletion

----- Views -----

Views

----- Triggers -----

Triggers

----- Summary -----

Summary I

Summary II

Summary III

----- Bonus: SQLite + Python -----

Configuration (optional)

SQLite + Python

Bonus

Screenshots

Reviews

Coupons

Charts

Price

Rating

Enrollment distribution

Related Topics