{"id":5504,"date":"2016-06-29T10:52:45","date_gmt":"2016-06-29T13:52:45","guid":{"rendered":"http:\/\/www.fabriciolima.net\/?p=5504"},"modified":"2016-07-23T14:49:40","modified_gmt":"2016-07-23T17:49:40","slug":"certificacoes-do-sql-server-2016","status":"publish","type":"post","link":"https:\/\/fabriciolima.net\/blog\/2016\/06\/29\/certificacoes-do-sql-server-2016\/","title":{"rendered":"Certifica\u00e7\u00f5es do SQL Server 2016"},"content":{"rendered":"<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-5506 size-full aligncenter\" src=\"https:\/\/www.fabriciolima.net\/blog\/wp-content\/uploads\/2016\/06\/certificacao.jpg\" alt=\"certificacao\" width=\"318\" height=\"159\" srcset=\"https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2016\/06\/certificacao.jpg 318w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2016\/06\/certificacao-300x150.jpg 300w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2016\/06\/certificacao-100x50.jpg 100w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2016\/06\/certificacao-275x138.jpg 275w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2016\/06\/certificacao-20x10.jpg 20w\" sizes=\"auto, (max-width: 318px) 100vw, 318px\" \/><\/p>\n<p>Ol\u00e1 Pessoal,<\/p>\n<p>Acabei de ver no artigo abaixo informa\u00e7\u00f5es sobre as certifica\u00e7\u00f5es do SQL Server 2016:<\/p>\n<p><a href=\"https:\/\/borntolearn.mslearn.net\/b\/weblog\/posts\/certification-update-sql-2016\" target=\"_blank\">https:\/\/borntolearn.mslearn.net\/b\/weblog\/posts\/certification-update-sql-2016<\/a><\/p>\n<p>Para facilitar seu entendimento sobre certifica\u00e7\u00f5es, elas foram alteradas novamente&#8230; rsrs<\/p>\n<p>Agora temos o seguinte:<\/p>\n<h5>MCSA: SQL 2016 Database Development<\/h5>\n<h6>Provas:<\/h6>\n<ul>\n<li><b>70-761 &#8211;<\/b> Querying Data with Transact-SQL<\/li>\n<li><b>70-762 &#8211;<\/b> Developing SQL Databases<\/li>\n<\/ul>\n<p>Se voc\u00ea j\u00e1 \u00e9 MCSA no 2012\/2014 poder\u00e1 fazer um upgrade com a prova 70-762.<\/p>\n<h5>MCSA: SQL 2016 Database Administration<\/h5>\n<h6>Provas:<\/h6>\n<ul>\n<li><b>70-764<\/b> &#8211; Administering a SQL Database Infrastructure<\/li>\n<li><b>70-765<\/b> &#8211; Provisioning SQL Databases<\/li>\n<\/ul>\n<p>Se voc\u00ea j\u00e1 \u00e9 MCSA no 2012\/2014 poder\u00e1 fazer um upgrade com a prova 70-765.<\/p>\n<h5>MCSA: SQL 2016 Business Intelligence Development<\/h5>\n<h6>Provas:<\/h6>\n<ul>\n<li><b>70-767<\/b> &#8211; Implementing a SQL Data Warehouse<\/li>\n<li><b>70-768<\/b> &#8211; Developing SQL Data Models<\/li>\n<\/ul>\n<p>Se voc\u00ea j\u00e1 \u00e9 MCSA no 2012\/2014 poder\u00e1 fazer um upgrade com a prova 70-768.<\/p>\n<hr>\n<p>&nbsp;<\/p>\n<p>Ou seja, se voc\u00ea quiser tirar todas as certifica\u00e7\u00f5es <strong>MCSA<\/strong> e est\u00e1 come\u00e7ando agora, ter\u00e1 que fazer <strong>6 provas<\/strong>. Se j\u00e1 tinha um <strong>MCSA<\/strong>, ter\u00e1 que fazer <strong>3 provas<\/strong>.<\/p>\n<p>A dica \u00e9 fazer as provas da sua \u00e1rea primeiro <strong>(DBA, DEV ou BI)<\/strong> e, se tiver condi\u00e7\u00f5es <strong>(Tempo x Dinheiro)<\/strong>, partir para uma segunda e terceira \u00e1rea de seu interesse.<\/p>\n<p>No meu caso, come\u00e7arei pelas provas de <strong>DBA<\/strong> e depois de <strong>DEV<\/strong>. <strong>BI<\/strong> nesse momento n\u00e3o est\u00e1 no meu planejamento, mas quem sabe no futuro.<\/p>\n<p>As \u00fanicas informa\u00e7\u00f5es que vi sobre essas certifica\u00e7\u00f5es est\u00e3o nesse link que coloquei no in\u00edcio do post. Assim que tiver mais detalhes sobre materias de estudo e sobre as certifica\u00e7\u00f5es para <strong>MCSE<\/strong> do <strong>SQL Server 2016<\/strong>, atualizo nesse post. Fique ligado!<\/p>\n<p>As provas <strong>70-461, 70-462 e 70-463 do SQL 2012\/2014<\/strong> ainda v\u00e3o continuar da mesma forma como as provas do SQL 2008 continuaram dispon\u00edveis por um bom tempo ap\u00f3s o lan\u00e7amento do 2012\/2014.<\/p>\n<p><b>Gostou desse Post?<\/b><\/p>\n<p>Cadastre seu e-mail para receber novos Posts e curta minha <a href=\"https:\/\/www.facebook.com\/FabricioLimaSolucoesemBancodeDados\/\" target=\"_blank\">P\u00e1gina no Facebook<\/a> para receber Dicas de Leituras e Eventos sobre SQL Server.<\/p>\n<p>Abra\u00e7os,<\/p>\n<p>Fabr\u00edcio Lima<\/p>\n<p>MCITP \u2013 Database Administrator<\/p>\n<p>Consultor e Instrutor SQL Server<\/p>\n<p>Trabalha com SQL Server desde 2006<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ol\u00e1 Pessoal, Acabei de ver no artigo abaixo informa\u00e7\u00f5es sobre as certifica\u00e7\u00f5es do SQL Server 2016: https:\/\/borntolearn.mslearn.net\/b\/weblog\/posts\/certification-update-sql-2016 Para facilitar seu entendimento sobre certifica\u00e7\u00f5es, elas foram alteradas novamente&#8230; rsrs Agora temos o seguinte: MCSA: SQL 2016 Database Development Provas: 70-761 &#8211; Querying Data with Transact-SQL 70-762 &#8211; Developing SQL Databases Se voc\u00ea j\u00e1 \u00e9 MCSA no [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","jetpack_post_was_ever_published":false},"categories":[3,332,5,636,17,33],"tags":[1341,17,1340,1343,1344,977,1342],"class_list":["post-5504","post","type-post","status-publish","format-standard","hentry","category-administracao-de-bd","category-business-intelligence","category-carreira","category-certificacao-2","category-certificacao","category-sql-server","tag-certificacao-sql-2016","tag-certificacao","tag-certificacao-sql-server-2016","tag-mcsa-sql-server","tag-mcsa-sql-server-2016","tag-mcse-sql-server","tag-upgrade-certificacoes-sql-2016"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.9 - aioseo.com -->\n\t<meta name=\"description\" content=\"Ol\u00e1 Pessoal, Acabei de ver no artigo abaixo informa\u00e7\u00f5es sobre as certifica\u00e7\u00f5es do SQL Server 2016: https:\/\/borntolearn.mslearn.net\/b\/weblog\/posts\/certification-update-sql-2016 Para facilitar seu entendimento sobre certifica\u00e7\u00f5es, elas foram alteradas novamente... rsrs Agora temos o seguinte: MCSA: SQL 2016 Database Development Provas: 70-761 - Querying Data with Transact-SQL 70-762 - Developing SQL Databases Se voc\u00ea j\u00e1 \u00e9 MCSA no\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Fabr\u00edcio Lima\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/fabriciolima.net\/blog\/2016\/06\/29\/certificacoes-do-sql-server-2016\/\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.9\" \/>\n\t\t<meta property=\"og:locale\" content=\"pt_BR\" \/>\n\t\t<meta property=\"og:site_name\" content=\"Fabricio Lima | Neg\u00f3cios, Dados e IA - Insights pr\u00e1ticos sobre neg\u00f3cios, dados e intelig\u00eancia artificial.\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"Certifica\u00e7\u00f5es do SQL Server 2016 - Fabricio Lima | Neg\u00f3cios, Dados e IA\" \/>\n\t\t<meta property=\"og:description\" content=\"Ol\u00e1 Pessoal, Acabei de ver no artigo abaixo informa\u00e7\u00f5es sobre as certifica\u00e7\u00f5es do SQL Server 2016: https:\/\/borntolearn.mslearn.net\/b\/weblog\/posts\/certification-update-sql-2016 Para facilitar seu entendimento sobre certifica\u00e7\u00f5es, elas foram alteradas novamente... rsrs Agora temos o seguinte: MCSA: SQL 2016 Database Development Provas: 70-761 - Querying Data with Transact-SQL 70-762 - Developing SQL Databases Se voc\u00ea j\u00e1 \u00e9 MCSA no\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/fabriciolima.net\/blog\/2016\/06\/29\/certificacoes-do-sql-server-2016\/\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2016-06-29T13:52:45+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2016-07-23T17:49:40+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n\t\t<meta name=\"twitter:title\" content=\"Certifica\u00e7\u00f5es do SQL Server 2016 - Fabricio Lima | Neg\u00f3cios, Dados e IA\" \/>\n\t\t<meta name=\"twitter:description\" content=\"Ol\u00e1 Pessoal, Acabei de ver no artigo abaixo informa\u00e7\u00f5es sobre as certifica\u00e7\u00f5es do SQL Server 2016: https:\/\/borntolearn.mslearn.net\/b\/weblog\/posts\/certification-update-sql-2016 Para facilitar seu entendimento sobre certifica\u00e7\u00f5es, elas foram alteradas novamente... rsrs Agora temos o seguinte: MCSA: SQL 2016 Database Development Provas: 70-761 - Querying Data with Transact-SQL 70-762 - Developing SQL Databases Se voc\u00ea j\u00e1 \u00e9 MCSA no\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"BlogPosting\",\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/2016\\\/06\\\/29\\\/certificacoes-do-sql-server-2016\\\/#blogposting\",\"name\":\"Certifica\\u00e7\\u00f5es do SQL Server 2016 - Fabricio Lima | Neg\\u00f3cios, Dados e IA\",\"headline\":\"Certifica\\u00e7\\u00f5es do SQL Server 2016\",\"author\":{\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/author\\\/fabricio\\\/#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/#organization\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/www.fabriciolima.net\\\/blog\\\/wp-content\\\/uploads\\\/2016\\\/06\\\/certificacao.jpg\",\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/2016\\\/06\\\/29\\\/certificacoes-do-sql-server-2016\\\/#articleImage\"},\"datePublished\":\"2016-06-29T10:52:45-03:00\",\"dateModified\":\"2016-07-23T14:49:40-03:00\",\"inLanguage\":\"pt-BR\",\"commentCount\":38,\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/2016\\\/06\\\/29\\\/certificacoes-do-sql-server-2016\\\/#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/2016\\\/06\\\/29\\\/certificacoes-do-sql-server-2016\\\/#webpage\"},\"articleSection\":\"Administra\\u00e7\\u00e3o de Banco de Dados, Business Intelligence, Carreira, Certifica\\u00e7\\u00e3o, Certifica\\u00e7\\u00e3o SQL Server, SQL Server, certifica\\u00e7\\u00e3o SQL 2016, Certifica\\u00e7\\u00e3o SQL Server, certificacao sql server 2016, mcsa sql server, mcsa sql server 2016, mcse sql server, upgrade certifica\\u00e7\\u00f5es sql 2016\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/2016\\\/06\\\/29\\\/certificacoes-do-sql-server-2016\\\/#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/fabriciolima.net\\\/blog\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/category\\\/sql-server\\\/#listItem\",\"name\":\"SQL Server\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/category\\\/sql-server\\\/#listItem\",\"position\":2,\"name\":\"SQL Server\",\"item\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/category\\\/sql-server\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/category\\\/sql-server\\\/administracao-de-bd\\\/#listItem\",\"name\":\"Administra\\u00e7\\u00e3o de Banco de Dados\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/category\\\/sql-server\\\/administracao-de-bd\\\/#listItem\",\"position\":3,\"name\":\"Administra\\u00e7\\u00e3o de Banco de Dados\",\"item\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/category\\\/sql-server\\\/administracao-de-bd\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/2016\\\/06\\\/29\\\/certificacoes-do-sql-server-2016\\\/#listItem\",\"name\":\"Certifica\\u00e7\\u00f5es do SQL Server 2016\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/category\\\/sql-server\\\/#listItem\",\"name\":\"SQL Server\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/2016\\\/06\\\/29\\\/certificacoes-do-sql-server-2016\\\/#listItem\",\"position\":4,\"name\":\"Certifica\\u00e7\\u00f5es do SQL Server 2016\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/category\\\/sql-server\\\/administracao-de-bd\\\/#listItem\",\"name\":\"Administra\\u00e7\\u00e3o de Banco de Dados\"}}]},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/#organization\",\"name\":\"Fabricio Lima | Neg\\u00f3cios, Dados e IA\",\"description\":\"Insights pr\\u00e1ticos sobre neg\\u00f3cios, dados e intelig\\u00eancia artificial.\",\"url\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/author\\\/fabricio\\\/#author\",\"url\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/author\\\/fabricio\\\/\",\"name\":\"Fabr\\u00edcio Lima\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/2016\\\/06\\\/29\\\/certificacoes-do-sql-server-2016\\\/#authorImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/bf37320f6a46a98e189640eb70a8304c0ab624d1d7508cea5e99f626f4d56829?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"Fabr\\u00edcio Lima\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/2016\\\/06\\\/29\\\/certificacoes-do-sql-server-2016\\\/#webpage\",\"url\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/2016\\\/06\\\/29\\\/certificacoes-do-sql-server-2016\\\/\",\"name\":\"Certifica\\u00e7\\u00f5es do SQL Server 2016 - Fabricio Lima | Neg\\u00f3cios, Dados e IA\",\"description\":\"Ol\\u00e1 Pessoal, Acabei de ver no artigo abaixo informa\\u00e7\\u00f5es sobre as certifica\\u00e7\\u00f5es do SQL Server 2016: https:\\\/\\\/borntolearn.mslearn.net\\\/b\\\/weblog\\\/posts\\\/certification-update-sql-2016 Para facilitar seu entendimento sobre certifica\\u00e7\\u00f5es, elas foram alteradas novamente... rsrs Agora temos o seguinte: MCSA: SQL 2016 Database Development Provas: 70-761 - Querying Data with Transact-SQL 70-762 - Developing SQL Databases Se voc\\u00ea j\\u00e1 \\u00e9 MCSA no\",\"inLanguage\":\"pt-BR\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/2016\\\/06\\\/29\\\/certificacoes-do-sql-server-2016\\\/#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/author\\\/fabricio\\\/#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/author\\\/fabricio\\\/#author\"},\"datePublished\":\"2016-06-29T10:52:45-03:00\",\"dateModified\":\"2016-07-23T14:49:40-03:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/\",\"name\":\"Fabricio Lima | Neg\\u00f3cios, Dados e IA\",\"description\":\"Insights pr\\u00e1ticos sobre neg\\u00f3cios, dados e intelig\\u00eancia artificial.\",\"inLanguage\":\"pt-BR\",\"publisher\":{\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/#organization\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"Certifica\u00e7\u00f5es do SQL Server 2016 - Fabricio Lima | Neg\u00f3cios, Dados e IA","description":"Ol\u00e1 Pessoal, Acabei de ver no artigo abaixo informa\u00e7\u00f5es sobre as certifica\u00e7\u00f5es do SQL Server 2016: https:\/\/borntolearn.mslearn.net\/b\/weblog\/posts\/certification-update-sql-2016 Para facilitar seu entendimento sobre certifica\u00e7\u00f5es, elas foram alteradas novamente... rsrs Agora temos o seguinte: MCSA: SQL 2016 Database Development Provas: 70-761 - Querying Data with Transact-SQL 70-762 - Developing SQL Databases Se voc\u00ea j\u00e1 \u00e9 MCSA no","canonical_url":"https:\/\/fabriciolima.net\/blog\/2016\/06\/29\/certificacoes-do-sql-server-2016\/","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"BlogPosting","@id":"https:\/\/fabriciolima.net\/blog\/2016\/06\/29\/certificacoes-do-sql-server-2016\/#blogposting","name":"Certifica\u00e7\u00f5es do SQL Server 2016 - Fabricio Lima | Neg\u00f3cios, Dados e IA","headline":"Certifica\u00e7\u00f5es do SQL Server 2016","author":{"@id":"https:\/\/fabriciolima.net\/blog\/author\/fabricio\/#author"},"publisher":{"@id":"https:\/\/fabriciolima.net\/blog\/#organization"},"image":{"@type":"ImageObject","url":"https:\/\/www.fabriciolima.net\/blog\/wp-content\/uploads\/2016\/06\/certificacao.jpg","@id":"https:\/\/fabriciolima.net\/blog\/2016\/06\/29\/certificacoes-do-sql-server-2016\/#articleImage"},"datePublished":"2016-06-29T10:52:45-03:00","dateModified":"2016-07-23T14:49:40-03:00","inLanguage":"pt-BR","commentCount":38,"mainEntityOfPage":{"@id":"https:\/\/fabriciolima.net\/blog\/2016\/06\/29\/certificacoes-do-sql-server-2016\/#webpage"},"isPartOf":{"@id":"https:\/\/fabriciolima.net\/blog\/2016\/06\/29\/certificacoes-do-sql-server-2016\/#webpage"},"articleSection":"Administra\u00e7\u00e3o de Banco de Dados, Business Intelligence, Carreira, Certifica\u00e7\u00e3o, Certifica\u00e7\u00e3o SQL Server, SQL Server, certifica\u00e7\u00e3o SQL 2016, Certifica\u00e7\u00e3o SQL Server, certificacao sql server 2016, mcsa sql server, mcsa sql server 2016, mcse sql server, upgrade certifica\u00e7\u00f5es sql 2016"},{"@type":"BreadcrumbList","@id":"https:\/\/fabriciolima.net\/blog\/2016\/06\/29\/certificacoes-do-sql-server-2016\/#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/fabriciolima.net\/blog#listItem","position":1,"name":"Home","item":"https:\/\/fabriciolima.net\/blog","nextItem":{"@type":"ListItem","@id":"https:\/\/fabriciolima.net\/blog\/category\/sql-server\/#listItem","name":"SQL Server"}},{"@type":"ListItem","@id":"https:\/\/fabriciolima.net\/blog\/category\/sql-server\/#listItem","position":2,"name":"SQL Server","item":"https:\/\/fabriciolima.net\/blog\/category\/sql-server\/","nextItem":{"@type":"ListItem","@id":"https:\/\/fabriciolima.net\/blog\/category\/sql-server\/administracao-de-bd\/#listItem","name":"Administra\u00e7\u00e3o de Banco de Dados"},"previousItem":{"@type":"ListItem","@id":"https:\/\/fabriciolima.net\/blog#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/fabriciolima.net\/blog\/category\/sql-server\/administracao-de-bd\/#listItem","position":3,"name":"Administra\u00e7\u00e3o de Banco de Dados","item":"https:\/\/fabriciolima.net\/blog\/category\/sql-server\/administracao-de-bd\/","nextItem":{"@type":"ListItem","@id":"https:\/\/fabriciolima.net\/blog\/2016\/06\/29\/certificacoes-do-sql-server-2016\/#listItem","name":"Certifica\u00e7\u00f5es do SQL Server 2016"},"previousItem":{"@type":"ListItem","@id":"https:\/\/fabriciolima.net\/blog\/category\/sql-server\/#listItem","name":"SQL Server"}},{"@type":"ListItem","@id":"https:\/\/fabriciolima.net\/blog\/2016\/06\/29\/certificacoes-do-sql-server-2016\/#listItem","position":4,"name":"Certifica\u00e7\u00f5es do SQL Server 2016","previousItem":{"@type":"ListItem","@id":"https:\/\/fabriciolima.net\/blog\/category\/sql-server\/administracao-de-bd\/#listItem","name":"Administra\u00e7\u00e3o de Banco de Dados"}}]},{"@type":"Organization","@id":"https:\/\/fabriciolima.net\/blog\/#organization","name":"Fabricio Lima | Neg\u00f3cios, Dados e IA","description":"Insights pr\u00e1ticos sobre neg\u00f3cios, dados e intelig\u00eancia artificial.","url":"https:\/\/fabriciolima.net\/blog\/"},{"@type":"Person","@id":"https:\/\/fabriciolima.net\/blog\/author\/fabricio\/#author","url":"https:\/\/fabriciolima.net\/blog\/author\/fabricio\/","name":"Fabr\u00edcio Lima","image":{"@type":"ImageObject","@id":"https:\/\/fabriciolima.net\/blog\/2016\/06\/29\/certificacoes-do-sql-server-2016\/#authorImage","url":"https:\/\/secure.gravatar.com\/avatar\/bf37320f6a46a98e189640eb70a8304c0ab624d1d7508cea5e99f626f4d56829?s=96&d=mm&r=g","width":96,"height":96,"caption":"Fabr\u00edcio Lima"}},{"@type":"WebPage","@id":"https:\/\/fabriciolima.net\/blog\/2016\/06\/29\/certificacoes-do-sql-server-2016\/#webpage","url":"https:\/\/fabriciolima.net\/blog\/2016\/06\/29\/certificacoes-do-sql-server-2016\/","name":"Certifica\u00e7\u00f5es do SQL Server 2016 - Fabricio Lima | Neg\u00f3cios, Dados e IA","description":"Ol\u00e1 Pessoal, Acabei de ver no artigo abaixo informa\u00e7\u00f5es sobre as certifica\u00e7\u00f5es do SQL Server 2016: https:\/\/borntolearn.mslearn.net\/b\/weblog\/posts\/certification-update-sql-2016 Para facilitar seu entendimento sobre certifica\u00e7\u00f5es, elas foram alteradas novamente... rsrs Agora temos o seguinte: MCSA: SQL 2016 Database Development Provas: 70-761 - Querying Data with Transact-SQL 70-762 - Developing SQL Databases Se voc\u00ea j\u00e1 \u00e9 MCSA no","inLanguage":"pt-BR","isPartOf":{"@id":"https:\/\/fabriciolima.net\/blog\/#website"},"breadcrumb":{"@id":"https:\/\/fabriciolima.net\/blog\/2016\/06\/29\/certificacoes-do-sql-server-2016\/#breadcrumblist"},"author":{"@id":"https:\/\/fabriciolima.net\/blog\/author\/fabricio\/#author"},"creator":{"@id":"https:\/\/fabriciolima.net\/blog\/author\/fabricio\/#author"},"datePublished":"2016-06-29T10:52:45-03:00","dateModified":"2016-07-23T14:49:40-03:00"},{"@type":"WebSite","@id":"https:\/\/fabriciolima.net\/blog\/#website","url":"https:\/\/fabriciolima.net\/blog\/","name":"Fabricio Lima | Neg\u00f3cios, Dados e IA","description":"Insights pr\u00e1ticos sobre neg\u00f3cios, dados e intelig\u00eancia artificial.","inLanguage":"pt-BR","publisher":{"@id":"https:\/\/fabriciolima.net\/blog\/#organization"}}]},"og:locale":"pt_BR","og:site_name":"Fabricio Lima | Neg\u00f3cios, Dados e IA - Insights pr\u00e1ticos sobre neg\u00f3cios, dados e intelig\u00eancia artificial.","og:type":"article","og:title":"Certifica\u00e7\u00f5es do SQL Server 2016 - Fabricio Lima | Neg\u00f3cios, Dados e IA","og:description":"Ol\u00e1 Pessoal, Acabei de ver no artigo abaixo informa\u00e7\u00f5es sobre as certifica\u00e7\u00f5es do SQL Server 2016: https:\/\/borntolearn.mslearn.net\/b\/weblog\/posts\/certification-update-sql-2016 Para facilitar seu entendimento sobre certifica\u00e7\u00f5es, elas foram alteradas novamente... rsrs Agora temos o seguinte: MCSA: SQL 2016 Database Development Provas: 70-761 - Querying Data with Transact-SQL 70-762 - Developing SQL Databases Se voc\u00ea j\u00e1 \u00e9 MCSA no","og:url":"https:\/\/fabriciolima.net\/blog\/2016\/06\/29\/certificacoes-do-sql-server-2016\/","article:published_time":"2016-06-29T13:52:45+00:00","article:modified_time":"2016-07-23T17:49:40+00:00","twitter:card":"summary_large_image","twitter:title":"Certifica\u00e7\u00f5es do SQL Server 2016 - Fabricio Lima | Neg\u00f3cios, Dados e IA","twitter:description":"Ol\u00e1 Pessoal, Acabei de ver no artigo abaixo informa\u00e7\u00f5es sobre as certifica\u00e7\u00f5es do SQL Server 2016: https:\/\/borntolearn.mslearn.net\/b\/weblog\/posts\/certification-update-sql-2016 Para facilitar seu entendimento sobre certifica\u00e7\u00f5es, elas foram alteradas novamente... rsrs Agora temos o seguinte: MCSA: SQL 2016 Database Development Provas: 70-761 - Querying Data with Transact-SQL 70-762 - Developing SQL Databases Se voc\u00ea j\u00e1 \u00e9 MCSA no"},"aioseo_meta_data":{"post_id":"5504","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_custom_url":null,"og_image_custom_fields":null,"og_image_url":null,"og_image_width":null,"og_image_height":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_image_url":null,"twitter_title":null,"twitter_description":null,"schema_type":"default","schema_type_options":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"limit_modified_date":false,"ai":null,"breadcrumb_settings":null,"seo_analyzer_scan_date":null,"created":"2026-07-04 23:39:59","updated":"2026-07-04 23:39:59"},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/fabriciolima.net\/blog\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/fabriciolima.net\/blog\/category\/sql-server\/\" title=\"SQL Server\">SQL Server<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/fabriciolima.net\/blog\/category\/sql-server\/administracao-de-bd\/\" title=\"Administra\u00e7\u00e3o de Banco de Dados\">Administra\u00e7\u00e3o de Banco de Dados<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tCertifica\u00e7\u00f5es do SQL Server 2016\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/fabriciolima.net\/blog"},{"label":"SQL Server","link":"https:\/\/fabriciolima.net\/blog\/category\/sql-server\/"},{"label":"Administra\u00e7\u00e3o de Banco de Dados","link":"https:\/\/fabriciolima.net\/blog\/category\/sql-server\/administracao-de-bd\/"},{"label":"Certifica\u00e7\u00f5es do SQL Server 2016","link":"https:\/\/fabriciolima.net\/blog\/2016\/06\/29\/certificacoes-do-sql-server-2016\/"}],"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":2253,"url":"https:\/\/fabriciolima.net\/blog\/2013\/08\/03\/material-para-as-certificacoes-mcsa-e-mcse-do-sql-server-2012\/","url_meta":{"origin":5504,"position":0},"title":"Material para as Certifica\u00e7\u00f5es MCSA e MCSE do SQL Server 2012\/2014","author":"Fabr\u00edcio Lima","date":"3 de agosto de 2013","format":false,"excerpt":"Ol\u00e1 Pessoal, Ap\u00f3s um longo tempo afastado devido a prioriza\u00e7\u00e3o de outras atividades profissionais e pessoais, volto com um post que ainda estava em falta no meu Blog que \u00e9 sobre as certifica\u00e7\u00f5es do SQL Server 2012. Para a tristeza de muitos o SQL Server 2014 j\u00e1 est\u00e1 a\u00ed batendo\u2026","rel":"","context":"Em &quot;Administra\u00e7\u00e3o de Banco de Dados&quot;","block_context":{"text":"Administra\u00e7\u00e3o de Banco de Dados","link":"https:\/\/fabriciolima.net\/blog\/category\/sql-server\/administracao-de-bd\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.fabriciolima.net\/blog\/wp-content\/uploads\/2013\/08\/Caminho.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.fabriciolima.net\/blog\/wp-content\/uploads\/2013\/08\/Caminho.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/www.fabriciolima.net\/blog\/wp-content\/uploads\/2013\/08\/Caminho.png?resize=525%2C300&ssl=1 1.5x"},"classes":[]},{"id":2928,"url":"https:\/\/fabriciolima.net\/blog\/2014\/04\/27\/como-serao-as-certificacoes-do-sql-server-2014\/","url_meta":{"origin":5504,"position":1},"title":"Como ser\u00e3o as certifica\u00e7\u00f5es do SQL Server 2014?","author":"Fabr\u00edcio Lima","date":"27 de abril de 2014","format":false,"excerpt":"Ol\u00e1 Pessoal, Sexta-feira estive no evento oficial de lan\u00e7amento do SQL Server no Brasil na sede da Microsoft em S\u00e3o Paulo. Foi falado bastante sobre as novas funcionalidades do SQL 2014, contudo, ningu\u00e9m tocou no assunto certifica\u00e7\u00e3o. Me passaram um link da microsoft muito interessante onde na parte de perguntas\u2026","rel":"","context":"Em &quot;Administra\u00e7\u00e3o de Banco de Dados&quot;","block_context":{"text":"Administra\u00e7\u00e3o de Banco de Dados","link":"https:\/\/fabriciolima.net\/blog\/category\/sql-server\/administracao-de-bd\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2512,"url":"https:\/\/fabriciolima.net\/blog\/2013\/11\/28\/sql-server-2012-simulado-para-a-prova-70-461-parte-8\/","url_meta":{"origin":5504,"position":2},"title":"SQL Server 2012 \u2013 Simulado para a prova 70-461 \u2013 Parte 8","author":"Fabr\u00edcio Lima","date":"28 de novembro de 2013","format":false,"excerpt":"Ol\u00e1 Pessoal, Segue mais um simulado com 5 quest\u00f5es para a Prova 70-461 - Querying Microsoft SQL Server 2012\/2014 \u00a0 1) Qual tipo de dados voc\u00ea deve utilizar no lugar do tipo TIMESTAMP que ser\u00e1 descontinuado? A - VARBINARY B - ROWVERSION C - DATETIME2 D - TIME 2) Qual\u2026","rel":"","context":"Em &quot;Certifica\u00e7\u00e3o&quot;","block_context":{"text":"Certifica\u00e7\u00e3o","link":"https:\/\/fabriciolima.net\/blog\/category\/certificacao-2\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2498,"url":"https:\/\/fabriciolima.net\/blog\/2013\/11\/26\/sql-server-2012-simulado-para-a-prova-70-461-parte-7\/","url_meta":{"origin":5504,"position":3},"title":"SQL Server 2012 \u2013 Simulado para a prova 70-461 \u2013 Parte 7","author":"Fabr\u00edcio Lima","date":"26 de novembro de 2013","format":false,"excerpt":"Ol\u00e1 Pessoal, Segue mais um simulado com 5 quest\u00f5es para a Prova 70-461 - Querying Microsoft SQL Server 2012\/2014 \u00a0 1) Qual das alternativas abaixo n\u00e3o \u00e9 uma cl\u00e1usula FLWOR? (cap\u00edtulo de XML) A - for B - let C - where D - over E - return 2) Qual\u2026","rel":"","context":"Em &quot;Certifica\u00e7\u00e3o&quot;","block_context":{"text":"Certifica\u00e7\u00e3o","link":"https:\/\/fabriciolima.net\/blog\/category\/certificacao-2\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2480,"url":"https:\/\/fabriciolima.net\/blog\/2013\/11\/21\/sql-server-2012-simulado-para-a-prova-70-461-parte-6\/","url_meta":{"origin":5504,"position":4},"title":"SQL Server 2012 \u2013 Simulado para a prova 70-461 \u2013 Parte 6","author":"Fabr\u00edcio Lima","date":"21 de novembro de 2013","format":false,"excerpt":"Ol\u00e1 Pessoal, Segue mais um simulado com 5 quest\u00f5es para a Prova 70-461 - Querying Microsoft SQL Server 2012\/2014 \u00a0 1) Como voc\u00ea procura pelo sin\u00f4nimo de uma palavra com o predicado CONTAINS? A - CONTAINS(FTcolumn, \u2018FORMSOF(THESAURUS,PalavraProcurada)\u2019) B - CONTAINS (PROPERTY (FT column, \u2018PropertyName\u2019),\u2018PalavraProcurada\u2019) C - CONTAINS (FT column, \u2018FORMSOF(INFLECTIONAL,PalavraProcurada)\u2019)\u2026","rel":"","context":"Em &quot;Certifica\u00e7\u00e3o&quot;","block_context":{"text":"Certifica\u00e7\u00e3o","link":"https:\/\/fabriciolima.net\/blog\/category\/certificacao-2\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2527,"url":"https:\/\/fabriciolima.net\/blog\/2013\/12\/04\/sql-server-2012-simulado-para-a-prova-70-461-parte-9\/","url_meta":{"origin":5504,"position":5},"title":"SQL Server 2012 \u2013 Simulado para a prova 70-461 \u2013 Parte 9","author":"Fabr\u00edcio Lima","date":"4 de dezembro de 2013","format":false,"excerpt":"Ol\u00e1 Pessoal, Segue mais um simulado com 5 quest\u00f5es para a Prova 70-461 - Querying Microsoft SQL Server 2012\/2014 \u00a0 1) Quais s\u00e3o os objetos que o comando SELECT INTO n\u00e3o copia para a tabela de destino? (Marque todas as corretas.) A - Indexes B - Constraints C - A\u2026","rel":"","context":"Em &quot;Certifica\u00e7\u00e3o&quot;","block_context":{"text":"Certifica\u00e7\u00e3o","link":"https:\/\/fabriciolima.net\/blog\/category\/certificacao-2\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"post_mailing_queue_ids":[],"_links":{"self":[{"href":"https:\/\/fabriciolima.net\/blog\/wp-json\/wp\/v2\/posts\/5504","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/fabriciolima.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/fabriciolima.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/fabriciolima.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/fabriciolima.net\/blog\/wp-json\/wp\/v2\/comments?post=5504"}],"version-history":[{"count":0,"href":"https:\/\/fabriciolima.net\/blog\/wp-json\/wp\/v2\/posts\/5504\/revisions"}],"wp:attachment":[{"href":"https:\/\/fabriciolima.net\/blog\/wp-json\/wp\/v2\/media?parent=5504"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fabriciolima.net\/blog\/wp-json\/wp\/v2\/categories?post=5504"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fabriciolima.net\/blog\/wp-json\/wp\/v2\/tags?post=5504"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}