DATABASE 1&2 - MySQL

This course covers how to use Linux. The part that beginners find particularly difficult is how to control the computer using commands. This course covers the most common rules that beginners need to use commands.

Learn how to create components in React and the relationship between React and immutability.

This class covers the basics of using AWS (Amazon Web Services), a cloud service, and S3, which provides storage space for files.

This is a course on basic internet knowledge taught by Life Coding.

This is a crowdfunding course called Web 1, taught by Lee Going of Life Coding, which teaches programming to the general public. This course allows anyone to have the opportunity to learn coding by creating web pages using HTML, the foundation of the web.

This is a basic JavaScript language course for daily coding. You can learn the basics of JavaScript through basic grammar.

I will sequentially teach you the minimum required things to study PHP.

This is a class where you can learn the basics and use of AWS, a global cloud service. Show off your own service to the world using AWS.

This class was created to provide knowledge and experience about CSS while creating https://opentutorials.org (a daily coding site).

I will show you how to create web applications using JavaScript and Node.js. By using JavaScript, which runs in the web browser, you can replace the roles of PHP or JSP. This allows you to implement an entire web application using a single language.

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.

You can develop your understanding of programming by creating games with Scratch.

This article explains in a simple and easy-to-understand way what Git is, why you should use it, and how to use it, using Source Tree, a more accessible GUI Git tool.

This course was created to provide you with knowledge and experience in PHP while creating https://opentutorials.org.

This is a course that has been moved to Inflearn for easy learning through the agreement of the original author of Life Coding. I would like to express my gratitude to Life Coding http://opentutorials.org.

This course teaches you how to implement authentication using Session in Express, a Node.js web framework.

This is a new HTML class by egoing from 생활코딩 (Open Tutorials).

This lesson introduces how to use Git through commands.

This is a SQLite lecture provided by Living Coding (Open Tutorials), which will help you get started with the relational database SQLite.

This course will teach you how to use Passport.js, an authentication middleware for Node.js Express.

The basics of database! We will help you to clearly understand the concept of your DB. We will help you not to get lost in any study related to database in the future.

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 is a course that has been moved to Inflearn for easy learning through the agreement of the original author of Life Coding. I would like to express my gratitude to Life Coding http://opentutorials.org.

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

How will you handle exploding traffic? Learn how to build resilient and flexibly scalable architectures through practical EDA (Event-Driven Architecture) design patterns using Kafka, Spring, CDC, and Temporal. A Kakao developer shares real-world experience with clear, easy-to-follow explanations that even non-majors can understand. A practice-oriented course covering everything from real-time data flow and event processing to microservice integration!

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.

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.

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 course for learning MS-SQL through baseball and corporate databases.

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 is a course on creating practical Unity games with databases. It covers topics that are usually difficult to encounter, explained through lectures.

Learn how to analyze 5 million Korean apartment transaction data using PostgreSQL. Covers the process of data cleaning, transformation, and deriving meaningful insights through various SQL queries.

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

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

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.

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.

Immutable truths for developers/engineers that will never change even in the AI era! We provide essential computer science knowledge for free to prepare for developer/engineer job applications and technical interviews.

If you can master DB and programming, you should be more than halfway prepared for the information processing engineer exam. Let's take a look at the DB and programming parts, which are worth 45 to 55 points in the practical exam, and pass the written exam steadily.

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.