SQL Server 2016: Administer a Database Infrastructure/ with Adam Wilbert.

Format:

Video

Author/Creator:

Wilbert, Adam, speaker.

Contributor:

linkedin.com (Firm)

Language:

English

Genre:

Instructional films.

Educational films.

Video recordings.

Physical Description:

1 online resource

polychrome

Place of Publication:

Carpenteria, CA:: linkedin.com, 2017.

System Details:

Latest version of the following browsers: Chrome, Safari, Firefox, or Internet Explorer. Adobe Flash Player Plugin. JavaScript and cookies must be enabled. A broadband Internet connection.

Summary:

Learn how to administer SQL Server 2016, and prepare for the Microsoft MCSA Administering a SQL Database Infrastructure (70-764) certification exam.

SQL Server comes with many features for monitoring, securing, optimizing, and supporting your database infrastructure. Learn how to use these features to administer your SQL Server instances, and prepare for the Microsoft MCSA Administering a SQL Database Infrastructure (70-764) certification exam. Adam Wilbert covers four main skill areas required of SQL Server 2016 administrators: configuring access to data, managing backups, monitoring performance, and implementing the high-availability features of the product. Learn about data encryption, access control, role-level security, and dynamic data masking. Use SQL Server auditing to gain insights into the health and performance of your system, and determine upgrade paths. Discover how to back up SQL Server and perform full or partial restores, and monitor activity. Explore indexing and query execution plan management. Plus, learn to configure availability groups to mitigate hardware failure.

Participant:

Presenter: Adam Wilbert

Notes:

8/11/20171

Access Restriction:

Restricted for use by site license.