강의

멘토링

로드맵

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.1) 7 reviews

85 learners

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

What you will learn!

  • 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,067

Learners

65

Reviews

20

Answers

4.6

Rating

6

Courses

안녕하세요. 😄

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

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


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

GitHub : https://github.com/Nanninggu


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

Curriculum

All

64 lectures ∙ (8hr 49min)

Published: 
Last updated: 

Reviews

All

7 reviews

4.1

7 reviews

  • heyhello0011님의 프로필 이미지
    heyhello0011

    Reviews 1

    Average Rating 5.0

    5

    31% enrolled

    • 숀김
      Instructor

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

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

    Reviews 594

    Average Rating 4.9

    5

    6% enrolled

    좋은 강의 감사합니다!

    • 숀김
      Instructor

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

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

    Reviews 1

    Average Rating 3.0

    3

    31% enrolled

    • 숀김
      Instructor

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

  • me.centric.world님의 프로필 이미지
    me.centric.world

    Reviews 7

    Average Rating 4.9

    5

    31% enrolled

    • 숀김
      Instructor

      수강평 감사합니다. ㅎㅎ 좋은하루 되세요. ^^

  • hakjuknu님의 프로필 이미지
    hakjuknu

    Reviews 155

    Average Rating 5.0

    5

    31% enrolled

    great!

    • 숀김
      Instructor

      수강평 감사합니다. 😊

$28.60

may9noy's other courses

Check out other courses by the instructor!

Similar courses

Explore other courses in the same field!