Intermediate-Advanced SQL and 101 Practical Data Analysis Problem Solutions

For those looking to learn Data Science, Big Data, and Crawling, (1) we will summarize the most essential Python core syntax in a short time, and (2) you will become familiar with Python and crawling through practical crawling programming.

Learn NoSQL technology, which can handle Big Data, one of the fundamental technologies in full-stack and data science utilized by modern startups. MongoDB is the easiest and quickest technology to utilize among NoSQL databases. In this lecture, you will learn the basics of MongoDB in a short time, and also acquire the skills to manipulate and utilize MongoDB with Python.

This newly designed course, drawing from the instructor's initial deep learning failures, helps you progressively learn deep learning essentials: math, theory, PyTorch-based implementation, transfer learning, and GPT's core Transformer.

This course offers an easy and fast way to learn FastAPI, the latest full-stack and backend framework, along with cleanly organized materials and projects that cover backend concepts, core FastAPI syntax, and asynchronous database utilization in an easy, step-by-step manner.

This course aims to teach data analysis beginners fundamental skills for the entire Python data analysis workflow. As an e-commerce planner and developer leveraging real-world data analysis, I crafted this for easy acquisition and immediate application of the full Python data analysis process.

Unlike existing lectures, this course has been newly designed based on the instructor's initial failures in learning machine learning, enabling easy understanding and application to real-world problems.

This course, Part3 of the Full-stack Course Series, solidly teaches the latest server and Docker technologies. It's structured to practically integrate Docker into your tech stack, meticulously testing its options, learning necessary related tech like Linux, and building complex services.

Through this lecture, you can learn about understanding SQL and databases, SQL syntax, database design for practical application, database utilization through programming, and even data analysis application cases.

This is a full-stack lecture series based on real-world web service development experience, aiming to help beginners develop web and app services to a level suitable for actual commercialization. As Part 2 of this series, this lecture thoroughly and solidly covers the latest HTML5, CSS3, vanilla Javascript + ES6, considering responsiveness and compatibility within the diverse landscape of frontend technologies.

Based on real-world web service development experience, this full-stack series targets beginners, aiming to develop web and app services capable of actual commercialization. As the initial step (part1-1), this lecture details intermediate Python for full-scale development, backend implementation with flask, and essential web technologies (e.g., HTTP, RestAPI, MVC patterns).

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 comprehensive course allows step-by-step Flutter learning, from Dart programming basics to Flutter's basic/intermediate features, and integrating backend Firebase for real projects.

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

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

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.

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.

Through this lecture, you can learn about understanding SQL and databases, SQL syntax, database design for practical application, database utilization through programming, and even data analysis application cases.

Learn NoSQL technology, which can handle Big Data, one of the fundamental technologies in full-stack and data science utilized by modern startups. MongoDB is the easiest and quickest technology to utilize among NoSQL databases. In this lecture, you will learn the basics of MongoDB in a short time, and also acquire the skills to manipulate and utilize MongoDB with Python.

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.

SQLD Yellow Book 176 Problem Solving Lecture for You Who Studied but Cannot Solve Problems. After Completing the Course, You Will Become an Expert Beyond Passing. SQLD All-in-One Pass!

For those who feel overwhelmed preparing for the SQLD exam, this is a comprehensive course that analyzes the entire Norang-i scope, organizes necessary theory, conducts practice-focused classes, and solves all problems systematically. With short, concise clips and topic-based segmented structure, you can build skills that work directly in the exam room.

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.

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!

SQLD, where should I start? This course is for you who feel so overwhelmed; you'll meet a changed you after completing it. SQLD All-in-One Pass!

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