Life Coding - MySQL

This lesson introduces how to use Git through commands.

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

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

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 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 covers the basics of using AWS (Amazon Web Services), a cloud service, and S3, which provides storage space for files.

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

This class introduces the version control system git.

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.

CSS is a designer's language that makes HTML look beautiful. I think CSS is like a brush stroke for those who produce digital content. In this lesson, I will teach you how to use a digital brush stroke.

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

This is a course that has been moved to Infraon 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 will teach you what effects you can get when you introduce Python into a website created in WEB1.

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 is a Life Coding JavaScript course. We will study the JavaScript reference that allows you to directly control the web browser.

This is how to use various developer tools introduced in Life Coding.

This is a JavaScript-related lecture provided by Life Coding. It is a class on how to handle data immutably in JavaScript.

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

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.

The importance of MySQL is constantly being highlighted in various aspects. Through this lecture, you will learn step by step and through this, you will jump to the intermediate level in one go.

It contains a comprehensive introduction to databases, the heart of information technology. We study the essence of databases and learn about MYSQL, the most representative relational database.

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.

I learned it the hard way, but I want you to learn it easily. I've discarded unnecessary theories and included only the core essentials of SQL. Build your SQL confidence quickly.

I'll show you everything about how to build servers for stateful services and how zero-downtime deployment works.

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 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 must-have subject for aspiring developers and those looking to get a job in big data!!

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.

Inflearn cumulative students over 30,000, Datarian's SQL basics course with rich online/offline teaching experience. Learn SQL basic theory and solve 10 SQL problems together.

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