MCSA: SQL 2016 Database Administration Online Training

Focused View

Garth Schulte

9:54:30

33 View

001 Configure Encryption SQL Server Encryption.mp4

04:53

002 Configure Encryption Implement Cell-Level Encryption.mp4

07:18

003 Configure Encryption Implement Always Encrypted.mp4

10:45

004 Configure Encryption Implement Backup Encryption.mp4

05:55

005 Configure Encryption Configure Transparent Data Encryption.mp4

06:12

006 Configure Encryption Configure Encryption for Connections.mp4

07:27

007 Configure Encryption Troubleshoot Encryption Errors.mp4

05:33

008 Configure Encryption Lab.mp4

11:48

009 Configure Data Access and Permissions SQL Server Data Access.mp4

04:53

010 Configure Data Access and Permissions Create and Maintain Users.mp4

09:55

011 Configure Data Access and Permissions Create and Maintain Custom Roles.mp4

08:24

012 Configure Data Access and Permissions Manage Database Object Permissions.mp4

08:12

013 Configure Data Access and Permissions Configure Row-Level Security.mp4

07:14

014 Configure Data Access and Permissions Configure Dynamic Data Masking.mp4

04:43

015 Configure Data Access and Permissions Configure User Options in Azure.mp4

08:40

016 Configure Data Access and Permissions Lab.mp4

12:01

017 Configure Auditing SQL Server Auditing.mp4

03:33

018 Configure Auditing Configure an Audit on SQL Server.mp4

07:58

019 Configure Auditing Query the SQL Server Audit Log.mp4

06:45

020 Configure Auditing Manage an SQL Server Audit.mp4

05:56

021 Configure Auditing Configure an Azure SQL Database Audit.mp4

06:53

022 Configure Auditing Analyze Audit Logs and Reports from Azure SQL Database.mp4

07:45

023 Configure Auditing Lab.mp4

09:50

024 Develop a Backup Strategy SQL Server Backup.mp4

06:37

025 Develop a Backup Strategy Backup Databases.mp4

07:02

026 Develop a Backup Strategy Back up Very Large Databases.mp4

07:31

027 Develop a Backup Strategy Manage Transaction Log Backups.mp4

07:43

028 Develop a Backup Strategy Configure Database Recovery Models.mp4

04:43

029 Develop a Backup Strategy Configure Backup Automation.mp4

10:15

030 Develop a Backup Strategy Configure Alerting for Failed Backups.mp4

06:50

031 Develop a Backup Strategy Back up Databases to Azure.mp4

05:09

032 Develop a Backup Strategy Lab.mp4

10:02

033 Restore Databases SQL Server Restore.mp4

05:13

034 Restore Databases Perform Restores.mp4

05:27

035 Restore Databases Perform Piecemeal Restores.mp4

06:17

036 Restore Databases Perform Page Recovery.mp4

05:09

037 Restore Databases Perform Point-in-Time Recovery.mp4

07:25

038 Restore Databases Restore Filegroups.mp4

03:37

039 Restore Databases Test and Automate Restores.mp4

07:30

040 Restore Databases Lab.mp4

08:50

041 Manage Database Integrity SQL Server Database Integrity.mp4

04:09

042 Manage Database Integrity Implement Database Consistency Checks.mp4

06:40

043 Manage Database Integrity Identify Database Corruption.mp4

07:21

044 Manage Database Integrity Recover from Database Corruption.mp4

04:46

045 Manage Database Integrity Lab.mp4

07:10

046 Monitor Database Activity SQL Server Database Monitoring.mp4

03:26

047 Monitor Database Activity Monitor Current Sessions.mp4

05:44

048 Monitor Database Activity Identify Sessions that Cause Blocking Activity.mp4

05:10

049 Monitor Database Activity Identify Sessions that Consume TempDB Resources.mp4

04:59

050 Monitor Database Activity Configure the Data Collector.mp4

05:35

