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