Hands-on SQLD Practice (Subject 2)

🤔 Have you ever had an experience like this?

"I heard it only takes a week, so I opened the 'Yellow Book'... but I got stuck from the very first page."

It's only natural.

People who say they passed in just a week are those who already have a foundation in SQL.

If you rush into a workbook without a solid foundation, you'll end up just memorizing the answers and getting questions wrong as soon as they are slightly modified.

Eventually, you even start thinking, "Maybe I just don't have a talent for SQL."

It is not a matter of talent.

The problem is trying to solve problems without first going through the process of writing basic syntax yourself.

💡 This course's approach

Before solving problems, you will write queries yourself first.

Our course starts with executing each line yourself and visually confirming the results, from what SELECT is to how WHERE works.

Instead of just reading through the theory, you will repeat the process of writing every concept as a query, executing it, and verifying the results.

Once you build a foundation like this, you will start to be able to read the "Noraengi" (Yellow Book) problems. You will begin to see, "Ah, so this is what this question is asking."

🔑 What makes this lecture different

1. From basic grammar to the exam scope, without any gaps

From SELECT, WHERE, and GROUP BY to JOIN, subqueries, and window functions. We build your foundation step-by-step from the very beginning, without skipping any sections by assuming "you probably already know this."

2. Learn all concepts by executing them yourself

We don't just stop at listening to explanations. You will directly write and execute queries for every concept. We even recreate problems from the "Yellow Book" (SQLD study guide) through hands-on practice, helping you grasp the examiner's intent and master standard solution routines.

3. Practice immediately without installation

We provide a Web SQL Lab exclusively for the course.

You can write queries immediately by simply opening your browser, without the need for Oracle installation or environment setup.

It includes an SQL editor, window function visualization, and an ERD schema viewer.

4. Short clips, a structure for selective review

It is divided into short segments by concept and problem.

You can pick and choose only the parts you need to rewatch, and quickly skim through them right before the exam.

🧑‍💻 Recommended for these people

🚀 After taking the course..

• You will become familiar with basic SQL syntax.

• The exam scope can be understood at a glance.

• You will start to understand the "Noraengi" (Yellow Book) problems.

• You will gain the confidence of having covered the entire scope.

👩‍💻 The person who created this course

Ttatji - A researcher who loves to nitpick

I have used SQL every day while building data pipelines in practice.

As a language designed by mathematicians, SQL is a clean and complete language the more you get to know it. I created this course because I wanted to share that enjoyment with those preparing for the exam.

Thanks to my personality of questioning "Why does this work this way?" until the very end, I make sure to point out the details that students often overlook.

📦 Provided Learning Materials

• Web SQL Lab — Practice directly in your browser without any installation

• Query Script

• Summary Guide

• Problem analysis materials

Things to note before taking the course