{"id":22571,"date":"2026-10-11T00:58:03","date_gmt":"2026-10-11T00:58:03","guid":{"rendered":"https:\/\/shpik.org\/product\/learn-qasja-dhe-modifikimi-i-bazes-se-te-dhenave-267\/"},"modified":"2026-10-11T00:58:03","modified_gmt":"2026-10-11T00:58:03","slug":"learn-qasja-dhe-modifikimi-i-bazes-se-te-dhenave-267","status":"publish","type":"product","link":"https:\/\/shpik.org\/en\/product\/learn-qasja-dhe-modifikimi-i-bazes-se-te-dhenave-267\/","title":{"rendered":"Qasja dhe modifikimi i baz\u00ebs s\u00eb t\u00eb dh\u00ebnave"},"content":{"rendered":"<p><strong>Target Groups:<\/strong><br \/>\nDataBase Interested<br \/>\n<strong>Timeline:<\/strong><br \/>\nApprox. 13 hours (29 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 dhe sistemi p\u00ebr menaxhimin e baz\u00ebs s\u00eb t\u00eb dh\u00ebnave<\/li>\n<li>Skema e 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>Analiza e t\u00eb dh\u00ebnave dhe k\u00ebrkesave<\/li>\n<li>Modeli konceptual &#8211; Diagram ER<\/li>\n<li>Modeli logjike i baz\u00ebs s\u00eb t\u00eb dh\u00ebnave<\/li>\n<li>SQL- Structured Query Language<\/li>\n<li>Definimi i baz\u00ebs s\u00eb t\u00eb dh\u00ebnave n\u00eb SQL<\/li>\n<li>Krijimi i tabel\u00ebs<\/li>\n<li>Insertimi, p\u00ebrdit\u00ebsimi dhe fshirja e t\u00eb dh\u00ebnave<\/li>\n<li>P\u00ebrpunimi i nj\u00eb tabele<\/li>\n<li>P\u00ebrpunimi i tabelave t\u00eb shum\u00ebfishta<\/li>\n<li>N\u00ebn-pyet\u00ebsi (sub-query)<\/li>\n<li>Implementimi i tabelave p\u00ebr kompanin\u00eb e cila merret me prodhimin e filmave<\/li>\n<li>Eksportimi dhe importimi i nj\u00eb baze t\u00eb dh\u00ebnash<\/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>Siguri dhe privat\u00ebsi e t\u00eb dh\u00ebnave<\/li>\n<li>Kriteret p\u00ebr sigurin\u00eb dhe mbrojtjen e t\u00eb dh\u00ebnave<\/li>\n<li>Privilegjet dhe rolet n\u00eb nj\u00eb DBMS<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<ul>\n<li>Konceptet kryesore t\u00eb baz\u00ebs s\u00eb t\u00eb dh\u00ebnave, Analiza e t\u00eb dh\u00ebnave dhe dizajni i baz\u00ebs s\u00eb t\u00eb dh\u00ebnave<\/li>\n<li>Implementimi i baz\u00ebs s\u00eb t\u00eb dh\u00ebnave n\u00eb SQL<\/li>\n<li>Testimi dhe vler\u00ebsimi i baz\u00ebs s\u00eb t\u00eb dh\u00ebnave, Siguria dhe privat\u00ebsia e t\u00eb dh\u00ebnave<\/li>\n<\/ul>\n","protected":false},"featured_media":23631,"comment_status":"open","ping_status":"closed","template":"","meta":[],"product_brand":[],"product_cat":[117,114],"product_tag":[],"class_list":["post-22571","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\/22571","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=22571"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/shpik.org\/en\/wp-json\/wp\/v2\/media\/23631"}],"wp:attachment":[{"href":"https:\/\/shpik.org\/en\/wp-json\/wp\/v2\/media?parent=22571"}],"wp:term":[{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/shpik.org\/en\/wp-json\/wp\/v2\/product_brand?post=22571"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/shpik.org\/en\/wp-json\/wp\/v2\/product_cat?post=22571"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/shpik.org\/en\/wp-json\/wp\/v2\/product_tag?post=22571"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}