{"id":54,"count":5,"description":"Online kurzy PostgreSQL s\u00fa zameran\u00e9 na objektovo-rela\u010dn\u00fd datab\u00e1zov\u00fd syst\u00e9m PostgreSQL, jazyk SQL, in\u0161tal\u00e1ciu a konfigur\u00e1ciu datab\u00e1zov\u00e9ho servera, spr\u00e1vu datab\u00e1z, SQL dopyty, indexy, z\u00e1lohovanie, d\u00e1tov\u00e9 typy, datab\u00e1zov\u00e9 sch\u00e9my, monitoring a optimaliz\u00e1ciu v\u00fdkonu. V PostgreSQL I. Za\u010diato\u010dn\u00edk<\/a><\/strong> sa nau\u010d\u00edte pracova\u0165 s DBMS (Database Management System), in\u0161talova\u0165 PostgreSQL na Microsoft Windows a Linux Ubuntu a pou\u017e\u00edva\u0165 n\u00e1stroje pgAdmin a DBeaver. Osvoj\u00edte si tvorbu datab\u00e1z, tabuliek a sch\u00e9m, pr\u00e1cu s pr\u00edkazov\u00fdm riadkom a psql, SQL dopyty, d\u00e1tov\u00e9 typy, funkcie, regul\u00e1rne v\u00fdrazy, logick\u00e9 oper\u00e1tory, INSERT INTO, z\u00e1lohovanie a obnovu datab\u00e1z. PostgreSQL II. Mierne Pokro\u010dil\u00fd<\/a><\/strong> rozv\u00edja pr\u00e1cu s d\u00e1tov\u00fdmi typmi a konverziami, normaliz\u00e1ciou, indexmi, r\u00f4znymi typmi JOIN oper\u00e1ci\u00ed, datab\u00e1zov\u00fdmi rel\u00e1ciami, sch\u00e9mami a do\u010dasn\u00fdmi tabu\u013ekami. Nau\u010d\u00edte sa analyzova\u0165 dopyty, pou\u017e\u00edva\u0165 EXPLAIN, pracova\u0165 s pou\u017e\u00edvate\u013emi a opr\u00e1vneniami pomocou Grant Wizard a monitorova\u0165 datab\u00e1zu pomocou n\u00e1stroja pgBadger. V PostgreSQL III. Pokro\u010dil\u00fd<\/a><\/strong> sa zameriate na PL\/pgSQL, proced\u00fary, bin\u00e1rne objekty, indexovanie, Query Planner, EXPLAIN, sekven\u010dn\u00e9 a indexov\u00e9 skenovanie, n\u00e1klady dopytov, datab\u00e1zov\u00e9 \u0161tatistiky, buffer, rel\u00e1cie a VACUUM. PostgreSQL IV. Optimaliz\u00e1cia dopytov<\/a><\/strong> v\u00e1s nau\u010d\u00ed monitorova\u0165 a optimalizova\u0165 n\u00e1ro\u010dn\u00e9 SQL dopyty, pracova\u0165 s indexmi, Query Plannerom, EXPLAIN, Bitmap Index Scan, Bitmap Heap Scan, \u0161tatistikami, logmi, TOAST, VACUUM, JSON a n\u00e1strojmi pgAdmin, pgBadger a EverSQL. Ponuku dop\u013a\u0148a Jazyk SQL \u2013 MySQL, PostgreSQL, Microsoft SQL Server<\/a><\/strong>, v ktorom sa nau\u010d\u00edte SELECT, BETWEEN, LIKE, agrega\u010dn\u00e9 funkcie, GROUP BY, HAVING, vnoren\u00e9 dopyty, JOIN, UNION a \u010fal\u0161ie \u0161tandardn\u00e9 SQL oper\u00e1cie naprie\u010d viacer\u00fdmi datab\u00e1zov\u00fdmi syst\u00e9mami. Online kurzy PostgreSQL rozv\u00edjaj\u00fa praktick\u00e9 zru\u010dnosti vyu\u017eite\u013en\u00e9 pre datab\u00e1zov\u00fdch administr\u00e1torov a analytikov, SQL \u0161pecialistov, d\u00e1tov\u00fdch analytikov a vedcov, backend a fullstack developerov, program\u00e1torov, BI developerov a \u010fal\u0161\u00edch IT odborn\u00edkov pracuj\u00facich s rela\u010dn\u00fdmi datab\u00e1zami.","link":"https:\/\/www.vita.sk\/cs\/online-kurzy-postgresql\/","name":"PostgreSQL","slug":"online-kurzy-postgresql","taxonomy":"product_cat","parent":49,"meta":[],"yoast_head":"\nPostgreSQL | VITA<\/title>\n<meta name=\"description\" content=\"Online kurzy PostgreSQL v\u00e1s nau\u010dia SQL, pgAdmin, DBeaver, JOIN, indexy, PL\/pgSQL, EXPLAIN, VACUUM, z\u00e1lohovanie a optimaliz\u00e1ciu 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-postgresql\/\" \/>\n<meta property=\"og:locale\" content=\"cs_CZ\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"PostgreSQL arch\u00edvy\" \/>\n<meta property=\"og:description\" content=\"Online kurzy PostgreSQL v\u00e1s nau\u010dia SQL, pgAdmin, DBeaver, JOIN, indexy, PL\/pgSQL, EXPLAIN, VACUUM, z\u00e1lohovanie a optimaliz\u00e1ciu dopytov. \u2705\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.vita.sk\/online-kurzy-postgresql\/\" \/>\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-postgresql\/\",\n\t \"url\": \"https:\/\/www.vita.sk\/online-kurzy-postgresql\/\",\n\t \"name\": \"PostgreSQL | VITA\",\n\t \"isPartOf\": {\n\t \"@id\": \"https:\/\/www.vita.sk\/#website\"\n\t },\n\t \"description\": \"Online kurzy PostgreSQL v\u00e1s nau\u010dia SQL, pgAdmin, DBeaver, JOIN, indexy, PL\/pgSQL, EXPLAIN, VACUUM, z\u00e1lohovanie a optimaliz\u00e1ciu dopytov. \u2705\",\n\t \"breadcrumb\": {\n\t \"@id\": \"https:\/\/www.vita.sk\/online-kurzy-postgresql\/#breadcrumb\"\n\t },\n\t \"inLanguage\": \"cs\"\n\t },\n\t {\n\t \"@type\": \"BreadcrumbList\",\n\t \"@id\": \"https:\/\/www.vita.sk\/online-kurzy-postgresql\/#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 }\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":"PostgreSQL | VITA","description":"Online kurzy PostgreSQL v\u00e1s nau\u010dia SQL, pgAdmin, DBeaver, JOIN, indexy, PL\/pgSQL, EXPLAIN, VACUUM, z\u00e1lohovanie a optimaliz\u00e1ciu 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-postgresql\/","og_locale":"cs_CZ","og_type":"article","og_title":"PostgreSQL arch\u00edvy","og_description":"Online kurzy PostgreSQL v\u00e1s nau\u010dia SQL, pgAdmin, DBeaver, JOIN, indexy, PL\/pgSQL, EXPLAIN, VACUUM, z\u00e1lohovanie a optimaliz\u00e1ciu dopytov. \u2705","og_url":"https:\/\/www.vita.sk\/online-kurzy-postgresql\/","og_site_name":"VITA","twitter_card":"summary_large_image","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"CollectionPage","@id":"https:\/\/www.vita.sk\/online-kurzy-postgresql\/","url":"https:\/\/www.vita.sk\/online-kurzy-postgresql\/","name":"PostgreSQL | VITA","isPartOf":{"@id":"https:\/\/www.vita.sk\/#website"},"description":"Online kurzy PostgreSQL v\u00e1s nau\u010dia SQL, pgAdmin, DBeaver, JOIN, indexy, PL\/pgSQL, EXPLAIN, VACUUM, z\u00e1lohovanie a optimaliz\u00e1ciu dopytov. \u2705","breadcrumb":{"@id":"https:\/\/www.vita.sk\/online-kurzy-postgresql\/#breadcrumb"},"inLanguage":"cs"},{"@type":"BreadcrumbList","@id":"https:\/\/www.vita.sk\/online-kurzy-postgresql\/#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"}]},{"@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\/54","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=54"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}