Large-Scale Systems Design Part 1

Learn and create Git actions yourself, the de facto standard for version control tools!

You can learn about the core functions of MySQL and how to effectively use them in your work. You can also gain a new understanding of important parts that you have been using for a long time and have overlooked, and gain in-depth database knowledge.

Learn database design systematically through three stages: conceptual, logical, and physical, and strengthen your capabilities with a practical shopping mall project. Acquire real-world expertise through modern design techniques and the latest trends.

From building a database to creating tables, you can manipulate and change data within the database using various SQL queries.

Learn how to model data in a distributed database environment.

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

Have you ever wondered why we use these techniques while watching the Clone Coding lecture? Let me give you a big picture of backend development!

Beyond basics like API design, CRUD implementation, and JWT authentication, all the way to backend architecture design! This is an introductory system design course to help you build 'your own backend architecture' that you can confidently discuss in interviews.

✅ Out of the entire series (1) ~ (7), (5) operating system, user interface, database ✅ CS101 series lectures - From basic computer theory to the latest practical examples - Provides a wide range of basic knowledge

I learned it the hard way, so you can learn it the easy way I've discarded unnecessary theory and included only the SQL essentials. Quickly build your SQL confidence.

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.

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

Along with reading, writing, and arithmetic, computational thinking is an essential skill that everyone living in the AI era must possess. Simply put, computational thinking can be defined as thinking like a programmer or a computer scientist. This course replicates an actual full-semester university lecture and covers essential content for those new to programming or beginners planning to major in computer science. Furthermore, through this course, non-computer science majors or those with a background in the humanities can develop the ability to communicate easily with professional programmers. Even in an age where learning prompts for "AI vibe coding" is necessary, computational thinking will help you develop the ability to instruct AI more accurately and effectively.

I will transform the Engineer Information Processing written exam (Subjects 1–5) from a "test you solve by memorizing" into a "test where you connect clarified points directly to your score." This is an ultra-compressed lecture designed to help you grasp the entire flow within 3 days. It extracts only the core concepts repeated in past exams, structured to be understood even if viewed right before the test. The course is designed for short-term success by clearly distinguishing between frequently confusing concepts, trap points in multiple-choice options, and what needs to be memorized versus what only needs to be understood. "I'm short on time, but the scope is too broad." "I feel like I know the material when reading the book, but I keep getting the questions wrong." This lecture is for students facing these exact challenges.

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.

Through this course, you can acquire the concepts and practices of Information Strategic Planning.

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.

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.

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.

You can solve design problems by writing code in a formatted way. You can understand code or patterns written by other programmers.

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