The Ultimate MySQL: From Beginner to Advanced SQL-(2026)

Course Summary: This course teaches Java and Spring Boot developers how to design, build, and maintain Retrieval-Augmented Generation (RAG) systems at production level. Using Spring AI, PostgreSQL, and Redis, you will learn how to create robust pipelines for ingestion, chunking, embeddings, and retrieval, while orchestrating LLM behavior with reliable prompts. I share my backend engineering experience to help students solve common challenges: data inconsistency, inefficient retrieval, and unreliable prompts. By the end, you will be able to build a fully functional and maintainable internal knowledge assistant, with scalable, production-ready code.

This course is designed to help developers who feel overwhelmed by Docker, Kubernetes, and cloud deployments finally understand and apply DevOps concepts step by step. Based on real-world experience deploying containerized applications to production, I guide students through hands-on labs, clear explanations, and common mistakes beginners face. You will start from the basics of Docker and Kubernetes, build real containers, deploy applications locally, and then move confidently to Azure Kubernetes Service (AKS) with CI/CD pipelines using Azure DevOps. Every concept is explained practically, with a strong focus on “why” and “how”, so you don’t just follow commands—you actually understand what you’re doing and how to use it in real projects.

Course Summary: This course teaches you how to create multichannel AI agents that handle customer support across website chatbots, Telegram, emails, forms, and feedback—all without writing a single line of code. Drawing from my experience in helping students and professionals implement real-world AI solutions, I provide step-by-step guidance to design, connect, and deploy AI agents that actually work. You will learn to build a fully functional system, debug common issues, and even monetize your skills for clients or your own business. By the end, you'll have a practical project and ready-to-use AI agent templates.

In this course, I share my real-world experience building production-ready GraphQL APIs using Apollo Server, Node.js, Express, and MongoDB. Over the years, I’ve helped developers move from REST to GraphQL by breaking down complex concepts into clear, practical steps and solving common pain points such as authentication, pagination, performance optimization, and schema design. This course focuses on hands-on learning. You will build a complete GraphQL API from scratch, implement JWT authentication, design scalable schemas, and optimize performance using DataLoader, batching, and caching. Each concept is explained with practical examples so you can confidently apply it in real projects.

This course is a complete bootcamp designed to teach Android application development using Kotlin from scratch. It is structured to guide students step by step, even if they have no prior programming experience. With years of experience in programming and teaching, the instructor focuses on solving the most common problems students face when learning Android development. Each concept is explained clearly through practical examples, hands-on exercises, and real projects. Students will not only learn theory but also understand how to apply it to build real Android applications confidently.

This course is designed to help beginners confidently manage a VPS server and host professional websites without feeling overwhelmed by technical complexity. With over 5 years of experience working with WordPress and VPS-based hosting, I have helped many beginners solve common problems such as slow website performance, poor security, high hosting renewal costs, and limited control on shared hosting platforms. In this course, I break down complex server concepts into simple, step-by-step lessons that anyone can follow. You will learn how to purchase an affordable and high-performance VPS, connect a custom domain, install WordPress or other websites, secure your server, and manage everything using a reliable and user-friendly control panel. I also guide you through setting up Cloudflare for DNS, free SSL, CDN protection, automated backups, FTP access, database management, and a secure email server. By the end of this course, you will have the skills and confidence to manage your own VPS server, host multiple websites, and run a secure, scalable, and cost-effective web hosting environment.

This course is built from real experience teaching beginners who often feel lost when starting Unity and game development. Many students struggle with understanding how scripts work together, how game mechanics are connected, and how to turn simple ideas into a complete playable game. In this course, I guide students step by step, explaining every concept clearly and practically. Instead of overwhelming theory, we focus on building a real 2D space shooter game from scratch. Every script is written and explained line by line so students understand not only what to do, but why it works. The goal is to remove confusion, build confidence, and help students think like game developers. By the end of the course, students are able to understand Unity 2D fundamentals and confidently start their own game projects.

This course is designed to help complete beginners overcome the most common challenges in game development: understanding Unity, learning C#, and knowing how to turn ideas into real, playable games. Through years of teaching beginners, I have learned that students struggle most with complex explanations, disconnected theory, and lack of real practice. That’s why this course follows a clear, step-by-step, hands-on approach, where every concept is explained simply and immediately applied in real game projects. Students will build full 2D games from scratch, learning how to create player movement, enemies, levels, UI systems, animations, audio, and complete game flows. By the end of the course, learners will not only understand how 2D games work but will confidently create and export their own games using Unity and C#.

