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.

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

Fishpond works with suppliers all over the world to bring you a huge selection of products, really great prices, and delivery included on over 25 million products that we sell. We do our best every day to make Fishpond an awesome place for customers to shop and get what they want — all at the best prices online.

About Fishpond

You can earn a 8% commission by selling Exam Ref 70-762 Developing SQL Databases (Exam Ref) on your website. It's easy to get started - we will give you example code. After you're set-up, your website can earn you money while you work, play or even sleep! You should start right now!

Are you the Author or Publisher of a book? Or the manufacturer of one of the millions of products that we sell. You can improve sales and grow your revenue by submitting additional information on this title. The better the information we have about a product, the more we will sell!

Submit Information

Table of Contents

About the Author