강의

멘토링

커뮤니티

Data Science

/

Data Analysis

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

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

(4.3) 9 reviews

102 learners

Level Basic

Course period Unlimited

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

Reviews from Early Learners

Reviews from Early Learners

4.3

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 records of Korean apartment transactions using PostgreSQL.
You will learn skills that can be applied immediately in practice, from creating databases and tables to cleaning data, writing queries, and deriving visual insights using the Python Dash library.
This course is for those interested in data analysis and visualization. 😀

I recommend this to these people 😀

Data Analysis Beginner

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

SQL User

Data derivation and analysis using various SQL queries and functions using Korean apartment transaction data.

Data Visualization Beginner

Beginners to data visualization who want to effectively visualize analysis results to derive insights.

After class

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

  • Analysis results can be effectively expressed and generated through visualization tools.

  • Analyze data using large amounts of data to derive meaningful insights.

  • Learn about PostgreSQL, DBMS/RDBMS, data analysis, data cleaning, and data engineering.

Features of this course

Practice-oriented data analysis

Practice-oriented data analysis

By analyzing 5 million actual Korean apartment transaction data using PostgreSQL, you can acquire database management and analysis skills that can be applied immediately in the field.

Visualization (Phthon Dash)

Learn how to effectively express analyzed data using various visualization tools and how to express it in various graph forms.

Learn about these things

How to use PostgreSQL's query syntax and functions

Learn the basic query syntax and how to use various functions in PostgreSQL. This will help you develop the ability to efficiently retrieve and manipulate data in the database.

Query analysis using functions

Data analysis and visualization using queries

You will learn how to analyze large amounts of data using written queries and effectively present the analysis results using visualization tools. This will allow you to derive meaningful insights from the data.

Various data visualization analysis

Things to note before taking the class

Practice environment

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

  • Tools used: Postgresql, DBeaver, Python


Learning Materials

  • Learning materials are provided through lecture notes.


Player Knowledge and Notes

  • How to use basic queries such as SQL (SELECT, INSERT, DELETE, UPDATE).

  • Python (basic knowledge of Python grammar)

  • Since the speech is slow, it will be much easier to watch if you set the video speed to 1.2~1.5.

  • Please note that some footage contains noise.

Recommended for
these people

Who is this course right for?

  • Students and beginners entering Data Science and Data Engineering

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

  • Those looking to enhance their skills in SQL query writing, data cleansing, and transformation

Need to know before starting?

  • Basic PostgreSQL Query Usage (SELECT, UPDATE, INSERT, DELETE)

Hello
This is

1,493

Learners

112

Reviews

21

Answers

4.6

Rating

6

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. 😀

Curriculum

All

64 lectures ∙ (8hr 49min)

Published: 
Last updated: 

Reviews

All

9 reviews

4.3

9 reviews

  • mgkim2000님의 프로필 이미지
    mgkim2000

    Reviews 1

    Average Rating 5.0

    5

    31% enrolled

    • jinukchoi5015님의 프로필 이미지
      jinukchoi5015

      Reviews 13

      Average Rating 5.0

      5

      31% enrolled

      • heyhello00115898님의 프로필 이미지
        heyhello00115898

        Reviews 1

        Average Rating 5.0

        5

        31% enrolled

        • may9noy
          Instructor

          Thank you for your course review, heyhello0011. 😃

      • jjhgwx님의 프로필 이미지
        jjhgwx

        Reviews 644

        Average Rating 4.9

        5

        6% enrolled

        Thank you for the good lecture!

        • may9noy
          Instructor

          Thanks for the review, Jaehoon. ^^

      • goldencrab님의 프로필 이미지
        goldencrab

        Reviews 7

        Average Rating 4.9

        5

        31% enrolled

        • may9noy
          Instructor

          Thank you for your review. 😊😊 Have a great day. ^^

      $28.60

      may9noy's other courses

      Check out other courses by the instructor!

      Similar courses

      Explore other courses in the same field!