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.

This lesson introduces how to use Git through commands.

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

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

This is a Life Coding JavaScript course. We will study the JavaScript reference that allows you to directly control the web browser.

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

This class is about how to implement a web application using Express, a representative web framework for Node.js.

This course covers how to create a web application that uses JavaScript to control Node.js and dynamically generate HTML code.

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

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

This class introduces the version control system git.

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 class was created with the goal of providing knowledge and experience in JavaScript while creating https://opentutorials.org (a Life Coding site).

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

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 course will implement cookie and login functions using NodeJS, a server-side Javascript, and combine the results with the previous nodeJS course to create a complete web application.

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

This is a lecture on OAuth provided by Living Coding, where you can learn technologies for API interoperability.

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.

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.

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.

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.

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

We will learn how to create a system to support large amounts of data and traffic by creating it directly with Spring Boot.

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

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

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

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

This is a content about backend development using two databases, MySQL and Mongo, for job seekers preparing for backend employment.

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 how to analyze 5 million records of Korean apartment transaction data using PostgreSQL. It covers the process of deriving meaningful insights through data cleaning, transformation, and various SQL queries.

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.

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

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 common components of global-scale services through popular papers, books, and articles.

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.

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.

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.