DP-300 : Microsoft Database Administrator Associate Course

Welcome to this comprehensive step-by-step tutorial where we'll walk you through the entire process of setting up a Red Hat Virtual Machine in Azure, configuring SQL Server on the VM, and performing essential database operations.

In this video, you'll learn:

1. Creating a Red Hat Virtual Machine on Azure: From starting with the Azure portal to completing the deployment.

2. Configuring SQL Server in the VM: Installing and setting up SQL Server on your Red Hat VM.

3. Creating a Database and Table: Establishing a new database and designing a table within SQL Server.

4. Inserting and Querying Data: Inputting data into your table and performing queries to verify database functionality.

In this detailed hands-on tutorial, we will walk you through the end-to-end process of setting up Azure Data Discovery and Classification, including enabling Azure Defender for SQL and configuring auditing. This tutorial is perfect for IT professionals, database administrators, and anyone looking to enhance their skills in Azure SQL Database management.

What You'll Learn:

1. How to create an Azure SQL Database.

2. Configuring compute, storage, and networking settings for your database.

3. Creating a table in the Azure SQL Database and inserting values.

4. Verifying the inserted data in the database.

5. Enabling Microsoft Defender for SQL to enhance security.

6. Performing data discovery and classification, including adding classifications like Confidential GDPR, Highly Confidential, and Confidential.

7. Setting up Azure SQL Auditing with the log destination configured to a storage account.

8. Simulating incorrect login attempts and tracking them in audit records.

Welcome to this comprehensive, hands-on tutorial on implementing Azure SQL Database autoscaling using Azure Logic App! In this video, we'll walk you through every step from start to finish to ensure your Azure SQL Database stays in a healthy state during high-demand periods like Black Friday or New Year sales, and scales down to lower configurations when normal days resume. ?

What you'll learn:

1. Azure SQL Database Creation: Learn how to create an Azure SQL Database from scratch, including detailed configuration and networking settings.

2. Azure Logic App Setup: Create an Azure Logic App from scratch with multi-tenant consumption, and understand all configuration details.

3. Logic App Designer: Use the Logic App Designer to set up a recurrence trigger, defining the exact times for scaling operations.

4. Executing SQL Queries: Configure Azure Logic App to execute SQL queries for scaling up the database, including connection details.

5. Delay Configuration: Set up a delay to ensure smooth scaling down operations post-sale periods.

6. End-to-End Implementation: We'll demonstrate the entire process of scaling up and scaling down the Azure SQL Database, verifying and ensuring the operations work seamlessly.

In this comprehensive hands-on tutorial, we'll take you through the step-by-step process of setting up Azure Data Sync using both source and target Azure SQL servers. Learn how to configure your source Azure SQL database and set up firewall rules to enable connections from an on-premises SQL Server (SSMS).

What you'll learn:

1. Configuration of Source and Target Azure SQL Servers: Understand the setup and connection using SSMS from on-premises to Azure.

2. Creating a Sync Group: Discover how to create a new sync group for the source Azure SQL database and explore the concept of conflict resolution with the "Hub wins" strategy.

3. Bi-Directional Sync: Witness a live demonstration of cloud-to-on-premises sync with bi-directional synchronization for 60 seconds.

4. Hub Wins Concept: Learn about the hub wins strategy by inserting dummy rows in both source and target database tables simultaneously to showcase how conflicts are resolved.

Key Concepts:

1. Configuring Azure SQL Server Firewall Rules

2. Connecting to Azure SQL Server from On-Premises SSMS

3. Creating and Managing Sync Groups

4. Conflict Resolution - Hub Wins Strategy

5. Bi-Directional Synchronization Demonstration

By the end of this video, you'll have a clear understanding of how to effectively use Azure Data Sync to keep your data synchronized across multiple SQL databases with minimal effort.

In this comprehensive hands-on tutorial, we will guide you through the entire process of configuring Azure Alerts for high CPU thresholds on an Azure SQL Database, using an architecture diagram to illustrate each step.

