Adam Wilbert – Designing Database Solutions for SQL Server 2016

Adam Wilbert – Designing Database Solutions for SQL Server 2016

When youre working with a team to design a SQL Server 2016 database solution for your organization, there are certain advanced concepts you need to know.

In this course, Adam Wilbert introduces you to some of the concepts youll need to design elegant database solutions that set up your team for success. He covers how to prepare the server for efficient usage, use backup strategies to minimize the impact of a failure, and follow security concepts to ensure users are granted the appropriate permissions for their roles. Plus, Adam covers some of the optimization strategies you can implement in SQL Server to help the system run smoothly in the future. This course maps to the Microsoft Certified Solutions Expert: Data Platform exam, Designing Database Solutions for SQL Server. If youre planning on taking this exam, this course is a good place to start your test preparation.

Topics include:
– Building a database structure
– Identifying backup and recovery solutions
– Designing a database and table design
– Setting up security
– Creating automated maintenance plans
– Troubleshooting and optimizing
– Maintaining high availability
– Planning a disaster recovery solution