Skill

Microsoft MCSA SQL Server 2016 (70-764)

April 2018 with Garth Schulte

The exam associated with this skill has been retired. However, this skill still retains value as a training resource.

In this course, trainer Garth Schulte teaches you how to administer a SQL Server 2016 Database. Prepare for Microsoft's 70-764 certification exam as you learn to configure data access and auditing; manage database backup and restore; manage high availability and disaster recovery; and manage and monitor SQL server instances.

Take your SQL Server 2016 knowledge to the next level by using our hands-on virtual lab environment as you prepare for Microsoft's 70-764 exam, the first of two exams that must be passed to receive your Microsoft MCSA: SQL 2016 Database Administration certification.

Recommended Experience

Familiarity with databases

Recommended Equipment

Microsoft SQL Server 2016

Related Certifications

MCSA: SQL 2016 Database Administration
MCSE: Data Management and Analytics

Related Job Functions

Database administrators
System engineers
Database developers
Database analysts

Garth Schulte has been a CBT Nuggets trainer since 2001 and holds a variety of Microsoft and Google certifications spanning system administration, development, databases, cloud, and big data.

Garth Schulte — Garth Schulte
Trainer

Videos in this skill

1. Introducing SQL Server 2016 (5:30)
2. SQL Server 2016 Certifications (6:49)
3. Configure Encryption: SQL Server Encryption (4:53)
4. Configure Encryption: Implement Cell-Level Encryption (7:18)
5. Configure Encryption: Implement Always Encrypted (10:45)
6. Configure Encryption: Implement Backup Encryption (5:56)
7. Configure Encryption: Configure Transparent Data Encryption (6:13)
8. Configure Encryption: Configure Encryption for Connections (7:28)
9. Configure Encryption: Troubleshoot Encryption Errors (5:34)
10. Configure Encryption: Lab (11:48)
11. Configure Data Access and Permissions: SQL Server Data Access (4:53)
12. Configure Data Access and Permissions: Create and Maintain Users (9:56)
13. Configure Data Access and Permissions: Create and Maintain Custom Roles (8:24)
14. Configure Data Access and Permissions: Manage Database Object Permissions (8:12)
15. Configure Data Access and Permissions: Configure Row-Level Security (7:15)
16. Configure Data Access and Permissions: Configure Dynamic Data Masking (4:43)
17. Configure Data Access and Permissions: Configure User Options in Azure (8:40)
18. Configure Data Access and Permissions: Lab (12:01)
19. Configure Auditing: SQL Server Auditing (3:33)
20. Configure Auditing: Configure an Audit on SQL Server (7:59)
21. Configure Auditing: Query the SQL Server Audit Log (6:45)
22. Configure Auditing: Manage an SQL Server Audit (5:56)
23. Configure Auditing: Configure an Azure SQL Database Audit (6:54)
24. Configure Auditing: Analyze Audit Logs and Reports from Azure SQL Database (7:46)
25. Configure Auditing: Lab (9:51)
26. Develop a Backup Strategy: SQL Server Backup (6:37)
27. Develop a Backup Strategy: Backup Databases (7:02)
28. Develop a Backup Strategy: Back up Very Large Databases (7:31)
29. Develop a Backup Strategy: Manage Transaction Log Backups (7:43)
30. Develop a Backup Strategy: Configure Database Recovery Models (4:44)
31. Develop a Backup Strategy: Configure Backup Automation (10:15)
32. Develop a Backup Strategy: Configure Alerting for Failed Backups (6:50)
33. Develop a Backup Strategy: Back up Databases to Azure (5:09)
34. Develop a Backup Strategy: Lab (10:03)
35. Restore Databases: SQL Server Restore (5:13)
36. Restore Databases: Perform Restores (5:28)
37. Restore Databases: Perform Piecemeal Restores (6:17)
38. Restore Databases: Perform Page Recovery (5:10)
39. Restore Databases: Perform Point-in-Time Recovery (7:26)
40. Restore Databases: Restore Filegroups (3:38)
41. Restore Databases: Test and Automate Restores (7:30)
42. Restore Databases: Lab (8:51)
43. Manage Database Integrity: SQL Server Database Integrity (4:09)
44. Manage Database Integrity: Implement Database Consistency Checks (6:41)
45. Manage Database Integrity: Identify Database Corruption (7:22)
46. Manage Database Integrity: Recover from Database Corruption (4:46)
47. Manage Database Integrity: Lab (7:11)
48. Monitor Database Activity: SQL Server Database Monitoring (3:26)
49. Monitor Database Activity: Monitor Current Sessions (5:44)
50. Monitor Database Activity: Identify Sessions that Cause Blocking Activity (5:11)
51. Monitor Database Activity: Identify Sessions that Consume TempDB Resources (4:59)
52. Monitor Database Activity: Configure the Data Collector (5:35)
53. Monitor Database Activity: Lab (7:29)
54. Monitor Queries: SQL Server Query Monitoring (3:51)
55. Monitor Queries: Manage the Query Store (6:13)
56. Monitor Queries: Identify Problematic Execution Plans (8:23)
57. Monitor Queries: Configure Extended Events and Trace Events (8:38)
58. Monitor Queries: Troubleshoot Server Health using Extended Events (3:47)
59. Monitor Queries: Lab (8:11)
60. Manage Indexes: SQL Server Index Management (3:44)
61. Manage Indexes: Identify and Repair Index Fragmentation (6:33)
62. Manage Indexes: Identify and Create Missing Indexes (4:28)
63. Manage Indexes: Identify and Drop Underutilized Indexes (4:16)
64. Manage Indexes: Manage Existing Columnstore Indexes (6:03)
65. Manage Indexes: Lab (6:24)
66. Manage Statistics: SQL Server Statistics Management (3:44)
67. Manage Statistics: Identify and Correct Outdated Statistics (4:54)
68. Manage Statistics: Implement Auto Update Statistics (3:41)
69. Manage Statistics: Implement Statistics for Large Tables (4:39)
70. Manage Statistics: Lab (11:51)
71. Monitor SQL Server Instances: SQL Server Instance Monitoring (3:06)
72. Monitor SQL Server Instances: Configure Database Mail (5:51)
73. Monitor SQL Server Instances: Create and Manage Operators (3:30)
74. Monitor SQL Server Instances: Create and Manage Alerts (5:15)
75. Monitor SQL Server Instances: Define Custom Alert Actions (3:24)
76. Monitor SQL Server Instances: Define Failure Actions (2:57)
77. Monitor SQL Server Instances: Configure Policy-based Management (5:27)
78. Monitor SQL Server Instances: Identify Available Space on Data Volumes (2:46)
79. Monitor SQL Server Instances: Identify the Cause of Performance Degredation (3:54)
80. Monitor SQL Server Instances: Lab (8:11)
81. Implement Log Shipping: SQL Server Log Shipping (3:53)
82. Implement Log Shipping: Configure Log Shipping (10:10)
83. Implement Log Shipping: Monitor Log Shipping (6:20)
84. Implement Log Shipping: Lab (7:06)
85. Implement Always On Availability Groups: SQL Server Always On Availability Groups (5:50)
86. Implement Always On Availability Groups: Configure Windows Clustering (5:58)
87. Implement Always On Availability Groups: Create an Availability Group (11:38)
88. Implement Always On Availability Groups: Configure Read-only Routing (6:11)
89. Implement Always On Availability Groups: Manage Failover (4:17)
90. Implement Always On Availability Groups: Create Distributed Availability Groups (2:55)
91. Implement Always On Availability Groups: Lab (8:54)
92. Implement Failover Cluster Instances: SQL Server Always On Failover Cluster Instances (2:45)
93. Implement Failover Cluster Instances: Configure Shared Storage (8:57)
94. Implement Failover Cluster Instances: Create Failover Cluster Instances (9:46)
95. Implement Failover Cluster Instances: Lab (6:08)

Quizzes & Practice Exams

Reinforce core concepts and new skills with built-in quiz questions, and exams.

Virtual Labs

Explore new technology and apply your expertise in customized virtual labs.

Accountability Coaching

Define your goals and stick to a training plan with help from our coaches.

Learn this skill and so much more!

Gain instant access to our entire IT training library, free for your first week. Train anytime on your desktop, tablet, or mobile devices.

Not sure where to start?
Call 541-284-5522 or try our .

What is it like to train with us?

Our learners say it best.

Helps me learn the skills I need when I need them

THOMAS S. | SYSTEMS ENGINEER & CONSULTANT

Get CBT Nuggets IT training news and resources

Email Address

I have read and understood the privacy policy and am able to consent to it.

Product

Solutions

Resources

Company

Support

Follow us

Let's chat!

Sales | Support | General

© 2023 CBT Nuggets. All rights reserved.Terms | Privacy Policy | Accessibility | Sitemap | 2850 Crescent Avenue, Eugene, OR 97408 | 541-284-5522