Intermediate PostgreSQL in Practice: Data Modeling, Tuning, and Analysis of 5 Million Apartment Transactions

Are you struggling with inefficiencies caused by fragmented AI tools and manual tasks? Drawing on the expertise I’ve gained through hands-on experience, I’ll build integrated automation workflows to maximize your productivity.

This covers the process of creating AWS resources based on AWS InfraArchitecture using Terraform modules.

This course covers performance and load testing of a sample web application using Locust.

How long will you keep struggling with repetitive daily research and document writing? I, too, was an ordinary office worker who worked overtime every day trying to find key insights amidst an overflow of information. However, after integrating Gemini 3 into my workflow, I experienced a significant increase in work speed. Boost your productivity by utilizing Gemini in your tasks.

This is a lecture that teaches you how to save time and maximize your work productivity by using NotebookLM.

GCP (Google Cloud Platform) is Google's cloud computing service, offering a variety of infrastructure and platform services. This allows you to leverage various functionalities.

This involves designing and implementing the application, directly designing and configuring the Cloud infrastructure architecture, and running the developed program in a Cloud environment.

Through this course, you will learn about SQL and databases, SQL syntax, database design for practical use, how to use databases through programming, and real-world applications of data analysis.

Extract and utilize data through Oracle 18c and become a database expert!

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

This is a practical backend course designed to cultivate the service planning and design thinking skills that developers need in the AI era.

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.

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

Systematically learn the distributed NoSQL database Cassandra, from basic concepts to practical application. Develop high-volume data processing capabilities through practice-oriented theory and hands-on exercises, including data modeling, query optimization, and cluster configuration. Even without prior database experience, you can grow into a Cassandra expert based on the know-how of a current Silicon Valley developer.

It contains a comprehensive introduction to databases, the heart of information technology. We study the essence of databases and learn about MYSQL, the most representative relational database.

"Data analysis—don't stay trapped in complex Python syntax and Excel functions anymore." This course is a practical masterclass that automates the entire data processing journey—from Excel and Google Sheets to Python-integrated analysis—by hiring the latest AI agents as your personal dedicated data analysts. Instead of difficult coding knowledge, we introduce the latest 'Vibe Coding' method, where you give commands as if having a natural language conversation. This allows non-majors and humanities students to enter the world of data analysis without any barriers. Experience a powerful AI workflow that can be applied to your actual work tomorrow through comprehensive hands-on practice using real business data, covering everything from data preprocessing and visualization to report writing. A lecture on utilizing AI agents, Excel data analysis, chatGPT, Gemini, (Python), Genspark, Google Colab, chatbots, Google Antigravity, and notebookLM.

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.

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

"Data analysis—don't stay trapped in complex Python syntax and Excel functions anymore." This course is a practical masterclass that automates the entire process of data processing, from Excel and Google Sheets to Python-linked analysis, by hiring the latest AI agents as your own dedicated data analysts. Instead of difficult coding knowledge, we introduce the latest 'Vibe Coding' method—commanding as if having a conversation in natural language—allowing even non-majors to enter the world of data analysis without any barriers. Through comprehensive hands-on practice using actual business data—covering everything from data preprocessing and visualization to report writing—experience a powerful AI workflow that you can apply to your work starting tomorrow. A lecture utilizing AI agents, Excel data analysis, chatGPT, Gemini, (Python), Genspark, Google Colab, chatbots, Google Antigravity, and notebookLM.

If you want to be recognized as a machine learning expert in large-scale data environments—from understanding the core framework of Spark Machine Learning to SQL-based data processing through high-difficulty practical problems, and the ability to implement optimized machine learning models through business domain analysis—join this course.

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!

Learn common components of global-scale services through popular papers, books, and articles.

This course is designed for those who are new to Debezium-based CDC and unsure where to begin. You will gain hands-on experience with the entire process of collecting MySQL change data in real time via Kafka and delivering it to PostgreSQL. By learning everything from the basic principles of CDC to configuration and operational best practices, you will be able to build real-time data pipelines on your own.

This course teaches you how to build a practical Unity game with a database. It covers difficult-to-access topics in an easy-to-follow lecture format.

What do you learn in the 'Management Information Visualization Professional' certification course? This certification course focuses on developing the ability to analyze data effectively, visualize it for easy understanding, and communicate necessary information clearly and efficiently for important decision-making within companies or organizations. In simple terms, it is a process of learning the skills to not just look at data, but to uncover hidden meanings within it and express them through charts, tables, and graphs so they can be easily explained to others. Through this course, you will: Develop the power of strategic thinking through data, build practical skills that can be applied immediately to real-world tasks, and enhance your professional expertise and competitiveness. Through this lecture, cultivate the ability to connect management with data and take a step forward as an expert who understands and explains data.

This course goes beyond basic CRUD-level database usage, helping you develop the PostgreSQL skills needed in the AI era from a practical, real-world perspective. Drawing on AI development experience in Silicon Valley, you’ll gradually learn how to design and use JSON, indexes, transactions, and pgvector in actual services, while gaining the skills to solve complex data structure and performance problems.

This lecture is designed for job seekers preparing for Evaluation and Analysis roles in Samsung Electronics' DS Division (Memory, S.LSI, Foundry, TSP, AVP) and PE, AE, and Solution PE roles at SK hynix, who are struggling with the differences between business units and job functions. You will learn how to categorize job titles by company based on the actual workflow of Product Evaluation roles and how to translate your major-related experiences into professional terminology suitable for resumes and interviews. We will help you establish an application strategy by connecting experiences in Analog circuit design, Verilog/FPGA, process experiments, and data analysis with key industry terms such as Yield, Wafer Map, Shmoo Plot, and Failure Analysis.