
Exam Ref 70-762 Developing SQL Databases
Description
Alles über E-Books | Antworten auf Fragen rund um E-Books, Kopierschutz und Dateiformate finden Sie in unserem Info- & Hilfebereich.
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
More details
Other editions
Additional editions

Persons
Stacia Varga, Microsoft MVP (Data Platform) is a consultant, educator, mentor, and author specializing in data solutions since 1999. She provides consulting and custom education services through her company, Data Inspirations, and writes about her experiences with data at blog.datainspirations.com, and tweets as @_StaciaV_.
Content
Skill 1.1: Design and implement a relational database schema
Skill 1.2: Design and implement indexes
Skill 1.3: Design and implement views
Skill 1.4: Implement columnstore indexes
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
Chapter 3 Manage database concurrency
Skill 3.1: Implement transactions
Skill 3.2: Manage isolation levels
Skill 3.3: Optimize concurrency and locking behavior
Skill 3.4: Implement memory-optimized tables and native stored procedures
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
Skill 4.4: Monitor and trace SQL Server baseline performance metrics
System requirements
File format: ePUB
Copy protection: Adobe-DRM (Digital Rights Management)
System requirements:
- Computer (Windows; MacOS X; Linux): Install the free reader Adobe Digital Editions prior to download (see eBook Help).
- Tablet/smartphone (Android; iOS): Install the free app Adobe Digital Editions or the app PocketBook before downloading (see eBook Help).
- E-reader: Bookeen, Kobo, Pocketbook, Sony, Tolino and many more (not Kindle).
The file format ePub works well for novels and non-fiction books – i.e., „flowing” text without complex layout. On an e-reader or smartphone, line and page breaks automatically adjust to fit the small displays.
This eBook uses Adobe-DRM, a „hard” copy protection. If the necessary requirements are not met, unfortunately you will not be able to open the eBook. You will therefore need to prepare your reading hardware before downloading.
Please note: We strongly recommend that you authorise using your personal Adobe ID after installation of any reading software.
For more information, see our ebook Help page.