{"id":55,"count":15,"description":"Online kurzy SQL s\u00fa zameran\u00e9 na jazyk SQL (Structured Query Language), rela\u010dn\u00e9 datab\u00e1zy, datab\u00e1zov\u00e9 syst\u00e9my DBMS a RDBMS, tvorbu a optimaliz\u00e1ciu SQL dopytov, spracovanie a anal\u00fdzu d\u00e1t, d\u00e1tov\u00e9 modelovanie, indexy, JOIN oper\u00e1cie, poddopyty a praktick\u00fa pr\u00e1cu s datab\u00e1zami MySQL, PostgreSQL, Microsoft SQL Server a SQLite. V Jazyk SQL I. Za\u010diato\u010dn\u00edk<\/a><\/strong> sa nau\u010d\u00edte princ\u00edpy datab\u00e1z, pripojenie pomocou DBeaver, syntax SQL, pr\u00edkaz SELECT, agrega\u010dn\u00e9 funkcie, GROUP BY, oper\u00e1tory IN a BETWEEN, vypo\u010d\u00edtavan\u00e9 polia, SQL funkcie, pr\u00e1cu s MySQL a n\u00e1strojom phpMyAdmin. SQL I. Za\u010diato\u010dn\u00edk<\/a><\/strong> rozv\u00edja pr\u00e1cu s DBMS a RDBMS, datab\u00e1zami MySQL, PostgreSQL a SQLite, pr\u00edkazmi SELECT, WHERE, BETWEEN, IN, LIMIT a ORDER BY, agrega\u010dn\u00fdmi funkciami SUM, COUNT a AVG, GROUP BY, HAVING, regul\u00e1rnymi v\u00fdrazmi, hodnotami NULL a oper\u00e1ciami INSERT a UPDATE. V SQL II. Mierne Pokro\u010dil\u00fd<\/a><\/strong> sa nau\u010d\u00edte pou\u017e\u00edva\u0165 vnoren\u00e9 dopyty a SubQueries, INNER JOIN, LEFT JOIN a RIGHT JOIN, prim\u00e1rne a cudzie k\u013e\u00fa\u010de, indexy, d\u00e1tov\u00e9 typy, ERD (Entity Relationship Diagram), SQL funkcie a techniky ochrany pred SQL Injection. SQL III. Pokro\u010dil\u00fd<\/a><\/strong> nadv\u00e4zuje pokro\u010dilou pr\u00e1cou s datab\u00e1zami a komplexnej\u0161\u00edmi SQL oper\u00e1ciami. Pre d\u00e1tov\u00fdch analytikov a vedcov je ur\u010den\u00fd Jazyk SQL pre Analytikov a D\u00e1tov\u00fdch Vedcov<\/a><\/strong>, ktor\u00fd sa venuje filtrovaniu a agreg\u00e1cii d\u00e1t, funkci\u00e1m LIKE, BETWEEN a COALESCE, sekvenci\u00e1m, ER diagramom, JOIN oper\u00e1ci\u00e1m a importu a exportu \u00fadajov. V Jazyk SQL \u2013 MySQL, PostgreSQL, Microsoft SQL Server<\/a><\/strong> si osvoj\u00edte prenosite\u013en\u00e9 znalosti SQL naprie\u010d viacer\u00fdmi v\u00fdznamn\u00fdmi rela\u010dn\u00fdmi datab\u00e1zov\u00fdmi syst\u00e9mami. Pokro\u010dil\u00e9 kurzy Optimaliz\u00e1cia SQL Dopytov<\/a><\/strong> a Optimaliz\u00e1cia SQL Dopytov pre SQLite, MySQL, PostgreSQL, Microsoft SQL Server<\/a><\/strong> v\u00e1s nau\u010dia pracova\u0165 s indexmi, mera\u0165 v\u00fdkon datab\u00e1z, analyzova\u0165 n\u00e1klady dopytov, optimalizova\u0165 datab\u00e1zov\u00fd n\u00e1vrh a identifikova\u0165 pomal\u00e9 SQL dopyty. Ponuku dop\u013a\u0148aj\u00fa \u0161pecializovan\u00e9 kurzy SQL pre Microsoft SQL Server, MySQL a SQLite. Online kurzy SQL rozv\u00edjaj\u00fa praktick\u00e9 zru\u010dnosti vyu\u017eite\u013en\u00e9 pre datab\u00e1zov\u00fdch administr\u00e1torov a analytikov, d\u00e1tov\u00fdch a business analytikov, d\u00e1tov\u00fdch vedcov, SQL \u0161pecialistov, BI developerov, backend a fullstack program\u00e1torov, testerov a \u010fal\u0161\u00edch IT odborn\u00edkov pracuj\u00facich s d\u00e1tami.","link":"https:\/\/www.vita.sk\/cs\/online-kurzy-sql\/","name":"SQL","slug":"online-kurzy-sql","taxonomy":"product_cat","parent":49,"meta":[],"yoast_head":"\nSQL | VITA<\/title>\n<meta name=\"description\" content=\"Online kurzy SQL v\u00e1s nau\u010dia SELECT, JOIN, GROUP BY, poddopyty, indexy, MySQL, PostgreSQL, SQL Server, SQLite a optimaliz\u00e1ciu SQL dopytov. \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-sql\/\" \/>\n<meta property=\"og:locale\" content=\"cs_CZ\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL arch\u00edvy\" \/>\n<meta property=\"og:description\" content=\"Online kurzy SQL v\u00e1s nau\u010dia SELECT, JOIN, GROUP BY, poddopyty, indexy, MySQL, PostgreSQL, SQL Server, SQLite a optimaliz\u00e1ciu SQL dopytov. \u2705\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.vita.sk\/online-kurzy-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\/online-kurzy-sql\/\",\n\t \"url\": \"https:\/\/www.vita.sk\/online-kurzy-sql\/\",\n\t \"name\": \"SQL | VITA\",\n\t \"isPartOf\": {\n\t \"@id\": \"https:\/\/www.vita.sk\/#website\"\n\t },\n\t \"description\": \"Online kurzy SQL v\u00e1s nau\u010dia SELECT, JOIN, GROUP BY, poddopyty, indexy, MySQL, PostgreSQL, SQL Server, SQLite a optimaliz\u00e1ciu SQL dopytov. \u2705\",\n\t \"breadcrumb\": {\n\t \"@id\": \"https:\/\/www.vita.sk\/online-kurzy-sql\/#breadcrumb\"\n\t },\n\t \"inLanguage\": \"cs\"\n\t },\n\t {\n\t \"@type\": \"BreadcrumbList\",\n\t \"@id\": \"https:\/\/www.vita.sk\/online-kurzy-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\": \"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":"SQL | VITA","description":"Online kurzy SQL v\u00e1s nau\u010dia SELECT, JOIN, GROUP BY, poddopyty, indexy, MySQL, PostgreSQL, SQL Server, SQLite a optimaliz\u00e1ciu SQL dopytov. \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-sql\/","og_locale":"cs_CZ","og_type":"article","og_title":"SQL arch\u00edvy","og_description":"Online kurzy SQL v\u00e1s nau\u010dia SELECT, JOIN, GROUP BY, poddopyty, indexy, MySQL, PostgreSQL, SQL Server, SQLite a optimaliz\u00e1ciu SQL dopytov. \u2705","og_url":"https:\/\/www.vita.sk\/online-kurzy-sql\/","og_site_name":"VITA","twitter_card":"summary_large_image","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"CollectionPage","@id":"https:\/\/www.vita.sk\/online-kurzy-sql\/","url":"https:\/\/www.vita.sk\/online-kurzy-sql\/","name":"SQL | VITA","isPartOf":{"@id":"https:\/\/www.vita.sk\/#website"},"description":"Online kurzy SQL v\u00e1s nau\u010dia SELECT, JOIN, GROUP BY, poddopyty, indexy, MySQL, PostgreSQL, SQL Server, SQLite a optimaliz\u00e1ciu SQL dopytov. \u2705","breadcrumb":{"@id":"https:\/\/www.vita.sk\/online-kurzy-sql\/#breadcrumb"},"inLanguage":"cs"},{"@type":"BreadcrumbList","@id":"https:\/\/www.vita.sk\/online-kurzy-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":"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\/55","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=55"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}