{"id":50373,"date":"2026-01-05T12:17:13","date_gmt":"2026-01-05T11:17:13","guid":{"rendered":"https:\/\/eccentrix-eu.com\/?post_type=formation&p=50373"},"modified":"2026-07-07T14:12:39","modified_gmt":"2026-07-07T12:12:39","slug":"obuka-za-transact-sql","status":"publish","type":"formation","link":"https:\/\/eccentrix-eu.com\/sr\/obuke\/microsoft\/azure\/obuka-za-transact-sql\/","title":{"rendered":"Upit i izmena podataka pomoc\u0301u Transact-SQL-a (DP-080T00)"},"content":{"rendered":"\t\t
\n\t\t\t\t
\n\t\t\t\t\t
\n\t\t
\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t

Upit i izmena podataka pomoc\u0301u Transact-SQL-a (DP-080T00): Detaljan plan obuke<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/path><\/svg><\/span>\n\t\t\t\t\t\t\t\t<\/path><\/svg><\/span>\n\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\tModule 1: Introduction to Transact-SQL<\/a>\n\t\t\t\t\t<\/h6>\n\t\t\t\t\t
  • Work with schemas<\/div><\/div><\/li>
  • Explore the structure of SQL statements<\/div><\/div><\/li>
  • Examine the SELECT statement<\/div><\/div><\/li>
  • Work with data types<\/div><\/div><\/li>
  • Handle NULLs<\/div><\/div><\/li>
  • Exercise – Work with SELECT statements<\/div><\/div><\/li><\/ul><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t
    \n\t\t\t\t\t
    \n\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/path><\/svg><\/span>\n\t\t\t\t\t\t\t\t<\/path><\/svg><\/span>\n\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\tModule 2: Sort and filter results in T-SQL<\/a>\n\t\t\t\t\t<\/h6>\n\t\t\t\t\t
    • Sort your results<\/div><\/div><\/li>
    • Limit the sorted results<\/div><\/div><\/li>
    • Page results<\/div><\/div><\/li>
    • Remove duplicates<\/div><\/div><\/li>
    • Filter data with predicates<\/div><\/div><\/li>
    • Exercise – Sort and filter query results<\/div><\/div><\/li><\/ul><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t
      \n\t\t\t\t\t
      \n\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/path><\/svg><\/span>\n\t\t\t\t\t\t\t\t<\/path><\/svg><\/span>\n\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\tModule 3: Combine multiple tables with JOINs in T-SQL<\/a>\n\t\t\t\t\t<\/h6>\n\t\t\t\t\t
      • Understand joins concepts and syntax<\/div><\/div><\/li>
      • Use inner joins<\/div><\/div><\/li>
      • Use outer joins<\/div><\/div><\/li>
      • Use cross joins<\/div><\/div><\/li>
      • Use self joins<\/div><\/div><\/li>
      • Exercise – Query multiple tables with joins<\/div><\/div><\/li><\/ul><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t
        \n\t\t\t\t\t
        \n\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/path><\/svg><\/span>\n\t\t\t\t\t\t\t\t<\/path><\/svg><\/span>\n\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\tModule 4: Write Subqueries in T-SQL<\/a>\n\t\t\t\t\t<\/h6>\n\t\t\t\t\t
        • Understand subqueries<\/div><\/div><\/li>
        • Use scalar or multi-valued subqueries<\/div><\/div><\/li>
        • Use self-contained or correlated subqueries<\/div><\/div><\/li>
        • Exercise – Use subqueries<\/div><\/div><\/li><\/ul><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t
          \n\t\t\t\t\t
          \n\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/path><\/svg><\/span>\n\t\t\t\t\t\t\t\t<\/path><\/svg><\/span>\n\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\tModule 5:Use built-in functions and GROUP BY in Transact-SQL<\/a>\n\t\t\t\t\t<\/h6>\n\t\t\t\t\t
          • Categorize built-in functions<\/div><\/div><\/li>
          • Use scalar functions<\/div><\/div><\/li>
          • Use ranking and rowset functions<\/div><\/div><\/li>
          • Use aggregate functions<\/div><\/div><\/li>
          • Summarize data with GROUP BY<\/div><\/div><\/li>
          • Filter groups with HAVING<\/div><\/div><\/li>
          • Exercise – Use built-in functions<\/div><\/div><\/li><\/ul><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t
            \n\t\t\t\t\t
            \n\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/path><\/svg><\/span>\n\t\t\t\t\t\t\t\t<\/path><\/svg><\/span>\n\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\tModule 6: Modify data with T-SQL<\/a>\n\t\t\t\t\t<\/h6>\n\t\t\t\t\t
            • Insert data<\/div><\/div><\/li>
            • Generate automatic values<\/div><\/div><\/li>
            • Update data<\/div><\/div><\/li>
            • Delete data<\/div><\/div><\/li>
            • Merge data based on multiple tables<\/div><\/div><\/li>
            • Exercise – Modify data<\/div><\/div><\/li><\/ul><\/div>\n\t\t\t\t<\/div>\n\t\t\t\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>\n\t\t
              \n\t\t\t\t
              \n\t\t\t\t
              \n\t\t\t\t\t

              Preporu\u010deno predznanje<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
              \n\t\t\t\t
              \n\t\t\t\t\t\t\t\t\t
                \n
              • Poznavanje rada sa tabelama podataka, na primer u tabelarnom programu.<\/li>\n<\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t
                \n\t\t\t\t\t
                \n\t\t\t\t
                \n\t\t\t\t
                \n\t\t\t\t\t

                Obuka za Transact-SQL<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
                \n\t\t\t\t
                \n\t\t\t\t\t\t\t\t\t

                Obuka za Transact SQL upite je osmi\u0161ljena da osna\u017ei IT stru\u010dnjake znanjem i ve\u0161tinama potrebnim za implementaciju robusnih re\u0161enja za upite pomoc\u0301u Microsoft Transact-SQL-a. Ovaj kurs pru\u017ea detaljno razumevanje moguc\u0301nosti Transact-SQL-a, uklju\u010dujuc\u0301i pode\u0161avanje slo\u017eenih upita, kreiranje skladi\u0161tenih procedura i analizu podataka radi optimizacije performansi i pouzdanosti Microsoft SQL baza podataka.<\/p>

                Savladavanjem Transact-SQL-a, u\u010desnici mogu da obezbede proaktivno upravljanje svojim okru\u017eenjima baza podataka, omoguc\u0301avajuc\u0301i efikasno izdvajanje i manipulaciju podacima.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

                \n\t\t\t\t
                \n\t\t\t\t\t

                Za\u0161to poha\u0111ati ovu obuku?<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
                \n\t\t\t\t
                \n\t\t\t\t\t\t\t\t\t

                Efikasno upitivanje resursa baze podataka je klju\u010dno za odr\u017eavanje performansi i dostupnosti podataka. Transact-SQL je sveobuhvatno re\u0161enje za prac\u0301enje, dijagnostikovanje i optimizaciju resursa Microsoft baze podataka. Ova obuka pru\u017ea stru\u010dnost za konfigurisanje i kori\u0161c\u0301enje Transact-SQL-a za napredne uvide i operativnu efikasnost.<\/p>

                U\u010desnici c\u0301e nau\u010diti kako da podese automatizovane upite, prilagode re\u0161enja za baze podataka i iskoriste analitiku za pobolj\u0161anje otpornosti svoje infrastrukture podataka.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

                \n\t\t\t\t
                \n\t\t\t\t\t

                Ve\u0161tine razvijene tokom obuke<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
                \n\t\t\t\t
                \n\t\t\t\t\t\t\t\t\t
                1. Pode\u0161avanje Transact-SQL-a
                  Nau\u010dite kako da primenite Transact-SQL da biste nadgledali performanse i ispravnost resursa va\u0161e baze podataka.<\/li>
                2. Prilago\u0111avanje upita i obave\u0161tenja
                  Savladajte kreiranje upita za klju\u010dne metrike i doga\u0111aje kako biste omoguc\u0301ili proaktivno upravljanje problemima sa podacima.<\/li>
                3. Kori\u0161c\u0301enje analitike podataka
                  Istra\u017eite kako da analizirate telemetrijske podatke i logove za prakti\u010dne uvide koristec\u0301i moc\u0301ne alate Transact-SQL-a.<\/li>
                4. Kreiranje prilago\u0111enih prikaza
                  Dizajnirajte prikaze koji konsoliduju kriti\u010dne informacije i pru\u017eaju uvid u performanse baze podataka u realnom vremenu.<\/li>
                5. Integracija sa Microsoft SQL uslugama
                  Otkrijte kako da integri\u0161ete Transact-SQL sa drugim Microsoft uslugama kao \u0161to su SQL Server, Azure SQL baza podataka i Azure Synapse Analytics.<\/li>
                6. Implementacija najboljih praksi u upitima podataka
                  Steknite stru\u010dnost u optimizaciji konfiguracija kako biste osigurali isplativo i pouzdano upitivanje baze podataka.<\/li><\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
                  \n\t\t\t\t
                  \n\t\t\t\t\t

                  Interaktivna, prakti\u010dno orijentisana obuka\n<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
                  \n\t\t\t\t
                  \n\t\t\t\t\t\t\t\t\t

                  Vo\u0111en od strane sertifikovanih Microsoft stru\u010dnjaka, ovaj kurs kombinuje teorijsko znanje sa prakti\u010dnim ve\u017ebama. U\u010desnici c\u0301e raditi na scenarijima iz stvarnog sveta kako bi efikasno primenili Transact-SQL funkcije, osiguravajuc\u0301i spremnost za profesionalne izazove.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

                  \n\t\t\t\t
                  \n\t\t\t\t\t

                  Ko bi trebalo da prisustvuje?<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
                  \n\t\t\t\t
                  \n\t\t\t\t\t\t\t\t\t
                  • Programeri baza podataka koji upravljaju Microsoft SQL resursima<\/li>
                  • IT stru\u010dnjaci odgovorni za upite i dijagnostiku podataka<\/li>
                  • Sistemski arhitekti koji projektuju skalabilna i pouzdana re\u0161enja za baze podataka<\/li>
                  • Svi koji su zainteresovani za u\u010denje naprednih tehnika upita za Microsoft SQL<\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
                    \n\t\t\t\t
                    \n\t\t\t\t\t

                    Unapredite upravljanje Microsoft SQL-om uz stru\u010dnost u Transact-SQL-u<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
                    \n\t\t\t\t
                    \n\t\t\t\t\t\t\t\t\t

                    Obuka \u201eUpiti i modifikacija podataka pomoc\u0301u Transact-SQL-a\u201c (DP-080T00) oprema vas ve\u0161tinama potrebnim za kori\u0161c\u0301enje Transact-SQL-a za optimizaciju operacija va\u0161e baze podataka. Upi\u0161ite se sada da biste savladali napredne tehnike upita i osigurali otpornost i efikasnost va\u0161eg Microsoft SQL okru\u017eenja.<\/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\t\t<\/div>\n\t\t

                    \n\t\t\t\t\t
                    \n\t\t\t\t
                    \n\t\t\t\t
                    \n\t\t\t\t\t

                    \u010cesto postavljana pitanja - Obuka za Transact-SQL (FAQ)<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
                    \n\t\t\t\t
                    \n\t\t\t\t\t\t\t
                    \n\t\t\t\t\t\t\t
                    \n\t\t\t\t\t
                    \n\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/path><\/svg><\/span>\n\t\t\t\t\t\t\t\t<\/path><\/svg><\/span>\n\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\u0160ta obuhvata ova obuka?<\/a>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t

                    Pokriva implementaciju, konfiguraciju, upite, prikaze, analizu podataka i integraciju sa drugim Microsoft SQL servisima.<\/p><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t

                    \n\t\t\t\t\t
                    \n\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/path><\/svg><\/span>\n\t\t\t\t\t\t\t\t<\/path><\/svg><\/span>\n\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\tDa li je potrebno prethodno iskustvo sa Microsoft SQL-om?<\/a>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t

                    Osnovno razumevanje Microsoft SQL-a i koncepata baza podataka je preporu\u010dljivo, ali nije obavezno.<\/p><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t

                    \n\t\t\t\t\t
                    \n\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/path><\/svg><\/span>\n\t\t\t\t\t\t\t\t<\/path><\/svg><\/span>\n\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\tDa li su uklju\u010dene prakti\u010dne ve\u017ebe?<\/a>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t

                    Da, kurs sadr\u017ei prakti\u010dne laboratorijske ve\u017ebe i scenarije iz stvarnog sveta za primenu Transact-SQL ve\u0161tina.<\/p><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t

                    \n\t\t\t\t\t
                    \n\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/path><\/svg><\/span>\n\t\t\t\t\t\t\t\t<\/path><\/svg><\/span>\n\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\tKako Transact-SQL pobolj\u0161ava upravljanje bazama podataka?<\/a>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t

                    Omoguc\u0301ava proaktivno upravljanje podacima, kontinuirano prac\u0301enje performansi i naprednu za\u0161titu resursa baze podataka.<\/p><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t

                    \n\t\t\t\t\t
                    \n\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/path><\/svg><\/span>\n\t\t\t\t\t\t\t\t<\/path><\/svg><\/span>\n\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\tDa li se Transact-SQL mo\u017ee integrisati sa drugim alatima?<\/a>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t

                    Da, besprekorno se integri\u0161e sa SQL Server-om, Azure SQL bazom podataka, Azure Synapse Analytics-om i drugim Microsoft uslugama.<\/p><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t

                    \n\t\t\t\t\t
                    \n\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/path><\/svg><\/span>\n\t\t\t\t\t\t\t\t<\/path><\/svg><\/span>\n\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\tDa li ovaj kurs uklju\u010duje najbolje prakse za upite o podacima?<\/a>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t

                    Apsolutno, obuka pokriva strategije optimizacije i najbolje prakse za efikasno upite podataka.<\/p><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t