{"id":8542,"date":"2020-06-23T06:40:48","date_gmt":"2020-06-23T06:40:48","guid":{"rendered":"https:\/\/www.testpreptraining.com\/tutorial\/?page_id=8542"},"modified":"2021-05-27T13:56:03","modified_gmt":"2021-05-27T13:56:03","slug":"exam-70-762-microsoft-developing-sql-databases","status":"publish","type":"page","link":"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-762-microsoft-developing-sql-databases\/","title":{"rendered":"Exam 70-762 \u2013 Microsoft Developing SQL Databases"},"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\/Exam-70-762-\u2013-Microsoft-Developing-SQL-Databases-1.png\" alt=\"Exam 70-762 \u2013 Microsoft Developing SQL Databases \" class=\"wp-image-8551\"\/><\/figure><\/div>\n\n\n\n<p><a href=\"https:\/\/www.testpreptraining.ai\/blog\/how-to-clear-microsoft-deveoping-sql-database-70-762\/\" target=\"_blank\" rel=\"noreferrer noopener\">MS 70-762<\/a> &#8211; Developing SQL Databases exam is designed for database professionals who build and implement databases across organizations and ensure high level of data availability. The MS 70-762 exam is challenging and detailed preparation is required to pass the exam. These kinds of certifications increase your chances for the job and makes you feel like a pro in your field. This certification will help you to increase your chances of getting your dream job &amp; will help you climb higher in the corporate ladder. With the help of right resources and a perfect study guide you will definitely ace the exam and will get an advantage over your other mates. So, let\u2019s get started.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"alignright size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"300\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/06\/mcsa-sql-2016-database-development-certified-2018.png\" alt=\"\" class=\"wp-image-8552\"\/><\/figure><\/div>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>What is MS 70-762 exam?<\/strong><\/h4>\n\n\n\n<p>This exam measures your ability to accomplish the technical tasks such as- Design and implement database objects, implement programmability object, manage database concurrency, Optimize database objects and SQL infrastructure. The exam may test you on this above-mentioned basis but is not limited to these topics. So, you got to be conceptually strong in order to pass the exam with flying colors.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Exam overview<\/strong><\/h3>\n\n\n\n<p>The exam MS 70-762 is designed for database developer enthusiasts. MS 70-762 will contain 40-60 questions which have to be answered in 120 minutes. You have to achieve a score of 700 out of 1000 in order to clear the exam which can be achieved through thorough preparation and right guidance.<\/p>\n\n\n\n<p>&nbsp;The exam will cost you USD 165 if you are in US. The price of the exam may vary from place to place. This exam is available only in English language and you can take the exam through Pearson VUE platform. This certification is credit towards certifications of MCSA and MCSE.<\/p>\n\n\n\n<p>Here is table for your assistance:<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td>No. of questions asked-<\/td><td>40-60<\/td><\/tr><tr><td>Time allowed<\/td><td>120 minutes<\/td><\/tr><tr><td>Scoring policy<\/td><td>700 out of 1000 is desired score in order to pass MS 70-762<\/td><\/tr><tr><td>Pricing policy<\/td><td>USD 165 (In USA)<\/td><\/tr><tr><td>Languages available<\/td><td>English<\/td><\/tr><tr><td>Exam code<\/td><td>70-762<\/td><\/tr><tr><td>Schedule exam<\/td><td>Pearson VUE<\/td><\/tr><tr><td>Credit towards certification<\/td><td>MCSA &amp; MCSE<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>MS 70-762 Exam retake policy<\/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\/MS-70-762-Exam-retake-policy.png\" alt=\"\" class=\"wp-image-8564\"\/><\/figure><\/div>\n\n\n\n<ol class=\"wp-block-list\" type=\"1\"><li>If you are unable to pass the exam in first attempt, the you must at least wait 24 hours before retaking the exam. You cannot retake the exam if you achieve a passing score.<\/li><li>If you fail to pass the exam in second attempt too, then you must wait for a period not less than 14 days, in order to retake the exam. This is the same process for the failure in third, fourth or fifth attempt.<\/li><li>You will not be allowed to give the exam more than 5 times a year. This year, 12-month period starts on your failure on 5th attempt. If you wish to give the exam more than 5 months a year then you have to contact Microsoft.<\/li><\/ol>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>How to register for the MS 70-762 exam?<\/strong><\/h3>\n\n\n\n<p>Follow the steps written below to register for the exam:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Go to the Microsoft site and find your certificate in the list. Then select schedule exam, to register.<\/li><li>If the certificate will be available for your country then you will be able to select the exam during the registration process.<\/li><li>You will also select the language of the greeter, proctor, and proctoring software.<\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Academic pricing on the certifications<\/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\/Academic-pricing-on-the-certifications-1.png\" alt=\"Academic pricing Exam 70-762 \" class=\"wp-image-8566\"\/><\/figure><\/div>\n\n\n\n<p>Academic pricing on Microsoft Certified Professional exams is available in most countries (except India and China). You must verify your student status before scheduling your exam in order to be eligible for academic pricing.<\/p>\n\n\n\n<p>Applying student status through your account profile<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Sign in with your Microsoft account credentials.<\/li><li>Select Profile settings from the Account menu at the top of the page.<\/li><li>In the Job function menu, select, or ensure that you have selected, \u201cStudent.\u201d<\/li><li>Look for the academic pricing notice that appears next to the Job function menu. If your student status has not yet been validated, click \u201cGet verified\u201d to verify your status.<\/li><\/ul>\n\n\n\n<p>Applying student status when registering for an exam<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Sign in with your Microsoft account credentials.<\/li><li>On the exam for which you want to register, click Schedule exam.<\/li><li>On the Confirm your exam registration details page, ensure that the Job function field displays \u201cStudent \u2013 Verified.\u201d If it does not, click \u201cGet verified\u201d to validate your status, or click Edit to change your status.<\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Verifying your academic status<\/strong><\/h3>\n\n\n\n<p>Select the method you wish to use to verify your status. The methods include:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>School-issued email account<\/li><li>School network credentials<\/li><li>International Student Identity Card (ISIC)<\/li><li>Verification code from a Microsoft representative or your institution\u2019s administrator<\/li><li>Documentation<\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Other exam policies<\/strong><\/h3>\n\n\n\n<p>You can refer to the <a href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/certifications\/exams\/70-762\" target=\"_blank\" rel=\"noreferrer noopener\">official site of Microsoft for the exam <\/a>policies and other terms and conditions. Make sure to properly read all the terms and conditions so that you do not miss out on anything important for taking the exam.<\/p>\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\/FAQs-11.png\" alt=\"FAQs Exam 70-762 \" class=\"wp-image-8553\"\/><\/figure><\/div>\n\n\n\n<p>To know more, visit: <a href=\"https:\/\/www.testpreptraining.ai\/tutorial\/ms-70-762-exam-faqs\/\" target=\"_blank\" rel=\"noreferrer noopener\">MS 70-762 exam FAQs<\/a><\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Syllabus details<\/strong><\/h3>\n\n\n\n<p>These are the major testing basis as prescribed by the Microsoft. Let\u2019s go through them, one by one-<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Design and implement database objects (25\u201330%)<\/strong><\/h4>\n\n\n\n<p>Design and implement a relational database scheme <\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Design tables and schemas based on business requirements (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/synapse-analytics\/sql-data-warehouse\/sql-data-warehouse-tables-overview\" target=\"_blank\" rel=\"noreferrer noopener\">Design tables in Synapse SQL pool<\/a>)<\/li><li>Improve the design of tables by using the normalization (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/troubleshoot\/access\/database-normalization-description\" target=\"_blank\" rel=\"noreferrer noopener\">Description of the database normalization basics<\/a>)<\/li><li>Write table create statements (<strong>Microsoft Documentation:<\/strong> <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>)<\/li><li>Determine the most efficient data types to use. (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/dotnet\/visual-basic\/programming-guide\/language-features\/data-types\/efficient-use-of-data-types#:~:text=In%20Visual%20Basic%2C%20Integer%20and,point%20operations%20in%20double%20precision.\" target=\"_blank\" rel=\"noreferrer noopener\">Efficient Use of Data Types (Visual Basic)<\/a>)<\/li><\/ul>\n\n\n\n<p>Design and implement indexes<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Design new indexes based on provided tables, queries, or plans (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/indexes\/indexes?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Indexes<\/a>) <\/li><li>Distinguish between indexed columns and included columns (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/indexes\/create-indexes-with-included-columns?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Create Indexes with Included Columns<\/a>)<\/li><li>Implement clustered index columns by using best practices (<strong>Microsoft Documentation:<\/strong>  <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/sql-server-index-design-guide?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">SQL Server Index Architecture and Design Guide<\/a>)<\/li><li>Recommend new indexes based on query plans. (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/azure-sql\/database\/database-advisor-implement-performance-recommendations\" target=\"_blank\" rel=\"noreferrer noopener\">Database Advisor performance recommendations for Azure SQL Database<\/a>, <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/sql-server-index-design-guide?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">SQL Server Index Architecture and Design Guide<\/a>)<\/li><\/ul>\n\n\n\n<p>Design and implement views<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Design a view structure to select data based on user or business requirements (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/t-sql\/statements\/create-view-transact-sql?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">CREATE VIEW (Transact-SQL)<\/a>, <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/architecture\/guide\/technology-choices\/data-store-overview\" target=\"_blank\" rel=\"noreferrer noopener\">Understand data store models<\/a>)<\/li><li>Identify the steps necessary to design an updateable view (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/windows-server\/administration\/windows-server-update-services\/manage\/viewing-and-managing-updates\" target=\"_blank\" rel=\"noreferrer noopener\">Viewing and Managing Updates<\/a>, <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/t-sql\/statements\/create-view-transact-sql?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">CREATE VIEW (Transact-SQL)<\/a>)<\/li><li>Implement partitioned views (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/partitions\/partitioned-tables-and-indexes?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Partitioned Tables and Indexes<\/a>)<\/li><li>Implement 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<p>Implement columnstore indexes<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Determine use cases that support the use of columnstore indexes (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/indexes\/columnstore-indexes-overview?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Columnstore indexes: Overview<\/a>)<\/li><li>Identify proper usage of clustered and non-clustered columnstore indexes (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/indexes\/columnstore-indexes-overview?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Columnstore indexes: Overview<\/a>)<\/li><li>Design standard non-clustered indexes in conjunction with clustered columnstore indexes<\/li><li>Implement columnstore index maintenance. (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/indexes\/columnstore-indexes-data-warehouse?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Columnstore indexes &#8211; Data Warehouse<\/a>, <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/synapse-analytics\/sql-data-warehouse\/sql-data-warehouse-tables-index\" target=\"_blank\" rel=\"noreferrer noopener\">Indexing tables in Synapse SQL pool<\/a>)<\/li><\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Implement programmability objects (20\u201325%)<\/strong><\/h4>\n\n\n\n<p>Ensure data integrity with constraints<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Define table and foreign key constraints to enforce business rules (<strong>Microsoft Documentation:<\/strong> <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>Write Transact-SQL statements to add constraints to tables (<strong>Microsoft Documentation:<\/strong> <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>)<\/li><li>Identify results of Data Manipulation Language (DML) statements given existing tables and constraints (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/triggers\/dml-triggers?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">DML Triggers<\/a>, <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>Identify the proper usage of PRIMARY KEY 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>)<\/li><\/ul>\n\n\n\n<p>Create stored procedures<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Design stored procedure components and structure based on business requirements (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/query-processing-architecture-guide?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Query Processing Architecture Guide<\/a>, <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/t-sql\/statements\/create-procedure-transact-sql?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">CREATE PROCEDURE (Transact-SQL)<\/a>)<\/li><li>Implement input and output parameters<\/li><li>Implement table-valued parameters (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/connect\/jdbc\/using-table-valued-parameters?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Using table-valued parameters<\/a>)<\/li><li>Implement return codes, streamline existing stored procedure logic <\/li><li>Implement error handling and transaction control logic within 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>)<\/li><\/ul>\n\n\n\n<p>Create triggers and user-defined functions<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Design trigger logic based on business requirements<\/li><li>Determine when to use Data Manipulation Language (DML) triggers, Data Definition Language (DDL) triggers, or logon triggers (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/triggers\/dml-triggers?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">DML Triggers<\/a>, <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/t-sql\/statements\/create-trigger-transact-sql?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">CREATE TRIGGER (Transact-SQL<\/a>))<\/li><li>Recognize results based on the execution of AFTER or INSTEAD OF triggers (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/triggers\/use-the-inserted-and-deleted-tables?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Use the inserted and deleted Tables<\/a>, <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/t-sql\/statements\/create-trigger-transact-sql?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">CREATE TRIGGER (Transact-SQL<\/a>))<\/li><li>Design scalar-valued and table-valued user-defined functions based on business requirements (<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>)<\/li><li>Identify differences between deterministic and non-deterministic functions. Documentation: (<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><\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Manage database concurrency (25\u201330%)<\/strong><\/h4>\n\n\n\n<p>Implement transactions<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Identify DML statement results based on transaction behavior (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/sql-server-transaction-locking-and-row-versioning-guide?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Transaction Locking and Row Versioning Guide<\/a>)<\/li><li>Recognize differences between and identify usage of explicit and implicit transactions (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/dotnet\/framework\/data\/transactions\/implementing-an-implicit-transaction-using-transaction-scope\" target=\"_blank\" rel=\"noreferrer noopener\">Implementing an Implicit Transaction using Transaction Scope<\/a>, <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/t-sql\/statements\/set-implicit-transactions-transact-sql?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">SET IMPLICIT_TRANSACTIONS (Transact-SQL<\/a>))<\/li><li>Implement savepoints within transactions (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/t-sql\/language-elements\/save-transaction-transact-sql?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">SAVE TRANSACTION (Transact-SQL)<\/a>, <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/connect\/jdbc\/using-savepoints?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Using savepoints<\/a>)<\/li><li>Determine the role of transactions in high-concurrency databases. (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/dotnet\/framework\/data\/adonet\/transactions-and-concurrency\" target=\"_blank\" rel=\"noreferrer noopener\">Transactions and Concurrency<\/a>)<\/li><\/ul>\n\n\n\n<p>Manage isolation levels<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Identify differences between reading Uncommitted, Read Committed, Repeatable Read, Serializable, and Snapshot isolation levels (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/t-sql\/statements\/set-transaction-isolation-level-transact-sql?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">SET TRANSACTION ISOLATION LEVEL (Transact-SQL)<\/a>, <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/connect\/jdbc\/understanding-isolation-levels?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Understanding isolation levels<\/a>, <a href=\"https:\/\/docs.microsoft.com\/en-us\/dotnet\/framework\/data\/adonet\/sql\/snapshot-isolation-in-sql-server\" target=\"_blank\" rel=\"noreferrer noopener\">Snapshot Isolation in SQL Server<\/a>)<\/li><li>Define the results of concurrent queries based on isolation level (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/connect\/jdbc\/understanding-isolation-levels?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Understanding isolation levels<\/a>)<\/li><li>Identify the resource and performance impact of given isolation levels. (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/connect\/jdbc\/understanding-isolation-levels?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Understanding isolation levels<\/a>)<\/li><\/ul>\n\n\n\n<p>Optimize concurrency and locking behavior<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Troubleshoot locking issues<\/li><li>Identify lock escalation behaviors, capture and analyze deadlock graphs (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/sql-server-transaction-locking-and-row-versioning-guide?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Transaction Locking and Row Versioning Guide<\/a>, <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/tools\/sql-server-profiler\/analyze-deadlocks-with-sql-server-profiler?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Analyze Deadlocks with SQL Server Profiler<\/a>)<\/li><li>Identify ways to remediate deadlocks. (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/windows-hardware\/drivers\/devtest\/deadlock-detection\" target=\"_blank\" rel=\"noreferrer noopener\">Deadlock Detection<\/a>)<\/li><\/ul>\n\n\n\n<p>Implement memory-optimized tables and native stored procedures<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Define use cases for memory-optimized tables versus traditional disk-based tables (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/in-memory-oltp\/comparing-disk-based-table-storage-to-memory-optimized-table-storage?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Comparing Disk-Based Table Storage to Memory-Optimized Table Storage<\/a>)<\/li><li>Optimize the performance of in-memory tables by changing durability settings (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/in-memory-oltp\/defining-durability-for-memory-optimized-objects?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Defining Durability for Memory-Optimized Objects<\/a>)<\/li><li>Determine best case usage scenarios for natively compiled stored procedures (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/in-memory-oltp\/overview-and-usage-scenarios?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Overview and Usage Scenarios<\/a>)<\/li><li>Enable collection of execution statistics for natively compiled stored procedures. (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/in-memory-oltp\/monitoring-performance-of-natively-compiled-stored-procedures?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Monitoring Performance of Natively Compiled Stored Procedures<\/a>)<\/li><\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Optimize database objects and SQL infrastructure (20\u201325%)<\/strong><\/h4>\n\n\n\n<p>Optimize statistics and indexes<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Determine the accuracy of statistics and the associated impact to query plans and performance (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/statistics\/statistics?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Statistics<\/a>, <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/performance\/best-practice-with-the-query-store?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Best practices with Query Store<\/a>)<\/li><li>Design statistics maintenance tasks (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/maintenance-plans\/update-statistics-task-maintenance-plan?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Update Statistics Task (Maintenance Plan)<\/a><\/li><li>Use dynamic management objects to review current index usage and identify missing indexes, consolidate overlapping indexes. (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/sql-server-index-design-guide?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">SQL Server Index Architecture and Design Guide<\/a>), <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/system-dynamic-management-views\/sys-dm-db-missing-index-details-transact-sql?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">sys.dm_db_missing_index_details (Transact-SQL)<\/a>)<\/li><\/ul>\n\n\n\n<p>Analyze and troubleshoot query plans<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Capture query plans using extended events and traces (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/extended-events\/quick-start-extended-events-in-sql-server?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Extended events in SQL Server<\/a>)<\/li><li>Identify poorly performing query plan operators (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/azure-sql\/identify-query-performance-issues\" target=\"_blank\" rel=\"noreferrer noopener\">Detectable types of query performance bottlenecks in Azure SQL Database<\/a>)<\/li><li>Create efficient query plans using Query Store (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/performance\/best-practice-with-the-query-store?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Best practices with Query Store<\/a>)<\/li><li>Compare estimated and actual query plans and related metadata, configure Azure SQL Database Performance Insight. (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/azure-sql\/database\/query-performance-insight-use\" target=\"_blank\" rel=\"noreferrer noopener\">Query Performance Insight for Azure SQL Database<\/a>), <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/performance\/compare-execution-plans?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Compare execution plans<\/a>)<\/li><\/ul>\n\n\n\n<p>Manage performance for database instances<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Manage database workload in SQL Server (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/performance\/best-practice-with-the-query-store?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Best practices with Query Store<\/a>)<\/li><li>Design and implement Elastic Scale for Azure SQL Database (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/azure-sql\/database\/elastic-scale-introduction\" target=\"_blank\" rel=\"noreferrer noopener\">Scaling out with Azure SQL Database<\/a>)<\/li><li>Select an appropriate service tier or edition (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/azure-sql\/database\/service-tiers-dtu\" target=\"_blank\" rel=\"noreferrer noopener\">Service tiers in the DTU-based purchase model<\/a>)<\/li><li>Optimize database file and tempdb configuration (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/databases\/tempdb-database?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">tempdb database<\/a>)<\/li><li>Optimize memory configuration<\/li><li>Monitor and diagnose scheduling and wait statistics using dynamic management objects (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/system-dynamic-management-views\/sys-dm-os-wait-stats-transact-sql?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">sys.dm_os_wait_stats (Transact-SQL)<\/a>)<\/li><li>Troubleshoot and analyze storage, IO, and cache issues (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/storage\/common\/storage-monitoring-diagnosing-troubleshooting\" target=\"_blank\" rel=\"noreferrer noopener\">Monitor, diagnose, and troubleshoot Microsoft Azure Storage<\/a>)<\/li><li>Monitor Azure SQL Database query plans. <\/li><\/ul>\n\n\n\n<p>Monitor and trace SQL Server baseline performance metrics<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Monitor operating system and SQL Server performance metrics (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/performance\/performance-monitoring-and-tuning-tools?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Performance Monitoring and Tuning Tools<\/a>)<\/li><li>Compare baseline metrics to observed metrics while troubleshooting performance issues (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/azure-sql\/database\/intelligent-insights-overview\" target=\"_blank\" rel=\"noreferrer noopener\">Intelligent Insights using AI to monitor and troubleshoot database performance (preview)<\/a>)<\/li><li>Identify differences between performance monitoring and logging tools, such as perfmon and dynamic management objects (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/performance-monitor\/sql-server-memory-manager-object?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">SQL Server, Memory Manager Object<\/a>, <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/performance\/performance-monitoring-and-tuning-tools?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Performance Monitoring and Tuning Tools<\/a>)<\/li><li>Monitor Azure SQL Database performance <\/li><li>Determine best practice use cases for extended events (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/extended-events\/quick-start-extended-events-in-sql-server?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Extended events in SQL Server<\/a>)<\/li><li>Distinguish between Extended Events targets (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/extended-events\/extended-events?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Extended events overview<\/a>)<\/li><li>Compare the impact of Extended Events and SQL Trace (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/extended-events\/extended-events?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Extended events overview<\/a>)<\/li><li>Define differences between Extended Events Packages, Targets, Actions, and Sessions. (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/extended-events\/sql-server-extended-events-packages?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">SQL Server Extended Events Packages<\/a>)<\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Preparatory guide for MS 70-762<\/strong><\/h3>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"750\" height=\"1200\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/06\/c7ff94-3.png\" alt=\"Preparation guide for 70-762\" class=\"wp-image-8627\" srcset=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/06\/c7ff94-3.png 750w, https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/06\/c7ff94-3-250x400.png 250w\" sizes=\"auto, (max-width: 750px) 100vw, 750px\" \/><\/figure><\/div>\n\n\n\n<p>Your success will depend on how well did you prepare for the exam. To ace the exam, you have to prepare from every possible resource available to you. Here is the list of some of the resources which may show you the way. But always remember that there is no end to knowledge, you have endless resources beyond this list. Let us look at some important resources:<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>The official site<\/strong><\/h4>\n\n\n\n<p>Always make sure to visit the official site before taking any exam for essential details. The official site of Microsoft has too many resources prescribed with the course. Microsoft provide instructor led trainings for MS 70-762 exam, online training that are different for different modules as prescribed in syllabus. Microsoft has also prescribed its own book- \u2018Exam Ref 70-762 Developing SQL Databases\u2019 for reference.<\/p>\n\n\n\n<p>It has also made available many text resources and other lectures such as- Clustered and Non clustered Indexes, Columnstore Indexes \u2013 Design Guidance, Create and update database tables, Tutorial: Writing Transact-SQL Statements and so on for the ease and assistance of the candidates taking the exams. Microsoft has also made available its videos for the assistance of candidates regarding type and no. of questions and other details.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"alignright size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/06\/lrn-book-Cover-70-762examref-1-1-328x400.png\" alt=\"\" class=\"wp-image-8568\" width=\"234\" height=\"285\" srcset=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/06\/lrn-book-Cover-70-762examref-1-1-328x400.png 328w, https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/06\/lrn-book-Cover-70-762examref-1-1.png 600w\" sizes=\"auto, (max-width: 234px) 100vw, 234px\" \/><\/figure><\/div>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Libraries and the books<\/strong><\/h4>\n\n\n\n<p>Books are another valuable resource for the preparation. You can find many books available online or you can take any book from libraries or bookstores as per your ease. You can choose various books and prepare the topic that is best in the book. Now-a-days libraries are available online too. So, you can access the study material whenever you want just at one click. You can also prepare from the book prescribed by Microsoft- Exam Ref 70-762 Developing SQL Databases. This book covers all the concepts that are required for clearing the exam.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Online classes and Instructor-led training<\/strong><\/h4>\n\n\n\n<p>There are many online resources available like online classes or instructor-led training courses which are offered by online educational sites. They offer interactive classes that can be helpful for clearing your conceptual parts and doubts. They also keep you updated on new changes in the syllabus and other updates.<\/p>\n\n\n\n<p>You can also form online study groups with the candidates of same interests. You all can keep testing each other to evaluate your progress and pool your study resources.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Your own strategy<\/strong><\/h4>\n\n\n\n<p>Prepare your own strategy for study. Self-study is the key that will help you score more and will lead to perfection. Categories the syllabus into the parts which demands hands-on training and which is theoretical. Break the big parts into smaller one and then try to learn them. This will enable you to grasp things easily. Always make sure to never skip classes and keep your practice regular. Make notes and keep revising time to time.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Offline resources<\/strong><\/h4>\n\n\n\n<p>You can take classroom lectures if you don\u2019t feel comfortable with online classes. You can also from study groups which will help you boost your self-confidence and practice. This also will make you aware of other\u2019s point of view. So, you can obviously improve the parts in which you lag behind.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Test series and practice papers<\/strong><\/h4>\n\n\n\n<p>Many online sites provide you free test papers and paid test series which will keep evaluating your preparation. Taking the test series will help you identify what parts of the syllabus are strong from your side and on which parts you are required to put more efforts. Many sites provide trustworthy test series which help you gain confidence and will finally help you ace the exam. Since, clearing the exam is not the end, you have to apply the concepts practically to secure your dream job. <a href=\"https:\/\/www.testpreptraining.ai\/administering-microsoft-sql-server-20122014-databases-70-462-free-practice-test\" target=\"_blank\" rel=\"noreferrer noopener\">Take a free practice test now!<\/a><\/p>\n\n\n\n<p><strong><em>Passing the MS 70-762 exam requires a lot of efforts but nothing is impossible. You just need to pick right resources for yourself and you can clear the exam easily. Just make sure to put your 100% efforts. Start preparing for <a href=\"https:\/\/www.testpreptraining.ai\/administering-microsoft-sql-server-20122014-databases-70-462-free-practice-test\" target=\"_blank\" rel=\"noreferrer noopener\">MS 70-762 \u2013 Developing SQL Databases<\/a> Exam.<\/em><\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>MS 70-762 &#8211; Developing SQL Databases exam is designed for database professionals who build and implement databases across organizations and ensure high level of data availability. The MS 70-762 exam is challenging and detailed preparation is required to pass the exam. These kinds of certifications increase your chances for the job and makes you feel&#8230;<\/p>\n","protected":false},"author":1,"featured_media":8551,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"footnotes":""},"categories":[5720,1226],"tags":[1227,1230,1229,4],"class_list":["post-8542","page","type-page","status-publish","has-post-thumbnail","hentry","category-database","category-microsoft","tag-exam-70-762-microsoft-developing-sql-databases","tag-exam-70-762-microsoft-developing-sql-databases-free-practice-test","tag-exam-70-762-microsoft-developing-sql-databases-preparation-guide","tag-m4f"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Exam 70-762 \u2013 Microsoft Developing SQL Databases<\/title>\n<meta name=\"description\" content=\"Give boost to your career and upgrade your resume by taking the Exam 70-762 \u2013 Microsoft Developing SQL Databases Exam. Hurry up, try free practice test now!\" \/>\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-762-microsoft-developing-sql-databases\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Exam 70-762 \u2013 Microsoft Developing SQL Databases\" \/>\n<meta property=\"og:description\" content=\"Give boost to your career and upgrade your resume by taking the Exam 70-762 \u2013 Microsoft Developing SQL Databases Exam. Hurry up, try free practice test now!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-762-microsoft-developing-sql-databases\/\" \/>\n<meta property=\"og:site_name\" content=\"Testprep Training Tutorials\" \/>\n<meta property=\"article:modified_time\" content=\"2021-05-27T13:56:03+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/06\/Exam-70-762-\u2013-Microsoft-Developing-SQL-Databases-1.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=\"13 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-762-microsoft-developing-sql-databases\/\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-762-microsoft-developing-sql-databases\/\",\"name\":\"Exam 70-762 \u2013 Microsoft Developing SQL Databases\",\"isPartOf\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#website\"},\"datePublished\":\"2020-06-23T06:40:48+00:00\",\"dateModified\":\"2021-05-27T13:56:03+00:00\",\"description\":\"Give boost to your career and upgrade your resume by taking the Exam 70-762 \u2013 Microsoft Developing SQL Databases Exam. Hurry up, try free practice test now!\",\"breadcrumb\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-762-microsoft-developing-sql-databases\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-762-microsoft-developing-sql-databases\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-762-microsoft-developing-sql-databases\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Exam 70-762 \u2013 Microsoft Developing SQL Databases\"}]},{\"@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-762 \u2013 Microsoft Developing SQL Databases","description":"Give boost to your career and upgrade your resume by taking the Exam 70-762 \u2013 Microsoft Developing SQL Databases Exam. Hurry up, try free practice test now!","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-762-microsoft-developing-sql-databases\/","og_locale":"en_US","og_type":"article","og_title":"Exam 70-762 \u2013 Microsoft Developing SQL Databases","og_description":"Give boost to your career and upgrade your resume by taking the Exam 70-762 \u2013 Microsoft Developing SQL Databases Exam. Hurry up, try free practice test now!","og_url":"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-762-microsoft-developing-sql-databases\/","og_site_name":"Testprep Training Tutorials","article_modified_time":"2021-05-27T13:56:03+00:00","og_image":[{"width":750,"height":400,"url":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/06\/Exam-70-762-\u2013-Microsoft-Developing-SQL-Databases-1.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"13 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-762-microsoft-developing-sql-databases\/","url":"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-762-microsoft-developing-sql-databases\/","name":"Exam 70-762 \u2013 Microsoft Developing SQL Databases","isPartOf":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#website"},"datePublished":"2020-06-23T06:40:48+00:00","dateModified":"2021-05-27T13:56:03+00:00","description":"Give boost to your career and upgrade your resume by taking the Exam 70-762 \u2013 Microsoft Developing SQL Databases Exam. Hurry up, try free practice test now!","breadcrumb":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-762-microsoft-developing-sql-databases\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-762-microsoft-developing-sql-databases\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-762-microsoft-developing-sql-databases\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.testpreptraining.ai\/tutorial\/"},{"@type":"ListItem","position":2,"name":"Exam 70-762 \u2013 Microsoft Developing SQL Databases"}]},{"@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\/8542","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=8542"}],"version-history":[{"count":21,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/8542\/revisions"}],"predecessor-version":[{"id":21563,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/8542\/revisions\/21563"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/media\/8551"}],"wp:attachment":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/media?parent=8542"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/categories?post=8542"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/tags?post=8542"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}