{"id":9018,"date":"2020-04-04T15:57:33","date_gmt":"2020-04-04T15:57:33","guid":{"rendered":"https:\/\/itmeister.ee\/?post_type=course&#038;p=9018"},"modified":"2026-03-11T22:53:38","modified_gmt":"2026-03-11T22:53:38","slug":"mysql","status":"publish","type":"course","link":"https:\/\/itmeister.ee\/ru\/course\/mysql\/","title":{"rendered":"MySQL. \u041f\u0440\u043e\u0435\u043a\u0442\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u0435 \u0431\u0430\u0437 \u0434\u0430\u043d\u043d\u044b\u0445"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"9018\" class=\"elementor elementor-9018\" data-elementor-post-type=\"course\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-edbaeef elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"edbaeef\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-wide\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-25bc09e0\" data-id=\"25bc09e0\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-add6268 icon-position-right content-align-left icon-box-vertical-align-top icon-vertical-align-start elementor-widget elementor-widget-the7_icon_box_grid_widget\" data-id=\"add6268\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"the7_icon_box_grid_widget.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"the7-box-grid-wrapper the7-elementor-widget loading-effect-none the7_icon_box_grid_widget-add6268\">\t\t\t<div class=\"dt-css-grid\">\n\t\t\t\t\t\t\t\t\t<div class=\"wf-cell shown\">\n\t\t\t\t\t\t<div class=\"the7-icon-box-grid\">\t\t\t\t\t\t\t<div class=\"box-content-wrapper\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a class=\"elementor-icon-div\" aria-label=\"\u00d5ppe kogumaht\">\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-icon\">\n\t\t\t\t\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"xlwpf wppb-font-clock\"><\/i>\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<\/a>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"box-content\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<h4 class=\"box-heading\">\n\t\t\t\t\t\t\t\t\t\t\t<a aria-label=\"\u00d5ppe kogumaht\">\t\t\t\t\t\t\t\t\t\t\t\t\u00d5ppe kogumaht\t\t\t\t\t\t\t\t\t\t\t<\/a>\t\t\t\t\t\t\t\t\t\t<\/h4>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"box-description\">85 ak.t. <br\/>(60 kontakt\u00f5pe ja 25 iseseisev t\u00f6\u00f6)<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<div class=\"wf-cell shown\">\n\t\t\t\t\t\t<div class=\"the7-icon-box-grid\">\t\t\t\t\t\t\t<div class=\"box-content-wrapper\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a class=\"elementor-icon-div\" aria-label=\"Toimumise aeg\">\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-icon\">\n\t\t\t\t\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"xlwpf wppb-font-calender-alt\"><\/i>\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<\/a>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"box-content\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<h4 class=\"box-heading\">\n\t\t\t\t\t\t\t\t\t\t\t<a aria-label=\"Toimumise aeg\">\t\t\t\t\t\t\t\t\t\t\t\tToimumise aeg\t\t\t\t\t\t\t\t\t\t\t<\/a>\t\t\t\t\t\t\t\t\t\t<\/h4>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"box-description\">30.03.26 - 05.06.26<br\/>\n13.04.26 - 19.06.26<br\/>\n27.04.26 - 03.07.26<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<div class=\"wf-cell shown\">\n\t\t\t\t\t\t<div class=\"the7-icon-box-grid\">\t\t\t\t\t\t\t<div class=\"box-content-wrapper\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a class=\"elementor-icon-div\" aria-label=\"\u00d5ppep\u00e4evad\">\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-icon\">\n\t\t\t\t\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"xlwpf wppb-font-calender\"><\/i>\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<\/a>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"box-content\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<h4 class=\"box-heading\">\n\t\t\t\t\t\t\t\t\t\t\t<a aria-label=\"\u00d5ppep\u00e4evad\">\t\t\t\t\t\t\t\t\t\t\t\t\u00d5ppep\u00e4evad\t\t\t\t\t\t\t\t\t\t\t<\/a>\t\t\t\t\t\t\t\t\t\t<\/h4>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"box-description\">kokkuleppel<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<div class=\"wf-cell shown\">\n\t\t\t\t\t\t<div class=\"the7-icon-box-grid\">\t\t\t\t\t\t\t<div class=\"box-content-wrapper\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a class=\"elementor-icon-div\" aria-label=\"\u00d5ppekeel\">\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-icon\">\n\t\t\t\t\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"material-icons md-translate\"><\/i>\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<\/a>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"box-content\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<h4 class=\"box-heading\">\n\t\t\t\t\t\t\t\t\t\t\t<a aria-label=\"\u00d5ppekeel\">\t\t\t\t\t\t\t\t\t\t\t\t\u00d5ppekeel\t\t\t\t\t\t\t\t\t\t\t<\/a>\t\t\t\t\t\t\t\t\t\t<\/h4>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"box-description\">Vene<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<div class=\"wf-cell shown\">\n\t\t\t\t\t\t<div class=\"the7-icon-box-grid\">\t\t\t\t\t\t\t<div class=\"box-content-wrapper\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a class=\"elementor-icon-div\" aria-label=\"Toimumise koht\">\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-icon\">\n\t\t\t\t\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"xlwpf wppb-font-location-map\"><\/i>\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<\/a>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"box-content\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<h4 class=\"box-heading\">\n\t\t\t\t\t\t\t\t\t\t\t<a aria-label=\"Toimumise koht\">\t\t\t\t\t\t\t\t\t\t\t\tToimumise koht\t\t\t\t\t\t\t\t\t\t\t<\/a>\t\t\t\t\t\t\t\t\t\t<\/h4>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"box-description\">J\u00f5e 2, Tallinn<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<div class=\"wf-cell shown\">\n\t\t\t\t\t\t<div class=\"the7-icon-box-grid\">\t\t\t\t\t\t\t<div class=\"box-content-wrapper\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a class=\"elementor-icon-div\" aria-label=\"\u00d5ppetasu\">\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-icon\">\n\t\t\t\t\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"xlsmpli simpline-credit-card\"><\/i>\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<\/a>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"box-content\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<h4 class=\"box-heading\">\n\t\t\t\t\t\t\t\t\t\t\t<a aria-label=\"\u00d5ppetasu\">\t\t\t\t\t\t\t\t\t\t\t\t\u00d5ppetasu\t\t\t\t\t\t\t\t\t\t\t<\/a>\t\t\t\t\t\t\t\t\t\t<\/h4>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"box-description\">1230 \u20ac + km\/osaleja<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/div>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-75d63d29 elementor-widget elementor-widget-heading\" data-id=\"75d63d29\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Eesm\u00e4rk<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4ec81947 elementor-widget elementor-widget-text-editor\" data-id=\"4ec81947\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Kursuse eesm\u00e4rgiks on anda osalejatele p\u00f5hjalikud teadmised ja praktilised oskused MySQL andmebaaside projekteerimise valdkonnas. Kursuse k\u00e4igus \u00f5pitakse m\u00f5istma andmebaasis\u00fcsteemide p\u00f5him\u00f5tteid, omandatakse oskused andmemudelite loomiseks, tabelite ja suhete kujundamiseks ning \u00f5pitakse kasutama SQL p\u00e4ringuid andmete haldamiseks, manipuleerimiseks ja anal\u00fc\u00fcsimiseks. Kursus v\u00f5imaldab osalejatel omandada vajalikud teadmised, et planeerida, disainida ja rakendada t\u00f5husaid andmebaase MySQL keskkonnas.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e3cb4a9 elementor-widget elementor-widget-heading\" data-id=\"e3cb4a9\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">\u00d5ppekava<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7a5c86b4 elementor-widget elementor-widget-the7-accordion\" data-id=\"7a5c86b4\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"the7-accordion.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-accordion the7-adv-accordion ac_bb_active_title ac_left_right_borders\" data-accordion-type=\"accordion\" role=\"tablist\">\n\t\t\t\t\t\t\t<div class=\"elementor-accordion-item\">\n\t\t\t\t\t<h4 id=\"elementor-tab-title-2051\" class=\"elementor-tab-title the7-accordion-header deactive-default\" data-tab=\"1\" role=\"tab\" aria-controls=\"elementor-tab-content-2051\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon elementor-accordion-icon-right\" aria-hidden=\"true\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon-closed\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 24 24\" width=\"24\" height=\"24\"><path fill=\"none\" d=\"M0 0h24v24H0z\"><\/path><path d=\"M12 13.172l4.95-4.95 1.414 1.414L12 16 5.636 9.636 7.05 8.222z\"><\/path><\/svg><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon-opened\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 24 24\" width=\"24\" height=\"24\"><path fill=\"none\" d=\"M0 0h24v24H0z\"><\/path><path d=\"M12 10.828l-4.95 4.95-1.414-1.414L12 8l6.364 6.364-1.414 1.414z\"><\/path><\/svg><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a class=\"elementor-accordion-title\" href=\"\">Moodul 1: Andmebaaside alused (4 ak.t)<\/a>\n\t\t\t\t\t<\/h4>\n\t\t\t\t\t<div id=\"elementor-tab-content-2051\" class=\"elementor-tab-content elementor-clearfix deactive-default\" data-tab=\"1\" role=\"tabpanel\" aria-labelledby=\"elementor-tab-title-2051\"><p>1.1. Sissejuhatus andmebaasidesse.<br \/>&#8211; Tutvumine andmebaaside m\u00f5istega.<br \/>&#8211; Andmebaaside roll infos\u00fcsteemides.<br \/>1.2. Relatsioonandmebaaside struktuur.<br \/>&#8211; P\u00f5hilised komponendid relatsioonandmebaasis.<br \/>&#8211; Tabelid, v\u00e4ljad, kirjed.<\/p><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<div class=\"elementor-accordion-item\">\n\t\t\t\t\t<h4 id=\"elementor-tab-title-2052\" class=\"elementor-tab-title the7-accordion-header\" data-tab=\"2\" role=\"tab\" aria-controls=\"elementor-tab-content-2052\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon elementor-accordion-icon-right\" aria-hidden=\"true\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon-closed\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 24 24\" width=\"24\" height=\"24\"><path fill=\"none\" d=\"M0 0h24v24H0z\"><\/path><path d=\"M12 13.172l4.95-4.95 1.414 1.414L12 16 5.636 9.636 7.05 8.222z\"><\/path><\/svg><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon-opened\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 24 24\" width=\"24\" height=\"24\"><path fill=\"none\" d=\"M0 0h24v24H0z\"><\/path><path d=\"M12 10.828l-4.95 4.95-1.414-1.414L12 8l6.364 6.364-1.414 1.414z\"><\/path><\/svg><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a class=\"elementor-accordion-title\" href=\"\">Moodul 2: SQLi p\u00f5hit\u00f5ed (8 ak.t)<\/a>\n\t\t\t\t\t<\/h4>\n\t\t\t\t\t<div id=\"elementor-tab-content-2052\" class=\"elementor-tab-content elementor-clearfix\" data-tab=\"2\" role=\"tabpanel\" aria-labelledby=\"elementor-tab-title-2052\"><p>2.1. Sissejuhatus SQL-i.<br \/>&#8211; P\u00e4ringu stiil ja selle t\u00e4htsus.<br \/>&#8211; SELECT. Duplikaatide eemaldamine, DISTINCT.<br \/>2.2. Loogilised operaatorid ja tingimuslikud konstruktsioonid.<br \/>&#8211; V\u00f5rdlusoperaatorid: =, &lt;&gt;, &lt;, &gt;, &lt;=, &gt;=.<br \/>&#8211; Operaator LIKE.<br \/>&#8211; Loogilised operaatorid: AND, OR, NOT.<br \/>&#8211; Andmete filtreerimine (BETWEEN, IN, LIKE, IS NULL).<br \/>&#8211; Andmete sorteerimine (ORDER BY).<br \/>&#8211; Tingimuslikud konstruktsioonid operaatoritega CASE, CASE, IF THEN, ELSE.<br \/>2.3. Valiku piiramine: LIMIT.<\/p><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<div class=\"elementor-accordion-item\">\n\t\t\t\t\t<h4 id=\"elementor-tab-title-2053\" class=\"elementor-tab-title the7-accordion-header\" data-tab=\"3\" role=\"tab\" aria-controls=\"elementor-tab-content-2053\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon elementor-accordion-icon-right\" aria-hidden=\"true\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon-closed\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 24 24\" width=\"24\" height=\"24\"><path fill=\"none\" d=\"M0 0h24v24H0z\"><\/path><path d=\"M12 13.172l4.95-4.95 1.414 1.414L12 16 5.636 9.636 7.05 8.222z\"><\/path><\/svg><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon-opened\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 24 24\" width=\"24\" height=\"24\"><path fill=\"none\" d=\"M0 0h24v24H0z\"><\/path><path d=\"M12 10.828l-4.95 4.95-1.414-1.414L12 8l6.364 6.364-1.414 1.414z\"><\/path><\/svg><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a class=\"elementor-accordion-title\" href=\"\">Moodul 3: Andmebaasi ja tabelite loomine ja kustutamine (6 ak.t)<\/a>\n\t\t\t\t\t<\/h4>\n\t\t\t\t\t<div id=\"elementor-tab-content-2053\" class=\"elementor-tab-content elementor-clearfix\" data-tab=\"3\" role=\"tabpanel\" aria-labelledby=\"elementor-tab-title-2053\"><p>3.1. Andmebaasi loomine ja kustutamine.<br \/>&#8211; Operaatorid CREATE DATABASE ja DROP DATABASE.<br \/>3.2. Andmet\u00fc\u00fcbid MySQLis.<br \/>&#8211; CHAR, VARCHAR, INT, DECIMAL, DATE ja muud.<br \/>&#8211; Operaatorid CREATE TABLE ja ALTER TABLE.<br \/>3.3 V\u00f5tmed ja piirangud.<br \/>&#8211; PRIMARY KEY, FOREIGN KEY, UNIQUE, NOT NULL.<\/p><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<div class=\"elementor-accordion-item\">\n\t\t\t\t\t<h4 id=\"elementor-tab-title-2054\" class=\"elementor-tab-title the7-accordion-header\" data-tab=\"4\" role=\"tab\" aria-controls=\"elementor-tab-content-2054\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon elementor-accordion-icon-right\" aria-hidden=\"true\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon-closed\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 24 24\" width=\"24\" height=\"24\"><path fill=\"none\" d=\"M0 0h24v24H0z\"><\/path><path d=\"M12 13.172l4.95-4.95 1.414 1.414L12 16 5.636 9.636 7.05 8.222z\"><\/path><\/svg><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon-opened\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 24 24\" width=\"24\" height=\"24\"><path fill=\"none\" d=\"M0 0h24v24H0z\"><\/path><path d=\"M12 10.828l-4.95 4.95-1.414-1.414L12 8l6.364 6.364-1.414 1.414z\"><\/path><\/svg><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a class=\"elementor-accordion-title\" href=\"\">Moodul 4: SQL-i funktsioonid (6 ak.t)<\/a>\n\t\t\t\t\t<\/h4>\n\t\t\t\t\t<div id=\"elementor-tab-content-2054\" class=\"elementor-tab-content elementor-clearfix\" data-tab=\"4\" role=\"tabpanel\" aria-labelledby=\"elementor-tab-title-2054\"><p>4.1. Matemaatilised ja stringifunktsioonid.<br \/>&#8211; Lihtsad matemaatilised v\u00e4ljendid SQL-is.<br \/>&#8211; Funktsioonid SUM, MIN, MAX, AVG, COUNT.<br \/>&#8211; Stringifunktsioonid: CONCAT, SUBSTRING, REPLACE ja teised.<br \/>4.2. Operaator GROUP BY ja HAVING.<br \/>&#8211; Andmete grupeerimine.<br \/>&#8211; Gruppide filtreerimine.<\/p><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<div class=\"elementor-accordion-item\">\n\t\t\t\t\t<h4 id=\"elementor-tab-title-2055\" class=\"elementor-tab-title the7-accordion-header\" data-tab=\"5\" role=\"tab\" aria-controls=\"elementor-tab-content-2055\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon elementor-accordion-icon-right\" aria-hidden=\"true\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon-closed\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 24 24\" width=\"24\" height=\"24\"><path fill=\"none\" d=\"M0 0h24v24H0z\"><\/path><path d=\"M12 13.172l4.95-4.95 1.414 1.414L12 16 5.636 9.636 7.05 8.222z\"><\/path><\/svg><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon-opened\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 24 24\" width=\"24\" height=\"24\"><path fill=\"none\" d=\"M0 0h24v24H0z\"><\/path><path d=\"M12 10.828l-4.95 4.95-1.414-1.414L12 8l6.364 6.364-1.414 1.414z\"><\/path><\/svg><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a class=\"elementor-accordion-title\" href=\"\">Moodul 5: Andmete sisestamine, uuendamine ja kustutamine (4 ak.t)<\/a>\n\t\t\t\t\t<\/h4>\n\t\t\t\t\t<div id=\"elementor-tab-content-2055\" class=\"elementor-tab-content elementor-clearfix\" data-tab=\"5\" role=\"tabpanel\" aria-labelledby=\"elementor-tab-title-2055\"><p>5.1. Andmete sisestamine tabelisse (INSERT).<br \/>5.2. Andmete uuendamine (UPDATE).<br \/>5.3. Andmete kustutamine (DELETE).<\/p><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<div class=\"elementor-accordion-item\">\n\t\t\t\t\t<h4 id=\"elementor-tab-title-2056\" class=\"elementor-tab-title the7-accordion-header\" data-tab=\"6\" role=\"tab\" aria-controls=\"elementor-tab-content-2056\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon elementor-accordion-icon-right\" aria-hidden=\"true\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon-closed\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 24 24\" width=\"24\" height=\"24\"><path fill=\"none\" d=\"M0 0h24v24H0z\"><\/path><path d=\"M12 13.172l4.95-4.95 1.414 1.414L12 16 5.636 9.636 7.05 8.222z\"><\/path><\/svg><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon-opened\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 24 24\" width=\"24\" height=\"24\"><path fill=\"none\" d=\"M0 0h24v24H0z\"><\/path><path d=\"M12 10.828l-4.95 4.95-1.414-1.414L12 8l6.364 6.364-1.414 1.414z\"><\/path><\/svg><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a class=\"elementor-accordion-title\" href=\"\">Moodul 6: Tabelitevahelised seosed (5 ak.t)<\/a>\n\t\t\t\t\t<\/h4>\n\t\t\t\t\t<div id=\"elementor-tab-content-2056\" class=\"elementor-tab-content elementor-clearfix\" data-tab=\"6\" role=\"tabpanel\" aria-labelledby=\"elementor-tab-title-2056\"><p>6.1.Operaatorid JOIN ja UNION.<br \/>&#8211; Tabelite \u00fchendamise t\u00fc\u00fcbid: INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN.<br \/>&#8211; UNION ja UNION ALL p\u00e4ringute tulemuste \u00fchendamine.<\/p><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<div class=\"elementor-accordion-item\">\n\t\t\t\t\t<h4 id=\"elementor-tab-title-2057\" class=\"elementor-tab-title the7-accordion-header\" data-tab=\"7\" role=\"tab\" aria-controls=\"elementor-tab-content-2057\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon elementor-accordion-icon-right\" aria-hidden=\"true\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon-closed\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 24 24\" width=\"24\" height=\"24\"><path fill=\"none\" d=\"M0 0h24v24H0z\"><\/path><path d=\"M12 13.172l4.95-4.95 1.414 1.414L12 16 5.636 9.636 7.05 8.222z\"><\/path><\/svg><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon-opened\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 24 24\" width=\"24\" height=\"24\"><path fill=\"none\" d=\"M0 0h24v24H0z\"><\/path><path d=\"M12 10.828l-4.95 4.95-1.414-1.414L12 8l6.364 6.364-1.414 1.414z\"><\/path><\/svg><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a class=\"elementor-accordion-title\" href=\"\">Moodul 7: Vaadete loomine, muutmine ja kustutamine (2 ak.t)<\/a>\n\t\t\t\t\t<\/h4>\n\t\t\t\t\t<div id=\"elementor-tab-content-2057\" class=\"elementor-tab-content elementor-clearfix\" data-tab=\"7\" role=\"tabpanel\" aria-labelledby=\"elementor-tab-title-2057\"><p>7.1. Vaadete m\u00f5iste (VIEW).<br \/>7.2. Vaadete loomine, muutmine ja kustutamine.<\/p><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<div class=\"elementor-accordion-item\">\n\t\t\t\t\t<h4 id=\"elementor-tab-title-2058\" class=\"elementor-tab-title the7-accordion-header\" data-tab=\"8\" role=\"tab\" aria-controls=\"elementor-tab-content-2058\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon elementor-accordion-icon-right\" aria-hidden=\"true\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon-closed\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 24 24\" width=\"24\" height=\"24\"><path fill=\"none\" d=\"M0 0h24v24H0z\"><\/path><path d=\"M12 13.172l4.95-4.95 1.414 1.414L12 16 5.636 9.636 7.05 8.222z\"><\/path><\/svg><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon-opened\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 24 24\" width=\"24\" height=\"24\"><path fill=\"none\" d=\"M0 0h24v24H0z\"><\/path><path d=\"M12 10.828l-4.95 4.95-1.414-1.414L12 8l6.364 6.364-1.414 1.414z\"><\/path><\/svg><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a class=\"elementor-accordion-title\" href=\"\">Moodul 8: Andmete eksportimine (2 ak.t)<\/a>\n\t\t\t\t\t<\/h4>\n\t\t\t\t\t<div id=\"elementor-tab-content-2058\" class=\"elementor-tab-content elementor-clearfix\" data-tab=\"8\" role=\"tabpanel\" aria-labelledby=\"elementor-tab-title-2058\"><p>8.1. Andmete importimine ja eksportimine.<br \/>&#8211; Andmete laadimine tabelisse.<br \/>&#8211; Andmete eksportimine tabelist.<\/p><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<div class=\"elementor-accordion-item\">\n\t\t\t\t\t<h4 id=\"elementor-tab-title-2059\" class=\"elementor-tab-title the7-accordion-header\" data-tab=\"9\" role=\"tab\" aria-controls=\"elementor-tab-content-2059\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon elementor-accordion-icon-right\" aria-hidden=\"true\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon-closed\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 24 24\" width=\"24\" height=\"24\"><path fill=\"none\" d=\"M0 0h24v24H0z\"><\/path><path d=\"M12 13.172l4.95-4.95 1.414 1.414L12 16 5.636 9.636 7.05 8.222z\"><\/path><\/svg><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon-opened\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 24 24\" width=\"24\" height=\"24\"><path fill=\"none\" d=\"M0 0h24v24H0z\"><\/path><path d=\"M12 10.828l-4.95 4.95-1.414-1.414L12 8l6.364 6.364-1.414 1.414z\"><\/path><\/svg><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a class=\"elementor-accordion-title\" href=\"\">Moodul 9: Turvalisus MySQL-is  (4 ak. t)<\/a>\n\t\t\t\t\t<\/h4>\n\t\t\t\t\t<div id=\"elementor-tab-content-2059\" class=\"elementor-tab-content elementor-clearfix\" data-tab=\"9\" role=\"tabpanel\" aria-labelledby=\"elementor-tab-title-2059\"><p>9.1. Andmebaaside turvalisuse alused.<br \/>&#8211; SQL-s\u00fcstimised ja nende ennetamine.<br \/>&#8211; Kasutajad ja privileegid.<\/p><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<div class=\"elementor-accordion-item\">\n\t\t\t\t\t<h4 id=\"elementor-tab-title-20510\" class=\"elementor-tab-title the7-accordion-header\" data-tab=\"10\" role=\"tab\" aria-controls=\"elementor-tab-content-20510\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon elementor-accordion-icon-right\" aria-hidden=\"true\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon-closed\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 24 24\" width=\"24\" height=\"24\"><path fill=\"none\" d=\"M0 0h24v24H0z\"><\/path><path d=\"M12 13.172l4.95-4.95 1.414 1.414L12 16 5.636 9.636 7.05 8.222z\"><\/path><\/svg><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon-opened\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 24 24\" width=\"24\" height=\"24\"><path fill=\"none\" d=\"M0 0h24v24H0z\"><\/path><path d=\"M12 10.828l-4.95 4.95-1.414-1.414L12 8l6.364 6.364-1.414 1.414z\"><\/path><\/svg><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a class=\"elementor-accordion-title\" href=\"\">Moodul 10: Salvestatud protseduurid ja funktsioonid (6 ak.t)<\/a>\n\t\t\t\t\t<\/h4>\n\t\t\t\t\t<div id=\"elementor-tab-content-20510\" class=\"elementor-tab-content elementor-clearfix\" data-tab=\"10\" role=\"tabpanel\" aria-labelledby=\"elementor-tab-title-20510\"><p>10.1. Salvestatud protseduuride loomine ja k\u00e4ivitamine.<br \/>&#8211; Salvestatud protseduuride loomise s\u00fcntaks.<br \/>&#8211; Parameetrite edastamine salvestatud protseduuridele.<br \/>&#8211; Lihtsate salvestatud protseduuride loomise ja k\u00e4ivitamise n\u00e4ited.<br \/>10.2. Salvestatud funktsioonide loomine ja k\u00e4ivitamine.<br \/>&#8211; Salvestatud funktsioonide loomise s\u00fcntaks.<br \/>&#8211; T\u00f6\u00f6 tagastatavate v\u00e4\u00e4rtustega.<br \/>&#8211; Salvestatud funktsioonide kasutamine p\u00e4ringutes.<\/p><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<div class=\"elementor-accordion-item\">\n\t\t\t\t\t<h4 id=\"elementor-tab-title-20511\" class=\"elementor-tab-title the7-accordion-header\" data-tab=\"11\" role=\"tab\" aria-controls=\"elementor-tab-content-20511\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon elementor-accordion-icon-right\" aria-hidden=\"true\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon-closed\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 24 24\" width=\"24\" height=\"24\"><path fill=\"none\" d=\"M0 0h24v24H0z\"><\/path><path d=\"M12 13.172l4.95-4.95 1.414 1.414L12 16 5.636 9.636 7.05 8.222z\"><\/path><\/svg><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon-opened\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 24 24\" width=\"24\" height=\"24\"><path fill=\"none\" d=\"M0 0h24v24H0z\"><\/path><path d=\"M12 10.828l-4.95 4.95-1.414-1.414L12 8l6.364 6.364-1.414 1.414z\"><\/path><\/svg><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a class=\"elementor-accordion-title\" href=\"\">Moodul 11: Trigerid MySQL-is (5 ak.t)<\/a>\n\t\t\t\t\t<\/h4>\n\t\t\t\t\t<div id=\"elementor-tab-content-20511\" class=\"elementor-tab-content elementor-clearfix\" data-tab=\"11\" role=\"tabpanel\" aria-labelledby=\"elementor-tab-title-20511\"><p>11.1. Trigerite loomine ja kasutamine.<br \/>&#8211; Trigerite loomise s\u00fcntaks.<br \/>&#8211; Trigerid s\u00fcndmuste INSERT, UPDATE, DELETE korral.<br \/>&#8211; Trigerite kasutamise n\u00e4ited andmete automaatseks muutmiseks.<\/p><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<div class=\"elementor-accordion-item\">\n\t\t\t\t\t<h4 id=\"elementor-tab-title-20512\" class=\"elementor-tab-title the7-accordion-header\" data-tab=\"12\" role=\"tab\" aria-controls=\"elementor-tab-content-20512\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon elementor-accordion-icon-right\" aria-hidden=\"true\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon-closed\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 24 24\" width=\"24\" height=\"24\"><path fill=\"none\" d=\"M0 0h24v24H0z\"><\/path><path d=\"M12 13.172l4.95-4.95 1.414 1.414L12 16 5.636 9.636 7.05 8.222z\"><\/path><\/svg><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon-opened\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 24 24\" width=\"24\" height=\"24\"><path fill=\"none\" d=\"M0 0h24v24H0z\"><\/path><path d=\"M12 10.828l-4.95 4.95-1.414-1.414L12 8l6.364 6.364-1.414 1.414z\"><\/path><\/svg><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a class=\"elementor-accordion-title\" href=\"\">Moodul 12: Andmebaaside projekteerimine (8 ak.t)<\/a>\n\t\t\t\t\t<\/h4>\n\t\t\t\t\t<div id=\"elementor-tab-content-20512\" class=\"elementor-tab-content elementor-clearfix\" data-tab=\"12\" role=\"tabpanel\" aria-labelledby=\"elementor-tab-title-20512\"><p>12.1. Andmebaasimudeli loomine.<br \/>&#8211; Andmebaasimudeli koostamise p\u00f5him\u00f5tted.<br \/>&#8211; Andmete struktureerimine tabeliteks ja v\u00e4ljadeks.<br \/>12.2. Andmebaasidisaini p\u00f5him\u00f5tted.<br \/>&#8211; Andmebaasi normaalkuju.<br \/>&#8211; Andmebaasi tervikluse tagamine.<br \/>&#8211; V\u00f5tmev\u00e4ljade kasutamine.<br \/>12.3. Andmebaaside optimeerimine.<br \/>&#8211; Andmebaasi j\u00f5udluse m\u00f5\u00f5tmine ja optimeerimine.<br \/>&#8211; Indeksite kasutamine.<br \/>&#8211; Tabelite partitsioneerimine.<\/p><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-afdf2bd elementor-widget elementor-widget-heading\" data-id=\"afdf2bd\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">\u00d5piv\u00e4ljundid<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-fec5be0 elementor-widget elementor-widget-text-editor\" data-id=\"fec5be0\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Koolituse l\u00f5petanu:<\/p><ul><li>suudab luua andmemudeleid, sealhulgas kavandada ja kujundada andmebaase, tabelite struktuuri ja suhteid<\/li><li>oskab koostada SQL p\u00e4ringuid, sealhulgas andmete p\u00e4rimist, sisestamist, uuendamist ja kustutamist andmebaasist<\/li><li>m\u00f5istab, kuidas optimeerida andmebaase, et parandada p\u00e4ringute j\u00f5udlust ja t\u00f5husust<\/li><li>on teadlik andmete turvalisuse ja tervikluse olulisusest ning oskab rakendada sobivaid meetmeid andmete kaitsmiseks volitamata juurdep\u00e4\u00e4su eest<\/li><li>suudab planeerida, projekteerida ja rakendada t\u00f5husaid andmebaase vastavalt konkreetsetele n\u00f5uetele ja \u00e4riprotsessidele, kasutades MySQL-i<\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e86cea0 elementor-widget elementor-widget-heading\" data-id=\"e86cea0\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Sihtr\u00fchm<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-aea6073 elementor-widget elementor-widget-text-editor\" data-id=\"aea6073\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Koolitus on suunatud IT-spetsialistidele, andmeanal\u00fc\u00fctikutele, tarkvaraarendajatele, \u00e4rijuhtidele ja \u00fcli\u00f5pilastele, kes soovivad laiendada oma teadmisi andmebaaside valdkonnas, \u00f5ppida SQL-i p\u00e4ringute koostamist ning omandada praktilisi oskusi andmemudelite loomisel ja andmebaaside integreerimisel. Koolitus aitab osalejatel paremini hallata andmeid, teha informeeritud otsuseid ning arendada t\u00f5husaid rakendusi.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ae9b456 elementor-widget elementor-widget-heading\" data-id=\"ae9b456\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">\u00d5ppemeetodid<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2c3cdc6 elementor-widget elementor-widget-text-editor\" data-id=\"2c3cdc6\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Auditoorne t\u00f6\u00f6 (60 ak.t): loengud, praktilised harjutused, r\u00fchmat\u00f6\u00f6d<br \/>Iseseisev t\u00f6\u00f6 (25 ak.t): kindlate eesm\u00e4rkidega t\u00f6\u00f6- ja \u00f5ppe\u00fclesannete t\u00e4itmine, mille kohta koolitaja annab tagasisidet<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-bf62ae4 elementor-widget elementor-widget-heading\" data-id=\"bf62ae4\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">\u00d5ppematerjalid<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4a45460 elementor-widget elementor-widget-text-editor\" data-id=\"4a45460\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Koolitusel osalejad saavad teemakohased jaotusmaterjalid elektroonselt, mis on koostatud koolitaja poolt koolituse k\u00f5ikide teemade kohta.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-02e64c2 elementor-widget elementor-widget-heading\" data-id=\"02e64c2\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">\u00d5ppekeskkond<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6d12f45 elementor-widget elementor-widget-text-editor\" data-id=\"6d12f45\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<div>Koolitus toimub arvutiklassides kogu vajaliku tehnilise varustusega. Grupi suurus on kuni 10 osalejat.\u00a0<\/div><div>Koolitus v\u00f5ib toimuda ka reaalajas veebikeskkonnas.\u00a0<br \/>Juurdep\u00e4\u00e4s ratastooliga liikumiseks on olemas.<\/div><div>\u00d5ppekeskkonna kirjeldus: <a href=\"https:\/\/itmeister.ee\/oppekorralduse-alused\/\">\u00f5ppekorralduse alused<\/a><\/div>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-23ba057 elementor-widget elementor-widget-heading\" data-id=\"23ba057\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Hindamiskriteerium<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7b22e7b elementor-widget elementor-widget-text-editor\" data-id=\"7b22e7b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>\u00d5piv\u00e4ljundeid hinnatakse iseseisvalt sooritatud praktiliste t\u00f6\u00f6de p\u00f5hjal.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-25a0f32 elementor-widget elementor-widget-heading\" data-id=\"25a0f32\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">L\u00f5petamise tingimused ja v\u00e4ljastatavad dokumendid<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b9e351b elementor-widget elementor-widget-text-editor\" data-id=\"b9e351b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Koolituse l\u00f5ppedes v\u00e4ljastab koolituskeskus tunnistuse v\u00f5i t\u00f5endi. Koolituse l\u00e4binule v\u00e4ljastatakse tunnistus juhul, kui \u00f5ppija on osalenud v\u00e4hemalt 75% \u00f5ppetundidest ja t\u00e4itnud 75% praktilistest \u00fclesannetest. T\u00f5end osalemise v\u00f5i t\u00e4iendkoolituse l\u00e4bimise kohta v\u00e4ljastatakse juhul, kui \u00f5ppija ei ole saavutanud k\u00f5iki \u00f5ppekava l\u00f5petamiseks n\u00f5utud \u00f5piv\u00e4ljundeid, kuid v\u00f5ttis osa \u00f5ppet\u00f6\u00f6st.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3eb3e16 elementor-widget elementor-widget-heading\" data-id=\"3eb3e16\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Koolitaja kompetentsust tagava kvalifikatsiooni v\u00f5i \u00f5pi- v\u00f5i t\u00f6\u00f6kogemuse kirjeldus<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6905cb9 elementor-widget elementor-widget-text-editor\" data-id=\"6905cb9\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>K\u00f5rgharidus, ja on aktiivselt tegutsenud \u00f5petatavas valdkonnas v\u00f5i omavad vastavasisulist kogemust (\u00f5petamiskogemus IKT valdkonnas)<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-529f85b elementor-widget elementor-widget-heading\" data-id=\"529f85b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">\u00d5ppekavar\u00fchm<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-14f6dce elementor-widget elementor-widget-text-editor\" data-id=\"14f6dce\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>0611 Arvutikasutus<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-1546f154\" data-id=\"1546f154\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-6a66de2 elementor-widget elementor-widget-menu-anchor\" data-id=\"6a66de2\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"menu-anchor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-menu-anchor\" id=\"registreerimine\"><\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2c2f747 elementor-widget elementor-widget-heading\" data-id=\"2c2f747\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Registreerimine<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-daf636a elementor-button-align-stretch elementor-widget elementor-widget-form\" data-id=\"daf636a\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;step_next_label&quot;:&quot;Next&quot;,&quot;step_previous_label&quot;:&quot;Previous&quot;,&quot;step_type&quot;:&quot;none&quot;,&quot;button_width&quot;:&quot;100&quot;,&quot;step_icon_shape&quot;:&quot;circle&quot;}\" data-widget_type=\"form.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<form class=\"elementor-form\" method=\"post\" name=\"mysql kursus\" aria-label=\"mysql kursus\">\n\t\t\t<input type=\"hidden\" name=\"post_id\" value=\"9018\"\/>\n\t\t\t<input type=\"hidden\" name=\"form_id\" value=\"daf636a\"\/>\n\t\t\t<input type=\"hidden\" name=\"referer_title\" value=\"\" \/>\n\n\t\t\t\n\t\t\t<div class=\"elementor-form-fields-wrapper elementor-labels-above\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-field-type-hidden elementor-field-group elementor-column elementor-field-group-field_f4dccba elementor-col-100\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t<input size=\"1\" type=\"hidden\" name=\"form_fields[field_f4dccba]\" id=\"form-field-field_f4dccba\" class=\"elementor-field elementor-size-sm  elementor-field-textual\">\n\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<div class=\"elementor-field-type-text elementor-field-group elementor-column elementor-field-group-name elementor-col-100 elementor-field-required elementor-mark-required\">\n\t\t\t\t\t\t\t\t\t\t\t\t<label for=\"form-field-name\" class=\"elementor-field-label\">\n\t\t\t\t\t\t\t\tNimi\t\t\t\t\t\t\t<\/label>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<input size=\"1\" type=\"text\" name=\"form_fields[name]\" id=\"form-field-name\" class=\"elementor-field elementor-size-sm  elementor-field-textual\" required=\"required\">\n\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<div class=\"elementor-field-type-radio elementor-field-group elementor-column elementor-field-group-field_8d8900e elementor-col-100 elementor-field-required elementor-mark-required\">\n\t\t\t\t\t\t\t\t\t\t\t\t<label for=\"form-field-field_8d8900e\" class=\"elementor-field-label\">\n\t\t\t\t\t\t\t\tToimumise aeg\t\t\t\t\t\t\t<\/label>\n\t\t\t\t\t\t<div class=\"elementor-field-subgroup  \"><span class=\"elementor-field-option\"><input type=\"radio\" value=\"30.03.26 - 05.06.26\" id=\"form-field-field_8d8900e-0\" name=\"form_fields[field_8d8900e]\" required=\"required\"> <label for=\"form-field-field_8d8900e-0\">30.03.26 - 05.06.26<\/label><\/span><span class=\"elementor-field-option\"><input type=\"radio\" value=\"13.04.26 - 19.06.26\" id=\"form-field-field_8d8900e-1\" name=\"form_fields[field_8d8900e]\" required=\"required\"> <label for=\"form-field-field_8d8900e-1\">13.04.26 - 19.06.26<\/label><\/span><span class=\"elementor-field-option\"><input type=\"radio\" value=\"27.04.26 - 03.07.26\" id=\"form-field-field_8d8900e-2\" name=\"form_fields[field_8d8900e]\" required=\"required\"> <label for=\"form-field-field_8d8900e-2\">27.04.26 - 03.07.26<\/label><\/span><\/div>\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<div class=\"elementor-field-type-email elementor-field-group elementor-column elementor-field-group-email elementor-col-100 elementor-field-required elementor-mark-required\">\n\t\t\t\t\t\t\t\t\t\t\t\t<label for=\"form-field-email\" class=\"elementor-field-label\">\n\t\t\t\t\t\t\t\tEmail\t\t\t\t\t\t\t<\/label>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<input size=\"1\" type=\"email\" name=\"form_fields[email]\" id=\"form-field-email\" class=\"elementor-field elementor-size-sm  elementor-field-textual\" required=\"required\">\n\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<div class=\"elementor-field-type-number elementor-field-group elementor-column elementor-field-group-field_efc1dfd elementor-col-100\">\n\t\t\t\t\t\t\t\t\t\t\t\t<label for=\"form-field-field_efc1dfd\" class=\"elementor-field-label\">\n\t\t\t\t\t\t\t\tTelefon\t\t\t\t\t\t\t<\/label>\n\t\t\t\t\t\t\t\t\t<input type=\"number\" name=\"form_fields[field_efc1dfd]\" id=\"form-field-field_efc1dfd\" class=\"elementor-field elementor-size-sm  elementor-field-textual\" min=\"\" max=\"\" >\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<div class=\"elementor-field-type-number elementor-field-group elementor-column elementor-field-group-field_698bd9f elementor-col-100 elementor-field-required elementor-mark-required\">\n\t\t\t\t\t\t\t\t\t\t\t\t<label for=\"form-field-field_698bd9f\" class=\"elementor-field-label\">\n\t\t\t\t\t\t\t\tIsikukood\t\t\t\t\t\t\t<\/label>\n\t\t\t\t\t\t\t\t\t<input type=\"number\" name=\"form_fields[field_698bd9f]\" id=\"form-field-field_698bd9f\" class=\"elementor-field elementor-size-sm  elementor-field-textual\" required=\"required\" min=\"\" max=\"\" >\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<div class=\"elementor-field-type-radio elementor-field-group elementor-column elementor-field-group-field_194f95f elementor-col-100 elementor-field-required elementor-mark-required\">\n\t\t\t\t\t\t\t\t\t\t\t\t<label for=\"form-field-field_194f95f\" class=\"elementor-field-label\">\n\t\t\t\t\t\t\t\t\u00d5ppemaksu tasub\t\t\t\t\t\t\t<\/label>\n\t\t\t\t\t\t<div class=\"elementor-field-subgroup  elementor-subgroup-inline\"><span class=\"elementor-field-option\"><input type=\"radio\" value=\"Eraisik\" id=\"form-field-field_194f95f-0\" name=\"form_fields[field_194f95f]\" required=\"required\"> <label for=\"form-field-field_194f95f-0\">Eraisik<\/label><\/span><span class=\"elementor-field-option\"><input type=\"radio\" value=\"Firma\" id=\"form-field-field_194f95f-1\" name=\"form_fields[field_194f95f]\" required=\"required\"> <label for=\"form-field-field_194f95f-1\">Firma<\/label><\/span><\/div>\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<div class=\"elementor-field-type-textarea elementor-field-group elementor-column elementor-field-group-message elementor-col-100\">\n\t\t\t\t\t\t\t\t\t\t\t\t<label for=\"form-field-message\" class=\"elementor-field-label\">\n\t\t\t\t\t\t\t\tKommentaar \/ Firma rekvisiidid\t\t\t\t\t\t\t<\/label>\n\t\t\t\t\t\t<textarea class=\"elementor-field-textual elementor-field  elementor-size-sm\" name=\"form_fields[message]\" id=\"form-field-message\" rows=\"4\"><\/textarea>\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<div class=\"elementor-field-type-acceptance elementor-field-group elementor-column elementor-field-group-field_4ce5340 elementor-col-100 elementor-field-required elementor-mark-required\">\n\t\t\t\t\t\t\t<div class=\"elementor-field-subgroup\">\n\t\t\t<span class=\"elementor-field-option\">\n\t\t\t\t<input type=\"checkbox\" name=\"form_fields[field_4ce5340]\" id=\"form-field-field_4ce5340\" class=\"elementor-field elementor-size-sm  elementor-acceptance-field\" required=\"required\">\n\t\t\t\t<label for=\"form-field-field_4ce5340\">Olen n\u00f5us <a href=\"https:\/\/itmeister.ee\/registreerimise-tingimused\/\" target=\"_blank\">registreerimise tingimustega<\/a><\/label>\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<div class=\"elementor-field-group elementor-column elementor-field-type-submit elementor-col-100 e-form__buttons\">\n\t\t\t\t\t<button class=\"elementor-button elementor-size-sm\" type=\"submit\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-button-icon\">\n\t\t\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"xlsmpli simpline-pencil\"><\/i>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-button-text\">Registreeri<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/button>\n\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t<\/form>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-30770fb elementor-widget elementor-widget-spacer\" data-id=\"30770fb\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f700f3f icon-position-right content-align-left icon-box-vertical-align-top icon-vertical-align-start elementor-widget elementor-widget-the7_icon_box_widget\" data-id=\"f700f3f\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"the7_icon_box_widget.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\n\t\t<div class=\"the7-box-wrapper the7-elementor-widget the7_icon_box_widget-f700f3f\">\t\t\t<div class=\"box-content-wrapper\">\n\t\t\t\t\t\t\t\t\t<a class=\"elementor-icon-div\" >\t\t\t\t\t\t<div class=\"elementor-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"xlwpf wppb-font-users-alt\"><\/i>\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/a>\t\t\t\t\t\t\t\t<div class=\"box-content\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<h5 class=\"box-heading\">\n\t\t\t\t\t\t\t<a >\t\t\t\t\t\t\t\tKoolitajad\t\t\t\t\t\t\t<\/a>\t\t\t\t\t\t<\/h5>\n\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t<\/div>\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9c3d4fa elementor-grid-1 elementor-posts--align-center elementor-grid-tablet-2 elementor-grid-mobile-1 elementor-posts--thumbnail-top elementor-widget elementor-widget-posts\" data-id=\"9c3d4fa\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;classic_columns&quot;:&quot;1&quot;,&quot;classic_columns_tablet&quot;:&quot;2&quot;,&quot;classic_columns_mobile&quot;:&quot;1&quot;,&quot;classic_row_gap&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:35,&quot;sizes&quot;:[]},&quot;classic_row_gap_tablet&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]},&quot;classic_row_gap_mobile&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]}}\" data-widget_type=\"posts.classic\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-posts-container elementor-posts elementor-posts--skin-classic elementor-grid\" role=\"list\">\n\t\t\t\t<article class=\"elementor-post elementor-grid-item post-1330 our_team type-our_team status-publish has-post-thumbnail hentry\" role=\"listitem\">\n\t\t\t\t<a class=\"elementor-post__thumbnail__link\" href=\"https:\/\/itmeister.ee\/ru\/our_team\/person007\/\" tabindex=\"-1\" >\n\t\t\t<div class=\"elementor-post__thumbnail\"><img fetchpriority=\"high\" decoding=\"async\" width=\"800\" height=\"800\" src=\"https:\/\/itmeister.ee\/wp-content\/uploads\/2020\/04\/anna.jpg\" class=\"attachment-large size-large wp-image-9730\" alt=\"\" srcset=\"https:\/\/itmeister.ee\/wp-content\/uploads\/2020\/04\/anna.jpg 800w, https:\/\/itmeister.ee\/wp-content\/uploads\/2020\/04\/anna-300x300.jpg 300w, https:\/\/itmeister.ee\/wp-content\/uploads\/2020\/04\/anna-150x150.jpg 150w, https:\/\/itmeister.ee\/wp-content\/uploads\/2020\/04\/anna-768x768.jpg 768w, https:\/\/itmeister.ee\/wp-content\/uploads\/2020\/04\/anna-12x12.jpg 12w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/div>\n\t\t<\/a>\n\t\t\t\t<div class=\"elementor-post__text\">\n\t\t\t\t<h3 class=\"elementor-post__title\">\n\t\t\t<a href=\"https:\/\/itmeister.ee\/ru\/our_team\/person007\/\" >\n\t\t\t\tAnna Alieva\t\t\t<\/a>\n\t\t<\/h3>\n\t\t\t\t<div class=\"elementor-post__excerpt\">\n\t\t\t<p>Saint Petersburg State University of Aerospace Instrumentation<br \/>\nInformaatika ja infotehnoloogia<br \/>\nKoolitaja kogemus 2020 aastast<br \/>\nOskused: Front-end\/Back-end\/SQL<\/p>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/article>\n\t\t\t\t<\/div>\n\t\t\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>\u041a\u0443\u0440\u0441 \u043f\u0440\u0435\u0434\u043d\u0430\u0437\u043d\u0430\u0447\u0435\u043d \u0434\u043b\u044f \u043e\u0431\u0443\u0447\u0435\u043d\u0438\u044f \u0440\u0430\u0431\u043e\u0442\u0435 \u0441 \u0431\u0430\u0437\u0430\u043c\u0438 \u0434\u0430\u043d\u043d\u044b\u0445, \u0432\u043a\u043b\u044e\u0447\u0430\u044f \u043e\u0441\u043d\u043e\u0432\u044b \u0440\u0430\u0431\u043e\u0442\u044b \u0441 \u0434\u0430\u043d\u043d\u044b\u043c\u0438, \u044f\u0437\u044b\u043a \u0437\u0430\u043f\u0440\u043e\u0441\u043e\u0432 SQL, \u0432\u0437\u0430\u0438\u043c\u043e\u043e\u0442\u043d\u043e\u0448\u0435\u043d\u0438\u044f \u043c\u0435\u0436\u0434\u0443 \u0442\u0430\u0431\u043b\u0438\u0446\u0430\u043c\u0438, \u0431\u0435\u0437\u043e\u043f\u0430\u0441\u043d\u043e\u0441\u0442\u044c \u0431\u0430\u0437 \u0434\u0430\u043d\u043d\u044b\u0445, \u0445\u0440\u0430\u043d\u0438\u043c\u044b\u0435 \u043f\u0440\u043e\u0446\u0435\u0434\u0443\u0440\u044b \u0438 \u0444\u0443\u043d\u043a\u0446\u0438\u0438, \u0442\u0440\u0438\u0433\u0433\u0435\u0440\u044b, \u043f\u0440\u043e\u0435\u043a\u0442\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u0435 \u0431\u0430\u0437 \u0434\u0430\u043d\u043d\u044b\u0445 \u0438 \u043e\u0441\u043d\u043e\u0432\u044b \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u044f \u0441\u0442\u0440\u0443\u043a\u0442\u0443\u0440\u043e\u0439 \u0431\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445. \u041f\u043e\u043b\u0443\u0447\u0435\u043d\u043d\u044b\u0435 \u043d\u0430\u0432\u044b\u043a\u0438 \u043f\u043e\u0437\u0432\u043e\u043b\u044f\u0442 \u044d\u0444\u0444\u0435\u043a\u0442\u0438\u0432\u043d\u043e \u0443\u043f\u0440\u0430\u0432\u043b\u044f\u0442\u044c \u0434\u0430\u043d\u043d\u044b\u043c\u0438 \u0441 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u0435\u043c MySQL.<\/p>","protected":false},"featured_media":9019,"template":"","course_category":[109],"course_tag":[],"class_list":["post-9018","course","type-course","status-publish","has-post-thumbnail","hentry","course_category-andmebaasid"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/itmeister.ee\/ru\/wp-json\/wp\/v2\/course\/9018","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/itmeister.ee\/ru\/wp-json\/wp\/v2\/course"}],"about":[{"href":"https:\/\/itmeister.ee\/ru\/wp-json\/wp\/v2\/types\/course"}],"version-history":[{"count":133,"href":"https:\/\/itmeister.ee\/ru\/wp-json\/wp\/v2\/course\/9018\/revisions"}],"predecessor-version":[{"id":10182,"href":"https:\/\/itmeister.ee\/ru\/wp-json\/wp\/v2\/course\/9018\/revisions\/10182"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/itmeister.ee\/ru\/wp-json\/wp\/v2\/media\/9019"}],"wp:attachment":[{"href":"https:\/\/itmeister.ee\/ru\/wp-json\/wp\/v2\/media?parent=9018"}],"wp:term":[{"taxonomy":"course_category","embeddable":true,"href":"https:\/\/itmeister.ee\/ru\/wp-json\/wp\/v2\/course_category?post=9018"},{"taxonomy":"course_tag","embeddable":true,"href":"https:\/\/itmeister.ee\/ru\/wp-json\/wp\/v2\/course_tag?post=9018"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}