Databases & SQL · ⁨데이터베이스 및 SQL⁩

Every lesson runs in your browser — write real code, press Run, and the tasks check themselves. Free, no account needed, with translated notes paired with English. · ⁨모든 수업은 브라우저에서 실행됩니다 — 실제 코드를 작성하고 '실행' 버튼을 누르면 과제가 자동 점검합니다. 무료이며 계정 없이 이용 가능하며, 영문과 짝지어진 번역 메모가 제공됩니다.⁩

Start the course · ⁨과정 시작⁩

Lessons in this course · ⁨이 과정의 수업⁩

No lessons match. Clear the search or choose another filter.

1. history A short history of SQL · ⁨SQL의 짧은 역사⁩ Reading and resources
2. usage What SQL is used for · ⁨SQL이 사용되는 용도⁩ Reading and resources
3. resources Where to learn more · ⁨더 배우는 곳⁩ Reading and resources
4. setup Set up your computer · ⁨컴퓨터 설정하기⁩ Reading and resources
5. 01 Databases and SELECT 2 required tasks Video · ⁨영상⁩
6. 02 Choosing columns 2 required tasks Video · ⁨영상⁩
7. 03 Filtering with WHERE 2 required tasks Video · ⁨영상⁩
8. 04 AND, OR, NOT 2 required tasks Video · ⁨영상⁩
9. 05 Sorting with ORDER BY · ⁨ORDER BY를 이용한 정렬⁩ 2 required tasks Video · ⁨영상⁩
10. 06 Counting and averaging · ⁨계산 및 평균 구하기⁩ 2 required tasks Video · ⁨영상⁩
11. 07 LIKE, IN and BETWEEN 2 required tasks Video · ⁨영상⁩
12. 08 Grouping with GROUP BY · ⁨GROUP BY를 이용한 그룹화⁩ 2 required tasks Video · ⁨영상⁩
13. 09 Tables, keys and relationships · ⁨테이블, 키 및 관계⁩ 2 required tasks Video · ⁨영상⁩
14. 10 INNER JOIN 2 required tasks Video · ⁨영상⁩
15. 11 Joins with grouping 2 required tasks Video · ⁨영상⁩
16. 12 Creating tables 2 required tasks Video · ⁨영상⁩
17. 13 Changing the schema 2 required tasks Video · ⁨영상⁩
18. 14 Inserting rows · ⁨행 삽입⁩ 2 required tasks Video · ⁨영상⁩
19. 15 Updating rows · ⁨행 업데이트⁩ 2 required tasks Video · ⁨영상⁩
20. 16 Deleting rows 2 required tasks Video · ⁨영상⁩
21. 17 Normalisation 2 required tasks Video · ⁨영상⁩

Language reference · ⁨언어 참고 자료⁩

/know/reference/sql