Overview

Prepare for Microsoft Exam 70-762, Developing SQL Databases –and help demonstrate your real-world mastery of skills for building and implementing databases across organisations. Designed for database professionals who build and implement databases across organisations 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 Optimise database objects and SQL infrastructure

Full Product Details

Author:   Louis Davidson ,  Stacia Varga
Publisher:   Microsoft Press,U.S.
Imprint:   Microsoft Press
Dimensions:   Width: 18.80cm , Height: 2.30cm , Length: 22.60cm
Weight:   0.700kg
ISBN:  

9781509304912

ISBN 10:   1509304916
Pages:   400
Publication Date:   01 March 2017
Audience:   Professional and scholarly ,  Professional & Vocational
Format:   Paperback
Publisher's Status:   Active
Availability:   In Print  
This item will be ordered in for you from one of our suppliers. Upon receipt, we will promptly dispatch it out to you. For in store availability, please contact us.

Table of Contents

Chapter 1 Design and implement database objects 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

Reviews

Author Information

Louis Davidson, Microsoft MVP (Data Platform), Senior Data Architect for CBN. Over 20 years of experience with SQL Server as an architect, developer, and writer.   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

Tab Content 6

Author Website:  

Customer Reviews

Recent Reviews

No review item found!

Add your own review!

Countries Available

All regions