Life Coding - SQLite

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.

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

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

This class introduces the version control system git.

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 is a lecture on OAuth provided by Living Coding, where you can learn technologies for API interoperability.

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

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.

This is a Redux course provided by Life Coding. It is a class for those who are intermediate or higher in JavaScript, and it teaches how to create more complex applications with simpler code using Redux.

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

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

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 web applications using Node.js and MySQL.

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

This lesson will teach you how to assign a domain name to your server computer.

The technical term for a router is router. A router is the core of the core that makes the Internet work. If you understand routers, you will feel that your perspective on the Internet has been greatly expanded.

This lesson introduces how to use Git through commands.

This class will teach you what effects you can get when you introduce Python into a website created in WEB1.

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

Make the most of relational database systems!

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.

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.

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.

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.

Not only developers, but also planners and data analysts learn databases step-by-step, starting from the basics of SQL.

A beginner's guide to SQL coding! We'll teach you the secrets of writing, interpreting, and validating SQL.

This course focuses on building the real skills needed in actual development work. The goal is not simply to learn how to write code well, but to experience how to work well as a developer. The examples are based on the commerce domain, covering cases frequently encountered in real-world work environments, and are provided in SpringBoot & Kotlin. However, it's a course where anyone can contemplate and experience real-world development through thought-provoking content, without being dependent on any specific language or framework. Based on the practical perspective of a senior developer and former director at Toss Payments who led a large-scale payment service organization, the course is designed to help you learn the thought processes and design decisions used in actual work environments.

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

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.

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.

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.