Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Features
Speaker Deck
PRO
Sign in
Sign up for free
Search
Search
[春のDojo祭り'23] いまからでも遅くない!データベース超入門 ハンズオン編
Search
Kwangsoo Lee
May 30, 2023
Technology
2
610
[春のDojo祭り'23] いまからでも遅くない!データベース超入門 ハンズオン編
2023/5/29開催Dojoの資料です。
Kwangsoo Lee
May 30, 2023
Tweet
Share
More Decks by Kwangsoo Lee
See All by Kwangsoo Lee
準備で決まる!現行踏襲で終わらせないシステム再構築にむけて
leekwangsoo1995
0
240
RPAの基礎を学ぼう~業務自動化超入門~
leekwangsoo1995
0
540
Other Decks in Technology
See All in Technology
強化されたAmazon Location Serviceによる新機能と開発者体験
dayjournal
3
220
MySQL5.6から8.4へ 戦いの記録
kyoshidaxx
1
260
PHPでWebブラウザのレンダリングエンジンを実装する
dip_tech
PRO
0
210
rubygem開発で鍛える設計力
joker1007
2
220
AWS アーキテクチャ作図入門/aws-architecture-diagram-101
ma2shita
30
11k
M3 Expressiveの思想に迫る
chnotchy
0
110
生成AI時代 文字コードを学ぶ意義を見出せるか?
hrsued
1
580
急成長を支える基盤作り〜地道な改善からコツコツと〜 #cre_meetup
stefafafan
0
130
Understanding_Thread_Tuning_for_Inference_Servers_of_Deep_Models.pdf
lycorptech_jp
PRO
0
140
解析の定理証明実践@Lean 4
dec9ue
0
180
Prox Industries株式会社 会社紹介資料
proxindustries
0
320
セキュリティの民主化は何故必要なのか_AWS WAF 運用の 10 の苦悩から学ぶ
yoh
1
180
Featured
See All Featured
Balancing Empowerment & Direction
lara
1
380
Performance Is Good for Brains [We Love Speed 2024]
tammyeverts
10
930
Optimising Largest Contentful Paint
csswizardry
37
3.3k
Rails Girls Zürich Keynote
gr2m
94
14k
Evolution of real-time – Irina Nazarova, EuRuKo, 2024
irinanazarova
8
800
Done Done
chrislema
184
16k
The Success of Rails: Ensuring Growth for the Next 100 Years
eileencodes
45
7.5k
Helping Users Find Their Own Way: Creating Modern Search Experiences
danielanewman
29
2.7k
Intergalactic Javascript Robots from Outer Space
tanoku
271
27k
Bash Introduction
62gerente
614
210k
Why Our Code Smells
bkeepers
PRO
337
57k
The Straight Up "How To Draw Better" Workshop
denniskardys
234
140k
Transcript
IBM Developer
2 Customer Success, IBM Technology, Japan / © 2023 IBM
Corporation
3 Customer Success, IBM Technology, Japan / © 2023 IBM
Corporation
4 Customer Success, IBM Technology, Japan / © 2023 IBM
Corporation
5 Customer Success, IBM Technology, Japan / © 2023 IBM
Corporation
6 Customer Success, IBM Technology, Japan / © 2023 IBM
Corporation
7 Customer Success, IBM Technology, Japan / © 2023 IBM
Corporation
8 Customer Success, IBM Technology, Japan / © 2023 IBM
Corporation (DB) ..
9 Customer Success, IBM Technology, Japan / © 2023 IBM
Corporation
10 Customer Success, IBM Technology, Japan / © 2023 IBM
Corporation
11 Customer Success, IBM Technology, Japan / © 2023 IBM
Corporation 2
12 Customer Success, IBM Technology, Japan / © 2023 IBM
Corporation 2
13 Customer Success, IBM Technology, Japan / © 2023 IBM
Corporation
14 Customer Success, IBM Technology, Japan / © 2023 IBM
Corporation SQL
15 Customer Success, IBM Technology, Japan / © 2023 IBM
Corporation SQL
16 Customer Success, IBM Technology, Japan / © 2023 IBM
Corporation .. SQL
17 Customer Success, IBM Technology, Japan / © 2023 IBM
Corporation .. SQL
18 Customer Success, IBM Technology, Japan / © 2023 IBM
Corporation
19 Customer Success, IBM Technology, Japan / © 2023 IBM
Corporation Paiza.io https://paiza.io/ja/projects/new?language=mysql myCompiler https://www.mycompiler.io/es/new/mysql trysql_editor https://www.w3schools.com/mySQl/trymysql.asp?filename=trysql_editor OneCompiler https://onecompiler.com/mysql
20 Customer Success, IBM Technology, Japan / © 2023 IBM
Corporation ※ SQL show databases;
21 Customer Success, IBM Technology, Japan / © 2023 IBM
Corporation - 1 test
22 Customer Success, IBM Technology, Japan / © 2023 IBM
Corporation - 1 CREATE TABLE Test(id int, title text); SQL ( ) SQL( ) CREATE TABLE [ ]([ 1] [ ], [ 2] [ ]..); SQL
23 Customer Success, IBM Technology, Japan / © 2023 IBM
Corporation - 1 INSERT INTO Test(id, title) VALUES (1," "); SQL ( ) SQL( ) INSERT INTO [ ]([ 1], [ 2]..) VALUES ([ 1],[ 2]..); SQL
24 Customer Success, IBM Technology, Japan / © 2023 IBM
Corporation - 1 SELECT * FROM Test; SQL ( ) SQL( ) SELECT [ ] FROM [ ]; SQL
25 Customer Success, IBM Technology, Japan / © 2023 IBM
Corporation - 2
26 Customer Success, IBM Technology, Japan / © 2023 IBM
Corporation - 2 UPDATE Test SET title=" "; SQL ( ) SQL( ) UPDATE [ ] SET =“[ ]"; SQL
27 Customer Success, IBM Technology, Japan / © 2023 IBM
Corporation - 2 ALTER TABLE Test RENAME COLUMN title TO greeting; SQL ( ) SQL( ) ALTER TABLE [ ] RENAME COLUMN [ ] TO [ ]; SQL
28 Customer Success, IBM Technology, Japan / © 2023 IBM
Corporation - 3
29 Customer Success, IBM Technology, Japan / © 2023 IBM
Corporation - 3 DELETE FROM Test; SQL ( ) SQL( ) DELETE FROM [ ] SQL
30 Customer Success, IBM Technology, Japan / © 2023 IBM
Corporation - 3 SQL( ) DROP TABLE Test; SQL ( ) DROP TABLE [ ]; SQL
31 Customer Success, IBM Technology, Japan / © 2023 IBM
Corporation - 4
32 Customer Success, IBM Technology, Japan / © 2023 IBM
Corporation - 4 CREATE TABLE Test(id integer, title text); INSERT INTO Test(id, title) VALUES (1," "); INSERT INTO Test(id, title) VALUES (2," "); SELECT * from Test; SQL
33 Customer Success, IBM Technology, Japan / © 2023 IBM
Corporation - 4 SELECT [ ] FROM [ ] WHERE [ ]; SQL SELECT * FROM Test WHERE id= 2; UPDATE [ ] SET title=" [ ] " WHERE [ ]; UPDATE Test SET title= " " where id = 2;
34 Customer Success, IBM Technology, Japan / © 2023 IBM
Corporation - 4 SELECT [ ] FROM [ ] ORDER BY [ ] [ or ] SQL ORDER BY SELECT * FROM Test ORDER BY id DESC; ※ ASC DESC
35 Customer Success, IBM Technology, Japan / © 2023 IBM
Corporation SELECT No, , , … FROM sales WHERE = 3/15 Sales
36 Customer Success, IBM Technology, Japan / © 2023 IBM
Corporation
37 Customer Success, IBM Technology, Japan / © 2023 IBM
Corporation
38 Customer Success, IBM Technology, Japan / © 2023 IBM
Corporation
39 Customer Success, IBM Technology, Japan / © 2023 IBM
Corporation RDB NoSQL