{"id":52,"count":4,"description":"Online kurzy Microsoft SQL Server s\u00fa zameran\u00e9 na rela\u010dn\u00fd datab\u00e1zov\u00fd syst\u00e9m Microsoft SQL Server, jazyk SQL, spr\u00e1vu datab\u00e1z, datab\u00e1zov\u00e9 objekty, SQL dopyty, z\u00e1lohovanie a obnovu d\u00e1t, zabezpe\u010denie, indexovanie, monitoring a optimaliz\u00e1ciu v\u00fdkonu. V Microsoft SQL Server I. Za\u010diato\u010dn\u00edk<\/a><\/strong> sa nau\u010d\u00edte in\u0161talova\u0165 a konfigurova\u0165 Microsoft SQL Server, orientova\u0165 sa v datab\u00e1zach, pou\u017e\u00edva\u0165 SQL Engine, vytv\u00e1ra\u0165 a spravova\u0165 tabu\u013eky, indexy a poh\u013eady a pracova\u0165 s prim\u00e1rnymi a cudz\u00edmi k\u013e\u00fa\u010dmi. Osvoj\u00edte si SQL dopyty, filtrovanie, agreg\u00e1cie, zoskupovanie d\u00e1t, \u0161tandardn\u00e9 funkcie, JOIN oper\u00e1cie, z\u00e1lohovanie a obnovu datab\u00e1z a pr\u00e1cu s Microsoft SQL Server Management Studio. Jazyk SQL v Microsoft SQL Server I. Za\u010diato\u010dn\u00edk<\/a><\/strong> je zameran\u00fd na syntax SQL, princ\u00edpy rela\u010dn\u00fdch datab\u00e1z, informa\u010dn\u00fa sch\u00e9mu, premenn\u00e9, funkcie, oper\u00e1tory a DML (Data Manipulation Language) pr\u00edkazy SELECT, INSERT, UPDATE a DELETE. Nau\u010d\u00edte sa pou\u017e\u00edva\u0165 GROUP BY, ORDER BY, HAVING, SELECT TOP, CONCAT, SUBSTRING a REPLACE a analyzova\u0165 \u00fadaje pomocou SQL dopytov. V Microsoft SQL Server II. Mierne Pokro\u010dil\u00fd<\/a><\/strong> si roz\u0161\u00edrite znalosti o \u00fa\u010dty a prihl\u00e1senia, ERD (Entity Relationship Diagram), JOIN oper\u00e1cie, poh\u013eady, transakcie, pr\u00edkazy MERGE, INSERT a TRUNCATE, ulo\u017een\u00e9 proced\u00fary, triggery, datab\u00e1zov\u00e9 sn\u00edmky, fulltextov\u00e9 indexovanie a zabezpe\u010denie datab\u00e1z. Microsoft SQL Server V. Ladenie a Optimaliz\u00e1cia Dopytov<\/a><\/strong> sa venuje architekt\u00fare SQL Servera, monitorovaniu a meraniu v\u00fdkonu, Query Planneru, Execution Planom, indexom, \u0161tatistik\u00e1m a n\u00e1kladom dopytov, identifik\u00e1cii pomal\u00fdch dopytov, SQL Injection a technik\u00e1m optimaliz\u00e1cie datab\u00e1zov\u00e9ho v\u00fdkonu. Online kurzy Microsoft SQL Server 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, .NET program\u00e1torov, IT analytikov, konzultantov a \u010fal\u0161\u00edch odborn\u00edkov pracuj\u00facich s podnikov\u00fdmi datab\u00e1zami.","link":"https:\/\/www.vita.sk\/cs\/online-kurzy-microsoft-sql-server\/","name":"Microsoft SQL Server","slug":"online-kurzy-microsoft-sql-server","taxonomy":"product_cat","parent":49,"meta":[],"yoast_head":"\nMicrosoft SQL Server | VITA<\/title>\n<meta name=\"description\" content=\"Online kurzy Microsoft SQL Server v\u00e1s nau\u010dia SQL, SSMS, datab\u00e1zy, JOIN, proced\u00fary, triggery, indexy, 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-microsoft-sql-server\/\" \/>\n<meta property=\"og:locale\" content=\"cs_CZ\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Microsoft SQL Server arch\u00edvy\" \/>\n<meta property=\"og:description\" content=\"Online kurzy Microsoft SQL Server v\u00e1s nau\u010dia SQL, SSMS, datab\u00e1zy, JOIN, proced\u00fary, triggery, indexy, z\u00e1lohovanie a optimaliz\u00e1ciu dopytov. \u2705\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.vita.sk\/online-kurzy-microsoft-sql-server\/\" \/>\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-microsoft-sql-server\/\",\n\t \"url\": \"https:\/\/www.vita.sk\/online-kurzy-microsoft-sql-server\/\",\n\t \"name\": \"Microsoft SQL Server | VITA\",\n\t \"isPartOf\": {\n\t \"@id\": \"https:\/\/www.vita.sk\/#website\"\n\t },\n\t \"description\": \"Online kurzy Microsoft SQL Server v\u00e1s nau\u010dia SQL, SSMS, datab\u00e1zy, JOIN, proced\u00fary, triggery, indexy, z\u00e1lohovanie a optimaliz\u00e1ciu dopytov. \u2705\",\n\t \"breadcrumb\": {\n\t \"@id\": \"https:\/\/www.vita.sk\/online-kurzy-microsoft-sql-server\/#breadcrumb\"\n\t },\n\t \"inLanguage\": \"cs\"\n\t },\n\t {\n\t \"@type\": \"BreadcrumbList\",\n\t \"@id\": \"https:\/\/www.vita.sk\/online-kurzy-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-statistika-analytika\/\"\n\t },\n\t {\n\t \"@type\": \"ListItem\",\n\t \"position\": 4,\n\t \"name\": \"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":"Microsoft SQL Server | VITA","description":"Online kurzy Microsoft SQL Server v\u00e1s nau\u010dia SQL, SSMS, datab\u00e1zy, JOIN, proced\u00fary, triggery, indexy, 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-microsoft-sql-server\/","og_locale":"cs_CZ","og_type":"article","og_title":"Microsoft SQL Server arch\u00edvy","og_description":"Online kurzy Microsoft SQL Server v\u00e1s nau\u010dia SQL, SSMS, datab\u00e1zy, JOIN, proced\u00fary, triggery, indexy, z\u00e1lohovanie a optimaliz\u00e1ciu dopytov. \u2705","og_url":"https:\/\/www.vita.sk\/online-kurzy-microsoft-sql-server\/","og_site_name":"VITA","twitter_card":"summary_large_image","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"CollectionPage","@id":"https:\/\/www.vita.sk\/online-kurzy-microsoft-sql-server\/","url":"https:\/\/www.vita.sk\/online-kurzy-microsoft-sql-server\/","name":"Microsoft SQL Server | VITA","isPartOf":{"@id":"https:\/\/www.vita.sk\/#website"},"description":"Online kurzy Microsoft SQL Server v\u00e1s nau\u010dia SQL, SSMS, datab\u00e1zy, JOIN, proced\u00fary, triggery, indexy, z\u00e1lohovanie a optimaliz\u00e1ciu dopytov. \u2705","breadcrumb":{"@id":"https:\/\/www.vita.sk\/online-kurzy-microsoft-sql-server\/#breadcrumb"},"inLanguage":"cs"},{"@type":"BreadcrumbList","@id":"https:\/\/www.vita.sk\/online-kurzy-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-statistika-analytika\/"},{"@type":"ListItem","position":4,"name":"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_cat\/52","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=52"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}