{"id":14403,"date":"2022-12-29T08:21:28","date_gmt":"2022-12-29T07:21:28","guid":{"rendered":"https:\/\/www.itta.net\/formations\/course-55069-microsoft-powershell-for-sql-server-administrators-lausanne-geneva\/"},"modified":"2025-09-27T15:55:33","modified_gmt":"2025-09-27T13:55:33","slug":"powershell-for-sql-server-administrators","status":"publish","type":"formations","link":"https:\/\/www.itta.net\/en\/trainings\/it-pro\/systems-networking\/powershell-for-sql-server-administrators\/","title":{"rendered":"PowerShell for SQL Server Administrators (55069)"},"content":{"rendered":"<p>This course provides you with the knowledge and skills needed to use PowerShell and SMO components for SQL Server administration on SQL Server 2016, 2014 or 2012. You will learn how to manage day-to-day and scheduled maintenance tasks. The main focus will be administration of the database engine, but optional material &amp; exercises on Analysis Services (SSAS) and Integration Services (SSIS) are also included.<\/p>\n","protected":false},"featured_media":0,"parent":0,"menu_order":0,"template":"","editeurs":[1489,1488],"domaine":[1253,1260],"class_list":["post-14403","formations","type-formations","status-publish","hentry","editeurs-automating-scripting-powershell-microsoft","editeurs-microsoft","domaine-it-pro","domaine-systems-networking"],"acf":{"reference":"55069AC","duree_nombre":2,"duree_unite":"jour","prix_virtuel":1700,"prix_presentiel":1800,"prix_blended":"","prix_elearning":"","views":2071,"niveau":["Interm\u00e9diaire"],"role":"","certifiant":"","pdus":"","lieux":["Gen\u00e8ve","Lausanne"],"formats_dapprentissage":["presentiel","virtuel"],"examen_inclus":"Non certifiant","garanti":[""],"financement":["Temptraining"],"description_temptraining":"","description_caf":"","description_title":"","objectifs":"<ul>\r\n \t<li>Install and Configure SQL Server and all its components using PowerShell<\/li>\r\n \t<li>Manage day-to-day SQL Server Administration with PowerShell<\/li>\r\n \t<li>Maintain the SQL Server environment using PowerShell scripting and programming options<\/li>\r\n<\/ul>","connaissances":"<ul>\r\n \t<li>Experience working on Windows desktops or servers<\/li>\r\n \t<li>Experience working in a Windows domain environment<\/li>\r\n \t<li>Experience Administering SQL Server Servers<\/li>\r\n \t<li>Fundamental experience with PowerShell<\/li>\r\n<\/ul>","profils_participants":"<ul>\r\n \t<li>SQL Server administrators who work in a Windows network environment<\/li>\r\n<\/ul>","examen":"","documentation":"<ul>\r\n \t<li>Digital courseware included<\/li>\r\n<\/ul>","lab__exercices":"<ul>\r\n \t<li>Online Labs<\/li>\r\n<\/ul>","contenu_cours":"<strong>Module 01: Install and Configure SQL Server with PowerShell<\/strong>\r\n<ul>\r\n \t<li>Install SQL Server<\/li>\r\n \t<li>Configure Database Settings<\/li>\r\n \t<li>Configure SQL Server Settings<\/li>\r\n \t<li>Configure SQL Server Policy-Based Management<\/li>\r\n<\/ul>\r\n<strong>Module 02: Administering SQL Servers with PowerShell<\/strong>\r\n<ul>\r\n \t<li>Managing Users and Roles<\/li>\r\n \t<li>Managing Database Performance<\/li>\r\n \t<li>Managing Database Availability<\/li>\r\n \t<li>Managing SQL Server Features<\/li>\r\n<\/ul>\r\n<strong>Module 03: Maintaining SQL Server with PowerShell<\/strong>\r\n<ul>\r\n \t<li>Managing Backups and Restores<\/li>\r\n \t<li>Maintaining Database Integrity and Performance<\/li>\r\n \t<li>Monitoring and Auditing<\/li>\r\n \t<li>Task Automation<\/li>\r\n \t<li>Generating Reports<\/li>\r\n<\/ul>","cours_recommandes":"","infos_additionnelles":"<ul>\r\n \t<li>Course developed by the Microsoft Community<\/li>\r\n<\/ul>","inclus_dans_ce_cours_virtuel":"<ul>\r\n \t<li>Training provided by a certified trainer<\/li>\r\n \t<li>180 days of access to Microsoft labs<\/li>\r\n \t<li>Documentation in digital format<\/li>\r\n \t<li>Achievement badge<\/li>\r\n<\/ul>","inclus_dans_ce_cours_presentiel":"<ul>\r\n \t<li>Training provided by a certified trainer<\/li>\r\n \t<li>180 days of access to Microsoft labs<\/li>\r\n \t<li>Documentation in digital format<\/li>\r\n \t<li>Achievement badge<\/li>\r\n<\/ul>","inclus_dans_ce_cours_blended":"","inclus_dans_ce_cours_elearning":"","inclus_dans_ce_cours_surmesure":""},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.5 (Yoast SEO v27.5) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Formation PowerShell for SQL Server Administrators - ITTA<\/title>\n<meta name=\"description\" content=\"This course provides you with the knowledge and skills needed to use PowerShell and SMO components for SQL Server administration on SQL Server 2016, 2014 or 2012.\" \/>\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.itta.net\/en\/trainings\/it-pro\/systems-networking\/powershell-for-sql-server-administrators\/\" \/>\n<meta name=\"twitter:label1\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/trainings\\\/it-pro\\\/systems-networking\\\/powershell-for-sql-server-administrators\\\/\",\"url\":\"https:\\\/\\\/www.itta.net\\\/en\\\/trainings\\\/it-pro\\\/systems-networking\\\/powershell-for-sql-server-administrators\\\/\",\"name\":\"Formation PowerShell for SQL Server Administrators - ITTA\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/#website\"},\"datePublished\":\"2022-12-29T07:21:28+00:00\",\"dateModified\":\"2025-09-27T13:55:33+00:00\",\"description\":\"This course provides you with the knowledge and skills needed to use PowerShell and SMO components for SQL Server administration on SQL Server 2016, 2014 or 2012.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/trainings\\\/it-pro\\\/systems-networking\\\/powershell-for-sql-server-administrators\\\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.itta.net\\\/en\\\/trainings\\\/it-pro\\\/systems-networking\\\/powershell-for-sql-server-administrators\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/trainings\\\/it-pro\\\/systems-networking\\\/powershell-for-sql-server-administrators\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.itta.net\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"IT Pro\",\"item\":\"https:\\\/\\\/www.itta.net\\\/en\\\/trainings\\\/it-pro\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Systems and Networking\",\"item\":\"https:\\\/\\\/www.itta.net\\\/en\\\/trainings\\\/it-pro\\\/systems-networking\\\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"PowerShell for SQL Server Administrators (55069)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/www.itta.net\\\/en\\\/\",\"name\":\"ITTA\",\"description\":\"Formations &amp; Certifications en Suisse Romande\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.itta.net\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":[\"Organization\",\"EducationalOrganization\"],\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/#organization\",\"name\":\"ITTA\",\"alternateName\":\"IT TRAINING ACADEMY SA\",\"url\":\"https:\\\/\\\/www.itta.net\\\/en\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.itta.net\\\/wp-content\\\/uploads\\\/2023\\\/02\\\/Logo-transparent.png\",\"contentUrl\":\"https:\\\/\\\/www.itta.net\\\/wp-content\\\/uploads\\\/2023\\\/02\\\/Logo-transparent.png\",\"width\":1500,\"height\":623,\"caption\":\"ITTA\"},\"image\":{\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/people\\\/ITTA\\\/100063747262936\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/1001738\",\"https:\\\/\\\/www.instagram.com\\\/itta_suisse\\\/\"],\"contactPoint\":{\"@type\":\"ContactPoint\",\"telephone\":\"+41 58 307 73 00\",\"contactType\":\"customer service\",\"availableLanguage\":[\"French\",\"English\"],\"areaServed\":[{\"@type\":\"Country\",\"name\":\"Switzerland\"},{\"@type\":\"Country\",\"name\":\"France\"}]},\"location\":[{\"@type\":\"Place\",\"name\":\"ITTA Geneve\",\"address\":{\"@type\":\"PostalAddress\",\"streetAddress\":\"Route des Jeunes 35\",\"addressLocality\":\"Carouge\",\"postalCode\":\"1227\",\"addressRegion\":\"GE\",\"addressCountry\":\"CH\"},\"geo\":{\"@type\":\"GeoCoordinates\",\"latitude\":46.18274,\"longitude\":6.12922}},{\"@type\":\"Place\",\"name\":\"ITTA Lausanne\",\"address\":{\"@type\":\"PostalAddress\",\"streetAddress\":\"Rue des Cotes-de-Montbenon 16\",\"addressLocality\":\"Lausanne\",\"postalCode\":\"1003\",\"addressRegion\":\"VD\",\"addressCountry\":\"CH\"},\"geo\":{\"@type\":\"GeoCoordinates\",\"latitude\":46.52111,\"longitude\":6.62734}}]}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Formation PowerShell for SQL Server Administrators - ITTA","description":"This course provides you with the knowledge and skills needed to use PowerShell and SMO components for SQL Server administration on SQL Server 2016, 2014 or 2012.","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.itta.net\/en\/trainings\/it-pro\/systems-networking\/powershell-for-sql-server-administrators\/","twitter_misc":{"Estimated reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.itta.net\/en\/trainings\/it-pro\/systems-networking\/powershell-for-sql-server-administrators\/","url":"https:\/\/www.itta.net\/en\/trainings\/it-pro\/systems-networking\/powershell-for-sql-server-administrators\/","name":"Formation PowerShell for SQL Server Administrators - ITTA","isPartOf":{"@id":"https:\/\/www.itta.net\/en\/#website"},"datePublished":"2022-12-29T07:21:28+00:00","dateModified":"2025-09-27T13:55:33+00:00","description":"This course provides you with the knowledge and skills needed to use PowerShell and SMO components for SQL Server administration on SQL Server 2016, 2014 or 2012.","breadcrumb":{"@id":"https:\/\/www.itta.net\/en\/trainings\/it-pro\/systems-networking\/powershell-for-sql-server-administrators\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.itta.net\/en\/trainings\/it-pro\/systems-networking\/powershell-for-sql-server-administrators\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.itta.net\/en\/trainings\/it-pro\/systems-networking\/powershell-for-sql-server-administrators\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.itta.net\/en\/"},{"@type":"ListItem","position":2,"name":"IT Pro","item":"https:\/\/www.itta.net\/en\/trainings\/it-pro\/"},{"@type":"ListItem","position":3,"name":"Systems and Networking","item":"https:\/\/www.itta.net\/en\/trainings\/it-pro\/systems-networking\/"},{"@type":"ListItem","position":4,"name":"PowerShell for SQL Server Administrators (55069)"}]},{"@type":"WebSite","@id":"https:\/\/www.itta.net\/en\/#website","url":"https:\/\/www.itta.net\/en\/","name":"ITTA","description":"Formations &amp; Certifications en Suisse Romande","publisher":{"@id":"https:\/\/www.itta.net\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.itta.net\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":["Organization","EducationalOrganization"],"@id":"https:\/\/www.itta.net\/en\/#organization","name":"ITTA","alternateName":"IT TRAINING ACADEMY SA","url":"https:\/\/www.itta.net\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.itta.net\/en\/#\/schema\/logo\/image\/","url":"https:\/\/www.itta.net\/wp-content\/uploads\/2023\/02\/Logo-transparent.png","contentUrl":"https:\/\/www.itta.net\/wp-content\/uploads\/2023\/02\/Logo-transparent.png","width":1500,"height":623,"caption":"ITTA"},"image":{"@id":"https:\/\/www.itta.net\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/people\/ITTA\/100063747262936\/","https:\/\/www.linkedin.com\/company\/1001738","https:\/\/www.instagram.com\/itta_suisse\/"],"contactPoint":{"@type":"ContactPoint","telephone":"+41 58 307 73 00","contactType":"customer service","availableLanguage":["French","English"],"areaServed":[{"@type":"Country","name":"Switzerland"},{"@type":"Country","name":"France"}]},"location":[{"@type":"Place","name":"ITTA Geneve","address":{"@type":"PostalAddress","streetAddress":"Route des Jeunes 35","addressLocality":"Carouge","postalCode":"1227","addressRegion":"GE","addressCountry":"CH"},"geo":{"@type":"GeoCoordinates","latitude":46.18274,"longitude":6.12922}},{"@type":"Place","name":"ITTA Lausanne","address":{"@type":"PostalAddress","streetAddress":"Rue des Cotes-de-Montbenon 16","addressLocality":"Lausanne","postalCode":"1003","addressRegion":"VD","addressCountry":"CH"},"geo":{"@type":"GeoCoordinates","latitude":46.52111,"longitude":6.62734}}]}]}},"_links":{"self":[{"href":"https:\/\/www.itta.net\/en\/wp-json\/wp\/v2\/formations\/14403","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.itta.net\/en\/wp-json\/wp\/v2\/formations"}],"about":[{"href":"https:\/\/www.itta.net\/en\/wp-json\/wp\/v2\/types\/formations"}],"wp:attachment":[{"href":"https:\/\/www.itta.net\/en\/wp-json\/wp\/v2\/media?parent=14403"}],"wp:term":[{"taxonomy":"editeurs","embeddable":true,"href":"https:\/\/www.itta.net\/en\/wp-json\/wp\/v2\/editeurs?post=14403"},{"taxonomy":"domaine","embeddable":true,"href":"https:\/\/www.itta.net\/en\/wp-json\/wp\/v2\/domaine?post=14403"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}