Learn the basics of Google Sheets with a cup of Americano
pbj0812
This is not a complete list of Google Spreadsheets, but rather a collection of only the things I use to preprocess data in my field.
Beginner
Google Sheets
This is a basic SQL SELECT grammar lecture that starts without installing SQL.

Reviews from Early Learners
5.0
woojun2002
The entire course is 35 minutes long, but it's short, and I liked that it only focused on the key points~! I recommend it to those who don't have time and want to learn quickly and apply it to their work!!
5.0
Dooho Park
It's good to practice with an example that can be applied right away.
5.0
Jang Jaehoon
Thank you so much for the great lecture!
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,953
Learners
448
Reviews
15
Answers
4.8
Rating
8
Courses
- Current) KREAM Data Analyst
- Former) ABLY Data Analyst
- Former) wadiz Data Analyst
- Former Senior Researcher, AI Development Team at XIILab
- Former) Associate, Numerical Modeling Team 1, Ara Total Technology
- Inha University, Department of Ocean Sciences (Bachelor's/Master's)
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
148 reviews
4.8
148 reviews
Reviews 1
∙
Average Rating 5.0
Reviews 1
∙
Average Rating 5.0
5
It's good to practice with an example that can be applied right away.
thank you!!!!!
Reviews 7
∙
Average Rating 5.0
Free
Check out other courses by the instructor!
Explore other courses in the same field!