강의

멘토링

로드맵

Programming

/

Database

SQL for Marketers

This is a SQL lecture designed to help marketers learn SQL easily. We introduce the essential SQL grammar and analyze real data obtained from Kaggle.

(4.0) 4 reviews

46 learners

  • kwangsung
SQL

What you will learn!

  • Understanding SQL Basics

  • How to upload a file to a database

  • Sales data analysis using SQL

Learn the basic SQL grammar required by marketers ,
Let's proceed with the analysis using actual data .

subject

  • Learn the SQL grammar that marketers need .
  • Let's analyze real data using the grammar we learned.
  • We develop hypotheses and test them with data.

Why should I learn SQL?

  • SQL is the language that drives the database .
  • Data, which is the core of a company, is managed in a database.
  • Knowing SQL allows you to leverage databases to validate insights and hypotheses without any additional processing.

What will I learn in this lecture?

  • Learn basic SQL grammar .
  • Let's combine basic grammar to analyze real data.

Lecture Features

  • Learn SQL syntax for data analysis .
  • You can easily get started with SQL by focusing on basic grammar while omitting complex, advanced grammar.

What tools do you use?

  • PostgreSQL
  • NetBeans
  • All tools are free, so you can use them without any burden.

Can non-majors also take the course?

  • For non-majors, we covered simple SQL grammar.
  • You will learn how basic grammar is used while working with real data.

Recommended for
these people

Who is this course right for?

  • Marketers who want to analyze with numbers, not feelings

  • Anyone who wants to learn SQL

  • Marketers who want to learn SQL

Hello
This is

5,058

Learners

118

Reviews

29

Answers

3.8

Rating

9

Courses

  • 현) 리얼메이커 수석 개발자
  • 전) CCG 수석 개발자
  • 전) VARDOT 소프트웨어 엔지니어, 드루팔 개발자
  • 전) 반도체 에칭 시뮬레이션 책임 개발자

Curriculum

All

23 lectures ∙ (3hr 30min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

4 reviews

4.0

4 reviews

  • geonwoo님의 프로필 이미지
    geonwoo

    Reviews 2

    Average Rating 5.0

    5

    100% enrolled

    In the beginning, since it was the same SQL grammar, my skills didn't improve much, but at the end, the questions that came up during data analysis and the method of analyzing data were explained well in the form of queries, which was very helpful. Thank you.

    • kwangsung
      Instructor

      thank you

  • mjlee3331님의 프로필 이미지
    mjlee3331

    Reviews 1

    Average Rating 4.0

    4

    100% enrolled

    It was good that it was explained in an easy-to-understand way since it was my first time learning it! However, I think it would have been better if the parts where I modified or searched the query statement in the middle of the class were edited and done more neatly!

    • insomnis2020님의 프로필 이미지
      insomnis2020

      Reviews 5

      Average Rating 4.8

      4

      100% enrolled

      30,000 won seems a bit expensive, but since there are not many people who teach PostgreSQL, there are some alternatives. Still, the lecture was good because it was short and concise.

      • kwangsung
        Instructor

        Thank you for your evaluation.

    • gshwang1110님의 프로필 이미지
      gshwang1110

      Reviews 2

      Average Rating 4.0

      3

      100% enrolled

      The sound quality...

      • kwangsung
        Instructor

        Sorry, I'll try to improve the sound quality.

    $26.40

    kwangsung's other courses

    Check out other courses by the instructor!

    Similar courses

    Explore other courses in the same field!