From the course: Designing Database Solutions for SQL Server 2016

Welcome - SQL Server Tutorial

From the course: Designing Database Solutions for SQL Server 2016

Start my 1-month free trial

Welcome

“

- [Adam] Hi, my name is Adam Wilbert and I'd like to welcome you to Designing Database Solutions for SQL Server 2016. In this course, I'll expand on the basics of working with SQL Server and introduce you to a number of advanced concepts that you need to be aware of when working as a team to design a database solution for your organization. I'll start with the physical design of the database. Some best practices for storing files on disk and preparing the server for efficient usage. I'll touch on backup strategies to minimize the impact of a failure and security concepts to ensure that people have access to the resources and permissions that they need and are kept out of those that they do not. Finally, I'll explore some of the optimization strategies that can be implemented in SQL Server to help the system run smoothly now and into the future by maximizing concurrency, compressing data tables, and monitoring performance. We have a lot to cover so let's dig into Designing Database Solutions for SQL Server 2016.

Contents