Azure Database Administrator Associate
Focused View
Chris Behrens
11:05:21
45 View
001 Course Introduction.mp4
02:08
002 About the Training Architect - Steven Moran.mp4
01:43
003 About the Training Architect - Landon Fowler.mp4
00:51
004 DP-300 Exam Overview.mp4
13:19
004 Download DP-300 Skills Measured Guide.txt
004 Exam DP-300 Administering Relational Databases on Microsoft Azure.txt
004 Exam DP-900 Microsoft Azure Data Fundamentals.txt
005 Course Overview.mp4
08:26
005 Download DP-300 Skills Measured Guide.txt
001 Introduction to Deploying Azure SQL Systems.mp4
01:32
002 Azure SQL documentation.txt
002 Exploring SQL Database Deployment Options in Azure.mp4
05:15
002 What is Azure SQL.txt
003 Azure SQL Database and Azure SQL Managed Instance service tiers.txt
003 Choose between the vCore and DTU purchasing models - Azure SQL Database and SQL Managed Instance.txt
003 Exploring Azure SQL Resource Configuration Basics.mp4
14:09
004 Choose between the vCore and DTU purchasing models - Azure SQL Database and SQL Managed Instance.txt
004 Examining the DTU Purchasing Model.mp4
09:26
004 Service tiers in the DTU-based purchase model.txt
005 Examining the vCore Purchasing Model.mp4
09:28
005 vCore model overview - Azure SQL Database and Azure SQL Managed Instance.txt
006 Examining the StandardGeneral Purpose Service Tiers.mp4
08:23
006 General Purpose service tier - Azure SQL Database and Azure SQL Managed Instance.txt
007 Business Critical tier - Azure SQL Database and Azure SQL Managed Instance.txt
007 Examining the PremiumBusiness Critical Service Tiers.mp4
05:59
008 Azure SQL Database Hyperscale FAQ.txt
008 Examining the Hyperscale Service Tier.mp4
08:00
008 Hyperscale service tier.txt
009 Azure Hybrid Benefit - Azure SQL Database SQL Managed Instance.txt
009 Features comparison Azure SQL Database and Azure SQL Managed Instance.txt
009 Save costs for resources with reserved capacity - Azure SQL Database SQL Managed Instance.txt
009 Selecting the Best Resource Configuration Options.mp4
17:52
010 Provisioning Azure SQL Database Servers.mp4
13:36
010 What is a logical SQL server in Azure SQL Database.txt
011 Getting started with single databases in Azure SQL Database.txt
011 Provisioning Azure SQL Single Databases.mp4
14:36
011 What is a single database in Azure SQL Database.txt
012 Demo Creating Azure SQL Database Servers and Single Databases using the Azure Portal.mp4
14:17
013 Creating a new SQL Database elastic pool using the Azure portal.txt
013 Elastic pools help you manage and scale multiple databases in Azure SQL Database.txt
013 Provisioning Azure SQL Elastic Pools.mp4
16:04
014 Demo Creating Elastic Pools using the Azure Portal.mp4
09:01
016 Implementing SQL Server on Azure VMs.mp4
16:10
016 Overview of SQL Server on Azure Virtual Machines (Linux).txt
016 What is SQL Server on Azure Virtual Machines (Windows).txt
017 Demo Provisioning SQL Server on Azure VM.mp4
10:38
017 Quickstart Create SQL Server 2017 on a Windows virtual machine in the Azure portal.txt
018 Provisioning Azure SQL Managed Instances - Part 1.mp4
09:43
018 What is Azure SQL Managed Instance.txt
019 Provisioning Azure SQL Managed Instances - Part 2.mp4
09:21
019 What is Azure SQL Managed Instance.txt
020 Demo Provisioning Azure SQL Managed Instance using the Azure Portal.mp4
09:36
020 Quickstart Create an Azure SQL Managed Instance.txt
021 Selecting the Best Azure SQL Deployment Option.mp4
07:41
023 Automating SQL Deployment with PowerShell and Azure CLI.mp4
13:15
023 Azure PowerShell samples for Azure SQL Database and Azure SQL Managed Instance.txt
023 Manage servers databases and firewalls using PowerShell.txt
023 Quickstart Create SQL Server on a Windows virtual machine with Azure PowerShell.txt
023 Use PowerShell to create a managed instance.txt
001 Introduction to Securing Azure Resources.mp4
01:32
002 Authorizing Management Access to Azure SQL Objects.mp4
05:49
003 Azure SQL Database connectivity architecture.txt
003 Azure SQL connectivity settings.txt
003 Controlling Network Access to Azure SQL Databases.mp4
15:37
004 Controlling Network Access to SQL Virtual Machines.mp4
04:04
004 Security considerations for SQL Server on Azure Virtual Machines Secure connections.txt
005 Connectivity architecture for Azure SQL Managed Instance.txt
005 Controlling Network Access to Azure SQL Managed Instances.mp4
07:54
006 Authorize database access to SQL Database and SQL Managed Instance.txt
006 Managing Azure SQL Authentication.mp4
14:13
006 Use Azure Active Directory authentication.txt
007 Authorizing SQL Data Access - Part 1.mp4
09:08
007 Getting Started with Database Engine Permissions.txt
007 Permissions (Database Engine).txt
007 Securables.txt
008 Authorizing SQL Data Access - Part 2.mp4
11:49
008 Tutorial Ownership Chains and Context Switching.txt
010 Protecting SQL Data.mp4
15:17
011 Integrating with Azure Key Vault.mp4
16:34
012 Demo Integrating Azure SQL with Azure Key Vault - Pt 1.mp4
06:03
013 Demo Integrating Azure SQL with Azure Key Vault - Pt 2.mp4
09:07
014 Demo Enable Column Encryption in SSMS.mp4
07:05
015 Examining Azure Defender for SQL.mp4
10:48
016 Monitoring Azure SQL Activity.mp4
15:42
017 SQL Data Discovery and Classification.mp4
06:22
001 Introduction to Implementing HADR for Azure SQL.mp4
00:56
002 SQL Virtual Machine Backup Recovery Options.mp4
08:20
003 Azure SQL PaaS Backup Recovery Options.mp4
05:14
004 SQL Server Continuity Solutions - Part 1.mp4
07:33
005 SQL Server Continuity Solutions - Part 2.mp4
10:13
006 Azure Virtual Machine Continuity Solutions.mp4
13:31
007 Azure SQL PaaS Continuity Solutions.mp4
10:55
001 Introduction to Migrating to Azure SQL.mp4
01:51
002 Exploring the Azure SQL Migration Process.mp4
11:01
003 Exploring SQL Migration Tools Services.mp4
06:01
004 Exploring Azure SQL Migration Methods.mp4
09:38
005 Azure SQL Family Migration Considerations.mp4
08:01
006 Working with the Azure Database Migration Service - Part 1.mp4
08:54
007 Working with the Azure Database Migration Service - Part 2.mp4
11:28
001 Introduction to Azure SQL Performance.mp4
10:04
002 Working with Performance Baselines.mp4
09:39
003 Identifying Performance Problems (Part 1).mp4
07:55
004 Azure SQL Database Wait Types.txt
004 Identifying Performance Problems (Part 2).mp4
13:02
005 Working with Extended Events.mp4
11:42
007 Improving System Performance (Part 1).mp4
11:55
008 Improving System Performance (Part 2).mp4
05:50
009 Examining Azure SQL Scalability Options.mp4
07:43
010 Improving Query Performance.mp4
08:23
012 Maintaining Performance.mp4
08:45
014 Automating Maintenance.mp4
09:02
015 Working with SQL Server Agent.mp4
08:01
017 Working with Azure Automation.mp4
08:18
018 Elastic Jobs SQL.txt
018 Working with Elastic Jobs.mp4
12:14
001 Final Words.mp4
09:56
002 Course Wrap-Up.mp4
01:43
Description
Use this course to prepare for the DP-300: Administering Relational Databases on Microsoft Azure exam.
What You'll Learn?
This course prepares students who are already familiar with core Azure services and Azure and SQL database skills used by Azure Database Administrators. An Azure Database Administrator is responsible for the management, availability, security, performance monitoring, and optimization of modern relational database solutions. They also assist Azure Data Engineers in managing operational aspects of a data platform solution. Azure Database Administrators are familiar with: - Deploying SQL database solutions within Azure - Azure SQL Server, database, and query architecture - Basic usage of Transact-SQL for administrative tasks - Securing Azure SQL resources and data - Interconnecting Azure SQL resources with other Azure services - Monitoring and optimizing Azure SQL Database performance - Maintaining business continuity for Azure SQL resources - Processes for migrating on-premises SQL Server databases to Azure - Other options for managing relational data in Azure This course also prepares exam candidates to pass the DP-300: Administering Relational Databases on Microsoft Azure exam to attain the Azure Database Administrator Associate certification. Candidates for the exam are presumed to be database administrators and data management specialists that manage on-premises and cloud relational databases built on top of Microsoft SQL Server and Microsoft Azure data services.
More details
User Reviews
Rating
average 0
Focused display
Category
Chris Behrens
Instructor's Courses
Acloud Guru
View courses Acloud GuruA Cloud Guru is an online training platform for people interested in Information Technology. Most of the courses offered prepare students to take certification exams for the three major cloud providers.
- language english
- Training sessions 72
- duration 11:05:21
- Release Date 2023/12/10
