Analysis and Visualization of 5 Million Korean Apartment Transaction Data with PostgreSQL

Learn how to analyze 5 million records of Korean apartment transaction data using PostgreSQL. It covers the process of deriving meaningful insights through data cleaning, transformation, and various SQL queries.

(4.4) 12 reviews

125 learners

Level Basic

Course period Unlimited

PostgreSQL
PostgreSQL
DBMS/RDBMS
DBMS/RDBMS
Data Engineering
Data Engineering
data-analysis
data-analysis
data-cleaning
data-cleaning
PostgreSQL
PostgreSQL
DBMS/RDBMS
DBMS/RDBMS
Data Engineering
Data Engineering
data-analysis
data-analysis
data-cleaning
data-cleaning

Reviews from Early Learners

4.4

5.0

Jang Jaehoon

6% enrolled

Thank you for the good lecture!

5.0

hakjuknu

31% enrolled

great!

5.0

태준

17% enrolled

I'm a complete beginner at SQL, but since I've used Power Query in Excel a lot, it's not too difficult.

What you will gain after the course

  • Data Analysis

  • Data analysis using PostgreSQL

  • Data Analysis using SQL

"Analysis and Visualization of 5 Million Korean Apartment Transaction Data with PostgreSQL"

In this course, you will learn how to analyze and visualize 5 million South Korean apartment transaction records using PostgreSQL.
From creating databases and tables to data cleaning, writing queries, and deriving visualization insights using the Python Dash library, you will acquire skills that can be immediately applied to real-world tasks.
This course is designed for anyone interested in data analysis and visualization. 😀

Recommended for these people 😀

Data analysis beginners

Beginners interested in database management and large-scale data analysis using PostgreSQL.

SQL Users

Deriving and analyzing data using various SQL queries and functions through Korean apartment transaction data.

Data Visualization Beginners

Data visualization beginners who want to effectively visualize analysis results to derive insights.

After completing the course,

  • Acquire the ability to manage large-scale databases and write queries using PostgreSQL.

  • Capable of effectively expressing and creating analysis results through visualization tools.

  • Deriving meaningful insights by analyzing large-scale data.

  • Learning content related to PostgreSQL, DBMS/RDBMS, data-analysis, data-cleaning, and data engineering.

Features of this course

실무중심의 데이터 분석

Practical Data Analysis

Through the process of analyzing 5 million actual South Korean apartment transaction records using PostgreSQL, you can acquire database management and analysis skills that can be immediately applied in the field.

Visualization (Python Dash)

You will learn how to effectively represent analyzed data using various visualization tools and how to express it in diverse graph formats.

What you will learn

PostgreSQL query syntax and how to use functions

You will learn the basic query syntax of PostgreSQL and how to use various functions. Through this, you will develop the ability to efficiently retrieve and manipulate data within a database.

Query Analysis Using Functions

Data analysis and visualization using queries

You will learn how to analyze large-scale data using the queries you have written and how to effectively present the analysis results through visualization tools. Through this, you can derive meaningful insights from the data.

Various Data Visualization Analyses

Notes before taking the course

Practice Environment

  • Operating System and Version (OS): Windows, macOS

  • Tools used: Postgresql, DBeaver, Python


Learning Materials

  • Learning materials are provided through lecture notes.


Prerequisite Knowledge and Notices

  • Basic query usage such as SQL (SELECT, INSERT, DELETE, UPDATE).

  • Python (Basic grammatical knowledge of Python)

  • I tend to speak slowly, so it will be much easier to follow if you set the video speed to 1.2–1.5x.

  • Please note that there is some noise in some of the videos.

Recommended for
these people

Who is this course right for?

  • Students and beginners looking to enter the fields of data science and data engineering

  • Those who want to efficiently analyze large-scale data using PostgreSQL

  • Those who wish to improve their skills in writing SQL queries, as well as data cleaning and transformation.

Need to know before starting?

  • How to use basic PostgreSQL queries (SELECT, UPDATE, INSERT, DELETE)

Hello
This is may9noy

Career Verified

2,562

Learners

295

Reviews

26

Answers

4.4

Rating

8

Courses

Hello. 😄

Sometimes I get exhausted from burnout due to childcare and work, 😅

I am an IT worker living each day with gratitude and a joyful heart. 😅


Personal Blog : https://may9noy.tistory.com

GitHub : https://github.com/Nanninggu


I wish you a life and home always filled with good things. 😀

More

Curriculum

All

64 lectures ∙ (8hr 49min)

Published: 
Last updated: 

Reviews

All

12 reviews

4.4

12 reviews

  • jjhgwx님의 프로필 이미지
    jjhgwx

    Reviews 1,058

    Average Rating 4.9

    5

    6% enrolled

    Thank you for the good lecture!

    • may9noy
      Instructor

      Thanks for the review, Jaehoon. ^^

  • hakjuknu님의 프로필 이미지
    hakjuknu

    Reviews 155

    Average Rating 5.0

    5

    31% enrolled

    great!

    • may9noy
      Instructor

      Thank you for your course review! 😊

  • gurwns8769972님의 프로필 이미지
    gurwns8769972

    Reviews 2

    Average Rating 5.0

    5

    100% enrolled

    • may9noy님의 프로필 이미지
      may9noy

      Reviews 12

      Average Rating 4.9

      5

      100% enrolled

      • eulerlab1092님의 프로필 이미지
        eulerlab1092

        Reviews 7

        Average Rating 2.0

        1

        31% enrolled

        Keeps repeating the same thing over and over. Keeps repeating. Keeps repeating.

        • may9noy
          Instructor

          Hello. :) I understand that you were not satisfied with the repeated explanations of recurring queries or functions. Personally, I repeated the explanations of frequently used functions, hoping that it would help you remember them for a long time. I will try to improve and create better lectures by improving the areas that can be improved. Thank you for the course review. ^^

        • It's not that, but you repeat unnecessary words. Then, then, this, this...

      may9noy's other courses

      Check out other courses by the instructor!

      Similar courses

      Explore other courses in the same field!

      Limited time deal ends in 6 days

      $27,500.00

      24%

      $28.60