This course is designed for beginners who want to learn Unity 3D through a clear, practical, and problem-solving approach. Based on real teaching experience with beginners, this course focuses on explaining concepts step by step, in simple language, without assuming any prior knowledge. Common beginner problems—such as understanding GameObjects, movement, shooting logic, enemy behavior, and UI—are addressed carefully with hands-on examples and clear explanations. Instead of overwhelming students with theory, each lesson builds directly on the previous one, helping learners understand why things work, not just how to copy code. By following the full project from start to finish, students gain confidence and a strong foundation in Unity 3D by creating a complete and playable Space Invaders–style 3D game.

This course is designed to help learners master AI prompt engineering and confidently use ChatGPT and generative AI tools to solve real-world problems. Through my experience working with students, professionals, and entrepreneurs, I have identified a common challenge: many people use AI tools without knowing how to instruct them effectively. This often leads to inaccurate, generic, or unusable outputs. In this course, I guide learners step by step on how to communicate with AI the right way, using proven prompt patterns and practical examples. By combining clear explanations, real-life use cases, and hands-on techniques, I help students transform AI into a powerful assistant for writing, business growth, productivity, presentations, meetings, and creative work. This course focuses on practical results, not theory, so learners can immediately apply what they learn to their personal or professional projects.

This course is designed to help students move beyond theory and actually build real AI-powered marketing automation systems. Drawing from hands-on experience designing and implementing AI workflows, I focus on solving common problems students face—such as disconnected tools, repetitive manual tasks, inconsistent content creation, and lack of scalable automation. Rather than relying on abstract explanations, I teach through practical demonstrations and step-by-step workflows using n8n as the central automation platform. Students learn by building real marketing automations, AI agents, and multi-step workflows that connect ChatGPT, APIs, and business tools into reliable systems. By the end of the course, students don’t just understand AI automation—they know how to design, deploy, and orchestrate agentic AI workflows that solve real marketing problems efficiently.

This course provides a complete, concise, and practical introduction to Jira and Confluence for Agile project management. Based on real-world experience, I guide students step by step through setting up Agile projects exactly as Jira and Confluence were intended to be used. Throughout the course, I focus on solving the most common challenges beginners face: understanding Agile concepts, organizing backlogs, planning sprints, managing teams, and documenting work effectively. Instead of theory overload, I demonstrate clear workflows, real examples, and best practices that students can immediately apply in their own teams or organizations. By the end of the course, students gain the confidence to manage Agile projects, collaborate efficiently, and use Jira and Confluence as professional project management tools.

This course is built from real-world agile delivery challenges faced by Scrum Masters, Project Managers, and Product Managers who struggle with time pressure, unclear requirements, overloaded backlogs, and inefficient meetings. Through hands-on demonstrations and step-by-step workflows, I show students exactly how to use Generative AI tools—such as ChatGPT, Jira AI, Confluence AI, Rovo AI, and Fireflies.ai—to solve these everyday problems. Instead of theory, the course focuses on practical use cases: creating product goals, refining user stories, generating acceptance criteria, planning sprints, automating documentation, and improving team collaboration. Each lesson is designed to help learners apply AI immediately in their daily work, build confidence with industry-standard tools, and develop AI-powered habits that increase productivity, clarity, and leadership effectiveness in agile environments.

This course is based on a real production workflow behind a Breaking Bad–inspired cinematic animation created and published on my YouTube channel. Instead of showing only final results, I focus on explaining every step of the process in detail, including the decisions, techniques, and problem-solving methods used during production. Many students struggle to understand how all parts of a cinematic scene fit together — environment creation, animation, lighting, assets, and final assembly. This class is designed to solve exactly that. Through a 4-hour in-depth tutorial, I guide you step by step through the creation of two full scenes, sharing practical techniques, common mistakes to avoid, and a clear production workflow you can reuse in your own projects.

This course is designed to help students confidently create large-scale landscape scenes in Blender without feeling overwhelmed by complex workflows. Throughout the class, I guide students step by step, explaining not only what to do, but why each decision is made. Common beginner problems—such as scene scale, camera placement, managing large environments, and shader complexity—are addressed clearly and practically. By breaking the entire process into manageable stages, students can follow along easily while still learning professional techniques used in real environment production. The course starts with Blender basics and gradually introduces more advanced concepts like volumetrics, shader mixing, photogrammetry assets, lighting, and compositing. My teaching approach focuses on clarity, real-world dimensions, and efficient workflows, ensuring students can recreate the process on their own and apply it to future projects.

In this course, I guide students step by step through the complete process of creating a detailed cyberpunk-style scene in Blender, starting from Blender’s default cube and ending with a fully rendered, cinematic environment. Throughout the course, I focus on solving the most common problems students face when learning 3D, such as understanding the full modeling workflow, fixing UV issues, adding realistic imperfections, and creating convincing lighting and atmosphere. Every step is recorded in real time, with clear explanations of not only what to do, but why it is done that way. By combining hands-on modeling, texturing, scene building, lighting, and post-processing, this course helps students gain confidence in their Blender workflow and teaches them how to turn a simple idea into a polished, professional-looking scene.

