[Practice Makes Perfect] Intermediate SQL for Data Analysis

Inflearn cumulative students over 30,000, Datarian's SQL basics course with rich online/offline teaching experience. Learn SQL basic theory and solve 10 SQL problems together.

No developers needed! No coding knowledge required. I'll show you how anyone can easily install GA4 with just a few clicks.

Have you switched to GA4 but feel lost on how to use it? By learning three principles for effective data viewing and practical GA4 examples, you can immediately apply them to your work starting tomorrow!

Inflearn cumulative students of over 30,000, Datarian's advanced SQL course with extensive online/offline teaching experience. Learn advanced SQL theory and solve 25 practice problems together.

We will reveal the actual data analysis portfolio of successful job seekers and the portfolio-related questions they received during interviews!

If you were curious about what A/B testing is and how other companies experiment, attend this November seminar!

I have worked at seven different small startups that had neither data analysts nor user researchers, and I've stumbled through various trials and errors. I will share the many realistic challenges a UX designer can face, along with the deep insights I gained while navigating through those difficulties.

In the cookie-less era, how will marketing change? If you don't know how to start marketing performance analysis, attend the November seminar.

If you are worried about where to start and where to start studying because you need to take a SQL coding test to become a data analyst, then come to this seminar!

Where and how should you start preparing to get a job as a data analyst? From data analysis project know-how to the job search experience of senior data analysts! You can hear it all at this February seminar.

How can data be leveraged in side projects? Hear the stories of 'Geumim' and 'Skull' at this seminar!

Solve 25 SQL problems of varying difficulty levels. This is a commentary lecture for Advent of SQL 2025, and upon completing the course, you can finish the advent calendar and earn a badge.

Are you having trouble persuading others with data? Learn how to present your data simply and powerfully using Google Sheets!

Are you worried about whether you can become a data analyst as a non-major? Hear from a non-major senior analyst!

If you are thinking about using data in your work, get some great tips from this seminar.

If you are curious about the various possibilities and future prospects of generative AI, including ChatGPT and Clova X, that can be used for data analysis, come to our seminar this May!

Were you frustrated because you didn't know what a data analyst does? Listen to the stories of three data analysts working in different domains!

We share the case of Datalian, founded by 4 data analysts, on how they analyze data, configure dashboards, and utilize data for action!

Are you wondering how to write a resume or prepare for an interview to get a data analyst job? You can learn everything about data analyst hiring at this seminar!

Don't miss out on Datarian's April seminar, packed with everything from profitable sales analysis to cohort analysis frameworks.

"Why does my automated trading collapse in a bear market?" I have also deeply pondered this same question. Most automated trading logics on the market seem to generate profits during a bull market, but they lose their ability to respond the moment the market sentiment changes. To solve this problem, I have combined the know-how I researched myself over the past two years with the latest AI technology. In this course, you will learn how to directly design a 'Transformer-based deep learning model' that simultaneously reads macroeconomic trends and individual stock flows, and how to automatically train and deploy it in a free GPU environment. In particular, we will introduce sophisticated data normalization techniques at the hedge fund level to build an 'Intelligent Comprehensive Scoring System' that goes beyond simple indicators to incorporate news sentiment. To this, we add an 'AI Safety Gate' that implants the insight of a trader with 20 years of experience on Wall Street, adding a final layer of confidence from a human trader's perspective right before a purchase. Beyond simple buying and selling functions, you will directly implement the entire process of an institutional-grade algorithmic system by adding dynamic take-profit and stop-loss logic, eight self-recovery mechanisms, and real-time Slack reports.

"The deep learning code runs, but why do the formulas in papers look so unfamiliar?" As you study AI, you eventually hit a wall of mathematical formulas. If you trace the source of that wall, it usually leads back to not having a solid foundation in the most basic mathematical language. Starting with the language of sets, this course covers core concepts across 18 lectures, including equations, functions, sequences, exponents/logarithms, and trigonometric functions. We don't make you memorize formulas. While we briefly touch upon how these connect to the context of AI, the primary goal of this course is one thing — to build an unshakable foundation for when you later learn linear algebra, calculus, and probability/statistics. As the first part of the Suminjeongeum series, this course will provide you with the common language needed to properly digest the remaining three parts.

