Microsoft SQL Server 2016: Installation and Administration
Microsoft SQL Server 2016: Installation and Administration is an Intermediate level study on Business, compiled by an expert, Gerry O'Brien. This study is a critical foundation for a person who needs to excel in his/her Business skills. It provides you a strong understanding on Business, Developer, Web, Servers, Databases, SQL Server, Business, Developer, Web, Servers, Databases and SQL Server.
SQL Server is the database used with Azure and many on-premises environments and is quickly becoming a very popular RDBMS. Get an overview of installing, administering, and managing SQL Server 2016 in this course with SQL Server expert Gerry O’Brien. Learn how to install the database and tools, configure different instances, optimize performance, and secure your database with user roles and logins. Gerry also covers administrative duties such as backup and restoration, database migration, and high-availability options, including database replication, log shipping, and always-on availability.
This course is also ideal for anybody preparing for the Administering a SQL Database Infrastructure (70-764) exam, one of two exams necessary to earn an MCSA: SQL 2016 Database Administration certification.
- Installation and configuration considerations
- Data storage strategies
- Configuring database instances
- Performance considerations
- Security considerations
- Managing roles and users
- Managing data
- High-availability options