Key Highlights:

1. Create and Configure Azure SQL Database from Scratch: Learn how to set up your Azure SQL Database server and database from the ground up.

2. Configure Azure Alert Rule: Set up an Azure Alert Rule using the 'CPU percentage' signal. We'll choose a static threshold type, setting the threshold value to 90. The evaluation will occur every 1 minute with a lookback period of 5 minutes.

3. Action Group and Notifications: Create an alert rule action group and configure email notifications to ensure you're alerted when the criteria are met.

4. Critical Alert Rule Details: Learn how to configure a Severity 0 (Critical) alert rule.

5. Test with High CPU Queries: Fire complex queries that consume high CPU using the Azure SQL Database Query Editor and monitor the CPU performance using Azure Monitor.

6. Email Notifications: See how email notifications are received when the alert criteria are met.

7. Repeat Configuration for Severity 2 Alert: Understand how to configure and test a Severity 2 (Warning) alert with a CPU threshold of 70%.

By the end of this tutorial, you'll be well-equipped to set up and monitor Azure Alerts for high CPU thresholds on your Azure SQL Database, ensuring efficient resource management and timely notifications.

Learn step-by-step how to configure and manage geo-replication for Azure SQL Database in this hands-on tutorial.

This video demonstrates how to:

1. Set up a secondary database in a different region to ensure high availability and disaster recovery.

2. Perform manual failover operations to the secondary database when needed.

Gain valuable insights into optimizing your Azure SQL Database for maximum reliability and business continuity.

Dive into this hands-on tutorial and take your Azure skills to the next level! In this course, you'll gain practical experience with the Azure portal as you learn to:

1. Create and configure a Windows Virtual Machine (VM).

2. Install SQL Server with clear, step-by-step guidance.

3. Set up and manage databases in the cloud effortlessly.

By the end of this tutorial, you'll have the confidence to provision virtual machines, configure their settings, and unleash the full potential of SQL Server in the Azure cloud.

This comprehensive project is designed to guide you through the entire process of creating and managing an Azure Web Application Firewall. Here's what you'll learn:

• Creating a New Web Application Firewall: Step-by-step instructions on how to create a new Web Application Firewall using the Azure portal.

• Policy Modes: Prevention and Detection: Detailed explanation of the different policy modes and how to configure them.

• Managing Rules: Learn how to manage rules for common threats like XSS and SQL injection.

• Setting Blocked Response Body Messages: Discover how to customize blocked response body messages to enhance security.

• Configuring Custom Rules: Understand how to configure custom rules to meet specific security requirements.

• Toggling Between Modes: Demonstration of how to toggle between detection mode and prevention mode after deploying the Web Application Firewall.

By the end of this course, you'll have the skills and confidence to create, manage, and secure your web applications using Azure Web Application Firewall.

In this comprehensive hands-on tutorial, we guide you through the process of implementing dynamic data masking in Azure SQL Database to protect personally identifiable information (PII). Learn how to ensure that only authorized users can view PII data, while others see masked data even when running the same queries.

What You'll Learn:

• Creating Azure SQL Database and SQL Server: Step-by-step instructions to set up your database and server.

• Configuring Firewall Rules: Learn how to configure firewall rules to secure your database.

• Creating Users in the Database: Detailed guidance on creating different users and managing permissions.

• Granting Permissions: Understand how to grant appropriate permissions to users.

• Creating Tables with Masked Columns: Learn to create tables with masked columns to protect PII data.

• Inserting Values into the Table: Step-by-step process to insert data into the masked columns.

• Demonstrating Dynamic Data Masking: Watch as we demonstrate querying the same data as different users to show how dynamic data masking works.

Join us to gain practical experience and master the implementation of dynamic data masking in Azure SQL Database, ensuring data security and compliance with privacy regulations.

