Free Worldwide Shipping

Shop over 1 Million Toys in our Huge New Range

Exam Ref 70-762 Developing SQL Databases
By

Rating

Product Description
Product Details

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

About the Author

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. He tweets as @drsql.

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_.

Ask a Question About this Product More...
Write your question below:
Look for similar items by category
Item ships from and is sold by Fishpond World Ltd.
Back to top