강의

멘토링

커뮤니티

BEST
Data Science

/

Data Engineering

SQL data analysis learned through various cases

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

(5.0) 44 reviews

1,580 learners

  • dooleyz3525
sql
데이터 엔지니어링
postgresql
데이터분석
데이터베이스
SQL
PostgreSQL
DBMS/RDBMS
Data Engineering
data-analysis

Reviews from Early Learners

What you will gain after the course

  • Practical service analysis cases such as sales, order, and web log analysis

  • Understand key metrics for analysis such as RFM, DAU/MAU, churn rate, retention rate, and conversion funnel, and implement them in SQL.

  • Utilization and practical application techniques of Join, Group by, and Window functions

  • Ability to freely derive desired analysis results through SQL

  • Strengthening core SQL data analysis capabilities based on practical data similar to actual work

  • Chart visualization of analysis data

Learn SQL with practical data analysis!
You can become a leading data expert 🏃‍♂️

SQL skills + practical analysis skills all in one!

The demand for data professionals with both exceptional SQL skills and a deep understanding of company operations and services is growing. Therefore, for data analysts, data scientists, analytics developers, and data engineers , possessing superior SQL skills and the ability to derive and support analytical results that can improve products and services is a crucial competitive advantage.

The course 'Learn SQL Data Analysis through Various Case Studies' is ✅

SQL skills should be developed through solving challenging problems in real-world situations. However, the SQL I've encountered in lectures and books so far has been quite different from the SQL used in real-world situations.

This course is filled with theoretical and practical SQL queries used in real-world analytics , something you won't find in existing lectures or books. Furthermore, it covers domain-specific topics like sales and order analysis, as well as various analytical metrics utilized in Google Analytics and growth hacking, all implemented using sophisticated SQL. This approach aims to simultaneously improve both analytical and SQL skills .


After taking this course 📜

By the end of this course, which implements many analytical indicators used in actual work using SQL, you will become a SQL expert who can freely derive the desired analysis results.

Additionally, the various analysis cases covered in this course will help you understand how to design metrics and conduct analyses to drive business and service growth.

Please check the player course !

Unfortunately, this course is intended for those who have taken the course ' Data Analysis SQL Fundamentals ' .

If you have practical experience with SQL but have not taken the Data Analysis SQL Fundamentals course, please review the course curriculum and be sure to refer to the ' Course Introduction ' video in Section 0 and the ' Course Selection Guide for Those Who Have Not Taken Data Analysis SQL Fundamentals ' video to determine if the course is suitable for your skills before deciding to take the course.

We would like to inform you in advance that you may have difficulty understanding the contents of this lecture if you have not taken ' Data Analysis SQL Fundamentals '.


Features of this course ✨

Explanation of different types of key analytical indicators +
A hands-on exercise to implement analytical metrics using SQL queries.

We'll cover key metrics for various types of sales analysis, cross-selling, order analysis like RFM, and more, as well as DAU/WAU/MAU, stickiness, channel analysis, entry/exit page analysis, bounce rate, retention rate, and conversion funnel analysis, all of which are well-utilized in Google Analytics and growth hacking.

Difficult SQL exercises based on real-world datasets:
We'll help you improve your SQL skills to the max!

Instead of toy data, you'll implement challenging SQL on a Google Analytics data set for practice. To actively improve implementation skills, most of the course is structured around live coding . By the end of the course, you'll become a SQL expert, capable of freely deriving the desired analysis results.

Detailed and thorough explanation of complex logic

To make complex and lengthy SQL queries easier to understand, we'll break down each processing logic step by step, using detailed diagrams and charts. Through this course, you'll gain the ability to understand and apply even the most complex SQL queries step by step.

Practice implementing chart visualizations to aid intuitive understanding

You can visualize the analyzed SQL results in charts to intuitively understand the analysis results. You'll also learn how to visualize the analysis results using charts to communicate them more effectively. (The visualization code is implemented using Python's Plotly.)


Practice environment
Check it out 💻

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

PostgreSQL is a free, open-source DBMS that boasts stability, performance, and, most importantly, rich SQL support. It complies with the ANSI SQL standard and offers a wide range of SQL functions and analytical capabilities, making it widely used not only online but also as an analytical DBMS.

DBeaver Community Edition is free, but it offers superior features, faster performance, and greater stability than most commercial SQL editors. DBeaver supports various DBMSs, including PostgreSQL, MySQL, and Oracle.

Additionally, I use Jupyter Notebook and Plotly for chart visualization.