Welcome to "Mastering Shared Access Signatures in Azure: End-to-End Hands-On Tutorial"! This comprehensive course is designed to guide you through the entire process of creating and managing Shared Access Signatures (SAS) in Azure. Here's what you'll learn:

• Creating a Blob Storage Account: Step-by-step instructions on how to create a Blob storage account using Azure Cloud Shell CLI commands.

• Creating a Container: Learn how to create a container within your storage account using CLI.

• Uploading Blobs: Discover how to upload blobs to the storage account and verify the uploaded data for correctness using Azure Storage Explorer.

• Creating Shared Access Signatures (SAS): Detailed guide on creating SAS at both the blob level and the storage account level.

• Verifying Data with Azure Storage Explorer: Learn how to use Azure Storage Explorer to verify the data shared using SAS.

By the end of this course, you'll have the skills and confidence to create, manage, and secure your data using Shared Access Signatures in Azure.

Ready to master Azure SQL Database firewall configuration? In this hands-on tutorial, we walk you through every step—from signing into the Azure portal to deploying a SQL server, importing a .bacpac file, and configuring firewall rules for secure access.

What You'll Learn:

· How to sign in to the Azure portal (with cache-clearing tips)

· Creating a SQL Server with SQL Authentication

· Configuring firewall rules to allow client IP access

· Importing the sample.bacpac file into Azure SQL

· Executing T-SQL to set firewall rules and create contained users

· Troubleshooting login errors and switching database context

Learn how to configure a failover group for Azure SQL Databases hosted on SQL Server—step-by-step! This hands-on tutorial walks you through creating primary and secondary SQL databases, setting up servers across regions, and deploying a failover group to ensure high availability and disaster recovery.

What You'll Learn:

· How to create Azure SQL Databases and SQL Servers

· Configure compute tiers and storage redundancy

· Set up a failover group across East US and West US 2 regions

· Test failover functionality and validate role switching to validate disaster recovery readiness

Unlock the full potential of Azure SQL with this step-by-step hands-on tutorial designed for IT professionals, cloud engineers, and database administrators. In this practical course, you'll learn how to create, configure, and export a BACPAC file from an Azure SQL Database and securely store it in an Azure Storage Account container.

By the end of this tutorial, you'll be able to:

· Set up an Azure SQL Server and deploy the AdventureWorksLT sample database

· Create and configure an Azure Storage Account and Blob Container for backups

· Modify networking settings to allow secure SQL authentication from your local machine

· Use SQL Server Management Studio (SSMS) to connect to Azure SQL and export a data-tier application (BACPAC file)

· Upload the BACPAC file to your Azure Storage container for long-term retention or migration

In this hands-on session, you'll learn how to restore an Azure SQL Database using a BACPAC file from your local machine—without writing a single line of code.

What You'll Learn:

• How to create a new Azure Storage Account and Blob Container

• Upload BACPAC files from your local computer to Azure Storage

• Use the Azure Portal’s “Import Database” feature to restore data into Azure SQL Server

• Validate the restored database to ensure data integrity and completeness

Key Concepts Covered:

• Azure SQL Database architecture

• BACPAC file format and its role in database migration

• Storage account configuration and access

• Database import workflow via Azure Portal • Post-restore data validation techniques

Unlock the power of Azure SQL Database recovery with this end-to-end hands-on tutorial designed for IT professionals, cloud engineers, and database administrators. In this practical walkthrough, you'll learn how to perform a Point-in-Time Restore (PITR) to recover from accidental data loss, corruption, or deletion—and validate the integrity of your restored data with confidence.

What You'll Learn:

· How Azure SQL automated backups work behind the scenes

· Step-by-step process to initiate a Point-in-Time Restore using Azure Portal and CLI

· Real-world disaster scenario simulation: dropping a table or deleting critical data

· Restoring the database to a precise timestamp before the incident

· Verifying restored data using Azure Data Studio and SQL queries

· Best practices for disaster recovery planning and testing