{"id":7948,"date":"2021-11-22T12:16:21","date_gmt":"2021-11-22T11:16:21","guid":{"rendered":"https:\/\/www.vita.sk\/?post_type=product&p=7948"},"modified":"2024-05-23T10:54:55","modified_gmt":"2024-05-23T08:54:55","slug":"online-kurz-optimalizacia-sql-dopytov-pre-sqlite-mysql-postgresql-microsoft-sql-server","status":"publish","type":"product","link":"https:\/\/www.vita.sk\/cs\/online-kurz-optimalizacia-sql-dopytov-pre-sqlite-mysql-postgresql-microsoft-sql-server\/","title":{"rendered":"Online kurz Optimaliz\u00e1cia SQL Dopytov pre SQLite, MySQL, PostgreSQL, Microsoft SQL Server"},"content":{"rendered":"

Online kurz Optimaliz\u00e1cia SQL Dopytov pre SQLite, MySQL, PostgreSQL, Microsoft SQL Server je pre v\u00e1s ide\u00e1lny ak sa chcete nau\u010di\u0165, optimalizova\u0165 SQL dopyty naprie\u010d r\u00f4znymi datab\u00e1zov\u00fdmi syst\u00e9mami. Osvoj\u00edte si \u0161trukt\u00faru SQL dopytov, pr\u00edkazy a oper\u00e1cie s d\u00e1tami ako vyh\u013ead\u00e1vanie, generovanie zost\u00e1v a vytv\u00e1ranie anal\u00fdz. Nau\u010d\u00edte sa sa pracova\u0165 s r\u00f4znymi datab\u00e1zov\u00fdmi syst\u00e9mami ako MySQL a PostgreSQL a SQLite. Budete vedie\u0165 vytv\u00e1ra\u0165 a pou\u017e\u00edva\u0165 vlastn\u00e9 funkcie a importova\u0165 d\u00e1ta do datab\u00e1z. Pochop\u00edte, ako zobrazova\u0165 a pou\u017e\u00edva\u0165 indexy pre optimaliz\u00e1ciu v\u00fdkonu. Uk\u00e1\u017eeme si ako analyzova\u0165 SQL Server query statistics. Pochop\u00edte ak\u00e9 m\u00f4\u017ee by\u0165 n\u00e1klady na dopyty a nau\u010d\u00edte sa pracova\u0165 s n\u00e1strojom SQL Fiddle pre testovanie a ladenie dopytov. Ak sa chcete skuto\u010dne nau\u010di\u0165 pou\u017e\u00edva\u0165 Optimaliz\u00e1cia SQL Dopytov, tak toto je ide\u00e1lny online kurz pre v\u00e1s.<\/p>\n","protected":false},"excerpt":{"rendered":"

Online kurz Optimaliz\u00e1cia SQL Dopytov pre SQLite, MySQL, PostgreSQL, Microsoft SQL Server je pre v\u00e1s ide\u00e1lny ak sa chcete nau\u010di\u0165, optimalizova\u0165 SQL dopyty naprie\u010d r\u00f4znymi datab\u00e1zov\u00fdmi syst\u00e9mami. Osvoj\u00edte si \u0161trukt\u00faru SQL dopytov, pr\u00edkazy a oper\u00e1cie s d\u00e1tami ako vyh\u013ead\u00e1vanie, generovanie zost\u00e1v a vytv\u00e1ranie anal\u00fdz.","protected":false},"author":27,"featured_media":4265,"comment_status":"open","ping_status":"closed","template":"","meta":{"_acf_changed":false},"product_brand":[],"product_cat":[55,49,73],"product_tag":[188,347],"class_list":{"0":"post-7948","1":"product","2":"type-product","3":"status-publish","4":"has-post-thumbnail","6":"product_cat-online-kurzy-sql","7":"product_cat-online-kurzy-databazy-statistika-analytika","8":"product_cat-bez-kategorie","9":"product_tag-databazy-a-analytika","10":"product_tag-sql","12":"first","13":"instock","14":"sale","15":"sold-individually","16":"taxable","17":"shipping-taxable","18":"purchasable","19":"product-type-simple"},"yoast_head":"\nOnline kurz Optimaliz\u00e1cia SQL Dopytov pre SQLite, MySQL, PostgreSQL, Microsoft SQL Server | VITA<\/title>\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-kurz-optimalizacia-sql-dopytov-pre-sqlite-mysql-postgresql-microsoft-sql-server\/\" \/>\n<meta property=\"og:locale\" content=\"cs_CZ\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Online kurz Optimaliz\u00e1cia SQL Dopytov pre SQLite, MySQL, PostgreSQL, Microsoft SQL Server\" \/>\n<meta property=\"og:description\" content=\"Online kurz Optimaliz\u00e1cia SQL Dopytov pre SQLite, MySQL, PostgreSQL, Microsoft SQL Server je pre v\u00e1s ide\u00e1lny ak sa chcete nau\u010di\u0165, optimalizova\u0165 SQL dopyty naprie\u010d r\u00f4znymi datab\u00e1zov\u00fdmi syst\u00e9mami. Osvoj\u00edte si \u0161trukt\u00faru SQL dopytov, pr\u00edkazy a oper\u00e1cie s d\u00e1tami ako vyh\u013ead\u00e1vanie, generovanie zost\u00e1v a vytv\u00e1ranie anal\u00fdz. Nau\u010d\u00edte sa sa pracova\u0165 s r\u00f4znymi datab\u00e1zov\u00fdmi syst\u00e9mami ako MySQL a […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.vita.sk\/online-kurz-optimalizacia-sql-dopytov-pre-sqlite-mysql-postgresql-microsoft-sql-server\/\" \/>\n<meta property=\"og:site_name\" content=\"VITA\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/VitaAcademySK\" \/>\n<meta property=\"article:modified_time\" content=\"2024-05-23T08:54:55+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.vita.sk\/wp-content\/uploads\/2020\/11\/kurz-sql.png\" \/>\n\t<meta property=\"og:image:width\" content=\"360\" \/>\n\t<meta property=\"og:image:height\" content=\"360\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Odhadovan\u00e1 doba \u010dten\u00ed\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minuta\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\n\t \"@context\": \"https:\/\/schema.org\",\n\t \"@graph\": [\n\t {\n\t \"@type\": \"WebPage\",\n\t \"@id\": \"https:\/\/www.vita.sk\/online-kurz-optimalizacia-sql-dopytov-pre-sqlite-mysql-postgresql-microsoft-sql-server\/\",\n\t \"url\": \"https:\/\/www.vita.sk\/online-kurz-optimalizacia-sql-dopytov-pre-sqlite-mysql-postgresql-microsoft-sql-server\/\",\n\t \"name\": \"Online kurz Optimaliz\u00e1cia SQL Dopytov pre SQLite, MySQL, PostgreSQL, Microsoft SQL Server 2023 | VITA\",\n\t \"isPartOf\": {\n\t \"@id\": \"https:\/\/www.vita.sk\/#website\"\n\t },\n\t \"primaryImageOfPage\": {\n\t \"@id\": \"https:\/\/www.vita.sk\/online-kurz-optimalizacia-sql-dopytov-pre-sqlite-mysql-postgresql-microsoft-sql-server\/#primaryimage\"\n\t },\n\t \"image\": {\n\t \"@id\": \"https:\/\/www.vita.sk\/online-kurz-optimalizacia-sql-dopytov-pre-sqlite-mysql-postgresql-microsoft-sql-server\/#primaryimage\"\n\t },\n\t \"thumbnailUrl\": \"https:\/\/www.vita.sk\/wp-content\/uploads\/2020\/11\/kurz-sql.png\",\n\t \"datePublished\": \"2021-11-22T11:16:21+00:00\",\n\t \"dateModified\": \"2024-05-23T08:54:55+00:00\",\n\t \"breadcrumb\": {\n\t \"@id\": \"https:\/\/www.vita.sk\/online-kurz-optimalizacia-sql-dopytov-pre-sqlite-mysql-postgresql-microsoft-sql-server\/#breadcrumb\"\n\t },\n\t \"inLanguage\": \"cs\",\n\t \"potentialAction\": [\n\t {\n\t \"@type\": \"ReadAction\",\n\t \"target\": [\n\t \"https:\/\/www.vita.sk\/online-kurz-optimalizacia-sql-dopytov-pre-sqlite-mysql-postgresql-microsoft-sql-server\/\"\n\t ]\n\t }\n\t ]\n\t },\n\t {\n\t \"@type\": \"ImageObject\",\n\t \"inLanguage\": \"cs\",\n\t \"@id\": \"https:\/\/www.vita.sk\/online-kurz-optimalizacia-sql-dopytov-pre-sqlite-mysql-postgresql-microsoft-sql-server\/#primaryimage\",\n\t \"url\": \"https:\/\/www.vita.sk\/wp-content\/uploads\/2020\/11\/kurz-sql.png\",\n\t \"contentUrl\": \"https:\/\/www.vita.sk\/wp-content\/uploads\/2020\/11\/kurz-sql.png\",\n\t \"width\": 360,\n\t \"height\": 360,\n\t \"caption\": \"Online kurz SQL\"\n\t },\n\t {\n\t \"@type\": \"BreadcrumbList\",\n\t \"@id\": \"https:\/\/www.vita.sk\/online-kurz-optimalizacia-sql-dopytov-pre-sqlite-mysql-postgresql-microsoft-sql-server\/#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-analytika\/\"\n\t },\n\t {\n\t \"@type\": \"ListItem\",\n\t \"position\": 4,\n\t \"name\": \"SQL\",\n\t \"item\": \"https:\/\/www.vita.sk\/online-kurzy-sql\/\"\n\t },\n\t {\n\t \"@type\": \"ListItem\",\n\t \"position\": 5,\n\t \"name\": \"Online kurz Optimaliz\u00e1cia SQL Dopytov pre SQLite, MySQL, PostgreSQL, Microsoft SQL Server\"\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":"Online kurz Optimaliz\u00e1cia SQL Dopytov pre SQLite, MySQL, PostgreSQL, Microsoft SQL Server | VITA","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-kurz-optimalizacia-sql-dopytov-pre-sqlite-mysql-postgresql-microsoft-sql-server\/","og_locale":"cs_CZ","og_type":"article","og_title":"Online kurz Optimaliz\u00e1cia SQL Dopytov pre SQLite, MySQL, PostgreSQL, Microsoft SQL Server","og_description":"Online kurz Optimaliz\u00e1cia SQL Dopytov pre SQLite, MySQL, PostgreSQL, Microsoft SQL Server je pre v\u00e1s ide\u00e1lny ak sa chcete nau\u010di\u0165, optimalizova\u0165 SQL dopyty naprie\u010d r\u00f4znymi datab\u00e1zov\u00fdmi syst\u00e9mami. Osvoj\u00edte si \u0161trukt\u00faru SQL dopytov, pr\u00edkazy a oper\u00e1cie s d\u00e1tami ako vyh\u013ead\u00e1vanie, generovanie zost\u00e1v a vytv\u00e1ranie anal\u00fdz. Nau\u010d\u00edte sa sa pracova\u0165 s r\u00f4znymi datab\u00e1zov\u00fdmi syst\u00e9mami ako MySQL a […]","og_url":"https:\/\/www.vita.sk\/online-kurz-optimalizacia-sql-dopytov-pre-sqlite-mysql-postgresql-microsoft-sql-server\/","og_site_name":"VITA","article_publisher":"https:\/\/www.facebook.com\/VitaAcademySK","article_modified_time":"2024-05-23T08:54:55+00:00","og_image":[{"width":360,"height":360,"url":"https:\/\/www.vita.sk\/wp-content\/uploads\/2020\/11\/kurz-sql.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_misc":{"Odhadovan\u00e1 doba \u010dten\u00ed":"1 minuta"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.vita.sk\/online-kurz-optimalizacia-sql-dopytov-pre-sqlite-mysql-postgresql-microsoft-sql-server\/","url":"https:\/\/www.vita.sk\/online-kurz-optimalizacia-sql-dopytov-pre-sqlite-mysql-postgresql-microsoft-sql-server\/","name":"Online kurz Optimaliz\u00e1cia SQL Dopytov pre SQLite, MySQL, PostgreSQL, Microsoft SQL Server 2023 | VITA","isPartOf":{"@id":"https:\/\/www.vita.sk\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.vita.sk\/online-kurz-optimalizacia-sql-dopytov-pre-sqlite-mysql-postgresql-microsoft-sql-server\/#primaryimage"},"image":{"@id":"https:\/\/www.vita.sk\/online-kurz-optimalizacia-sql-dopytov-pre-sqlite-mysql-postgresql-microsoft-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/www.vita.sk\/wp-content\/uploads\/2020\/11\/kurz-sql.png","datePublished":"2021-11-22T11:16:21+00:00","dateModified":"2024-05-23T08:54:55+00:00","breadcrumb":{"@id":"https:\/\/www.vita.sk\/online-kurz-optimalizacia-sql-dopytov-pre-sqlite-mysql-postgresql-microsoft-sql-server\/#breadcrumb"},"inLanguage":"cs","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.vita.sk\/online-kurz-optimalizacia-sql-dopytov-pre-sqlite-mysql-postgresql-microsoft-sql-server\/"]}]},{"@type":"ImageObject","inLanguage":"cs","@id":"https:\/\/www.vita.sk\/online-kurz-optimalizacia-sql-dopytov-pre-sqlite-mysql-postgresql-microsoft-sql-server\/#primaryimage","url":"https:\/\/www.vita.sk\/wp-content\/uploads\/2020\/11\/kurz-sql.png","contentUrl":"https:\/\/www.vita.sk\/wp-content\/uploads\/2020\/11\/kurz-sql.png","width":360,"height":360,"caption":"Online kurz SQL"},{"@type":"BreadcrumbList","@id":"https:\/\/www.vita.sk\/online-kurz-optimalizacia-sql-dopytov-pre-sqlite-mysql-postgresql-microsoft-sql-server\/#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-analytika\/"},{"@type":"ListItem","position":4,"name":"SQL","item":"https:\/\/www.vita.sk\/online-kurzy-sql\/"},{"@type":"ListItem","position":5,"name":"Online kurz Optimaliz\u00e1cia SQL Dopytov pre SQLite, MySQL, PostgreSQL, Microsoft SQL Server"}]},{"@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\/7948","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.vita.sk\/cs\/wp-json\/wp\/v2\/product"}],"about":[{"href":"https:\/\/www.vita.sk\/cs\/wp-json\/wp\/v2\/types\/product"}],"author":[{"embeddable":true,"href":"https:\/\/www.vita.sk\/cs\/wp-json\/wp\/v2\/users\/27"}],"replies":[{"embeddable":true,"href":"https:\/\/www.vita.sk\/cs\/wp-json\/wp\/v2\/comments?post=7948"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.vita.sk\/cs\/wp-json\/wp\/v2\/media\/4265"}],"wp:attachment":[{"href":"https:\/\/www.vita.sk\/cs\/wp-json\/wp\/v2\/media?parent=7948"}],"wp:term":[{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/www.vita.sk\/cs\/wp-json\/wp\/v2\/product_brand?post=7948"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/www.vita.sk\/cs\/wp-json\/wp\/v2\/product_cat?post=7948"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/www.vita.sk\/cs\/wp-json\/wp\/v2\/product_tag?post=7948"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}