Database Basics (SQL)

This course is not focused on C# grammar. It focuses on understanding and creating classes. It covers basic grammar, but it also includes a lot of practical program writing tips because it goes through many examples.

This course is an easy-to-understand explanation of database design theory, focusing on practical exercises. Most people who have experienced it through books, etc. have probably felt that database theory was difficult and given up. I did the same. However, if you know it, you will find that it is an easy and very interesting field. In this course, the design content is organized so that you can understand it just by looking at it.

This is the second lecture following the Database Design Fundamentals course. This is a practical course that focuses on real-world projects from start to finish. After understanding all the lecture content, you will be able to freely design databases.

This course does not teach the grammar of C#. It simply uses C# as a tool for designing object-oriented programs. This course covers in depth the essential content that intermediate and higher level programmers need to know, as well as the content that is essential to developing programs that are linked to databases.

This course is mainly about ADO.NET and will be practiced with WinForms programs using the C# language. In addition, it will explain various fields such as database design, SQL writing, stored procedure writing, and libraries and transactions created with ADO.NET through practical programming through sample projects.

This course is for those who are learning database programming for the first time or those who have some knowledge but want to learn systematically. From concepts to practical exercises, you will master the database query language by organizing examples of types that frequently occur in real life.

This course is for those who are learning programming for the first time. The lectures are not boring at all. Most of the lectures proceed through examples after a simple explanation.

This course covers everything from building a database to creating tables and manipulating and changing data within the database using various SQL queries.

This is a course to learn MariaDB, a commercially available database. Even if you are learning about databases for the first time, you can learn it easily.

Make the most of relational database systems!

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.

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

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 is a course on creating a practical Unity game with a database. You can learn through lectures about aspects that are difficult to encounter.

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.

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.

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

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.

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.