sadego

データを扱う人なら必ず知っておくべき基本技術はSQLです。今回の講義では、SQLをデータ分析という観点から実習中心に学習していきます。実習はDuckDBを用いてGoogle Colabで行います。


keeyonghan

シリコンバレーのデータリーダーが教える基礎SQL

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


이론과 실습 한 번에

이론 실습 모두

실무적용

데이터분석

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.


입문

초급

중급이상

Data literacy

Data Engineering

Big Data

데이터베이스 관리 시스템

DBMS/RDBMS

SQL Basics from a Silicon Valley Data Leader

Course Introduction

Introduction to SQL and Data Warehouses

Introduction to DuckDB and Setting Up the Practice Environment

SQL Basics: DDL + SELECT

# Learning GROUP BY, JOIN, and CTAS/CTE/Subquery

## GROUP BY and JOIN and CTAS/CTE/Subquery Learning

Guitar grammar learning and various problem-solving exercises

# Other Advanced SQL Syntax and Transactions

Bonus Learning

Course Completion