{"id":22579,"date":"2026-10-11T00:58:03","date_gmt":"2026-10-11T00:58:03","guid":{"rendered":"https:\/\/shpik.org\/product\/learn-320-320\/"},"modified":"2026-10-11T00:58:03","modified_gmt":"2026-10-11T00:58:03","slug":"learn-320-320","status":"publish","type":"product","link":"https:\/\/shpik.org\/en\/product\/learn-320-320\/","title":{"rendered":"Instalimi dhe konfigurimi i baz\u00ebs s\u00eb t\u00eb dh\u00ebnave"},"content":{"rendered":"<p><strong>Target Groups:<\/strong><br \/>\nData Base Interested<br \/>\n<strong>Timeline:<\/strong><br \/>\nApprox. 21 hours (46 lessons)<br \/>\n<strong>Previous knowledge (recommended):<\/strong><br \/>\nBasic computer knowledge<\/p>\n<p><strong>Content<\/strong><\/p>\n<ul>\n<li>Baza e t\u00eb dh\u00ebnave<\/li>\n<li>Zhvillimi i menaxhimit t\u00eb t\u00eb dh\u00ebnave<\/li>\n<li>Llojet e bazave t\u00eb t\u00eb dh\u00ebnave<\/li>\n<li>Dizajni i baz\u00ebs s\u00eb t\u00eb dh\u00ebnave<\/li>\n<li>Fazat e zhvillimit t\u00eb baz\u00ebs s\u00eb t\u00eb dh\u00ebnave<\/li>\n<li>Zhvillimi i baz\u00ebs s\u00eb t\u00eb dh\u00ebnave me shembuj konkret<\/li>\n<li>Arkitektura e baz\u00ebs s\u00eb t\u00eb dh\u00ebnave<\/li>\n<li>Normalizimi i t\u00eb dh\u00ebnave<\/li>\n<li>Instalimi i sistemit t\u00eb menaxhimit t\u00eb baz\u00ebs s\u00eb t\u00eb dh\u00ebnave MySQL<\/li>\n<li>P\u00ebrdorimi i veglave MySQL<\/li>\n<li>Definimi i baz\u00ebs s\u00eb t\u00eb dh\u00ebnave n\u00eb SQL<\/li>\n<li>Llojet e t\u00eb dh\u00ebnave<\/li>\n<li>Krijimi i tabel\u00ebs<\/li>\n<li>Menaxhimi i indeksit<\/li>\n<li>Implementimi i tabelave p\u00ebr shembullin \u201cBlerja online e librave\u201d<\/li>\n<li>Menaxhimi i p\u00ebrdoruesve<\/li>\n<li>Menaxhimi i p\u00ebrdoruesve me MySQL Administrator<\/li>\n<li>Pamja<\/li>\n<li>Procedurat e ruajtura<\/li>\n<li>Insertimi i t\u00eb dh\u00ebnave<\/li>\n<li>Migrimi i t\u00eb dh\u00ebnave<\/li>\n<li>Importimi i tabelave<\/li>\n<li>Siguria dhe privat\u00ebsia e t\u00eb dh\u00ebnave<\/li>\n<li>Kriteret p\u00ebr sigurin\u00eb dhe mbrojtjen e t\u00eb dh\u00ebnave<\/li>\n<li>Testimi i baz\u00ebs s\u00eb t\u00eb dh\u00ebnave<\/li>\n<li>Llojet e testimit t\u00eb baz\u00ebs s\u00eb t\u00eb dh\u00ebnave<\/li>\n<li>P\u00ebrcaktimi i t\u00eb dh\u00ebnave p\u00ebr testim dhe kontrollimi i pyetjeve<\/li>\n<li>Krijimi i form\u00ebs p\u00ebr testim<\/li>\n<li>Gjenerimi i t\u00eb dh\u00ebnave testuese n\u00eb nj\u00eb baz\u00eb t\u00eb dh\u00ebnash<\/li>\n<li>Monitorimi dhe raportimi<\/li>\n<li>Dokumentimi dhe r\u00ebnd\u00ebsia e tij<\/li>\n<li>Si ta b\u00ebjm\u00eb dokumentimin?<\/li>\n<li>Standardet e kodimit<\/li>\n<li>P\u00ebrgatitja e dor\u00ebzimit<\/li>\n<li>Dor\u00ebzimi<\/li>\n<li>Vler\u00ebsimi i p\u00ebrvojave<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<ul>\n<li>Bazat e t\u00eb dh\u00ebnave dhe llojet e tyre, Vler\u00ebsimi konceptimi dhe planifikimi<\/li>\n<li>Instalimi i MySQL-it, Realizimi i baz\u00ebs s\u00eb t\u00eb dh\u00ebnave, Pamja dhe procedurat e ruajtura<\/li>\n<li>Ruajtja dhe importimi i t\u00eb dh\u00ebnave, Testimi dhe vler\u00ebsimi i baz\u00ebs s\u00eb t\u00eb dh\u00ebnave<\/li>\n<li>Monitorimi, Dokumentimi, V\u00ebnia n\u00eb pun\u00eb e baz\u00ebs s\u00eb t\u00eb dh\u00ebnave<\/li>\n<\/ul>\n","protected":false},"featured_media":23525,"comment_status":"open","ping_status":"closed","template":"","meta":[],"product_brand":[],"product_cat":[117,114],"product_tag":[],"class_list":["post-22579","product","type-product","status-publish","has-post-thumbnail","product_cat-learn-database-175","product_cat-learn-tik-2-172","user-has-not-earned","first","instock","sale","virtual","purchasable","product-type-simple"],"_links":{"self":[{"href":"https:\/\/shpik.org\/en\/wp-json\/wp\/v2\/product\/22579","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/shpik.org\/en\/wp-json\/wp\/v2\/product"}],"about":[{"href":"https:\/\/shpik.org\/en\/wp-json\/wp\/v2\/types\/product"}],"replies":[{"embeddable":true,"href":"https:\/\/shpik.org\/en\/wp-json\/wp\/v2\/comments?post=22579"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/shpik.org\/en\/wp-json\/wp\/v2\/media\/23525"}],"wp:attachment":[{"href":"https:\/\/shpik.org\/en\/wp-json\/wp\/v2\/media?parent=22579"}],"wp:term":[{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/shpik.org\/en\/wp-json\/wp\/v2\/product_brand?post=22579"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/shpik.org\/en\/wp-json\/wp\/v2\/product_cat?post=22579"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/shpik.org\/en\/wp-json\/wp\/v2\/product_tag?post=22579"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}