{"id":4722,"date":"2023-04-25T15:34:36","date_gmt":"2023-04-25T13:34:36","guid":{"rendered":"https:\/\/www.dbi-services.com\/courses\/formation-microsoft-sql-server-dba\/"},"modified":"2025-09-08T17:22:48","modified_gmt":"2025-09-08T15:22:48","slug":"microsoft-sql-server-dba-les-essentiels","status":"publish","type":"courses","link":"https:\/\/www.dbi-services.com\/fr\/formations\/microsoft-sql-server-dba-les-essentiels\/","title":{"rendered":"Microsoft SQL Server DBA – les essentiels"},"content":{"rendered":"\n\n
\n\n
\"\"<\/figure>\n\n<\/div><\/div><\/section>\n\n

<\/h3>

Objectifs<\/h2>

<\/p>

\n\n

<\/h2>
  • Comprendre les concepts de SQL Server (fonctionnement, stockage, s\u00e9curit\u00e9, administration)<\/li>
  • Installer & configurer une instance en GUI ou en ligne de commande, en suivant les bonnes pratiques<\/li>
  • Cr\u00e9er et configurer des bases de donn\u00e9es<\/li>
  • Maintenir un environnement MSSQL: plan de maintenance (indexes, int\u00e9grit\u00e9 des donn\u00e9es, sauvegardes), jobs et alertes de l\u2019agent SQL, optimisation du log d\u2019erreur<\/li>
  • Pr\u00e9requis et bonnes pratiques SQL Server<\/li><\/ul>\n\n<\/div><\/div><\/section>\n\n

    <\/h3>

    M\u00e9thode<\/h2>

    <\/p>

    \n\n

    <\/h2>
    • Pr\u00e9sentations, exercices pratiques, \u00e9tudes de cas et d\u00e9monstrations orient\u00e9es en fonction des questions<\/li>
    • Discussion et networking durant les pauses et le repas de midi (inclus)<\/li><\/ul>\n\n<\/div><\/div><\/section>\n\n

      <\/h3>

      Cibles<\/h2>
      \n\n

      <\/h2>
      • Cette formation Microsoft SQL Server DBA sur les essentiels s\u2019adresse aux administrateurs de bases de donn\u00e9es (DBA) ainsi qu\u2019aux administrateurs de r\u00e9seaux, de syst\u00e8mes et d\u2019applications responsables des bases de donn\u00e9es SQL Server ou de leur support.<\/li><\/ul>\n\n<\/div><\/div><\/section>\n\n

        <\/h3>

        Pr\u00e9requis<\/h2>

        <\/p>

        \n\n

        <\/h2>
        • Connaissances des bases en Windows Server.<\/li><\/ul>\n\n<\/div><\/div><\/section>\n\n

          R\u00e9duction de 5% pour les membres du SOUG, du SwissPUG et de la DOAG.<\/strong><\/p><\/div><\/section>","protected":false},"author":122,"featured_media":0,"template":"","meta":{"_acf_changed":false},"categories":[35,38],"location":[21],"class_list":["post-4722","courses","type-courses","status-publish","hentry","category-database","category-microsoft","location-nyon"],"acf":[],"yoast_head":"\nMicrosoft SQL Server DBA - les essentiels - dbi services<\/title>\n<meta name=\"description\" content=\"\u00c0 l\u2019issue de ce cours, vous serez en mesure d\u2019installer une instance SGBD et d\u2019administrer une base de donn\u00e9es SQL Server selon les bonnes pratiques.\" \/>\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.dbi-services.com\/fr\/formations\/microsoft-sql-server-dba-les-essentiels\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Microsoft SQL Server DBA - les essentiels\" \/>\n<meta property=\"og:description\" content=\"\u00c0 l\u2019issue de ce cours, vous serez en mesure d\u2019installer une instance SGBD et d\u2019administrer une base de donn\u00e9es SQL Server selon les bonnes pratiques.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/fr\/formations\/microsoft-sql-server-dba-les-essentiels\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi services\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/dbiservices\/\" \/>\n<meta property=\"article:modified_time\" content=\"2025-09-08T15:22:48+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/wp-content\/uploads\/2023\/04\/Microsoft-SQL-Server-DBA-Essential-Training-2.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"1200\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@dbiservices\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/fr\/formations\/microsoft-sql-server-dba-les-essentiels\/\",\"url\":\"https:\/\/www.dbi-services.com\/fr\/formations\/microsoft-sql-server-dba-les-essentiels\/\",\"name\":\"Microsoft SQL Server DBA - les essentiels - dbi services\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/fr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/fr\/formations\/microsoft-sql-server-dba-les-essentiels\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/fr\/formations\/microsoft-sql-server-dba-les-essentiels\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/wp-content\/uploads\/2023\/04\/Microsoft-SQL-Server-DBA-Essential-Training-2-1024x1024.png\",\"datePublished\":\"2023-04-25T13:34:36+00:00\",\"dateModified\":\"2025-09-08T15:22:48+00:00\",\"description\":\"\u00c0 l\u2019issue de ce cours, vous serez en mesure d\u2019installer une instance SGBD et d\u2019administrer une base de donn\u00e9es SQL Server selon les bonnes pratiques.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/fr\/formations\/microsoft-sql-server-dba-les-essentiels\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/fr\/formations\/microsoft-sql-server-dba-les-essentiels\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/www.dbi-services.com\/fr\/formations\/microsoft-sql-server-dba-les-essentiels\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/wp-content\/uploads\/2023\/04\/Microsoft-SQL-Server-DBA-Essential-Training-2-1024x1024.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/wp-content\/uploads\/2023\/04\/Microsoft-SQL-Server-DBA-Essential-Training-2-1024x1024.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/fr\/formations\/microsoft-sql-server-dba-les-essentiels\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.dbi-services.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Formations\",\"item\":\"https:\/\/www.dbi-services.com\/fr\/formations\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Microsoft SQL Server DBA – les essentiels\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/fr\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/fr\/\",\"name\":\"dbi services\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.dbi-services.com\/fr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/fr\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.dbi-services.com\/fr\/#organization\",\"name\":\"dbi services\",\"alternateName\":\"dbi services\",\"url\":\"https:\/\/www.dbi-services.com\/fr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/www.dbi-services.com\/fr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.dbi-services.com\/wp-content\/uploads\/2023\/06\/dbi-services-by-sequotech-01-1.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/wp-content\/uploads\/2023\/06\/dbi-services-by-sequotech-01-1.png\",\"width\":3230,\"height\":1100,\"caption\":\"dbi services\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/fr\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/dbiservices\/\",\"https:\/\/x.com\/dbiservices\",\"https:\/\/www.linkedin.com\/company\/dbi-services\/\",\"https:\/\/www.youtube.com\/user\/dbiservices\"]}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Microsoft SQL Server DBA - les essentiels - dbi services","description":"\u00c0 l\u2019issue de ce cours, vous serez en mesure d\u2019installer une instance SGBD et d\u2019administrer une base de donn\u00e9es SQL Server selon les bonnes pratiques.","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.dbi-services.com\/fr\/formations\/microsoft-sql-server-dba-les-essentiels\/","og_locale":"fr_FR","og_type":"article","og_title":"Microsoft SQL Server DBA - les essentiels","og_description":"\u00c0 l\u2019issue de ce cours, vous serez en mesure d\u2019installer une instance SGBD et d\u2019administrer une base de donn\u00e9es SQL Server selon les bonnes pratiques.","og_url":"https:\/\/www.dbi-services.com\/fr\/formations\/microsoft-sql-server-dba-les-essentiels\/","og_site_name":"dbi services","article_publisher":"https:\/\/www.facebook.com\/dbiservices\/","article_modified_time":"2025-09-08T15:22:48+00:00","og_image":[{"width":1200,"height":1200,"url":"https:\/\/www.dbi-services.com\/wp-content\/uploads\/2023\/04\/Microsoft-SQL-Server-DBA-Essential-Training-2.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_site":"@dbiservices","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/fr\/formations\/microsoft-sql-server-dba-les-essentiels\/","url":"https:\/\/www.dbi-services.com\/fr\/formations\/microsoft-sql-server-dba-les-essentiels\/","name":"Microsoft SQL Server DBA - les essentiels - dbi services","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/fr\/formations\/microsoft-sql-server-dba-les-essentiels\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/fr\/formations\/microsoft-sql-server-dba-les-essentiels\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/wp-content\/uploads\/2023\/04\/Microsoft-SQL-Server-DBA-Essential-Training-2-1024x1024.png","datePublished":"2023-04-25T13:34:36+00:00","dateModified":"2025-09-08T15:22:48+00:00","description":"\u00c0 l\u2019issue de ce cours, vous serez en mesure d\u2019installer une instance SGBD et d\u2019administrer une base de donn\u00e9es SQL Server selon les bonnes pratiques.","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/fr\/formations\/microsoft-sql-server-dba-les-essentiels\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/fr\/formations\/microsoft-sql-server-dba-les-essentiels\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/www.dbi-services.com\/fr\/formations\/microsoft-sql-server-dba-les-essentiels\/#primaryimage","url":"https:\/\/www.dbi-services.com\/wp-content\/uploads\/2023\/04\/Microsoft-SQL-Server-DBA-Essential-Training-2-1024x1024.png","contentUrl":"https:\/\/www.dbi-services.com\/wp-content\/uploads\/2023\/04\/Microsoft-SQL-Server-DBA-Essential-Training-2-1024x1024.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/fr\/formations\/microsoft-sql-server-dba-les-essentiels\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.dbi-services.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Formations","item":"https:\/\/www.dbi-services.com\/fr\/formations\/"},{"@type":"ListItem","position":3,"name":"Microsoft SQL Server DBA – les essentiels"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/fr\/#website","url":"https:\/\/www.dbi-services.com\/fr\/","name":"dbi services","description":"","publisher":{"@id":"https:\/\/www.dbi-services.com\/fr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/fr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Organization","@id":"https:\/\/www.dbi-services.com\/fr\/#organization","name":"dbi services","alternateName":"dbi services","url":"https:\/\/www.dbi-services.com\/fr\/","logo":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/www.dbi-services.com\/fr\/#\/schema\/logo\/image\/","url":"https:\/\/www.dbi-services.com\/wp-content\/uploads\/2023\/06\/dbi-services-by-sequotech-01-1.png","contentUrl":"https:\/\/www.dbi-services.com\/wp-content\/uploads\/2023\/06\/dbi-services-by-sequotech-01-1.png","width":3230,"height":1100,"caption":"dbi services"},"image":{"@id":"https:\/\/www.dbi-services.com\/fr\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/dbiservices\/","https:\/\/x.com\/dbiservices","https:\/\/www.linkedin.com\/company\/dbi-services\/","https:\/\/www.youtube.com\/user\/dbiservices"]}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/fr\/wp-json\/wp\/v2\/courses\/4722","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/fr\/wp-json\/wp\/v2\/courses"}],"about":[{"href":"https:\/\/www.dbi-services.com\/fr\/wp-json\/wp\/v2\/types\/courses"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/fr\/wp-json\/wp\/v2\/users\/122"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/fr\/wp-json\/wp\/v2\/media?parent=4722"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/fr\/wp-json\/wp\/v2\/categories?post=4722"},{"taxonomy":"location","embeddable":true,"href":"https:\/\/www.dbi-services.com\/fr\/wp-json\/wp\/v2\/location?post=4722"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}