Exam 70-762 Developing SQL Databases

这个考试还是很有用的，教了很多有用的东西，不错，虽然考试需要很多钱，不过值的尝试。虽然用了sql server 这么多年但是对于事务、多并发的优化还是处于小学生的水平，通过这次考试争取让自己提一个档次。好好学习

 

不看书不知道自己有多浅薄，人无知更要多读书。

 

Resources

• Clustered and Nonclustered Indexes
• Columnstore Indexes – Design Guidance
• Create and update database tables
• Tutorial: Writing Transact-SQL Statements
• Views
• DDL Triggers
• Lesson 2-3 Creating Views and Stored Procedures
• Primary and Foreign Key Constraints
• Unique Constraints and Check Constraints
• User-Defined Functions
• Introduction to Memory-Optimized Tables
• SQL Server Transaction Locking and Row Versioning Guide
• Best Practice with Query Store
• Extended Events
• Performance Center for SQL Server Database and Azure SQL Database