45 SQL Tuning Techniques You Can Use Right Away in Practice

There are frequently appearing problem patterns in the Big Data Analytics Engineer practical exam. And there are also a few lines of code that you must memorize before going to the test center. If passing the exam is your goal, 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.

Author's direct lecture for the SQL200제 book published by Jeongbomunhwasa! So far, numerous data analysts have gained wings in their data retrieval skills with Instructor Yooyeonsu's SQL lectures.

How is processing big data different from processing data with Pandas? Let's learn about Spark, an essential framework for big data processing.

"Big Data + AI Full Stack Development" - The process of building big data that breathes life into AI is carried out in the form of a pilot project. We identify requirements, configure the platform step by step, and perform smart car data exploration and analysis.

This is a course aimed at obtaining the nationally recognized SQLD certification, and SQLD refers to developers who can write accurate SQL for manipulating and extracting data while developing application software based on database and data modeling knowledge.

If you work with data, SQL is a fundamental skill you must know. In this course, we will learn SQL from a data analysis perspective, focusing on hands-on practice. The practice will be conducted in Google Colab using DuckDB.

A beginner's guide to SQL coding! We'll teach you the secrets of writing, interpreting, and validating SQL.

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.

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.

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!

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 teaches MS-SQL through baseball/company databases.

You can learn the core concepts of GA4 (Google Analytics) e-commerce setup, which is too difficult to learn on your own by searching the internet, through hands-on practice. Performance marketers and beginner developers who are setting up GA4 e-commerce for the first time can easily understand by practicing step-by-step setup on a cafe24 demo shopping mall. Since the developer's role is handled by chatgpt during the practice, marketers and PM/planners without specialized development knowledge can also learn about GA4 e-commerce setup.

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 basic SQL SELECT grammar lecture that starts without installing SQL.

Make the most of relational database systems!

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.

This course is designed to help you learn the core functions of FastAPI, as well as the entire process of web service development. Through this course, we will help you become a FastAPI expert developer needed in the field.

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 🚀

Revolutionize your stock investments with AI! In this lecture, you will directly build a real, working AI automated trading system targeting the top 25 NASDAQ stocks. We provide a special opportunity to gain experience and know-how through simulated investments with the 한국투자증권 API, and to perform AI stock automated trading with a real account. Even stock beginners will have no problem. We will easily explain basic stock concepts and why you should invest in US stocks, and provide all source code and remote support. From now on, investment is essential for the next 60 years of our lives. Create your own AI investment partner that will be with you!

What do you learn in the 'Business Information Visualization Certification' course? This certification course focuses on developing the ability to analyze data well, visualize it in an easy-to-understand way, and clearly and effectively communicate the information needed when making important decisions in a company or organization. Simply put, it's a course where you learn the skills to not just look at data, but to discover the hidden meanings within it and express them through pictures, tables, graphs, etc., so you can explain them well to others. Through this course, you will: Develop the ability to think strategically through data, build practical skills that can be immediately applied to actual work, and enhance your professional expertise and competitiveness. Through this lecture, develop the ability to connect business and data, and take one more step toward becoming an expert who understands and explains data.