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!

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

What Will I 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

Requirements

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

Target audience

• intermediate SQL learners who want to expand their knowledge and skills in database design and data manipulation using SQLite
• students or individuals pursuing a career in database administration, data engineering, or software development who need a solid understanding of SQL's Data Definition Language (DDL) and Data Manipulation Language (DML) using SQLite
• database developers or programmers who want to deepen their understanding of SQL and learn how to create and manage database objects, as well as manipulate data using SQLite as the database management system
• professionals working with databases who want to enhance their skills in creating tables, defining relationships, and performing data manipulation tasks using SQL and SQLite
• self-learners or enthusiasts who are interested in SQL and want to practice designing databases, creating tables, and manipulating data through hands-on exercises using SQLite
• individuals who are considering using SQLite as a database solution and want to learn the essentials of DDL and DML for database management and data manipulation