{"id":1656,"date":"2025-10-13T08:08:32","date_gmt":"2025-10-13T06:08:32","guid":{"rendered":"https:\/\/nikitalitvinenko24.thkit.ee\/wp\/?page_id=1656"},"modified":"2025-11-13T15:07:14","modified_gmt":"2025-11-13T13:07:14","slug":"ab-halduse-konspekt","status":"publish","type":"page","link":"https:\/\/nikitalitvinenko24.thkit.ee\/wp\/ab-halduse-konspekt\/","title":{"rendered":"AB halduse konspekt"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\"><strong>AB kasutajate rollid:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>AB kasutaja<\/strong> &#8211; tavakasutaja, mis saab muuta, lisada, filtreerida ja otsida vastavalt vajadusele.<\/li>\n\n\n\n<li><strong>AB programmeerija<\/strong> &#8211; loob funktsioonid ja protseduurid (trigerid).<\/li>\n\n\n\n<li><strong>DBA <\/strong>&#8211;  <strong>AB administraator<\/strong> &#8211; tagab, et \u00f5iged kasutajad saavad oma \u00f5igused.<\/li>\n\n\n\n<li><strong>AB projekteerija<\/strong> &#8211; loob tabeleid ja struktuuri.<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>DBA &#8211; AB administraator liigid:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>S\u00fcsteemiadmin<\/li>\n\n\n\n<li>AB arhitekt<\/li>\n\n\n\n<li>AB anal\u00fc\u00fctik<\/li>\n\n\n\n<li>Data warehouse admin (\u0430\u0434\u043c\u0438\u043d \u0445\u0440\u0430\u043d\u0438\u043b\u0438\u0449\u0430 \u0434\u0430\u043d\u043d\u044b\u0445) &#8211; andmeladu<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>DBA kaks peamist eesm\u00e4rki (\u00fclesanded):<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Kasutajate toetus ja ligip\u00e4\u00e4su jagamine ja seadistamine.<\/li>\n\n\n\n<li>AB Turvalisus ja j\u00f5udluse tagamine.<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>AB Turvalisus &#8211; 3 p\u00f5hiaspekti<\/strong><\/p>\n\n\n\n<div class=\"wp-block-group is-content-justification-left is-nowrap is-layout-flex wp-container-core-group-is-layout-24bf8543 wp-block-group-is-layout-flex\">\n<ul class=\"wp-block-list\">\n<li><strong>Andmete konfidentsiaalsus<\/strong> (confidentiality) <\/li>\n<\/ul>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nGRANT role to user &#x5B;identified by pwd] &#x5B;with grant option];\n\nREVOKE role from user;\n<\/pre><\/div><\/div>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Andmete k\u00e4ttesaadavus <\/strong>(availability\/\u0434\u043e\u0441\u0442\u0443\u043f\u043d\u043e\u0441\u0442\u044c) &#8211; andmed me saame k\u00e4tte \u00f5igel ajal ja \u00f5igel kasutajal.<\/li>\n\n\n\n<li><strong>Andmete terviklikkus<\/strong> (integrity\/\u0446\u0435\u043b\u0435\u0441\u0442\u043d\u043e\u0441\u0442\u044c) &#8211; usaldusv\u00e4\u00e4rne andmeallikad<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><td><strong>Risk<\/strong><\/td><td>Ohutuse aspekt<\/td><\/tr><tr><td>Inimlikud vead<\/td><td>konfidentsiaalsus, k\u00e4ttesaadavus, terviklikkus<\/td><\/tr><tr><td>F\u00fc\u00fcsilised vead (riistvara)<\/td><td>terviklikkus, k\u00e4ttesaadavus <\/td><\/tr><tr><td>Operatsioonis\u00fcsteemi rikked<\/td><td>K\u00e4ttesaadavus, terviklikkus, Konfidentsiaalsus <\/td><\/tr><tr><td>Andmebaasis\u00fcsteemi rikked<\/td><td>K\u00e4ttesaadavus, terviklikkus, Konfidentsiaalsus<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>COMMIT <\/strong>&#8211; k\u00e4sk, mida kasutatakse tavaliselt p\u00e4rast mitmeid INSERT-, UPDATE- v\u00f5i DELETE-operatsioone, et tagada muudatuste salvestamine andmebaasi.<br><\/li>\n\n\n\n<li><strong>ROLLBACK <\/strong>&#8211; k\u00e4sk, mida kasutatakse transaktsiooni poolt tehtud muudatuste tagasip\u00f6\u00f6ramiseks.<br><\/li>\n\n\n\n<li><strong>ROLLFORWARD<\/strong> &#8211; k\u00e4sk, mida kasutatakse logifailides sisalduvate transaktsioonide edasiarendamiseks m\u00e4\u00e4ratud asukohas.<br><\/li>\n\n\n\n<li><strong>Data Mining<\/strong> &#8211; (\u043f\u043e\u0438\u0441\u043a \u0441\u043a\u0440\u044b\u0442\u044b\u0445 \u0448\u0430\u0431\u043b\u043e\u043d\u043e\u0432) protsess, kus otsitakse suurtest andmekogudest kasulikke mustreid ja infot.<br><\/li>\n\n\n\n<li><strong>Data Warehouse<\/strong>  &#8211; suur andmeladu, kuhu kogutakse palju andmeid, et neid hiljem lihtsamalt vaadata ja kasutada.<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>GROUP BY<\/strong> &#8211; r\u00fchmitab andmed valitud veergude alusel, et teha kokkuv\u00f5tteid (nt SUM, COUNT).<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nSELECT Country, Gender, SUM(Salary) AS TotalSalary\nFROM Employees\nGROUP BY Country, Gender\n<\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\"><strong>UNION ALL<\/strong> &#8211; \u00fchendab mitu p\u00e4ringut, s\u00e4ilitades k\u00f5ik read, ka duplikaadid.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nSELECT Country, Gender, SUM(Salary) AS TotalSalary\nFROM Employees\nGROUP BY Country, Gender\n\nUNION ALL\n\nSELECT Country, NULL, SUM(Salary) AS TotalSalary\nFROM Employees\nGROUP BY Country\n<\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\"><strong>GROUPING <\/strong>&#8211; v\u00f5imaldab m\u00e4\u00e4rata, kuidas andmeid grupeeritakse, kasutades GROUPING SETS, ROLLUP v\u00f5i CUBE.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nSELECT Country, Gender, SUM(Salary) AS TotalSalary\nFROM Employees\nGROUP BY\n    GROUPING SETS\n    (\n        (Country, Gender),\n        (Country),\n        (Gender),\n        ()\n    )\n<\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\"><strong>ROLLUP <\/strong>&#8211; summerib hierarhiliselt valitud veergud.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nSELECT Country, SUM(Salary) AS TotalSalary\nFROM Employees\nGROUP BY ROLLUP(Country)\n<\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\"><strong>CUBE <\/strong>&#8211; arvutab summad igas veerus\/kombinatsioonis.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nSELECT Continent, Country, City, SUM(SaleAmount) AS TotalSales\nFROM Sales\nGROUP BY CUBE(Continent, Country, City)\n<\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\"><strong>Erinevus ROLLUP ja CUBE<\/strong> &#8211; ROLLUP summerib hierarhiliselt valitud veergud, CUBE arvutab summad igas veerus\/kombinatsioonis.<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_85 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/nikitalitvinenko24.thkit.ee\/wp\/ab-halduse-konspekt\/#AB_SQL-i_votmed\" >AB SQL-i v\u00f5tmed<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/nikitalitvinenko24.thkit.ee\/wp\/ab-halduse-konspekt\/#1_Primary_key\" >1. Primary key<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/nikitalitvinenko24.thkit.ee\/wp\/ab-halduse-konspekt\/#2_Foreign_key\" >2. Foreign key<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/nikitalitvinenko24.thkit.ee\/wp\/ab-halduse-konspekt\/#3_Unique_key\" >3. Unique key<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/nikitalitvinenko24.thkit.ee\/wp\/ab-halduse-konspekt\/#4_Simple_key\" >4. Simple key<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/nikitalitvinenko24.thkit.ee\/wp\/ab-halduse-konspekt\/#5_Composite_key_Compound_key\" >5. Composite key \/ Compound key<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/nikitalitvinenko24.thkit.ee\/wp\/ab-halduse-konspekt\/#6_Superkey\" >6. Superkey<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/nikitalitvinenko24.thkit.ee\/wp\/ab-halduse-konspekt\/#7_Candidate_key\" >7. Candidate key<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/nikitalitvinenko24.thkit.ee\/wp\/ab-halduse-konspekt\/#8_Alternate_key\" >8. Alternate key<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/nikitalitvinenko24.thkit.ee\/wp\/ab-halduse-konspekt\/#Allikad\" >Allikad:<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"AB_SQL-i_votmed\"><\/span>AB SQL-i v\u00f5tmed<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Primary key<\/li>\n\n\n\n<li>Foreign key<\/li>\n\n\n\n<li>Unique key<\/li>\n\n\n\n<li>Simple key<\/li>\n\n\n\n<li>Composite key \/ Compound key<\/li>\n\n\n\n<li>Superkey<\/li>\n\n\n\n<li>Candidate key<\/li>\n\n\n\n<li>Alternate key<\/li>\n<\/ol>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"1_Primary_key\"><\/span>1. <strong>Primary key<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Primary key<\/strong> on tabeli v\u00e4li, mis unikaalselt m\u00e4\u00e4rab iga rea. Selle v\u00e4\u00e4rtus ei kordu ja ei tohi olla t\u00fchi.<br>Tavaliselt kasutatakse<strong> Primary key&#8217;ga<\/strong> <strong>Identity&#8217;t<\/strong>, mis genereerib v\u00e4\u00e4rtuse automaatselt.<br><br>N\u00e4ide:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nCREATE TABLE Turniir (\n\tTurniirID int PRIMARY KEY IDENTITY(1,1),\n\tTurniirNimi varchar(50),\n);\n<\/pre><\/div>\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"2_Foreign_key\"><\/span>2. <strong>Foreign key<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Foreign key<\/strong> on tabeli v\u00e4li, mis viitab teise tabeli primaarv\u00f5tmele. See loob seose kahe tabeli vahel ja aitab tagada, et andmed oleksid omavahel \u00f5igesti seotud.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">N\u00e4ide:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nCREATE TABLE V\u00f5istlus (\n\tVoistlusID int PRIMARY KEY IDENTITY(1,1),\n\tVostlusNimi varchar(50),\n\tOsalejateArv int,\n\tTurniirID int FOREIGN KEY REFERENCES Turniir(TurniirID),\n);\n<\/pre><\/div>\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"3_Unique_key\"><\/span>3. Unique key<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Unique key<\/strong> on v\u00e4li v\u00f5i v\u00e4ljade kombinatsioon, mille v\u00e4\u00e4rtused ei tohi korduda, kuid v\u00f5ivad olla t\u00fchjad (NULL). See tagab, et k\u00f5ik v\u00e4\u00e4rtused selles veerus on andmebaasis ainulaadsed.<br><br>N\u00e4ide:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nCREATE TABLE Persons (\n    ID int UNIQUE,\n    LastName varchar(255),\n    FirstName varchar(255),\n    Age int\n);\n<\/pre><\/div>\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"4_Simple_key\"><\/span>4. Simple key<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Simple key<\/strong> on \u00fcksainus v\u00e4li, mis toimib primaar v\u00f5i unikaalv\u00f5tmena.<br><br>N\u00e4ide:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nCREATE TABLE Opilased (\n    opilaseId int PRIMARY KEY,\n    eesnimi varchar(50),\n    perenimi varchar(50)\n);\n<\/pre><\/div>\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"5_Composite_key_Compound_key\"><\/span>5. Composite key \/ Compound key<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Composite key<\/strong>\/<strong>Compound key<\/strong> on v\u00f5ti, mis koosneb mitmest veerust, et \u00fcheselt identifitseerida iga rida, kuna \u00fcks veerg \u00fcksi ei ole unikaalne.<br><br>N\u00e4ide:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nCREATE TABLE KursuseleRegistreerumised (\n    opilaseId int,\n    kursuseId int,\n    registreerumiseKuupaev date,\n    PRIMARY KEY (opilaseId, kursuseId)\n);\n<\/pre><\/div>\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"6_Superkey\"><\/span>6. Superkey<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Superkey <\/strong>on v\u00f5ti, mis \u00fcksk\u00f5ik millise rea \u00fcheselt m\u00e4\u00e4rab, isegi kui m\u00f5ned veerud selles v\u00f5tmes pole vajalikud unikaalsuse tagamiseks.<br><br>N\u00e4ide:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nCREATE TABLE Student (\n    studentId int,\n    name varchar(50),\n    address varchar(100),\n    phone varchar(15), -- minimaalne superkey\n    PRIMARY KEY (opilaseId)  -- minimaalne superkey\n);\n<\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">studentId &#8211; piisab iga \u00f5pilase tuvastamiseks.<br>studentId, phone &#8211; ka superkey, kuigi phone pole vajalik.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"7_Candidate_key\"><\/span>7. Candidate key<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Candidate key<\/strong> on minimaalne v\u00f5ti, mis unikaalselt tuvastab iga rea tabelis.<br><br>N\u00e4ide:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nCREATE TABLE Student (\n    studentId int,\n    email varchar(100), -- candidate key\n    name varchar(50),\n    PRIMARY KEY (studentId)  -- candidate key\n);\n<\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\"><strong>Candidate key<\/strong>&nbsp;selles tabelis:&nbsp;<strong>studentId&nbsp;<\/strong>ja&nbsp;<strong>email&nbsp;<\/strong>(kui iga e-post on unikaalne).<br>M\u00f5lemad v\u00f5ivad toimida Primary key, aga kumbki ei sisalda \u00fcleliigseid veerge.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"8_Alternate_key\"><\/span>8. Alternate key<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Alternate key<\/strong> on v\u00f5ti mis tahes <strong>Primary key<\/strong>, mida ei ole valitud esmaseks v\u00f5tmeks.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nCREATE TABLE CUSTOMERS(\n   ID INT,\n   NAME VARCHAR (20),\n   AGE INT,\n   AADHAAR_ID BIGINT, -- alternate key\n   MOBILE_NO BIGINT, -- alternate key\n   SALARY DECIMAL (18, 2),\n   PRIMARY KEY(ID)      \n);\n<\/pre><\/div>\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Allikad\"><\/span>Allikad:<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/www.w3schools.com\/sql\/sql_ref_primary_key.asp\">W3schools Primary key<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.w3schools.com\/sql\/sql_foreignkey.asp\">W3schools Foreign key<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.w3schools.com\/sql\/sql_unique.asp\">W3schools Unique key<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/en.wikipedia.org\/wiki\/Composite_key\">Wikipedia Composite key<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.geeksforgeeks.org\/dbms\/types-of-keys-in-relational-model-candidate-super-primary-alternate-and-foreign\/\">Geeksforgeeks Keys in Relational Model<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.tutorialspoint.com\/sql\/sql-alternate-key.htm\">TutorialsPoint Alternate key<\/a><\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/nikitalitvinenko24.thkit.ee\/wp\/tabeli-normaliseerimine\/\">Tabeli normaliseerimine<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>AB kasutajate rollid: DBA &#8211; AB administraator liigid: DBA kaks peamist eesm\u00e4rki (\u00fclesanded): AB Turvalisus &#8211; 3 p\u00f5hiaspekti Risk Ohutuse aspekt Inimlikud vead konfidentsiaalsus, k\u00e4ttesaadavus, terviklikkus F\u00fc\u00fcsilised vead (riistvara) terviklikkus, k\u00e4ttesaadavus Operatsioonis\u00fcsteemi rikked K\u00e4ttesaadavus, terviklikkus, Konfidentsiaalsus Andmebaasis\u00fcsteemi rikked K\u00e4ttesaadavus, terviklikkus, Konfidentsiaalsus GROUP BY &#8211; r\u00fchmitab andmed valitud veergude alusel, et teha kokkuv\u00f5tteid (nt SUM, COUNT). &hellip; <a href=\"https:\/\/nikitalitvinenko24.thkit.ee\/wp\/ab-halduse-konspekt\/\" class=\"more-link\">Loe edasi<span class=\"screen-reader-text\"> &#8220;AB halduse konspekt&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-1656","page","type-page","status-publish","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.9 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>AB halduse konspekt - Nikita Litvinenko Portfoolio<\/title>\n<meta name=\"description\" content=\"AB kasutaja - tavakasutaja, mis saab muuta, lisada, filtreerida ja otsida vastavalt vajadusele. AB programmeerija - loob funktsioonid ja protseduurid (trigerid). DBA - AB administraator - tagab, et \u00f5iged kasutajad saavad oma \u00f5igused. AB projekteerija - loob tabeleid ja struktuuri.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/nikitalitvinenko24.thkit.ee\/wp\/ab-halduse-konspekt\/\" \/>\n<meta property=\"og:locale\" content=\"et_EE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"AB halduse konspekt - Nikita Litvinenko Portfoolio\" \/>\n<meta property=\"og:description\" content=\"AB kasutaja - tavakasutaja, mis saab muuta, lisada, filtreerida ja otsida vastavalt vajadusele. AB programmeerija - loob funktsioonid ja protseduurid (trigerid). DBA - AB administraator - tagab, et \u00f5iged kasutajad saavad oma \u00f5igused. AB projekteerija - loob tabeleid ja struktuuri.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/nikitalitvinenko24.thkit.ee\/wp\/ab-halduse-konspekt\/\" \/>\n<meta property=\"og:site_name\" content=\"Nikita Litvinenko Portfoolio\" \/>\n<meta property=\"article:modified_time\" content=\"2025-11-13T13:07:14+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 minutit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/nikitalitvinenko24.thkit.ee\\\/wp\\\/ab-halduse-konspekt\\\/\",\"url\":\"https:\\\/\\\/nikitalitvinenko24.thkit.ee\\\/wp\\\/ab-halduse-konspekt\\\/\",\"name\":\"AB halduse konspekt - Nikita Litvinenko Portfoolio\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/nikitalitvinenko24.thkit.ee\\\/wp\\\/#website\"},\"datePublished\":\"2025-10-13T06:08:32+00:00\",\"dateModified\":\"2025-11-13T13:07:14+00:00\",\"description\":\"AB kasutaja - tavakasutaja, mis saab muuta, lisada, filtreerida ja otsida vastavalt vajadusele. AB programmeerija - loob funktsioonid ja protseduurid (trigerid). DBA - AB administraator - tagab, et \u00f5iged kasutajad saavad oma \u00f5igused. AB projekteerija - loob tabeleid ja struktuuri.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/nikitalitvinenko24.thkit.ee\\\/wp\\\/ab-halduse-konspekt\\\/#breadcrumb\"},\"inLanguage\":\"et\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/nikitalitvinenko24.thkit.ee\\\/wp\\\/ab-halduse-konspekt\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/nikitalitvinenko24.thkit.ee\\\/wp\\\/ab-halduse-konspekt\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/nikitalitvinenko24.thkit.ee\\\/wp\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"AB halduse konspekt\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/nikitalitvinenko24.thkit.ee\\\/wp\\\/#website\",\"url\":\"https:\\\/\\\/nikitalitvinenko24.thkit.ee\\\/wp\\\/\",\"name\":\"Nikita Litvinenko Portfoolio\",\"description\":\"Noorem tarkvaraarendaja\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/nikitalitvinenko24.thkit.ee\\\/wp\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"et\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"AB halduse konspekt - Nikita Litvinenko Portfoolio","description":"AB kasutaja - tavakasutaja, mis saab muuta, lisada, filtreerida ja otsida vastavalt vajadusele. AB programmeerija - loob funktsioonid ja protseduurid (trigerid). DBA - AB administraator - tagab, et \u00f5iged kasutajad saavad oma \u00f5igused. AB projekteerija - loob tabeleid ja struktuuri.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/nikitalitvinenko24.thkit.ee\/wp\/ab-halduse-konspekt\/","og_locale":"et_EE","og_type":"article","og_title":"AB halduse konspekt - Nikita Litvinenko Portfoolio","og_description":"AB kasutaja - tavakasutaja, mis saab muuta, lisada, filtreerida ja otsida vastavalt vajadusele. AB programmeerija - loob funktsioonid ja protseduurid (trigerid). DBA - AB administraator - tagab, et \u00f5iged kasutajad saavad oma \u00f5igused. AB projekteerija - loob tabeleid ja struktuuri.","og_url":"https:\/\/nikitalitvinenko24.thkit.ee\/wp\/ab-halduse-konspekt\/","og_site_name":"Nikita Litvinenko Portfoolio","article_modified_time":"2025-11-13T13:07:14+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"3 minutit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/nikitalitvinenko24.thkit.ee\/wp\/ab-halduse-konspekt\/","url":"https:\/\/nikitalitvinenko24.thkit.ee\/wp\/ab-halduse-konspekt\/","name":"AB halduse konspekt - Nikita Litvinenko Portfoolio","isPartOf":{"@id":"https:\/\/nikitalitvinenko24.thkit.ee\/wp\/#website"},"datePublished":"2025-10-13T06:08:32+00:00","dateModified":"2025-11-13T13:07:14+00:00","description":"AB kasutaja - tavakasutaja, mis saab muuta, lisada, filtreerida ja otsida vastavalt vajadusele. AB programmeerija - loob funktsioonid ja protseduurid (trigerid). DBA - AB administraator - tagab, et \u00f5iged kasutajad saavad oma \u00f5igused. AB projekteerija - loob tabeleid ja struktuuri.","breadcrumb":{"@id":"https:\/\/nikitalitvinenko24.thkit.ee\/wp\/ab-halduse-konspekt\/#breadcrumb"},"inLanguage":"et","potentialAction":[{"@type":"ReadAction","target":["https:\/\/nikitalitvinenko24.thkit.ee\/wp\/ab-halduse-konspekt\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/nikitalitvinenko24.thkit.ee\/wp\/ab-halduse-konspekt\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/nikitalitvinenko24.thkit.ee\/wp\/"},{"@type":"ListItem","position":2,"name":"AB halduse konspekt"}]},{"@type":"WebSite","@id":"https:\/\/nikitalitvinenko24.thkit.ee\/wp\/#website","url":"https:\/\/nikitalitvinenko24.thkit.ee\/wp\/","name":"Nikita Litvinenko Portfoolio","description":"Noorem tarkvaraarendaja","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/nikitalitvinenko24.thkit.ee\/wp\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"et"}]}},"_links":{"self":[{"href":"https:\/\/nikitalitvinenko24.thkit.ee\/wp\/wp-json\/wp\/v2\/pages\/1656","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nikitalitvinenko24.thkit.ee\/wp\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/nikitalitvinenko24.thkit.ee\/wp\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/nikitalitvinenko24.thkit.ee\/wp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/nikitalitvinenko24.thkit.ee\/wp\/wp-json\/wp\/v2\/comments?post=1656"}],"version-history":[{"count":73,"href":"https:\/\/nikitalitvinenko24.thkit.ee\/wp\/wp-json\/wp\/v2\/pages\/1656\/revisions"}],"predecessor-version":[{"id":2072,"href":"https:\/\/nikitalitvinenko24.thkit.ee\/wp\/wp-json\/wp\/v2\/pages\/1656\/revisions\/2072"}],"wp:attachment":[{"href":"https:\/\/nikitalitvinenko24.thkit.ee\/wp\/wp-json\/wp\/v2\/media?parent=1656"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}