강의

멘토링

커뮤니티

Data Science

/

Data Analysis

SQL Basics from a Silicon Valley Data Leader

If you work with data, SQL is a fundamental skill you must know. In this course, we will learn SQL from a data analysis perspective, focusing on hands-on practice. The practice will be conducted in Google Colab using DuckDB.

(5.0) 6 reviews

74 learners

  • keeyonghan9539
이론 실습 모두
실무적용
데이터분석
sql
SQL
Data literacy
Data Engineering
Big Data
DBMS/RDBMS

Reviews from Early Learners

What you will gain after the course

  • SQL syntax and data analysis skills using SQL

  • How to use the DuckDB data warehouse

Learn from a 30-year Silicon Valley data expert
Practical SQL for Data Analysis

Hello. I am Ki-Yong Han, a Silicon Valley data expert with 30 years of experience. After starting my career at Samsung Electronics, I left for Silicon Valley at the age of 31. I share my knowledge of data warehouses and SQL based on the know-how I gained from building data teams at organizations such as Udemy (listed on NASDAQ in 2021) and Polyvore (acquired by Yahoo in 2015) and providing data consulting to various Silicon Valley and Korean companies.


How do we handle data in practice?
Can I solve this by just learning SQL grammar ?

•••

No it is not

Practical SQL must be learned from a data analysis perspective


When and which SQL syntax to use
We present a “logical approach”

SQL is a core tool for data management and analysis. SQL is used in all processes of designing databases, creating tables, extracting necessary data, and analyzing them. Therefore, you should start by understanding the database and table structure. In other words , when you understand how data is organized and stored, you can develop the ability to use various SQL grammars appropriately for the situation .

Lecture Features

The most widely used and easiest to install practice environment

This lecture uses DuckDB, the most widely used embedded data warehouse database, and Google Colab as a practice environment. In many cases, if it is paid or the installation is complicated, setting up the practice environment itself can be a big obstacle to learning. For that reason, we have set up a practice environment that is easy to install but meaningful enough to know.


Data analysis tips for practical use

We will explain using a practice table similar to the user data that you will frequently encounter in practice. We will introduce data analysis tips for marketing, such as Google Analytics’ session, customer satisfaction measurement method (NPS), and how to check data quality.

SQL problem solving with 5 real-life examples

We have included 5 data analysis cases that are frequently experienced when operating a service. For each case, we will examine the table schema and practice SQL step by step. We will cover join strategies that can be applied without difficulty to any database, group rankings, and aggregate functions such as partion by and group by.


How to use artificial intelligence for data analysis

In the bonus section, we will walk you through the process of presenting SQL problem texts to ChatGPT, Claude, and Gemini and receiving and verifying the results. We hope you will gain insight into how to improve the efficiency of data analysis with AI.
(This section will continue to be updated with additional classes.)


Recommended for
these people

Who is this course right for?

  • Data Analyst, Data Engineer, Data Scientist

  • Anyone who needs to do data analysis, regardless of their job title or field.

Need to know before starting?

  • Experience using SQL SELECT

Hello
This is

999

Learners

64

Reviews

40

Answers

4.9

Rating

5

Courses

컴퓨터 공학 석사 후 삼성전자에서 시작된 커리어가 친구덕에 실리콘밸리로 이어져 지난 29년간 13개의 다양한 스테이지의 회사를 다녔습니다 (창업, 대기업들, 다수의 스타트업들).

  • 야후: 엔지니어링 디렉터로 검색엔진 개발.

  • 유데미. 데이터팀을 처음 만들어 30명까지 성장. 2021년 10월에 나스닥 상장

  • 삼성전자

  • ...

중간에 11개월 쉬어보기도 했고 본의 아니게 엔젤투자자(Chartmetric, Goodtime.io, Select Star, EO, 비지니스 캔버스, ...), 어드바이저(몰로코, 블라인드, 월급쟁이부자들, ...), 컨설팅(SK텔레콤, 현대카드, 이마트 등등) 등의 역할을 하면서 나만의 브랜드를 만들었습니다. 실패를 실패가 아닌 교훈으로 보는 긍정의 힘과 꾸준함이라는 복리의 힘을 믿습니다.

https://www.linkedin.com/in/keeyonghan/

유투브 채널

월급쟁이부자들 강의

Curriculum

All

38 lectures ∙ (7hr 6min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

6 reviews

5.0

6 reviews

  • 100yen님의 프로필 이미지
    100yen

    Reviews 23

    Average Rating 4.8

    5

    71% enrolled

    本当にたくさん学べた講義でした。いつもDBAが行うデータ分析はどのような仕事なのか漠然と気になっていましたが、役割に対する考えを広げることができる機会でした。知らずに使っていたSQLももっと理解できるようになりました。特に、セッションでチャネル分析をするのは本当に興味深かったです。あのようにデータを収集するんですね..!! まだジュニアレベルだからか、とても新鮮で面白かったです。もっと一生懸命学んでみます。ありがとうございます、ギヨンさん!!

    • keeyonghan9539
      Instructor

      詳しい受講レビューありがとうございます。もしデータ収集の方に興味がおありでしたら、Airflow講座もおすすめします。Pythonの知識が少し必要ですが、ChatGPT等に聞きながら学習すれば、思ったよりそれほど難しくないと信じています。応援しています!

  • abcd123123님의 프로필 이미지
    abcd123123

    Reviews 326

    Average Rating 5.0

    5

    100% enrolled

    • sadego님의 프로필 이미지
      sadego

      Reviews 5

      Average Rating 4.2

      5

      32% enrolled

      • keeyonghan9539
        Instructor

        ありがとうございます。もし何かご不明な点がございましたら、ご遠慮なくご質問ください。

    • ppq3905303님의 프로필 이미지
      ppq3905303

      Reviews 3

      Average Rating 5.0

      5

      100% enrolled

      データ関連の勉強をされている方は、この講義を優先して勉強されるのが良いと思います...!! SQLをなぜ学ぶのか、各々の文法の役割は何なのか、分からないときにどうすれば良いのかなど、入門者や初級者にとって気になる部分をうまく掻いてくれる良い講義です!!

      • keeyonghan9539
        Instructor

        ありがとうございます!もしご不明な点がありましたら、お気軽にご質問ください。そして、3週間前にAirflowの講義もアップしました。2週間後にはSparkの講義もアップする予定で、検索エンジンとレコメンドエンジン、そしてABテストに関する講義も引き続きアップしていく予定です。引き続きご関心をお寄せいただけますと幸いです。

    • hsjang5717님의 프로필 이미지
      hsjang5717

      Reviews 2

      Average Rating 5.0

      5

      32% enrolled

      長年の実務経験+大学講義の良いところだけをぎゅっと凝縮....ただ構文を暗記して機械的に学習するのではなく、なぜこの文法を使うのかという原理を教えてくださるので、とても良いです...!

      $55.00

      keeyonghan9539's other courses

      Check out other courses by the instructor!

      Similar courses

      Explore other courses in the same field!