![[백문이불여일타] 데이터 분석을 위한 기초 SQL강의 썸네일](https://cdn.inflearn.com/public/courses/324566/cover/aa1fac55-6e80-4506-9c92-f32c2b65f93a/sql_basic.png?w=420)
[백문이불여일타] 데이터 분석을 위한 기초 SQL
데이터리안
인프런 누적 수강생 10,000명 이상, 풍부한 온/오프라인 강의 경험을 가진 데이터리안의 SQL 기초 강의. SQL 기초 이론을 배우고, 해커랭크 문제 10개를 함께 풀어봅니다.
입문
SQL, MySQL, 카카오공채-서비스
Solve 25 SQL problems of various difficulty levels. This is the Advent of SQL 2024 explanation lecture. Upon finishing the lecture, you can complete the Advent calendar and obtain a badge.
SQL Problems: Beginner to Advanced, Various Difficulties
Advent of SQL 2024 Completed
solvesql X datalian
This challenge has already had over 1,000 participants.
What's more important than SQL theory or certification is whether you can actually do it.
Inflearn SQL popular course "[A hundred questions are not as good as seeing once] SQL for data analysis" explained directly by the instructor.
"I don't know how to prepare for the SQL coding test. Is there an effective way to study ?"
"I want to master the grammar that I still find difficult, such as subqueries and window functions, by repeatedly solving various problems ."
"I passed the SQLD certification exam, but I didn't understand exactly how to extract and analyze data. Now, I need practice, not theory ."
This will prepare you perfectly for the SQL coding test.
You will become proficient in everything from basic SELECT, FROM, WHERE grammar to subqueries and window functions.
You will become familiar with functions for working with dates and times, and functions for working with strings.
Are you bored with solving SQL problems? Every time you solve a problem, your calendar turns colorful. Studying SQL is no longer boring because you have fun completing your own calendar.
Calendar complete!
Are you thinking, 'Is it too late to start the Advent of SQL 2024 Challenge?' Everyone who completes the challenge will receive the Advent of SQL 2024 (Too Late) badge!
See who received the badge 👉 https://solvesql.com/badges/advent-of-sql-2024-toolate/
Advent of SQL 2024
(Too Late) Badge
Current) Datalian CEO
Former Kakao Data Analyst
Former Hyperconnect Product Analyst
Former Coupang Business Analyst
Hello! Nice to meet you. I am Seonmi Yoon, a data analyst. I have created this lecture due to many requests for explanations for the Advent of SQL 2024 Challenge. I hope it will be helpful to those who are studying SQL and preparing for coding tests.
Leave memorizing SQL grammar to the cheat sheet for now.
Q. Do I need to have good computer specifications?
Computer specifications are not important at all. All practical exercises are conducted online to avoid learning impediments due to program installation and other external factors. Please take the course in an environment with a smooth internet connection.
However, since you will need to practice directly while looking at the lecture screen, we recommend using dual monitors.
Q. I'm new to SQL. Can I listen to it too?
This lecture is a problem-solving lecture, and the class proceeds assuming that you are familiar with the main SQL grammar. For those who need to learn basic SQL theory, we recommend the SQL Data Analysis Camp | Introduction + Practice Package .
Q. How difficult is the actual coding test?
SolveSQL's problems are classified by difficulty level from 1 to 5. Most coding test problems are considered to be between difficulty level 3 and 4. This is similar to HackerRank Medium and Leetcode Medium~Hard.
If you are new to SQL coding tests, I recommend the lecture Almost Everything About SQL Coding Tests .
Q. The lecture title says ‘(Introductory Week 1)’. What does that mean?
SQL Data Analysis Camp | Solve problems based on the content of the first week of the introductory course . If you are curious about Datarian's camp, please refer to the Datarian homepage !
Solvesql membership registration and login required
Dual monitor use recommended
You can start Day 1 with basic grammar at the level of SELECT, FROM, WHERE, ORDER BY.
DBMS Permissions
SQLite: All logged in users
MySQL: SQL Data Analysis Camp Introductory , Practical , and Master Class Students
PostgreSQL: SQL Data Analysis Camp Master Course Student
SQL Data Analysis Camp | Master Class
For those who are wondering which is better between query A and query B
Anyone who wants to experience data analysis methodology that is essential in practice
For those who are curious about how to design data
For those who want to further upgrade their SQL skills
Who is this course right for?
Person preparing for SQL coding test
Knows SQL theory but lacks practice
Need to know before starting?
SQL
32,375
Learners
2,814
Reviews
23
Answers
4.9
Rating
37
Courses
All
35 lectures ∙ (2hr 54min)
Course Materials:
Free
Check out other courses by the instructor!
Explore other courses in the same field!