SQL in Containers: Mastering SQL with Docker and DBeaver

Name: SQL in Containers: Mastering SQL with Docker and DBeaver
Rating: 4.3 (95 reviews)

Harnessing the Power of SQL, MySQL, and PostgreSQL within Docker-Driven Development with DBeaver

Created byKiril Spiridonov

Last updated 5/2025

English

English [Auto],

What you'll learn

Fundamentals of relational databases
Installing and setting up Docker
Understanding and using Docker commands
Installing and configuring DBeaver
Basic SQL commands and their applications
Complex SQL commands
Performing data filtering
Utilizing SQL functions
Creating and managing stored procedures
Optimizing SQL performance

Coding Exercises

This course includes our updated coding exercises so you can practice your skills as you learn.

Course content

2 sections • 25 lectures • 1h 20m total length

Introduction2:52
Master SQL with Docker and DBeaver by learning the basics of relational databases, core SQL commands, joins, and advanced topics like CTEs, transactions, and authentication through hands-on exercises.
Course Architecture1:44
Explore how Docker simplifies database management and Beaver enables cross-database connectivity and query composition across many databases. Build practical SQL skills across PostgreSQL and MySQL using Docker containers.
Understanding relational databases4:23
Explore relational databases and relationships, including 1-to-1, 1-to-many, and many-to-many, by learning how tables, rows, and columns connect. Master SQL basics, joins, indexes, and transactions to query and manage data.
Docker Installation2:33
Install Docker Desktop to enable containerized databases and simplified management. Follow guided steps to install WSL 2 on Windows, select the right options, and launch the Docker interface.
Docker Installation Written Instructions0:58
Docker Introduction2:46
Learn how Docker images become containers, pull images from Dockerhub, and configure a MySQL container with environment variables in an isolated Docker environment.
Docker Commands5:26
Learn docker essentials for sql databases by pulling a mysql image, running containers, managing volumes and ports, and an introduction to docker compose.
Introduction to Docker Commands2:21
DBeaver Installation2:01
Download the DBeaver community edition from the official site, accept terms, choose the Windows installer, and install with default or customized settings, optionally associating SQL files with DBeaver.
Connecting DBeaver with Database Container in Docker3:48
Connect DBeaver to running Docker containers for MySQL and PostgreSQL by configuring port mapping, host settings, and public key retrieval, then test connections from the local environment.
Basic SQL Commands Overview3:31
Explore core SQL commands, including select from, where, group by, having, and joins, apply aggregate functions like count, sum, and avg, using PostgreSQL and MySQL containers.
Basic SQL Commands Quick Reading1:58
SELECT statement4:46
Master the select statement to query a Postgres database inside Docker containers, create and populate a sales table, and retrieve data with selects, aliases, and select star queries.
Quick SELECT Exercise
Data Filtering, WHERE statement3:13
Master data filtering with the where statement by applying conditions on sale amounts, sale dates, and string patterns using and, like, and underscore wildcard for precise results.
Quick WHERE Exercise
Book Club Manager
LIKE wildcards4:18
Utilize like wildcards to master flexible SQL pattern matching with percent and underscore, and control searches using square brackets and caret to specify character ranges.
Aggregation and GROUP BY4:01
Group and summarize sales data by product name and sale date, applying count, sum, and average aggregations, with having for post grouping filters in a dockerized Postgres setup.
Grouping Data with a GROUP BY Clause
Using Group By and Having
JOIN operations: INNER, LEFT, RIGHT, FULL4:33
Explore inner, left, right, full joins using sales and clothing data to preserve, enrich, and analyze transactions with related product details.
Joining Data from Multiple Tables
Using Joins and Aggregation
Conditional columns, CASE WHEN2:17
Explore creating conditional columns in sql with the case statement, using sales data to label prices as promotion, regular, or overpriced.
Using the CASE WHEN Statement
Set operations: UNION, INTERSECT, EXCEPT2:30
Explore union, intersect, and accept (except) set operators in sql to combine and compare data from clothing and sales tables, with a practical script.
Combining Data with UNION
Finding Common Data with INTERSECT
Finding Differences with EXCEPT
Champions Exercise: Subqueries and Aggregate Functions
Champions Exercise: Using Subqueries and Conditional Logic

