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 involves designing and implementing the application, directly designing and configuring the Cloud infrastructure architecture, and running the developed program in a Cloud environment.

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 course teaches you how to write performance-conscious queries during the SQL development phase, guided by a SQL Server expert. You can learn the basics for meeting query performance requirements along with practical case studies.

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.

Learn how to model data in a distributed database environment.

A DBA instructor with 30 years of experience teaches 45 essential SQL tuning techniques that can be immediately applied in practice through real-world examples. Master the practical know-how to make slow queries 10 times faster, from execution plan analysis to index optimization and join tuning!

I have summarized the essential SQL SELECT statements and basic usage of Google Sheets that I learned while working as an analyst at a service company.

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

Learn how to use AI tools to strategically analyze raw data and visualize it persuasively—without complex or tedious statistical or coding knowledge. Starting with preprocessing messy raw data, you’ll complete complex tasks such as exploratory data analysis (EDA) and correlation analysis through just a few AI conversations, dramatically reducing the time required for practical analysis. Through concise, hands-on theory and scenario-based exercises, develop your own end-to-end professional skills for transforming numbers into powerful tools of business persuasion.

In the era of AI and Big Data, are you utilizing your organization's data effectively? This course builds essential capabilities for reading and interpreting data, covering everything from the foundations of statistical thinking to the core principles of machine learning and deep learning. Grow into a practical leader capable of discovering patterns amidst volatility and making data-driven decisions.

SQL data analysis! We will teach you how to solve practical problems that are applicable in the field, quickly and easily!

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.

Is it enough to just search for past exam questions and pass the Google Analytics Individual Qualification (GAIQ)? A certification holds little meaning if you obtain it without knowing how GA4 is actually used in practice or how to query and utilize data. This course focuses on practical application, allowing you to directly examine reports and GA demo accounts, and even set up a demo shopping mall yourself. You will build the skills necessary for the field while solving the latest 2026 GAIQ exam questions.

This is a code-lab-oriented course where you will directly build big data or distributed processing system clusters (HDFS, Zookeeper, Spark, Zeppelin) that guarantee High Availability.

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 🚀

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

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

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.

With the arrival of the AI era, the skills required of developers are becoming increasingly complex. You might have thought, "I just need to be good at frontend," but when you try to create your own service or integrate AI features, you eventually hit a massive wall called the backend. However, as you try to start backend development, are you overwhelmed by how much there is to learn—from database design and authentication (Auth) to storage management and complex infrastructure setup? Now, you can lay down that heavy burden. In this course, we use Supabase, which solves all these backend functions at once. We will guide you through the fastest shortcut to becoming a full-stack developer who can "instantly" complete a backend without complex server knowledge and bring ideas to life immediately.

★.NET 8.0★ This is a basic Windows Desktop development course using WinForms. Learn how to easily perform DB CRUD operations using EntityFrameworkCore. I will teach you class design methods based on loose coupling and the "basics" of Form UI Design. The source code used in the lecture is also provided :)

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.