My friend said that I could apply it to my work if I just listened to the intermediate level, but I think it was a good idea to listen to the advanced level. Just seeing examples of what functions there are and how they can be used broadens my horizons and makes me want to try more things, so I feel passionate!! Thank you!

harryoh

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

odhkorea, thank you for your course review! About 61% of the intermediate class students are taking the advanced course, which is a little over half of the students :) We also put a lot of effort into making the advanced course and tried to include as much practical content as possible. Congratulations on completing the course.

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