Microsoft Certified: Azure Database Administrator Associate Online Training

Focused View

Knox Hutchinson

22:44:08

109 View

1 Deploy SQL Resources Using Manual Methods

1 Deploy Azure SQL Resources Manually.mp4

01:15

2 Azure SQL IaaS Deployment.mp4

19:35

3 Single Azure SQL Database Deployments.mp4

12:20

4 Elastic Pool Deployments.mp4

08:12

5 Azure SQL Managed Instance Deployments.mp4

22:20

6 Summarizing Azure SQL Manual Deployments.mp4

01:09

2 Evaluate SQL Database Deployment Options in Azure

7 Introducing the Azure SQL Platform.mp4

01:59

8 IaaS vs PaaS Offerings.mp4

16:48

9 vCore and DTU Pricing Models.mp4

15:51

10 vCore Service Tiers.mp4

10:15

11 vCore Compute Tiers.mp4

07:18

12 PaaS Backups and HADR.mp4

08:37

13 Summarizing the Azure SQL Platform Offerings.mp4

01:25

3 Configure Azure SQL for Scale and Performance

14 Introducing Scaling Your Azure SQL Instances.mp4

01:31

15 Configure Azure SQL VMs for Scale.mp4

07:04

16 Configure Azure SQL DBs for Scale.mp4

06:52

17 Configure Azure SQL Managed Instances for Scale.mp4

07:07

18 Automate Azure SQL Database Scaling.mp4

21:43

19 Set Up SQL Data Sync.mp4

21:15

20 Understand Partitioning and Database Sharding .mp4

13:00

21 Understand Read Scale-Out.mp4

07:07

4 Migrate SQL Server Databases to Azure

22 Introducing SQL Server Database Migrations to Azure.mp4

02:45

23 Understanding Your Options.mp4

16:50

24 Migrate to an Azure SQL VM - Offline.mp4

27:18

25 Migrate to an Azure SQL VM - Online.mp4

08:41

26 Migrate to an Azure SQL Database - Offline.mp4

22:27

27 Migrate to an Azure SQL Database - Online.mp4

15:41

5 Configure SQL Server and Azure SQL Authentication

28 Introducing SQL Authentication.mp4

01:34

29 Understand SQL Security Architecture.mp4

10:58

30 Create SQL Logins.mp4

15:13

31 Create SQL Database Users (and More!).mp4

13:32

32 Implement Azure SQL Authentication Using Azure AD.mp4

12:39

6 Configure SQL Server Authorization

33 Introducing SQL Server Authorization.mp4

00:58

34 Fixed Server Roles Explored.mp4

10:42

35 Deploying Custom Server Roles.mp4

08:58

36 Fixed Database Roles Explored.mp4

08:07

37 Custom Database Roles Explored.mp4

09:13

38 Configuring Object Access.mp4

10:19

7 Encrypt SQL Data at Rest

39 Introducing Encrypting Data at Rest.mp4

02:07

40 Encrypt an Azure VM OS and Data Disk.mp4

14:19

41 Object-Level Encryption.mp4

12:25

42 Dynamic Data Masking.mp4

10:15

43 Transparent Data Encryption.mp4

09:23

8 Deploy SQL AlwaysEncrypted in Local and Azure Environments

44 Introducing SQL Server Always Encrypted.mp4

02:33

45 How Always Encrypted Works.mp4

16:10

46 Implement Always Encrypted On-Premises.mp4

12:33

47 Register Your App in Azure.mp4

06:24

48 Deploy Your Azure Resources.mp4

10:23

49 Implement Always Encrypted on an Azure DB.mp4

04:53

50 Create a .NET Console App to Use Always Encrypted.mp4

14:35

9 Implement Compliance Controls for Sensitive Data

51 Introducing SQL Server Auditing and Security.mp4

01:29

52 Discover and Classify Data.mp4

09:57

53 Implement Change Tracking.mp4

12:59

54 Perform a Vulnerability Assessment.mp4

06:38

55 Create a Server Audit.mp4

09:10

56 Create a Database Audit.mp4

06:15

57 Analyzing Audit Results.mp4

07:05

10 Implement Azure SQL Database Security Features

58 Introducing Azure SQL Database Security Features.mp4

01:44

59 Azure SQL Auditing.mp4

10:17

60 Data Discovery and Classification.mp4

08:43

61 Dynamic Data Masking.mp4

06:45

62 Deploy with Transparent Data Encryption.mp4

