[春のDojo祭り'23] いまからでも遅くない！データベース超入門ハンズオン編

IBM Developer

2 Customer Success, IBM Technology, Japan / © 2023 IBM
Corporation

Corporation

Corporation (DB) ..

Corporation

Corporation 2

Corporation

Corporation SQL

Corporation .. SQL

Corporation

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

Corporation ※ SQL show databases;

Corporation - 1 test

Corporation - 1 CREATE TABLE Test(id int, title text); SQL ( ) SQL( ) CREATE TABLE [ ]([ 1] [ ], [ 2] [ ]..); SQL

Corporation - 1 INSERT INTO Test(id, title) VALUES (1," "); SQL ( ) SQL( ) INSERT INTO [ ]([ 1], [ 2]..) VALUES ([ 1],[ 2]..); SQL

Corporation - 1 SELECT * FROM Test; SQL ( ) SQL( ) SELECT [ ] FROM [ ]; SQL

Corporation - 2

Corporation - 2 UPDATE Test SET title=" "; SQL ( ) SQL( ) UPDATE [ ] SET =“[ ]"; SQL

Corporation - 2 ALTER TABLE Test RENAME COLUMN title TO greeting; SQL ( ) SQL( ) ALTER TABLE [ ] RENAME COLUMN [ ] TO [ ]; SQL

Corporation - 3

Corporation - 3 DELETE FROM Test; SQL ( ) SQL( ) DELETE FROM [ ] SQL

Corporation - 3 SQL( ) DROP TABLE Test; SQL ( ) DROP TABLE [ ]; SQL

Corporation - 4

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

Corporation - 4 SELECT [ ] FROM [ ] WHERE [ ]; SQL SELECT * FROM Test WHERE id= 2; UPDATE [ ] SET title=" [ ] " WHERE [ ]; UPDATE Test SET title= " " where id = 2;

Corporation - 4 SELECT [ ] FROM [ ] ORDER BY [ ] [ or ] SQL ORDER BY SELECT * FROM Test ORDER BY id DESC; ※ ASC DESC

Corporation SELECT No, , , … FROM sales WHERE = 3/15 Sales

Corporation

Corporation RDB NoSQL

[春のDojo祭り'23] いまからでも遅くない！データベース超入門 ハンズオン編

[春のDojo祭り'23] いまからでも遅くない！データベース超入門 ハンズオン編

More Decks by Kwangsoo Lee

Other Decks in Technology

Featured

Transcript

[春のDojo祭り'23] いまからでも遅くない！データベース超入門ハンズオン編

[春のDojo祭り'23] いまからでも遅くない！データベース超入門ハンズオン編