The Essence of SQLD: Mastering the Yellow Book Problem Set

The easiest ADsP introductory course that even non-majors can understand right away! From basic concepts to expected questions, everything you need to pass!

Do you want to generate significant profits even in a bear market? Are you interested in automated trading but haven't been able to start because of coding, trading strategy design, exchange APIs, or server deployment? In this course, we guide even those new to Python to turn trading ideas into concrete strategies using ChatGPT and Codex, and implement them into backtesting and live automated trading code. We will practice Binance Futures automated trading using Python and CCXT, technical indicator strategies, DCA (dollar-cost averaging) backtesting, and Upbit API-based Kimchi Premium strategies. Afterward, we will apply Telegram notifications and order safety features, manage the completed bot with GitHub, and deploy it to a cloud server. Rather than leaving all investment decisions to the LLM, humans will determine the strategies and risk management criteria, while using the LLM as an assistant to help with strategy design, coding, and troubleshooting. After completing the course, you won't just be running the provided code—you will be able to create, verify, modify, and deploy your own unique strategies!

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?"

This course was created based on my personal experience passing the very first revised Information Processing Engineer practical exam, which had a pass rate of only 5.34%. The Information Processing Engineer practical exam can no longer be prepared for through simple memorization alone. In particular, the ability to read the execution flow of C, Java, Python, and SQL code to track results, as well as the ability to accurately distinguish short-answer concepts and write them as answers, has become crucial. This course is structured to help even beginners who are new to programming follow along step-by-step, covering everything from creating variable tables to tracking C, Java, Python, and SQL code, core practical terminology, and written exam subjects 1 through 5. Rather than being a video-centered course, this is a text-based course designed for fast reading and repeated review. It makes it easy to look up necessary parts again and focuses on practicing how to derive answers at the testing center by following the code and explanations directly. The 1st update covers the practical programming sections: C, Java, Python, and SQL. The 2nd update will organize core terms and concepts required for the short-answer practical questions and provide a "Stepper Simulator" to practice code tracking directly. The 3rd update will sequentially expand to cover written exam subjects 1 through 5. The Stepper Simulator is designed so that you don't just stop at reading explanations; you can understand how variable values change as the code executes line by line by following along yourself. If you have any questions while taking the course, please leave them in the Q&A. I will respond as quickly as possible to ensure your learning doesn't get stuck.

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

"A query that ran perfectly during development suddenly slows down as data accumulates." At such times, the mark of a truly skilled developer is identifying the root cause based on solid evidence rather than guesswork, and optimizing a 30-second query down to 0.1 seconds. Master the core principles of database performance—from execution plans, indexes, and optimizers to joins and sorting—using millions of rows of real-world data. Elevate your skills and become a top-tier developer capable of independently analyzing and resolving slow queries in production environments.

Learning by Doing: 정보처리산업기사 I have prepared everything for passing the 정보처리산업기사 course-evaluation practical exam.

You will systematically learn database design through three stages—conceptual, logical, and physical—and strengthen your skills through a practical shopping mall project. Gain real-world know-how through modern design techniques and the latest trends.

For those feeling overwhelmed by SQLD exam preparation, this is a standard course that analyzes the entire scope of the "Yellow Book," organizes the necessary theories through practice-oriented lessons, and solves every single problem. With short, concise clips and a topic-based structure, you can build the practical skills needed to succeed on the actual exam.

SQLD Yellow Book 176 Problem-Solving Course for those who studied but can't solve problems. After completion, you'll go beyond passing to become an expert. SQLD All-in-One Pass!

Solve 25 SQL problems of various difficulty levels. This is the Advent of SQL 2024 explanation lecture. Upon finishing the lecture, you can complete the Advent calendar and obtain a badge.

Solve 25 SQL problems of varying difficulty levels. This is a commentary lecture for Advent of SQL 2025, and upon completing the course, you can finish the advent calendar and earn a badge.

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.

SQLD, where should I start? For those of you feeling completely overwhelmed, this is the lecture for you. You will meet a transformed version of yourself after completing the course. SQLD All-in-One Pass!

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

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