Dive into Hands-On Exercises with SQLite and DQL - Unlock the Power of Data Querying and Manipulation!
InstructorPaweł Krakowiak
The curriculum uses a sequence of practical examples that increase in difficulty, covering essential clauses like WHERE, GROUP BY, and various join types.
Instruction includes specific practice for set operations such as UNION, EXCEPT, and INTERSECT.
Editorial course preview
These 4 complementary views highlight concrete, legible examples from the course presentation.
This screenshot shows the hands-on coding environment for Exercise 15, where learners write SQL queries in a text editor to create tables and manage data.
This lesson view presents the solution to an exercise involving data grouping and filtering, featuring a SELECT statement that utilizes AVG(), GROUP BY, HAVING, and ORDER BY clauses.
This screenshot displays Exercise 2 from a SQL course, instructing students to merge two monthly order tables into one using the UNION operator and sort by quantity.
This screenshot displays the second hands-on exercise in the SQL Bootcamp course, presenting a problem statement and code editor for calculating average salaries grouped by job ID.
One signal from 2022 suggests errors in sample databases and issues with capitalization; because this predates the displayed 2024 update, it remains uncertain if these have been resolved.
A signal from 2022 indicates that some proposed solutions may require adjustment or verification; the update label does not prove a correction of these issues.
The curriculum aligns with the target of beginners learning SQL via SQLite.