Life Coding - SQLite

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

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 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 article introduces the relationship between Nodejs, a server-side JavaScript language, and a database, and explains how to create web applications using Nodejs and a database.

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 class was created to provide knowledge and experience about CSS while creating https://opentutorials.org (a daily coding site).

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

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

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 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 introduces the version control system git.

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.

mongoDB, NoSQL You hear a lot these days, but is it still an unfamiliar database? Aren't you using it like a relational database (RDS/SQL)? No matter how good the technology is, if it's not used correctly, it will have the opposite effect. That's why we often see cases of failure in using MongoDB. This lecture will teach you everything from basic concepts to practical know-how so that you can use MongoDB as MongoDB-like as possible.

I've created a 'MySQL Performance Optimization Beginner/Practical Course (SQL Tuning Edition)' that's easy to understand even for non-majors and can be immediately applied in real-world situations!

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

Make the most of relational database systems!

This is a practical backend course designed to cultivate the service planning and design thinking skills that developers need in the AI era.

"I know I need to study SQL, but I don't know where to start." When you open a database book, terms like normalization, B-Tree, and clusters... it's daunting right from the start. This course strips away all those complex theories and includes only what you truly need. Where are KakaoTalk messages stored? Why is the MapleStory trade window secure? Starting with everyday examples like these, you can grasp the entire flow of SQL in just 2 hours by coding along through installation → creating tables → CRUD → JOIN → and indexes.

Learn common components of global-scale services through popular papers, books, and articles.

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 beginner's guide to SQL coding! We'll teach you the secrets of writing, interpreting, and validating SQL.

Extract and utilize data through Oracle 18c and become a database expert!

This course teaches MS-SQL through baseball/company databases.

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.

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.

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