{"id":51,"count":1,"description":"Online kurzy IBM DB2 s\u00fa zameran\u00e9 na rela\u010dn\u00fd datab\u00e1zov\u00fd syst\u00e9m IBM Db2, tvorbu a spr\u00e1vu datab\u00e1z, datab\u00e1zov\u00e9 objekty, jazyk SQL, SQL dopyty, z\u00e1lohovanie a obnovu d\u00e1t, zabezpe\u010denie datab\u00e1z a praktick\u00e9 prepojenie datab\u00e1z s programovac\u00edm jazykom Python. V <strong><a href=\"https:\/\/www.vita.sk\/online-kurz-db2-udb-i-zaciatocnik\/\">IBM DB2 I. Za\u010diato\u010dn\u00edk<\/a><\/strong> sa nau\u010d\u00edte z\u00e1klady pr\u00e1ce s datab\u00e1zov\u00fdm syst\u00e9mom IBM DB2, vytv\u00e1ra\u0165 datab\u00e1zy, nap\u013a\u0148a\u0165 ich \u00fadajmi, pres\u00fava\u0165 d\u00e1ta a pracova\u0165 s datab\u00e1zov\u00fdmi objektmi. Osvoj\u00edte si in\u0161tal\u00e1ciu IBM DB2, vytvorenie datab\u00e1zov\u00e9ho pripojenia, pr\u00e1cu s konzolou a Server Managerom a z\u00e1kladn\u00fa administr\u00e1ciu datab\u00e1zov\u00e9ho prostredia. Nau\u010d\u00edte sa vytv\u00e1ra\u0165 SQL dopyty, pou\u017e\u00edva\u0165 podmienky, funkcie, tabu\u013eky, oper\u00e1tory OR a AND, pr\u00edkaz FETCH, vnoren\u00e9 dopyty (SubSelect) a oper\u00e1cie JOIN. Kurz sa venuje aj ERD (Entity Relationship Diagram), z\u00e1lohovaniu a obnove \u00fadajov, z\u00e1kladom zabezpe\u010denia datab\u00e1z a vyu\u017eitiu kni\u017en\u00edc a modulov DBMS (Database Management System). Praktick\u00fa \u010das\u0165 dop\u013a\u0148a pr\u00e1ca s programovac\u00edm jazykom Python a jeho prepojenie s datab\u00e1zami. Online kurzy IBM DB2 rozv\u00edjaj\u00fa praktick\u00e9 zru\u010dnosti vyu\u017eite\u013en\u00e9 pre datab\u00e1zov\u00fdch administr\u00e1torov, SQL \u0161pecialistov, d\u00e1tov\u00fdch a datab\u00e1zov\u00fdch analytikov, program\u00e1torov, .NET developerov, webov\u00fdch v\u00fdvoj\u00e1rov, testerov a IT \u0161pecialistov pracuj\u00facich s podnikov\u00fdmi datab\u00e1zami.","link":"https:\/\/www.vita.sk\/cs\/online-kurzy-ibm-db2\/","name":"DB2 UDB","slug":"online-kurzy-ibm-db2","taxonomy":"product_cat","parent":49,"meta":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v25.0 (Yoast SEO v25.0) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>DB2 UDB | VITA<\/title>\n<meta name=\"description\" content=\"Online kurzy IBM DB2 v\u00e1s nau\u010dia datab\u00e1zy Db2, SQL, JOIN, SubSelect, datab\u00e1zov\u00e9 objekty, z\u00e1lohovanie, obnovu d\u00e1t, zabezpe\u010denie a Python. \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\/online-kurzy-db2-udb\/\" \/>\n<meta property=\"og:locale\" content=\"cs_CZ\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"DB2 UDB arch\u00edvy\" \/>\n<meta property=\"og:description\" content=\"Online kurzy IBM DB2 v\u00e1s nau\u010dia datab\u00e1zy Db2, SQL, JOIN, SubSelect, datab\u00e1zov\u00e9 objekty, z\u00e1lohovanie, obnovu d\u00e1t, zabezpe\u010denie a Python. \u2705\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.vita.sk\/online-kurzy-db2-udb\/\" \/>\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\/online-kurzy-db2-udb\/\",\n\t            \"url\": \"https:\/\/www.vita.sk\/online-kurzy-db2-udb\/\",\n\t            \"name\": \"DB2 UDB | VITA\",\n\t            \"isPartOf\": {\n\t                \"@id\": \"https:\/\/www.vita.sk\/#website\"\n\t            },\n\t            \"description\": \"Online kurzy IBM DB2 v\u00e1s nau\u010dia datab\u00e1zy Db2, SQL, JOIN, SubSelect, datab\u00e1zov\u00e9 objekty, z\u00e1lohovanie, obnovu d\u00e1t, zabezpe\u010denie a Python. \u2705\",\n\t            \"breadcrumb\": {\n\t                \"@id\": \"https:\/\/www.vita.sk\/online-kurzy-db2-udb\/#breadcrumb\"\n\t            },\n\t            \"inLanguage\": \"cs\"\n\t        },\n\t        {\n\t            \"@type\": \"BreadcrumbList\",\n\t            \"@id\": \"https:\/\/www.vita.sk\/online-kurzy-db2-udb\/#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\": \"DB2 UDB\"\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":"DB2 UDB | VITA","description":"Online kurzy IBM DB2 v\u00e1s nau\u010dia datab\u00e1zy Db2, SQL, JOIN, SubSelect, datab\u00e1zov\u00e9 objekty, z\u00e1lohovanie, obnovu d\u00e1t, zabezpe\u010denie a Python. \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\/online-kurzy-db2-udb\/","og_locale":"cs_CZ","og_type":"article","og_title":"DB2 UDB arch\u00edvy","og_description":"Online kurzy IBM DB2 v\u00e1s nau\u010dia datab\u00e1zy Db2, SQL, JOIN, SubSelect, datab\u00e1zov\u00e9 objekty, z\u00e1lohovanie, obnovu d\u00e1t, zabezpe\u010denie a Python. \u2705","og_url":"https:\/\/www.vita.sk\/online-kurzy-db2-udb\/","og_site_name":"VITA","twitter_card":"summary_large_image","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"CollectionPage","@id":"https:\/\/www.vita.sk\/online-kurzy-db2-udb\/","url":"https:\/\/www.vita.sk\/online-kurzy-db2-udb\/","name":"DB2 UDB | VITA","isPartOf":{"@id":"https:\/\/www.vita.sk\/#website"},"description":"Online kurzy IBM DB2 v\u00e1s nau\u010dia datab\u00e1zy Db2, SQL, JOIN, SubSelect, datab\u00e1zov\u00e9 objekty, z\u00e1lohovanie, obnovu d\u00e1t, zabezpe\u010denie a Python. \u2705","breadcrumb":{"@id":"https:\/\/www.vita.sk\/online-kurzy-db2-udb\/#breadcrumb"},"inLanguage":"cs"},{"@type":"BreadcrumbList","@id":"https:\/\/www.vita.sk\/online-kurzy-db2-udb\/#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":"DB2 UDB"}]},{"@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\/51","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=51"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}