SQL Bootcamp – Hands-On Exercises – SQLite – Part I

Dive into Hands-On Exercises with SQLite and DQL - Unlock the Power of Data Querying and Manipulation!

Created by: Paweł Krakowiak
Python Developer/Data Scientist/Stockbroker

What Will I Learn?

• solve 150 exercises using the SQL language
• test yourself in DQL (Data Query Language)
• test yourself in creating and executing database queries
• test yourself in sorting, filtering and grouping data
• test yourself in joining tables and creating subqueries.
• test yourself in creating complex queries
• deal with real programming problems
• work with documentation and Stack Overflow
• guaranteed instructor support

Requirements

• basic knowledge of SQL and SQLite

Target audience

• beginners or individuals with limited knowledge of SQL who want to learn and practice SQL queries specifically focused on data retrieval (DQL) using SQLite
• students or individuals pursuing a career in data analysis, data engineering, or database administration who need a strong foundation in SQL and want to gain practical experience in writing DQL queries
• database developers or programmers who want to expand their SQL skills and learn how to query and manipulate data in SQLite databases
• professionals working with data in various roles who want to improve their data analysis and querying skills using SQL and SQLite as a database management system
• self-learners or enthusiasts who are interested in SQL and want to develop their proficiency in data retrieval by solving hands-on exercises in SQLite
• individuals who are considering using SQLite as a lightweight database solution and want to understand and practice DQL queries for data retrieval