{"id":3,"date":"2024-04-04T06:16:27","date_gmt":"2024-04-04T03:16:27","guid":{"rendered":"https:\/\/sisu.ut.ee\/ajalooandmebaasid\/avaleht\/"},"modified":"2024-04-04T06:16:44","modified_gmt":"2024-04-04T03:16:44","slug":"avaleht","status":"publish","type":"page","link":"https:\/\/sisu.ut.ee\/ajalooandmebaasid\/","title":{"rendered":"Avaleht"},"content":{"rendered":"<p>\n\t<span style=\"font-size:20px\">Ajaloo andmebaaside kursuse (HVAJ.02.003) \u00f5ppematerjal<\/span>\n<\/p>\n<p>\n\t<span style=\"font-size:14px\">Tutvu iseseisvalt semantilise veebi avaandmete kontseptsiooniga ja harjuta wikidatal SPARQL p\u00e4ringuid. Materjali koostas Liisi Taimre.\u00a0<\/span>\n<\/p>\n<p>\n\tTee l\u00e4bi relatsioonilise andmebaasi loomine ja kasutamine alates mudeli disainimisest kuni andmete anal\u00fc\u00fcsimiseks vajalike keskmiselt keerukate SQL p\u00e4ringute koostamiseni. Materjalis on olemas n\u00e4idisandmebaasi jaoks vajalikud andmed. SQL p\u00e4ringute \u00f5igsuse kontrollimiseks on toodud vasted, mille \u00f5iged p\u00e4ringud annavad. Materjali koostas Kadri Tooming (<a href=\"mailto:kadri.tooming@ra.ee\">kadri.tooming@ra.ee<\/a>)\n<\/p>\n<p>\n\t<img loading=\"lazy\" decoding=\"async\" width=\"607\" height=\"213\" class=\"alignnone wp-image-17\" src=\"https:\/\/sisu.ut.ee\/wp-content\/uploads\/sites\/444\/hitsa.jpg\" title=\"hitsa.jpg\" alt=\"Hitsa logo\" srcset=\"https:\/\/sisu.ut.ee\/wp-content\/uploads\/sites\/444\/hitsa.jpg 607w, https:\/\/sisu.ut.ee\/wp-content\/uploads\/sites\/444\/hitsa-300x105.jpg 300w\" sizes=\"auto, (max-width: 607px) 100vw, 607px\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ajaloo andmebaaside kursuse (HVAJ.02.003) \u00f5ppematerjal Tutvu iseseisvalt semantilise veebi avaandmete kontseptsiooniga ja harjuta wikidatal SPARQL p\u00e4ringuid. Materjali koostas Liisi Taimre.\u00a0 Tee l\u00e4bi relatsioonilise andmebaasi loomine ja kasutamine alates mudeli disainimisest kuni andmete anal\u00fc\u00fcsimiseks vajalike keskmiselt keerukate SQL p\u00e4ringute koostamiseni. Materjalis &#8230;<\/p>\n","protected":false},"author":231,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"class_list":["post-3","page","type-page","status-publish","hentry"],"acf":[],"_links":{"self":[{"href":"https:\/\/sisu.ut.ee\/ajalooandmebaasid\/wp-json\/wp\/v2\/pages\/3","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sisu.ut.ee\/ajalooandmebaasid\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/sisu.ut.ee\/ajalooandmebaasid\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/sisu.ut.ee\/ajalooandmebaasid\/wp-json\/wp\/v2\/users\/231"}],"replies":[{"embeddable":true,"href":"https:\/\/sisu.ut.ee\/ajalooandmebaasid\/wp-json\/wp\/v2\/comments?post=3"}],"version-history":[{"count":1,"href":"https:\/\/sisu.ut.ee\/ajalooandmebaasid\/wp-json\/wp\/v2\/pages\/3\/revisions"}],"predecessor-version":[{"id":148,"href":"https:\/\/sisu.ut.ee\/ajalooandmebaasid\/wp-json\/wp\/v2\/pages\/3\/revisions\/148"}],"wp:attachment":[{"href":"https:\/\/sisu.ut.ee\/ajalooandmebaasid\/wp-json\/wp\/v2\/media?parent=3"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}