Upgrade to Pro — share decks privately, control downloads, hide ads and more …

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

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

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

Kwangsoo Lee

May 30, 2023
Tweet

More Decks by Kwangsoo Lee

Other Decks in Technology

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