Intermediate-Advanced SQL and 101 Practical Data Analysis Problem Solutions

Strengthening SQL practical skills
This one lecture is enough 💪

We have compiled and reorganized the best feedback from students in the data analysis boot camps and offline lectures we have conducted over the years into an online lecture. Most of the students who have taken the existing offline lectures have upgraded their skills to the point where they can immediately perform real-world data projects as data experts, so we confidently recommend this lecture to those who want to improve their practical SQL skills.

With 101 practice problems
Don't be confused by any SQL you encounter

Do you know SQL grammar but still feel overwhelmed when trying to write queries that are necessary for practical work? The fastest and most efficient way to upgrade your SQL skills is to solve various problems . If you follow the curriculum step by step, you will be able to solve complex and long queries that go beyond one line of queries and reach dozens of lines in no time.

In particular, since the problems are about data analysis topics that are likely to be requested in practice, if you can solve the problems covered in this lecture on your own, you will be able to acquire the skills to do both SQL coding tests and SQL data analysis at the industry level .

Let's build up your SQL skills so you can create any SQL statement you want without buffering!

Lecture Features ✨

#1.
Lectures based on well-organized materials

To help you become familiar with database utilization techniques in a short period of time.
We provide a variety of code and material-based lectures by step/technology.

#2.
If you need to level up after learning basic SQL grammar

If you know the basic SQL grammar, it won't be difficult for anyone!
You can start with a single line of query and eventually write a real-world query with dozens of lines.

#3.
Systematic roadmap

For those considering a career in data science/AI engineering, we present a systematic roadmap. ( Click here )

What you'll learn 📖

Detailed study grammar

• SQL functions (strings, date/time, numbers, etc.)

• Various intermediate and advanced subqueries and correlated subqueries

• SQL set commands

• Transactions and ROLLBACK/COMMIT

• SQL VIEW

• WITH Clause (Common Table Expressions)

• CASE WHEN, GROUP_CONCAT clause

• Window functions (RANK, DENSE_RANK, ROW_NUMBER)

• Window functions (PARTITION BY, ORDER BY, ROWS/RANGE)

• Window functions (LEAD, LAG, FIRST_VALUE, LAST_VALUE)

• Window functions (PERCENT_RANK, CUME_DIST, NTILE)

Who created this course (Dave Lee of Janjaemi Coding)

This course was designed based on my experience working with data analysts and data engineers, with the idea that complex SQL writing skills are essential for performing roles in the field. In order to improve these skills in a short period of time, the course was designed with the consideration that complex SQL query writing practice and an understanding of intermediate and advanced SQL are necessary. I hope that this course will help you quickly develop practical SQL skills and grow into a data analyst, data scientist, or data engineer with solid SQL skills.

• Current CTO of Neumanns & Turings

• Former Coupang Principal Product Manager/Principal Development Manager,

  Samsung Electronics Development Manager

  
  

• Education: Korea University Japanese Language and Literature / Yonsei University Computer Engineering Master's degree

  
  

• Key development/planning history: Ecommerce, Samsung Pay, mobile platform

  
  

• Books: Flask & FastAPI for the fastest full stack, Linux Kernel Programming, Understanding and developing the Linux operating system, IT core technology that anyone can read and understand, Introduction to Python programming for complete beginners

Things to note before taking the class