データベース中級

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 was created for those who find databases challenging, making it easy to understand concepts and build your skills through practice. This lecture covers database fundamentals and SQL language usage. For learning how to create databases, you can take the database design course. Since most program developers encounter databases in their work, I've made an effort to explain in detail how to approach databases from a programmer's perspective.

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

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.

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

Make the most of relational database systems!

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.

Secrets of people who are good at their jobs! How should I start with SQL? It covers everything from SQL installation and basic environment configuration to simple practical exercises that can be used in real life! You can also learn basic commands step by step through practical exercises.

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.

Real-time data processing is now essential, not optional! Learn to handle real-time streaming smartly with Apache Flink. Batch? Streaming? Even complex concepts can be understood easily and quickly. Hands-on practice configuration where you'll get the hang of it by directly working with Kafka and DB integration! In a world driven by data, start first with Flink.

If you want to be recognized as a machine learning expert based on large-scale data, from understanding the core framework of Spark machine learning, to SQL-based data processing through difficult practical problems, to data analysis through business domain analysis, and to the ability to implement optimized machine learning models, please join this course.

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

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

Uncover true value in the age of data! 📊 Designing applications focused on data has now become essential. Develop the insight and skills your company wants with the latest trends and practical case studies. Start now with efficient data processing and design secrets! Your next step, leap into the data-driven world!

We have gathered Apache Kafka application programming knowledge used in real environments! We will take a look at and practice various functions of Apache Kafka that are key to building data pipelines.

This is a course on creating practical Unity games with databases. You can work through the difficult-to-approach parts through the lectures.

This lecture comprehensively organizes the content that would be good for those who want to get a job as a new Spring Java backend developer, especially those who are about to have an interview.

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.

Through this course, you can learn about Docker and set up a CI environment.