Lynda – Designing Database Solutions for SQL Server 2016-0daytown

Lynda – Designing Database Solutions for SQL Server 2016
Size: 387 MB | Duration: 3h 15m | Video: AVC (.mp4) 1280×720 15&30fps | Audio: AAC 48KHz 2ch
Genre: eLearning | Level: Advanced | Language: English
When you’re 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 you’ll 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 you’re 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