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

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

Through detailed lectures and hands-on practice on the core elements of SQL, we will provide you with a solid foundation to grow into a SQL analysis expert.

If you work with data, SQL is a fundamental skill you must know. In this course, we will learn SQL from a data analysis perspective, focusing on hands-on practice. The practice will be conducted in Google Colab using DuckDB.

Learn NoSQL technology for handling big data, one of the fundamental skills in full-stack and data science technologies used by modern startups. MongoDB is the easiest and fastest NoSQL technology to utilize. In this course, you will learn the basics of MongoDB in a short time and master the skills to handle and utilize MongoDB with Python.

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.

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.

I learned it the hard way, but I want you to learn it easily. I've discarded unnecessary theories and included only the core essentials of SQL. Build your SQL confidence quickly.

MongoDB is easy to learn because it uses JavaScript, which is familiar to web developers who haven't learned SQL. This course will explain concepts using everything from the most basic parts of MongoDB to practical applications.