[Intermediate] Mastering MySQL: From Basics to Practical Application

This course is a practical, hands-on guide for those who want to learn how to maximize development productivity in the AI era. Beyond simply learning how to use AI, we focus on how to utilize Claude Code in a real-world development environment and how to produce "proper results." Many developers use AI but still face issues such as: ❌ Inconsistent results ❌ Poor code quality ❌ Increasing project complexity To solve these problems, this course teaches you how to utilize AI as a "development partner" rather than just a tool through: ✔ Spec-based workflows ✔ Structured command systems ✔ Sub-agent and automation strategies Furthermore, you will gain the experience of completing and deploying a full application from start to finish by integrating with real-world services such as Firebase, Figma, GitHub, and Vercel.

This course is designed for developers, DevOps engineers, cloud engineers, and IT professionals who want to master advanced Kubernetes concepts used in real-world production environments. Throughout the course, students will engage in hands-on projects and real-world deployment scenarios, learning how to build secure, scalable, and production-ready Kubernetes infrastructure. Rather than focusing solely on theory, this course emphasizes practical implementation, troubleshooting, and best practices utilized by modern DevOps teams. One of the biggest challenges students face when learning Kubernetes is understanding how all components interact within large-scale environments. Many learners struggle with topics such as RBAC permissions, persistent storage, namespaces, network policies, StatefulSets, Kustomize, and secure cloud deployments. This course addresses these issues step-by-step through clear explanations, guided labs, and examples that mirror actual production environments. Students will learn step-by-step how to organize Kubernetes resources, secure workloads, manage application configurations, deploy stateful applications like MongoDB, and automate multi-environment deployments using Kustomize. Additionally, the course covers how to deploy applications to Google Kubernetes Engine (GKE) and configure Ingress, TLS certificates, monitoring, and scaling strategies. By the end of this course, students will have the confidence to design, secure, deploy, and manage advanced Kubernetes environments used in professional DevOps and cloud engineering workflows.

While studying Spring Security, you've probably wondered at least once: "I've built the login, but how do I handle authorization?" "How are authentication and authorization implemented in real-world practice?" This course is a practical, project-oriented lecture designed to solve those exact concerns. Instead of just explaining concepts, we implement them exactly as they are used in real services by: 👉 Building on an actual TodoApp project 👉 Integrating with a database 👉 Managing user permissions 👉 Handling validation In particular, I will provide easy, step-by-step explanations for the parts many students find difficult: Method-level authorization Access control within templates Validation using regular expressions Through this course, I will help you confidently say, 👉 "I can actually use Spring Security." 🚀

This course is designed for developers, AI enthusiasts, and professionals who want to develop real-world AI applications using LangChain, OpenAI, Hugging Face, and Python. Rather than focusing solely on theory, this course takes a practical, project-oriented approach. Throughout the course, students will directly build a total of 15 high-quality AI applications, including chatbots, CSV analysis tools, resume screening systems, invoice extraction bots, support assistants, marketing tools, and text-to-SQL applications. I created this course to make complex AI concepts easy to understand and to ensure modern LLM development is accessible to everyone. Many learners struggle to understand how tools like LangChain, embeddings, memory systems, vector databases, and AI agents interact in real-world applications. This course guides you step-by-step through clear explanations, hands-on coding sessions, and actual implementation workflows. By the end of the course, students will confidently understand how to design, build, and deploy AI-powered applications using the latest generative AI technologies.

This course is designed to help learners build solid AWS cloud engineering and architecture skills through hands-on projects and practical demonstrations. Students will learn how to build secure AWS environments, manage scalable computing infrastructure using EC2 and Auto Scaling, configure networking via VPC and Load Balancers, and implement cloud-native storage and database solutions using S3, Aurora, and MySQL. Throughout the course, I will guide students step-by-step using hands-on labs, architectural explanations, and real-world deployment scenarios commonly used in modern cloud environments. I focus on simplifying complex AWS concepts into easy-to-understand lessons while helping students avoid common mistakes made during cloud deployment, security configuration, and infrastructure scaling. By the end of this course, students will not only gain the confidence to design secure, scalable, and cost-effective solutions on AWS but will also be prepared for the AWS Solutions Architect Associate certification exam.

Step into the future of software development with Claude Code and agentic coding. This course is designed to help developers move beyond simple trial-and-error prompting and systematically utilize Claude Code as a true pair-programmer. Instead of blindly copying AI-generated code, you will learn how to effectively direct, control, and automate Claude Code to produce clean, consistent, and production-ready results. Based on a real-world project, **LiftingDiary** (a full-stack Next.js application), you will learn step-by-step workflows used in professional development environments. We cover everything from defining coding standards and generating documentation to improve AI output quality, to automating repetitive tasks and scaling agentic workflows in growing codebases. This course focuses on solving the actual problems developers face when using AI tools—such as inconsistent code, lack of structure, maintenance difficulties, and loss of development control. By the end of this course, you will have a clear system for using Claude Code more efficiently, confidently, and professionally in your daily development workflow.

