Book description
Prepare for Microsoft Exam 70-762, Developing SQL Databases –and help demonstrate your real-world mastery of skills for building and implementing databases across organizations. Designed for database professionals who build and implement databases across organizations and who ensure high levels of data availability, Exam Ref focuses on the critical-thinking and decision-making acumen needed for success at the MCSA level.
Focus on the expertise measured by these objectives:
• Design and implement database objects
• Implement programmability objects
• Manage database concurrency
• Optimize database objects and SQL infrastructure
This Microsoft Exam Ref:
• Organizes its coverage by exam objectives
• Features strategic, what-if scenarios to challenge you
• Assumes you have working knowledge of Microsoft Windows, Transact-SQL, and relational databases
About the Exam
Exam 70-762 focuses on skills and knowledge for building and implementing databases across organizations and ensuring high levels of data availability.
About Microsoft Certification
Passing this exam earns you credit toward a Microsoft Certified Solutions Associate
(MCSA) certification that demonstrates your mastery of modern database
development. Exam 70-761 (Querying Data with Transact-SQL) is also required for MCSA: SQL 2016 Database Development. See full details at: microsoft.com/learning
Table of contents
- Cover
- Title Page
- Copyright Page
- Contents at a glance
- Contents
- Introduction
- Chapter 1. Design and implement database objects
-
Chapter 2. Implement programmability objects
- Skill 2.1 Ensure data integrity with constraints
- Skill 2.2 Create stored procedures
-
Skill 2.3 Create triggers and user-defined functions
- Design trigger logic based on business requirements
- Determine when to use Data Manipulation Language (DML) triggers, Data Definition Language (DDL) triggers, or logon triggers
- Recognize results based on execution of AFTER or INSTEAD OF triggers
- Design scalar-valued and table-valued user-defined functions based on business requirements
- Identify differences between deterministic and non-deterministic functions
- Chapter summary
- Thought Experiment
- Though Experiment Answer
- Chapter 3. Manage database concurrency
-
Chapter 4. Optimize database objects and SQL infrastructure
- Skill 4.1: Optimize statistics and indexes
- Skill 4.2: Analyze and troubleshoot query plans
-
Skill 4.3: Manage performance for database instances
- Manage database workload in SQL Server
- Design and implement Elastic Scale for Azure SQL Database
- Select an appropriate service tier or edition
- Optimize database file and tempdb configuration
- Optimize memory configuration
- Monitor and diagnose schedule and wait statistics using dynamic management objects
- Troubleshoot and analyze storage, IO, and cache issues
- Monitor Azure SQL Database query plans
-
Skill 4.4: Monitor and trace SQL Server baseline performance metrics
- Monitor operating system and SQL Server performance metrics
- Compare baseline metrics to observed metrics while troubleshooting performance issues
- Identify differences between performance monitoring and logging tools
- Monitor Azure SQL Database performance
- Determine best practice use cases for extended events
- Distinguish between Extended Events targets
- Compare the impact of Extended Events and SQL Trace
- Define differences between Extended Events Packages, Targets, Actions, and Sessions
- Chapter summary
- Thought experiment
- Thought experiment answer
- Index
- About the authors
- Free ebooks
- Survey
- Code Snippets
Product information
- Title: Exam Ref 70-762 Developing SQL Databases, First Edition
- Author(s):
- Release date: January 2017
- Publisher(s): Microsoft Press
- ISBN: 9781509304929
You might also like
book
Exam Ref 70-767 Implementing a SQL Data Warehouse
Prepare for Microsoft Exam 70-767–and help demonstrate your real-world mastery of skills for managing data warehouses. …
video
Developing SQL Databases - Exam 70-762 Certification
Microsoft exam 70-762 is one of two exams you must pass to earn a Microsoft Certified …
video
SQL Server 70-762: Developing SQL Databases: Required Knowledge for SQL Server 2012 and 2014
More than 19 hours of video instruction to help you learn and master the skills necessary …
book
Exam Ref 70-764 Administering a SQL Database Infrastructure
Prepare for Microsoft Exam 70-764—and help demonstrate your real-world mastery of skills for database administration. This …