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.
![[ITⓔCoaching] Practical Data Management with OracleCourse Thumbnail](https://cdn.inflearn.com/public/courses/327587/cover/8133dede-51cb-4410-949c-cd95aa80b7d6/327587-eng-original.jpg?w=420)
![[A hundred words are not as good as seeing once] Basic SQL for data analysisCourse Thumbnail](https://cdn.inflearn.com/public/courses/324566/cover/aa1fac55-6e80-4506-9c92-f32c2b65f93a/sql_basic.png?w=420)
![Core Banking Server Features Implementation with Multi-Module Architecture [ Kotlin & Spring ]Course Thumbnail](https://cdn.inflearn.com/public/files/courses/337692/cover/01jx6h8k9xwd55qz59ta1vskrc?w=420)
![Check out the first past exam of 2026, the 60th session (26.3.7)! - All questions by subject and chapter [SQLD Past Exams are the Answer!]Course Thumbnail](https://cdn.inflearn.com/public/files/courses/341259/cover/01kky9hv3j24z7xtvxvpz11307?w=420)
![[2026] SQLD All-in-One: Pass in One Go, Even for Non-MajorsCourse Thumbnail](https://cdn.inflearn.com/public/files/courses/336953/cover/01kfq68bzb04w1mydc92ysfads?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)