In this course, I guide students step by step through the process of creating a procedural city generator in Blender using Geometry Nodes, and using it to build a cinematic Batman-inspired scene. The course is designed to solve one of the most common problems beginners face: understanding Geometry Nodes and knowing how to apply them in real projects. Instead of focusing on theory alone, I teach through a practical, beginner-friendly workflow, explaining every step and decision in a clear and efficient way. Students will learn how to model optimized buildings, create flexible Geometry Nodes setups, control lighting through shaders, and finally compose and render a complete cinematic scene. My goal is to help students not only follow along, but truly understand how to reuse these techniques in their own future projects.

This course is designed to guide beginners through a complete cinematic workflow in Blender, from the first idea to the final rendered scene. Drawing from practical production techniques, the course focuses on solving common beginner problems such as inefficient modeling, overcomplicating textures, and struggling to achieve realistic results with limited time. Each step is explained clearly and recorded in real time, showing not only what to do, but why it works. Students will learn how to create a visually rich cinematic scene using smart low-poly modeling, collage textures, efficient UV unwrapping, and emissive shaders. The course also covers lighting, environment creation, volumetrics, and scene composition to achieve a moody, cinematic look. By following a structured, step-by-step approach, students gain confidence in Blender while learning time-saving techniques they can reuse in future projects. Only Blender is required, making this course accessible and easy to follow for beginners.

In this course, you will learn a complete CG and VFX workflow inside Blender by creating a cinematic Batman-inspired scene from start to finish. We begin by analyzing real movie footage from The Batman (2022) to build strong visual references for lighting, camera placement, and color grading. Step by step, you will learn how to block a scene, project camera footage, match CG with live-action, and smoothly blend both elements to achieve a cinematic result. Around 90% of the final scene is created in CGI, making this course ideal for learning how professionals combine live footage and CG efficiently. The course focuses on practical techniques, helping you avoid common beginner mistakes in lighting, camera matching, and post-processing. By the end of the course, you will have a complete cinematic shot and a solid foundation in Blender-based CG and VFX workflows that can be reused in your own projects.

This course is designed to help you learn MySQL databases and SQL step-by-step, from the absolute basics to a professional level. It covers database concepts, relational models, SQL syntax, queries, conditions, sorting, functions, joins, subqueries, and indexes, with a focus on practical examples. The curriculum is structured so that you can understand concepts many students find difficult (such as joins, subqueries, and group functions) by following along directly. With a flow of Theory → Practice → Summary, this course ensures you can complete it until the end without getting stuck. Whether you are new to SQL or want to brush up on the basics, you will gain database skills that can be applied immediately in the workplace.

I've created a 'MySQL Performance Optimization Beginner/Practical Course (SQL Tuning Edition)' that's easy to understand even for non-majors and can be immediately applied in real-world situations!

Make the most of relational database systems!

This course is for those who are learning database programming for the first time or those who have some knowledge but want to learn systematically. From concepts to practical exercises, you will master the database query language by organizing examples of types that frequently occur in real life.

This course proceeds in stages, similar to the actual work, by learning and applying the necessary knowledge while configuring the infrastructure.

This is a full-stack restaurant map tutorial that allows you to learn everything from front-end, back-end, Kakao Map API usage, and deployment all at once while creating a restaurant map of your favorite YouTuber.

We will inform you about the platform mass adoption method using AWS (S3, CloudFront) and MySQL (Geospatial Query).

We covered the concepts considered while migrating 20 billion data items managed through the existing MongoDB to MySQL.

This course provides a step-by-step learning path, ranging from the fundamental usage of MySQL to advanced techniques required in real-world production environments. It covers a wide range of topics, including data modeling techniques based on various case studies and practical data, evaluating the effectiveness of Foreign Key designs, analyzing Google Calendar schema DDL, and modern DDL design principles. Through this course, you will gain an in-depth understanding of how to utilize MySQL as a core system component rather than just a simple database.

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

From understanding SQL to using actual functions, Complete preparation for SQLD certification with the latest past exam questions!

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 course is designed to help students learn and practice PHP programming concepts. It is designed for students who want to learn PHP programming concepts.

A practical course on easily building a super simple bulletin board with Spring Boot and React.js! This course focuses less on theory and more on hands-on practice, covering the web application development process for quick completion.

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.

Just listen. The lecturing skill, captivating power, and lecture quality are different.

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

This is a basic SQL SELECT grammar lecture that starts without installing SQL.

This course teaches you how to implement modern web applications that combine the accessibility of the web with the excellent information management capabilities of a database by linking PHP and MySQL.

We enable you to fundamentally understand and resolve issues where Hangeul appears broken on web pages or in databases, or files contain unknown characters.