45 SQL Tuning Techniques You Can Use Right Away in Practice

There are frequently appearing question patterns in the Big Data Analysis Certification practical exam. There are also a few lines of code that you must memorize before going to the testing center. If your goal is to pass the exam, be sure to take this course.

A lecture directly taught by the author of the SQL 200 Questions book (PL/SQL) published by Jeongbo Munhwasa! This is a PL/SQL lecture by Oracle instructor Yoo Yeon-soo, who has trained numerous DBAs and PL/SQL developers. After taking this course, you will clearly feel the difference between before and after using PL/SQL.

A lecture taught directly by the author of the book "SQL 200," published by Jungbo Munhwasa! Over the years, numerous data analysts have empowered their data retrieval skills through instructor Yeon-soo Yoo's SQL lectures.

This course will solidify the basics of SQL through various problems that can be encountered in the actual IT industry. Solve the problem-solving quests, take the first step toward data analysis, and strengthen your SQL skills that can be applied in real life!

Solve the challenges you inevitably face in real-world design—such as common codes, category hierarchies, history tracking, soft deletes, statistics, dynamic design, and JSON utilization—with 9 core patterns. This is not just simple theory; it contains practical know-how and selection criteria for various scenarios, proven across numerous projects. Now, become a true design expert who can confidently handle any requirement that comes your way.

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

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.

This is a course to learn about Airflow, an Orchestration tool for efficiently building and managing data pipelines. Welcome to the Airflow Master Class, where even beginners can learn step-by-step!

A lecture taught directly by the author of the book "SQL 200," published by Jungbo Munhwasa! Over the years, numerous data analysts have empowered their data retrieval skills through instructor Yeon-soo Yoo's SQL lectures.

mongoDB, NoSQL You hear a lot these days, but is it still an unfamiliar database? Aren't you using it like a relational database (RDS/SQL)? No matter how good the technology is, if it's not used correctly, it will have the opposite effect. That's why we often see cases of failure in using MongoDB. This lecture will teach you everything from basic concepts to practical know-how so that you can use MongoDB as MongoDB-like as possible.

Uncover true value in the age of data! 📊 Designing applications focused on data has now become essential. Develop the insight and skills your company wants with the latest trends and practical case studies. Start now with efficient data processing and design secrets! Your next step, leap into the data-driven world!

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 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!

Technology should also start with interest. I have prepared a story about a person who analyzes MBTI of his coworkers. I hope that those who have been daunted by SQL will start studying it with enjoyment.

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

Not only developers, but also planners and data analysts learn databases step-by-step, starting from the basics of SQL.

Revolutionize your stock investing with AI! In this course, you will directly build a functional AI automated trading system targeting the top 25 Nasdaq stocks. We provide a special opportunity to gain experience and know-how through mock trading using the Korea Investment & Securities API, and then transition to AI automated trading with a real account. Even stock market beginners will have no problem. We explain basic stock concepts and the reasons why you should invest in US stocks in an easy-to-understand way, while providing all source codes and even remote support. From now on, investing is essential for the next 60 years of our lives. Create your own AI investment partner to join you on this journey!

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

This course goes beyond simple CRUD-level database usage to help you acquire PostgreSQL skills necessary for the AI era from a practical perspective. Based on AI development experience in Silicon Valley, you will learn step-by-step how to design and utilize JSON, indexes, transactions, and even pgvector in real-world services, while mastering methods to solve complex data structures and performance issues.

Make the most of relational database systems!

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.

This is a lecture using the only domestic e-government framework and Layered Architecture, which are widely used in practice but not available in Korea. In this lecture, we will learn how to build the backend and server side of web development using the Spring Framework and the e-government standard framework.

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 🚀