{"id":564,"date":"2020-09-25T14:15:33","date_gmt":"2020-09-25T14:15:33","guid":{"rendered":"https:\/\/lucient.com\/es\/?post_type=books_publications&#038;p=564"},"modified":"2020-11-20T09:20:32","modified_gmt":"2020-11-20T09:20:32","slug":"exam-ref-70-761-querying-data-with-transact-sql","status":"publish","type":"books_publications","link":"https:\/\/lucient.com\/es\/libros_publicaciones\/exam-ref-70-761-querying-data-with-transact-sql\/","title":{"rendered":"Exam Ref 70-761 Querying Data with Transact-SQL"},"content":{"rendered":"\n<p>Prepare for Microsoft Exam 70-761 and help demonstrate your real-world mastery of SQL Server 2016, Transact-SQL data management, queries, and database programming. Designed for experienced IT professionals ready to advance their status, Exam Ref focuses on the critical-thinking and decision-making acumen needed for success at the MCSA level.<\/p>\n\n\n\n<div class=\"wp-block-buttons is-layout-flex wp-block-buttons-is-layout-flex\">\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link has-white-color has-text-color has-background\" href=\"https:\/\/www.amazon.com\/Exam-70-761-Querying-Data-Transact-SQL\/dp\/1509304339\/ref=sr_1_1?dchild=1&amp;keywords=1509304339&amp;qid=1592938245&amp;sr=8-1\" style=\"border-radius:5px;background-color:#a17df6\" target=\"_blank\" rel=\"noreferrer noopener\">Buy on Amazon<\/a><\/div>\n<\/div>\n\n\n\n<h3 class=\"wp-block-heading\">Focus on the expertise measured by these objectives:<\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li>Filter, sort, join, aggregate, and modify data<\/li><li>Use subqueries, table expressions, grouping sets, and pivoting<\/li><li>Query temporal and non-relational data, and output XML or JSON<\/li><li>Create views, user-defined functions, and stored procedures<\/li><li>Implement error handling, transactions, data types, and nulls<\/li><\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Prep\u00e1rese para el Examen de Microosft 70-761 y demuestre su maestr\u00eda en SQL Server 2016.<\/p>\n","protected":false},"featured_media":1450,"menu_order":30,"template":"","class_list":["post-564","books_publications","type-books_publications","status-publish","has-post-thumbnail","hentry"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Exam Ref 70-761 Querying Data with Transact-SQL - Lucient - Latinoam\u00e9rica<\/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:\/\/lucient.com\/es\/libros_publicaciones\/exam-ref-70-761-querying-data-with-transact-sql\/\" \/>\n<meta property=\"og:locale\" content=\"es_MX\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Exam Ref 70-761 Querying Data with Transact-SQL - Lucient - Latinoam\u00e9rica\" \/>\n<meta property=\"og:description\" content=\"Prep\u00e1rese para el Examen de Microosft 70-761 y demuestre su maestr\u00eda en SQL Server 2016.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/lucient.com\/es\/libros_publicaciones\/exam-ref-70-761-querying-data-with-transact-sql\/\" \/>\n<meta property=\"og:site_name\" content=\"Lucient - Latinoam\u00e9rica\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/LucientData\" \/>\n<meta property=\"article:modified_time\" content=\"2020-11-20T09:20:32+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/lucient.com\/es\/wp-content\/uploads\/sites\/4\/2020\/09\/Exam-Ref-70761-Querying-Data-with-Transact-SQL-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"450\" \/>\n\t<meta property=\"og:image:height\" content=\"450\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@lucient_data\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/lucient.com\\\/es\\\/libros_publicaciones\\\/exam-ref-70-761-querying-data-with-transact-sql\\\/\",\"url\":\"https:\\\/\\\/lucient.com\\\/es\\\/libros_publicaciones\\\/exam-ref-70-761-querying-data-with-transact-sql\\\/\",\"name\":\"Exam Ref 70-761 Querying Data with Transact-SQL - Lucient - Latinoam\u00e9rica\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/lucient.com\\\/es\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/lucient.com\\\/es\\\/libros_publicaciones\\\/exam-ref-70-761-querying-data-with-transact-sql\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/lucient.com\\\/es\\\/libros_publicaciones\\\/exam-ref-70-761-querying-data-with-transact-sql\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/lucient.com\\\/es\\\/wp-content\\\/uploads\\\/sites\\\/4\\\/2020\\\/09\\\/Exam-Ref-70761-Querying-Data-with-Transact-SQL-1.jpg\",\"datePublished\":\"2020-09-25T14:15:33+00:00\",\"dateModified\":\"2020-11-20T09:20:32+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/lucient.com\\\/es\\\/libros_publicaciones\\\/exam-ref-70-761-querying-data-with-transact-sql\\\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/lucient.com\\\/es\\\/libros_publicaciones\\\/exam-ref-70-761-querying-data-with-transact-sql\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/lucient.com\\\/es\\\/libros_publicaciones\\\/exam-ref-70-761-querying-data-with-transact-sql\\\/#primaryimage\",\"url\":\"https:\\\/\\\/lucient.com\\\/es\\\/wp-content\\\/uploads\\\/sites\\\/4\\\/2020\\\/09\\\/Exam-Ref-70761-Querying-Data-with-Transact-SQL-1.jpg\",\"contentUrl\":\"https:\\\/\\\/lucient.com\\\/es\\\/wp-content\\\/uploads\\\/sites\\\/4\\\/2020\\\/09\\\/Exam-Ref-70761-Querying-Data-with-Transact-SQL-1.jpg\",\"width\":450,\"height\":450},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/lucient.com\\\/es\\\/libros_publicaciones\\\/exam-ref-70-761-querying-data-with-transact-sql\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Inicio\",\"item\":\"https:\\\/\\\/lucient.com\\\/es\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Books &amp; Publications\",\"item\":\"https:\\\/\\\/lucient.com\\\/es\\\/libros_publicaciones\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Exam Ref 70-761 Querying Data with Transact-SQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/lucient.com\\\/es\\\/#website\",\"url\":\"https:\\\/\\\/lucient.com\\\/es\\\/\",\"name\":\"Lucient - Latinoam\u00e9rica\",\"description\":\"Potencie su empresa con inteligencia de negocios basada en datos\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/lucient.com\\\/es\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Exam Ref 70-761 Querying Data with Transact-SQL - Lucient - Latinoam\u00e9rica","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:\/\/lucient.com\/es\/libros_publicaciones\/exam-ref-70-761-querying-data-with-transact-sql\/","og_locale":"es_MX","og_type":"article","og_title":"Exam Ref 70-761 Querying Data with Transact-SQL - Lucient - Latinoam\u00e9rica","og_description":"Prep\u00e1rese para el Examen de Microosft 70-761 y demuestre su maestr\u00eda en SQL Server 2016.","og_url":"https:\/\/lucient.com\/es\/libros_publicaciones\/exam-ref-70-761-querying-data-with-transact-sql\/","og_site_name":"Lucient - Latinoam\u00e9rica","article_publisher":"https:\/\/www.facebook.com\/LucientData","article_modified_time":"2020-11-20T09:20:32+00:00","og_image":[{"width":450,"height":450,"url":"https:\/\/lucient.com\/es\/wp-content\/uploads\/sites\/4\/2020\/09\/Exam-Ref-70761-Querying-Data-with-Transact-SQL-1.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_site":"@lucient_data","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/lucient.com\/es\/libros_publicaciones\/exam-ref-70-761-querying-data-with-transact-sql\/","url":"https:\/\/lucient.com\/es\/libros_publicaciones\/exam-ref-70-761-querying-data-with-transact-sql\/","name":"Exam Ref 70-761 Querying Data with Transact-SQL - Lucient - Latinoam\u00e9rica","isPartOf":{"@id":"https:\/\/lucient.com\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/lucient.com\/es\/libros_publicaciones\/exam-ref-70-761-querying-data-with-transact-sql\/#primaryimage"},"image":{"@id":"https:\/\/lucient.com\/es\/libros_publicaciones\/exam-ref-70-761-querying-data-with-transact-sql\/#primaryimage"},"thumbnailUrl":"https:\/\/lucient.com\/es\/wp-content\/uploads\/sites\/4\/2020\/09\/Exam-Ref-70761-Querying-Data-with-Transact-SQL-1.jpg","datePublished":"2020-09-25T14:15:33+00:00","dateModified":"2020-11-20T09:20:32+00:00","breadcrumb":{"@id":"https:\/\/lucient.com\/es\/libros_publicaciones\/exam-ref-70-761-querying-data-with-transact-sql\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/lucient.com\/es\/libros_publicaciones\/exam-ref-70-761-querying-data-with-transact-sql\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/lucient.com\/es\/libros_publicaciones\/exam-ref-70-761-querying-data-with-transact-sql\/#primaryimage","url":"https:\/\/lucient.com\/es\/wp-content\/uploads\/sites\/4\/2020\/09\/Exam-Ref-70761-Querying-Data-with-Transact-SQL-1.jpg","contentUrl":"https:\/\/lucient.com\/es\/wp-content\/uploads\/sites\/4\/2020\/09\/Exam-Ref-70761-Querying-Data-with-Transact-SQL-1.jpg","width":450,"height":450},{"@type":"BreadcrumbList","@id":"https:\/\/lucient.com\/es\/libros_publicaciones\/exam-ref-70-761-querying-data-with-transact-sql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Inicio","item":"https:\/\/lucient.com\/es\/"},{"@type":"ListItem","position":2,"name":"Books &amp; Publications","item":"https:\/\/lucient.com\/es\/libros_publicaciones\/"},{"@type":"ListItem","position":3,"name":"Exam Ref 70-761 Querying Data with Transact-SQL"}]},{"@type":"WebSite","@id":"https:\/\/lucient.com\/es\/#website","url":"https:\/\/lucient.com\/es\/","name":"Lucient - Latinoam\u00e9rica","description":"Potencie su empresa con inteligencia de negocios basada en datos","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/lucient.com\/es\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"}]}},"_links":{"self":[{"href":"https:\/\/lucient.com\/es\/wp-json\/wp\/v2\/books_publications\/564","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/lucient.com\/es\/wp-json\/wp\/v2\/books_publications"}],"about":[{"href":"https:\/\/lucient.com\/es\/wp-json\/wp\/v2\/types\/books_publications"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/lucient.com\/es\/wp-json\/wp\/v2\/media\/1450"}],"wp:attachment":[{"href":"https:\/\/lucient.com\/es\/wp-json\/wp\/v2\/media?parent=564"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}