Intermediate-Advanced SQL and Practical Data Analysis: 101 Problem Solutions

This is a course for learning the basic skills of the entire Python data analysis process for data analysis beginners. As an e-commerce planner and developer who utilizes data analysis techniques in actual work, I created this to help you easily learn the entire Python data analysis process and apply it immediately.

For those who want to learn data science, big data, and web crawling, (1) we summarize the most essential Python syntax in a short time, and (2) you'll become familiar with Python and crawling through practical crawling programming.

This is a newly designed course that allows you to gradually learn the mathematics, theory, PyTorch-based implementation, transfer learning, and GPT's core transformer needed to understand deep learning, based on the instructor's own failed experiences when first learning deep learning.

This course is Part 3 of the Full Stack lecture series, designed to help you solidly master the latest server technologies and Docker. The course is structured to enable you to practically incorporate Docker into your tech stack by meticulously testing Docker's various options, learning related technologies such as Linux that are necessary for understanding Docker, and building actual complex services.

Based on the instructor's own failed experiences when first learning machine learning, this is a newly designed course that differs from existing lectures, making it easy to understand machine learning and apply it to real-world problems

This is a course where you can learn FastAPI, which is easy and fast for modern full-stack and backend development, starting from backend concepts step by step to FastAPI core syntax and asynchronous database usage, organized with clean materials and projects.

Based on real-world experience developing web services in the field, this is a full-stack series course aimed at helping beginners develop web and app services at a level suitable for actual commercialization. As the first step (part1-1) toward this goal, this course provides detailed explanations of intermediate Python, backend implementation techniques using Flask, and essential web technologies (HTTP, REST API, MVC pattern, etc.) for full-scale development.

Through this course, you can learn SQL and database fundamentals, SQL syntax, database design for practical applications, database utilization through programming, and data analysis use cases.

This is a full-stack series course aimed at developing web and app services at a commercially viable level for beginners, based on real-world experience developing web services in the field. As Part 2 of this series, this course thoroughly covers the latest HTML5, CSS3, and vanilla JavaScript + ES6, considering responsiveness and compatibility among the various frontend technologies available.

This is Part 1 of a roadmap lecture that concisely organizes the essential computer science (CS knowledge) needed to excel in development and data, in a short period. This lecture has also been used as an in-house lecture at top domestic companies for several years. Based on 20 years of experience in actual practice, from system SW to web, app development, and data science, this lecture systematically yet easily organizes the essential core knowledge needed to excel in development and data.

This course is a comprehensive lecture where you can learn Flutter step by step, from the basics of dart programming to basic and intermediate Flutter features, even integrating with Firebase backend, all the way to actual projects!

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.

Through this course, you can learn SQL and database fundamentals, SQL syntax, database design for practical applications, database utilization through programming, and data analysis use cases.

Train SQL queries with 50 diverse problems, preparing for real analysis environments and coding tests. * If you're new to SQL, taking the SQL [Concepts Course] first will help you follow along easily.

From SQL basics to practical analysis! Learn powerful SQL skills to solve business problems by extracting, transforming, and analyzing data.

Sometimes, data processing is blocked and frustrating. If you are not a professional programmer or developer, learning unfamiliar fields such as Python or Java is not easy and there is not enough time. This is for those who only know Excel and SQL basics when it comes to frequently used things. This is the first part of the SQL query book that you can find and use when you need it.

The goal of this course is for you to efficiently learn SQL, apply it directly to practical work, and quickly develop data analysis skills. Let's grasp essential SQL fundamental concepts through solving Hackerrank problems, immediately apply them to real-world tasks, and truly enhance your skills.

What do you learn in the 'Business Information Visualization Certification' course? This certification course focuses on developing the ability to analyze data well, visualize it in an easy-to-understand way, and clearly and effectively communicate the information needed when making important decisions in a company or organization. Simply put, it's a course where you learn the skills to not just look at data, but to discover the hidden meanings within it and express them through pictures, tables, graphs, etc., so you can explain them well to others. Through this course, you will: Develop the ability to think strategically through data, build practical skills that can be immediately applied to actual work, and enhance your professional expertise and competitiveness. Through this lecture, develop the ability to connect business and data, and take one more step toward becoming an expert who understands and explains data.

Neo4J-based Knowledge Graph RAG System: Next-Generation Search Technology That Goes Beyond Simple Vector Search to Leverage Data Relationships Maximizing RAG Performance with the Power of Graph Databases!

This is a special lecture that can lay the theoretical foundation to simultaneously prepare for the Microsoft AZ-900 certification, and as the latest content reflecting the scope of questions as of May 2025, by providing content related to core data concepts, Azure's relational data, Azure's non-relational data, and Azure's analytical workloads in a form combining theory and practice, it can be utilized as a meaningful educational opportunity to not only obtain the certification but also take the first step towards becoming a data professional.

SQLD, where do I even start? This course is for those who feel completely lost - you'll meet a transformed version of yourself after completing it. SQLD All-in-One Pass!

SQLD Yellow Book 176 Problem-Solving Course for those who studied but can't solve problems. After completion, you'll go beyond passing to become an expert. SQLD All-in-One Pass!

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

This is a course aimed at obtaining the nationally recognized SQLD certification, and SQLD refers to developers who can write accurate SQL for manipulating and extracting data while developing application software based on database and data modeling knowledge.

Let's understand data analysis suitable for advanced retail business and learn how to utilize tools utilized in the industry!