CTEs and WITH statement2:28
Master common table expressions (CTEs) and the with statement to simplify PostgreSQL queries, such as left joining sales and clothing, and name CTEs to improve readability and maintainability.
Using Common Table Expressions (CTE)
Champions Exercise: Retrieve The Hierarchical Structure Of Categories
Functions2:27
Demonstrate creating a user defined sql function with parameters, data types, and a begin end block, then run it to add numbers or columns like sale id and sale amount.
Stored procedures1:45
Master creating or replacing PostgreSQL stored procedures, including name, arguments, language, and a dollar-quoted body, and implement a sales data backup via drop, recreate with select into, and call.
Transaction Control, BEGIN, COMMIT, and ROLLBACK2:07
Master sql transactions by using begin, commit, and rollback to safely test changes, review results, and understand irreversible effects after committing.
Authentication and Roles2:06
Explore PostgreSQL roles and permissions, view users with pg_catalog.pg_user, create a test user with password 1234, grant read access, and test connections in DBeaver.
Performance Optimization10:05
Optimize SQL queries with indexes, query hints, and proper schema design to speed data retrieval, then analyze execution plans, caching, and partitioning to sustain performance as data grows.

Requirements

Ideally, a Windows machine would be preferred (although guides for other operating systems are available, you might need to conduct additional research on your own)
Embrace proactive learning by actively seeking out information and asking questions about what you don't understand.

Description

Dive into the world of SQL in today’s containerized environments with our innovative course! You’ll learn how to leverage Docker and DBeaver to transform your database management skills. SQL is a must-have skill for anyone working with databases, and in our fast-paced tech world, mastering SQL with the latest tools is crucial. This course is designed to equip you with the knowledge and skills necessary to excel in SQL database management using Docker and DBeaver.

Who is this course for?

Beginners: If you’re just starting out with SQL and database management, this course will give you a strong foundation.
Data Engineers & Developers: Perfect for developers who want to seamlessly integrate SQL databases into their applications and pipelines.
Data Analysts: Ideal for analysts looking to sharpen their SQL skills for more effective data querying and analysis.
DBAs: Database administrators eager to learn how to use Docker and DBeaver for managing databases in containerized setups.
Students: Anyone excited to learn SQL with modern tools and boost their career opportunities.

What will you learn?

This course is split into two main sections:

Basics: You’ll kick things off with the fundamentals, covering relational databases, how to install and configure Docker, and getting familiar with Docker commands. Then, you’ll dive into basic SQL commands, data filtering, aggregation, JOIN operations, and much more.
Advanced: After you’ve got the basics down, you’ll tackle more complex topics like Common Table Expressions (CTEs), SQL functions, stored procedures, transaction control, authentication, and performance optimization.

Course Highlights:

Engaging practical exercises with coding tasks for hands-on experience.
Utilization of modern tools like Docker and DBeaver for a real-world SQL learning experience.
A thorough curriculum designed to make you proficient in SQL database management.
Boost your marketability with sought-after Docker and SQL skills.
Streamline your database workflows and enhance efficiency.
Learn how to set up portable, reproducible database environments.

By the end of this course, you'll be able to:

Set up and manage SQL databases in Docker containers
Write complex SQL queries using advanced techniques like CTEs and transactions
Optimize database performance using best practices
Implement security measures for database protection"

Why Enroll?

By enrolling in this course, you'll gain the skills and knowledge needed to effectively manage SQL databases using Docker and DBeaver. Whether you're a beginner or an experienced professional, this course will help you take your SQL skills to the next level and advance your career in database management.

Get Started Today!

Ready to master SQL with Docker and DBeaver? Enroll now and start your journey to becoming an SQL expert!

Who this course is for:

Beginners: Those new to SQL and database management.
Data Engineers & Developers: who want to integrate SQL databases in their applications and master the language.
Data Analysts: Analysts looking to enhance their SQL skills for better data querying and analysis.
DBAs: Database administrators seeking to learn about Docker and DBeaver for managing databases in containers.
Students: Anyone interested in learning SQL using modern tools.