SQL 코딩테스트를 위한 첫 걸음
Gemma
Leetcode SQL 문제를 풀이하면서, 짧은 시간 안에 문제 유형 파악 및 SQL 구현 실력을 키울 수 있습니다.
초급
코딩 테스트, SQL, MySQL
The final step for SQL coding test
As you work through more difficult Leetcode SQL problems, you'll learn how to apply multiple grammar rules to a single problem.
Reviews from Early Learners
What you will learn!
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!
Why the SQL Coding Test Was Difficult
Even complex solutions are explained clearly!
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 closely related to data jobs
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.
Player course
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 lecture
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.
To reduce the burden and increase efficiency.
🙋♀️ 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
Take your skills to the next level
The final step of the SQL coding test
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!
Detailed Curriculum
The lecture is largely divided into two parts.
Part 1. Function-related types
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.
Part 2. Logic-related types
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&A 💬
Q. What makes this course different?
- Leetcode problems are provided by type .
- Solve complex, difficult problems that mix all the grammar and functions.
- We provide environment settings that allow you to directly check intermediate SQL results while installing MySQL Workbench .
- By installing Github together, we provide an environment setting that can back up not only the SQL of this lecture but also other programming languages in the future.
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.
Recommended for
these people
Who is this course right for?
Computer Engineering Major
Job seekers preparing for coding tests
Data Analyst
Need to know before starting?
SQL
770
Learners
97
Reviews
37
Answers
4.8
Rating
4
Courses
수학으로 시작하여 개발자 커리어 이후, 통계 공부를 통해 현재는 데이터 분석가로 정착한 Gemma 입니다. 데이터 분석은 흐르고 넘치는 빅데이터 안에서 참신한 인사이트와 트렌드를 파악하는게 가장 중요합니다. 말이야 쉽죠? 하지만 적절한 분석툴과 방법을 활용할 수 있다면 충분히 누구나 귀중한 보석을 발견할 수 있어요. 이러한 방법론을 여러분에게 공유하고자 합니다.
(현) 데이터 분석가
학사 수학과 졸업, 석사 통계학 졸업
https://blog.naver.com/italian-lesson
(개인 블로그)
Curriculum
All
25 lectures ∙ (1hr 50min)
Course Materials:
Lecture resources
Published:
Last updated:
Reviews
All
4 reviews
5.0
4 reviews
$17.60
gemmadata's other courses
Check out other courses by the instructor!
Similar courses
Explore other courses in the same field!
![[C#과 유니티로 만드는 MMORPG 게임 개발 시리즈] Part5: 데이터베이스강의 썸네일](https://cdn.inflearn.com/public/courses/325283/course_cover/afb413e6-681e-47cd-808a-099c79fed112/rookiss-rpg-5.jpg?f=avif&w=420)
![[2025] 비전공자도 한 번에 합격하는 SQLD 올인원강의 썸네일](https://cdn.inflearn.com/public/files/courses/336953/cover/01jr02gfpt2km3k50amyw7sttt?f=avif&w=420)
