may9noy

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.

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

이론과 실습 한 번에

이론 실습 모두

데이터분석프로젝트

입문

초급

중급이상

포스트그레SQL

PostgreSQL

데이터베이스 관리 시스템

DBMS/RDBMS

data-analysis

data-cleaning

Data Engineering

Course Introduction

PostgreSQL Introduction

PostgreSQL Installation

Add Sample Data for analysis (Approx. 5 million South Korean apartment transaction records)

Data cleansing

Data Analysis (Basic Information)

Data Analysis Using Functions

Advanced SQL Syntax

Data Analysis

Visualization using Dash

Index and Performance Optimization

Advanced features

Lecture Notes