{"id":487,"count":2,"description":"Online kurzy Oracle PL\/SQL s\u00fa zameran\u00e9 na programovanie a spracovanie d\u00e1t v datab\u00e1zovom syst\u00e9me Oracle, procedur\u00e1lne roz\u0161\u00edrenie jazyka SQL, datab\u00e1zov\u00e9 proced\u00fary, triggery, cykly, premenn\u00e9, d\u00e1tov\u00e9 typy, transakcie a pr\u00e1cu v Oracle SQL Developer. V Oracle PL\/SQL I. Za\u010diato\u010dn\u00edk<\/a><\/strong> sa nau\u010d\u00edte z\u00e1kladn\u00fa \u0161trukt\u00faru a syntax PL\/SQL, pou\u017e\u00edva\u0165 \u010d\u00edseln\u00e9 d\u00e1tov\u00e9 typy, deklarova\u0165 kon\u0161tanty, vytv\u00e1ra\u0165 vnoren\u00e9 FOR cykly a pracova\u0165 s proced\u00farami. Osvoj\u00edte si tvorbu datab\u00e1zy v Oracle SQL Developer, cykly LOOP a FOR, import sch\u00e9m a datab\u00e1zov\u00fdch pripojen\u00ed, vytv\u00e1ranie tabuliek a triggerov, vkladanie \u00fadajov pomocou INSERT INTO a riadenie datab\u00e1zov\u00fdch transakci\u00ed. Nau\u010d\u00edte sa vytv\u00e1ra\u0165 vlastn\u00e9 proced\u00fary, zaznamen\u00e1va\u0165 logy a spracov\u00e1va\u0165 varovania a chyby pri datab\u00e1zov\u00fdch oper\u00e1ci\u00e1ch. Kateg\u00f3riu dop\u013a\u0148a Oracle DB Database I. Za\u010diato\u010dn\u00edk<\/a><\/strong>, ktor\u00fd vytv\u00e1ra potrebn\u00fd z\u00e1klad pre \u010fal\u0161ie programovanie v PL\/SQL. Nau\u010d\u00edte sa v \u0148om nain\u0161talova\u0165 a nakonfigurova\u0165 Oracle Database a Oracle SQL Developer, vytv\u00e1ra\u0165 datab\u00e1zy, sch\u00e9my a tabu\u013eky a pracova\u0165 s pr\u00edkazmi SELECT a INSERT, filtrovan\u00edm, trieden\u00edm a z\u00e1kladn\u00fdmi SQL dopytmi. Online kurzy Oracle PL\/SQL rozv\u00edjaj\u00fa praktick\u00e9 zru\u010dnosti vyu\u017eite\u013en\u00e9 pre datab\u00e1zov\u00fdch v\u00fdvoj\u00e1rov a administr\u00e1torov, SQL a Oracle \u0161pecialistov, d\u00e1tov\u00fdch analytikov a vedcov, program\u00e1torov, IT analytikov, testerov a IKT architektov pracuj\u00facich s datab\u00e1zami Oracle.","link":"https:\/\/www.vita.sk\/cs\/online-kurzy-pl-sql\/","name":"PL\/SQL","slug":"online-kurzy-pl-sql","taxonomy":"product_cat","parent":49,"meta":[],"yoast_head":"\nPL\/SQL | VITA<\/title>\n<meta name=\"description\" content=\"Online kurzy Oracle PL\/SQL v\u00e1s nau\u010dia Oracle Database, SQL Developer, proced\u00fary, triggery, LOOP a FOR cykly, transakcie a datab\u00e1zov\u00e9 programovanie. \u2705\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.vita.sk\/pl-sql\/\" \/>\n<meta property=\"og:locale\" content=\"cs_CZ\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"PL\/SQL arch\u00edvy\" \/>\n<meta property=\"og:description\" content=\"Online kurzy Oracle PL\/SQL v\u00e1s nau\u010dia Oracle Database, SQL Developer, proced\u00fary, triggery, LOOP a FOR cykly, transakcie a datab\u00e1zov\u00e9 programovanie. \u2705\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.vita.sk\/pl-sql\/\" \/>\n<meta property=\"og:site_name\" content=\"VITA\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\n\t \"@context\": \"https:\/\/schema.org\",\n\t \"@graph\": [\n\t {\n\t \"@type\": \"CollectionPage\",\n\t \"@id\": \"https:\/\/www.vita.sk\/pl-sql\/\",\n\t \"url\": \"https:\/\/www.vita.sk\/pl-sql\/\",\n\t \"name\": \"PL\/SQL | VITA\",\n\t \"isPartOf\": {\n\t \"@id\": \"https:\/\/www.vita.sk\/#website\"\n\t },\n\t \"description\": \"Online kurzy Oracle PL\/SQL v\u00e1s nau\u010dia Oracle Database, SQL Developer, proced\u00fary, triggery, LOOP a FOR cykly, transakcie a datab\u00e1zov\u00e9 programovanie. \u2705\",\n\t \"breadcrumb\": {\n\t \"@id\": \"https:\/\/www.vita.sk\/pl-sql\/#breadcrumb\"\n\t },\n\t \"inLanguage\": \"cs\"\n\t },\n\t {\n\t \"@type\": \"BreadcrumbList\",\n\t \"@id\": \"https:\/\/www.vita.sk\/pl-sql\/#breadcrumb\",\n\t \"itemListElement\": [\n\t {\n\t \"@type\": \"ListItem\",\n\t \"position\": 1,\n\t \"name\": \"VITA Academy\",\n\t \"item\": \"https:\/\/www.vita.sk\/cs\/\"\n\t },\n\t {\n\t \"@type\": \"ListItem\",\n\t \"position\": 2,\n\t \"name\": \"Shop\",\n\t \"item\": \"https:\/\/www.vita.sk\/shop\/\"\n\t },\n\t {\n\t \"@type\": \"ListItem\",\n\t \"position\": 3,\n\t \"name\": \"Spr\u00e1va Datab\u00e1z, \u0160tatistika a D\u00e1tov\u00e1 Anal\u00fdza\",\n\t \"item\": \"https:\/\/www.vita.sk\/online-kurzy-databazy-statistika-analytika\/\"\n\t },\n\t {\n\t \"@type\": \"ListItem\",\n\t \"position\": 4,\n\t \"name\": \"PL\/SQL\"\n\t }\n\t ]\n\t },\n\t {\n\t \"@type\": \"WebSite\",\n\t \"@id\": \"https:\/\/www.vita.sk\/#website\",\n\t \"url\": \"https:\/\/www.vita.sk\/\",\n\t \"name\": \"VITA\",\n\t \"description\": \"\",\n\t \"publisher\": {\n\t \"@id\": \"https:\/\/www.vita.sk\/#organization\"\n\t },\n\t \"potentialAction\": [\n\t {\n\t \"@type\": \"SearchAction\",\n\t \"target\": {\n\t \"@type\": \"EntryPoint\",\n\t \"urlTemplate\": \"https:\/\/www.vita.sk\/?s={search_term_string}\"\n\t },\n\t \"query-input\": {\n\t \"@type\": \"PropertyValueSpecification\",\n\t \"valueRequired\": true,\n\t \"valueName\": \"search_term_string\"\n\t }\n\t }\n\t ],\n\t \"inLanguage\": \"cs\"\n\t },\n\t {\n\t \"email\": \"admin@vita.sk\",\n\t \"logo\": \"https:\/\/www.vita.sk\/img\/vita_logo.png \",\n\t \"address\": {\n\t \"type\": \"PostalAddress\",\n\t \"streetAddress\": \"Tom\u00e1\u0161ikova 50\/A\",\n\t \"addressLocality\": \"Bratislava\",\n\t \"postalCode\": \"83104\",\n\t \"addressCountry\": {\n\t \"name\": \"SK\",\n\t \"type\": \"Country\"\n\t }\n\t },\n\t \"contactPoint\": {\n\t \"type\": \"ContactPoint\",\n\t \"telephone\": \"+421 907 375\u00a0543\",\n\t \"Email\": \"admin@vita.sk\",\n\t \"contactType\": \"customer service\"\n\t },\n\t \"sameAs\": [\n\t \"https:\/\/www.facebook.com\/VitaAcademySK\/\",\n\t \"https:\/\/www.linkedin.com\/company\/vita-academy\/\"\n\t ]\n\t }\n\t ]\n\t}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"PL\/SQL | VITA","description":"Online kurzy Oracle PL\/SQL v\u00e1s nau\u010dia Oracle Database, SQL Developer, proced\u00fary, triggery, LOOP a FOR cykly, transakcie a datab\u00e1zov\u00e9 programovanie. \u2705","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:\/\/www.vita.sk\/pl-sql\/","og_locale":"cs_CZ","og_type":"article","og_title":"PL\/SQL arch\u00edvy","og_description":"Online kurzy Oracle PL\/SQL v\u00e1s nau\u010dia Oracle Database, SQL Developer, proced\u00fary, triggery, LOOP a FOR cykly, transakcie a datab\u00e1zov\u00e9 programovanie. \u2705","og_url":"https:\/\/www.vita.sk\/pl-sql\/","og_site_name":"VITA","twitter_card":"summary_large_image","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"CollectionPage","@id":"https:\/\/www.vita.sk\/pl-sql\/","url":"https:\/\/www.vita.sk\/pl-sql\/","name":"PL\/SQL | VITA","isPartOf":{"@id":"https:\/\/www.vita.sk\/#website"},"description":"Online kurzy Oracle PL\/SQL v\u00e1s nau\u010dia Oracle Database, SQL Developer, proced\u00fary, triggery, LOOP a FOR cykly, transakcie a datab\u00e1zov\u00e9 programovanie. \u2705","breadcrumb":{"@id":"https:\/\/www.vita.sk\/pl-sql\/#breadcrumb"},"inLanguage":"cs"},{"@type":"BreadcrumbList","@id":"https:\/\/www.vita.sk\/pl-sql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"VITA Academy","item":"https:\/\/www.vita.sk\/cs\/"},{"@type":"ListItem","position":2,"name":"Shop","item":"https:\/\/www.vita.sk\/shop\/"},{"@type":"ListItem","position":3,"name":"Spr\u00e1va Datab\u00e1z, \u0160tatistika a D\u00e1tov\u00e1 Anal\u00fdza","item":"https:\/\/www.vita.sk\/online-kurzy-databazy-statistika-analytika\/"},{"@type":"ListItem","position":4,"name":"PL\/SQL"}]},{"@type":"WebSite","@id":"https:\/\/www.vita.sk\/#website","url":"https:\/\/www.vita.sk\/","name":"VITA","description":"","publisher":{"@id":"https:\/\/www.vita.sk\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.vita.sk\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"cs"},{"email":"admin@vita.sk","logo":"https:\/\/www.vita.sk\/img\/vita_logo.png ","address":{"type":"PostalAddress","streetAddress":"Tom\u00e1\u0161ikova 50\/A","addressLocality":"Bratislava","postalCode":"83104","addressCountry":{"name":"SK","type":"Country"}},"contactPoint":{"type":"ContactPoint","telephone":"+421 907 375\u00a0543","Email":"admin@vita.sk","contactType":"customer service"},"sameAs":["https:\/\/www.facebook.com\/VitaAcademySK\/","https:\/\/www.linkedin.com\/company\/vita-academy\/"]}]}},"acf":[],"_links":{"self":[{"href":"https:\/\/www.vita.sk\/cs\/wp-json\/wp\/v2\/product_cat\/487","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.vita.sk\/cs\/wp-json\/wp\/v2\/product_cat"}],"about":[{"href":"https:\/\/www.vita.sk\/cs\/wp-json\/wp\/v2\/taxonomies\/product_cat"}],"up":[{"embeddable":true,"href":"https:\/\/www.vita.sk\/cs\/wp-json\/wp\/v2\/product_cat\/49"}],"wp:post_type":[{"href":"https:\/\/www.vita.sk\/cs\/wp-json\/wp\/v2\/product?product_cat=487"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}