{"id":22199,"date":"2019-12-12T16:43:24","date_gmt":"2019-12-12T16:43:24","guid":{"rendered":"https:\/\/www.istegroup.com\/?post_type=product&#038;p=22199"},"modified":"2024-01-03T13:43:19","modified_gmt":"2024-01-03T13:43:19","slug":"sql-analytique-dans-sql-server-2014-2016","status":"publish","type":"product","link":"https:\/\/www.istegroup.com\/en\/produit\/sql-analytique-dans-sql-server-2014-2016\/","title":{"rendered":"SQL Analytique dans SQL Server 2014\/2016"},"content":{"rendered":"<p>L\u2019analyse de donn\u00e9es est une comp\u00e9tence cl\u00e9 pour l\u2019\u00e9laboration d\u2019indicateurs et de m\u00e9triques permettant le suivi des syst\u00e8mes d\u2019information. Afin d\u2019assurer cette mission, plusieurs m\u00e9thodes, techniques et outils ont \u00e9t\u00e9 d\u00e9velopp\u00e9s. C\u2019est le cas des syst\u00e8mes de gestion de bases de donn\u00e9es (SGBD) et du <em>Structured Query Language<\/em> (SQL), langage de requ\u00eate pr\u00e9alablement con\u00e7u pour la d\u00e9finition et la manipulation des donn\u00e9es devenu indispensable pour l\u2019analyse de ces m\u00eames donn\u00e9es.<\/p>\n<p><em>SQL Analytique dans SQL Server 2014\/2016<\/em> traite des fonctions fournies par Microsoft\u00ae SQL Server 2014\/2016 pour l\u2019analyse d\u00e9cisionnelle. Apr\u00e8s avoir examin\u00e9 les fondements de l\u2019analyse de donn\u00e9es avec SQL, il explique l\u2019expansion de ce langage en \u00e9tudiant ses caract\u00e9ristiques \u00e0 la fois simples, performantes et diverses ; il pr\u00e9sente d\u2019abord les requ\u00eates, puis les fonctions et enfin les op\u00e9rateurs propres \u00e0 ce langage.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>L\u2019analyse de donn\u00e9es est une comp\u00e9tence cl\u00e9 pour l\u2019\u00e9laboration d\u2019indicateurs et de m\u00e9triques permettant le suivi des syst\u00e8mes d\u2019information. Afin d\u2019assurer cette mission, plusieurs m\u00e9thodes, techniques et outils ont \u00e9t\u00e9 d\u00e9velopp\u00e9s. C\u2019est le cas des syst\u00e8mes de gestion de bases de donn\u00e9es (SGBD) et du Structured Query Language (SQL), langage de requ\u00eate pr\u00e9alablement con\u00e7u pour [&hellip;]<\/p>\n","protected":false},"featured_media":22208,"template":"","meta":{"_acf_changed":false,"_links_to":"","_links_to_target":""},"product_brand":[],"product_cat":[667],"product_tag":[31,269,18,19,20,21,204,63,26,4060,212,38,4063,4062,4061],"class_list":{"0":"post-22199","1":"product","2":"type-product","3":"status-publish","4":"has-post-thumbnail","6":"product_cat-informatique-12506482","7":"product_tag-ebook","8":"product_tag-edition-francaise","9":"product_tag-edition-scientifique","10":"product_tag-editions-francaise","11":"product_tag-editions-technique","12":"product_tag-iste-group","13":"product_tag-livre","14":"product_tag-livre-electronique","15":"product_tag-livre-scientifique-francais","16":"product_tag-livres","17":"product_tag-ouvrage","18":"product_tag-ouvrage-numerique","19":"product_tag-riadh-ghlala","20":"product_tag-sql-analytique","21":"product_tag-sql-server","23":"first","24":"instock","25":"shipping-taxable","26":"purchasable","27":"product-type-variable"},"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>SQL Analytique dans SQL Server 2014\/2016 - ISTE Group<\/title>\n<meta name=\"description\" content=\"SQL Analytique dans SQL Server 2014\/2016 traite des fonctions fournies par Microsoft\u00ae SQL Server 2014\/2016 pour l\u2019analyse d\u00e9cisionnelle.\" \/>\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.istegroup.com\/en\/produit\/sql-analytique-dans-sql-server-2014-2016\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Analytique dans SQL Server 2014\/2016 - ISTE Group\" \/>\n<meta property=\"og:description\" content=\"SQL Analytique dans SQL Server 2014\/2016 traite des fonctions fournies par Microsoft\u00ae SQL Server 2014\/2016 pour l\u2019analyse d\u00e9cisionnelle.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.istegroup.com\/en\/produit\/sql-analytique-dans-sql-server-2014-2016\/\" \/>\n<meta property=\"og:site_name\" content=\"ISTE Group\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-03T13:43:19+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.istegroup.com\/wp-content\/uploads\/2019\/07\/SQL-Analytique-dans-SQL-Server.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"300\" \/>\n\t<meta property=\"og:image:height\" content=\"452\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.istegroup.com\/en\/produit\/sql-analytique-dans-sql-server-2014-2016\/\",\"url\":\"https:\/\/www.istegroup.com\/en\/produit\/sql-analytique-dans-sql-server-2014-2016\/\",\"name\":\"SQL Analytique dans SQL Server 2014\/2016 - ISTE Group\",\"isPartOf\":{\"@id\":\"https:\/\/www.istegroup.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.istegroup.com\/en\/produit\/sql-analytique-dans-sql-server-2014-2016\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.istegroup.com\/en\/produit\/sql-analytique-dans-sql-server-2014-2016\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.istegroup.com\/wp-content\/uploads\/2019\/07\/SQL-Analytique-dans-SQL-Server.jpg\",\"datePublished\":\"2019-12-12T16:43:24+00:00\",\"dateModified\":\"2024-01-03T13:43:19+00:00\",\"description\":\"SQL Analytique dans SQL Server 2014\/2016 traite des fonctions fournies par Microsoft\u00ae SQL Server 2014\/2016 pour l\u2019analyse d\u00e9cisionnelle.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.istegroup.com\/en\/produit\/sql-analytique-dans-sql-server-2014-2016\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.istegroup.com\/en\/produit\/sql-analytique-dans-sql-server-2014-2016\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.istegroup.com\/en\/produit\/sql-analytique-dans-sql-server-2014-2016\/#primaryimage\",\"url\":\"https:\/\/www.istegroup.com\/wp-content\/uploads\/2019\/07\/SQL-Analytique-dans-SQL-Server.jpg\",\"contentUrl\":\"https:\/\/www.istegroup.com\/wp-content\/uploads\/2019\/07\/SQL-Analytique-dans-SQL-Server.jpg\",\"width\":300,\"height\":452,\"caption\":\"SQL Analytique dans SQL Server 2014\/2016\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.istegroup.com\/en\/produit\/sql-analytique-dans-sql-server-2014-2016\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.istegroup.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Shop\",\"item\":\"https:\/\/www.istegroup.com\/fr\/nouveautes\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"SQL Analytique dans SQL Server 2014\/2016\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.istegroup.com\/#website\",\"url\":\"https:\/\/www.istegroup.com\/\",\"name\":\"ISTE Group\",\"description\":\"Publishing Knowledge\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.istegroup.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL Analytique dans SQL Server 2014\/2016 - ISTE Group","description":"SQL Analytique dans SQL Server 2014\/2016 traite des fonctions fournies par Microsoft\u00ae SQL Server 2014\/2016 pour l\u2019analyse d\u00e9cisionnelle.","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.istegroup.com\/en\/produit\/sql-analytique-dans-sql-server-2014-2016\/","og_locale":"en_US","og_type":"article","og_title":"SQL Analytique dans SQL Server 2014\/2016 - ISTE Group","og_description":"SQL Analytique dans SQL Server 2014\/2016 traite des fonctions fournies par Microsoft\u00ae SQL Server 2014\/2016 pour l\u2019analyse d\u00e9cisionnelle.","og_url":"https:\/\/www.istegroup.com\/en\/produit\/sql-analytique-dans-sql-server-2014-2016\/","og_site_name":"ISTE Group","article_modified_time":"2024-01-03T13:43:19+00:00","og_image":[{"width":300,"height":452,"url":"https:\/\/www.istegroup.com\/wp-content\/uploads\/2019\/07\/SQL-Analytique-dans-SQL-Server.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.istegroup.com\/en\/produit\/sql-analytique-dans-sql-server-2014-2016\/","url":"https:\/\/www.istegroup.com\/en\/produit\/sql-analytique-dans-sql-server-2014-2016\/","name":"SQL Analytique dans SQL Server 2014\/2016 - ISTE Group","isPartOf":{"@id":"https:\/\/www.istegroup.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.istegroup.com\/en\/produit\/sql-analytique-dans-sql-server-2014-2016\/#primaryimage"},"image":{"@id":"https:\/\/www.istegroup.com\/en\/produit\/sql-analytique-dans-sql-server-2014-2016\/#primaryimage"},"thumbnailUrl":"https:\/\/www.istegroup.com\/wp-content\/uploads\/2019\/07\/SQL-Analytique-dans-SQL-Server.jpg","datePublished":"2019-12-12T16:43:24+00:00","dateModified":"2024-01-03T13:43:19+00:00","description":"SQL Analytique dans SQL Server 2014\/2016 traite des fonctions fournies par Microsoft\u00ae SQL Server 2014\/2016 pour l\u2019analyse d\u00e9cisionnelle.","breadcrumb":{"@id":"https:\/\/www.istegroup.com\/en\/produit\/sql-analytique-dans-sql-server-2014-2016\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.istegroup.com\/en\/produit\/sql-analytique-dans-sql-server-2014-2016\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.istegroup.com\/en\/produit\/sql-analytique-dans-sql-server-2014-2016\/#primaryimage","url":"https:\/\/www.istegroup.com\/wp-content\/uploads\/2019\/07\/SQL-Analytique-dans-SQL-Server.jpg","contentUrl":"https:\/\/www.istegroup.com\/wp-content\/uploads\/2019\/07\/SQL-Analytique-dans-SQL-Server.jpg","width":300,"height":452,"caption":"SQL Analytique dans SQL Server 2014\/2016"},{"@type":"BreadcrumbList","@id":"https:\/\/www.istegroup.com\/en\/produit\/sql-analytique-dans-sql-server-2014-2016\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.istegroup.com\/"},{"@type":"ListItem","position":2,"name":"Shop","item":"https:\/\/www.istegroup.com\/fr\/nouveautes\/"},{"@type":"ListItem","position":3,"name":"SQL Analytique dans SQL Server 2014\/2016"}]},{"@type":"WebSite","@id":"https:\/\/www.istegroup.com\/#website","url":"https:\/\/www.istegroup.com\/","name":"ISTE Group","description":"Publishing Knowledge","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.istegroup.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/www.istegroup.com\/en\/wp-json\/wp\/v2\/product\/22199","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.istegroup.com\/en\/wp-json\/wp\/v2\/product"}],"about":[{"href":"https:\/\/www.istegroup.com\/en\/wp-json\/wp\/v2\/types\/product"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.istegroup.com\/en\/wp-json\/wp\/v2\/media\/22208"}],"wp:attachment":[{"href":"https:\/\/www.istegroup.com\/en\/wp-json\/wp\/v2\/media?parent=22199"}],"wp:term":[{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/www.istegroup.com\/en\/wp-json\/wp\/v2\/product_brand?post=22199"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/www.istegroup.com\/en\/wp-json\/wp\/v2\/product_cat?post=22199"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/www.istegroup.com\/en\/wp-json\/wp\/v2\/product_tag?post=22199"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}