{"id":22552,"date":"2026-10-11T00:58:00","date_gmt":"2026-10-11T00:58:00","guid":{"rendered":"https:\/\/shpik.org\/product\/learn-perpunimi-i-databazave-me-sql-206\/"},"modified":"2026-10-11T00:58:00","modified_gmt":"2026-10-11T00:58:00","slug":"learn-perpunimi-i-databazave-me-sql-206","status":"publish","type":"product","link":"https:\/\/shpik.org\/en\/product\/learn-perpunimi-i-databazave-me-sql-206\/","title":{"rendered":"P\u00ebrpunimi i databazave me SQL"},"content":{"rendered":"<p><strong>Target Groups:<\/strong><br \/>\nDataBase Interested<br \/>\n<strong>Timeline:<\/strong><br \/>\nApprox. 19 hours (41 lessons)<br \/>\n<strong>Previous knowledge (recommended):<\/strong><br \/>\nBasic computer knowledge<\/p>\n<p><strong>Content<\/strong><\/p>\n<ul>\n<li>T\u00eb dh\u00ebnat<\/li>\n<li>Baza relacionale e t\u00eb dh\u00ebnave<\/li>\n<li>Krijimi i skem\u00ebs s\u00eb baz\u00ebs s\u00eb t\u00eb dh\u00ebnave<\/li>\n<li>Modelimi i t\u00eb dh\u00ebnave<\/li>\n<li>Normalizimi i t\u00eb dh\u00ebnave<\/li>\n<li>P\u00ebrshtatja e skem\u00ebs s\u00eb baz\u00ebs s\u00eb t\u00eb dh\u00ebnave<\/li>\n<li>SQL &#8211; Structured Query Language<\/li>\n<li>Gjeneratat e gjuh\u00ebve programuese<\/li>\n<li>Struktura e SQL &#8211; it<\/li>\n<li>SQL n\u00eb MS Access<\/li>\n<li>P\u00ebrdorimi i MySQL-it<\/li>\n<li>P\u00ebrdorimi i veglave MySQL<\/li>\n<li>Krijimi i baz\u00ebs s\u00eb t\u00eb dh\u00ebnave<\/li>\n<li>Fshirja e baz\u00ebs s\u00eb t\u00eb dh\u00ebnave<\/li>\n<li>Krijimi i tabelave<\/li>\n<li>Llojet e t\u00eb dh\u00ebnave<\/li>\n<li>Zgjedhja e baz\u00ebs s\u00eb t\u00eb dh\u00ebnave<\/li>\n<li>T\u00eb dh\u00ebnat e detyrueshme<\/li>\n<li>Vendosja automatike e vlerave<\/li>\n<li>P\u00ebrcaktimi i \u00e7el\u00ebsit primar<\/li>\n<li>P\u00ebrcaktimi i \u00e7el\u00ebsit t\u00eb jasht\u00ebm<\/li>\n<li>Menaxhimi i indeksit<\/li>\n<li>Shfaqja e tabelave<\/li>\n<li>Ndryshimi i struktur\u00ebs s\u00eb tabel\u00ebs<\/li>\n<li>Fshirja e tabel\u00ebs<\/li>\n<li>Ruajtja e t\u00eb dh\u00ebnave n\u00eb SQL<\/li>\n<li>Ruajtja e t\u00eb dh\u00ebnave nga tabela ekzistuese<\/li>\n<li>P\u00ebrdorimi i MySQL Migration Toolkit<\/li>\n<li>P\u00ebrdit\u00ebsimi i t\u00eb dh\u00ebnave<\/li>\n<li>Fshirja e t\u00eb dh\u00ebnave<\/li>\n<li>Selektimi i atributeve<\/li>\n<li>P\u00ebrcaktimi i kushteve<\/li>\n<li>Funksionet aritmetikore<\/li>\n<li>Grupimi dhe vendosja e kushteve<\/li>\n<li>K\u00ebrkimi i t\u00eb dh\u00ebnave duke p\u00ebrdorur operatorin union<\/li>\n<li>Selektimi i t\u00eb dh\u00ebnave nga tabelat e shum\u00ebfishta<\/li>\n<li>Analizimi i tabelave t\u00eb lidhura<\/li>\n<li>Administratori dhe p\u00ebrdoruesi i baz\u00ebs s\u00eb t\u00eb dh\u00ebnave<\/li>\n<li>Menaxhimi i administratorit t\u00eb baz\u00ebs s\u00eb t\u00eb dh\u00ebnave<\/li>\n<li>Menaxhimi i p\u00ebrdoruesve<\/li>\n<li>Menaxhimi i p\u00ebrdoruesve me MySQL Administrator<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<ul>\n<li>\u00c7far\u00eb \u00ebsht\u00eb nj\u00eb databaz\u00eb? Krijimi i skem\u00ebs s\u00eb baz\u00ebs s\u00eb t\u00eb dh\u00ebnave<\/li>\n<li>Zhvillimi i gjuh\u00ebve programuese, P\u00ebrdormi i SQL-it n\u00eb sistemet e baz\u00ebs s\u00eb t\u00eb dh\u00ebnave<\/li>\n<li>Menaxhimi i baz\u00ebs s\u00eb t\u00eb dh\u00ebnave, Menaxhimi i tabelave, Ruajtja p\u00ebrdit\u00ebsimi dhe fshirja e t\u00eb dh\u00ebnave<\/li>\n<li>P\u00ebrpunimi dhe vler\u00ebsimi i t\u00eb dh\u00ebnave, P\u00ebrpunimi i tabelave t\u00eb shum\u00ebfishta<\/li>\n<li>P\u00ebrcaktimi i roleve dhe privilegjeve<\/li>\n<\/ul>\n","protected":false},"featured_media":23599,"comment_status":"open","ping_status":"closed","template":"","meta":[],"product_brand":[],"product_cat":[117,114],"product_tag":[],"class_list":["post-22552","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\/22552","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=22552"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/shpik.org\/en\/wp-json\/wp\/v2\/media\/23599"}],"wp:attachment":[{"href":"https:\/\/shpik.org\/en\/wp-json\/wp\/v2\/media?parent=22552"}],"wp:term":[{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/shpik.org\/en\/wp-json\/wp\/v2\/product_brand?post=22552"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/shpik.org\/en\/wp-json\/wp\/v2\/product_cat?post=22552"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/shpik.org\/en\/wp-json\/wp\/v2\/product_tag?post=22552"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}