강의

멘토링

커뮤니티

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) 8 reviews

92 learners

  • may9noy
이론 실습 모두
데이터분석프로젝트
PostgreSQL
DBMS/RDBMS
data-analysis
data-cleaning
Data Engineering

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,198

Learners

80

Reviews

20

Answers

4.7

Rating

6

Courses

안녕하세요. 😄

가끔은 육아와 업무로 번아웃이 와서 지치긴 하지만, 😅

하루하루를 항상 감사와 즐거운 마음으로 살아가고 있는 IT 근로자 입니다. 😅


개인 블로그 : https://may9noy.tistory.com

GitHub : https://github.com/Nanninggu


삶과 가정 속에서 항상 좋은 일들만 가득하시길 기원합니다. 😀

Curriculum

All

64 lectures ∙ (8hr 49min)

Published: 
Last updated: 

Reviews

All

8 reviews

4.3

8 reviews

  • mgkim님의 프로필 이미지
    mgkim

    Reviews 1

    Average Rating 5.0

    5

    31% enrolled

    • 최진욱님의 프로필 이미지
      최진욱

      Reviews 13

      Average Rating 5.0

      5

      31% enrolled

      • heyhello0011님의 프로필 이미지
        heyhello0011

        Reviews 1

        Average Rating 5.0

        5

        31% enrolled

        • 숀김
          Instructor

          heyhello0011님 수강평 감사합니다. 😃

      • Jang Jaehoon님의 프로필 이미지
        Jang Jaehoon

        Reviews 609

        Average Rating 4.9

        5

        6% enrolled

        좋은 강의 감사합니다!

        • 숀김
          Instructor

          재훈님 수강평 감사합니다. ^^

      • 김상현님의 프로필 이미지
        김상현

        Reviews 1

        Average Rating 3.0

        3

        31% enrolled

        • 숀김
          Instructor

          소중한 수강평 감사합니다. ^^ 부족한 부분 전달주시면 개선 하도록 하겠습니다. 감사합니다. ^^

      Limited time deal ends in 07:57:05

      $27,220.00

      25%

      $28.60

      may9noy's other courses

      Check out other courses by the instructor!

      Similar courses

      Explore other courses in the same field!