Build your own powerful stock price analysis model that analyzes over 40 types of economic indicators and stock price data using AI to predict not only the S&P 500 and QQQ ETFs but also individual stocks!

We guide non-majors and beginners to quickly obtain the Big Data Analysis Certification (Practical Exam)! Keep the theory light and the practice solid—focusing on core points that are guaranteed to appear on the exam through past questions, without the need for complex background knowledge.

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!

Learn the fundamentals of SQL and databases essential for practical work. Not only developers, but also planners and data analysts can learn SQL in depth.

Prepare perfectly for the Goorm environment—the biggest challenge of the Big Data Analysis Certification practical exam—on the practice platform provided by Algorun. Practice past exam questions for Task Types 1, 2, and 3 repeatedly in a setting identical to the actual exam environment to gain an intuitive feel for the test rather than just memorizing code. This is a practice-oriented lecture designed to train your hands to move automatically in an environment that differs from Colab or Jupyter.

Solve the challenges you inevitably face in real-world design—such as common codes, category hierarchies, history tracking, soft deletes, statistics, dynamic design, and JSON utilization—with 9 core patterns. This is not just simple theory; it contains practical know-how and selection criteria for various scenarios, proven across numerous projects. Now, become a true design expert who can confidently handle any requirement that comes your way.

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!

"While following trends is important, unwavering fundamentals are what build true skill." This lecture is a beginner course designed to help you understand the flow of data science and properly master the most practical techniques.

Learn how to design and handle large-scale data architectures that process hundreds of billions of records using only pure SQL and core MySQL features, alongside a Toss developer who handles hundreds of billions of financial traffic transactions and a developer who started as a non-major and is now developing platforms in Pangyo.

You will systematically learn database design through three stages—conceptual, logical, and physical—and strengthen your skills through a practical shopping mall project. Gain real-world know-how through modern design techniques and the latest trends.

"From environment setup to practical business projects, a data science journey to find revenue answers through data (39 lectures in total)." Go beyond simply learning how to use libraries and learn how to cook real-world e-commerce data through the data science process. Starting from development environment setup and Numpy/Pandas basics to data preprocessing, statistical analysis, visualization, and business scenario-based RFM segmentation and hypothesis testing! Systematically master the core competencies of a data scientist through practical projects.

"From the basics to 7 domain projects, completing the A to Z of deep learning (41 lectures in total)." Go beyond simply calling models and learn how to build clean, efficient deep learning pipelines using PyTorch Lightning, the current industry trend. Grow into a confident AI engineer capable of handling any data by directly implementing 7 projects, ranging from stock price prediction to generative AI, medical imaging, and sound analysis.

Doing it carelessly is worse than not doing it at all. You'll just waste time! From now on, let's solve it thoroughly and perfectly together!

This is a course for PMs who want to utilize data. It covers the entire process of using data in a PM role, capturing the full workflow from your first day at a new job to the beginning and end of a project. It is an introductory data course designed to build your thinking power, covering everything from data-driven and logical thinking to metric definition, log design, experiment design, and building a data culture. Although it was created for PMs, the content is also highly beneficial for data analysts (in fact, many analysts have already taken this course). Additionally, many professionals in marketing, design, and business planning roles are also taking the course.

The "Big Data Analysis Certification Squid Game Challenge," directly managed by After-Work Hobbies—which has boasted high pass rates every session—is back. The goal of this game is to consistently complete daily missions and finish the course. If studying alone was difficult, now you can finish together and sharpen your practical skills!

Not only developers, but also planners and data analysts learn databases step-by-step, starting from the basics of SQL.

Revolutionize your stock investing with AI! In this course, you will directly build a functional AI automated trading system targeting the top 25 Nasdaq stocks. We provide a special opportunity to gain experience and know-how through mock trading using the Korea Investment & Securities API, and then transition to AI automated trading with a real account. Even stock market beginners will have no problem. We explain basic stock concepts and the reasons why you should invest in US stocks in an easy-to-understand way, while providing all source codes and even remote support. From now on, investing is essential for the next 60 years of our lives. Create your own AI investment partner to join you on this journey!

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.