Skill

Microsoft MCSA SQL Server 2016 (70-765)

August 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 provision a SQL Server 2016 Database. Learn to manage databases, instances, and storage; implement SQL in Azure; and more.

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-765 exam, the second of two exams that must be passed to receive your Microsoft MCSA: SQL 2016 Database Administration certification.

Recommended Experience

Completion of the Microsoft MCSA SQL Server 2016 70-764 course is recommended

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 has received 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. Implement SQL in Azure: Overview (2:52)
4. Deploy a Microsoft Azure SQL Database: Choose a Service Tier (4:57)
5. Deploy a Microsoft Azure SQL Database: Create Servers and Databases (9:50)
6. Deploy a Microsoft Azure SQL Database: Create a Sysadmin Account (3:23)
7. Deploy a Microsoft Azure SQL Database: Configure Elastic Pools (6:28)
8. Deploy a Microsoft Azure SQL Database: Lab (7:48)
9. Plan for SQL Server Installation: Plan for an IaaS or On-premises Deployment (3:26)
10. Plan for SQL Server Installation: Select the Appropriate Size for a Virtual Machine (4:33)
11. Plan for SQL Server Installation: Design a Storage Layout for a SQL Server Virtual Machine (5:18)
12. Plan for SQL Server Installation: Plan Storage Pools Based on Performance Requirements (3:42)
13. Plan for SQL Server Installation: Evaluate Best Practices for Installation (4:26)
14. Deploy SQL Server Instances: Deploy a SQL Server Instance in IaaS and On-premises (6:52)
15. Deploy SQL Server Instances: Provision an Azure Virtual Machine to Host a SQL Server Instance (5:01)
16. Deploy SQL Server Instances: Manually Install SQL Server on an Azure Virtual Machine (3:51)
17. Deploy SQL Server Instances: Deploy SQL Server by using Templates (3:56)
18. Deploy SQL Server Instances: Automate the Deployment of SQL Server Databases (5:19)
19. Deploy SQL Server Instances: Lab (5:30)
20. Deploy SQL Server Databases to Azure Virtual Machines: Migrate an On-premise SQL Server Database to an Azure Virtual Machine (5:56)
21. Deploy SQL Server Databases to Azure Virtual Machines: Generate Benchmark Data for Performance Needs (4:19)
22. Deploy SQL Server Databases to Azure Virtual Machines: Performance Tuning on Azure IaaS (5:37)
23. Deploy SQL Server Databases to Azure Virtual Machines: Support Availability Sets in Azure (4:43)
24. Deploy SQL Server Databases to Azure Virtual Machines: Lab (5:34)
25. Manage Databases and Instances: Overview (2:01)
26. Configure Secure Access to Microsoft Azure SQL Databases: Configure Firewall Rules (4:08)
27. Configure Secure Access to Microsoft Azure SQL Databases: Configure Cell-Level Encryption (2:38)
28. Configure Secure Access to Microsoft Azure SQL Databases: Configure Always Encrypted (4:48)
29. Configure Secure Access to Microsoft Azure SQL Databases: Configure Dynamic Data Masking (3:55)
30. Configure Secure Access to Microsoft Azure SQL Databases: Configure Transparent Data Encryption (TDE) (2:40)
31. Configure Secure Access to Microsoft Azure SQL Databases: Lab (7:07)
32. Configure SQL Server Performance Settings: Configure Server Performance Settings (5:15)
33. Configure SQL Server Performance Settings: Configure Database Performance Settings (5:05)
34. Configure SQL Server Performance Settings: Configure Operators and Alerts (4:46)
35. Configure SQL Server Performance Settings: Lab (4:55)
36. Manage SQL Server Instances: Create Databases (6:18)
37. Manage SQL Server Instances: Manage Files and Filegroups (6:53)
38. Manage SQL Server Instances: Manage System Database Files (6:53)
39. Manage SQL Server Instances: Configure TempDB (4:40)
40. Manage SQL Server Instances: Lab (7:02)
41. Manage Storage: Overview (2:57)
42. Manage Storage: Manage SMB File Shares (3:48)
43. Manage Storage: Manage Stretch Databases (4:25)
44. Manage Storage: Configure Azure Storage (6:05)
45. Manage Storage: Change Service Tiers (2:25)
46. Manage Storage: Review Wait Statistics (3:48)
47. Manage Storage: Manage Storage Pools (3:46)
48. Manage Storage: Recover from Failed Storage (4:03)
49. Manage Storage: Lab (7:39)
50. Perform Database Maintenance: Monitor DMVs (6:22)
51. Perform Database Maintenance: Maintain Indexes (4:29)
52. Perform Database Maintenance: Automate Maintenance Tasks (7:54)
53. Perform Database Maintenance: Update Statistics (4:39)
54. Perform Database Maintenance: Verify Database Integrity (5:23)
55. Perform Database Maintenance: Recover from Database Corruption (4:08)
56. Perform Database Maintenance: Lab (6:27)

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