{"id":2786,"date":"2026-10-07T10:57:21","date_gmt":"2026-10-07T10:57:21","guid":{"rendered":"http:\/\/creativehubkos.com\/blog\/?p=2786"},"modified":"2026-10-07T10:57:21","modified_gmt":"2026-10-07T10:57:21","slug":"sql-apo-python-data-engineering","status":"publish","type":"post","link":"https:\/\/creativehubkos.com\/blog\/sql-apo-python-data-engineering\/","title":{"rendered":"SQL apo Python: nga t\u00eb fillosh p\u00ebr Data Engineering?"},"content":{"rendered":"\n<div class=\"wp-block-group chk-answer is-layout-constrained wp-block-group-is-layout-constrained\">\n<p class=\"wp-block-paragraph\"><strong>N\u00ebse po fillon nga zero dhe synon Data Engineering, rekomandimi yn\u00eb \u00ebsht\u00eb t\u00eb nis\u00ebsh me bazat e SQL, pastaj ta shtosh Python p\u00ebr t\u00eb nd\u00ebrtuar nj\u00eb proces t\u00eb plot\u00eb me t\u00eb dh\u00ebna.<\/strong> SQL t\u00eb sh\u00ebrben p\u00ebr t\u00eb punuar me tabela dhe p\u00ebr t\u00eb p\u00ebrpunuar t\u00eb dh\u00ebna brenda databaz\u00ebs; Python t\u00eb ndihmon t\u00eb lidh\u00ebsh hapa si leximi i skedar\u00ebve, kontrollet dhe ekzekutimi i komandave SQL. <sup><a href=\"#s1\">[1]<\/a><a href=\"#s2\">[2]<\/a><a href=\"#s3\">[3]<\/a><\/sup><\/p>\n<\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Kjo renditje \u00ebsht\u00eb nj\u00eb propozim m\u00ebsimor, jo rregull universal i industris\u00eb. N\u00ebse tashm\u00eb programon ose projekti yt nis nga p\u00ebrpunimi i skedar\u00ebve, mund t\u00eb fillosh me Python dhe t\u00eb m\u00ebsosh SQL krahas tij. Q\u00ebllimi \u00ebsht\u00eb t\u00eb kuptosh kur t\u00eb p\u00ebrdor\u00ebsh secilin dhe si t\u2019i bashkosh n\u00eb nj\u00eb zgjidhje.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u00c7far\u00eb b\u00ebn SQL dhe \u00e7far\u00eb b\u00ebn Python n\u00eb Data Engineering?<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>SQL<\/strong> p\u00ebrdoret p\u00ebr t\u00eb krijuar dhe p\u00ebr t\u00eb punuar me struktura t\u00eb t\u00eb dh\u00ebnave n\u00eb databaza. Tutoriali i PostgreSQL p\u00ebrfshin krijimin e tabelave, shtimin e rreshtave, k\u00ebrkimin, lidhjen e tabelave dhe p\u00ebrmbledhjen e t\u00eb dh\u00ebnave. <strong>Python<\/strong> \u00ebsht\u00eb gjuh\u00eb programimi me p\u00ebrdorim m\u00eb t\u00eb gjer\u00eb, e p\u00ebrshtatshme edhe p\u00ebr skripte q\u00eb lidhin disa veprime n\u00eb nj\u00eb proces. <sup><a href=\"#s1\">[1]<\/a><a href=\"#s4\">[4]<\/a><\/sup><\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th>Detyra<\/th><th>SQL<\/th><th>Python<\/th><\/tr><\/thead><tbody>\n<tr><td>T\u00eb zgjedh\u00ebsh porosit\u00eb e nj\u00eb qyteti<\/td><td>Nj\u00eb query me <code>SELECT<\/code> dhe <code>WHERE<\/code><\/td><td>Mund t\u00eb ekzekutoj\u00eb query-n dhe t\u00eb p\u00ebrdor\u00eb rezultatin<\/td><\/tr>\n<tr><td>T\u00eb lidh\u00ebsh porosit\u00eb me klient\u00ebt<\/td><td>Nj\u00eb <code>JOIN<\/code> mes tabelave<\/td><td>Mund t\u00eb koordinoj\u00eb ngarkimin dhe hapat p\u00ebrreth<\/td><\/tr>\n<tr><td>T\u00eb llogarit\u00ebsh totalin sipas qytetit<\/td><td><code>SUM<\/code> dhe <code>GROUP BY<\/code><\/td><td>Mund t\u00eb p\u00ebrpunoj\u00eb rezultatin ose ta shkruaj\u00eb n\u00eb skedar<\/td><\/tr>\n<tr><td>T\u00eb lexosh dhe kontrollosh nj\u00eb CSV<\/td><td>M\u00ebnyra e importimit varet nga sistemi i databaz\u00ebs<\/td><td>Moduli <code>csv<\/code> lexon rreshtat; kodi yt p\u00ebrcakton kontrollet<\/td><\/tr>\n<\/tbody><\/table><\/figure>\n\n\n\n<p class=\"chk-small wp-block-paragraph\">Tabela ilustron ndarjen e pun\u00ebs n\u00eb nj\u00eb projekt t\u00eb thjesht\u00eb. Nuk n\u00ebnkupton se nj\u00eb detyr\u00eb ka vet\u00ebm nj\u00eb zgjidhje teknike. Bazuar n\u00eb dokumentacionin e PostgreSQL dhe Python. <a href=\"#s1\">[1]<\/a> <a href=\"#s2\">[2]<\/a> <a href=\"#s3\">[3]<\/a> <a href=\"#s5\">[5]<\/a> <a href=\"#s6\">[6]<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">P\u00ebr t\u00eb kuptuar ku lidhen k\u00ebto aft\u00ebsi me profesionin, lexo <a href=\"https:\/\/creativehubkos.com\/blog\/cfare-eshte-data-engineering\/\">\u00e7far\u00eb \u00ebsht\u00eb Data Engineering<\/a>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Me cilin t\u00eb fillosh sipas p\u00ebrvoj\u00ebs q\u00eb ke?<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">N\u00ebse nuk ke programuar m\u00eb par\u00eb: provo SQL fillimisht<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Propozimi yn\u00eb \u00ebsht\u00eb t\u00eb punosh fillimisht me nj\u00eb tabel\u00eb t\u00eb vog\u00ebl dhe pyetje konkrete: sa porosi ka, cilat jan\u00eb t\u00eb paguara dhe si ndryshon totali sipas qytetit? K\u00ebshtu e lidh m\u00ebsimin me rezultate q\u00eb mund t\u2019i kontrollosh vet\u00eb.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Pasi t\u00eb kuptosh filtrimin, grupimin dhe lidhjen e tabelave, shto Python p\u00ebr t\u00eb sjell\u00eb t\u00eb dh\u00ebnat dhe p\u00ebr t\u2019i kontrolluar para ngarkimit. Nuk ke nevoj\u00eb ta p\u00ebrfundosh \u00e7do tem\u00eb t\u00eb SQL para se t\u00eb fillosh Python.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">N\u00ebse tashm\u00eb di Python: p\u00ebrdore si ur\u00eb drejt SQL<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Nd\u00ebrto nj\u00eb projekt q\u00eb lexon t\u00eb dh\u00ebna dhe i vendos n\u00eb nj\u00eb databaz\u00eb. Pastaj shkruaj vet\u00eb query-t q\u00eb prodhojn\u00eb raportin. Moduli <code>sqlite3<\/code> ofron nj\u00eb m\u00ebnyr\u00eb p\u00ebr t\u00eb ekzekutuar SQL nga Python, pa ngritur nj\u00eb server t\u00eb ve\u00e7ant\u00eb databaze p\u00ebr k\u00ebt\u00eb ushtrim. <sup><a href=\"#s3\">[3]<\/a><\/sup><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">N\u00ebse t\u00eb duhet menj\u00ebher\u00eb t\u00eb p\u00ebrpunosh skedar\u00eb<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Mund t\u00eb nis\u00ebsh me Python dhe nj\u00eb CSV t\u00eb thjesht\u00eb. Vendos nj\u00eb objektiv t\u00eb kufizuar: lexo kolonat, kontrollo vlerat dhe prodho nj\u00eb rezultat t\u00eb past\u00ebr. Shto SQL sapo t\u00eb kalosh te organizimi dhe lidhja e tabelave. Ky \u00ebsht\u00eb orientim sipas projektit, jo pretendim se nj\u00ebra gjuh\u00eb \u00ebsht\u00eb gjithmon\u00eb m\u00eb e leht\u00eb.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">A k\u00ebrkohen SQL dhe Python n\u00eb Kosov\u00eb?<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Dy shpallje t\u00eb publikuara n\u00eb KosovaJob p\u00ebr role n\u00eb Prishtin\u00eb tregojn\u00eb se ato mund t\u00eb k\u00ebrkohen bashk\u00eb:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>SPAXEL, Mid-Level Data Engineer Freelancer:<\/strong> p\u00ebrmend aft\u00ebsi t\u00eb forta n\u00eb SQL, p\u00ebrvoj\u00eb me Python dhe pipeline t\u00eb automatizuara, si dhe pun\u00eb me databaza, API dhe platforma cloud. K\u00ebrkon 3\u20136 vjet p\u00ebrvoj\u00eb. Afati i sh\u00ebnuar ishte 1 qershor 2026. <sup><a href=\"#s7\">[7]<\/a><\/sup><\/li>\n\n\n<li><strong>Borek Solutions, Senior Data Engineer:<\/strong> p\u00ebrmend SQL t\u00eb avancuar, optimizim query-sh, Python dhe p\u00ebrvoj\u00eb me modelim e transformim t\u00eb t\u00eb dh\u00ebnave. K\u00ebrkon 3\u20135+ vjet p\u00ebrvoj\u00eb. <sup><a href=\"#s8\">[8]<\/a><\/sup><\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><em>T\u00eb dyja faqet shfaqeshin si konkurse t\u00eb skaduara kur u kontrolluan m\u00eb 29 shtator 2026.<\/em> I p\u00ebrdorim si shembuj t\u00eb dokumentuar t\u00eb k\u00ebrkesave profesionale, jo si vende pune t\u00eb hapura ose matje t\u00eb gjith\u00eb tregut.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">P\u00ebr nj\u00eb fillestar, kjo sugjeron nj\u00eb drejtim p\u00ebr t\u2019u zhvilluar: nd\u00ebrto baz\u00ebn n\u00eb t\u00eb dyja gjuh\u00ebt. Nuk do t\u00eb thot\u00eb se duhet t\u00eb plot\u00ebsosh sot \u00e7do k\u00ebrkes\u00eb t\u00eb nj\u00eb pozite senior. P\u00ebr rolin e par\u00eb, shqyrto ve\u00e7mas shpalljet q\u00eb pranojn\u00eb kandidat\u00eb pa p\u00ebrvoj\u00eb ose me p\u00ebrvoj\u00eb t\u00eb kufizuar.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Nj\u00eb rrug\u00eb praktike p\u00ebr t\u00eb m\u00ebsuar SQL dhe Python<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Plani m\u00eb posht\u00eb \u00ebsht\u00eb rekomandimi yn\u00eb m\u00ebsimor. Kalo te hapi tjet\u00ebr kur mund ta shpjegosh dhe ta kontrollosh pun\u00ebn q\u00eb ke b\u00ebr\u00eb, pa i vendosur vetes nj\u00eb afat t\u00eb sajuar p\u00ebr pun\u00ebsim.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">1. M\u00ebso t\u00eb lexosh nj\u00eb tabel\u00eb me SQL<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Ushtro <code>SELECT<\/code>, <code>WHERE<\/code> dhe <code>ORDER BY<\/code>. P\u00ebr \u00e7do query, shkruaj fillimisht pyetjen n\u00eb gjuh\u00eb t\u00eb thjesht\u00eb. Kontrollo manualisht disa rreshta q\u00eb t\u00eb bindesh se p\u00ebrgjigjja p\u00ebrputhet me pyetjen.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">2. Lidh dhe p\u00ebrmblidh t\u00eb dh\u00ebnat<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Puno me dy tabela, p\u00ebr shembull klient\u00eb dhe porosi. <code>JOIN<\/code> kombinon rreshta sipas kushteve t\u00eb p\u00ebrcaktuara, nd\u00ebrsa funksionet si <code>SUM<\/code> dhe <code>COUNT<\/code> p\u00ebrmbledhin t\u00eb dh\u00ebna. Me <code>GROUP BY<\/code> mund ta b\u00ebsh p\u00ebrmbledhjen p\u00ebr secilin grup. <sup><a href=\"#s5\">[5]<\/a><a href=\"#s6\">[6]<\/a><\/sup><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Kontroll praktik:<\/strong> krahaso numrin e rreshtave para dhe pas lidhjes. N\u00ebse rezultati shtohet papritur, kontrollo n\u00ebse \u00e7el\u00ebsi i lidhjes p\u00ebrs\u00ebritet n\u00eb tabel\u00ebn tjet\u00ebr. Mos e merr totalin si t\u00eb sakt\u00eb vet\u00ebm sepse query ekzekutohet.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">3. Shto bazat e Python q\u00eb i duhen projektit<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">P\u00ebr ushtrimin m\u00eb posht\u00eb do t\u00eb p\u00ebrdor\u00ebsh variabla, lista, nj\u00eb cik\u00ebl <code>for<\/code>, kushte <code>if<\/code> dhe importe modulesh. Tutoriali zyrtar i Python mbulon k\u00ebto koncepte, por vet\u00eb ai sqaron se supozon njohuri baz\u00eb programimi. N\u00ebse je krejt fillestar, p\u00ebrdor edhe orientimin <a href=\"https:\/\/www.python.org\/about\/gettingstarted\/\">Python for Beginners<\/a>. <sup><a href=\"#s4\">[4]<\/a><a href=\"#s9\">[9]<\/a><\/sup><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">4. Bashkoji n\u00eb nj\u00eb proces t\u00eb vet\u00ebm<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Zgjidh nj\u00eb burim t\u00eb vog\u00ebl t\u00eb dh\u00ebnash, p\u00ebrcakto \u00e7far\u00eb pranon si t\u00eb vlefshme dhe krijo nj\u00eb raport t\u00eb riprodhuesh\u00ebm. Mbaj nj\u00eb sh\u00ebnim p\u00ebr supozimet: \u00e7far\u00eb p\u00ebrfaq\u00ebson \u00e7do rresht, \u00e7far\u00eb nj\u00ebsie p\u00ebrdor shuma dhe si trajtohen statuset.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Projekt p\u00ebr fillestar\u00eb: nga nj\u00eb CSV te raporti me SQL<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Shembull m\u00ebsimor me t\u00eb dh\u00ebna sintetike.<\/strong> Tre porosit\u00eb m\u00eb posht\u00eb jan\u00eb krijuar p\u00ebr ushtrimin dhe nuk p\u00ebrfaq\u00ebsojn\u00eb shitje t\u00eb nj\u00eb biznesi real. Detyra \u00ebsht\u00eb t\u00eb llogarit\u00ebsh vet\u00ebm totalin e porosive t\u00eb paguara, sipas qytetit.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Python do t\u00eb lexoj\u00eb CSV-n\u00eb dhe do t\u00eb kontrolloj\u00eb rreshtat. Pastaj do t\u2019i ngarkoj\u00eb n\u00eb SQLite. SQL do t\u00eb filtroj\u00eb dhe p\u00ebrmbledh\u00eb rezultatet. Modulet <code>csv<\/code> dhe <code>sqlite3<\/code> jan\u00eb t\u00eb dokumentuara nga Python; <code>sqlite3<\/code> mund t\u00eb mungoj\u00eb n\u00eb disa instalime t\u00eb personalizuara. <sup><a href=\"#s2\">[2]<\/a><a href=\"#s3\">[3]<\/a><\/sup><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Si ta ekzekutosh<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Me Python 3 t\u00eb instaluar, kopjo kodin n\u00eb nj\u00eb skedar me emrin <code>ushtrim_sql_python.py<\/code>.<\/li>\n\n\n<li>Hap terminalin n\u00eb dosjen e skedarit dhe ekzekuto <code>python3 ushtrim_sql_python.py<\/code>. N\u00eb Windows mund t\u00eb p\u00ebrdor\u00ebsh <code>py ushtrim_sql_python.py<\/code>, n\u00ebse ke Python Launcher.<\/li>\n\n\n<li>Krahaso rezultatin me at\u00eb t\u00eb treguar m\u00eb posht\u00eb.<\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">Ushtrimi nuk k\u00ebrkon llogari cloud ose paketa shtes\u00eb me <code>pip<\/code>. Databaza krijohet n\u00eb memorie dhe mbyllet n\u00eb fund; nuk ruan t\u00eb dh\u00ebna n\u00eb disk. Shumat ruhen n\u00eb cent\u00eb si numra t\u00eb plot\u00eb.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>import csv<br>import io<br>import sqlite3<br><br># Te dhena sintetike per ushtrimin.<br>csv_text = \"\"\"order_id,city,amount_cents,status<br>1,Prishtin\u00eb,4500,paid<br>2,Prizren,2500,pending<br>3,Prishtin\u00eb,1500,paid<br>\"\"\"<br><br>rows = []<br>seen_ids = set()<br>for row in csv.DictReader(io.StringIO(csv_text)):<br>    order_id = int(row[\"order_id\"])<br>    city = row[\"city\"].strip()<br>    amount = int(row[\"amount_cents\"])<br>    status = row[\"status\"].strip()<br><br>    if order_id in seen_ids:<br>        raise ValueError(\"ID e perseritur\")<br>    if not city or amount &lt; 0 or status not in {\"paid\", \"pending\"}:<br>        raise ValueError(\"Rresht i pavlefshem\")<br><br>    seen_ids.add(order_id)<br>    rows.append((order_id, city, amount, status))<br><br>conn = sqlite3.connect(\":memory:\")<br>try:<br>    conn.execute(\"\"\"<br>        CREATE TABLE orders (<br>            order_id INTEGER PRIMARY KEY,<br>            city TEXT NOT NULL,<br>            amount_cents INTEGER NOT NULL,<br>            status TEXT NOT NULL<br>        )<br>    \"\"\")<br>    conn.executemany(<br>        \"INSERT INTO orders VALUES (?, ?, ?, ?)\", rows<br>    )<br>    conn.commit()<br><br>    report = conn.execute(\"\"\"<br>        SELECT city, SUM(amount_cents) AS total_cents<br>        FROM orders<br>        WHERE status = 'paid'<br>        GROUP BY city<br>        ORDER BY city<br>    \"\"\")<br>    for city, total in report:<br>        print(f\"{city}: {total \/\/ 100}.{total % 100:02d} EUR\")<br>finally:<br>    conn.close()<br><\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Rezultati i pritur:<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Prishtin\u00eb: 60.00 EUR<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Dy porosit\u00eb e Prishtin\u00ebs jan\u00eb t\u00eb paguara dhe japin 4,500 + 1,500 = 6,000 cent\u00eb. Porosia e Prizrenit \u00ebsht\u00eb n\u00eb pritje, ndaj kushti <code>WHERE status = 'paid'<\/code> e p\u00ebrjashton.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><code>csv.DictReader<\/code> i lidh vlerat me emrat e kolonave. Konvertimi me <code>int<\/code> e b\u00ebn shum\u00ebn num\u00ebr, nd\u00ebrsa kontrollet ndalojn\u00eb shembullin n\u00ebse ndeshin ID t\u00eb p\u00ebrs\u00ebritur, qytet bosh, shum\u00eb negative ose status t\u00eb papranuar. <sup><a href=\"#s2\">[2]<\/a><\/sup><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Vlerat futen n\u00eb SQL p\u00ebrmes parametrave <code>?<\/code>, duke e mbajtur t\u00eb ndar\u00eb komand\u00ebn nga t\u00eb dh\u00ebnat. Kjo ndjek praktik\u00ebn e dokumentuar te <code>sqlite3<\/code>. Kodi \u00ebsht\u00eb nj\u00eb shembull origjinal m\u00ebsimor, jo kopjim i nj\u00eb pipeline prodhimi. <sup><a href=\"#s3\">[3]<\/a><\/sup><\/p>\n\n\n\n<div class=\"wp-block-group chk-exercise is-layout-constrained wp-block-group-is-layout-constrained\">\n<p class=\"wp-block-paragraph\"><strong>Provoje vet\u00eb:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Ndrysho porosin\u00eb e Prizrenit n\u00eb <code>paid<\/code>. Raporti duhet t\u00eb p\u00ebrfshij\u00eb edhe <code>Prizren: 25.00 EUR<\/code>.<\/li>\n\n\n<li>P\u00ebrs\u00ebrit nj\u00eb <code>order_id<\/code>. Procesi duhet t\u00eb ndalet me gabim.<\/li>\n\n\n<li>Shto nj\u00eb porosi t\u00eb paguar n\u00eb Prishtin\u00eb p\u00ebr 500 cent\u00eb. Totali i Prishtin\u00ebs duhet t\u00eb b\u00ebhet 65.00 EUR.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">N\u00eb fund, shpjego me fjal\u00ebt e tua: cilat hapa i b\u00ebri Python dhe cil\u00ebn pjes\u00eb e zgjidhi SQL?<\/p>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\">\u00c7far\u00eb duhet t\u00eb kontrollosh p\u00ebrtej sintaks\u00ebs?<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Kur ta zgjerosh k\u00ebt\u00eb ushtrim, p\u00ebrdor k\u00ebto pyetje si list\u00eb kontrolli:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Kuptimi i treguesit:<\/strong> po mat porosi, pagesa apo t\u00eb ardhura pas kthimeve? N\u00eb shembull matim vet\u00ebm shumat e rreshtave me status <code>paid<\/code>.<\/li>\n\n\n<li><strong>Cil\u00ebsia e hyrjes:<\/strong> \u00e7far\u00eb ndodh n\u00ebse mungon nj\u00eb kolon\u00eb ose shuma nuk \u00ebsht\u00eb num\u00ebr? Shembulli ndalet; nj\u00eb projekt m\u00eb i plot\u00eb duhet t\u00eb p\u00ebrcaktoj\u00eb si regjistrohen dhe trajtohen gabimet.<\/li>\n\n\n<li><strong>Ekzekutimi i p\u00ebrs\u00ebritur:<\/strong> ushtrimi krijon \u00e7do her\u00eb nj\u00eb databaz\u00eb t\u00eb re n\u00eb memorie. Kur kalon n\u00eb nj\u00eb databaz\u00eb t\u00eb ruajtur, duhet t\u00eb mendosh si t\u00eb shmang\u00ebsh ngarkimin dy her\u00eb t\u00eb s\u00eb nj\u00ebjt\u00ebs porosi.<\/li>\n\n\n<li><strong>Shpjegimi i kodit:<\/strong> edhe n\u00ebse AI t\u00eb ndihmon ta shkruash, kontrollo q\u00eb ndryshimet te hyrja japin rezultatin q\u00eb pret. Mos e p\u00ebrdor ekzekutimin pa gabime si prov\u00ebn e vetme t\u00eb sakt\u00ebsis\u00eb.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Ky projekt \u00ebsht\u00eb nj\u00eb pik\u00ebnisje. P\u00ebr ta zhvilluar m\u00eb tej, shto nj\u00eb tabel\u00eb klient\u00ebsh, nj\u00eb <code>JOIN<\/code> dhe nj\u00eb skedar me sh\u00ebnime q\u00eb shpjegon hyrjen, kontrollet dhe kufizimet.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Ku lidhen k\u00ebto aft\u00ebsi me akademin\u00eb?<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Planprogrami i publikuar i <a href=\"https:\/\/creativehubkos.com\/data-engineering-cloud-ai-academy\/\"><strong>Data Engineering, Cloud &amp; AI Academy n\u00eb Creative Hub Kosovo<\/strong><\/a> p\u00ebrfshin Python, databaza relacionale dhe SQL, pastaj PySpark, Databricks dhe tema t\u00eb orkestrimit. Projektet e p\u00ebrshkruara p\u00ebrfshijn\u00eb p\u00ebrpunim t\u00eb t\u00eb dh\u00ebnave me Python dhe zgjidhje me SQL. <sup><a href=\"#s10\">[10]<\/a><\/sup><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Planprogrami e nis me Python. Kjo \u00ebsht\u00eb nj\u00eb renditje tjet\u00ebr e vlefshme n\u00eb nj\u00eb program t\u00eb udh\u00ebhequr: rekomandimi yn\u00eb p\u00ebr SQL fillimisht \u00ebsht\u00eb nj\u00eb rrug\u00eb p\u00ebr vet\u00ebstudim, jo p\u00ebrshkrim i renditjes s\u00eb akademis\u00eb.<\/p>\n\n\n\n<div class=\"wp-block-group chk-cta is-layout-constrained wp-block-group-is-layout-constrained\">\n<p class=\"wp-block-paragraph\"><strong>D\u00ebshiron ta zhvillosh k\u00ebt\u00eb baz\u00eb me projekte dhe udh\u00ebzim?<\/strong> <a href=\"https:\/\/creativehubkos.com\/data-engineering-cloud-ai-academy\/\">Shiko planprogramin e Data Engineering, Cloud &amp; AI<\/a> dhe diskuto me koordinatorin se ku duhet t\u00eb fillosh sipas njohurive q\u00eb ke.<\/p>\n<\/div>\n\n\n\n<p class=\"wp-block-paragraph\">P\u00ebr nj\u00eb pamje m\u00eb t\u00eb gjer\u00eb t\u00eb roleve, lexo edhe <a href=\"https:\/\/creativehubkos.com\/blog\/career-pathways-data-engineering-cloud-ai\/\">rrug\u00ebt e karrier\u00ebs n\u00eb Data Engineering, Cloud &amp; AI<\/a>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Pyetjet e shpeshta<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">A duhet t\u00eb m\u00ebsoj SQL para Python?<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">P\u00ebr vet\u00ebstudim nga zero, rekomandojm\u00eb SQL fillimisht p\u00ebr t\u00eb kuptuar tabelat dhe query-t, pastaj Python n\u00eb t\u00eb nj\u00ebjtin projekt. N\u00ebse tashm\u00eb programon, mund t\u2019i m\u00ebsosh paralelisht.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">A e z\u00ebvend\u00ebson Python SQL?<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Jo domosdoshm\u00ebrisht. N\u00eb ushtrimin ton\u00eb Python ekzekuton komandat SQL p\u00ebrmes <code>sqlite3<\/code>. Ato punojn\u00eb bashk\u00eb brenda t\u00eb nj\u00ebjtit proces. <sup><a href=\"#s3\">[3]<\/a><\/sup><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">A mjaftojn\u00eb SQL dhe Python p\u00ebr \u00e7do pun\u00eb si Data Engineer?<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Jo. Dy shpalljet e analizuara k\u00ebrkojn\u00eb edhe p\u00ebrvoj\u00eb dhe aft\u00ebsi t\u00eb tjera, si modelim, platforma cloud dhe cil\u00ebsi t\u00eb t\u00eb dh\u00ebnave. K\u00ebrkesat ndryshojn\u00eb sipas pozit\u00ebs. <sup><a href=\"#s7\">[7]<\/a><a href=\"#s8\">[8]<\/a><\/sup><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">A duhet t\u00eb blej mjete p\u00ebr ushtrimin?<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Jo. Shembulli p\u00ebrdor Python dhe modulet e p\u00ebrmendura m\u00eb sip\u00ebr. Nuk p\u00ebrdor API me pages\u00eb, server cloud ose dataset me pages\u00eb.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Sa koh\u00eb duhet p\u00ebr t\u2019i m\u00ebsuar t\u00eb dyja?<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Ky artikull nuk vendos afat universal. Mat p\u00ebrparimin me aft\u00ebsin\u00eb p\u00ebr ta nd\u00ebrtuar, kontrolluar dhe shpjeguar nj\u00eb projekt, pastaj krahasoje me k\u00ebrkesat e rolit q\u00eb synon.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Burimet<\/h2>\n\n\n\n<p class=\"chk-small wp-block-paragraph\">Kontrolluar m\u00eb 29 shtator 2026. Faktet teknike mb\u00ebshteten te dokumentacioni zyrtar. Renditja e m\u00ebsimit, ushtrimi dhe lista e kontrollit jan\u00eb propozime editoriale; t\u00eb dh\u00ebnat e ushtrimit jan\u00eb sintetike.<\/p>\n\n\n\n<ol class=\"chk-sources\"><li id=\"s1\"><a href=\"https:\/\/www.postgresql.org\/docs\/current\/tutorial-sql.html\">PostgreSQL: The SQL Language<\/a>. Temat baz\u00eb t\u00eb SQL.<\/li><li id=\"s2\"><a href=\"https:\/\/docs.python.org\/3\/library\/csv.html\">Python: csv, CSV File Reading and Writing<\/a>. Leximi i CSV dhe DictReader.<\/li><li id=\"s3\"><a href=\"https:\/\/docs.python.org\/3\/library\/sqlite3.html\">Python: sqlite3, DB-API 2.0 interface for SQLite databases<\/a>. Lidhja me databaz\u00ebn, ekzekutimi i SQL dhe parametrat.<\/li><li id=\"s4\"><a href=\"https:\/\/docs.python.org\/3\/tutorial\/\">The Python Tutorial<\/a>. Gjuha, konceptet dhe parakushtet e tutorialit.<\/li><li id=\"s5\"><a href=\"https:\/\/www.postgresql.org\/docs\/current\/tutorial-join.html\">PostgreSQL: Joins Between Tables<\/a>. Lidhja e tabelave.<\/li><li id=\"s6\"><a href=\"https:\/\/www.postgresql.org\/docs\/current\/tutorial-agg.html\">PostgreSQL: Aggregate Functions<\/a>. P\u00ebrmbledhja dhe grupimi.<\/li><li id=\"s7\"><a href=\"https:\/\/www.kosovajob.com\/jobs.php?id=44412\">SPAXEL n\u00eb KosovaJob: Mid-Level Data Engineer Freelancer<\/a>. Shpallje e skaduar, Prishtin\u00eb; p\u00ebrdoret vet\u00ebm si shembull k\u00ebrkesash.<\/li><li id=\"s8\"><a href=\"https:\/\/kosovajob.com\/jobs?id=42754\">Borek Solutions n\u00eb KosovaJob: Senior Data Engineer<\/a>. Shpallje e sh\u00ebnuar si e skaduar; p\u00ebrdoret vet\u00ebm si shembull k\u00ebrkesash.<\/li><li id=\"s9\"><a href=\"https:\/\/www.python.org\/about\/gettingstarted\/\">Python.org: Python for Beginners<\/a>. Orientim p\u00ebr fillestar\u00ebt.<\/li><li id=\"s10\"><a href=\"https:\/\/creativehubkos.com\/data-engineering-cloud-ai-academy\/\">Creative Hub Kosovo: Data Engineering, Cloud &amp; AI Academy<\/a>. Planprogrami i publikuar.<\/li><\/ol>\n","protected":false},"excerpt":{"rendered":"<p>SQL apo Python p\u00ebr Data Engineering? Krahaso p\u00ebrdorimet, shiko k\u00ebrkesa nga Kosova dhe provo nj\u00eb projekt t\u00eb thjesht\u00eb q\u00eb i kombinon t\u00eb dyja.<\/p>\n","protected":false},"author":1,"featured_media":2787,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[20],"tags":[],"class_list":["post-2786","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-insights"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.7 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>SQL apo Python: nga t\u00eb fillosh p\u00ebr Data Engineering? - Creative Hub Kosovo<\/title>\n<meta name=\"description\" content=\"SQL apo Python p\u00ebr Data Engineering? Krahaso p\u00ebrdorimet, shiko k\u00ebrkesa nga Kosova dhe provo nj\u00eb projekt t\u00eb thjesht\u00eb q\u00eb i kombinon t\u00eb dyja.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/creativehubkos.com\/blog\/sql-apo-python-data-engineering\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL apo Python: nga t\u00eb fillosh p\u00ebr Data Engineering? - Creative Hub Kosovo\" \/>\n<meta property=\"og:description\" content=\"SQL apo Python p\u00ebr Data Engineering? Krahaso p\u00ebrdorimet, shiko k\u00ebrkesa nga Kosova dhe provo nj\u00eb projekt t\u00eb thjesht\u00eb q\u00eb i kombinon t\u00eb dyja.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/creativehubkos.com\/blog\/sql-apo-python-data-engineering\/\" \/>\n<meta property=\"og:site_name\" content=\"Creative Hub Kosovo\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/creativehubkosovo\" \/>\n<meta property=\"article:published_time\" content=\"2026-10-07T10:57:21+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/creativehubkos.com\/blog\/wp-content\/uploads\/2026\/09\/cover-sql-apo-python-data-engineering.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"675\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Creative Hub\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Creative Hub\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"11 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/creativehubkos.com\\\/blog\\\/sql-apo-python-data-engineering\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/creativehubkos.com\\\/blog\\\/sql-apo-python-data-engineering\\\/\"},\"author\":{\"name\":\"Creative Hub\",\"@id\":\"https:\\\/\\\/creativehubkos.com\\\/blog\\\/#\\\/schema\\\/person\\\/1520aec1dc8847e4078c1560bccf1b98\"},\"headline\":\"SQL apo Python: nga t\u00eb fillosh p\u00ebr Data Engineering?\",\"datePublished\":\"2026-10-07T10:57:21+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/creativehubkos.com\\\/blog\\\/sql-apo-python-data-engineering\\\/\"},\"wordCount\":2049,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/creativehubkos.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/creativehubkos.com\\\/blog\\\/sql-apo-python-data-engineering\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/creativehubkos.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/cover-sql-apo-python-data-engineering.jpg\",\"articleSection\":[\"Insights\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/creativehubkos.com\\\/blog\\\/sql-apo-python-data-engineering\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/creativehubkos.com\\\/blog\\\/sql-apo-python-data-engineering\\\/\",\"url\":\"https:\\\/\\\/creativehubkos.com\\\/blog\\\/sql-apo-python-data-engineering\\\/\",\"name\":\"SQL apo Python: nga t\u00eb fillosh p\u00ebr Data Engineering? - Creative Hub Kosovo\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/creativehubkos.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/creativehubkos.com\\\/blog\\\/sql-apo-python-data-engineering\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/creativehubkos.com\\\/blog\\\/sql-apo-python-data-engineering\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/creativehubkos.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/cover-sql-apo-python-data-engineering.jpg\",\"datePublished\":\"2026-10-07T10:57:21+00:00\",\"description\":\"SQL apo Python p\u00ebr Data Engineering? Krahaso p\u00ebrdorimet, shiko k\u00ebrkesa nga Kosova dhe provo nj\u00eb projekt t\u00eb thjesht\u00eb q\u00eb i kombinon t\u00eb dyja.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/creativehubkos.com\\\/blog\\\/sql-apo-python-data-engineering\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/creativehubkos.com\\\/blog\\\/sql-apo-python-data-engineering\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/creativehubkos.com\\\/blog\\\/sql-apo-python-data-engineering\\\/#primaryimage\",\"url\":\"https:\\\/\\\/creativehubkos.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/cover-sql-apo-python-data-engineering.jpg\",\"contentUrl\":\"https:\\\/\\\/creativehubkos.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/cover-sql-apo-python-data-engineering.jpg\",\"width\":1200,\"height\":675,\"caption\":\"SQL apo Python: nga t\u00eb fillosh p\u00ebr Data Engineering?\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/creativehubkos.com\\\/blog\\\/sql-apo-python-data-engineering\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/creativehubkos.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL apo Python: nga t\u00eb fillosh p\u00ebr Data Engineering?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/creativehubkos.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/creativehubkos.com\\\/blog\\\/\",\"name\":\"Creative Hub Kosovo\",\"description\":\"Stay inspired! Read Creative Hub Kosovo&#039;s blog for career tips, industry insights, and academy updates.\",\"publisher\":{\"@id\":\"https:\\\/\\\/creativehubkos.com\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/creativehubkos.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/creativehubkos.com\\\/blog\\\/#organization\",\"name\":\"Creative Hub Kosovo\",\"url\":\"https:\\\/\\\/creativehubkos.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/creativehubkos.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/creativehubkos.com\\\/blog3\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/logo-variations_CH-logo-circle.jpg\",\"contentUrl\":\"https:\\\/\\\/creativehubkos.com\\\/blog3\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/logo-variations_CH-logo-circle.jpg\",\"width\":1655,\"height\":1642,\"caption\":\"Creative Hub Kosovo\"},\"image\":{\"@id\":\"https:\\\/\\\/creativehubkos.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/creativehubkosovo\",\"https:\\\/\\\/www.instagram.com\\\/creativehubkosovo\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/creativehubkosovo\\\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/creativehubkos.com\\\/blog\\\/#\\\/schema\\\/person\\\/1520aec1dc8847e4078c1560bccf1b98\",\"name\":\"Creative Hub\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/7c7267a99e33b4e04e2c63652b37957b708265689aeaadcc04671d5d4228ba73?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/7c7267a99e33b4e04e2c63652b37957b708265689aeaadcc04671d5d4228ba73?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/7c7267a99e33b4e04e2c63652b37957b708265689aeaadcc04671d5d4228ba73?s=96&d=mm&r=g\",\"caption\":\"Creative Hub\"},\"sameAs\":[\"https:\\\/\\\/creativehubkos.com\\\/blog\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL apo Python: nga t\u00eb fillosh p\u00ebr Data Engineering? - Creative Hub Kosovo","description":"SQL apo Python p\u00ebr Data Engineering? Krahaso p\u00ebrdorimet, shiko k\u00ebrkesa nga Kosova dhe provo nj\u00eb projekt t\u00eb thjesht\u00eb q\u00eb i kombinon t\u00eb dyja.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/creativehubkos.com\/blog\/sql-apo-python-data-engineering\/","og_locale":"en_US","og_type":"article","og_title":"SQL apo Python: nga t\u00eb fillosh p\u00ebr Data Engineering? - Creative Hub Kosovo","og_description":"SQL apo Python p\u00ebr Data Engineering? Krahaso p\u00ebrdorimet, shiko k\u00ebrkesa nga Kosova dhe provo nj\u00eb projekt t\u00eb thjesht\u00eb q\u00eb i kombinon t\u00eb dyja.","og_url":"https:\/\/creativehubkos.com\/blog\/sql-apo-python-data-engineering\/","og_site_name":"Creative Hub Kosovo","article_publisher":"https:\/\/www.facebook.com\/creativehubkosovo","article_published_time":"2026-10-07T10:57:21+00:00","og_image":[{"width":1200,"height":675,"url":"https:\/\/creativehubkos.com\/blog\/wp-content\/uploads\/2026\/09\/cover-sql-apo-python-data-engineering.jpg","type":"image\/jpeg"}],"author":"Creative Hub","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Creative Hub","Est. reading time":"11 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/creativehubkos.com\/blog\/sql-apo-python-data-engineering\/#article","isPartOf":{"@id":"https:\/\/creativehubkos.com\/blog\/sql-apo-python-data-engineering\/"},"author":{"name":"Creative Hub","@id":"https:\/\/creativehubkos.com\/blog\/#\/schema\/person\/1520aec1dc8847e4078c1560bccf1b98"},"headline":"SQL apo Python: nga t\u00eb fillosh p\u00ebr Data Engineering?","datePublished":"2026-10-07T10:57:21+00:00","mainEntityOfPage":{"@id":"https:\/\/creativehubkos.com\/blog\/sql-apo-python-data-engineering\/"},"wordCount":2049,"commentCount":0,"publisher":{"@id":"https:\/\/creativehubkos.com\/blog\/#organization"},"image":{"@id":"https:\/\/creativehubkos.com\/blog\/sql-apo-python-data-engineering\/#primaryimage"},"thumbnailUrl":"https:\/\/creativehubkos.com\/blog\/wp-content\/uploads\/2026\/09\/cover-sql-apo-python-data-engineering.jpg","articleSection":["Insights"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/creativehubkos.com\/blog\/sql-apo-python-data-engineering\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/creativehubkos.com\/blog\/sql-apo-python-data-engineering\/","url":"https:\/\/creativehubkos.com\/blog\/sql-apo-python-data-engineering\/","name":"SQL apo Python: nga t\u00eb fillosh p\u00ebr Data Engineering? - Creative Hub Kosovo","isPartOf":{"@id":"https:\/\/creativehubkos.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/creativehubkos.com\/blog\/sql-apo-python-data-engineering\/#primaryimage"},"image":{"@id":"https:\/\/creativehubkos.com\/blog\/sql-apo-python-data-engineering\/#primaryimage"},"thumbnailUrl":"https:\/\/creativehubkos.com\/blog\/wp-content\/uploads\/2026\/09\/cover-sql-apo-python-data-engineering.jpg","datePublished":"2026-10-07T10:57:21+00:00","description":"SQL apo Python p\u00ebr Data Engineering? Krahaso p\u00ebrdorimet, shiko k\u00ebrkesa nga Kosova dhe provo nj\u00eb projekt t\u00eb thjesht\u00eb q\u00eb i kombinon t\u00eb dyja.","breadcrumb":{"@id":"https:\/\/creativehubkos.com\/blog\/sql-apo-python-data-engineering\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/creativehubkos.com\/blog\/sql-apo-python-data-engineering\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/creativehubkos.com\/blog\/sql-apo-python-data-engineering\/#primaryimage","url":"https:\/\/creativehubkos.com\/blog\/wp-content\/uploads\/2026\/09\/cover-sql-apo-python-data-engineering.jpg","contentUrl":"https:\/\/creativehubkos.com\/blog\/wp-content\/uploads\/2026\/09\/cover-sql-apo-python-data-engineering.jpg","width":1200,"height":675,"caption":"SQL apo Python: nga t\u00eb fillosh p\u00ebr Data Engineering?"},{"@type":"BreadcrumbList","@id":"https:\/\/creativehubkos.com\/blog\/sql-apo-python-data-engineering\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/creativehubkos.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL apo Python: nga t\u00eb fillosh p\u00ebr Data Engineering?"}]},{"@type":"WebSite","@id":"https:\/\/creativehubkos.com\/blog\/#website","url":"https:\/\/creativehubkos.com\/blog\/","name":"Creative Hub Kosovo","description":"Stay inspired! Read Creative Hub Kosovo&#039;s blog for career tips, industry insights, and academy updates.","publisher":{"@id":"https:\/\/creativehubkos.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/creativehubkos.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/creativehubkos.com\/blog\/#organization","name":"Creative Hub Kosovo","url":"https:\/\/creativehubkos.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/creativehubkos.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/creativehubkos.com\/blog3\/wp-content\/uploads\/2022\/10\/logo-variations_CH-logo-circle.jpg","contentUrl":"https:\/\/creativehubkos.com\/blog3\/wp-content\/uploads\/2022\/10\/logo-variations_CH-logo-circle.jpg","width":1655,"height":1642,"caption":"Creative Hub Kosovo"},"image":{"@id":"https:\/\/creativehubkos.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/creativehubkosovo","https:\/\/www.instagram.com\/creativehubkosovo\/","https:\/\/www.linkedin.com\/company\/creativehubkosovo\/"]},{"@type":"Person","@id":"https:\/\/creativehubkos.com\/blog\/#\/schema\/person\/1520aec1dc8847e4078c1560bccf1b98","name":"Creative Hub","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/7c7267a99e33b4e04e2c63652b37957b708265689aeaadcc04671d5d4228ba73?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/7c7267a99e33b4e04e2c63652b37957b708265689aeaadcc04671d5d4228ba73?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/7c7267a99e33b4e04e2c63652b37957b708265689aeaadcc04671d5d4228ba73?s=96&d=mm&r=g","caption":"Creative Hub"},"sameAs":["https:\/\/creativehubkos.com\/blog"]}]}},"_links":{"self":[{"href":"https:\/\/creativehubkos.com\/blog\/wp-json\/wp\/v2\/posts\/2786","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/creativehubkos.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/creativehubkos.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/creativehubkos.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/creativehubkos.com\/blog\/wp-json\/wp\/v2\/comments?post=2786"}],"version-history":[{"count":1,"href":"https:\/\/creativehubkos.com\/blog\/wp-json\/wp\/v2\/posts\/2786\/revisions"}],"predecessor-version":[{"id":2802,"href":"https:\/\/creativehubkos.com\/blog\/wp-json\/wp\/v2\/posts\/2786\/revisions\/2802"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/creativehubkos.com\/blog\/wp-json\/wp\/v2\/media\/2787"}],"wp:attachment":[{"href":"https:\/\/creativehubkos.com\/blog\/wp-json\/wp\/v2\/media?parent=2786"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/creativehubkos.com\/blog\/wp-json\/wp\/v2\/categories?post=2786"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/creativehubkos.com\/blog\/wp-json\/wp\/v2\/tags?post=2786"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}