051 Monitor Database Activity Lab.mp4

07:28

052 Monitor Queries SQL Server Query Monitoring.mp4

03:51

053 Monitor Queries Manage the Query Store.mp4

06:13

054 Monitor Queries Identify Problematic Execution Plans.mp4

08:22

055 Monitor Queries Configure Extended Events and Trace Events.mp4

08:37

056 Monitor Queries Troubleshoot Server Health using Extended Events.mp4

03:47

057 Monitor Queries Lab.mp4

08:11

058 Manage Indexes SQL Server Index Management.mp4

03:43

059 Manage Indexes Identify and Repair Index Fragmentation.mp4

06:32

060 Manage Indexes Identify and Create Missing Indexes.mp4

04:27

061 Manage Indexes Identify and Drop Underutilized Indexes.mp4

04:15

062 Manage Indexes Manage Existing Columnstore Indexes.mp4

06:03

063 Manage Indexes Lab.mp4

06:24

064 Manage Statistics SQL Server Statistics Management.mp4

03:44

065 Manage Statistics Identify and Correct Outdated Statistics.mp4

04:54

066 Manage Statistics Implement Auto Update Statistics.mp4

03:41

067 Manage Statistics Implement Statistics for Large Tables.mp4

04:39

068 Manage Statistics Lab.mp4

11:51

069 Monitor SQL Server Instances SQL Server Instance Monitoring.mp4

03:05

070 Monitor SQL Server Instances Configure Database Mail.mp4

05:51

071 Monitor SQL Server Instances Create and Manage Operators.mp4

03:29

072 Monitor SQL Server Instances Create and Manage Alerts.mp4

05:14

073 Monitor SQL Server Instances Define Custom Alert Actions.mp4

03:24

074 Monitor SQL Server Instances Define Failure Actions.mp4

02:56

075 Monitor SQL Server Instances Configure Policy-based Management.mp4

05:27

076 Monitor SQL Server Instances Identify Available Space on Data Volumes.mp4

02:45

077 Monitor SQL Server Instances Identify the Cause of Performance Degredation.mp4

03:54

078 Monitor SQL Server Instances Lab.mp4

08:11

079 Implement Log Shipping SQL Server Log Shipping.mp4

03:53

080 Implement Log Shipping Configure Log Shipping.mp4

10:09

081 Implement Log Shipping Monitor Log Shipping.mp4

06:19

082 Implement Log Shipping Lab.mp4

07:05

083 Implement Always On Availability Groups SQL Server Always On Availability Groups.mp4

05:49

084 Implement Always On Availability Groups Configure Windows Clustering.mp4

05:57

085 Implement Always On Availability Groups Create an Availability Group.mp4

11:38

086 Implement Always On Availability Groups Configure Read-only Routing.mp4

06:11

087 Implement Always On Availability Groups Manage Failover.mp4

04:17

088 Implement Always On Availability Groups Create Distributed Availability Groups.mp4

02:54

089 Implement Always On Availability Groups Lab.mp4

08:54

090 Implement Failover Cluster Instances SQL Server Always On Failover Cluster Instances.mp4

02:44

091 Implement Failover Cluster Instances Configure Shared Storage.mp4

08:57

092 Implement Failover Cluster Instances Create Failover Cluster Instances.mp4

09:45

093 Implement Failover Cluster Instances Lab.mp4

06:07

Description

In this Microsoft MCSA: SQL 2016 training, Garth Schulte covers the objectives in both exams required to earn the MCSA: SQL 2016 certification — Microsoft exams 70-764 and 70-765.

More details

MCSA: SQL 2016 Database Administration was designed by Microsoft to validate the entry-level skills expected of a database administrator with about a year of experience, which includes planning, deploying, and configuring a SQL database with Azure SQL and SQL Server.

For anyone who leads a data team, this MCSA training can be used for 70-764 and 70-765 exam prep, on-boarding new database administrators, or as part of a team training plan.

