{"id":84,"date":"2021-03-04T10:04:57","date_gmt":"2021-03-04T10:04:57","guid":{"rendered":"https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/?post_type=chapter&#038;p=84"},"modified":"2021-05-06T18:58:37","modified_gmt":"2021-05-06T18:58:37","slug":"tarkvara-installimine","status":"publish","type":"chapter","link":"https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/chapter\/tarkvara-installimine\/","title":{"raw":"Tarkvara installimine","rendered":"Tarkvara installimine"},"content":{"raw":"<p style=\"text-align: justify\">Kuna n\u00fc\u00fcd meil on vajalikud teadmised andmebaasi loomise protsessist olemas, on \u00f5ige aeg installida vajalik tarkvara andmebaaside loomiseks.<\/p>\r\n\r\n<h2>PostgreSQL installimine<\/h2>\r\n<p style=\"text-align: justify\">Nagu esimeses peat\u00fckis mainitud sai, siis andmebaaside haldamiseks on olemas erinevaid andmebaasi halduss\u00fcsteeme. Selle valikmooduli raames kasutame me andmebaasi halduss\u00fcsteemina PostgreSQL\u2019i. PostgreSQL kasuks r\u00e4\u00e4gib see, et PostgreSQL on tasuta, avatud l\u00e4htekoodiga ning v\u00e4ga populaarne andmebaasi halduss\u00fcsteem.<\/p>\r\n<p style=\"text-align: justify\">Selleks, et oma arvutisse PostgreSQL'i installida, vali enda operatsioonis\u00fcsteemile vastav juhend ning l\u00e4bi k\u00f5ik sammud.<\/p>\r\n\r\n<ul style=\"text-align: justify\">\r\n \t<li><a href=\"https:\/\/drive.google.com\/file\/d\/1UoKC6kz2n8AwE9y29uYge-7yYYH2WViX\/view?usp=sharing\">PostgreSQL'i installimine (Windows 10)<\/a><\/li>\r\n \t<li><a href=\"https:\/\/drive.google.com\/file\/d\/1OqHSo4XrJ0ys4m90mn19VMvHoIOAbSf4\/view?fbclid=IwAR1Mdmkz6HeYgyou-g5y3q8LQvjt5gZ14avdm4a3WwiE2fESQ1hqFoWnnx4\">PostgreSQL'i installimine (macOS)<\/a><\/li>\r\n \t<li><a href=\"https:\/\/drive.google.com\/file\/d\/12oXI5DnDIMb4h9bc8pYzEfxzZSHU2kzJ\/view?usp=sharing\">PostgreSQL'i installimine (Ubuntu)<\/a><\/li>\r\n<\/ul>\r\n<h2>DBeaveri installimine<\/h2>\r\n<p style=\"text-align: justify\">Selleks, et meie andmebaasis toimuvast parem \u00fclevaade saada, on meil vaja installida ka kliendipoolne tarkvararakendus DBeaver. DBeaver on tasuta ning see toetab k\u00f5iki peamisi operatsioonis\u00fcsteeme (Windows, macOS, Linux) ning ka peamisi andmebaasi halduss\u00fcsteeme (Oracle, MySQL, PostgreSQL, jpm).<\/p>\r\n<p style=\"text-align: justify\">DBeaveri installimise juhend on all nii Windows 10, macOS\u2019i kui ka Ubuntu jaoks. Vali enda arvutis olev operatsioonis\u00fcsteem ning l\u00e4bi k\u00f5ik sammud.<\/p>\r\n\r\n<ul style=\"text-align: justify\">\r\n \t<li><a href=\"https:\/\/drive.google.com\/file\/d\/1XemvUnxvc1hkrG2-dJjko--2FLXqkU7o\/view?usp=sharing\">DBeaveri installimine (Windows 10)<\/a><\/li>\r\n \t<li><a href=\"https:\/\/drive.google.com\/file\/d\/1XZc6zkFMz-ESN7wnMTw_XVoo1ytKyDD6\/view?fbclid=IwAR1odyqkq0fstqBdJ83BL_-ozLnBEuayBNjo2RFLq20BkcSbqIu2mE_Q0jQ\">DBeaveri installimine (macOS)<\/a><\/li>\r\n \t<li><a href=\"https:\/\/drive.google.com\/file\/d\/17PnEG2jiXUTacalLWnFBBUg9bm66KcLk\/view?usp=sharing\">DBeaveri installimine (Ubuntu)<\/a><\/li>\r\n<\/ul>\r\n<h2>DBeaveri esimene k\u00e4ivitamine<\/h2>\r\n<p style=\"text-align: justify\">Proovime n\u00fc\u00fcd DBeaveri esimest korda t\u00f6\u00f6le panna. Selle jaoks on samuti Windowsil, macOS'il ning Ubuntul veidikene erinevad sammud. Vali j\u00e4llegi enda arvutis olev operatsioonis\u00fcsteem ning l\u00e4bi juhendis olevad sammud.<\/p>\r\n\r\n<ul style=\"text-align: justify\">\r\n \t<li><a href=\"https:\/\/drive.google.com\/file\/d\/1HNI72g1-8TxrCTnPte7AU0XKLPGx8h2N\/view?usp=sharing\">DBeaveri esimene k\u00e4ivitamine (Windows 10)<\/a><\/li>\r\n \t<li><a href=\"https:\/\/drive.google.com\/file\/d\/1qB4WO0PTROha573Re_yPXk-EF-M8NkhI\/view?fbclid=IwAR0xZmav_zkgynOCiWP_KB-UMIXukLpOlj94TjzmE1XfFN7zfbxg8nQp-xE\">DBeaveri esimene k\u00e4ivitamine (macOS)<\/a><\/li>\r\n \t<li><a href=\"https:\/\/drive.google.com\/file\/d\/1FnSwQpnqdOMFSvXtwZ2VxOMjQA9ZJRm-\/view?usp=sharing\">DBeaveri esimene k\u00e4ivitamine (Ubuntu)<\/a><\/li>\r\n<\/ul>\r\n<p style=\"text-align: justify\">Kui eelnevad sammud on l\u00e4bitud, peaks nii Windowsi, macOS'i kui ka Ubuntu kasutajatel olema ees sarnane pilt. Pane t\u00e4hele, et ette tuleb v\u00f5tta <em>Projects<\/em> men\u00fc\u00fc. Kui see esmalt olemas ei ole, saab selle avada valides \u00fclalolevalt men\u00fc\u00fcribalt Window -&gt; Projects. Kui Projects men\u00fc\u00fc on lahti, peaks pilt v\u00e4lja n\u00e4gema j\u00e4rgnev.<\/p>\r\n<p style=\"text-align: justify\"><span style=\"color: #ff00ff\"><img class=\" wp-image-915 aligncenter\" src=\"https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-content\/uploads\/sites\/21\/2021\/03\/projects_menuu_lahti-300x225.png\" alt=\"\" width=\"1025\" height=\"769\" \/><\/span><\/p>\r\n<p style=\"text-align: justify\">Kui n\u00fc\u00fcd vajutada projekti <em>General<\/em> juures olevat noolekest ning liikuda j\u00e4rjest s\u00fcgavamale (Windowsi ja Linuxi kasutajatel <em>General<\/em> -&gt; <em>Connections<\/em> -&gt; <em>postgres<\/em> -&gt; <em>postgres<\/em> -&gt; <em>Schemas<\/em>, macOS kasutajatel <em>General<\/em> -&gt; <em>Connections<\/em> -&gt; <em>postgres<\/em> -&gt; <em>sinu_arvuti_kasutajanimi<\/em> -&gt; <em>Schemas<\/em>), peaks n\u00e4htavale tulema andmebaasi skeem (ingl s<em>chema<\/em>) <em>public<\/em>. Andmebaasi skeem kirjeldab andmebaasis esinevaid tabeleid ja nendevahelisi seoseid, seega sisuliselt kirjeldab skeem andmebaasi struktuuri. Edaspidi nimetame lihtsuse m\u00f5ttes skeemi <em>public<\/em> andmebaasiks, mitte skeemiks, sest me loome edaspidi nii kui nii vaid \u00fche andmebaasi skeemi.<\/p>\r\n<p style=\"text-align: justify\"><span style=\"color: #ff00ff\"><img class=\" wp-image-914 aligncenter\" src=\"https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-content\/uploads\/sites\/21\/2021\/03\/public_schema_nahtaval-300x225.png\" alt=\"\" width=\"1024\" height=\"768\" \/><\/span><\/p>\r\n<p style=\"text-align: justify\">Nagu n\u00e4ha, siis andmebaasi <em>public<\/em> all on alamkategooria <em>Tables<\/em>, mis hetkel veel \u00fchtegi tabelit ei sisalda. Selle sama andmebaasiga hakkame me edasistes peat\u00fckkides t\u00f6\u00f6d tegema ning sealjuures r\u00e4\u00e4gime andmebaasis <em>public<\/em> sisalduvast t\u00e4psemalt.<\/p>","rendered":"<p style=\"text-align: justify\">Kuna n\u00fc\u00fcd meil on vajalikud teadmised andmebaasi loomise protsessist olemas, on \u00f5ige aeg installida vajalik tarkvara andmebaaside loomiseks.<\/p>\n<h2>PostgreSQL installimine<\/h2>\n<p style=\"text-align: justify\">Nagu esimeses peat\u00fckis mainitud sai, siis andmebaaside haldamiseks on olemas erinevaid andmebaasi halduss\u00fcsteeme. Selle valikmooduli raames kasutame me andmebaasi halduss\u00fcsteemina PostgreSQL\u2019i. PostgreSQL kasuks r\u00e4\u00e4gib see, et PostgreSQL on tasuta, avatud l\u00e4htekoodiga ning v\u00e4ga populaarne andmebaasi halduss\u00fcsteem.<\/p>\n<p style=\"text-align: justify\">Selleks, et oma arvutisse PostgreSQL&#8217;i installida, vali enda operatsioonis\u00fcsteemile vastav juhend ning l\u00e4bi k\u00f5ik sammud.<\/p>\n<ul style=\"text-align: justify\">\n<li><a href=\"https:\/\/drive.google.com\/file\/d\/1UoKC6kz2n8AwE9y29uYge-7yYYH2WViX\/view?usp=sharing\">PostgreSQL&#8217;i installimine (Windows 10)<\/a><\/li>\n<li><a href=\"https:\/\/drive.google.com\/file\/d\/1OqHSo4XrJ0ys4m90mn19VMvHoIOAbSf4\/view?fbclid=IwAR1Mdmkz6HeYgyou-g5y3q8LQvjt5gZ14avdm4a3WwiE2fESQ1hqFoWnnx4\">PostgreSQL&#8217;i installimine (macOS)<\/a><\/li>\n<li><a href=\"https:\/\/drive.google.com\/file\/d\/12oXI5DnDIMb4h9bc8pYzEfxzZSHU2kzJ\/view?usp=sharing\">PostgreSQL&#8217;i installimine (Ubuntu)<\/a><\/li>\n<\/ul>\n<h2>DBeaveri installimine<\/h2>\n<p style=\"text-align: justify\">Selleks, et meie andmebaasis toimuvast parem \u00fclevaade saada, on meil vaja installida ka kliendipoolne tarkvararakendus DBeaver. DBeaver on tasuta ning see toetab k\u00f5iki peamisi operatsioonis\u00fcsteeme (Windows, macOS, Linux) ning ka peamisi andmebaasi halduss\u00fcsteeme (Oracle, MySQL, PostgreSQL, jpm).<\/p>\n<p style=\"text-align: justify\">DBeaveri installimise juhend on all nii Windows 10, macOS\u2019i kui ka Ubuntu jaoks. Vali enda arvutis olev operatsioonis\u00fcsteem ning l\u00e4bi k\u00f5ik sammud.<\/p>\n<ul style=\"text-align: justify\">\n<li><a href=\"https:\/\/drive.google.com\/file\/d\/1XemvUnxvc1hkrG2-dJjko--2FLXqkU7o\/view?usp=sharing\">DBeaveri installimine (Windows 10)<\/a><\/li>\n<li><a href=\"https:\/\/drive.google.com\/file\/d\/1XZc6zkFMz-ESN7wnMTw_XVoo1ytKyDD6\/view?fbclid=IwAR1odyqkq0fstqBdJ83BL_-ozLnBEuayBNjo2RFLq20BkcSbqIu2mE_Q0jQ\">DBeaveri installimine (macOS)<\/a><\/li>\n<li><a href=\"https:\/\/drive.google.com\/file\/d\/17PnEG2jiXUTacalLWnFBBUg9bm66KcLk\/view?usp=sharing\">DBeaveri installimine (Ubuntu)<\/a><\/li>\n<\/ul>\n<h2>DBeaveri esimene k\u00e4ivitamine<\/h2>\n<p style=\"text-align: justify\">Proovime n\u00fc\u00fcd DBeaveri esimest korda t\u00f6\u00f6le panna. Selle jaoks on samuti Windowsil, macOS&#8217;il ning Ubuntul veidikene erinevad sammud. Vali j\u00e4llegi enda arvutis olev operatsioonis\u00fcsteem ning l\u00e4bi juhendis olevad sammud.<\/p>\n<ul style=\"text-align: justify\">\n<li><a href=\"https:\/\/drive.google.com\/file\/d\/1HNI72g1-8TxrCTnPte7AU0XKLPGx8h2N\/view?usp=sharing\">DBeaveri esimene k\u00e4ivitamine (Windows 10)<\/a><\/li>\n<li><a href=\"https:\/\/drive.google.com\/file\/d\/1qB4WO0PTROha573Re_yPXk-EF-M8NkhI\/view?fbclid=IwAR0xZmav_zkgynOCiWP_KB-UMIXukLpOlj94TjzmE1XfFN7zfbxg8nQp-xE\">DBeaveri esimene k\u00e4ivitamine (macOS)<\/a><\/li>\n<li><a href=\"https:\/\/drive.google.com\/file\/d\/1FnSwQpnqdOMFSvXtwZ2VxOMjQA9ZJRm-\/view?usp=sharing\">DBeaveri esimene k\u00e4ivitamine (Ubuntu)<\/a><\/li>\n<\/ul>\n<p style=\"text-align: justify\">Kui eelnevad sammud on l\u00e4bitud, peaks nii Windowsi, macOS&#8217;i kui ka Ubuntu kasutajatel olema ees sarnane pilt. Pane t\u00e4hele, et ette tuleb v\u00f5tta <em>Projects<\/em> men\u00fc\u00fc. Kui see esmalt olemas ei ole, saab selle avada valides \u00fclalolevalt men\u00fc\u00fcribalt Window -&gt; Projects. Kui Projects men\u00fc\u00fc on lahti, peaks pilt v\u00e4lja n\u00e4gema j\u00e4rgnev.<\/p>\n<p style=\"text-align: justify\"><span style=\"color: #ff00ff\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-915 aligncenter\" src=\"https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-content\/uploads\/sites\/21\/2021\/03\/projects_menuu_lahti-300x225.png\" alt=\"\" width=\"1025\" height=\"769\" srcset=\"https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-content\/uploads\/sites\/21\/2021\/03\/projects_menuu_lahti-300x225.png 300w, https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-content\/uploads\/sites\/21\/2021\/03\/projects_menuu_lahti-768x576.png 768w, https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-content\/uploads\/sites\/21\/2021\/03\/projects_menuu_lahti-65x49.png 65w, https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-content\/uploads\/sites\/21\/2021\/03\/projects_menuu_lahti-225x169.png 225w, https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-content\/uploads\/sites\/21\/2021\/03\/projects_menuu_lahti-350x263.png 350w, https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-content\/uploads\/sites\/21\/2021\/03\/projects_menuu_lahti.png 1024w\" sizes=\"auto, (max-width: 1025px) 100vw, 1025px\" \/><\/span><\/p>\n<p style=\"text-align: justify\">Kui n\u00fc\u00fcd vajutada projekti <em>General<\/em> juures olevat noolekest ning liikuda j\u00e4rjest s\u00fcgavamale (Windowsi ja Linuxi kasutajatel <em>General<\/em> -&gt; <em>Connections<\/em> -&gt; <em>postgres<\/em> -&gt; <em>postgres<\/em> -&gt; <em>Schemas<\/em>, macOS kasutajatel <em>General<\/em> -&gt; <em>Connections<\/em> -&gt; <em>postgres<\/em> -&gt; <em>sinu_arvuti_kasutajanimi<\/em> -&gt; <em>Schemas<\/em>), peaks n\u00e4htavale tulema andmebaasi skeem (ingl s<em>chema<\/em>) <em>public<\/em>. Andmebaasi skeem kirjeldab andmebaasis esinevaid tabeleid ja nendevahelisi seoseid, seega sisuliselt kirjeldab skeem andmebaasi struktuuri. Edaspidi nimetame lihtsuse m\u00f5ttes skeemi <em>public<\/em> andmebaasiks, mitte skeemiks, sest me loome edaspidi nii kui nii vaid \u00fche andmebaasi skeemi.<\/p>\n<p style=\"text-align: justify\"><span style=\"color: #ff00ff\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-914 aligncenter\" src=\"https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-content\/uploads\/sites\/21\/2021\/03\/public_schema_nahtaval-300x225.png\" alt=\"\" width=\"1024\" height=\"768\" srcset=\"https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-content\/uploads\/sites\/21\/2021\/03\/public_schema_nahtaval-300x225.png 300w, https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-content\/uploads\/sites\/21\/2021\/03\/public_schema_nahtaval-768x576.png 768w, https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-content\/uploads\/sites\/21\/2021\/03\/public_schema_nahtaval-65x49.png 65w, https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-content\/uploads\/sites\/21\/2021\/03\/public_schema_nahtaval-225x169.png 225w, https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-content\/uploads\/sites\/21\/2021\/03\/public_schema_nahtaval-350x263.png 350w, https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-content\/uploads\/sites\/21\/2021\/03\/public_schema_nahtaval.png 1024w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/span><\/p>\n<p style=\"text-align: justify\">Nagu n\u00e4ha, siis andmebaasi <em>public<\/em> all on alamkategooria <em>Tables<\/em>, mis hetkel veel \u00fchtegi tabelit ei sisalda. Selle sama andmebaasiga hakkame me edasistes peat\u00fckkides t\u00f6\u00f6d tegema ning sealjuures r\u00e4\u00e4gime andmebaasis <em>public<\/em> sisalduvast t\u00e4psemalt.<\/p>\n","protected":false},"author":33,"menu_order":3,"template":"","meta":{"pb_show_title":"on","pb_short_title":"","pb_subtitle":"","pb_authors":[],"pb_section_license":""},"chapter-type":[],"contributor":[],"license":[],"class_list":["post-84","chapter","type-chapter","status-publish","hentry"],"part":3,"_links":{"self":[{"href":"https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-json\/pressbooks\/v2\/chapters\/84","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-json\/pressbooks\/v2\/chapters"}],"about":[{"href":"https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-json\/wp\/v2\/types\/chapter"}],"author":[{"embeddable":true,"href":"https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-json\/wp\/v2\/users\/33"}],"version-history":[{"count":30,"href":"https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-json\/pressbooks\/v2\/chapters\/84\/revisions"}],"predecessor-version":[{"id":1431,"href":"https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-json\/pressbooks\/v2\/chapters\/84\/revisions\/1431"}],"part":[{"href":"https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-json\/pressbooks\/v2\/parts\/3"}],"metadata":[{"href":"https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-json\/pressbooks\/v2\/chapters\/84\/metadata\/"}],"wp:attachment":[{"href":"https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-json\/wp\/v2\/media?parent=84"}],"wp:term":[{"taxonomy":"chapter-type","embeddable":true,"href":"https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-json\/pressbooks\/v2\/chapter-type?post=84"},{"taxonomy":"contributor","embeddable":true,"href":"https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-json\/wp\/v2\/contributor?post=84"},{"taxonomy":"license","embeddable":true,"href":"https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-json\/wp\/v2\/license?post=84"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}