This course goes beyond simple grammar explanations and focuses on developing C++ programming skills that can be applied immediately in the field. Throughout my teaching, I have directly addressed common challenges faced by many learners—such as struggling to understand the STL or feeling confused by file handling and exception handling concepts. Based on this experience, I provide step-by-step explanations to ensure even complex concepts are understood easily and clearly. Furthermore, this course is not just about delivering theory; it is structured around: 👉 "Why this concept is necessary" 👉 "How it is used in actual code" 👉 "How it is applied in professional practice"

This course is designed to help even those new to MySQL understand it easily, starting from the basic concepts of DBMS and progressing step-by-step to the ability to write SQL that can be applied in real-world practice. To solve the problems learners frequently encounter (e.g., SQL syntax is difficult, not knowing how to write queries, or not understanding the flow of data processing), the course is structured with repetitive theory and practice, helping you naturally build your skills through a hands-on approach. In particular, the focus is not on simple memorization of syntax, but on understanding "why it is written this way" through the process of handling actual data.

This course is a practice-oriented program where you will learn how to build a DevOps environment applicable to real-world services using Microsoft Azure and Azure DevOps. Rather than just explaining simple theories, the lecture proceeds step-by-step through the entire process of creating an actual project, integrating it with GitHub, and building CI/CD pipelines. Additionally, you will learn how to implement automated deployments in various environments using ASP.NET Core and Spring Boot projects. Learners will be able to understand and directly implement the entire DevOps workflow, from project management (Azure Boards) and source control (GitHub) to build and release automation (Azure Pipelines).

This is an introductory course designed for those learning Rust for the first time, structured to help you learn step-by-step from the basics. Many learners encountering Rust for the first time often find it difficult due to: - Unfamiliar syntax - The burden of memory concepts - Differences from existing languages (C/C++) To solve these problems, this course helps anyone understand Rust naturally through: 👉 Easy explanations 👉 Step-by-step curriculum 👉 Repetitive practical examples Rust is a modern systems programming language that offers both safety and performance, making it a very important technology in the future development landscape. Build a solid foundation of Rust's core basics through this course.

This course is a practical, hands-on guide to automating repetitive tasks and maximizing work productivity using ChatGPT and Python. You will learn step-by-step how to use AI to automate daily repetitive tasks such as Excel work, report writing, sending emails, and data organization. Starting as a non-developer myself, I have taught AI automation to thousands of students, and I have compiled only the methods that can be used immediately in actual business environments. This course focuses not on complex theories, but on **"automation techniques you can use right today."** 👉 The goal is to turn ChatGPT into more than just a tool, but into **your own personal work assistant (Jarvis)**.

This course is designed to help even those new to MySQL understand it easily, starting from the basic concepts of DBMS and progressing step-by-step to the ability to write SQL that can be applied in real-world practice. To solve the problems learners frequently encounter (e.g., SQL syntax is difficult, not knowing how to write queries, or not understanding the flow of data processing), the course is structured with repetitive theory and practice, helping you naturally build your skills through a hands-on approach. In particular, the focus is not on simple memorization of syntax, but on understanding "why it is written this way" through the process of handling actual data.

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.

This is a Silicon Valley internship and 30 Big Tech system design & open-source contribution mastery course that ensures job security even in the AI era. In this course, you will design and scale 30 real-world system designs using cases from Big Tech companies such as Netflix, Tesla, Meta, and Tinder. Finally, you will design your own service from architecture to DB and scaling.

This course is a master class that systematically covers the fundamental principles and practical applications of MongoDB. Starting with core MongoDB concepts, you will systematically learn essential topics for practical work, such as database design, CRUD operations, indexing, aggregation pipelines, performance optimization, transactions, and security. It explains topics step-by-step so even beginners can understand, and you can deeply learn the working principles of MongoDB through exercises and examples. This is the best introductory and practical course for developers who want to build strong MongoDB skills for practical work.

Learn how to model data in a distributed database environment.

Channel Talk interviewers will directly analyze the difference between failing and passing answers to the same questions, and help you prepare for actual follow-up questions.

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

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.

Inflearn cumulative students of over 30,000, Datarian's advanced SQL course with extensive online/offline teaching experience. Learn advanced SQL theory and solve 25 practice problems together.

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

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

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!

Learn the SAGA transaction management technique for maintaining data consistency in distributed environments through a hands-on approach. You will configure three microservices using Spring Boot and Docker, and implement both Orchestration and Choreography patterns using Kafka and MySQL. Through this course, you will master core concepts applicable to real-world scenarios, including the operational principles of distributed transactions, designing compensating transactions, and handling fault recovery.

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

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.

This course focuses more on data modeling through entity design than on JPA technical explanations. Based on the principle that solid DB design is the foundation of application development, we analyze various design patterns—such as one-to-many, many-to-many, inheritance, and collections—alongside business scenarios. You will learn by directly observing the process of code being transformed into actual tables on screen. To ensure immediate practical application, we provide business use cases, source code, and test codes for each design pattern.

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

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.

✅ Out of the entire series (1) ~ (7), (5) operating system, user interface, database ✅ CS101 series lectures - From basic computer theory to the latest practical examples - Provides a wide range of basic knowledge

This is a course on creating practical Unity games with databases. It covers topics that are usually difficult to encounter, explained through lectures.