Database and SQL Fundamentals Through Illustrations: From Queries to Data Design

It’s perfectly fine even if you’ve never written a single line of SQL. We start with installing Oracle Database and DBeaver. You’ll complete the entire scope of SQLD Subject 1 (Data Modeling) and Subject 2 (SQL Basics and Applications) by running queries yourself over 15 hours and 23 minutes. It includes practice questions and answers, as well as review lectures where we solve the questions together. You’ll be taught by a data expert with 30 years of experience, who worked as a DBA and SQL tuner at Korea Exchange Credit Card and Hyundai HiCar Direct, and has delivered 100 sessions of SQL lectures at Samsung Electronics.

Have you ever felt frustrated with table design? This course is for those who have had concerns like, "Is this table right?", "Which column should be the PK?", "Is it okay to connect relationships this way?", or "Will I have to rebuild the table when adding new features?"

We will directly extract indicators frequently used in marketing/planning/CRM using SQL.

Starting from installing MariaDB and understanding its structure, you will learn step-by-step from writing SQL queries and utilizing functions to joins and subqueries. You will master core practical features such as table design, performance management, backup, and recovery through hands-on practice, completing the practical skills necessary for database development and operation.

Secrets of people who are good at their jobs! How should I start with SQL? It covers everything from SQL installation and basic environment configuration to simple practical exercises that can be used in real life! You can also learn basic commands step by step through practical exercises.

From SQL basics to practical analysis! Learn powerful SQL skills to solve business problems by extracting, transforming, and analyzing data.

I learned it the hard way, but I want you to learn it easily. I've discarded unnecessary theories and included only the core essentials of SQL. Build your SQL confidence quickly.

From Java basics to advanced levels and Oracle SQL, this is a backend web development series where you learn through hands-on practice with star instructor Young-Cody Kim, who makes coding easy to understand even for non-majors and beginners.

Perfect preparation for the SQLD certification, from understanding SQL to practical function application, finishing with the latest exam questions!

This course is structured to help even learners new to data architecture understand the material, progressing from basic data concepts → data structures and design → data modeling → databases → enterprise data architecture → AI data architecture → data architecture in practice and future strategies. In particular, it uses an online shopping company as a recurring case study to connect the foundational concepts covered in the course to real-world data design and AI applications.

Make the most of relational database systems!

A demo takes a day; production is another matter. We’ll build a Text-to-SQL chatbot with local Claude Code, measure its accuracy against 50 questions with known answers, and show with real-world measurements how to protect a production database using guardrails, read-only accounts, privacy protections, and permissions.

This is a course for learning MS-SQL through baseball and corporate databases.

"SQLD is an exam where past questions are not officially released." Preparing for the upcoming 60th exam (2026.3.7)— Practical study material featuring 50 vividly reconstructed questions by subject and chapter, based on the latest 59th exam!

By implementing various practical data analysis cases using SQL, you can simultaneously improve your data analysis and SQL utilization skills.

Learn how modern data teams leverage dbt. Build maintainable analytics models and validated data pipelines hands-on. Master core concepts of analytics engineering with a practical focus. This course is for those who want to take their data career to the next level 🚀

This course aims to obtain the state-certified SQLD (SQL Developer) certification. An SQLD refers to a developer who can write accurate SQL to manipulate and extract data while developing application software based on knowledge of databases and data modeling.

This is a special lecture that can lay the theoretical foundation to simultaneously prepare for the Microsoft AZ-900 certification, and as the latest content reflecting the scope of questions as of May 2025, by providing content related to core data concepts, Azure's relational data, Azure's non-relational data, and Azure's analytical workloads in a form combining theory and practice, it can be utilized as a meaningful educational opportunity to not only obtain the certification but also take the first step towards becoming a data professional.

Let's understand data analysis tailored for advanced retail businesses and learn how to use the tools utilized in the industry!