{"id":188,"date":"2025-01-28T14:27:30","date_gmt":"2025-01-28T12:27:30","guid":{"rendered":"https:\/\/com47276.wordpress.com\/?page_id=188"},"modified":"2025-11-13T13:25:32","modified_gmt":"2025-11-13T13:25:32","slug":"andmebaas","status":"publish","type":"page","link":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/andmebaas\/","title":{"rendered":"Andmebaas"},"content":{"rendered":"\n

Andmebaas<\/h2>\n\n\n\n
\"\"<\/figure>\n\n\n\n

Andmebaas p\u00f5him\u00f5isted:<\/a><\/strong><\/p>\n\n\n\n

Milleks on vaja AB? <\/strong>
– hoiustada andmed,
– p\u00e4ringu tegemine, et vajalikud andmed leida,
– v\u00e4ltida andmete dubleerimist.<\/p>\n\n\n\n

Andmet\u00fc\u00fcbid:<\/strong>
1. Text \/ S\u00fcmbol (Varchar(25), char(5), TEXT)
2. Number (int, smallint, decimall(5, 2))
3. Logika (bit, boolean, bool, true\/false)
4. Date\/Time (date, time, interval)<\/p>\n\n\n\n

Piirangud:<\/strong>
Primary key<\/strong> <\/em>– primaarne v\u00f5ti – lisab andmetabelis iga kirje unikaalsus
Foreign key <\/strong>– v\u00e4lisv\u00f5ti – seos teise tabeliga
not null<\/strong>
unique <\/strong>– ainult \u00fcks kord tabelis
check<\/strong> – valik – kasutaja saab valida<\/p>\n\n\n\n

SQL – Structure Query Language – Struktuurne p\u00e4ringukeel<\/strong><\/p>\n\n\n\n

SQL SERVER Management Studio
Server name <\/strong>: (localdb)\\MSSQLLocalDB<\/strong>
Windows Autentification<\/p>\n\n\n\n

— AB loomine<\/p>\n\n\n\n

— Andmebass —<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Andmebaas Andmebaas p\u00f5him\u00f5isted: Milleks on vaja AB? – hoiustada andmed, – p\u00e4ringu tegemine, et vajalikud andmed leida, – v\u00e4ltida andmete […]<\/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-188","page","type-page","status-publish","hentry"],"yoast_head":"\nAndmebaas - Oleksandra Ryshniak Portfolio<\/title>\n<meta name=\"description\" content=\"Milleks on vaja AB? - hoiustada andmed, - p\u00e4ringu tegemine, et vajalikud andmed leida, - v\u00e4ltida andmete dubleerimist.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/andmebaas\/\" \/>\n<meta property=\"og:locale\" content=\"et_EE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Andmebaas - Oleksandra Ryshniak Portfolio\" \/>\n<meta property=\"og:description\" content=\"Milleks on vaja AB? - hoiustada andmed, - p\u00e4ringu tegemine, et vajalikud andmed leida, - v\u00e4ltida andmete dubleerimist.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/andmebaas\/\" \/>\n<meta property=\"og:site_name\" content=\"Oleksandra Ryshniak Portfolio\" \/>\n<meta property=\"article:modified_time\" content=\"2025-11-13T13:25:32+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/11\/image-4.png\" \/>\n\t<meta property=\"og:image:width\" content=\"200\" \/>\n\t<meta property=\"og:image:height\" content=\"200\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\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=\"1 minut\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/oleksandraryshniak24.thkit.ee\\\/wp1\\\/andmebaas\\\/\",\"url\":\"https:\\\/\\\/oleksandraryshniak24.thkit.ee\\\/wp1\\\/andmebaas\\\/\",\"name\":\"Andmebaas - Oleksandra Ryshniak Portfolio\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/oleksandraryshniak24.thkit.ee\\\/wp1\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/oleksandraryshniak24.thkit.ee\\\/wp1\\\/andmebaas\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/oleksandraryshniak24.thkit.ee\\\/wp1\\\/andmebaas\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/oleksandraryshniak24.thkit.ee\\\/wp1\\\/wp-content\\\/uploads\\\/2025\\\/11\\\/image-4.png\",\"datePublished\":\"2025-01-28T12:27:30+00:00\",\"dateModified\":\"2025-11-13T13:25:32+00:00\",\"description\":\"Milleks on vaja AB? - hoiustada andmed, - p\u00e4ringu tegemine, et vajalikud andmed leida, - v\u00e4ltida andmete dubleerimist.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/oleksandraryshniak24.thkit.ee\\\/wp1\\\/andmebaas\\\/#breadcrumb\"},\"inLanguage\":\"et\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/oleksandraryshniak24.thkit.ee\\\/wp1\\\/andmebaas\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"et\",\"@id\":\"https:\\\/\\\/oleksandraryshniak24.thkit.ee\\\/wp1\\\/andmebaas\\\/#primaryimage\",\"url\":\"https:\\\/\\\/oleksandraryshniak24.thkit.ee\\\/wp1\\\/wp-content\\\/uploads\\\/2025\\\/11\\\/image-4.png\",\"contentUrl\":\"https:\\\/\\\/oleksandraryshniak24.thkit.ee\\\/wp1\\\/wp-content\\\/uploads\\\/2025\\\/11\\\/image-4.png\",\"width\":200,\"height\":200},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/oleksandraryshniak24.thkit.ee\\\/wp1\\\/andmebaas\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/oleksandraryshniak24.thkit.ee\\\/wp1\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Andmebaas\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/oleksandraryshniak24.thkit.ee\\\/wp1\\\/#website\",\"url\":\"https:\\\/\\\/oleksandraryshniak24.thkit.ee\\\/wp1\\\/\",\"name\":\"Oleksandra Ryshniak Portfolio\",\"description\":\"\u041f\u0440\u043e\u0441\u0442\u043e \u0435\u0449\u0435 \u043e\u0434\u0438\u043d WordPress \u0441\u0430\u0439\u0442\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/oleksandraryshniak24.thkit.ee\\\/wp1\\\/?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":"Andmebaas - Oleksandra Ryshniak Portfolio","description":"Milleks on vaja AB? - hoiustada andmed, - p\u00e4ringu tegemine, et vajalikud andmed leida, - v\u00e4ltida andmete dubleerimist.","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:\/\/oleksandraryshniak24.thkit.ee\/wp1\/andmebaas\/","og_locale":"et_EE","og_type":"article","og_title":"Andmebaas - Oleksandra Ryshniak Portfolio","og_description":"Milleks on vaja AB? - hoiustada andmed, - p\u00e4ringu tegemine, et vajalikud andmed leida, - v\u00e4ltida andmete dubleerimist.","og_url":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/andmebaas\/","og_site_name":"Oleksandra Ryshniak Portfolio","article_modified_time":"2025-11-13T13:25:32+00:00","og_image":[{"width":200,"height":200,"url":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/11\/image-4.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"1 minut"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/andmebaas\/","url":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/andmebaas\/","name":"Andmebaas - Oleksandra Ryshniak Portfolio","isPartOf":{"@id":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/#website"},"primaryImageOfPage":{"@id":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/andmebaas\/#primaryimage"},"image":{"@id":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/andmebaas\/#primaryimage"},"thumbnailUrl":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/11\/image-4.png","datePublished":"2025-01-28T12:27:30+00:00","dateModified":"2025-11-13T13:25:32+00:00","description":"Milleks on vaja AB? - hoiustada andmed, - p\u00e4ringu tegemine, et vajalikud andmed leida, - v\u00e4ltida andmete dubleerimist.","breadcrumb":{"@id":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/andmebaas\/#breadcrumb"},"inLanguage":"et","potentialAction":[{"@type":"ReadAction","target":["https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/andmebaas\/"]}]},{"@type":"ImageObject","inLanguage":"et","@id":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/andmebaas\/#primaryimage","url":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/11\/image-4.png","contentUrl":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/11\/image-4.png","width":200,"height":200},{"@type":"BreadcrumbList","@id":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/andmebaas\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/"},{"@type":"ListItem","position":2,"name":"Andmebaas"}]},{"@type":"WebSite","@id":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/#website","url":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/","name":"Oleksandra Ryshniak Portfolio","description":"\u041f\u0440\u043e\u0441\u0442\u043e \u0435\u0449\u0435 \u043e\u0434\u0438\u043d WordPress \u0441\u0430\u0439\u0442","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"et"}]}},"_links":{"self":[{"href":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-json\/wp\/v2\/pages\/188","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-json\/wp\/v2\/comments?post=188"}],"version-history":[{"count":3,"href":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-json\/wp\/v2\/pages\/188\/revisions"}],"predecessor-version":[{"id":1800,"href":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-json\/wp\/v2\/pages\/188\/revisions\/1800"}],"wp:attachment":[{"href":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-json\/wp\/v2\/media?parent=188"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}