[Down]   Sv-Diary   / 23.01.2022 / [ www.svti.sk ]
[1] GLITCH: About SQL - az sql-ről - o sql - o sql - o sql ==> [ Youtube - Source GLITCH]
[2] SQL = communication with database - SQL = kommunikáció az adatbázissal
- SQL = komunikácia s databázou - SQL = komunikacja z bazš danych - SQL = komunikace s databází
[3] 2 tables - 2 asztal - 2 tabužky - 2 tabele - 2 tabulky
lego_people and lego_height
[4] SELECT name FROM lego_people
[5] SELECT name from 1st table
[6] SELECT name from 2nd table
[7] Table lego_height (where is cm column)
[8] SELECT name FROM lego_height cm > 3
[9] Result cm > 3
[10] 2 tables - combination height and age
[11] SELECT name, age FROM people LEFT JOIN lego height USING (name)
[12] Result
[13] The two matching by the names in each table
[14] How to add Joe, whose age is 12 to lego_people table
[15] INSERT INTO lego_people (name, age) VALUES ('JOE',12)
[16] Make Joe 13
[17] Make Joe 13 in lego_peoble table
[18] UPDATE lego_people SET name='Joe',13
[19] DELETE Joe: DELETE FROM lego_people WHERE name='Joe'
[20] You should learn SQL
[21] There are several varioations of SQL
[22] Different data SQL databases in companies
[23] SQL only speaks to a specific kond of databases
[24] SQL is mostly related to RELATIONAL DATABASES
[25] RELATIONAL DATABASE is a tabullar schema (consisting of several related tables
- a model introduced by E.F.COD)
[1] GLITCH: About SQL - az sql-ről - o sql - o sql - o sql ==> [ Youtube - Source GLITCH]   | EDUPORT |   EN - Databases | https://eduport.stuba.sk/EN/EDUPACKS/SQL/HP_jan2022_EDU_EN_001.png


[2] SQL = communication with database - SQL = kommunikáció az adatbázissal
- SQL = komunikácia s databázou - SQL = komunikacja z bazš danych - SQL = komunikace s databází   | EDUPORT |   EN - Databases | https://eduport.stuba.sk/EN/EDUPACKS/SQL/HP_jan2022_EDU_EN_002.png


[3] 2 tables - 2 asztal - 2 tabužky - 2 tabele - 2 tabulky
lego_people and lego_height   | EDUPORT |   EN - Databases | https://eduport.stuba.sk/EN/EDUPACKS/SQL/HP_jan2022_EDU_EN_003.png


[4] SELECT name FROM lego_people   | EDUPORT |   EN - Databases | https://eduport.stuba.sk/EN/EDUPACKS/SQL/HP_jan2022_EDU_EN_004.png


[5] SELECT name from 1st table   | EDUPORT |   EN - Databases | https://eduport.stuba.sk/EN/EDUPACKS/SQL/HP_jan2022_EDU_EN_005.png


[6] SELECT name from 2nd table   | EDUPORT |   EN - Databases | https://eduport.stuba.sk/EN/EDUPACKS/SQL/HP_jan2022_EDU_EN_006.png


[7] Table lego_height (where is cm column)   | EDUPORT |   EN - Databases | https://eduport.stuba.sk/EN/EDUPACKS/SQL/HP_jan2022_EDU_EN_007.png


[8] SELECT name FROM lego_height cm > 3   | EDUPORT |   EN - Databases | https://eduport.stuba.sk/EN/EDUPACKS/SQL/HP_jan2022_EDU_EN_008.png


[9] Result cm > 3   | EDUPORT |   EN - Databases | https://eduport.stuba.sk/EN/EDUPACKS/SQL/HP_jan2022_EDU_EN_009.png


[10] 2 tables - combination height and age   | EDUPORT |   EN - Databases | https://eduport.stuba.sk/EN/EDUPACKS/SQL/HP_jan2022_EDU_EN_010.png


[11] SELECT name, age FROM people LEFT JOIN lego height USING (name)   | EDUPORT |   EN - Databases | https://eduport.stuba.sk/EN/EDUPACKS/SQL/HP_jan2022_EDU_EN_011.png


[12] Result   | EDUPORT |   EN - Databases | https://eduport.stuba.sk/EN/EDUPACKS/SQL/HP_jan2022_EDU_EN_012.png


[13] The two matching by the names in each table   | EDUPORT |   EN - Databases | https://eduport.stuba.sk/EN/EDUPACKS/SQL/HP_jan2022_EDU_EN_013.png


[14] How to add Joe, whose age is 12 to lego_people table   | EDUPORT |   EN - Databases | https://eduport.stuba.sk/EN/EDUPACKS/SQL/HP_jan2022_EDU_EN_014.png


[15] INSERT INTO lego_people (name, age) VALUES ('JOE',12)   | EDUPORT |   EN - Databases | https://eduport.stuba.sk/EN/EDUPACKS/SQL/HP_jan2022_EDU_EN_015.png


[16] Make Joe 13   | EDUPORT |   EN - Databases | https://eduport.stuba.sk/EN/EDUPACKS/SQL/HP_jan2022_EDU_EN_016.png


[17] Make Joe 13 in lego_peoble table   | EDUPORT |   EN - Databases | https://eduport.stuba.sk/EN/EDUPACKS/SQL/HP_jan2022_EDU_EN_017.png


[18] UPDATE lego_people SET name='Joe',13   | EDUPORT |   EN - Databases | https://eduport.stuba.sk/EN/EDUPACKS/SQL/HP_jan2022_EDU_EN_018.png


[19] DELETE Joe: DELETE FROM lego_people WHERE name='Joe'   | EDUPORT |   EN - Databases | https://eduport.stuba.sk/EN/EDUPACKS/SQL/HP_jan2022_EDU_EN_019.png


[20] You should learn SQL   | EDUPORT |   EN - Databases | https://eduport.stuba.sk/EN/EDUPACKS/SQL/HP_jan2022_EDU_EN_020.png


[21] There are several varioations of SQL   | EDUPORT |   EN - Databases | https://eduport.stuba.sk/EN/EDUPACKS/SQL/HP_jan2022_EDU_EN_021.png


[22] Different data SQL databases in companies   | EDUPORT |   EN - Databases | https://eduport.stuba.sk/EN/EDUPACKS/SQL/HP_jan2022_EDU_EN_022.png


[23] SQL only speaks to a specific kond of databases   | EDUPORT |   EN - Databases | https://eduport.stuba.sk/EN/EDUPACKS/SQL/HP_jan2022_EDU_EN_023.png


[24] SQL is mostly related to RELATIONAL DATABASES   | EDUPORT |   EN - Databases | https://eduport.stuba.sk/EN/EDUPACKS/SQL/HP_jan2022_EDU_EN_024.png


[25] RELATIONAL DATABASE is a tabullar schema (consisting of several related tables
- a model introduced by E.F.COD)   | EDUPORT |   EN - Databases | https://eduport.stuba.sk/EN/EDUPACKS/SQL/HP_jan2022_EDU_EN_025.png


[TOP]   <=   Záznam z: C:\SV\SEND * 23.01.2022 : 16:07:07