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

2023/5/29開催Dojoの資料です。

Transcript

1. IBM Developer
   

   View Slide

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

   View Slide

3. 3
   Customer Success, IBM Technology, Japan / © 2023 IBM Corporation
   

   View Slide

4. 4
   Customer Success, IBM Technology, Japan / © 2023 IBM Corporation
   

   View Slide

5. 5
   Customer Success, IBM Technology, Japan / © 2023 IBM Corporation
   

   View Slide

6. 6
   Customer Success, IBM Technology, Japan / © 2023 IBM Corporation
   

   View Slide

7. 7
   Customer Success, IBM Technology, Japan / © 2023 IBM Corporation
   

   View Slide

8. 8
   Customer Success, IBM Technology, Japan / © 2023 IBM Corporation
   (DB) ..
   

   View Slide

9. 9
   Customer Success, IBM Technology, Japan / © 2023 IBM Corporation
   

   View Slide

10. 10
    Customer Success, IBM Technology, Japan / © 2023 IBM Corporation
    

    View Slide

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

    View Slide

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

    View Slide

13. 13
    Customer Success, IBM Technology, Japan / © 2023 IBM Corporation
    

    View Slide

14. 14
    Customer Success, IBM Technology, Japan / © 2023 IBM Corporation
    SQL
    

    View Slide

15. 15
    Customer Success, IBM Technology, Japan / © 2023 IBM Corporation
    SQL
    

    View Slide

16. 16
    Customer Success, IBM Technology, Japan / © 2023 IBM Corporation .. SQL
    

    View Slide

17. 17
    Customer Success, IBM Technology, Japan / © 2023 IBM Corporation .. SQL
    

    View Slide

18. 18
    Customer Success, IBM Technology, Japan / © 2023 IBM Corporation
    

    View Slide

19. 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
    

    View Slide

20. 20
    Customer Success, IBM Technology, Japan / © 2023 IBM Corporation
    ※ SQL
    show databases;
    

    View Slide

21. 21
    Customer Success, IBM Technology, Japan / © 2023 IBM Corporation
    - 1
    test
    

    View Slide

22. 22
    Customer Success, IBM Technology, Japan / © 2023 IBM Corporation
    - 1
    CREATE TABLE Test(id int, title text);
    SQL
    ( )
    SQL( )
    CREATE TABLE [ ]([ 1] [ ], [ 2] [ ]..);
    SQL
    

    View Slide

23. 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
    

    View Slide

24. 24
    Customer Success, IBM Technology, Japan / © 2023 IBM Corporation
    - 1
    SELECT * FROM Test;
    SQL
    ( )
    SQL( )
    SELECT [ ] FROM [ ];
    SQL
    

    View Slide

25. 25
    Customer Success, IBM Technology, Japan / © 2023 IBM Corporation
    - 2
    

    View Slide

26. 26
    Customer Success, IBM Technology, Japan / © 2023 IBM Corporation
    - 2
    UPDATE Test SET title=" ";
    SQL
    ( )
    SQL( )
    UPDATE [ ] SET =“[ ]";
    SQL
    

    View Slide

27. 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
    

    View Slide

28. 28
    Customer Success, IBM Technology, Japan / © 2023 IBM Corporation
    - 3
    

    View Slide

29. 29
    Customer Success, IBM Technology, Japan / © 2023 IBM Corporation
    - 3
    DELETE FROM Test;
    SQL
    ( )
    SQL( )
    DELETE FROM [ ]
    SQL
    

    View Slide

30. 30
    Customer Success, IBM Technology, Japan / © 2023 IBM Corporation
    - 3
    SQL( )
    DROP TABLE Test;
    SQL
    ( )
    DROP TABLE [ ];
    SQL
    

    View Slide

31. 31
    Customer Success, IBM Technology, Japan / © 2023 IBM Corporation
    - 4
    

    View Slide

32. 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
    

    View Slide

33. 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;
    

    View Slide

34. 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
    

    View Slide

35. 35
    Customer Success, IBM Technology, Japan / © 2023 IBM Corporation
    SELECT No, , , … FROM sales WHERE = 3/15
    Sales
    

    View Slide

36. 36
    Customer Success, IBM Technology, Japan / © 2023 IBM Corporation
    

    View Slide

37. 37
    Customer Success, IBM Technology, Japan / © 2023 IBM Corporation
    

    View Slide

38. 38
    Customer Success, IBM Technology, Japan / © 2023 IBM Corporation
    

    View Slide

39. 39
    Customer Success, IBM Technology, Japan / © 2023 IBM Corporation
    RDB NoSQL
    

    View Slide