„Adatkezelés” változatai közötti eltérés

* [[Media:adatkezeles_SQL_1_8_2023_teljes.pdf | 9. hét]]: SQL: DDL, DML, DQL; története ([https://bmeedu-my.sharepoint.com/:v:/r/personal/eros_levente_vik_bme_hu/Documents/Stream%20Migrated%20Videos/Adatkezel%C3%A9s,%209.%20el%C5%91ad%C3%A1s,%20SQL%20bevezet%C5%91-20201103_100218.mp4?csf=1&web=1&e=9U5AEG&nav=eyJyZWZlcnJhbEluZm8iOnsicmVmZXJyYWxBcHAiOiJTdHJlYW1XZWJBcHAiLCJyZWZlcnJhbFZpZXciOiJTaGFyZURpYWxvZyIsInJlZmVycmFsQXBwUGxhdGZvcm0iOiJXZWIiLCJyZWZlcnJhbE1vZGUiOiJ2aWV3In19 videó]), CREATE TABLE, data types ([https://bmeedu-my.sharepoint.com/:v:/r/personal/eros_levente_vik_bme_hu/Documents/Stream%20Migrated%20Videos/Adatkezel%C3%A9s,%2010.%20el%C5%91ad%C3%A1s,%20CREATE%20TABLE-20201103_100216.mp4?csf=1&web=1&e=jYC35v&nav=eyJyZWZlcnJhbEluZm8iOnsicmVmZXJyYWxBcHAiOiJTdHJlYW1XZWJBcHAiLCJyZWZlcnJhbFZpZXciOiJTaGFyZURpYWxvZyIsInJlZmVycmFsQXBwUGxhdGZvcm0iOiJXZWIiLCJyZWZlcnJhbE1vZGUiOiJ2aWV3In19 videó]); SELECT & FROM: arithmetic operators, null values, column alias, literal character string, duplicate rows ([https://bmeedu-my.sharepoint.com/:v:/r/personal/eros_levente_vik_bme_hu/Documents/Stream%20Migrated%20Videos/Adatkezel%C3%A9s,%2011.%20el%C5%91ad%C3%A1s,%20SELECT-20201103_100214.mp4?csf=1&web=1&e=tz80z0&nav=eyJyZWZlcnJhbEluZm8iOnsicmVmZXJyYWxBcHAiOiJTdHJlYW1XZWJBcHAiLCJyZWZlcnJhbFZpZXciOiJTaGFyZURpYWxvZyIsInJlZmVycmFsQXBwUGxhdGZvcm0iOiJXZWIiLCJyZWZlcnJhbE1vZGUiOiJ2aWV3In19 videó]); WHERE: dates (TO_DATE()) ([https://bmeedu-my.sharepoint.com/:v:/r/personal/eros_levente_vik_bme_hu/Documents/Stream%20Migrated%20Videos/Adatkezel%C3%A9s,%2012.%20el%C5%91ad%C3%A1s,%20egysoros%20f%C3%BCggv%C3%A9nyek-20201119_073608.mp4?csf=1&web=1&e=p5p7xl&nav=eyJyZWZlcnJhbEluZm8iOnsicmVmZXJyYWxBcHAiOiJTdHJlYW1XZWJBcHAiLCJyZWZlcnJhbFZpZXciOiJTaGFyZURpYWxvZyIsInJlZmVycmFsQXBwUGxhdGZvcm0iOiJXZWIiLCJyZWZlcnJhbE1vZGUiOiJ2aWV3In19 videó]), comparison operators, IN, LIKE, NULL, logical operators, rules of precedence; ORDER BY ([https://bmeedu-my.sharepoint.com/:v:/r/personal/eros_levente_vik_bme_hu/Documents/Stream%20Migrated%20Videos/Adatkezel%C3%A9s,%2015.%20el%C5%91ad%C3%A1s,%20WHERE%20%C3%A9s%20ORDER%20BY-20201119_073625.mp4?csf=1&web=1&e=4ohWcg&nav=eyJyZWZlcnJhbEluZm8iOnsicmVmZXJyYWxBcHAiOiJTdHJlYW1XZWJBcHAiLCJyZWZlcnJhbFZpZXciOiJTaGFyZURpYWxvZyIsInJlZmVycmFsQXBwUGxhdGZvcm0iOiJXZWIiLCJyZWZlcnJhbE1vZGUiOiJ2aWV3In19 videó]); single & multi-row functions: case & character-manipulation functions, number functions (ROUND, TRUNC), date functions ([https://bmeedu-my.sharepoint.com/:v:/r/personal/eros_levente_vik_bme_hu/Documents/Stream%20Migrated%20Videos/Adatkezel%C3%A9s,%2012.%20el%C5%91ad%C3%A1s,%20egysoros%20f%C3%BCggv%C3%A9nyek-20201119_073608.mp4?csf=1&web=1&e=V536Gh&nav=eyJyZWZlcnJhbEluZm8iOnsicmVmZXJyYWxBcHAiOiJTdHJlYW1XZWJBcHAiLCJyZWZlcnJhbFZpZXciOiJTaGFyZURpYWxvZyIsInJlZmVycmFsQXBwUGxhdGZvcm0iOiJXZWIiLCJyZWZlcnJhbE1vZGUiOiJ2aWV3In19 videó]); group functions: AVG, SUM, MIN, MAX, COUNT, HAVING, nesting ([https://bmeedu-my.sharepoint.com/:v:/r/personal/eros_levente_vik_bme_hu/Documents/Stream%20Migrated%20Videos/Adatkezel%C3%A9s,%2013.%20el%C5%91ad%C3%A1s,%20aggreg%C3%A1tumok-20201119_073620.mp4?csf=1&web=1&e=frD8GT&nav=eyJyZWZlcnJhbEluZm8iOnsicmVmZXJyYWxBcHAiOiJTdHJlYW1XZWJBcHAiLCJyZWZlcnJhbFZpZXciOiJTaGFyZURpYWxvZyIsInJlZmVycmFsQXBwUGxhdGZvcm0iOiJXZWIiLCJyZWZlcnJhbE1vZGUiOiJ2aWV3In19 videó])

* 10. hét: az előző hét folytatása: NATURAL JOIN, USING, traditional join, ON, BETWEEN, LEFT / RIGHT / FULL OUTER JOIN, CROSS JOIN ([https://bmeedu-my.sharepoint.com/:v:/r/personal/eros_levente_vik_bme_hu/Documents/Stream%20Migrated%20Videos/Adatkezel%C3%A9s,%2014.%20el%C5%91ad%C3%A1s,%20join-20201119_073622.mp4?csf=1&web=1&e=k59rWz&nav=eyJyZWZlcnJhbEluZm8iOnsicmVmZXJyYWxBcHAiOiJTdHJlYW1XZWJBcHAiLCJyZWZlcnJhbFZpZXciOiJTaGFyZURpYWxvZyIsInJlZmVycmFsQXBwUGxhdGZvcm0iOiJXZWIiLCJyZWZlcnJhbE1vZGUiOiJ2aWV3In19 videó]); subqueries: syntax, in-line view, single- / multiple-row query, subqueries, ANY, ALL, NOT IN, NVL ([https://bmeedu-my.sharepoint.com/:v:/r/personal/eros_levente_vik_bme_hu/Documents/Stream%20Migrated%20Videos/Adatkezel%C3%A9s,%2016.%20el%C5%91ad%C3%A1s,%20allek%C3%A9rdez%C3%A9sek-20201117_013514.mp4?csf=1&web=1&e=d8Tspe&nav=eyJyZWZlcnJhbEluZm8iOnsicmVmZXJyYWxBcHAiOiJTdHJlYW1XZWJBcHAiLCJyZWZlcnJhbFZpZXciOiJTaGFyZURpYWxvZyIsInJlZmVycmFsQXBwUGxhdGZvcm0iOiJXZWIiLCJyZWZlcnJhbE1vZGUiOiJ2aWV3In19 videó]); set operators: UNION (ALL), INTERSECT, MINUS ([https://bmeedu-my.sharepoint.com/:v:/r/personal/eros_levente_vik_bme_hu/Documents/Stream%20Migrated%20Videos/Adatkezel%C3%A9s,%2017.%20el%C5%91ad%C3%A1s,%20halmazm%C5%B1veletek-20201117_013517.mp4?csf=1&web=1&e=phE7Uf&nav=eyJyZWZlcnJhbEluZm8iOnsicmVmZXJyYWxBcHAiOiJTdHJlYW1XZWJBcHAiLCJyZWZlcnJhbFZpZXciOiJTaGFyZURpYWxvZyIsInJlZmVycmFsQXBwUGxhdGZvcm0iOiJXZWIiLCJyZWZlcnJhbE1vZGUiOiJ2aWV3In19 videó]); DML: INSERT INTO, UPDATE, SELECT FOR UPDATE (NOWAIT / WAIT), DELETE ([https://bmeedu-my.sharepoint.com/:v:/r/personal/eros_levente_vik_bme_hu/Documents/Stream%20Migrated%20Videos/Adatkezel%C3%A9s,%2018.%20el%C5%91ad%C3%A1s,%20DML-20201126_070815.mp4?csf=1&web=1&e=jmlmtF&nav=eyJyZWZlcnJhbEluZm8iOnsicmVmZXJyYWxBcHAiOiJTdHJlYW1XZWJBcHAiLCJyZWZlcnJhbFZpZXciOiJTaGFyZURpYWxvZyIsInJlZmVycmFsQXBwUGxhdGZvcm0iOiJXZWIiLCJyZWZlcnJhbE1vZGUiOiJ2aWV3In19 videó])

=== Labor ===