{"id":1931,"date":"2019-08-08T06:58:54","date_gmt":"2019-08-08T06:58:54","guid":{"rendered":"https:\/\/www.testpreptraining.com\/tutorial\/?page_id=1931"},"modified":"2021-05-27T13:53:26","modified_gmt":"2021-05-27T13:53:26","slug":"exam-70-761-querying-data-with-transact-sql","status":"publish","type":"page","link":"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-761-querying-data-with-transact-sql\/","title":{"rendered":"Exam 70-761: Querying Data with Transact-SQL"},"content":{"rendered":"\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"750\" height=\"400\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/06\/Querying-Data-with-Transact-SQL-70-761.png\" alt=\"\" class=\"wp-image-6632\"\/><\/figure><\/div>\n\n\n\n<p>Certifications from Microsoft provide you with a professional edge by demonstrating your skills and abilities to embrace new technologies. By being globally recognised, these certifications verify your skills and unlock an avenue of opportunities for you.<\/p>\n\n\n\n<p>The <a href=\"https:\/\/www.testpreptraining.ai\/querying-data-with-transact-sql-70-761-exam\" target=\"_blank\" rel=\"noreferrer noopener\">Microsoft Querying Data with Transact-SQL 70-761<\/a> exam helps you validate your skills and knowledge that is necessary to manage and query data and to program databases. This exam covers a vast syllabus and thus requires deep learning.&nbsp; The Microsoft 70-761 exam will catapult your career and help you achieve new heights.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>What is Microsoft 70-761 Exam?<\/strong><\/h3>\n\n\n\n<p>Microsoft Querying Data with Transact-SQL 70-761 exam is one of the first exams related to querying data with Transact in SQL Server. This exam validates your mastery of SQL Server 2016 Transact- SQL data management, database programming and queries.<\/p>\n\n\n\n<p>This exam is designed for IT professionals who are willing to advance their status by focusing on the critical-thinking and decision-making acumen needed for success at the MCSA level.<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"How to prepare for Exam 70-761 ?\" width=\"640\" height=\"360\" src=\"https:\/\/www.youtube.com\/embed\/liikH3c60TM?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Why Choose Microsoft 70-761 Exam?<\/strong><\/h3>\n\n\n\n<p>The Microsoft 70-761 is a highly acclaimed certification. This exam makes your resume shine and grabs the attention of your potential employers. The benefits of Microsoft 70-761 Exam are-<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>This certification validates your mastery in SQL Server 2016 Transact<\/li><li>Microsoft Certification enhances your employability and makes you job ready.<\/li><li>It also helps you chase further advanced goals in the field of IT.<\/li><li>This certification guarantees high growth opportunities. About 23% of Microsoft certified professionals reported receiving up to a 20% salary increase.<\/li><li>Microsoft Certifications provide you with a competitive edge over non certified candidates. It is estimated that certified employees earn 15% more than those without certification and are nearly 20% more productive.<\/li><li>You\u2019ll make immediate impact as a Microsoft Certified Professional. This credential will help you in getting noticed and bring recognition.<\/li><\/ul>\n\n\n\n<p>Also most importantly, once you\u2019re certified you will be able to share your achievements through your Microsoft Badge. This Microsoft Badge can be shared online within your professional network as it trusted and verifiable. It also helps find jobs easily and increases your salary potential.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/i2.wp.com\/jonshaulis.com\/wp-content\/uploads\/2018\/07\/exam-761-querying-data-with-transact-sql-1.png?resize=300%2C300&amp;ssl=1\" alt=\"Microsoft 70-761 exam, Querying with Transact-SQL badge\" width=\"206\" height=\"206\"\/><\/figure><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Microsoft Certification<\/strong> <strong>Details<\/strong><\/h3>\n\n\n\n<p>The Microsoft 70-761 exam is your first step towards earning the MCSA certification.<\/p>\n\n\n\n<p>On successful completion of both Microsoft 70-761: Querying Data with Transact-SQL and Microsoft 70-762: Developing SQL Databases you will achieve the Expert Certification of MCSA: SQL 2016 Database Development.<\/p>\n\n\n\n<p>The MCSA: SQL 2016 Database Development demonstrates your skills as a database professional, for both on-premises and cloud-based databases.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/06\/70-750x255.png\" alt=\"Microsoft 70-761 MCSA\" class=\"wp-image-6634\" width=\"614\" height=\"209\" srcset=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/06\/70-750x255.png 750w, https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/06\/70.png 779w\" sizes=\"auto, (max-width: 614px) 100vw, 614px\" \/><\/figure><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Objectives of Microsoft 70-761<\/strong><\/h3>\n\n\n\n<p>Microsoft Querying Data with Transact-SQL 70-761 exam focuses on the following objectives-<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Filter, sort, join, aggregate, and modify data<\/li><li>Use sub queries, 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\n\n\n<h3 class=\"wp-block-heading\"><strong>Exam Details<\/strong><\/h3>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"750\" height=\"400\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/06\/Exam-Details-5.png\" alt=\"Exam Details about Microsoft 70-761 Exam\" class=\"wp-image-6630\"\/><\/figure><\/div>\n\n\n\n<p>The Microsoft 70-761 Exam is definitely your way ahead to become a Microsoft Certified MCSA Expert. Following are some basic details about the exam.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/06\/nfkdsj-750x202.png\" alt=\"\" class=\"wp-image-6631\" width=\"823\" height=\"222\" srcset=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/06\/nfkdsj-750x202.png 750w, https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/06\/nfkdsj.png 775w\" sizes=\"auto, (max-width: 823px) 100vw, 823px\" \/><\/figure><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Target Audience<\/strong><\/h3>\n\n\n\n<p>This exam is intended for SQL Server database administrators, system engineers, and developers who are seeking to validate their skills and knowledge in writing queries<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Prerequisite<\/strong> <strong>for Microsoft 70-761 Exam<\/strong><\/h3>\n\n\n\n<p>The candidate must have an experience of two or more years in Microsoft SQL Server.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>How to Schedule the exam?<\/strong><\/h3>\n\n\n\n<p>The Microsoft Querying Data with Transact-SQL 70-761 exam is built to test your abilities of SQL Server 2016 Transact- SQL data management, database programming and queries. The exam can be scheduled as<\/p>\n\n\n\n<p>For non-students interested in technology at Pearson Vue<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"245\" height=\"48\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/06\/image-2-1.png\" alt=\"\" class=\"wp-image-6638\"\/><\/figure>\n\n\n\n<p>For students or instructors at Certiport<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"216\" height=\"44\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/06\/image-3-1.png\" alt=\"\" class=\"wp-image-6639\"\/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Exam retake policy<\/strong><\/h3>\n\n\n\n<p>Microsoft allows 5 attempts per year for a specific exam. The exam retake policy for Microsoft 70-761 Exam is as follows-<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>If a candidate is not able to clear the exam in the first attempt, the candidate must wait at least 24 hours before retaking the exam.<\/li><li>If a candidate does not clear the exam the second time, candidate must wait at least 14 days before retaking the exam a third time.<\/li><li>A 14-day waiting period is also there for the fourth and fifth subsequent exam retakes.<\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Cancellation and Reschedule Policy:<\/strong> <strong>Microsoft 70-761 Exam<\/strong><\/h3>\n\n\n\n<p>Microsoft allows free cancelling of the Exam within 24 hours prior to your scheduled appointment.<\/p>\n\n\n\n<p>But, if you fail to show up on your exam day without rescheduling or cancelling your exam, Microsoft reserves all rights to forfeit your entire exam fee.<\/p>\n\n\n\n<p>Rescheduling and Cancellation of your scheduled exams can be done through the <a href=\"https:\/\/www.microsoft.com\/learning\/dashboard.aspx\" target=\"_blank\" rel=\"noreferrer noopener\">Certification Dashboard.<\/a><\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Exam FAQ<\/strong><\/h3>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>For more queries visit: <a href=\"https:\/\/www.testpreptraining.ai\/tutorial\/microsoft-70-761-exam-faqs\/\" target=\"_blank\" rel=\"noreferrer noopener\">Microsoft 70-761 Exam FAQ&#8217;s<\/a><\/strong><\/h4>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><a href=\"https:\/\/www.testpreptraining.ai\/tutorial\/microsoft-70-761-exam-faqs\/\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" width=\"750\" height=\"400\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/06\/Microsoft-70-761-Exam-Faq.png\" alt=\"Microsoft 70-761 Exam FAQ\" class=\"wp-image-6623\"\/><\/a><\/figure><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Exam Course<\/strong><\/h3>\n\n\n\n<p>The Microsoft 70-761 Exam covers the following domains. Percentage against each domain represents its weight age in the exam.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/06\/course-673x400.png\" alt=\"Microsoft 70-761 Exam Course\" class=\"wp-image-6635\" width=\"403\" height=\"240\" srcset=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/06\/course-673x400.png 673w, https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/06\/course.png 917w\" sizes=\"auto, (max-width: 403px) 100vw, 403px\" \/><\/figure><\/div>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Domain 1- Manage data with Transact-SQL (40\u201345%)<\/strong><\/h4>\n\n\n\n<h5 class=\"wp-block-heading\"><strong>Create Transact-SQL SELECT queries<\/strong><\/h5>\n\n\n\n<ul class=\"wp-block-list\"><li>Identify proper SELECT query structure (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/t-sql\/queries\/select-transact-sql?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">SELECT (Transact-SQL)<\/a>)<\/li><li>Write specific queries to satisfy business requirements <\/li><li>Construct results from multiple queries using set operators (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/t-sql\/language-elements\/set-operators-union-transact-sql?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Set Operators &#8211; UNION (Transact-SQL)<\/a>)<\/li><li>Distinguish between UNION and UNION ALL behavior <\/li><li>Identify the query that would return expected results based on the provided table structure and\/or data <\/li><\/ul>\n\n\n\n<h5 class=\"wp-block-heading\"><strong>Query multiple tables by using joins<\/strong><\/h5>\n\n\n\n<ul class=\"wp-block-list\"><li>Write queries with join statements based on provided tables, data, and requirements (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/performance\/joins?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Joins (SQL Server)<\/a>, <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/join-tables-and-queries-3f5838bd-24a0-4832-9bc1-07061a1478f6\" target=\"_blank\" rel=\"noreferrer noopener\">Join tables and queries<\/a>)<\/li><li>Determine proper usages of INNER JOIN, LEFT\/RIGHT\/FULL OUTER JOIN, and CROSS JOIN (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/performance\/joins?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Joins (SQL Server)<\/a>)<\/li><li>Construct multiple JOIN operators using AND OR (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/t-sql\/language-elements\/and-transact-sql?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">AND (Transact-SQL)<\/a>, <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/t-sql\/language-elements\/or-transact-sql?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">OR (Transact-SQL)<\/a>)<\/li><li>Determine the correct results when presented with multi-table SELECT statements and source data (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/create-a-query-based-on-multiple-tables-4a14e73a-3ecd-481c-a416-09571c7064a9\" target=\"_blank\" rel=\"noreferrer noopener\">Create a query based on multiple tables<\/a>, <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/use-a-union-query-to-combine-multiple-queries-into-a-single-result-1f772ec0-cc73-474d-ab10-ad0a75541c6e\" target=\"_blank\" rel=\"noreferrer noopener\">Use a union query to combine multiple queries<\/a>)<\/li><li>Write queries with NULLs on joins (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/performance\/joins?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Joins (SQL Server)<\/a>)<\/li><\/ul>\n\n\n\n<h5 class=\"wp-block-heading\"><strong>Implement functions and aggregate data<\/strong><\/h5>\n\n\n\n<ul class=\"wp-block-list\"><li>Construct queries using scalar-valued and table-valued functions (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/t-sql\/statements\/create-function-transact-sql?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">CREATE FUNCTION (Transact-SQL)<\/a>, <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/user-defined-functions\/create-user-defined-functions-database-engine?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Create User-defined Functions (Database Engine)<\/a>)<\/li><li>Identify the impact of function usage to query performance and WHERE clause variability (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/t-sql\/queries\/where-transact-sql?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">WHERE (Transact-SQL)<\/a>)<\/li><li>Identify the differences between deterministic and non-deterministic functions (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/user-defined-functions\/deterministic-and-nondeterministic-functions?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Deterministic and Nondeterministic Functions<\/a><\/li><li>Use built-in aggregate functions (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/t-sql\/functions\/aggregate-functions-transact-sql?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Aggregate Functions (Transact-SQL)<\/a>)<\/li><li>Use arithmetic functions, date-related functions, and system functions (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/t-sql\/functions\/date-and-time-data-types-and-functions-transact-sql?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Date and Time Data Types and Functions (Transact-SQL)<\/a>)<\/li><\/ul>\n\n\n\n<h5 class=\"wp-block-heading\"><strong>Modify data<\/strong><\/h5>\n\n\n\n<ul class=\"wp-block-list\"><li>Write INSERT, UPDATE, and DELETE statements (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/access\/concepts\/structured-query-language\/insert-update-and-delete-records-from-a-table-using-access-sql\" target=\"_blank\" rel=\"noreferrer noopener\">Insert, update, and delete records from a table using Access SQL<\/a>)<\/li><li>Determine which statements can be used to load data to a table based on its structure and constraints (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/tables\/unique-constraints-and-check-constraints?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Unique Constraints and Check Constraints<\/a>, <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/t-sql\/statements\/create-table-transact-sql?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">CREATE TABLE (Transact-SQL)<\/a>, <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/tables\/primary-and-foreign-key-constraints?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Primary and Foreign Key Constraints<\/a>)<\/li><li>Construct Data Manipulation Language (DML) statements using the OUTPUT statement (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/t-sql\/queries\/queries?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Queries<\/a>, <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/t-sql\/queries\/output-clause-transact-sql?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">OUTPUT Clause (Transact-SQL)<\/a>)<\/li><li>Determine the results of Data Definition Language (DDL) statements on supplied tables and data (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/t-sql\/statements\/statements?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Transact-SQL statements<\/a>)<\/li><\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Domain 2- Query data with advanced Transact-SQL components (30\u201335%)<\/strong><\/h4>\n\n\n\n<h5 class=\"wp-block-heading\"><strong>Query data by using sub queries and APPLY<\/strong><\/h5>\n\n\n\n<ul class=\"wp-block-list\"><li>Determine the results of queries using subqueries and table joins (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/performance\/subqueries?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Subqueries (SQL Server)<\/a>)<\/li><li>Evaluate performance differences between table joins and correlated subqueries based on provided data and query plans (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-in\/help\/136699\/description-of-the-usage-of-joins-in-microsoft-query\" target=\"_blank\" rel=\"noreferrer noopener\">usage of joins in Microsoft Query<\/a>, <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/performance\/subqueries?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Subqueries (SQL Server)<\/a>)<\/li><li>Distinguish between the use of CROSS APPLY and OUTER APPLY (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/t-sql\/queries\/from-transact-sql?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">FROM clause plus JOIN, APPLY, PIVOT (Transact-SQL<\/a>)<\/li><li>Write APPLY statements that return a given data set based on supplied data (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/t-sql\/tutorial-writing-transact-sql-statements?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Writing Transact-SQL Statements<\/a>)<\/li><\/ul>\n\n\n\n<h5 class=\"wp-block-heading\"><strong>Query data by using table expressions<\/strong><\/h5>\n\n\n\n<ul class=\"wp-block-list\"><li>Identify basic components of table expressions (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/t-sql\/queries\/with-common-table-expression-transact-sql?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">WITH common_table_expression (Transact-SQL)<\/a>)<\/li><li>Define usage differences between table expressions and temporary tables (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/t-sql\/queries\/with-common-table-expression-transact-sql?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">WITH common_table_expression (Transact-SQL)<\/a>, <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/synapse-analytics\/sql-data-warehouse\/sql-data-warehouse-tables-temporary#:~:text=than%20remote%20storage.-,Temporary%20tables%20are%20useful%20when%20processing%20data%2C%20especially%20during%20transformation,when%20that%20session%20logs%20off.\" target=\"_blank\" rel=\"noreferrer noopener\">Temporary tables in Synapse SQL pool<\/a>)<\/li><li>Construct recursive table expressions to meet business requirements (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/archive\/msdn-magazine\/2007\/october\/data-points-common-table-expressions\" target=\"_blank\" rel=\"noreferrer noopener\">Data Points: Common Table Expressions<\/a>, <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/t-sql\/queries\/with-common-table-expression-transact-sql?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">WITH common_table_expression (Transact-SQL)<\/a>)<\/li><\/ul>\n\n\n\n<h5 class=\"wp-block-heading\"><strong>Group and pivot data by using queries<\/strong><\/h5>\n\n\n\n<ul class=\"wp-block-list\"><li>Use windowing functions to the group and rank the results of a query (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/t-sql\/queries\/select-over-clause-transact-sql?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">SELECT &#8211; OVER Clause (Transact-SQL)<\/a>)<\/li><li>Distinguish between using windowing functions and GROUP BY (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/stream-analytics\/stream-analytics-window-functions#:~:text=You%20use%20the%20window%20functions,using%20the%20Windows()%20function.\" target=\"_blank\" rel=\"noreferrer noopener\">Introduction to Stream Analytics windowing functions<\/a>)<\/li><li>Construct complex GROUP BY clauses using GROUPING SETS, and CUBE (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/t-sql\/queries\/select-group-by-transact-sql?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">SELECT &#8211; GROUP BY- Transact-SQL<\/a>)<\/li><li>Construct PIVOT and UNPIVOT statements to return desired results based on supplied data (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/t-sql\/queries\/from-using-pivot-and-unpivot?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">FROM &#8211; Using PIVOT and UNPIVOT<\/a>)<\/li><li>Determine the impact of NULL values in PIVOT and UNPIVOT queries (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/t-sql\/queries\/from-using-pivot-and-unpivot?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">FROM &#8211; Using PIVOT and UNPIVOT<\/a>)<\/li><\/ul>\n\n\n\n<h5 class=\"wp-block-heading\"><strong>Query temporal data and non-relational data<\/strong><\/h5>\n\n\n\n<ul class=\"wp-block-list\"><li>Query historic data by using temporal tables, query and output JSON data, and query and output XML data (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/json\/format-query-results-as-json-with-for-json-sql-server?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Format Query Results as JSON with FOR JSON (SQL Server)<\/a>, <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/xml\/for-xml-sql-server?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">FOR XML (SQL Server)<\/a>, <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/tables\/querying-data-in-a-system-versioned-temporal-table?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Querying data in a system-versioned temporal table<\/a>)<\/li><\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Domain 3- Program databases by using Transact-SQL (25\u201330%)<\/strong><\/h4>\n\n\n\n<h5 class=\"wp-block-heading\"><strong>Create database programmability objects by using Transact-SQL<\/strong><\/h5>\n\n\n\n<ul class=\"wp-block-list\"><li>Create stored procedures, table-valued and scalar-valued user-defined functions, triggers, and views (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/user-defined-functions\/create-user-defined-functions-database-engine?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Create User-defined Functions (Database Engine)<\/a>, <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/t-sql\/statements\/create-function-transact-sql?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">CREATE FUNCTION (Transact-SQL)<\/a>, <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/user-defined-functions\/user-defined-functions?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">User-Defined Functions<\/a>)<\/li><li>Implement input and output parameters in stored procedures (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/dotnet\/framework\/data\/adonet\/configuring-parameters-and-parameter-data-types\" target=\"_blank\" rel=\"noreferrer noopener\">Configuring parameters and parameter data types<\/a>, <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/connect\/jdbc\/using-a-stored-procedure-with-output-parameters?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Using a stored procedure with output parameters<\/a>)<\/li><li>Identify whether to use scalar-valued or table-valued functions (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/user-defined-functions\/scalar-udf-inlining?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Scalar UDF Inlining<\/a>)<\/li><li>Distinguish between deterministic and non-deterministic functions (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/user-defined-functions\/deterministic-and-nondeterministic-functions?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Deterministic and Nondeterministic Functions<\/a>)<\/li><li>Create indexed views (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/views\/create-indexed-views?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Create Indexed Views<\/a>)<\/li><\/ul>\n\n\n\n<h5 class=\"wp-block-heading\"><strong>Implement error handling and transactions<\/strong><\/h5>\n\n\n\n<ul class=\"wp-block-list\"><li>Determine the results of Data Definition Language (DDL) statements based on transaction control statements (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/t-sql\/statements\/statements?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Transact-SQL statements<\/a>)<\/li><li>Implement TRY\u2026CATCH error handling with Transact-SQL (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/t-sql\/language-elements\/try-catch-transact-sql?view=sql-server-ver15#:~:text=Remarks-,A%20TRY...,statements%20generates%20a%20syntax%20error.\" target=\"_blank\" rel=\"noreferrer noopener\">TRY&#8230;CATCH (Transact-SQL)<\/a>, <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/t-sql\/functions\/error-message-transact-sql?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">ERROR_MESSAGE (Transact-SQL)<\/a>)<\/li><li>Generate error messages with THROW and RAISERROR (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/t-sql\/language-elements\/raiserror-transact-sql?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">RAISERROR (Transact-SQL)<\/a>, <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/t-sql\/language-elements\/throw-transact-sql?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">THROW (Transact-SQL)<\/a>)<\/li><li>Implement transaction control in conjunction with error handling in stored procedures (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/t-sql\/language-elements\/try-catch-transact-sql?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">TRY&#8230;CATCH (Transact-SQL)<\/a>, <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/errors-events\/database-engine-events-and-errors?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Database engine errors<\/a>)<\/li><\/ul>\n\n\n\n<h5 class=\"wp-block-heading\"><strong>Implement data types and NULLs<\/strong> <\/h5>\n\n\n\n<ul class=\"wp-block-list\"><li>Evaluate results of data type conversions (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/t-sql\/data-types\/data-type-conversion-database-engine?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Data type conversion (Database Engine)<\/a>, <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/t-sql\/functions\/cast-and-convert-transact-sql?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">CAST and CONVERT (Transact-SQL)<\/a>)<\/li><li>Determine proper data types for given data elements or table columns (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/introduction-to-data-types-and-field-properties-30ad644f-946c-442e-8bd2-be067361987c\" target=\"_blank\" rel=\"noreferrer noopener\">data types and field properties<\/a>, <a href=\"https:\/\/docs.microsoft.com\/en-us\/dotnet\/api\/system.data.datacolumn.datatype?view=netcore-3.1\" target=\"_blank\" rel=\"noreferrer noopener\">DataColumn.DataType Property<\/a>)<\/li><li>Identify locations of implicit data type conversions in queries (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/t-sql\/data-types\/data-type-conversion-database-engine?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Data type conversion (Database Engine)<\/a>)<\/li><li>Determine the correct results of joins and functions in the presence of NULL values (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/performance\/joins?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Joins (SQL Server)<\/a>, <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/connect\/ado-net\/sql\/handle-null-values?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Handling null values<\/a>)<\/li><li>Identify the proper usage of ISNULL and COALESCE functions (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/t-sql\/language-elements\/coalesce-transact-sql?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">COALESCE (Transact-SQL)<\/a>)<\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Preparatory Guide<\/strong> <strong>for<\/strong> <strong>Microsoft 70-761 Exam<\/strong><\/h3>\n\n\n\n<p>The key to successfully pass an exam is by preparing right. Preparations demand consistency and determination. We present you our specially curated preparatory guide to help you achieve the Microsoft 70-761 Exam Certification in the very first attempt. Let\u2019s discuss step by step.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/06\/Steak-Guide-Timeline-Infographics-1-160x400.png\" alt=\"Microsoft 70-761 Exam Preparatory Guide\" class=\"wp-image-6637\" width=\"524\" height=\"1310\" srcset=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/06\/Steak-Guide-Timeline-Infographics-1-160x400.png 160w, https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/06\/Steak-Guide-Timeline-Infographics-1.png 800w\" sizes=\"auto, (max-width: 524px) 100vw, 524px\" \/><\/figure><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step1- Refer the Official Exam Guide<\/strong><\/h3>\n\n\n\n<p>Firstly, you need to go through the official guide of Microsoft 70-761 exam. Familiarise yourself with all the objectives and course domains of the exam. Devote enough time to each topic and have in depth knowledge of the subject.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 2- Devise a Study Plan<\/strong><\/h3>\n\n\n\n<p>The next step is to strategize a study plan for your preparations. Following your plan will help you remain consistent and also help in avoiding distractions. Remember the key to excel is to start early, hence begin with your preparations and stay motivated.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 3- Books \u2013 your Best friends<\/strong><\/h3>\n\n\n\n<p>Books are the most important ingredient of preparation. There are a vast variety of books available in the market which you can use to prepare for the Microsoft 70-761 Exam. Therefore, our suggestion to you would be to find books for the Microsoft 70-761 exam from genuine sources.&nbsp;<\/p>\n\n\n\n<p>We recommend you to refer the <strong><a href=\"https:\/\/www.microsoftpressstore.com\/store\/exam-ref-70-761-querying-data-with-transact-sql-9781509304332\" target=\"_blank\" rel=\"noreferrer noopener\">Exam Ref 70-761 Querying Data with Transact-SQL<\/a><\/strong> by Microsoft Press Store. This book 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-image\"><figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/images-na.ssl-images-amazon.com\/images\/I\/51pLqYVcfwL._SX258_BO1,204,203,200_.jpg\" alt=\"Exam Ref 70-761 BOOK\" width=\"218\" height=\"266\"\/><\/figure><\/div>\n\n\n\n<p>Additionally you can also refer the <a href=\"http:\/\/amzn.to\/2sKIAya\" target=\"_blank\" rel=\"noreferrer noopener\">Hands on Guide for SQL Data manipulation<\/a>. <\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 4- Learn from Online Resources<\/strong><\/h3>\n\n\n\n<p>There are plenty of Online Resources Available online for the preparation of your Microsoft 70-761 Exam. Each resource tries to offer you clarity about your exam domains. We recommend you to refer the official <a href=\"https:\/\/docs.microsoft.com\/en-in\/\" target=\"_blank\" rel=\"noreferrer noopener\">Microsoft Documentation. Also, you can refer the following documentation<\/a> for further learning-<\/p>\n\n\n\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/t-sql\/functions\/functions?view=sql-server-2017\" target=\"_blank\" rel=\"noreferrer noopener\">Database Functions <\/a><\/p>\n\n\n\n<p><a href=\"https:\/\/technet.microsoft.com\/en-us\/library\/ms174377(v=sql.110).aspx\" target=\"_blank\" rel=\"noreferrer noopener\">Transaction Statements <\/a><\/p>\n\n\n\n<p>&nbsp;<a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/t-sql\/lesson-1-creating-database-objects?view=sql-server-2017\" target=\"_blank\" rel=\"noreferrer noopener\">Tutorial on basic T-SQL operations <\/a><\/p>\n\n\n\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/performance\/subqueries?view=sql-server-2017\" target=\"_blank\" rel=\"noreferrer noopener\">Subquery Fundamentals &nbsp;<\/a><\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 5- Go for a Training Course<\/strong><\/h3>\n\n\n\n<p>Microsoft provides its own Training Courses for the preparation of this Exam. &nbsp;We know that being a practical exam, it requires hands on training. To solve this issue Microsoft has come up with training options in two modes. Choose the one that best suits you.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/www.microsoft.com\/en-us\/learning\/course.aspx?cid=20761\" target=\"_blank\" rel=\"noreferrer noopener\">Instructor-Led<\/a> Training- Microsoft instructor-led training is similar to the traditional classroom training setting. You can in-depth understanding of the exam course and hands-on experience. &nbsp;<\/li><li><a href=\"https:\/\/aka.ms\/edx-dat201x-abou\" target=\"_blank\" rel=\"noreferrer noopener\">Online Training<\/a>&#8211; Online Training offered by Microsoft is an ultimate resource for you to prepare. Such training helps you learn on your own schedule, at your own pace, and in your own place.&nbsp;<\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 6- Practice Tests<\/strong><\/h3>\n\n\n\n<p>Practice tests are really significant to check your preparations. They provide you with insights about your strengths and weaknesses. Strengthening your weakness will help you ace the exam. Attempt as many practice papers as you can and try to perform better than the previous one each time. There are plenty of practice papers available online. Make sure you choose the right and authentic ones. <a href=\"https:\/\/www.testpreptraining.ai\/querying-data-with-transact-sql-70-761-free-practice-test\" target=\"_blank\" rel=\"noreferrer noopener\">Start practicing for Microsoft 70-761 Now!<\/a><\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 7- Join a community<\/strong><\/h3>\n\n\n\n<p>Online forums and study groups are really beneficial while preparing for the exam. Study groups help you stay connected with the other people who are also going through the same journey as yours. Moreover, you can also ask a question related to the topic you\u2019re having difficulty with. You get to learn from the expertise of your peers and therefore joining a community is an important step while preparing.<\/p>\n\n\n\n<p><strong>Your best career opportunity is just a few tests away. <a href=\"https:\/\/www.testpreptraining.ai\/querying-data-with-transact-sql-70-761-exam\" target=\"_blank\" rel=\"noreferrer noopener\">Start preparing for your Microsoft 70-761: Querying Data with Transact-SQL certification exam now!<\/a><\/strong><\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/1gew6o3qn6vx9kp3s42ge0y1-wpengine.netdna-ssl.com\/wp-content\/uploads\/prod\/sites\/5\/2020\/04\/Microsoft-logo_rgb_c-gray-960x540.png\" alt=\"Microsoft on the Issues - News and perspectives on legal, public ...\" width=\"232\" height=\"130\"\/><\/figure><\/div>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"exam-title\">Querying Data with Transact-SQL<\/h2>\n\n\n\n<p>Microsoft Exam 70-761\u2013helps 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<p>The Microsoft Exam 70-7610 focuses on the expertise measured by these objectives Filter, sort, join, aggregate, and modify data, Use subqueries, table expressions, grouping sets, and pivoting, Query temporal and non-relational data, and output XML or JSON, Create views, user-defined functions, and stored procedures and Implement error handling, transactions, data types, and nulls.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Microsoft Exam 70-761 Table of Content<\/strong><\/h3>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Chapter 1 &#8211; Manage data with Transact-SQL<\/strong><\/h4>\n\n\n\n<p>Transact-SQL (T-SQL) is the main language used to manage and manipulate data in Microsoft SQL Server and Azure SQL Database.&nbsp;  This chapter focuses on managing data with T-SQL and it covers the elements of the SELECT statement, how to combine data from multiple tables with set operators and joins, use of built-in functions, and how to modify data. <\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/www.testpreptraining.ai\/tutorial\/create-transact-sql-select-queries\/\" target=\"_blank\" rel=\"noreferrer noopener\">1.1 Create Transact-SQL SELECT queries<\/a><\/li><li><a href=\"https:\/\/www.testpreptraining.ai\/tutorial\/query-multiple-tables-by-using-joins\/\" target=\"_blank\" rel=\"noreferrer noopener\">1.2 Query multiple tables by using joins<\/a><\/li><li><a href=\"https:\/\/www.testpreptraining.ai\/tutorial\/from-transact-sql\/\" target=\"_blank\" rel=\"noreferrer noopener\">1.3 FROM Transact-SQL<\/a> <\/li><li><a href=\"https:\/\/www.testpreptraining.ai\/tutorial\/join-sql-server-tables\/\" target=\"_blank\" rel=\"noreferrer noopener\">1.4 Join SQL Server Tables<\/a><\/li><li><a href=\"https:\/\/www.testpreptraining.ai\/tutorial\/implement-function-and-aggregate-data\/\" target=\"_blank\" rel=\"noreferrer noopener\">1.5 Implement Functions and Aggregate Data<\/a><\/li><li><a href=\"https:\/\/www.testpreptraining.ai\/tutorial\/microsoft-modify-data\/\" target=\"_blank\" rel=\"noreferrer noopener\">1.6 Modify data<\/a><\/li><\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong> Chapter 2 &#8211; Query data with advanced Transact-SQL components<\/strong><\/h4>\n\n\n\n<p>This chapter covers a number of T-SQL components that allow you to manipulate and analyze data. The module elaborates how to nest queries and use the APPLY operator, work with table expressions, apply data analysis calculations with grouping, pivoting, and windowing, query historical data from temporal tables, and query and output XML and JSON data. <\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"http:\/\/query-data-by-using-subqueries-and-apply-2\" target=\"_blank\" rel=\"noreferrer noopener\">2.1 Query data by using subqueries and APPLY<\/a><\/li><li><a href=\"https:\/\/www.testpreptraining.ai\/tutorial\/query-data-by-using-table-expressions\/\" target=\"_blank\" rel=\"noreferrer noopener\">2.2 Query data by using table expressions<\/a><\/li><li><a href=\"https:\/\/www.testpreptraining.ai\/tutorial\/group-and-pivot-data-by-using-queries\/\" target=\"_blank\" rel=\"noreferrer noopener\">2.3 Group and pivot data by using queries<\/a><\/li><li><a href=\"https:\/\/www.testpreptraining.ai\/tutorial\/query-temporal-data-and-non-relational-data\/\" target=\"_blank\" rel=\"noreferrer noopener\">2.4 Query temporal data and non-relational data<\/a><\/li><\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Chapter 3 &#8211; Program databases by using Transact-SQL<\/strong><\/h4>\n\n\n\n<p>The chapter covers programmability features in T-SQL. It starts with programmability objects like views, user-defined functions, and stored procedures. It then covers handling errors with the TRY-CATCH construct, and working with transactions. The chapter completes with coverage of handling of data types and treatment of NULLs. <\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/www.testpreptraining.ai\/tutorial\/create-database-programmability-objects-by-using-transact-sql\/\" target=\"_blank\" rel=\"noreferrer noopener\">3.1 Create database programmability objects by using Transact-SQL<\/a><\/li><li><a href=\"https:\/\/www.testpreptraining.ai\/tutorial\/implement-error-handling-and-transactions\/\" target=\"_blank\" rel=\"noreferrer noopener\">3.2 Implement error handling and transactions<\/a><\/li><li><a href=\"https:\/\/www.testpreptraining.ai\/tutorial\/implement-data-types-and-nulls\/\" target=\"_blank\" rel=\"noreferrer noopener\">3.3 Implement data types and NULLs<\/a><\/li><\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Certifications from Microsoft provide you with a professional edge by demonstrating your skills and abilities to embrace new technologies. By being globally recognised, these certifications verify your skills and unlock an avenue of opportunities for you. The Microsoft Querying Data with Transact-SQL 70-761 exam helps you validate your skills and knowledge that is necessary to&#8230;<\/p>\n","protected":false},"author":1,"featured_media":6632,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"footnotes":""},"categories":[5720,174,5729],"tags":[360,4,358,357,359],"class_list":["post-1931","page","type-page","status-publish","has-post-thumbnail","hentry","category-database","category-microsoft-azure","category-server","tag-exam-70-761","tag-m4f","tag-microsoft-70-761","tag-microsoft-exam","tag-querying-data-with-transact-sql"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Exam 70-761: Querying Data with Transact-SQL | Study Guide<\/title>\n<meta name=\"description\" content=\"Catapult your career opportunities with Microsoft Querying Data with Transact-SQL (70-761) Exam | Start Learning from our Tutorials and Preparatory Guide\" \/>\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.testpreptraining.ai\/tutorial\/exam-70-761-querying-data-with-transact-sql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Exam 70-761: Querying Data with Transact-SQL | Study Guide\" \/>\n<meta property=\"og:description\" content=\"Catapult your career opportunities with Microsoft Querying Data with Transact-SQL (70-761) Exam | Start Learning from our Tutorials and Preparatory Guide\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-761-querying-data-with-transact-sql\/\" \/>\n<meta property=\"og:site_name\" content=\"Testprep Training Tutorials\" \/>\n<meta property=\"article:modified_time\" content=\"2021-05-27T13:53:26+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/06\/Querying-Data-with-Transact-SQL-70-761.png\" \/>\n\t<meta property=\"og:image:width\" content=\"750\" \/>\n\t<meta property=\"og:image:height\" content=\"400\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\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=\"14 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-761-querying-data-with-transact-sql\/\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-761-querying-data-with-transact-sql\/\",\"name\":\"Exam 70-761: Querying Data with Transact-SQL | Study Guide\",\"isPartOf\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#website\"},\"datePublished\":\"2019-08-08T06:58:54+00:00\",\"dateModified\":\"2021-05-27T13:53:26+00:00\",\"description\":\"Catapult your career opportunities with Microsoft Querying Data with Transact-SQL (70-761) Exam | Start Learning from our Tutorials and Preparatory Guide\",\"breadcrumb\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-761-querying-data-with-transact-sql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-761-querying-data-with-transact-sql\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-761-querying-data-with-transact-sql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Exam 70-761: Querying Data with Transact-SQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#website\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\",\"name\":\"Testprep Training Tutorials\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.testpreptraining.ai\/tutorial\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#organization\",\"name\":\"Testprep Training\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png\",\"contentUrl\":\"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png\",\"width\":583,\"height\":153,\"caption\":\"Testprep Training\"},\"image\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Exam 70-761: Querying Data with Transact-SQL | Study Guide","description":"Catapult your career opportunities with Microsoft Querying Data with Transact-SQL (70-761) Exam | Start Learning from our Tutorials and Preparatory Guide","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.testpreptraining.ai\/tutorial\/exam-70-761-querying-data-with-transact-sql\/","og_locale":"en_US","og_type":"article","og_title":"Exam 70-761: Querying Data with Transact-SQL | Study Guide","og_description":"Catapult your career opportunities with Microsoft Querying Data with Transact-SQL (70-761) Exam | Start Learning from our Tutorials and Preparatory Guide","og_url":"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-761-querying-data-with-transact-sql\/","og_site_name":"Testprep Training Tutorials","article_modified_time":"2021-05-27T13:53:26+00:00","og_image":[{"width":750,"height":400,"url":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/06\/Querying-Data-with-Transact-SQL-70-761.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"14 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-761-querying-data-with-transact-sql\/","url":"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-761-querying-data-with-transact-sql\/","name":"Exam 70-761: Querying Data with Transact-SQL | Study Guide","isPartOf":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#website"},"datePublished":"2019-08-08T06:58:54+00:00","dateModified":"2021-05-27T13:53:26+00:00","description":"Catapult your career opportunities with Microsoft Querying Data with Transact-SQL (70-761) Exam | Start Learning from our Tutorials and Preparatory Guide","breadcrumb":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-761-querying-data-with-transact-sql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-761-querying-data-with-transact-sql\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-761-querying-data-with-transact-sql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.testpreptraining.ai\/tutorial\/"},{"@type":"ListItem","position":2,"name":"Exam 70-761: Querying Data with Transact-SQL"}]},{"@type":"WebSite","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#website","url":"https:\/\/www.testpreptraining.ai\/tutorial\/","name":"Testprep Training Tutorials","description":"","publisher":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.testpreptraining.ai\/tutorial\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#organization","name":"Testprep Training","url":"https:\/\/www.testpreptraining.ai\/tutorial\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/","url":"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png","contentUrl":"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png","width":583,"height":153,"caption":"Testprep Training"},"image":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/1931","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/comments?post=1931"}],"version-history":[{"count":26,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/1931\/revisions"}],"predecessor-version":[{"id":42775,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/1931\/revisions\/42775"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/media\/6632"}],"wp:attachment":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/media?parent=1931"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/categories?post=1931"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/tags?post=1931"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}