Mastering MySQL from Basics to Practice (SQL Introductory Course)

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 designed to help you easily understand and apply deep learning through both theory and practice using PyTorch. Based on their experience in machine learning projects, the instructor explains complex concepts (neural networks, optimization, model training) step-by-step so that anyone can understand them. Many learners know the theory but struggle with implementing actual models. This course is structured with a focus on practice to solve this problem. Through this course, you will understand the core concepts of deep learning and be able to build computer vision and sequence data processing models yourself.

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)**.

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.

Have you ever felt frustrated with table design? This course is for those who have had concerns like, "Is this table right?", "Which column should be the PK?", "Is it okay to connect relationships this way?", or "Will I have to rebuild the table when adding new features?"

I have created a course titled 'Introduction to MySQL Performance Optimization & Practice (SQL Tuning Edition)' that is easy for non-majors to understand and can be applied immediately in practice!

I will transform the Engineer Information Processing written exam (Subjects 1–5) from a "test you solve by memorizing" into a "test where you connect clarified points directly to your score." This is an ultra-compressed lecture designed to help you grasp the entire flow within 3 days. It extracts only the core concepts repeated in past exams, structured to be understood even if viewed right before the test. The course is designed for short-term success by clearly distinguishing between frequently confusing concepts, trap points in multiple-choice options, and what needs to be memorized versus what only needs to be understood. "I'm short on time, but the scope is too broad." "I feel like I know the material when reading the book, but I keep getting the questions wrong." This lecture is for students facing these exact challenges.

Let's learn together about Columnar Storage, which allows you to conveniently handle both structured and unstructured data provided by GCP and allows for a free table format, and BigQuery, a universal database.

Learn about Race Condition, a representative concurrency problem. Practice by comparing single server environments and distributed environments that cause concurrency issues. Understand transaction boundaries and isolation levels. Learn the differences between optimistic locking, pessimistic locking, and distributed locking.

A must-have subject for aspiring developers and those looking to get a job in big data!!

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

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.

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.

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.

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

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 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 an introductory BigQuery (SQL) course for beginners. I recommend it to those who are curious about how to process data. I will teach SQL from the perspective of data analysis and data engineering, rather than from a backend development perspective.

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

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

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

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