14:14

63 Enable TDE After Deployment.mp4

11:31

64 Summarizing Azure SQL Security Features.mp4

02:38

11 Monitor SQL Server Activity and Performance

65 Introducing SQL Server Monitoring.mp4

02:17

66 Creating a Baseline with Perfmon.mp4

14:00

67 Monitoring Disk Utilization.mp4

09:57

68 Monitoring CPU Load.mp4

03:54

69 Monitoring Memory Load.mp4

05:02

70 SSMS Performance Dashboard and Reports.mp4

08:39

71 Tracing with Extended Events.mp4

13:37

12 Implement Performance-Related Database Maintenance Tasks

72 Introducing More SQL Performance Tuning Tools.mp4

02:09

73 Azure SQL Auto-Tuning.mp4

07:08

74 Storage Capacity Planning.mp4

15:59

75 Manually Updating SQL Statistics.mp4

13:33

76 Automate Statistic Maintenance.mp4

09:09

77 Summarizing SQL Performance Tools.mp4

01:17

13 Identify and Troubleshoot Database Performance Issues

78 Introducing Performance Troubleshooting on SQL Server and Azure .mp4

01:45

79 Enable the Query Store in SQL Server.mp4

08:51

80 Review Query Store Reports.mp4

13:43

81 Identify Blocking Sessions.mp4

10:44

82 Assess Growth and Fragmentation of Files.mp4

13:27

83 Summarizing Performance Troubleshooting.mp4

01:24

14 Implementing Index Maintenance Tasks

84 Introducing Index Maintenance Tasks.mp4

01:37

85 Repairing Fragmented Indexes.mp4

15:35

86 Repairing Fragmented Columnstore Indexes.mp4

10:43

87 Finding Missing Indexes.mp4

09:06

88 Removing Underutilized Indexes.mp4

08:18

89 Summarizing Index Maintenance.mp4

01:26

15 Automate SQL Workflows Using Azure Logic Apps

90 Introducing Azure Logic Apps and SQL.mp4

02:36

91 Exploring Logic Apps.mp4

16:13

92 Deploying the SQL Resources.mp4

08:29

93 Create an API.mp4

04:35

94 Create the SQL Workflow.mp4

09:29

95 Test the API.mp4

08:58

96 Explore Other SQL Actions.mp4

06:01

16 Automate Management and Deployment of Azure SQL Resources

97 Introducing Azure SQL Automation.mp4

02:30

98 Deploy an Azure SQL DB Using PowerShell.mp4

20:08

99 Deploy an Azure SQL DB Using Az CLI.mp4

12:57

100 Deploy an Azure SQL VM Using Powershell.mp4

20:11

101 Deploy an Azure SQL DB from ARM Templates.mp4

07:15

102 Create an Email Alert with Powershell.mp4

08:20

17 Configure SQL Server Failover Groups

103 Introducing SQL Server Failover Clusters.mp4

01:05

104 How Failover Clusters Work.mp4

10:17

105 Create the iSCSI Connection.mp4

15:56

106 Create the Failover Cluster.mp4

09:10

107 Explore Witness Options.mp4

10:01

108 Install SQL Server for the Cluster.mp4

17:25

18 Deploy SQL Server Failover Cluster in Azure

109 Introducing SQL Failover Clusters on Azure VMs.mp4

01:31

110 The Azure Failover Cluster Architecture.mp4

15:34

111 Deploy the Azure Resources.mp4

08:58

112 Configure Secondary IPs on Azure VM NICs.mp4

09:00

113 Create the Windows Failover Cluster.mp4

10:42

114 Create the SQL Failover Cluster.mp4

21:13

19 Implement SQL Server Backups

115 Introducing SQL Server Backups.mp4

01:17

116 Understand the Backup Strategy.mp4

15:31

117 Perform Backups with T-SQL or SSMS.mp4

12:50

118 Backups with Filegroups.mp4

08:47

119 Automate Backups with Alerting.mp4

18:54

20 Restore SQL Server Databases

120 Introducing SQL Database Restoration.mp4

01:11

121 Perform SQL Database Restoration.mp4

11:23

122 Restore SQL Filegroups.mp4

06:23

123 Restore SQL Pages.mp4

07:53

124 Point in Time Recovery.mp4

08:39

125 Automate SQL Database Backup Tests.mp4

12:06

21 Implement SQL Always-On Availability Groups

126 Introducing SQL Server Always-On Availability Groups.mp4

01:43

