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
ExaDB-D dbaascli で出来ること
oracle4engineer
PRO
0
2.1k
Databricks における 『MLOps』
databricksjapan
2
170
Java EE/Jakarta EEの現状と将来―クラウドネイティブ時代にJava EEは対応できるのか?―
takakiyo
1
140
アクセシビリティを考慮したUI/CSSフレームワーク・ライブラリ選定
yajihum
2
1k
Kernel MemoryでAzure OpenAI Serviceとお手軽データソース連携
mitsuzono
1
240
長期間TiDBを使ってきた話 @ 私たちはなぜNewSQLを使うのかTiDB選定5社が語る選定理由と活用LT / Experiences with TiDB Over Time
chibiegg
2
890
プロデザ! BY リクルート vol.18_リクルートのリサーチ実践組織「リサーチブーストコミュニティ」
recruitengineers
PRO
3
280
Next'24 事例セッションの紹介とクラウド資格を活用したキャリア形成について語りMuscle
yasumuusan
1
440
SIEMを用いて、セキュリティログ分析の可視化と分析を実現し、PDCAサイクルを回してみた
coconala_engineer
0
280
Cloud Native Java with Spring Boot (CNCF Aarhus, April 2024)
thomasvitale
1
170
チームでロジカルシンキングに改めて向き合っている話 〜学習環境と実践⽅法〜
sansantech
PRO
2
2.1k
私が trocco を推す理由
__allllllllez__
1
210
Featured
See All Featured
Typedesign – Prime Four
hannesfritz
36
2.1k
Designing the Hi-DPI Web
ddemaree
276
33k
The Language of Interfaces
destraynor
151
23k
The Psychology of Web Performance [Beyond Tellerrand 2023]
tammyeverts
6
1.5k
Helping Users Find Their Own Way: Creating Modern Search Experiences
danielanewman
20
1.9k
XXLCSS - How to scale CSS and keep your sanity
sugarenia
241
1.2M
BBQ
matthewcrist
80
8.8k
Building Effective Engineering Teams - LeadDev
addyosmani
28
1.8k
From Idea to $5000 a Month in 5 Months
shpigford
377
45k
Infographics Made Easy
chrislema
238
18k
Building Better People: How to give real-time feedback that sticks.
wjessup
355
18k
RailsConf & Balkan Ruby 2019: The Past, Present, and Future of Rails at GitHub
eileencodes
125
32k
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