아메리카노 한 잔으로 듣는 구글시트 기초
박범진
구글 스프레드시트의 모든 것을 담은 것이 아닌, 제가 현업에서 데이터를 전처리 할 때 쓰는 것들만을 모아 담았습니다.
입문
Google Sheets
This is a basic SQL SELECT grammar lecture that starts without installing SQL.
SQL Select
Extracting data via SQL
Extract actual data with SQL Select!
• This course is designed to help you extract the data you want using SQL's SELECT syntax.
• I created this so that students can follow along using tables provided by w3schools.
• Simple images are included to help students understand.
In this course, we will practice using the online learning SQL editor provided by w3schools.
You can learn and practice SQL Select syntax without installing a separate SQL Editor.
Q. How is this different from previous lectures?
A1. It was created solely for data extraction.
A2. We made it so that you can follow it in practice rather than in theory.
A3. It is simple to compose because it consists only of grammar actually used in the company.
Q. What relational databases do you deal with?
A. This lecture is a basic SQL lecture, so it is commonly used.
Who is this course right for?
For those who dream of becoming a data analyst
Anyone who wants to extract the data they want through SQL
9,696
Learners
428
Reviews
15
Answers
4.8
Rating
8
Courses
- 현) KREAM 데이터 분석가
- 전) ABLY 데이터 분석가
- 전) wadiz 데이터 분석가
- 전) XIILab 인공지능개발팀 선임연구원
- 전) 아라종합기술 수치모델링1팀 사원
- 인하대학교 해양과학과 (학/석)
All
6 lectures ∙ (34min)
1. INTRO
00:58
2. SELECT
05:45
3. WHERE
05:44
4. GROUP BY
02:45
5. JOIN
08:06
6. SUBQUERY
11:00
All
146 reviews
4.8
146 reviews
Reviews 1
∙
Average Rating 5.0
Reviews 1
∙
Average Rating 5.0
Reviews 492
∙
Average Rating 4.8
Free
Check out other courses by the instructor!
Explore other courses in the same field!