I remember obtaining and watching a video of a lecture given by the CEO of Encore at Interpark about 15 years ago. He really instilled the core concepts of RDBMS in me. While working, I tried to find that lecture again but couldn't. However, I've found it here on Inflearn. I was getting bored because I kept being assigned only CH (Change) tasks. Next time, I should just say I'll do AP and CH all at once. Then I'll be able to move on to AP, right?

I will keep following your future lectures!! Thank you for providing such high-quality content~

cashbay3335

Through detailed lectures and hands-on practice on the core elements of SQL, we will provide you with a solid foundation to grow into a SQL analysis expert.

dooleyz3525

Data Analysis SQL Fundamentals

Oh, I see! ^^ Thank you so much for taking the time to write such a great review.

postgresql

데이터분석

데이터베이스 관리 시스템

DBMS/RDBMS

입문

초급

중급이상

포스트그레SQL

PostgreSQL

Data Engineering

Introducing the lecture and setting up the practical environment.

Join - Join-based mechanism

Join - Outer Join, Non Equi Join, Cross Join

Handling Date, Timestamp, and Interval

Group by and Aggregate Function

Analytic SQL - Overview and Rankings Analytic

Analytic SQL - Aggregate Analytic and Window Details

Analytic SQL - lead/lag, first_value/last_value, rank/reverse quantile functions

[Appendix] Sub-query

In conclusion