{"id":1760,"date":"2010-09-22T16:59:01","date_gmt":"2010-09-22T15:59:01","guid":{"rendered":"http:\/\/blog.capdata.fr\/?p=1760"},"modified":"2019-09-13T14:49:54","modified_gmt":"2019-09-13T13:49:54","slug":"formation-optimisation-de-requetes","status":"publish","type":"post","link":"https:\/\/blog.capdata.fr\/index.php\/formation-optimisation-de-requetes\/","title":{"rendered":"Formation Optimisation de requ\u00eates"},"content":{"rendered":"\"twitter\"<\/a>\"linkedin\"<\/a>\"mail\"<\/a>

Hello,<\/p>\n

Pour faire suite au post pr\u00e9c\u00e9dent <\/a>concernant le d\u00e9veloppement des formations SQL Server chez CapData, voici le plan de la nouvelle formation Optimisation de requ\u00eates<\/strong><\/em> qui nous a \u00e9t\u00e9 r\u00e9clam\u00e9e par pas mal de gens ces derniers temps. La formation n’est pas encore au catalogue mais la premi\u00e8re session sera donn\u00e9e par bibi d\u00e9but novembre dans nos locaux parisiens (d\u00e9j\u00e0 plus de place, il faudra appeler pour demander la session suivante\u00a0 \ud83d\ude41\u00a0 => 0820 620 400 <\/strong><\/em>).<\/p>\n

Elle se d\u00e9roulera sur 2 jours et abordera les th\u00e8mes suivants:<\/p>\n

I Pr\u00e9sentation et g\u00e9n\u00e9ralit\u00e9s :<\/strong><\/h2>\n

R\u00e9cap: <\/strong>se rem\u00e9morer les m\u00e9canismes fondamentaux de SQL Server.
\n* Rappels sur l’architecture de l’instance et de la base.
\n* Rappels sur la notion de transaction.
\n* Rappels sur l’isolation et le verrouillage.
\n* Utilisation des ressources et performances.<\/p>\n

II Mod\u00e9lisation et performances: <\/strong><\/h2>\n

R\u00e9cap<\/strong>: ensemble de bonnes pratiques de mod\u00e9lisation pour aboutir \u00e0 un mod\u00e8le de donn\u00e9es efficace et maintenable.
\n* Normalisation
\n* Indexation
\n* Typage
\n* Utilisation des contraintes
\n* Proc\u00e9dures stock\u00e9es
\n* Requ\u00eates ensemblistes et curseurs.
\n* LINQ et les ORM<\/p>\n

III Indexes et vues index\u00e9es:<\/strong><\/h2>\n

R\u00e9cap:<\/strong> comprendre la structure des principaux indexes, et leur utilisation.
\n* D\u00e9finition d’un index.
\n* Index clusteris\u00e9.
\n* Index non clusteris\u00e9.
\n* Index avec colonnes additionnelles.
\n* Index avec colonnes calcul\u00e9es.
\n* Index filtr\u00e9.
\n* Vues index\u00e9es.
\n* Couverture.
\n* Fragmentation.<\/p>\n

IV Optimiseur de requ\u00eates:<\/strong><\/h2>\n

<\/strong><\/h2>\n

R\u00e9cap<\/strong>: comprendre le fonctionnement de l’optimiseur et des diff\u00e9rentes \u00e9tapes de la compilation.
\n* Les diff\u00e9rentes phases de l’optimisation d’une requ\u00eate.
\n* Les statistiques.
\n* Plan d’ex\u00e9cution et recompilations.
\n* R\u00e9utilisation des plans.<\/p>\n

V Plan d’ex\u00e9cution:<\/strong><\/h2>\n

R\u00e9cap: <\/strong>savoir afficher, lire et interpr\u00e9ter un plan d’ex\u00e9cution.
\n* Afficher un plan d’ex\u00e9cution.
\n* Principaux op\u00e9rateurs dans le d\u00e9tail.
\n* Types de jointure.
\n* Parall\u00e9lisme.
\n* Hints<\/p>\n

VI Outils et m\u00e9thodologies:<\/strong><\/h2>\n

R\u00e9cap<\/strong>: savoir utiliser les outils et les m\u00e9thodes pour recueillir et analyser des donn\u00e9es de performances.
\n* Les outils basiques.
\n* SQL trace et Profiler.
\n* DTA
\n* DMV\/DMF orient\u00e9es performance.
\n* SQLDIAG.
\n* RML Utilities et ReadTrace.
\n* Autres (SQLNexus, Performance Dashboard, rapports SSMS).
\n* Extended events.
\n
\n<\/strong><\/p>\n

VII Etudes de cas
\n<\/strong><\/h2>\n

R\u00e9cap<\/strong>: diff\u00e9rents cas tordus et propositions de r\u00e9\u00e9criture \/ d’indexation.<\/p>\n

En esp\u00e9rant vous y voir bient\u00f4t . A+ <\/strong><\/p>\n

David B.
\n<\/strong><\/p>\n\"twitter\"<\/a>\"linkedin\"<\/a>\"mail\"<\/a>","protected":false},"excerpt":{"rendered":"

Hello, Pour faire suite au post pr\u00e9c\u00e9dent concernant le d\u00e9veloppement des formations SQL Server chez CapData, voici le plan de la nouvelle formation Optimisation de requ\u00eates qui nous a \u00e9t\u00e9 r\u00e9clam\u00e9e par pas mal de gens ces derniers temps. La… Continuer la lecture →<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":7932,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[177],"class_list":["post-1760","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sqlserver","tag-formation"],"yoast_head":"\nFormation Optimisation de requ\u00eates - Capdata TECH BLOG<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/blog.capdata.fr\/index.php\/formation-optimisation-de-requetes\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Formation Optimisation de requ\u00eates - Capdata TECH BLOG\" \/>\n<meta property=\"og:description\" content=\"Hello, Pour faire suite au post pr\u00e9c\u00e9dent concernant le d\u00e9veloppement des formations SQL Server chez CapData, voici le plan de la nouvelle formation Optimisation de requ\u00eates qui nous a \u00e9t\u00e9 r\u00e9clam\u00e9e par pas mal de gens ces derniers temps. La… Continuer la lecture →\" \/>\n<meta property=\"og:url\" content=\"https:\/\/blog.capdata.fr\/index.php\/formation-optimisation-de-requetes\/\" \/>\n<meta property=\"og:site_name\" content=\"Capdata TECH BLOG\" \/>\n<meta property=\"article:published_time\" content=\"2010-09-22T15:59:01+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-09-13T13:49:54+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2011\/01\/MS-SQL-Server-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1072\" \/>\n\t<meta property=\"og:image:height\" content=\"766\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"David Baffaleuf\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"David Baffaleuf\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/formation-optimisation-de-requetes\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/formation-optimisation-de-requetes\/\"},\"author\":{\"name\":\"David Baffaleuf\",\"@id\":\"https:\/\/blog.capdata.fr\/#\/schema\/person\/136297da9f61d6e4878abe0f48bc5fbf\"},\"headline\":\"Formation Optimisation de requ\u00eates\",\"datePublished\":\"2010-09-22T15:59:01+00:00\",\"dateModified\":\"2019-09-13T13:49:54+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/formation-optimisation-de-requetes\/\"},\"wordCount\":384,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/blog.capdata.fr\/#organization\"},\"keywords\":[\"formation\"],\"articleSection\":[\"SQL Server\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/blog.capdata.fr\/index.php\/formation-optimisation-de-requetes\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/formation-optimisation-de-requetes\/\",\"url\":\"https:\/\/blog.capdata.fr\/index.php\/formation-optimisation-de-requetes\/\",\"name\":\"Formation Optimisation de requ\u00eates - Capdata TECH BLOG\",\"isPartOf\":{\"@id\":\"https:\/\/blog.capdata.fr\/#website\"},\"datePublished\":\"2010-09-22T15:59:01+00:00\",\"dateModified\":\"2019-09-13T13:49:54+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/formation-optimisation-de-requetes\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/blog.capdata.fr\/index.php\/formation-optimisation-de-requetes\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/formation-optimisation-de-requetes\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/blog.capdata.fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Formation Optimisation de requ\u00eates\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/blog.capdata.fr\/#website\",\"url\":\"https:\/\/blog.capdata.fr\/\",\"name\":\"Capdata TECH BLOG\",\"description\":\"Le blog technique sur les bases de donn\u00e9es de CAP DATA Consulting\",\"publisher\":{\"@id\":\"https:\/\/blog.capdata.fr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/blog.capdata.fr\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/blog.capdata.fr\/#organization\",\"name\":\"Capdata TECH BLOG\",\"url\":\"https:\/\/blog.capdata.fr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/blog.capdata.fr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2023\/01\/logo_capdata.webp\",\"contentUrl\":\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2023\/01\/logo_capdata.webp\",\"width\":800,\"height\":254,\"caption\":\"Capdata TECH BLOG\"},\"image\":{\"@id\":\"https:\/\/blog.capdata.fr\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.linkedin.com\/company\/cap-data-consulting\/mycompany\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/blog.capdata.fr\/#\/schema\/person\/136297da9f61d6e4878abe0f48bc5fbf\",\"name\":\"David Baffaleuf\",\"sameAs\":[\"http:\/\/www.capdata.fr\"],\"url\":\"https:\/\/blog.capdata.fr\/index.php\/author\/dbaffaleuf\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Formation Optimisation de requ\u00eates - Capdata TECH BLOG","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:\/\/blog.capdata.fr\/index.php\/formation-optimisation-de-requetes\/","og_locale":"fr_FR","og_type":"article","og_title":"Formation Optimisation de requ\u00eates - Capdata TECH BLOG","og_description":"Hello, Pour faire suite au post pr\u00e9c\u00e9dent concernant le d\u00e9veloppement des formations SQL Server chez CapData, voici le plan de la nouvelle formation Optimisation de requ\u00eates qui nous a \u00e9t\u00e9 r\u00e9clam\u00e9e par pas mal de gens ces derniers temps. La… Continuer la lecture →","og_url":"https:\/\/blog.capdata.fr\/index.php\/formation-optimisation-de-requetes\/","og_site_name":"Capdata TECH BLOG","article_published_time":"2010-09-22T15:59:01+00:00","article_modified_time":"2019-09-13T13:49:54+00:00","og_image":[{"width":1072,"height":766,"url":"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2011\/01\/MS-SQL-Server-1.png","type":"image\/png"}],"author":"David Baffaleuf","twitter_card":"summary_large_image","twitter_misc":{"\u00c9crit par":"David Baffaleuf","Dur\u00e9e de lecture estim\u00e9e":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/blog.capdata.fr\/index.php\/formation-optimisation-de-requetes\/#article","isPartOf":{"@id":"https:\/\/blog.capdata.fr\/index.php\/formation-optimisation-de-requetes\/"},"author":{"name":"David Baffaleuf","@id":"https:\/\/blog.capdata.fr\/#\/schema\/person\/136297da9f61d6e4878abe0f48bc5fbf"},"headline":"Formation Optimisation de requ\u00eates","datePublished":"2010-09-22T15:59:01+00:00","dateModified":"2019-09-13T13:49:54+00:00","mainEntityOfPage":{"@id":"https:\/\/blog.capdata.fr\/index.php\/formation-optimisation-de-requetes\/"},"wordCount":384,"commentCount":0,"publisher":{"@id":"https:\/\/blog.capdata.fr\/#organization"},"keywords":["formation"],"articleSection":["SQL Server"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/blog.capdata.fr\/index.php\/formation-optimisation-de-requetes\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/blog.capdata.fr\/index.php\/formation-optimisation-de-requetes\/","url":"https:\/\/blog.capdata.fr\/index.php\/formation-optimisation-de-requetes\/","name":"Formation Optimisation de requ\u00eates - Capdata TECH BLOG","isPartOf":{"@id":"https:\/\/blog.capdata.fr\/#website"},"datePublished":"2010-09-22T15:59:01+00:00","dateModified":"2019-09-13T13:49:54+00:00","breadcrumb":{"@id":"https:\/\/blog.capdata.fr\/index.php\/formation-optimisation-de-requetes\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/blog.capdata.fr\/index.php\/formation-optimisation-de-requetes\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/blog.capdata.fr\/index.php\/formation-optimisation-de-requetes\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/blog.capdata.fr\/"},{"@type":"ListItem","position":2,"name":"Formation Optimisation de requ\u00eates"}]},{"@type":"WebSite","@id":"https:\/\/blog.capdata.fr\/#website","url":"https:\/\/blog.capdata.fr\/","name":"Capdata TECH BLOG","description":"Le blog technique sur les bases de donn\u00e9es de CAP DATA Consulting","publisher":{"@id":"https:\/\/blog.capdata.fr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/blog.capdata.fr\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"fr-FR"},{"@type":"Organization","@id":"https:\/\/blog.capdata.fr\/#organization","name":"Capdata TECH BLOG","url":"https:\/\/blog.capdata.fr\/","logo":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/blog.capdata.fr\/#\/schema\/logo\/image\/","url":"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2023\/01\/logo_capdata.webp","contentUrl":"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2023\/01\/logo_capdata.webp","width":800,"height":254,"caption":"Capdata TECH BLOG"},"image":{"@id":"https:\/\/blog.capdata.fr\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.linkedin.com\/company\/cap-data-consulting\/mycompany\/"]},{"@type":"Person","@id":"https:\/\/blog.capdata.fr\/#\/schema\/person\/136297da9f61d6e4878abe0f48bc5fbf","name":"David Baffaleuf","sameAs":["http:\/\/www.capdata.fr"],"url":"https:\/\/blog.capdata.fr\/index.php\/author\/dbaffaleuf\/"}]}},"_links":{"self":[{"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/posts\/1760","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/comments?post=1760"}],"version-history":[{"count":18,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/posts\/1760\/revisions"}],"predecessor-version":[{"id":1778,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/posts\/1760\/revisions\/1778"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/media\/7932"}],"wp:attachment":[{"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/media?parent=1760"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/categories?post=1760"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/tags?post=1760"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}