MCSA: SQL 2016 Database Administration: What You Need to Know

For any database administrator using this training for exam preparation, our MCSA: SQL 2016 Database Development course maps to the Microsoft MCSA: SQL 2016 Database Development exam objectives, and covers topics such as:

Microsoft Azure SQL database deployment: service tiers, creation of servers and databases, sysadmin account, elastic pools,
SQL Server Installation: IaaS vs. on-premises, storage design, performance requirements
SQL Server instances deployment: templates, automation, VM provisioning, migration
Secure access configuration: firewall rules, encryption, dynamic data masking
SQL Server Performance Settings: configuration; operators and alerts
SQL Server Instances management: database creation, file management, system database files
Storage management: overview, SMB file shares, service tiers, storage pools, storage recovery
Data Access and Permissions: create and maintain user and roles

Who Should Take MCSA: SQL 2016 Database Administrator Training?

This MCSA: SQL 2016 Database Administrator training is considered associate-level Microsoft training, which means it was designed for database administrators. This MCSA: SQL 2016 Database Administrator course is valuable for new IT professionals with at least a year of experience with SQL database and experienced database administrators looking to validate their Microsoft skills.

New or aspiring database administrators. New database administrators can quickly improve their knowledge and accelerate their careers with MCSA: SQL 2016 Database Administration training. The ability to develop SQL databases as well as administer them could qualify new IT professionals for specialized roles in their organizations â€” since with greater skills come greater opportunities. MCSA-certified database engineers are in high demand and can command a good salary.

Experienced database administrators. Continuous learning is the key to both personal development and career growth. Experienced SQL administrators can take the next step in their database careers by learning database development. A certification in MCSA SQL 2016 Database Administration can be the ticket to more senior positions, like database engineer.

User Reviews

Rating

average 0

Total votes0

Focused display

Database Programming

Microsoft SQL

Garth Schulte

Instructor's Courses

"I've always believed the best way to learn anything is to see it happen and try it yourself. My first experience with CBT Nuggets reinforced that belief and I'm both proud and honored to be a part of a company that strives to enrich people's lives with the power of knowledge!"

Garth Schulte began training on Office products about 20 years ago. His love of training led him to branch out to technical VB6 and SQL Server training. One of CBT Nuggets’ longest-tenured trainers, he recently worked as a product manager, lead .NET windows programmer and SQL Server architect for one of the top back-end real estate software companies in the country. He is a Google Authorized Trainer.

Certifications: Google Developer Expert, Google Certified Trainer, MCSD, MCSD.NET, MCDBA, MCSA

Areas of expertise: Windows Server, SQL Server, Microsoft Azure, Google Cloud Platform, .NET Development, DevOps (Docker/Kubernetes)

CBT Nuggets

View courses CBT Nuggets

CBT Nuggets is renowned for providing innovative training that's informative, meaningful, and engaging. We provide a variety of training, primarily in IT, project management, and office productivity topics. Our comprehensive library contains thousands of training videos ranging from Cisco networking to Microsoft Word. Whether you want to pass a certification exam, increase your skills, or simply learn new things, we've got you covered! All of our training is delivered through high-quality online streaming video. Subscribers can train 24 hours a day, seven days a week, from the convenience of a computer or mobile device. CBT Nuggets trainers are the rock stars of training, renowned for their expertise, industry-wide credibility, and engaging personalities. They enable CBT Nuggets to deliver accurate, up-to-date training, using a laid-back whiteboard presentation style. There are no scripts, EVER. Our trainers love to teach, and it shows! CEO and founder Dan Charbonneau was a Microsoft trainer when he began recording CBT Nuggets' very first training videos back in the 1990s. He wanted to help provide large organizations, small teams and individuals with comprehensive and budget-conscious training, and he realized it couldn't be done in a classroom. From the CBT Nuggets World Headquarters in Eugene, Oregon, Dan and his team promise each video will be informative, comprehensive, accurate, and fun to watch.