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

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 course allows you to learn the major trends in web development by following the overall web technologies required to complete a website.

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

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 course on basic internet knowledge taught by Life Coding.

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

This lesson introduces how to use Git through commands.

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

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

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

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.

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

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 class will teach you what effects you can get when you introduce Python into a website created in WEB1.

This is a React-related lecture provided by Life Coding. You will learn how to write components in class and function style in React and examine the differences.

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

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 lecture is a lecture on database basics in the [Web Development Full Stack Course] lecture series for training full-stack web developers. This lecture is a process of understanding database design while analyzing Netflix and Carrot Market. It is a basic lecture where you can learn basic database design principles and SQL.

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

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 practical backend course designed to cultivate the service planning and design thinking skills that developers need in the AI era.

Introduction to SQL Data Analysis! Quick and easy to understand with practical problem solving!

I have summarized the essential SQL SELECT statements and basic usage of Google Sheets that I learned while working as an analyst at a service company.

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.

We will inform you about the platform mass adoption method using AWS (S3, CloudFront) and MySQL (Geospatial Query).

This course covers how to set up multi-module projects from scratch using Kotlin and Spring Boot. It proceeds with a hands-on approach, covering everything from the basic concepts of modularization to Gradle configuration, managing dependencies between modules, and actual application development. If you are a beginner or intermediate developer looking to learn the fundamentals and practical application of multi-modules, please refer to this course.

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

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.

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

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.

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.

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.