127 SQL Server Always-On Availability Group Designs.mp4

15:01

128 Create the Windows Server Failover Cluster.mp4

09:51

129 Create the Availability Group.mp4

19:05

130 Configure Read-Only Intent Scaling.mp4

09:03

131 Manage Failover Events.mp4

06:27

22 Deploy SQL Always-On Availability Groups on Azure VMs

132 Introducing AGs on Azure VMs.mp4

01:22

133 SQL Availability Groups in Azure Considerations .mp4

10:06

134 Deploy the Necessary Resources in Azure.mp4

07:48

135 Prep the Azure VMs for SQL AGs.mp4

11:13

136 Configure the Cluster.mp4

08:14

137 Configure the Availability Group.mp4

15:46

23 Understand Azure SQL Database HADR Strategies

138 Introducing Azure SQL DB HADR Solutions.mp4

02:02

139 Active Geo Replication.mp4

09:29

140 Azure SQL Backup Configurations.mp4

09:30

141 Restore Azure SQL Databases.mp4

07:07

142 Restore Deleted Azure SQL Databases.mp4

05:22

143 Configure Log Shipping.mp4

14:08

Description

This intermediate Azure Database Administrator Associate training prepares database administrators to take the DP-300 exam, which is the one exam required to earn the Microsoft Certified: Azure Database Administrator Associate certification.

If you and your organization work with cloud-based applications, you've almost certainly heard of Azure. Microsoft's cloud computing service was custom built to make building, testing, deploying, and managing cloud-based apps and services as easy as possible. For database administrators, knowing how to incorporate your organization's apps and services with data sources all over the cloud can be the difference between keeping your job and failing.

More details

While some of the component parts of maintaining databases and connections in the cloud might be familiar -- components like SQL fundamentals, implementing data platform resources, and T-SQL -- it's knowing how to combine them all that sets a database administrator apart. This Azure Database Administrator Associate training puts it all into your hands.

For anyone with database administrators on their team, this Microsoft training can be used for DP-300 exam prep, onboarding new database administrators, individual or team training plans, or as a Microsoft reference resource.

Azure Database Administrator Associate: What You Need to Know

This Azure Database Administrator Associate training has videos that cover topics such as:

Planning and implementing data platform resources
Recommending appropriate database offerings based on requirements
Configuring database authentication with platform and database tools
Implementing performance-related maintenance tasks
Automating Azure tasks
Implementing high availability and disaster recovery environments

Who Should Take Azure Database Administrator Associate Training?

This Azure Database Administrator Associate training is considered associate-level Microsoft training, which means it was designed for new IT professionals with at least a year of experience with relational databases on Azure and experienced database administrators looking to validate their Microsoft skills.

New or aspiring database administrators. If you're a brand new database administrator, you've hopefully already got a sense of how to deploy databases, configure resources, and monitor query performance. This training brings those individual components together under the Microsoft Azure umbrella and makes sure you're comfortable and familiar with the Microsoft cloud database administration program.

Experienced database administrators. If you've been working as a network administrator for several years, this training should be particularly interesting to you if you and your organization are considering a move to Azure from your current data solution. A substantial portion of this Microsoft Certified: Azure Database Administrator Associate training includes preparing for, transitioning and validating migrations to the Azure platform -- with it, you can ensure your company's transition is free of mistakes and loss.

User Reviews

Rating

average 0

Total votes0

Focused display

Microsoft Azure

Knox Hutchinson

Instructor's Courses

The personal touch, coupled with the ability to go at your own pace, makes video training far and away the best way to learn.

Knox brings a wealth of data analysis and visualization experience to CBT Nuggets. Knox started off as a CBT Nuggets learner, became a mentor in our Learner Community, and is now a trainer. Having benefited from the CBT Nuggets Learning Experience firsthand, Knox creates training that connects with learners. Knox also has a wide range of IT experience. Prior to joining CBT Nuggets, Knox worked as an IT consultant, advising in a variety of areas including networking, cloud computing, and project management.

Certifications: Microsoft MCSE: Cloud Platform and Infrastructure, Microsoft MCP: Administering SQL Server 2012/2014 Databases, Cisco DevNet Professional, Cisco CCNP: Enterprise, Certified Meraki Network Operator (CMNO), JNCIA-JUNOS, JNCIA-DevOps, Tableau Desktop Qualified Associate, and CompTIA Network+

Areas of expertise: Data analysis and visualization, business intelligence solutions

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.