Bước đầu tiên hướng tới Tableau
Gemma
Bằng cách xem qua nội dung của chứng nhận Tableau, bạn có thể hiểu được các chức năng tổng thể của Tableau trong một khoảng thời gian ngắn.
입문
Tableau
First steps to SQL coding test
By solving Leetcode SQL problems, you can understand problem types and improve your SQL implementation skills in a short period of time.
Reviews from Early Learners
What you will learn!
Implementing SQL logic
Using SQL functions
A quick overview of SQL syntax
SQL coding test problem solving,
Logic implementation + various functions in one lecture!
How much preparation should I do for the SQL coding test?
Where and why is my solution to the problem wrong?
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 analyze only the data you need. Because SQL uses a limited syntax, implementing SQL logic and using the right functions is crucial. Therefore, SQL is the first language you encounter before joining an IT company, especially for data- related positions, from the coding test. It remains essential even after joining the company.
But aren't you sure where to start? Should you start with the basics, like database principles, or is it overwhelming? For now, let's start with solving SQL problems for coding tests !
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
To help you solve general SQL problems in a short period of time, this lecture follows Leetcode 's SQL Easy difficulty problems (Korean translation provided) .
After establishing a solid foundation of knowledge, when I want to improve my skills, I start with simple problem-solving rather than delving into more difficult theories. This naturally allows me to review the concepts, and by solving the problems myself, they stick in my memory longer. Just like how you can't understand math if you only study the theory and don't practice solving problems, you won't understand it.
Don't worry if you can't solve a SQL problem on the first try. There's a gap between knowing the grammar and being able to solve the problem. At first, I couldn't solve the problem on the first try, and it took me a long time. Since it requires practice to familiarize yourself with the problem types, I've designed this course to help you approach it step-by-step with a light heart. Take the first step toward passing this year's SQL coding test!
Perfect for beginners!
First Steps to SQL Coding Test
Direct SQL query in MySQL Workbench + SQL backup via Github integration
The SQL you can query from the Leetcode prompt is limited. Directly verifying the data your SQL produces is essential for improving your skills. Therefore, before solving the problem, 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 your code to GitHub allows you to access it anytime, anywhere, from any device (whether it's your phone or another computer), making it a valuable backup tool. GitHub integration is incredibly useful, not only for SQL, but also for other programming languages!
Provides detailed SQL problem types and homework
Even within Leetcode's Easy difficulty, there are easy and hard levels. We'll start with the easier difficulty level. Beyond difficulty, we've also divided the SQL problems by type. Some are logic-related, like CASE WHEN and GROUP BY, while others are function-related, like LAG, LEAD, and RANK. By categorizing the problems, you can see at a glance how each type of problem will be presented.
For areas requiring additional conceptual explanation, we also provide theory lecture PPTs for students. We also provide assignments and solutions for additional practice on your own. Test your SQL skills for yourself!
Detailed Curriculum
The lecture is largely divided into three parts.
Part 1.
Introduction through very easy difficulty problems
Prepare for SQL coding tests by solving easier problems from Leetcode's Easy difficulty level first.
Part 2.
Logic related types
Solve logic- related problems by type (e.g. join, group by, not in, case when, etc.).
After querying the SQL step by step with MySQL Workbench, we derive the final query.
Part 3.
Function-related types
Solve function- related problems by type (e.g. rank, dense_rank, row_number, lag, lead, 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 additionally divided into difficulty and type .
- 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 used in this lecture, but also other programming languages in the future.
Q. Is this a course that non-majors can also take?
No, this course is designed for those with basic SQL knowledge. It's ideal for job seekers preparing for SQL coding tests or those just starting out in data-related fields.
Q. What level of proficiency can I expect to reach after completing this course?
The actual coding test is a mix of algorithmic and SQL questions (plus the occasional Pandas DataFrame processing question). The SQL questions aren't that difficult! (The algorithmic questions are more discriminatory.)
If you follow the lectures carefully and review the code posted on Github before the coding test date, you will be able to solve the SQL section problems without difficulty.
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
791
Learners
98
Reviews
38
Answers
4.8
Rating
4
Courses
수학으로 시작하여 개발자 커리어 이후, 통계 공부를 통해 현재는 데이터 분석가로 정착한 Gemma 입니다. 데이터 분석은 흐르고 넘치는 빅데이터 안에서 참신한 인사이트와 트렌드를 파악하는게 가장 중요합니다. 말이야 쉽죠? 하지만 적절한 분석툴과 방법을 활용할 수 있다면 충분히 누구나 귀중한 보석을 발견할 수 있어요. 이러한 방법론을 여러분에게 공유하고자 합니다.
(현) 데이터 분석가
학사 수학과 졸업, 석사 통계학 졸업
https://blog.naver.com/italian-lesson
(개인 블로그)
Curriculum
All
40 lectures ∙ (2hr 5min)
Course Materials:
Lecture resources
10. group by
05:00
12. having
04:25
14. min, max
01:22
18. Not in
05:16
24. group by
07:02
26. min, max
03:43
28. Not in
06:02
30. case when
06:20
Published:
Last updated:
Reviews
All
10 reviews
5.0
10 reviews
- blockmonkey1992
Reviews 10
∙
Average Rating 4.8
ss606444110Reviews 2
∙
Average Rating 5.0
- ssb79018373
Reviews 1
∙
Average Rating 5.0
- iceicebear
Reviews 2
∙
Average Rating 5.0
5
100% enrolledLúc đầu tôi không hiểu gì nên chỉ xem bài giảng và làm theo, nhưng khi xem qua bài giảng, tôi cố gắng giải quyết vấn đề trước khi xem bài giảng và đặt câu hỏi về những phần chưa biết. được đề cập trong các bài giảng, và tôi nghĩ tôi đã cảm nhận được điều đó. Sẽ dễ hiểu hơn nhiều vì bạn đã trả lời một cách chân thành. Cảm ơn!
- sooonzero
Reviews 4
∙
Average Rating 5.0
$26.40
Gemma's other courses
Check out other courses by the instructor!
Similar courses
Explore other courses in the same field!
![[Loạt bài phát triển game MMORPG thực hiện bằng C# và Unity] Phần 5: Cơ sở dữ liệu강의 썸네일](https://cdn.inflearn.com/public/courses/325283/course_cover/afb413e6-681e-47cd-808a-099c79fed112/rookiss-rpg-5.jpg?f=avif&w=420)
![[2025] SQLD All-in-One - Đỗ ngay lần đầu dành cho người không chuyên강의 썸네일](https://cdn.inflearn.com/public/files/courses/336953/cover/01jr02gfpt2km3k50amyw7sttt?f=avif&w=420)
