Getting Started with SQL Server 2016 Administration [Video]
This is the code repository for Getting Started with SQL Server 2016 Administration [Video], published by Packt. It contains all the supporting project files necessary to work through the video course from start to finish.
About the Video Course
SQL Server DBAs enable efficient administration of its SQL Server solution to get breakthrough performance and top-notch security.
This video will teach you basic as well as advanced administration tasks for handling, managing, and monitoring your SQL Server 2016 efficiently. After setting up and configuring your virtual machine for SQL Server 2016, you will implement various techniques to improve query performance, create indexes, and perform activity monitoring. You will learn how to secure your SQL Server solution by implementing various authentication techniques. Finally, you'll ensure your database is always available and ready for any catastrophe. This comprehensive tutorial is packed with real-world examples and tips to solve the trickiest of challenges.
By the end of this course, you will have a solid foundation in all SQL Server administration concepts and will be able to implement them in a production environment.
What You Will Learn
- How to install SQL Server
- Login and user security
- Creating user databases
- Administering database objects
- How to improve query performance
Instructions and Navigation
Assumed Knowledge
To fully benefit from the coverage included in this course, you will need:
If you are an administrator, developer, or a DBA with some knowledge of SQL Server concepts who wants want to learn SQL Administration, this video is for you. Some understanding of T-SQL would be helpful, but not mandatory.
Technical Requirements
This course has the following software requirements:
SQL sever 2016