As you work through more difficult Leetcode SQL problems, you'll learn how to apply multiple grammar rules to a single problem.
먼저 경험한 수강생들의 후기
5.0
김주아
I took this course because I liked the previous one so much. The teacher was very thorough, so it was very helpful. I highly recommend taking these two courses if you are preparing for a SQL coding test 😊😊
5.0
이승렬
As an extension of the pre-lecture, I think it helped me a lot in solving more difficult problems.
5.0
미나리
I took the beginner level, but I liked the teacher's teaching style, so I completed the intermediate level! I was about to take a coding test, and this lecture was good because I was able to solve a lot of problems. It would be more useful for those who are taking it before the test or want to apply it right away in real life.
Implementing SQL logic
Using SQL functions
Use various SQL syntax at once
SQL coding test problem solving,
From various functions to logic implementation, all in one place!
SQL coding tests aren't limited to a single grammar question! This course will help you solve challenging problems that mix multiple grammar questions .
SQL is a programming language that helps you uncover insights and trends hidden in vast amounts of data. You can also extract and examine only the specific data you need. Because it uses a limited syntax, implementing clear logic and using the right functions is crucial.
Therefore, SQL is the first language you encounter before joining an IT company, especially if you're in a data-related position, even during the coding test. It remains an essential language even after joining the company.
For those who don't know where to start preparing, I recommend taking the First Steps to SQL Coding Test course first.
In this pre-course, we'll follow Leetcode 's SQL Easy difficulty problems to help you cover the general SQL problem types in a short amount of time.
This course, consisting of Leetcode 's Medium-difficulty SQL problems (with Korean translations) , presents comprehensive problems that blend all aspects of grammar and function. Rather than focusing solely on single-logic problems, you'll practice organically connecting SQL grammar to solve problems that mix multiple logics.
🙋♀️ Job seekers preparing for coding tests
🙋♀️ Those who want to refer to SQL solutions and apply them to their work
🙋♀️ For those who find learning through examples more effective than theory
Setting up the environment for SQL queries and backups
The SQL you can query in the LeetCode prompt is limited. To improve your skills, it's essential to directly verify the data your queries produce. Therefore, before solving the problems, we'll install MySQL and set up the environment to query SQL in Workbench.
We'll also set up an environment that integrates with GitHub. Uploading code to GitHub allows you to access it anytime, anywhere, from any device, making it a great backup solution. This GitHub integration is incredibly useful, as it can be used not only for SQL but also for other programming languages!
Provides detailed SQL problem types and homework
Leetcode offers two difficulty levels, Easy and Hard. We'll start with the Easy difficulty level.
In addition to difficulty, we've categorized SQL questions by type. These range from logic-related questions like CASE WHEN and GROUP BY to function-related questions like LAG, LEAD, and RANK. We've organized the questions so you can see at a glance how each type of question will be presented.
We also provide theory lecture PPTs for areas requiring additional conceptual explanation. Interval homework and solutions are also provided for independent practice. Test your SQL skills for yourself!
The lecture is largely divided into two parts.
Solve function-related problems by type (e.g. rank, dense_rank, lag, lead, etc.).
After querying the SQL step by step with MySQL Workbench, we derive the final query.
Solve logic-related problems by type (e.g., having, limit, sum, not in, case when, etc.).
After querying the SQL step by step with MySQL Workbench, we derive the final query.
Q. What makes this course different?
Q. Can I listen without prior related knowledge?
No, this course is intended for those who have already taken the prerequisite course, " First Steps to the SQL Coding Test ." It's also an effective course for those just starting out in data science.
Q. What level can I reach after completing the course?
The actual SQL coding test isn't that difficult, so just attending the preparatory lectures should be sufficient. However, if you want to apply various grammar techniques to a single problem or practice organically connecting different logics, this course will help you level up.
학습 대상은 누구일까요?
Computer Engineering Major
Job seekers preparing for coding tests
Data Analyst
선수 지식, 필요할까요?
SQL
957
수강생
120
수강평
40
답변
4.9
강의 평점
5
강의_other
I am Gemma, a data analyst who started in mathematics, moved into a developer career, and eventually settled into my current role after studying statistics. In data analysis, the most important thing is identifying novel insights and trends within the overflowing sea of big data. That’s easier said than done, right? However, if you can utilize the right analysis tools and methods, anyone is more than capable of discovering valuable gems. I would like to share these methodologies with all of you.
(Current) LINE Plus Data Analyst
(Former) NAVER Data Analyst
Master's in Applied Statistics, Politecnico di Milano, Italy
Bachelor of Science in Mathematics, Ewha Womans University (Double Major in Computational Science, Minor in Computer Science)
Author of 'SQL Practical Training': https://product.kyobobook.co.kr/detail/S000217223580
Email: sweetherb100@gmail.com
Personal Blog:
https://blog.naver.com/italian-lesson
전체
14개 ∙ (강의상세_런타임_시간 강의상세_런타임_분)
4. rank
07:41
5. dense_rank
09:25
6. lag, lead
14:56
7. ifnull
09:02
8. date
08:08
9. min, max
03:39
10. having
07:44
11. limit
08:17
12. not in
04:55
13. case when
07:18
14. sum
04:28
전체
4개
5.0
4개의 수강평
수강평 3
∙
평균 평점 5.0
수강평 2
∙
평균 평점 5.0
수강평 1
∙
평균 평점 5.0
수강평 2
∙
평균 평점 5.0
5
I took the beginner level, but I liked the teacher's teaching style, so I completed the intermediate level! I was about to take a coding test, and this lecture was good because I was able to solve a lot of problems. It would be more useful for those who are taking it before the test or want to apply it right away in real life.
지식공유자님의 다른 강의를 만나보세요!
같은 분야의 다른 강의를 만나보세요!
강의상세.할인문구
$15,400.00
30%
$17.60
![[2026] SQLD All-in-One: Pass on Your First Try Even as a Non-MajorCourse Thumbnail](https://cdn.inflearn.com/public/files/courses/336953/cover/01kfq68bzb04w1mydc92ysfads?w=420)
![[2026] Yellow Book 176 Practice Problems for Those Who Find SQLD Questions DifficultCourse Thumbnail](https://cdn.inflearn.com/public/files/courses/336270/cover/01kfq647gtwqrwbjwbrn9rhn1t?w=420)
![Complete Mastery Bootcamp from Java Fundamentals to Oracle SQL [Full vers.]Course Thumbnail](https://cdn.inflearn.com/public/files/courses/336223/cover/01k2j32xzj93q4a4mhs8ra9q4b?w=420)
![[MMORPG Game Development Series with C# and Unity] Part 5: DatabaseCourse Thumbnail](https://cdn.inflearn.com/public/courses/325283/course_cover/afb413e6-681e-47cd-808a-099c79fed112/rookiss-rpg-5.jpg?w=420)
