Data Analysis SQL Fundamentals

The first step to becoming a SQL analysis expert! 💪
Build your fundamentals with detailed lectures and practical training.

Accessing data
The most basic technology, SQL.

Most corporate data is stored in RDBMS, and SQL is the most basic technology for accessing data. Therefore, the core of corporate data analysis starts with utilizing SQL.

However, it is difficult to find a data analyst who can freely use SQL for corporate data analysis. If you approach SQL only from the grammar and functional aspects when learning it, you will be frustrated when you encounter analysis requirements that include slightly difficult data processing and changes to the set level in real life.

Analytical SQL ,
If you want to do it right?

To be good at analytical SQL, you must have the ability to freely process and create original data into the level of the desired set. To do this, you must develop the ability to write SQL while understanding various types of joins, Group by, aggregate functions, and the mechanism by which Analytic SQL works. And you must be able to acquire this through a lot of practice.

Data Analysis SQL Fundamentals Course is ✅

Data Analysis SQL Fundamentals is Part 1 of a series of lectures designed to help you grow into a SQL analysis expert. This lecture is structured so that you can acquire the core contents and mechanisms of JOIN, Group by, aggregate functions, and Analytic SQL through detailed lectures and practice.

Follow-up series: SQL data analysis through various cases

In Part 2 of the lecture, 'SQL Data Analysis through Various Cases', we will perform various types of sales analysis, order analysis, website access and usage analysis, and website performance analysis using SQL based on Google Analytics-type data sets. We will meet you with a rich set of analysis topics, such as session and DAU/WAU/MAU, traffic source analysis by device/ad channel, landing page analysis, bounce rate and exit rate aggregation, RFM analysis, retention rate, and funnel analysis.

A key weapon for real-world analysis ,
Analytic SQL!

Analytic SQL, also known as Window Function, has played a major role in making SQL the center of corporate data analysis with its convenient and flexible analysis usability and advanced statistical functions. In this lecture, we will explain almost all of the Analytic SQL frequently used in practice .

In particular, we have prepared various visual materials to help you understand Analytic SQL more easily. We will also help you master Analytic SQL through considerations when applying it and various types of practice SQL.

Features of this course ✨

Rich description of core SQL operation mechanisms

We provide a detailed explanation of how different types of joins work, as well as how Group by and Analytic SQL work.

A variety of practice problems combining core understanding and advanced content

The main SQL exercises consist of live coding, and various practice problems are prepared so that you can learn in-depth content while understanding the core.

Analytic SQL - I can't explain it in more detail than this

We will explain in detail how the main components of Analytic SQL, Partition, Sort, and Window, work with visual aids. We will also inform you of errors that are easily overlooked when using Analytic SQL and how to resolve them.

Bonus! 100 pages of lecture material provided

We provide a 100-page lecture textbook, practice SQL code, and datasets so that you can fully understand the content without difficulty even on your own.

Practice environment
Check it out 💻

PostgreSQL is used as the practice environment DBMS and DBeaver is used as the SQL editor.

PostgreSQL is an open source DBMS that is provided free of charge and has stability, performance, and, above all, rich SQL support functions. It satisfies the Ansi SQL standard and has various SQL functions and analytical functions, so it is widely used not only online but also as an analytical DBMS.

DBeaver Community Edition is free, but it has better features, faster performance, and stability than most commercial SQL Editors. DBeaver supports various DBMSs such as PostgreSQL, MySQL, and Oracle.

Q&A 💡

Letters from knowledge sharers 💌