I took the course because I actually used it in my field, and it was very helpful for me to understand because it was easy to organize various things that can be applied in real-life fields, such as Windows functions. This course is also unlimited, so I can come in and look at it whenever I'm confused, which is nice. I will take various courses, such as Python, in the future :)

leegnho1022

Inflearn cumulative students of over 30,000, Datarian's advanced SQL course with extensive online/offline teaching experience.
Learn advanced SQL theory and solve 25 practice problems together.

datarian

인프런 10주년! 사랑주간 전체 할인

[A hundred words are not as good as seeing once] Advanced SQL for data analysis

leegnho1022, thank you for following along to the end of the lecture, even though it is not easy. The advanced class lecture is mainly planned to focus on things that are often used in the field, so I think you will be able to use it usefully in the field. I hope the cheat sheet I sent you today will also be of great help. Thank you for leaving a review of the lecture :)

sunmiyoon

sdatarian

canary4651

입문

초급

중급이상

Orientation

WHERE clause subquery

FROM Clause & SELECT Clause Subqueries

Subquery Wrap-up

Window Functions (Aggregate Functions)

Window Functions (Ranking Functions)

Window Functions (Position-based Functions)

Conclusion