인프런 영문 브랜드 로고
인프런 영문 브랜드 로고
BEST
Data Science

/

Data Analysis

[A hundred words are not as good as seeing once] Advanced SQL for data analysis

Datalian's advanced SQL lecture with over 10,000 cumulative students and rich online/offline lecture experience. Learn advanced SQL theory and solve practice problems together.

(4.8) 285 reviews

3,113 students

SQL
Thumbnail

This course is prepared for Intermediate Learners.

What you will learn!

  • Importing data with SQL

  • The third lecture in the SQL Basics series that even people who have never coded before can understand!

 

There are many lectures on SQL theory,
Why aren't there any lectures that allow me to develop real skills while solving problems?

Just as no matter how much you study English grammar, your English conversation skills will not improve if you don't actually have conversations,
You can't use SQL properly just by studying the grammar.

 

 

 

Lecture Introduction 📝

 

Welcome to the advanced class after completing the SQL Basics and Intermediate classes!

👏👏(clap clap clap)👏👏

 



If you have learned the basic syntax of SQL (joining multiple tables, group operations, etc.) so far,
From now on, we will cover various functions of SQL to solve more complex and difficult problems.

Through advanced lectures, you can acquire the skills to efficiently handle various operations required in practice.
You can also learn more in-depth by using the additional materials provided during or at the end of the lecture.

Thank you to all the students who took the classes from beginner to advanced for your hard work!

 

 


You no longer need to bother sending emails.
Download it directly from Infraon!

Now you have completed all the advanced SQL courses.
In the last lecture, 'Completion Commemorative Gift_SQL Cheatsheet (Advanced)'
Click the [Class Materials] button on the top right
You can download the CheatSheet
( see image below) .

(Not required, but thoughtful reviews and questions are always welcome!)

 

Things to prepare before attending the lecture ✔️

The lecture is available on HackerRank ( hackerrank.com ) and leetcode ( leetcode.com ) sites.
The curriculum is structured based on problems.
Before attending the lecture, we recommend that you visit the above website, register as a member, and then take a look around the website.

 

Things that are good to study together ✔️

Programmers SQL High Score Kit
https://programmers.co.kr/learn/challenges?tab=sql_practice_kit

 

✔️ Course Roadmap

 

Rewatch the last lecture 🔖

Recommended for
these people!

Who is this course right for?

  • People who have learned SQL theory but feel they lack practical experience

  • People preparing for SQL coding tests

  • People who need a problem-solving-focused SQL lecture

  • Anyone who wants to start learning SQL without any plan!

  • People who want to become data analysts

Need to know before starting?

  • Take a SQL Basics Course for Data Analysis

  • Take an intermediate SQL course for data analysis

Hello
This is

28,816

Students

2,574

Reviews

22

Answers

4.9

Rating

38

Courses

실무 경험이 탄탄한 현업 분석가들이 데이터 분석 교육을 기획하고, 직접 강의합니다.

데이터리안에 대해서 더 알아보고 싶다면

👉 https://datarian.io/

Curriculum

All

32 lectures ∙ (4hr 54min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

Not enough reviews.
Become the author of a review that helps everyone!