인프런 - 라이프타임 커리어 플랫폼

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.

In this lecture, you will learn how to create an ERD. You will learn database design. (The only big data design lecture in Korea)

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

This is a SQLite lecture provided by Living Coding (Open Tutorials), which will help you get started with the relational database SQLite.

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.

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 the easy and fun story of SQL Server operations from a Microsoft Certified Trainer! We explain core operational technologies that you can learn and use right away, and that are truly needed in the field, step by step so that even beginners can easily understand.

Easy and fun SQL stories learned from professional instructors! Lectures are conducted systematically and step-by-step for beginners. We offer opportunities to learn with sufficient repetition through a 3-step learning process.

You can learn how to solve concurrency problems, how to tune procedures, and how to speed up query execution. You can also learn various know-hows such as common mistakes and problems that occur in practice. (The only refactoring lecture in the world)

This is an Oracle DBMS SQL course for beginners.

It contains a comprehensive introduction to databases, the heart of information technology. We study the essence of databases and learn about MYSQL, the most representative relational database.

We will learn about cases where companies such as Line, Google, Carrot, and Kakao actually improved MySQL performance. Let's go beyond simple performance optimization guides and understand the internal workings of MySQL and learn how to use it efficiently.

Learn practical strategies for designing efficient and scalable database structures that accurately reflect the complex requirements of real-world scenarios.

Database concepts most frequently encountered in interviews and practical work, This introductory course is organized flow- and diagram-centrically. From SQL basic syntax to normalization, transactions, indexes, sharding/partitioning, and security, It explains seemingly complex DB concepts, structurally linking them with real-world examples. Finally, an interview practice chapter is included, So you can confidently answer questions like "What is a transaction?" and "When are indexes used?".

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 covers everything from building a database to creating tables and manipulating and changing data within the database using various SQL queries.

From building a database to creating tables, you can manipulate and change 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.

Based on Oracle 21C, from concept to practice, the easiest way to learn SQL for the first time! Directly taught by the author of EGIS Publishing's 《Do it! SQL for Beginners with Oracle》! We'll teach non-majors and beginners step-by-step.

This is a course on making practical Unity games with a database. Challenging areas can be covered in this course.