Although the video was created based on a Windows environment, it can also be performed without any problems in a Mac environment.

📢 Instructions for downloading lecture materials

  • The lecture materials (PDF), practice SQL code, and data can be downloaded from the [ Lecture Materials and Practice Data and Practice Materials ] class in Section 0: Lecture Introduction and Practice Environment Configuration.

Recommended for
these people

Who is this course right for?

  • People who perform analysis tasks using SQL

  • Those who want to experience various practical data analysis cases

  • Anyone who wants to greatly improve their SQL skills

  • Data Scientists and Data Analysts Leveraging SQL

  • Data engineers who need to perform data processing/extraction/refinement based on SQL to create tables for analysis or marts

Need to know before starting?

  • Data Analysis SQL Fundamentals lecture understanding required

Hello
This is

26,945

Learners

1,369

Reviews

4,011

Answers

4.9

Rating

14

Courses

(전) 엔코아 컨설팅

(전) 한국 오라클

AI 프리랜서 컨설턴트

파이썬 머신러닝 완벽 가이드 저자

Curriculum

All

91 lectures ∙ (15hr 10min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

44 reviews

5.0

44 reviews

  • john님의 프로필 이미지
    john

    Reviews 27

    Average Rating 4.9

    5

    100% enrolled

    尊敬します。ありがとうございます。大好きです。私のランソンシューティングゲームです。

    • dooleyz3525
      Instructor

      良い評価でしばらく気分が良くなりました。ありがとうございます。 。

  • jeongjiu1733356님의 프로필 이미지
    jeongjiu1733356

    Reviews 1

    Average Rating 5.0

    5

    100% enrolled

    本当に最高のSQLデータ分析の講義の一つと断言できそうです。 基本的なSQL文法を学びましたが、何か曖昧なSQL実力を様々な実践事例を通じて確実に向上させたい方に強力強力おすすめです。 講師様のすばらしい講義力と非常に充実した講義の内容のおかげでSQLについて新たに目を覚ましたような気持ちであり、講義を聞きながら実習も着実に並行していれば無条件実力が向上するしかないほどクオリティの高い講義です。 また、講義の中で気になる部分についても親切にお答えいただき、倍増して良かったです。本当におすすめです。ありがとうございます。

    • dooleyz3525
      Instructor

      SQLの強力さに新たに目を覚ましたなんて私も大きなやりがいを感じます。すばらしい受講に感謝します。

  • coolk14431님의 프로필 이미지
    coolk14431

    Reviews 5

    Average Rating 5.0

    5

    46% enrolled

    講義本当にお得ですね たくさん学んでいきます ありがとうございます!!!

    • kangchulho12348528님의 프로필 이미지
      kangchulho12348528

      Reviews 2

      Average Rating 5.0

      5

      20% enrolled

      実践的な事例がたっぷり詰まった素晴らしいSQL講義です。 いつも実戦分析経験がなく、実力向上に困難が多かったのですが、本講義が大きな助けとなりました。

      • jason님의 프로필 이미지
        jason

        Reviews 30

        Average Rating 5.0

        5

        31% enrolled

        昨年この時、データエンジニアの新入社に入社 講師様のSQLファンデーション+データ分析講義を両方見たいという覇気で同時に購入した一人です '私はこちらの分野に才能がないのか。と言い、SQLファンデーションだけを復習し、イリチュイとジョリチで1年が過ぎて少し慣れてきたか昨日から講師のsqlデータ分析講義を始めました 移動平均だから加重平均だから… 無制限だから本当に嬉しいです。.ㅎㅎ 他のデータ分析SQLの講義は見られませんでしたが、その講義も最も簡単に説明してくれたと信じています。 ゆっくりと着実に頑張ります。 一つの願いなら 売上のようなビジネス会計、統計すべてが見慣れているので、BIアナリストが望む方向にETLしてデータを積み重ねるにも大きすぎる困難がありますねㅎㅎ 誰でも見ることができるsqlファンデーションレベルほどのように会計、統計学、工学数学などが出てくればとても幸せそうです こんな質の良い講義を低い値にご提供いただきありがとうございますいつも応援します!

        • dooleyz3525
          Instructor

          ああ、長文の受講坪以上ありがとうございます。着実にこの講義の練習を繰り返し続けてみると、どこでも認められるSQL分析の専門家になることができます。

      $68.20

      dooleyz3525's other courses

      Check out other courses by the instructor!

      Similar courses

      Explore other courses in the same field!