Introduction to Databases & SQL from a Senior Backend Developer

Learn how to model data in a distributed database environment.

This course is a master class that systematically covers the fundamental principles and practical applications of MongoDB. Starting with core MongoDB concepts, you will systematically learn essential topics for practical work, such as database design, CRUD operations, indexing, aggregation pipelines, performance optimization, transactions, and security. It explains topics step-by-step so even beginners can understand, and you can deeply learn the working principles of MongoDB through exercises and examples. This is the best introductory and practical course for developers who want to build strong MongoDB skills for practical work.

I have summarized the essential SQL SELECT statements and basic usage of Google Sheets that I learned while working as an analyst at a service company.

This is an Oracle course, one of the top 3 databases. Even if you are learning databases for the first time, you can easily learn.

Automatically generate executable SQL files using JDBC (DatabaseMetaData, ResultSetMetaData). Install the e-Government Standard Framework 3.10.0 development environment. Install local DB (mariadb-10.6.4-winx64.zip).

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

Make the most of relational database systems!

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

Technology should also start with interest. I have prepared a story about a person who analyzes MBTI of his coworkers. I hope that those who have been daunted by SQL will start studying it with enjoyment.

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

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

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

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

From understanding SQL to using actual functions, Complete preparation for SQLD certification with the latest past exam questions!

Learn how modern data teams leverage dbt. Build maintainable analytics models and validated data pipelines hands-on. Master core concepts of analytics engineering with a practical focus. This course is for those who want to take their data career to the next level 🚀

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.