SQL Bootcamp – SQLite – Hands-On Exercises

SQL Bootcamp - SQLite - Hands-On Exercises

SQL Bootcamp – SQLite – Hands-On Exercises

Start your adventure with SQL and databases. Solve over 270 exercises and jump into the IT world!

Language: english

Note: 4.5/5 (20 notes) 14,115 students

Instructor(s): PaweĊ‚ Krakowiak

Last update: 2022-12-10

What you’ll learn

  • solve over 270 exercises
  • deal with real programming problems
  • work with documentation and Stack Overflow
  • guaranteed instructor support

 

Requirements

  • basic knowledge of databases
  • basic knowledge of SQLite
  • basic knowledge of SQL

 

Description

Welcome to the SQL Bootcamp – SQLite- Hands-On Exercises course where you can test your SQL programming skills. The course is designed for people who have basic knowledge in SQL and it consists of over 270 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.


SQLite

SQLite is an in-process library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. The code for SQLite is in the public domain and is thus free for use for any purpose, commercial or private. SQLite is the most widely deployed database in the world with more applications than we can count, including several high-profile projects.

SQLite is an embedded SQL database engine. Unlike most other SQL databases, SQLite does not have a separate server process. SQLite reads and writes directly to ordinary disk files. A complete SQL database with multiple tables, indices, triggers, and views, is contained in a single disk file. The database file format is cross-platform – you can freely copy a database between 32-bit and 64-bit systems.

 

Who this course is for

  • everyone who wants to learn by doing
  • everyone who wants to improve SQL programming skills
  • everyone who wants to improve database skills
  • everyone who wants to prepare for an interview

 

Course content

  • Intro
    • A few words from the author
    • Tip
    • Requirements
  • —– 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
    • 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
  • 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
  • —– 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 IV
    • SQL code for exercises
    • Exercise 1
    • Solution 1
    • Exercise 2
    • Solution 2
  • Summary V
    • 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
  • —– SQLite + Python —–
    • Intro
    • Configuation
  • 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
  • Configuration (optional)
    • Info
    • Google Colab + Google Drive
    • Google Colab + GitHub
    • Google Colab – Intro
    • Anaconda installation – Windows 10
    • Introduction to Spyder
    • Anaconda installation – Linux
  • Bonus
    • Bonus

 

Time remaining or 974 enrolls left

 

Don’t miss any coupons by joining our Telegram group 

Udemy Coupon Code 100% off | Udemy Free Course | Udemy offer | Course with certificate