SQL in Containers: Mastering SQL with Docker and DBeaver

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

Created by: Kiril Spiridonov
Data Engineer

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

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.

Target audience

• 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.