강의

멘토링

커뮤니티

Data Science

/

Data Analysis

Data analysis starting with SQL and Google Sheets

I have summarized the essential SQL SELECT statements and basic usage of Google Sheets that I learned while working as an analyst at a service company.

(4.7) 3 reviews

74 learners

  • pbj0812
SQL
Google Sheets
DBMS/RDBMS
MySQL

What you will gain after the course

  • SQL SELECT syntax for data analysis

  • How to use Google Sheets for data analysis

Learn practical data analysis know-how from a working data analyst!

📣 Please check before taking the course! • This course is a text-based lecture, providing PDF lecture files and practice files. This is not a video lecture, so please refer to it for your study. Thank you.

This course, based on feedback (course reviews) and questions from my previous SQL course, "SELECT ALL FROM SQL," I've tried to fill in the gaps left by the short 30-minute lecture. Rather than creating an encyclopedia of all SQL or Google Sheets syntax, I've focused on focusing on the most frequently used concepts in my work . I plan to continually update the course based on feedback and course reviews to address any areas I may have missed.


Lecture Features📑

✅ Rather than focusing on theory, we have created a system that focuses on possible examples to help you think about the relevant situations.

We provide practice files so that you can practice along with them rather than just looking at them.

✅ It is made in the form of an e-book , focusing on code for easy reading .

✅ We have included simple images as shown below to help students understand.


Previous lecture review✨

From data extraction to practice using SQL Select syntax

Q&A 🙋‍♀️

Q. How is this different from previous lectures?
A. I created this book by selecting only the grammar and functions I use in my field. Therefore, I tried to include only the essentials, rather than everything.

Q. What relational databases do you deal with?
A. This course focuses on MySQL, but most other SQLs can be applied as well.

Q. Does it also include a section on query tuning?
A. This course is for basic data extraction and analysis and does not include content on query tuning.

Q. Is the SQL installation method also included?
A. We have created and enclosed PDF reference materials for MacOS and Windows, but please note that we cannot accommodate all students' PC or OS conditions.

Recommended for
these people

Who is this course right for?

  • Marketers and planners who no longer want to ask for data extraction

  • For those who dream of becoming a data analyst for a service company

Need to know before starting?

  • doesn't exist

Hello
This is

9,869

Learners

442

Reviews

15

Answers

4.8

Rating

8

Courses

- 현) KREAM 데이터 분석가

- 전) ABLY 데이터 분석가

- 전) wadiz 데이터 분석가

- 전) XIILab 인공지능개발팀 선임연구원

- 전) 아라종합기술 수치모델링1팀 사원

- 인하대학교 해양과학과 (학/석)

Curriculum

All

17 lectures

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

3 reviews

4.7

3 reviews

  • hjb38803012님의 프로필 이미지
    hjb38803012

    Reviews 5

    Average Rating 5.0

    5

    100% enrolled

    I was worried at first because the lectures were in document format and not video format, but I think it's actually better because it's in document format for reviewing or looking up parts I forgot!

    • pbj0812
      Instructor

      Thank you!!! For me, it was my first time trying a document format rather than a video, so I was worried, Thank you for your kind words!!!

  • realfriend891451님의 프로필 이미지
    realfriend891451

    Reviews 3

    Average Rating 5.0

    5

    100% enrolled

    This lecture is simple but contains all the necessary information.

    • pbj0812
      Instructor

      Thank you for your words!!!!!!!

  • shsong2460님의 프로필 이미지
    shsong2460

    Reviews 1

    Average Rating 4.0

    4

    100% enrolled

    It's really good

$15.40

pbj0812's other courses

Check out other courses by the instructor!

Similar courses

Explore other courses in the same field!