{"id":7813,"date":"2021-10-12T14:30:29","date_gmt":"2021-10-12T12:30:29","guid":{"rendered":"https:\/\/www.vita.sk\/?post_type=product&#038;p=7813"},"modified":"2026-09-10T12:54:09","modified_gmt":"2026-09-10T10:54:09","slug":"online-kurz-postgresql-iv-optimalizacia-dopytov","status":"publish","type":"product","link":"https:\/\/www.vita.sk\/cs\/online-kurz-postgresql-iv-optimalizacia-dopytov\/","title":{"rendered":"Online kurz PostgreSQL IV. Optimaliz\u00e1cia dopytov"},"content":{"rendered":"<p>Online kurz PostgreSQL IV. Optimaliz\u00e1cia dopytov je pre v\u00e1s ide\u00e1lny, ak sa chcete nau\u010di\u0165 optimalizova\u0165 SQL dopyty, analyzova\u0165 v\u00fdkon datab\u00e1zy PostgreSQL, efekt\u00edvne pou\u017e\u00edva\u0165 indexy a oper\u00e1cie JOIN a pracova\u0165 s n\u00e1strojmi EXPLAIN, Query Planner, VACUUM a pgBadger. <strong>Ide o certifikovan\u00fd online kurz na PostgreSQL IV<\/strong>. Z\u00edskate preh\u013ead o pokro\u010dil\u00fdch princ\u00edpoch optimaliz\u00e1cie PostgreSQL datab\u00e1z, spracovan\u00ed SQL dopytov, vyhodnocovan\u00ed ich v\u00fdkonnosti a mo\u017enostiach zni\u017eovania \u010dasu a syst\u00e9mov\u00fdch n\u00e1rokov potrebn\u00fdch na z\u00edskavanie a spracovanie d\u00e1t. Obozn\u00e1mite sa s EDB PostgreSQL a n\u00e1strojom EverSQL a pochop\u00edte systematick\u00fd postup pri identifikovan\u00ed problematick\u00fdch SQL dopytov a h\u013eadan\u00ed mo\u017enost\u00ed ich optimaliz\u00e1cie. Nau\u010d\u00edte sa posudzova\u0165 \u0161trukt\u00faru dopytov, pracova\u0165 s odpor\u00fa\u010daniami pre optimaliz\u00e1ciu a vyhodnocova\u0165 faktory, ktor\u00e9 ovplyv\u0148uj\u00fa r\u00fdchlos\u0165 vykon\u00e1vania datab\u00e1zov\u00fdch oper\u00e1ci\u00ed. Preh\u013abite si znalosti o limitoch PostgreSQL, podporovan\u00fdch d\u00e1tov\u00fdch typoch, d\u00e1tov\u00fdch poliach, znakoch a textov\u00fdch re\u0165azcoch. Obozn\u00e1mite sa s technikou TOAST a pochop\u00edte sp\u00f4sob, ak\u00fdm PostgreSQL pracuje s rozsiahlymi hodnotami, ktor\u00e9 nie je mo\u017en\u00e9 efekt\u00edvne ulo\u017ei\u0165 priamo do \u0161tandardn\u00e9ho datab\u00e1zov\u00e9ho riadka. Z\u00edskate vedomosti o pou\u017e\u00edvan\u00ed oper\u00e1torov a o \u00fadr\u017ebe datab\u00e1zy pomocou VACUUM, ktor\u00e1 zohr\u00e1va v\u00fdznamn\u00fa \u00falohu pri spr\u00e1ve neaktu\u00e1lnych verzi\u00ed riadkov, vyu\u017e\u00edvan\u00ed \u00falo\u017en\u00e9ho priestoru a udr\u017eiavan\u00ed v\u00fdkonnosti datab\u00e1zy. Pochop\u00edte fungovanie Query Planner a v\u00fdznam hodnoty Cost pri porovn\u00e1van\u00ed jednotliv\u00fdch pl\u00e1nov vykonania SQL dopytu. Nau\u010d\u00edte sa pou\u017e\u00edva\u0165 pr\u00edkaz EXPLAIN na anal\u00fdzu pl\u00e1nov vykonania a interpretova\u0165 inform\u00e1cie, ktor\u00e9 PostgreSQL poskytuje o predpokladanej n\u00e1ro\u010dnosti jednotliv\u00fdch datab\u00e1zov\u00fdch oper\u00e1ci\u00ed. Obozn\u00e1mite sa so Sequential Scan a Index Scan a pochop\u00edte, v ak\u00fdch situ\u00e1ci\u00e1ch datab\u00e1zov\u00fd syst\u00e9m vol\u00ed sekven\u010dn\u00e9 skenovanie tabu\u013eky a kedy m\u00f4\u017ee efekt\u00edvnej\u0161ie vyu\u017ei\u0165 index. Budete vedie\u0165 porovn\u00e1va\u0165 jednotliv\u00e9 strat\u00e9gie pr\u00edstupu k d\u00e1tam a identifikova\u0165 situ\u00e1cie, v ktor\u00fdch m\u00f4\u017ee vhodne vytvoren\u00fd index v\u00fdrazne zlep\u0161i\u0165 v\u00fdkon SQL dopytu. Po absolvovan\u00ed kurzu budete schopn\u00ed analyzova\u0165 a optimalizova\u0165 SQL dopyty v PostgreSQL, pracova\u0165 s indexmi a oper\u00e1ciami JOIN, pou\u017e\u00edva\u0165 EXPLAIN a interpretova\u0165 Sequential Scan, Index Scan, Bitmap Index Scan a Bitmap Heap Scan, vyhodnocova\u0165 Query Planner a Cost a identifikova\u0165 v\u00fdkonnostn\u00e9 probl\u00e9my datab\u00e1zov\u00fdch oper\u00e1ci\u00ed. Ak sa chcete skuto\u010dne nau\u010di\u0165 optimalizova\u0165 SQL dopyty, analyzova\u0165 vykon\u00e1vacie pl\u00e1ny a systematicky zvy\u0161ova\u0165 v\u00fdkon PostgreSQL datab\u00e1z a sta\u0165 sa PostgreSQL datab\u00e1zov\u00fdm administr\u00e1torom alebo \u0161pecialistom na optimaliz\u00e1ciu datab\u00e1z, tak toto je ide\u00e1lny online kurz pre v\u00e1s.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Online kurz PostgreSQL IV. Optimaliz\u00e1cia dopytov v\u00e1s nau\u010d\u00ed optimalizova\u0165 SQL dopyty, pou\u017e\u00edva\u0165 indexy, EXPLAIN, Query Planner, VACUUM a pgBadger a analyzova\u0165, monitorova\u0165 a zvy\u0161ova\u0165 v\u00fdkon PostgreSQL datab\u00e1z.","protected":false},"author":27,"featured_media":4220,"comment_status":"open","ping_status":"closed","template":"","meta":{"_acf_changed":false},"product_brand":[],"product_cat":[54,49,73],"product_tag":[188,207],"class_list":{"0":"post-7813","1":"product","2":"type-product","3":"status-publish","4":"has-post-thumbnail","6":"product_cat-online-kurzy-postgresql","7":"product_cat-online-kurzy-databazy-statistika-analytika","8":"product_cat-bez-kategorie","9":"product_tag-databazy-a-analytika","10":"product_tag-postgresql","12":"first","13":"instock","14":"sale","15":"sold-individually","16":"taxable","17":"shipping-taxable","18":"purchasable","19":"product-type-simple"},"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>Online kurz PostgreSQL IV. Optimaliz\u00e1cia dopytov 2026 | VITA<\/title>\n<meta name=\"description\" content=\"Na online kurze PostgreSQL IV. Optimaliz\u00e1cia dopytov sa zozn\u00e1mite s problematikou tvorby optim\u00e1lnych dopytov a pou\u017e\u00edva\u0165 indexy. \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-kurz-postgresql-iv-optimalizacia-dopytov\/\" \/>\n<meta property=\"og:locale\" content=\"cs_CZ\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Online kurz PostgreSQL IV. Optimaliz\u00e1cia dopytov\" \/>\n<meta property=\"og:description\" content=\"Na online kurze PostgreSQL IV. Optimaliz\u00e1cia dopytov sa zozn\u00e1mite s problematikou tvorby optim\u00e1lnych dopytov a pou\u017e\u00edva\u0165 indexy. \u2705\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.vita.sk\/online-kurz-postgresql-iv-optimalizacia-dopytov\/\" \/>\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=\"2026-09-10T10:54:09+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.vita.sk\/wp-content\/uploads\/2020\/11\/kurz-postgre-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=\"3 minuty\" \/>\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-postgresql-iv-optimalizacia-dopytov\/\",\n\t            \"url\": \"https:\/\/www.vita.sk\/online-kurz-postgresql-iv-optimalizacia-dopytov\/\",\n\t            \"name\": \"Online kurz PostgreSQL IV. Optimaliz\u00e1cia dopytov {Y} | 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-postgresql-iv-optimalizacia-dopytov\/#primaryimage\"\n\t            },\n\t            \"image\": {\n\t                \"@id\": \"https:\/\/www.vita.sk\/online-kurz-postgresql-iv-optimalizacia-dopytov\/#primaryimage\"\n\t            },\n\t            \"thumbnailUrl\": \"https:\/\/www.vita.sk\/wp-content\/uploads\/2020\/11\/kurz-postgre-sql.png\",\n\t            \"datePublished\": \"2021-10-12T12:30:29+00:00\",\n\t            \"dateModified\": \"2026-09-10T10:54:09+00:00\",\n\t            \"description\": \"Na online kurze PostgreSQL IV. Optimaliz\u00e1cia dopytov sa zozn\u00e1mite s problematikou tvorby optim\u00e1lnych dopytov a pou\u017e\u00edva\u0165 indexy. \u2705\",\n\t            \"breadcrumb\": {\n\t                \"@id\": \"https:\/\/www.vita.sk\/online-kurz-postgresql-iv-optimalizacia-dopytov\/#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-postgresql-iv-optimalizacia-dopytov\/\"\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-postgresql-iv-optimalizacia-dopytov\/#primaryimage\",\n\t            \"url\": \"https:\/\/www.vita.sk\/wp-content\/uploads\/2020\/11\/kurz-postgre-sql.png\",\n\t            \"contentUrl\": \"https:\/\/www.vita.sk\/wp-content\/uploads\/2020\/11\/kurz-postgre-sql.png\",\n\t            \"width\": 360,\n\t            \"height\": 360,\n\t            \"caption\": \"Online kurz PostgreSQL\"\n\t        },\n\t        {\n\t            \"@type\": \"BreadcrumbList\",\n\t            \"@id\": \"https:\/\/www.vita.sk\/online-kurz-postgresql-iv-optimalizacia-dopytov\/#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\": \"PostgreSQL\",\n\t                    \"item\": \"https:\/\/www.vita.sk\/online-kurzy-postgresql\/\"\n\t                },\n\t                {\n\t                    \"@type\": \"ListItem\",\n\t                    \"position\": 5,\n\t                    \"name\": \"Online kurz PostgreSQL IV. Optimaliz\u00e1cia dopytov\"\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 PostgreSQL IV. Optimaliz\u00e1cia dopytov 2026 | VITA","description":"Na online kurze PostgreSQL IV. Optimaliz\u00e1cia dopytov sa zozn\u00e1mite s problematikou tvorby optim\u00e1lnych dopytov a pou\u017e\u00edva\u0165 indexy. \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-kurz-postgresql-iv-optimalizacia-dopytov\/","og_locale":"cs_CZ","og_type":"article","og_title":"Online kurz PostgreSQL IV. Optimaliz\u00e1cia dopytov","og_description":"Na online kurze PostgreSQL IV. Optimaliz\u00e1cia dopytov sa zozn\u00e1mite s problematikou tvorby optim\u00e1lnych dopytov a pou\u017e\u00edva\u0165 indexy. \u2705","og_url":"https:\/\/www.vita.sk\/online-kurz-postgresql-iv-optimalizacia-dopytov\/","og_site_name":"VITA","article_publisher":"https:\/\/www.facebook.com\/VitaAcademySK","article_modified_time":"2026-09-10T10:54:09+00:00","og_image":[{"width":360,"height":360,"url":"https:\/\/www.vita.sk\/wp-content\/uploads\/2020\/11\/kurz-postgre-sql.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_misc":{"Odhadovan\u00e1 doba \u010dten\u00ed":"3 minuty"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.vita.sk\/online-kurz-postgresql-iv-optimalizacia-dopytov\/","url":"https:\/\/www.vita.sk\/online-kurz-postgresql-iv-optimalizacia-dopytov\/","name":"Online kurz PostgreSQL IV. Optimaliz\u00e1cia dopytov {Y} | VITA","isPartOf":{"@id":"https:\/\/www.vita.sk\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.vita.sk\/online-kurz-postgresql-iv-optimalizacia-dopytov\/#primaryimage"},"image":{"@id":"https:\/\/www.vita.sk\/online-kurz-postgresql-iv-optimalizacia-dopytov\/#primaryimage"},"thumbnailUrl":"https:\/\/www.vita.sk\/wp-content\/uploads\/2020\/11\/kurz-postgre-sql.png","datePublished":"2021-10-12T12:30:29+00:00","dateModified":"2026-09-10T10:54:09+00:00","description":"Na online kurze PostgreSQL IV. Optimaliz\u00e1cia dopytov sa zozn\u00e1mite s problematikou tvorby optim\u00e1lnych dopytov a pou\u017e\u00edva\u0165 indexy. \u2705","breadcrumb":{"@id":"https:\/\/www.vita.sk\/online-kurz-postgresql-iv-optimalizacia-dopytov\/#breadcrumb"},"inLanguage":"cs","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.vita.sk\/online-kurz-postgresql-iv-optimalizacia-dopytov\/"]}]},{"@type":"ImageObject","inLanguage":"cs","@id":"https:\/\/www.vita.sk\/online-kurz-postgresql-iv-optimalizacia-dopytov\/#primaryimage","url":"https:\/\/www.vita.sk\/wp-content\/uploads\/2020\/11\/kurz-postgre-sql.png","contentUrl":"https:\/\/www.vita.sk\/wp-content\/uploads\/2020\/11\/kurz-postgre-sql.png","width":360,"height":360,"caption":"Online kurz PostgreSQL"},{"@type":"BreadcrumbList","@id":"https:\/\/www.vita.sk\/online-kurz-postgresql-iv-optimalizacia-dopytov\/#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":"PostgreSQL","item":"https:\/\/www.vita.sk\/online-kurzy-postgresql\/"},{"@type":"ListItem","position":5,"name":"Online kurz PostgreSQL IV. Optimaliz\u00e1cia dopytov"}]},{"@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\/7813","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=7813"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.vita.sk\/cs\/wp-json\/wp\/v2\/media\/4220"}],"wp:attachment":[{"href":"https:\/\/www.vita.sk\/cs\/wp-json\/wp\/v2\/media?parent=7813"}],"wp:term":[{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/www.vita.sk\/cs\/wp-json\/wp\/v2\/product_brand?post=7813"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/www.vita.sk\/cs\/wp-json\/wp\/v2\/product_cat?post=7813"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/www.vita.sk\/cs\/wp-json\/wp\/v2\/product_tag?post=7813"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}