{"id":504,"count":2,"description":"Online kurzy Datab\u00e1zy a SQL s\u00fa zameran\u00e9 na rela\u010dn\u00e9 datab\u00e1zy, datab\u00e1zov\u00e9 tabu\u013eky, jazyk SQL, SQL dopyty, spracovanie a spr\u00e1vu d\u00e1t, import a export \u00fadajov a praktick\u00fa pr\u00e1cu s datab\u00e1zov\u00fdmi syst\u00e9mami MySQL, PostgreSQL a Microsoft SQL Server. V Datab\u00e1zy a SQL<\/a><\/strong> sa nau\u010d\u00edte z\u00e1klady datab\u00e1z a jazyka SQL, pracova\u0165 s datab\u00e1zov\u00fdmi objektmi a tabu\u013ekami, pou\u017e\u00edva\u0165 phpMyAdmin a konzolu a vytv\u00e1ra\u0165 SQL dopyty. Osvoj\u00edte si pripojenie k datab\u00e1ze, import \u00fadajov z Excel a CSV s\u00faborov, pr\u00e1cu s datasetmi, export d\u00e1t, generovanie testovac\u00edch \u00fadajov, filtrovanie v\u00fdsledkov a sp\u00e1janie tabuliek pomocou JOIN. V Jazyk SQL \u2013 MySQL, PostgreSQL, Microsoft SQL Server<\/a><\/strong> sa nau\u010d\u00edte pou\u017e\u00edva\u0165 SQL v troch v\u00fdznamn\u00fdch rela\u010dn\u00fdch datab\u00e1zov\u00fdch syst\u00e9moch, prip\u00e1ja\u0165 sa k datab\u00e1zam a pracova\u0165 s pr\u00edkazmi SELECT, INSERT, UPDATE a DELETE. Kurz sa venuje oper\u00e1torom BETWEEN a LIKE, divok\u00fdm kart\u00e1m, funkci\u00e1m CONCAT, agrega\u010dn\u00fdm funkci\u00e1m, GROUP BY, HAVING, pr\u00e1ci s d\u00e1tumom a \u010dasom, vnoren\u00fdm dopytom (Subqueries), JOIN, LEFT a RIGHT JOIN, UNION a UNION ALL a d\u00e1tov\u00fdm typom. Online kurzy Datab\u00e1zy a SQL rozv\u00edjaj\u00fa praktick\u00e9 zru\u010dnosti vyu\u017eite\u013en\u00e9 pre datab\u00e1zov\u00fdch administr\u00e1torov a analytikov, SQL \u0161pecialistov, d\u00e1tov\u00fdch a business analytikov, backend a fullstack program\u00e1torov, BI developerov, testerov a IT \u0161pecialistov pracuj\u00facich s d\u00e1tami.","link":"https:\/\/www.vita.sk\/en\/online-kurzy-databazy-a-sql\/","name":"Datab\u00e1zy a SQL","slug":"online-kurzy-databazy-a-sql","taxonomy":"product_cat","parent":49,"meta":[],"yoast_head":"\nDatab\u00e1zy a SQL | VITA<\/title>\n<meta name=\"description\" content=\"Online kurzy Datab\u00e1zy a SQL v\u00e1s nau\u010dia SQL, MySQL, PostgreSQL, SQL Server, SELECT, JOIN, GROUP BY, poddopyty, import, export a spr\u00e1vu datab\u00e1z. \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\/databazy-a-sql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Datab\u00e1zy a SQL arch\u00edvy\" \/>\n<meta property=\"og:description\" content=\"Online kurzy Datab\u00e1zy a SQL v\u00e1s nau\u010dia SQL, MySQL, PostgreSQL, SQL Server, SELECT, JOIN, GROUP BY, poddopyty, import, export a spr\u00e1vu datab\u00e1z. \u2705\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.vita.sk\/databazy-a-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\/databazy-a-sql\/\",\n\t \"url\": \"https:\/\/www.vita.sk\/databazy-a-sql\/\",\n\t \"name\": \"Datab\u00e1zy a SQL | VITA\",\n\t \"isPartOf\": {\n\t \"@id\": \"https:\/\/www.vita.sk\/#website\"\n\t },\n\t \"description\": \"Online kurzy Datab\u00e1zy a SQL v\u00e1s nau\u010dia SQL, MySQL, PostgreSQL, SQL Server, SELECT, JOIN, GROUP BY, poddopyty, import, export a spr\u00e1vu datab\u00e1z. \u2705\",\n\t \"breadcrumb\": {\n\t \"@id\": \"https:\/\/www.vita.sk\/databazy-a-sql\/#breadcrumb\"\n\t },\n\t \"inLanguage\": \"en-US\"\n\t },\n\t {\n\t \"@type\": \"BreadcrumbList\",\n\t \"@id\": \"https:\/\/www.vita.sk\/databazy-a-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\/en\/\"\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\": \"Datab\u00e1zy a 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\": \"en-US\"\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":"Datab\u00e1zy a SQL | VITA","description":"Online kurzy Datab\u00e1zy a SQL v\u00e1s nau\u010dia SQL, MySQL, PostgreSQL, SQL Server, SELECT, JOIN, GROUP BY, poddopyty, import, export a spr\u00e1vu datab\u00e1z. \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\/databazy-a-sql\/","og_locale":"en_US","og_type":"article","og_title":"Datab\u00e1zy a SQL arch\u00edvy","og_description":"Online kurzy Datab\u00e1zy a SQL v\u00e1s nau\u010dia SQL, MySQL, PostgreSQL, SQL Server, SELECT, JOIN, GROUP BY, poddopyty, import, export a spr\u00e1vu datab\u00e1z. \u2705","og_url":"https:\/\/www.vita.sk\/databazy-a-sql\/","og_site_name":"VITA","twitter_card":"summary_large_image","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"CollectionPage","@id":"https:\/\/www.vita.sk\/databazy-a-sql\/","url":"https:\/\/www.vita.sk\/databazy-a-sql\/","name":"Datab\u00e1zy a SQL | VITA","isPartOf":{"@id":"https:\/\/www.vita.sk\/#website"},"description":"Online kurzy Datab\u00e1zy a SQL v\u00e1s nau\u010dia SQL, MySQL, PostgreSQL, SQL Server, SELECT, JOIN, GROUP BY, poddopyty, import, export a spr\u00e1vu datab\u00e1z. \u2705","breadcrumb":{"@id":"https:\/\/www.vita.sk\/databazy-a-sql\/#breadcrumb"},"inLanguage":"en-US"},{"@type":"BreadcrumbList","@id":"https:\/\/www.vita.sk\/databazy-a-sql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"VITA Academy","item":"https:\/\/www.vita.sk\/en\/"},{"@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":"Datab\u00e1zy a 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":"en-US"},{"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\/en\/wp-json\/wp\/v2\/product_cat\/504","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.vita.sk\/en\/wp-json\/wp\/v2\/product_cat"}],"about":[{"href":"https:\/\/www.vita.sk\/en\/wp-json\/wp\/v2\/taxonomies\/product_cat"}],"up":[{"embeddable":true,"href":"https:\/\/www.vita.sk\/en\/wp-json\/wp\/v2\/product_cat\/49"}],"wp:post_type":[{"href":"https:\/\/www.vita.sk\/en\/wp-json\/wp\/v2\/product?product_cat=504"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}