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
520
[春の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
150
RPAの基礎を学ぼう~業務自動化超入門~
leekwangsoo1995
0
470
Other Decks in Technology
See All in Technology
Tellus の衛星データを見てみよう #mf_fukuoka
kongmingstrap
0
240
生産性向上チームの紹介
cybozuinsideout
PRO
1
890
BPStudyの200回を中心にIT業界を振り返る。そしてこれから
haru860
3
300
AWS学習者向けにAzureの解説スライドを作成した話
handy
2
100
VSCodeの拡張機能を作っている話
ebarakazuhiro
1
660
TechFeed Experts Night#27 〜 フロントエンドフレームワーク最前線 (Svelte)
baseballyama
1
550
LangSmith入門―トレース/評価/プロンプト管理などを担うLLMアプリ開発プラットフォーム
os1ma
4
500
ServiceNow Knowledge 24の歩き方 EYストラテジー・アンド・コンサルティング
manarobot
0
200
いつか使うかも貯金してたらめちゃめちゃ機能が増えてた話
riyaamemiya
0
440
EMとして2023年度に頑張ったこと / What we did well in FY2023 as a EM
pauli
1
180
ワールドカフェI /チューターを改良する / World Café I and Improving the Tutors
ks91
PRO
0
130
MapLibreとAmazon Location Service
dayjournal
1
160
Featured
See All Featured
[RailsConf 2023] Rails as a piece of cake
palkan
23
4k
Build your cross-platform service in a week with App Engine
jlugia
225
17k
Bash Introduction
62gerente
604
210k
GraphQLとの向き合い方2022年版
quramy
32
12k
Product Roadmaps are Hard
iamctodd
44
9.7k
Fashionably flexible responsive web design (full day workshop)
malarkey
398
65k
ParisWeb 2013: Learning to Love: Crash Course in Emotional UX Design
dotmariusz
104
6.6k
Templates, Plugins, & Blocks: Oh My! Creating the theme that thinks of everything
marktimemedia
19
1.7k
Keith and Marios Guide to Fast Websites
keithpitt
408
22k
Building Flexible Design Systems
yeseniaperezcruz
319
37k
Pencils Down: Stop Designing & Start Developing
hursman
117
11k
Optimizing for Happiness
mojombo
370
69k
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