[Problem Solving Class] 50 SQL Queries Determined to Solve (Part 1) - Coding Test Prep

 

If you are looking for the fastest training camp to go from a SQL query beginner to an expert,

Make a change in the "SQL Problem Solving Class for Real."

 

1. Who is this course for? (Recommended learners)

 

"I want to leap from a beginner to an experienced user, but I don't know which lecture I should take."

"I know the concepts of SQL, but writing queries in a real-world environment is still so difficult."

"I feel lost on how to solve SQL coding tests whenever they come up."

 

• This course is for everyone who understands SQL concepts but has the desire to write queries more naturally and comfortably.
• Just as understanding concepts alone is not enough when solving math problems, coding like SQL can be difficult to apply in practice through simple memorization or conceptual understanding alone.
• To overcome that process, it is important to start with an experienced pacemaker through various cases, writing many queries yourself and encountering errors along the way.

2. What can I expect after completing the course? (Expected benefits)

• 문제풀이 강의를 더 이상 듣지 않아도 됩니다.
  • Since this course covers many types of scenarios you may encounter while writing SQL queries, you will definitely experience a transformation if you follow all the content provided in the lectures.
  • Since you will learn how to study on your own, you will be able to further improve your skills through self-study by solving problems independently after completing the course.
  • Even if you encounter a problem you don't know, you can expect continuous support by asking questions through this course's community and the inquiry section.
•  SQL 코딩테스트에 대한 두려움을 해소할 수 있습니다.
  • In this course, we will conduct training using the LeetCode platform, the most widely used service in the world for preparing for coding tests.
  • Leetcode's Essential 50 is designed to cover many of the most frequently appearing topics in coding tests, so it will be helpful in real-world scenarios as well.
• 입문자에서 숙련자로 올라갈 수 있습니다.
  • For a beginner to become an expert, the most important things are making many mistakes and experiencing a wide variety of query types.
  • 본 강의 수강 시 다양한 유형과 많은 에러를 볼 수 있는 환경을 접할 수 있을 거에요.
    • Feel free to make as many mistakes and encounter as many errors as you like while taking the course. That process is part of learning and will surely lead to growth.
    • I want to accompany our learners on their journey from beginners to experts.

 

Check out Leetcode SQL 50 (Link)

 

3. Then, what parts should you not expect? (What is not covered)

• 다양한 종류의 각 DB별 세부 문법을 커버하지는 않고 있습니다.
  • Unfortunately, it is difficult to say that this course can cover every single aspect of SQL syntax. This is because there are various types of databases, and the usage of functions and detailed syntax can vary between each one.
  • Furthermore, because the programming ecosystem is constantly changing with version updates, even developers in the field are always studying and verifying these changes while they work.
• 물고기가 아닌 물고기 잡는 방법을 알려드릴게요.
  • However, the reason I say this course alone is sufficient is that I aim to teach you how to fish, rather than just giving you the fish.
  • As I mentioned earlier, no developer in the field works while knowing or memorizing the syntax of every database. This is because the programming ecosystem is constantly changing.
  • If you are preparing for practical analysis or employment, it is important to focus on the core parts that do not change and learn how to handle other aspects as they arise in real-world situations.

 

4. How will the lecture proceed? (Lecture/Product Introduction)

• 문제풀이를 반복하여 해답을 보지 않고도 모든 문제를 푸실 수 있도록 만들어드려요.
  • The goal of this course is to help you solve the problems in the problem-solving class at least twice and ensure you can write the queries yourself without looking at the answers when you encounter the problems again.
  • 본 강의에서는 문제 세트를 2회 이상 반복하시는 것을 권장드리고 아래의 스텝으로 나누어서 진행하시는 것을 추천드리고 있어요.
    • During the first round, if you cannot solve a problem after thinking about it for more than 30 minutes, I recommend watching the video.
    • For the second round, it is recommended to select only the problems you couldn't solve on your own during the first round and try solving them without spending more than an hour on each.
    • Afterward, it is recommended to select only the problems that remained unsolved even during the second review and practice solving them repeatedly until you can solve them without looking at the answer key.
  • We provide guides for various plans that you can choose based on your individual situation (e.g., 30-Day Completion Plan / 2-Week Completion Plan / Short-term Cram Plan). Please select your desired duration and try to complete the course until the end.
  • Please refer to the sample video of this lecture for the problem-solving method.
• 스터디를 통해 완주하실 수 있도록 도와드려요.
  • Study groups are recruited on a rolling basis and are held online once a week for a total of four sessions.
  • We help track the progress of study participants.
  • 진행은 각 주차별 공통 문제를 풀고 스터디원들과 돌아가며 문제를 직접 구두로 설명하는 시간을 가져요.
    • A separate study group for introverts (where progress is verified via text only) is also available.
• 질문이 있을 경우 물어볼 수 있는 창구를 운영하고 있어요.
  • If you have any questions, please leave them through the questions tab within Inflearn.

 

 

5. Who will you be studying with? (Instructor Introduction)

• <SQL for Product Managers> Author - Insight

   

• Possesses many years of hands-on experience as a data engineer and analyst (SSG.COM, Kmong, Discovery of Play)

• Extensive experience in SQL corporate training (global corporations, startups, and individuals)

   

 

Other Lecture/Book Series by Joe (Breachers)

• 인프런 
  • [Concept Edition] SQL Queries: Learn and Use Immediately
  • [Concept Class] Pandas You Can Learn and Use Right Away
  • [Introductory Class] Stories of Servers, the Internet, and Data

• 도서
  • <SQL for Product Managers> - Insights

 

Community Launch Announcement

Please join the Discord server for lecture-related communication and information exchange!

- Link: https://discord.gg/yTdKbAk8g2