<h1>Lab Details</h1>

<ol>
	<li>
	This lab walks we will walk through the steps to deploy SQL server and create SQL database containing sample data.
	</li>
	<li>
	Duration:&nbsp;60 minutes
	</li>
</ol>

<h1>Introduction</h1>

<h2>What is Azure SQL Database?</h2>

<ul>
	<li>
	Azure SQL Database is a fully managed platform as a service (PaaS) database engine that handles most of the database management functions such as upgrading, patching, backups, and monitoring without user involvement.
	</li>
	<li>
	Azure SQL Database is always running on the latest stable version of the SQL Server database engine and patched OS with 99.99% availability.
	</li>
	<li>
	PaaS capabilities that are built into Azure SQL Database enable you to focus on the domain-specific database administration and optimization activities that are critical for your business.
	</li>
	<li>
	With Azure SQL Database, you can create a highly available and high-performance data storage layer for the applications and solutions in Azure.
	</li>
	<li>
	SQL Database can be the right choice for a variety of modern cloud applications because it enables you to process both relational data and non-relational structures, such as graphs, JSON, spatial, and XML.
	</li>
</ul>

<h1>Task Details</h1>

<ol>
	<li>
	Launching Lab Environment
	</li>
	<li>
	Create a Azure SQL Database
	</li>
	<li>
	Create a server-level IP firewall rule
	</li>
	<li>
	Connect to the database
	</li>
	<li>
	Create tables in the database
	</li>
</ol>

<h1>Lab Details</h1>

<ol>
	<li>
	In this lab we will go through various database services like CosmosDB, MySQL and PostgreSQL provided by Azure and also dive deeper into each of these services.
	</li>
	<li>
	Duration:&nbsp;60 minutes
	</li>
</ol>

<h1>Introduction</h1>

<h2>What is Azure Database Service?</h2>

<ul>
	<li>
	Azure Database Services ensures that customer databases are protected and monitored by establishing backup and recovery procedures, providing a secure database environment, and monitoring database performance.
	</li>
	<li>
	Today&#39;s applications are required to be highly responsive and always online. Applications need to respond in real time to large changes, store ever increasing volumes of data, and make this data available to users in milliseconds.
	</li>
	<li>
	Azure Cosmos DB is a fully managed NoSQL database for modern app development. As a fully managed service, it takes database administration off your hands with automatic management, updates and patching.
	</li>
	<li>
	Azure Database for MySQL is a relational database service powered by the MySQL community edition. It&#39;s a fully managed database as a service offering that can handle mission-critical workloads with predictable performance and dynamic scalability.
	</li>
	<li>
	Azure Database for PostgreSQL is a relational database service based on the open-source Postgres database engine.&nbsp;
	</li>
</ul>

<h1>Task Details</h1>

<ol>
	<li>
	Launching Lab Environment
	</li>
	<li>
	Create a CosmosDB account with SQL
	</li>
	<li>
	Create Azure Database for MySQL
	</li>
	<li>
	Create Azure Database for PostgreSQL
	</li>
</ol>

<h1 dir="ltr" style="line-height: 1.2; color: rgb(51, 51, 51); font-family: sans-serif, Arial, Verdana, &quot;Trebuchet MS&quot;;">Lab Details</h1><ol style="padding: 0px 40px; color: rgb(51, 51, 51); font-family: sans-serif, Arial, Verdana, &quot;Trebuchet MS&quot;; font-size: 13px;"><li dir="ltr">In this lab we will walk through the steps to create an azure database for PostgreSQL flexible server.</li><li dir="ltr">Duration:&nbsp;45 minutes.</li></ol><h1 dir="ltr" style="line-height: 1.2; color: rgb(51, 51, 51); font-family: sans-serif, Arial, Verdana, &quot;Trebuchet MS&quot;;">Introduction</h1><h2 dir="ltr" style="line-height: 1.2; color: rgb(51, 51, 51); font-family: sans-serif, Arial, Verdana, &quot;Trebuchet MS&quot;;">What is PostgreSQL?</h2><ul style="padding: 0px 40px; color: rgb(51, 51, 51); font-family: sans-serif, Arial, Verdana, &quot;Trebuchet MS&quot;; font-size: 13px;"><li dir="ltr">Azure Database for PostgreSQL provides highly accessible PostgreSQL databases that can be run, maintained, and scaled in the cloud. This lab demonstrates how to use the Azure interface to quickly setup an Azure Database for PostgreSQL - Flexible Server.</li><li dir="ltr">Azure Database for PostgreSQL - Flexible Server&nbsp;is a fully managed database service which aims to give users more control and flexibility over database management features and configuration options.&nbsp;</li><li dir="ltr">The service generally offers greater flexibility and server configuration changes based on user needs. Users can choose high availability both within a single availability zone and across many availability zones, collocate the database engine with the client-tier for reduced latency, and more thanks to the adaptable server architecture.</li></ul><h1 dir="ltr" style="line-height: 1.2; color: rgb(51, 51, 51); font-family: sans-serif, Arial, Verdana, &quot;Trebuchet MS&quot;;">Architecture Diagram</h1><img data-cke-saved-src="https://labresources.whizlabs.com/006a2efcd98e1076405b3c4beb17bdbb/Create an Azure Database for PostgreSQL Flexible Server_44_20.png" src="https://labresources.whizlabs.com/006a2efcd98e1076405b3c4beb17bdbb/Create%20an%20Azure%20Database%20for%20PostgreSQL%20Flexible%20Server_44_20.png" style="cursor: default; height: 487px; margin-left: 0px; margin-top: 0px; width: 800px;"><h1 dir="ltr" style="line-height: 1.2; color: rgb(51, 51, 51); font-family: sans-serif, Arial, Verdana, &quot;Trebuchet MS&quot;;">Task Details</h1><ol style="padding: 0px 40px; color: rgb(51, 51, 51); font-family: sans-serif, Arial, Verdana, &quot;Trebuchet MS&quot;; font-size: 13px;"><li dir="ltr">Launching Lab Environment.</li><li dir="ltr">Creating an Azure Database for PostgreSQL server.</li><li dir="ltr">Getting the connection information.</li><li dir="ltr">Connect to the PostsgreSQL database using psql.</li></ol>

<h1 dir="ltr" style="line-height: 1.2; color: rgb(51, 51, 51); font-family: sans-serif, Arial, Verdana, &quot;Trebuchet MS&quot;;">Lab Details</h1><ol style="padding: 0px 40px; color: rgb(51, 51, 51); font-family: sans-serif, Arial, Verdana, &quot;Trebuchet MS&quot;; font-size: 13px;"><li dir="ltr">In this lab we will walk through the steps to&nbsp;create a SQL server on a windows virtual machine.</li><li dir="ltr">Duration:&nbsp;60 minutes.</li></ol><h1 dir="ltr" style="line-height: 1.2; color: rgb(51, 51, 51); font-family: sans-serif, Arial, Verdana, &quot;Trebuchet MS&quot;;">Introduction</h1><h2 dir="ltr" style="line-height: 1.2; color: rgb(51, 51, 51); font-family: sans-serif, Arial, Verdana, &quot;Trebuchet MS&quot;;">What is a SQL Server?</h2><ul style="padding: 0px 40px; color: rgb(51, 51, 51); font-family: sans-serif, Arial, Verdana, &quot;Trebuchet MS&quot;; font-size: 13px;"><li dir="ltr">SQL Server on Azure Virtual Machines enables you to utilize full versions of SQL Server in the cloud without having to handle any on-premises hardware. When you pay as you go, licensing expenses for SQL Server virtual machines (VMs) are also made simpler.</li><li dir="ltr">There are numerous geographical locations where Azure virtual machines can be configured. Additionally, they provide a range of machine sizes. You can create a SQL Server VM with the appropriate version, edition, and operating system using the virtual machine image gallery. Because of this, virtual machines are a viable choice for a variety of SQL Server workloads.</li></ul><h1 dir="ltr" style="line-height: 1.2; color: rgb(51, 51, 51); font-family: sans-serif, Arial, Verdana, &quot;Trebuchet MS&quot;;">Architecture Diagram</h1><img data-cke-saved-src="https://labresources.whizlabs.com/5e309adc84f2681a5c74e946fa5cc0b2/Create a SQL Server on a Windows VM using Azure portal_27_43.png" src="https://labresources.whizlabs.com/5e309adc84f2681a5c74e946fa5cc0b2/Create%20a%20SQL%20Server%20on%20a%20Windows%20VM%20using%20Azure%20portal_27_43.png" style="cursor: default; height: 435px; margin-left: 0px; margin-top: 0px; width: 800px;"><h1 dir="ltr" style="line-height: 1.2; color: rgb(51, 51, 51); font-family: sans-serif, Arial, Verdana, &quot;Trebuchet MS&quot;;">Task Details</h1><ol style="padding: 0px 40px; color: rgb(51, 51, 51); font-family: sans-serif, Arial, Verdana, &quot;Trebuchet MS&quot;; font-size: 13px;"><li dir="ltr">Launching Lab Environment</li><li dir="ltr">Creating a SQL server VM image.</li><li dir="ltr">Connecting to SQL server through SQL Server Management</li><li dir="ltr">Logging in to the VM remotely</li></ol><h2 dir="ltr" style="line-height: 1.2; color: rgb(51, 51, 51); font-family: sans-serif, Arial, Verdana, &quot;Trebuchet MS&quot;;">Prerequisites</h2><ul style="padding: 0px 40px; color: rgb(51, 51, 51); font-family: sans-serif, Arial, Verdana, &quot;Trebuchet MS&quot;; font-size: 13px;"><li dir="ltr">Download and install SQL Server Management Studio (SSMS) in your system to use in this lab through the link given below:</li></ul><a data-cke-saved-href="https://aka.ms/ssmsfullsetup" href="https://aka.ms/ssmsfullsetup" target="_blank" style="color: rgb(7, 130, 193);">https://aka.ms/ssmsfullsetup</a>

<h1>Lab Details</h1>

<ol>
	<li>
	In this lab, you will learn how to implement SQL Database security features.
	</li>
	<li>
	Duration:&nbsp;45 minutes
	</li>
</ol>

<h1>Introduction</h1>

<h2>What is Azure SQL Database?</h2>

<ul>
	<li>
	Azure SQL Database is a relational database-as-a-service (DBaaS) hosted in Azure that falls into the industry category of Platform-as-a-Service (PaaS).
	</li>
	<li>
	Azure SQL Database is a general-purpose relational database service in Azure that supports structures such as relational data, JSON, spatial, and XML.&nbsp;
	</li>
	<li>
	It handles most of the database management functions such as upgrading, patching, backups, and monitoring without user involvement.&nbsp;
	</li>
	<li>
	Azure SQL Database is always running on the latest stable version of the SQL Server database engine and patched OS with 99.99% availability.&nbsp;
	</li>
	<li>
	PaaS capabilities built into Azure SQL Database enable you to focus on the domain-specific database administration and optimization activities that are critical for your business.
	</li>
	<li>
	SQL Database supports both server-side encryption via the Transparent Data Encryption (TDE) feature and client-side encryption via the Always Encrypted feature.
	</li>
</ul>

<h1>Architecture Diagram 
<img src="https://play.whizlabs.com/frontend/web/media/task_id_11021/securing_azure_sql_database.png" /></h1>

<h1>Task Details</h1>

<ol>
	<li>
	Launching Lab Environment
	</li>
	<li>
	Deploy an Azure SQL Database
	</li>
	<li>
	Configure Advanced Data Protection
	</li>
	<li>
	Configure Data Classification
	</li>
	<li>
	Configure Auditing
	</li>
</ol>

<h1>Lab Details</h1>

<ol>
	<li>
	In this lab, you will be creating and working with key vault and also understand about access policies and how to use it.
	</li>
	<li>
	Duration:&nbsp;45 minutes
	</li>
</ol>

<h1>Introduction</h1>

<h2>What is Azure Key Vault?</h2>

<ul>
	<li>
	Azure Key Vault allows the users to instantly store and access the sensitive information in a secured manner.
	</li>
	<li>
	This cloud service acts as a single central storage for all the secured information which the users can retrieve using specific permissions.
	</li>
	<li>
	The secured information can be in the form of passwords, certificates, API or cryptographic keys.
	</li>
	<li>
	The Azure Key Vault has an uptime of at least 99.99%.
	</li>
	<li>
	With Azure Key Vault, any tasks related to SSL/TLS certificates can be simplified and automated.
	</li>
	<li>
	Certificates can be automatically renewed from supported public Certificate Authorities through Key vault.
	</li>
</ul>

<h1>Task Details</h1>

<ol>
	<li>
	Launching Lab Environment
	</li>
	<li>
	Create a new Key Vault
	</li>
	<li>
	Create a Key
	</li>
	<li>
	Create a secret
	</li>
	<li>
	Access properties of key via Powershell
	</li>
</ol>

<h1 dir="ltr" style="color: rgb(85, 85, 85);">Lab Details</h1><ol><li dir="ltr">In this lab we will walk through the steps to Connect to an Azure SQL server using an Azure Private Endpoint.</li><li dir="ltr">Duration:&nbsp;60 minutes.</li></ol><h1 dir="ltr" style="color: rgb(85, 85, 85);">Introduction</h1><h2 dir="ltr" style="color: rgb(85, 85, 85);">What is Azure Private Endpoint?</h2><ul><li dir="ltr">Network Interface: Azure Private Endpoint is a network interface that allows secure and private access to Azure services.</li><li dir="ltr">Access over private IP: It enables access to Azure services over a private IP address from within a virtual network, eliminating exposure to the public Internet.</li><li dir="ltr">Enhanced Security: The communication between the virtual network and the service is encrypted and remains within the Microsoft network boundary, providing enhanced security compared to public Internet connections.</li><li dir="ltr">Improved Privacy: Azure Private Endpoint provides improved privacy compared to public Internet connections, as all communication remains within the Microsoft network.</li></ul><h2 dir="ltr" style="color: rgb(85, 85, 85);">What is Azure SQL Server?</h2><ul><li dir="ltr">Database Service: Azure SQL Server is a cloud-based relational database service provided by Microsoft Azure.</li><li dir="ltr">Scalability: It provides scalable, highly available, and managed relational database services, allowing you to easily manage and scale your database needs.</li><li dir="ltr">Integration: Azure SQL Server integrates with other Azure services, providing a seamless experience for building, deploying, and managing your applications.</li><li dir="ltr">Security: Azure SQL Server implements security features, such as encryption, authentication, and access control, to help you secure your data and meet compliance requirements.</li></ul><h1 dir="ltr" style="color: rgb(85, 85, 85);">Architecture Diagram</h1><h1 dir="ltr" style="color: rgb(85, 85, 85);"><img src="https://labresources.whizlabs.com/241b34d17c1095f057b921512377987c/image30_06_16_45_06.jpg" width="25%" style="width: 630.2px; height: 366.903px;"> </h1><h1 dir="ltr" style="color: rgb(85, 85, 85);">Task Details</h1><ol><li dir="ltr">Launching Lab Environment</li><li dir="ltr">Create a virtual network&nbsp;</li><li dir="ltr">Create a Virtual machine</li><li dir="ltr">Create an Azure SQL server and private endpoint</li><li dir="ltr">Disable public access to Azure SQL logical server</li><li dir="ltr">Test connectivity to private endpoint</li></ol>

<h1 dir="ltr" style="color: rgb(85, 85, 85);">Lab Details</h1><ol><li dir="ltr">In this lab we will walk through the steps of deploying an Azure SQL database and server using an Azure Resource Manager template.</li><li dir="ltr">Duration:&nbsp;30 minutes.</li></ol><h1 dir="ltr" style="color: rgb(85, 85, 85);">Introduction</h1><h2 dir="ltr" style="color: rgb(85, 85, 85);">What is an Azure SQL database?</h2><ul><li dir="ltr">Azure SQL database is a managed cloud database service from Microsoft.</li><li dir="ltr">It is a fully managed database-as-a-service (DBaaS) that provides a managed, cloud-based environment for developing, deploying, and managing data-driven applications.</li><li dir="ltr">It is based on the latest stable version of the Microsoft SQL Server database engine.</li><li dir="ltr">It is highly scalable, with the ability to automatically scale up or down based on workload demand.</li><li dir="ltr">It includes built-in high availability and failover capabilities.</li><li dir="ltr">It is optimized for performance, with the ability to fine-tune performance and optimize query performance.</li><li dir="ltr">It integrates seamlessly with other Azure services, including Azure Machine Learning, Azure Stream Analytics, and Azure Functions.</li></ul><h2 dir="ltr" style="color: rgb(85, 85, 85);">What is an ARM template?</h2><ul><li dir="ltr">An ARM template is a JSON file that defines one or more resources to be deployed to Azure.</li><li dir="ltr">ARM templates use a declarative syntax, meaning you define the desired end state of your resources rather than the specific steps required to create them.</li><li dir="ltr">ARM templates can be used to deploy a wide variety of Azure resources, including virtual machines, storage accounts, virtual networks, and more.</li><li dir="ltr">They can also be used to deploy resources from the Azure Marketplace, such as SaaS applications and IaaS offerings.</li><li dir="ltr">ARM templates are an important part of the Azure DevOps process, as they can be used to automate the deployment of resources as part of a CI/CD pipeline.</li><li dir="ltr">They can be used in conjunction with Azure Automation to automate the deployment and management of resources on a scheduled basis.</li></ul><h1 dir="ltr" style="color: rgb(85, 85, 85);">Architecture Diagram</h1><img src="https://play.whizlabs.com/frontend/web/media/task_id_11044/deploying_azure_sql_database_using_arm_template.png" style="height: 490px; margin-left: 0px; margin-top: 0px; width: 800px;"><h1 dir="ltr" style="color: rgb(85, 85, 85);">Task Details</h1><ol><li dir="ltr">Launching Lab Environment</li><li dir="ltr">Explore the ARM template</li><li dir="ltr">Deploy the ARM template</li><li dir="ltr">Verify your deployments</li></ol>

<h1 dir="ltr" style="color: rgb(85, 85, 85);">Lab Details</h1><ol><li dir="ltr">In this lab we will walk through the steps to create an Azure Database for MySQL server using an ARM template.</li><li dir="ltr">Duration:&nbsp;30&nbsp;minutes.</li></ol><h1 dir="ltr" style="color: rgb(85, 85, 85);">Introduction</h1><h2 dir="ltr" style="color: rgb(85, 85, 85);">What is Azure Database for MySQL?</h2><ul><li dir="ltr">Azure Database for MySQL is a fully managed relational database service that provides scalable and high-performance database capabilities for applications hosted on Microsoft Azure.&nbsp;</li><li dir="ltr">The single server platform is designed to handle most of the database management functions such as patching, backups, high availability, security with minimal user configuration and control.&nbsp;</li><li dir="ltr">The architecture is optimized for built-in high availability with 99.99% availability in a single availability zone. It supports the community version of MySQL 5.6 (retired), 5.7 and 8.0. The service is generally available today in a wide variety of Azure regions.</li></ul><h2 dir="ltr" style="color: rgb(85, 85, 85);">What is an ARM template?</h2><ul><li dir="ltr">An ARM template is a JSON file that defines one or more resources to be deployed to Azure.</li><li dir="ltr">ARM templates use a declarative syntax, meaning you define the desired end state of your resources rather than the specific steps required to create them.</li><li dir="ltr">ARM templates can be used to deploy a wide variety of Azure resources, including virtual machines, storage accounts, virtual networks, and more.</li><li dir="ltr">They can also be used to deploy resources from the Azure Marketplace, such as SaaS applications and IaaS offerings.</li><li dir="ltr">ARM templates are an important part of the Azure DevOps process, as they can be used to automate the deployment of resources as part of a CI/CD pipeline.</li><li dir="ltr">They can be used in conjunction with Azure Automation to automate the deployment and management of resources on a scheduled basis.</li></ul><h1 dir="ltr" style="color: rgb(85, 85, 85);">Architecture Diagram <img src="https://labresources.whizlabs.com/61704542bd3e0d0542ea9cb62856be17/mysql%20server_43_39.png" style="height: 466px; margin-left: 0px; margin-top: 0px; width: 800px;"></h1><h1 dir="ltr" style="color: rgb(85, 85, 85);">Task Details</h1><ol><li dir="ltr">Launching Lab Environment</li><li dir="ltr">Explore the ARM template</li><li dir="ltr">Deploy the ARM template</li><li dir="ltr">Verify your deployment</li></ol>

<h1 dir="ltr" style="color: rgb(85, 85, 85);">Lab Details</h1><ol><li dir="ltr">In this lab, you will learn how to deploy an Azure Cache for Redis by using an ARM template.</li><li dir="ltr">Duration:&nbsp;30 minutes</li></ol><h1 dir="ltr" style="color: rgb(85, 85, 85);">Introduction</h1><h2 dir="ltr" style="color: rgb(85, 85, 85);">What is Azure Cache for Redis?</h2><ul><li dir="ltr">Azure Cache for Redis is a fully managed, in-memory data store that is based on the popular open source Redis cache.</li><li dir="ltr">It provides high-performance and low-latency access to data by caching frequently used data in memory.</li><li dir="ltr">Azure Cache for Redis is designed to work with a variety of programming languages and data structures, including .NET, Java, Node.js, Python, and more.</li><li dir="ltr">It can be used to improve the performance of applications that require frequent reads and writes to a database, by caching data in-memory and reducing the number of database calls.</li><li dir="ltr">It supports various Redis features, such as Pub/Sub messaging, Lua scripting, transactions, and more.</li><li dir="ltr">Azure Cache for Redis provides multiple tiers with different memory sizes and features, including a basic tier for development and testing, a standard tier for production workloads, and a premium tier with more advanced features and higher scalability.</li><li dir="ltr">It can be easily integrated with other Azure services, such as Azure Web Apps, Azure Functions, and Azure Kubernetes Service, to enhance the performance and scalability of applications.</li><li dir="ltr">Azure Cache for Redis also provides features such as monitoring, alerting, and autoscaling to help manage and optimize the cache.</li><li dir="ltr">It uses industry-standard encryption and authentication protocols to ensure the security and privacy of data in transit and at rest. &nbsp;</li></ul><h2 dir="ltr" style="color: rgb(85, 85, 85);">What is an ARM template?</h2><ul><li dir="ltr">An ARM template is a JSON file that defines one or more resources to be deployed to Azure.</li><li dir="ltr">ARM templates use a declarative syntax, meaning you define the desired end state of your resources rather than the specific steps required to create them.</li><li dir="ltr">ARM templates can be used to deploy a wide variety of Azure resources, including virtual machines, storage accounts, virtual networks, and more.</li><li dir="ltr">They can also be used to deploy resources from the Azure Marketplace, such as SaaS applications and IaaS offerings.</li><li dir="ltr">ARM templates are an important part of the Azure DevOps process, as they can be used to automate the deployment of resources as part of a CI/CD pipeline.</li><li dir="ltr">They can be used in conjunction with Azure Automation to automate the deployment and management of resources on a scheduled basis.</li></ul><h1 dir="ltr" style="color: rgb(85, 85, 85);">Architecture Diagram <img src="https://labresources.whizlabs.com/f59951bcccd1bd0d2b9e4b648ffb5ef4/Azure%20Cache%20for%20Redis_15_17.png" style="height: 466px; margin-left: 0px; margin-top: 0px; width: 800px;"></h1><h1 dir="ltr" style="color: rgb(85, 85, 85);">Task Details</h1><ol><li dir="ltr">Sign in to Azure Portal</li><li dir="ltr">Explore the ARM template</li><li dir="ltr">Deploy the ARM template</li><li dir="ltr">Verify your deployment</li></ol><h1 dir="ltr" style="color: rgb(85, 85, 85);">Launching Lab Environment</h1><ol><li dir="ltr">To launch the lab environment, click on the&nbsp;<img src="https://labresources.whizlabs.com/f59951bcccd1bd0d2b9e4b648ffb5ef4/image11_15_58.png" style="height: 39px; margin-left: 0px; margin-top: 0px; width: 257px;">&nbsp;button.</li><li dir="ltr">Please wait until the cloud environment is provisioned.</li><li dir="ltr">Once the lab is started, you will be provided with a&nbsp;username&nbsp;and&nbsp;password. &nbsp;</li></ol>&nbsp;&nbsp;&nbsp;&nbsp;Note&nbsp;: You can only start one lab at a time.

<h1 style="color: rgb(85, 85, 85);">Lab Details</h1><ol><li>In this lab we will walk through the steps of deploying an Azure SQL database and server using Azure Bicep.</li><li>Duration:&nbsp;30 minutes.</li></ol><h1 style="color: rgb(85, 85, 85);">Introduction</h1><h2 style="color: rgb(85, 85, 85);">What is an Azure SQL database?</h2><ul><li>Azure SQL database is a managed cloud database service from Microsoft.</li><li>It is a fully managed database-as-a-service (DBaaS) that provides a managed, cloud-based environment for developing, deploying, and managing data-driven applications.</li><li>It is based on the latest stable version of the Microsoft SQL Server database engine.</li><li>It is highly scalable, with the ability to automatically scale up or down based on workload demand.</li><li>It includes built-in high availability and failover capabilities.</li><li>It is optimized for performance, with the ability to fine-tune performance and optimize query performance.</li><li>It integrates seamlessly with other Azure services, including Azure Machine Learning, Azure Stream Analytics, and Azure Functions.</li></ul><h2 style="color: rgb(85, 85, 85);">What is Azure Bicep?</h2><ul><li>Azure Bicep is a Domain Specific Language (DSL) for deploying Azure resources.</li><li>It simplifies the creation and maintenance of infrastructure as code (IaC).</li><li>Bicep uses a simplified syntax compared to Azure Resource Manager (ARM) templates.</li><li>Bicep allows you to create modular templates that can be easily shared and reused.</li><li>Bicep integrates with Azure DevOps, GitHub, and other tools commonly used for infrastructure as code.</li></ul><h1 style="color: rgb(85, 85, 85);">Architecture Diagram</h1><img alt="" src="https://labresources.whizlabs.com/18ff74084ff4c8d4595afb4e4fe950bb/Deploying%20Azure%20SQL%20database%20using%20Bicep_30_54.png" style="width: 800px; height: 517px;"><h1 style="color: rgb(85, 85, 85);">Task Details</h1><ol><li>Sign in to Azure Portal</li><li>Explore the Bicep file</li><li>Deploy the Bicep file</li><li>Verify your deployments</li></ol><h1 style="color: rgb(85, 85, 85);">Launching Lab Environment</h1><ol><li>To launch the lab environment, click on the&nbsp;<img alt="" src="https://labresources.whizlabs.com/18ff74084ff4c8d4595afb4e4fe950bb/start%20lab_29_24.png" style="width: 238px; height: 36px;">&nbsp;button.</li><li>Please wait until the cloud environment is provisioned.</li><li>Once the lab is started, you will be provided with a&nbsp;username&nbsp;and&nbsp;password.&nbsp;</li></ol>&nbsp;<span style="font-size: 12pt; font-family: Arial; background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; vertical-align: baseline; white-space: pre-wrap;">&nbsp;&nbsp;Note : <span style="font-size: 12pt; font-family: Arial; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; vertical-align: baseline; white-space: pre-wrap;">You can only start one lab at a time.&nbsp;

<h1 dir="ltr" style="margin-top: 0pt; margin-bottom: 0pt; color: rgb(85, 85, 85);"><span style="color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; text-decoration-line: underline; text-decoration-skip-ink: none; vertical-align: baseline; white-space: pre-wrap;">Lab Details</h1><ol style="margin-bottom: 0px; padding-inline-start: 48px;"><li aria-level="1" dir="ltr" style="list-style-type: decimal; font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; vertical-align: baseline; white-space: pre;">In this lab we will walk through the steps<span style="font-family: arial, helvetica, sans-serif; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; vertical-align: baseline; white-space: pre-wrap;"> to <span style="font-family: arial, helvetica, sans-serif; background-color: transparent; color: rgb(22, 22, 22); font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; vertical-align: baseline; white-space: pre-wrap;">deploy a Bicep file to create an Azure Cosmos DB database and a container within that database.	</li><li aria-level="1" dir="ltr" style="list-style-type: decimal; font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; vertical-align: baseline; white-space: pre;">Duration: <span style="font-family: arial, helvetica, sans-serif; background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; vertical-align: baseline; white-space: pre-wrap;">30 minutes<span style="font-family: arial, helvetica, sans-serif; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; vertical-align: baseline; white-space: pre-wrap;">. </li></ol><h1 dir="ltr" style="margin-top: 0pt; margin-bottom: 0pt; color: rgb(85, 85, 85);"><span style="color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; text-decoration-line: underline; text-decoration-skip-ink: none; vertical-align: baseline; white-space: pre-wrap;">Introduction</h1><h2 dir="ltr" style="color: rgb(85, 85, 85); margin-top: 0pt; margin-bottom: 0pt;"><span style="color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; text-decoration-line: underline; text-decoration-skip-ink: none; vertical-align: baseline; white-space: pre-wrap;">What is an Azure Cosmos DB? &nbsp;</h2><ul style="margin-bottom: 0px; padding-inline-start: 48px;"><li aria-level="1" dir="ltr" style="list-style-type: disc; font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; vertical-align: baseline; white-space: pre;">Azure Cosmos DB is a globally distributed, multi-model NoSQL database service provided by Microsoft.&nbsp;	</li><li aria-level="1" dir="ltr" style="list-style-type: disc; font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; vertical-align: baseline; white-space: pre;">It is designed to be highly available, scalable, and offer low-latency access to data for global applications.	</li><li aria-level="1" dir="ltr" style="list-style-type: disc; font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; vertical-align: baseline; white-space: pre;">Some of the key features of Azure Cosmos DB include: </li></ul><ul style="margin-bottom: 0px; padding-inline-start: 48px;"><li aria-level="1" dir="ltr" style="list-style-type: circle; font-size: 13pt; font-family: Roboto, sans-serif; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; vertical-align: baseline; white-space: pre; margin-left: 36pt;">Multi-Model Support: Azure Cosmos DB supports multiple data models such as document, key-value, graph, and column-family, giving developers the flexibility to choose the appropriate data model for their application.	</li><li aria-level="1" dir="ltr" style="list-style-type: circle; font-size: 13pt; font-family: Roboto, sans-serif; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; vertical-align: baseline; white-space: pre; margin-left: 36pt;">Global Distribution: Azure Cosmos DB can distribute data globally across multiple regions, ensuring low-latency access to data from anywhere in the world.	</li><li aria-level="1" dir="ltr" style="list-style-type: circle; font-size: 13pt; font-family: Roboto, sans-serif; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; vertical-align: baseline; white-space: pre; margin-left: 36pt;">High Availability: Azure Cosmos DB offers high availability with multiple replicas of data stored in different regions, reducing the risk of data loss or downtime.	</li><li aria-level="1" dir="ltr" style="list-style-type: circle; font-size: 13pt; font-family: Roboto, sans-serif; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; vertical-align: baseline; white-space: pre; margin-left: 36pt;">Scalability: Azure Cosmos DB is designed to scale horizontally, allowing developers to scale their databases as needed without worrying about hardware or infrastructure.	</li><li aria-level="1" dir="ltr" style="list-style-type: circle; font-size: 13pt; font-family: Roboto, sans-serif; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; vertical-align: baseline; white-space: pre; margin-left: 36pt;">Consistency: Azure Cosmos DB offers five consistency levels to choose from, allowing developers to choose the level of consistency that best suits their application.	</li><li aria-level="1" dir="ltr" style="list-style-type: circle; font-size: 13pt; font-family: Roboto, sans-serif; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; vertical-align: baseline; white-space: pre; margin-left: 36pt;">Multiple APIs: Azure Cosmos DB supports multiple APIs, including SQL, MongoDB, Cassandra, Gremlin, and Azure Table Storage, making it easy for developers to migrate their existing applications to Azure Cosmos DB. </li></ul><h2 dir="ltr" style="color: rgb(85, 85, 85); margin-top: 0pt; margin-bottom: 0pt;"><span style="color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; text-decoration-line: underline; text-decoration-skip-ink: none; vertical-align: baseline; white-space: pre-wrap;">What is a Bicep file? &nbsp;</h2><ul style="margin-bottom: 0px; padding-inline-start: 48px;"><li aria-level="1" dir="ltr" style="list-style-type: disc; font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; vertical-align: baseline; white-space: pre;">Bicep (short for "Bicep is a declarative language for describing Azure resources") is a domain-specific language (DSL) for Azure Resource Manager (ARM) templates.&nbsp;	</li><li aria-level="1" dir="ltr" style="list-style-type: disc; font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; vertical-align: baseline; white-space: pre;">A Bicep file is a file written in the Bicep language that defines the infrastructure and resources that make up an Azure deployment.	</li><li aria-level="1" dir="ltr" style="list-style-type: disc; font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; vertical-align: baseline; white-space: pre;">Bicep files are used to create, deploy, and manage Azure resources using Infrastructure as Code (IaC) principles.&nbsp;	</li><li aria-level="1" dir="ltr" style="list-style-type: disc; font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; vertical-align: baseline; white-space: pre;">Bicep files are easier to read and maintain than ARM templates, as they use a more intuitive syntax and allow for modularization and reuse of code. </li></ul><h1 dir="ltr" style="margin-top: 0pt; margin-bottom: 0pt; color: rgb(85, 85, 85);"><span style="color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; text-decoration-line: underline; text-decoration-skip-ink: none; vertical-align: baseline; white-space: pre-wrap;">Architecture Diagram &nbsp;</h1><img alt="" src="https://labresources.whizlabs.com/3b2db94926f069a4e5058b17aea458e1/image12_02_29.png" style="width: 800px; height: 495px;"> &nbsp;&nbsp;Task Details<ol style="margin-bottom: 0px; padding-inline-start: 48px;"><li aria-level="1" dir="ltr" style="list-style-type: decimal; font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; vertical-align: baseline; white-space: pre;">Sign in to Azure Portal	</li><li aria-level="1" dir="ltr" style="list-style-type: decimal; font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; vertical-align: baseline; white-space: pre;">Explore the Bicep file	</li><li aria-level="1" dir="ltr" style="list-style-type: decimal; font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; vertical-align: baseline; white-space: pre;">Deploy the Bicep file	</li><li aria-level="1" dir="ltr" style="list-style-type: decimal; font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; vertical-align: baseline; white-space: pre;">Verify your deployment	</li></ol><h1 dir="ltr" style="margin-top: 20pt; margin-bottom: 6pt; line-height: 1.38; color: rgb(85, 85, 85);"><span style="color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; text-decoration-line: underline; text-decoration-skip-ink: none; vertical-align: baseline; white-space: pre-wrap;">Launching Lab Environment</h1><ol style="margin-bottom: 0px; padding-inline-start: 48px;"><li aria-level="1" dir="ltr" style="list-style-type: decimal; font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; vertical-align: baseline; white-space: pre;">To launch the lab environment, click on the <img alt="" src="https://labresources.whizlabs.com/3b2db94926f069a4e5058b17aea458e1/image11_05_10.png" style="width: 253px; height: 38px;"><span style="font-family: arial, helvetica, sans-serif; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; vertical-align: baseline; white-space: pre-wrap;"> button.	</li><li aria-level="1" dir="ltr" style="list-style-type: decimal; font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; vertical-align: baseline; white-space: pre;">Please wait until the cloud environment is provisioned.	</li><li aria-level="1" dir="ltr" style="list-style-type: decimal; font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; vertical-align: baseline; white-space: pre;">Once the lab is started, you will be provided with a <span style="font-family: arial, helvetica, sans-serif; background-color: transparent; font-weight: 700; font-style: italic; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; vertical-align: baseline; white-space: pre-wrap;">username<span style="font-family: arial, helvetica, sans-serif; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; vertical-align: baseline; white-space: pre-wrap;"> and <span style="font-family: arial, helvetica, sans-serif; background-color: transparent; font-weight: 700; font-style: italic; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; vertical-align: baseline; white-space: pre-wrap;">password<span style="font-family: arial, helvetica, sans-serif; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; vertical-align: baseline; white-space: pre-wrap;">. 	</li></ol><span style="color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; vertical-align: baseline; white-space: pre-wrap;">&nbsp;&nbsp;&nbsp;&nbsp;Note<span style="color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; vertical-align: baseline; white-space: pre-wrap;"> : You can only start one lab at a time.

<h1 dir="ltr" style="margin-top: 0pt; margin-bottom: 0pt; color: rgb(85, 85, 85);"><span style="color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; text-decoration-line: underline; text-decoration-skip-ink: none; vertical-align: baseline; white-space: pre-wrap; font-family: Arial;">Lab Details</h1><ol style="margin-bottom: 0px; padding-inline-start: 48px;"><li aria-level="1" dir="ltr" style="list-style-type: decimal; font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; vertical-align: baseline; white-space: pre;">In this lab we will use Bicep to deploy a cache using Azure Cache for Redis.	</li><li aria-level="1" dir="ltr" style="list-style-type: decimal; font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; vertical-align: baseline; white-space: pre;">Duration: <span style="background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; vertical-align: baseline; white-space: pre-wrap;">30 minutes. </li></ol><h1 dir="ltr" style="margin-top: 0pt; margin-bottom: 0pt; color: rgb(85, 85, 85);">Introduction</h1><span style="font-size: 18pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; text-decoration-skip-ink: none; vertical-align: baseline; white-space: pre-wrap;">What is Azure Cache for Redis?

<h2 dir="ltr" style="line-height: 1.2; color: rgb(85, 85, 85); margin-top: 0pt; margin-bottom: 0pt;"><ul style="margin-bottom: 0px; padding-inline-start: 48px;"><li dir="ltr" aria-level="1" style="list-style-type: disc; font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; vertical-align: baseline; white-space: pre;">Azure Cache for Redis is a fully managed, in-memory data store that is based on the popular open source Redis cache.</li><li dir="ltr" aria-level="1" style="list-style-type: disc; font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; vertical-align: baseline; white-space: pre;">It provides high-performance and low-latency access to data by caching frequently used data in memory.</li><li dir="ltr" aria-level="1" style="list-style-type: disc; font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; vertical-align: baseline; white-space: pre;">Azure Cache for Redis is designed to work with a variety of programming languages and data structures, including .NET, Java, Node.js, Python, and more.</li><li dir="ltr" aria-level="1" style="list-style-type: disc; font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; vertical-align: baseline; white-space: pre;">It can be used to improve the performance of applications that require frequent reads and writes to a database, by caching data in-memory and reducing the number of database calls.</li><li dir="ltr" aria-level="1" style="list-style-type: disc; font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; vertical-align: baseline; white-space: pre;">It supports various Redis features, such as Pub/Sub messaging, Lua scripting, transactions, and more.</li><li dir="ltr" aria-level="1" style="list-style-type: disc; font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; vertical-align: baseline; white-space: pre;">Azure Cache for Redis provides multiple tiers with different memory sizes and features, including a basic tier for development and testing, a standard tier for production workloads, and a premium tier with more advanced features and higher scalability.</li><li dir="ltr" aria-level="1" style="list-style-type: disc; font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; vertical-align: baseline; white-space: pre;">It can be easily integrated with other Azure services, such as Azure Web Apps, Azure Functions, and Azure Kubernetes Service, to enhance the performance and scalability of applications.</li><li dir="ltr" aria-level="1" style="list-style-type: disc; font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; vertical-align: baseline; white-space: pre;">Azure Cache for Redis also provides features such as monitoring, alerting, and autoscaling to help manage and optimize the cache.</li><li dir="ltr" aria-level="1" style="list-style-type: disc; font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; vertical-align: baseline; white-space: pre;">It uses industry-standard encryption and authentication protocols to ensure the security and privacy of data in transit and at rest.</li></ul></h2><h2 dir="ltr" style="color: rgb(85, 85, 85); margin-top: 0pt; margin-bottom: 0pt;">What is a Bicep file? </h2><ul style="margin-bottom: 0px; padding-inline-start: 48px;"><li aria-level="1" dir="ltr" style="list-style-type: disc; font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; vertical-align: baseline; white-space: pre;">Bicep (short for "Bicep is a declarative language for describing Azure resources") is a domain-specific language (DSL) for Azure Resource Manager (ARM) templates.&nbsp;	</li><li aria-level="1" dir="ltr" style="list-style-type: disc; font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; vertical-align: baseline; white-space: pre;">A Bicep file is a file written in the Bicep language that defines the infrastructure and resources that make up an Azure deployment.	</li><li aria-level="1" dir="ltr" style="list-style-type: disc; font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; vertical-align: baseline; white-space: pre;">Bicep files are used to create, deploy, and manage Azure resources using Infrastructure as Code (IaC) principles.&nbsp;	</li><li aria-level="1" dir="ltr" style="list-style-type: disc; font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; vertical-align: baseline; white-space: pre;">Bicep files are easier to read and maintain than ARM templates, as they use a more intuitive syntax and allow for modularization and reuse of code. </li></ul><h1 dir="ltr" style="margin-top: 0pt; margin-bottom: 0pt; color: rgb(85, 85, 85);"><span style="color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; text-decoration-line: underline; text-decoration-skip-ink: none; vertical-align: baseline; white-space: pre-wrap;">Architecture Diagram <img src="https://labresources.whizlabs.com/c31965eeb6298771bc62efb0b60ac27d/cache%20redis%20bicep_53_51.png" width="25%" style="width: 710.2px; height: 439.843px;"> </h1> Task Details

<ol style="margin-bottom: 0px; padding-inline-start: 48px;"><li aria-level="1" dir="ltr" style="list-style-type: decimal; font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; vertical-align: baseline; white-space: pre;">Sign in to Azure Portal	</li><li aria-level="1" dir="ltr" style="list-style-type: decimal; font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; vertical-align: baseline; white-space: pre;">Explore the Bicep file	</li><li aria-level="1" dir="ltr" style="list-style-type: decimal; font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; vertical-align: baseline; white-space: pre;">Deploy the Bicep file	</li><li aria-level="1" dir="ltr" style="list-style-type: decimal; font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; vertical-align: baseline; white-space: pre;">Verify your deployment	</li></ol><h1 dir="ltr" style="margin-top: 20pt; margin-bottom: 6pt; line-height: 1.38; color: rgb(85, 85, 85);">Launching Lab Environment</h1><ol style="margin-bottom: 0px; padding-inline-start: 48px;"><li aria-level="1" dir="ltr" style="list-style-type: decimal; font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; vertical-align: baseline; white-space: pre;">To launch the lab environment, click on the <img alt="" src="https://labresources.whizlabs.com/3b2db94926f069a4e5058b17aea458e1/image11_05_10.png" style="width: 253px; height: 38px;"><span style="font-family: arial, helvetica, sans-serif; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; vertical-align: baseline; white-space: pre-wrap;"> button.	</li><li aria-level="1" dir="ltr" style="list-style-type: decimal; font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; vertical-align: baseline; white-space: pre;">Please wait until the cloud environment is provisioned.	</li><li aria-level="1" dir="ltr" style="list-style-type: decimal; font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; vertical-align: baseline; white-space: pre;">Once the lab is started, you will be provided with a <span style="font-family: arial, helvetica, sans-serif; background-color: transparent; font-weight: 700; font-style: italic; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; vertical-align: baseline; white-space: pre-wrap;">username<span style="font-family: arial, helvetica, sans-serif; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; vertical-align: baseline; white-space: pre-wrap;"> and <span style="font-family: arial, helvetica, sans-serif; background-color: transparent; font-weight: 700; font-style: italic; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; vertical-align: baseline; white-space: pre-wrap;">password<span style="font-family: arial, helvetica, sans-serif; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; vertical-align: baseline; white-space: pre-wrap;">. 	</li></ol><span style="color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; vertical-align: baseline; white-space: pre-wrap;">&nbsp;&nbsp;&nbsp;&nbsp;Note<span style="color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; vertical-align: baseline; white-space: pre-wrap;"> : You can only start one lab at a time.

<h1 style="color: rgb(85, 85, 85);">&nbsp;Lab Details</h1><ol><li>In this lab we will&nbsp;learn how to deploy a single database using Terraform.</li><li>Duration:&nbsp;30&nbsp;minutes.</li></ol><h1 style="color: rgb(85, 85, 85);">Introduction</h1><h2 dir="ltr" style="color: rgb(85, 85, 85);">What is an Azure SQL Database?</h2><ul><li dir="ltr" aria-level="1" style="list-style-type: disc; font-size: 12pt; font-family: Arial; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; vertical-align: baseline; white-space: pre;">Fully Managed Service: Azure SQL Database is a fully managed platform-as-a-service (PaaS) offering, which means Microsoft handles the infrastructure management, including patching, backups, and high availability, allowing you to focus on developing your applications.</li><li dir="ltr" aria-level="1" style="list-style-type: disc; font-size: 12pt; font-family: Arial; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; vertical-align: baseline; white-space: pre;">Compatibility: Azure SQL Database is based on Microsoft SQL Server, ensuring compatibility with existing SQL Server applications, tools, and skills. It supports the same T-SQL language and offers similar functionalities.</li><li dir="ltr" aria-level="1" style="list-style-type: disc; font-size: 12pt; font-family: Arial; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; vertical-align: baseline; white-space: pre;">Scalability: Azure SQL Database provides flexible scalability options. You can easily scale up or down the database resources to match your application's needs. It allows you to adjust compute power, storage, and performance levels on the fly without downtime.</li><li dir="ltr" aria-level="1" style="list-style-type: disc; font-size: 12pt; font-family: Arial; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; vertical-align: baseline; white-space: pre;">High Availability and Reliability: Azure SQL Database offers built-in high availability and fault tolerance features. It automatically replicates your database to multiple Azure regions, ensuring data redundancy and minimizing downtime.</li><li dir="ltr" aria-level="1" style="list-style-type: disc; font-size: 12pt; font-family: Arial; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; vertical-align: baseline; white-space: pre;">Security: Azure SQL Database provides robust security features to protect your data. It includes encryption at rest and in transit, built-in threat detection, firewall rules, role-based access control, and advanced data security capabilities.</li><li dir="ltr" aria-level="1" style="list-style-type: disc; font-size: 12pt; font-family: Arial; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; vertical-align: baseline; white-space: pre;">Intelligent Performance: Azure SQL Database leverages intelligent query processing capabilities, such as automatic indexing, query optimization, and performance recommendations. It helps improve query performance and overall database efficiency.</li></ul><h2 style="color: rgb(85, 85, 85);">What is Terraform?</h2><ul><li>Terraform is an open-source infrastructure as code (IC) software tool created by HashiCorp.</li><li>It allows users to define, provision, and manage infrastructure resources (such as virtual machines, storage accounts, and network interfaces) in a cloud environment through code.</li><li>Terraform uses a declarative language to describe the desired state of the infrastructure and automatically creates the necessary resources to achieve that state.</li><li>It supports multiple cloud providers (such as AWS, Azure, and Google Cloud Platform) and other infrastructure platforms (such as Kubernetes and OpenStack).</li><li>Terraform follows a plan and apply workflow that allows users to preview changes before applying them to the infrastructure, helping to prevent misconfigurations and unexpected downtime.</li><li>Terraform keeps track of the current state of the infrastructure, allowing users to easily update, destroy, or recreate resources as needed.</li><li>Terraform modules enable users to create reusable blocks of infrastructure code that can be shared across projects or teams.</li><li>Terraform can be used in a team environment, allowing multiple users to work on the same infrastructure codebase concurrently and providing version control for infrastructure changes.</li><li>Terraform is widely used by DevOps engineers, infrastructure teams, and developers to automate infrastructure provisioning and configuration, reduce human error, and increase productivity.</li></ul><h1 style="color: rgb(85, 85, 85);">Architecture Diagram</h1> &nbsp;<img src="https://labresources.whizlabs.com/143fb25f342696998ec19090bad8d94c/sql_database_20_55.png" width="25%" style="width: 639.057px; height: 376.35px;"><h1 style="color: rgb(85, 85, 85);">Task Details</h1><ol><li>Sign in to Azure Portal</li><li>Explore the Terraform code</li><li>Deploy the Terraform code</li><li>Verify your deployment</li></ol><h1 style="color: rgb(85, 85, 85);">Launching Lab Environment</h1><ol><li>To launch the lab environment, click on the&nbsp;<img alt="" src="https://labresources.whizlabs.com/9bef332814dd1bb1a7c86df2106a69b4/image15_29_47.png" style="height: 36px; width: 237px;">&nbsp;button.</li><li>Please wait until the cloud environment is provisioned.</li><li>Once the lab is started, you will be provided with a&nbsp;username&nbsp;and&nbsp;password.</li></ol>&nbsp;&nbsp;&nbsp; Note&nbsp;: You can only start one lab at a time.

<h1>Lab Details</h1>

<ol>
	<li>
	In this lab we will walk through the steps on how to resize a virtual machine.
	</li>
	<li>
	Duration:&nbsp;60 minutes
	</li>
</ol>

<h1>Introduction</h1>

<h2>What is a Virtual Machine?</h2>

<ul>
	<li>
	A virtual machine (VM) is a virtual environment that functions as a virtual computer system with its own CPU, memory, network interface, and storage, created on a physical hardware system (located off- or on-premises).
	</li>
	<li>
	VMs allow multiple different operating systems to run simultaneously on a single computer
	</li>
	<li>
	A VM provides an environment that is isolated from the rest of a system, so whatever is running inside a VM won&rsquo;t interfere with anything else running on the host hardware.
	</li>
</ul>

<h1>Task Details</h1>

<ol>
	<li>
	Launching Lab Environment
	</li>
	<li>
	Create a virtual machine
	</li>
	<li>
	Resize VM using portal
	</li>
	<li>
	Resize VM using CLI
	</li>
</ol>

<h1 dir="ltr" style="color: rgb(85, 85, 85);">Lab Details</h1><ol><li dir="ltr">In this lab we will walk through the steps to create a Redis Cache on Azure and connect with the Cache through Redis CLI.</li><li dir="ltr">Duration:&nbsp;60&nbsp;minutes.</li></ol><h1 dir="ltr" style="color: rgb(85, 85, 85);">Introduction</h1><h2 dir="ltr" style="color: rgb(85, 85, 85);">What is an Azure Cache for Redis?</h2><ul><li dir="ltr">Redis is a caching system that works by temporarily storing information in a key-value data structure in memory for faster data access.&nbsp;Azure Cache for Redis, provided by Azure is a fully managed, in-memory cache that enables high-performance and scalable architectures by providing superior throughput and performance to handle millions of requests per second with down to sub-millisecond latency. It runs alongside the primary database or can be deployed as a standalone application.</li><li dir="ltr">Azure Cache for Redis stores data in memory. Since memory is significantly faster than disk storage, data can be written and retrieved much faster.</li><li dir="ltr">Redis is a single-threaded server, and it processes commands one at a time</li><li dir="ltr">It can perform automatic hardware provisioning, scaling, patching and updates while the user can focus only on the primary application/development.</li></ul><h2 dir="ltr" style="color: rgb(85, 85, 85);">What is Redis CLI?</h2><ul><li dir="ltr">The redis-cli is a command-line utility that helps in interacting with Redis Cache using Redis commands directly from the command-line terminal.&nbsp;</li><li dir="ltr">There are two ports through which we can connect to Redis:</li></ul><ol><li>SSL Port- 6380.</li><li>Non-SSL Port- 6379</li></ol><h1 dir="ltr" style="color: rgb(85, 85, 85);">Architecture Diagram</h1><img alt="" src="https://labresources.whizlabs.com/1dc2ee9cf945ece326708c5a0257af6c/image16_09_15.png" style="border-width: 1px; border-style: solid; height: 416px; width: 750px;"><h1 dir="ltr" style="color: rgb(85, 85, 85);">Task Details</h1><ol><li dir="ltr">Launching Lab Environment</li><li dir="ltr">Create a namespace in the Azure Portal</li><li dir="ltr">Get the connection string</li><li dir="ltr">Create a topic in the namespace</li><li dir="ltr">Create a subscription to the topic</li><li dir="ltr">Delete the resources</li></ol><h1 style="color: rgb(85, 85, 85);">Launching Lab&nbsp;Environment</h1><ol><li dir="ltr">To launch the lab environment, click on the&nbsp;Start Lab&nbsp;button.</li><li dir="ltr">Please wait until the cloud environment is provisioned.</li><li dir="ltr">Once the lab is started, you will be provided with a&nbsp;username&nbsp;and&nbsp;password.&nbsp;</li></ol><div style="background: rgb(238, 238, 238); border: 1px solid rgb(204, 204, 204); padding: 5px 10px;">Note&nbsp;: You can only start one lab at a time.</div>

<h1 dir="ltr" style="color: rgb(85, 85, 85);">Lab Details</h1><ol><li dir="ltr">In this lab we will walk through the steps to deploy a container on Azure App Services.</li><li dir="ltr">Duration:&nbsp;45 minutes.</li></ol><h1 dir="ltr" style="color: rgb(85, 85, 85);">Introduction</h1><h2 dir="ltr" style="color: rgb(85, 85, 85);">What are Docker Containers?</h2><ul><li dir="ltr">A container is a standard unit of software that packages up code and all its dependencies so the application runs quickly and reliably from one computing environment to another.&nbsp;</li><li dir="ltr">Multiple containers can run on the same machine and share the OS kernel with other containers, each running as isolated processes in user space.</li><li dir="ltr">Containers are lightweight, portable, platform independent and improves resource utilization.</li></ul><h2 dir="ltr" style="color: rgb(85, 85, 85);">What is a Container Image?</h2><ul><li dir="ltr">A Docker container image is a lightweight, standalone, executable package of software that includes everything needed to run an application: code, runtime, system tools, system libraries and settings.</li><li dir="ltr">It is a read-only template with instructions for creating a Docker container.</li></ul><h2 dir="ltr" style="color: rgb(85, 85, 85);">What is Azure Container Registry?</h2><ul><li dir="ltr">A container registry is a service that stores and distributes container images and related artifacts. It is like a central repository that stores the container images.&nbsp;</li><li dir="ltr">Azure Container Registry allows you to build, store, and manage container images and artifacts in a private registry for all types of container deployments.?</li></ul><h1 dir="ltr" style="color: rgb(85, 85, 85);">Architecture Diagram</h1><div style="text-align: center;">&nbsp;<img src="https://labresources.whizlabs.com/362e1843274bfeef1448c8df4621dd0c/containerizing_web_apps_on_azure_app_service_50_51.png" width="25%" style="width: 768.825px; height: 721.488px;"></div><div><h1 dir="ltr">Task Details</h1><ol><li dir="ltr">Launching Lab Environment</li><li dir="ltr">Create an instance of Azure Container Registry</li><li dir="ltr">Download and install Docker</li><li dir="ltr">Building a container image</li><li dir="ltr">Log in to the Conatiner Registry</li><li dir="ltr">Pushing the docker image to Azure Container Registry</li><li dir="ltr">Deploy an Azure App Service</li><li dir="ltr">Browse the app</li><li dir="ltr">Validate the lab</li><li dir="ltr">Delete the resources</li></ol><h1 dir="ltr">Launching Lab Environment</h1><ol><li dir="ltr">To launch the lab environment, click on the&nbsp;Start lab&nbsp;button.</li><li dir="ltr">Please wait until the cloud environment is provisioned.</li><li dir="ltr">Once the lab is started, you will be provided with a&nbsp;username&nbsp;and&nbsp;password.</li></ol><div style="background: rgb(238, 238, 238); border: 1px solid rgb(204, 204, 204); padding: 5px 10px;">Note&nbsp;: You can only start one lab at a time.</div></div>

<h1 dir="ltr" style="line-height: 1.2; font-family: sans-serif, Arial, Verdana, &quot;Trebuchet MS&quot;;">Prerequisites</h1><ol style="padding: 0px 40px; font-family: sans-serif, Arial, Verdana, &quot;Trebuchet MS&quot;; font-size: 13px;"><li dir="ltr">Knowledge of the listed Azure services:<ul style="padding: 0px 40px; list-style-type: disc;"><li dir="ltr">Azure SQL Server</li><li dir="ltr">Azure Private endpoint</li></ul></li><li dir="ltr">Laptop</li><li dir="ltr">Internet Browser</li><li dir="ltr">Internet Connection</li></ol><h1 dir="ltr" style="line-height: 1.2; font-family: sans-serif, Arial, Verdana, &quot;Trebuchet MS&quot;;">Challenge Instructions</h1><ol style="padding: 0px 40px; font-family: sans-serif, Arial, Verdana, &quot;Trebuchet MS&quot;; font-size: 13px;"><li dir="ltr">Region: Make sure to use the&nbsp;&nbsp;<kbd>East US</kbd>&nbsp;region to create all the resources.</li><li dir="ltr">You will be provided with the requirements of the challenge. If you are new to Azure Cloud, we recommend you to go through our hands-on Labs before taking this challenge.</li><li dir="ltr">Challenge Duration:&nbsp;&nbsp;<kbd>90 minutes</kbd></li></ol><h1 dir="ltr" style="line-height: 1.2; font-family: sans-serif, Arial, Verdana, &quot;Trebuchet MS&quot;;">Launching Challenge&nbsp;Environment</h1><ol style="padding: 0px 40px; font-family: sans-serif, Arial, Verdana, &quot;Trebuchet MS&quot;; font-size: 13px;"><li dir="ltr">To launch the challenge environment, click on the&nbsp;<img data-cke-saved-src="https://labresources.whizlabs.com/bea1b9be9684ae19077b904cf09c9d70/start.png" src="https://labresources.whizlabs.com/bea1b9be9684ae19077b904cf09c9d70/start.png" style="cursor: default; height: 36px; margin-left: 0px; margin-top: 0px; width: 237px;">&nbsp;button.</li><li dir="ltr">Please wait until the cloud environment is provisioned.</li><li dir="ltr">Once the challenge&nbsp;creation process is completed, you will be provided a&nbsp;username&nbsp;and&nbsp;password.</li></ol><div style="font-family: sans-serif, Arial, Verdana, &quot;Trebuchet MS&quot;; font-size: 13px; background: rgb(238, 238, 238); border: 1px solid rgb(204, 204, 204); padding: 5px 10px;">Note&nbsp;: You can only start one challenge at any given time.</div>

DP-300: Administering Microsoft Azure SQL Solutions&nbsp;is intended for database administrators and data management specialists. Enroll in DP-300 training to become a Microsoft Certified Azure Database Administrator Associate.

DP-300: Administering Microsoft Azure SQL Solutions

DP-300 Cloud Sandbox is a real time Azure environment. This sandbox provisioned with the Azure services that are required to pass the DP 300 certification exam. This is unlimited access to practice, test and experiment your ideas to prepare for Administering Microsoft Azure SQL Solutions exam.
If you find any services that are not supported in our Sandbox, please send a e-mail to&nbsp;<a href="mailto:support@whizlabs.com">support@whizlabs.com</a>.&nbsp;

Practice Tests

Millions of aspirants have become certified with our practice tests. Give your preparation a new edge with Whizlabs Microsoft Azure DP-300 Practice Tests.

Microsoft Azure DP-300 Practice Tests - Whizlabs

Online Course

Have helped over 1.5 million Azure professionals in their certification exam preparation. Enrol now for Microsoft Azure Exam DP-300 Online Course.

Microsoft Azure Exam DP-300 Online Course - Whizlabs

Free Test

Preparing for Microsoft Azure Exam DP-300 certification exam? Check your current preparation level with Microsoft Azure Exam DP-300 free test. Try now!

Microsoft Azure Exam DP-300 Free Test - Whizlabs

Exam DP-300: Administering Microsoft Azure SQL Solutions

Pass Microsoft Azure Exam DP-300 Certification in 1st Attempt. Trained 5M+ professionals since 20 years. Start with Free Trial!

Microsoft Azure Exam DP-300 Certification - Whizlabs

Practice Exams, Video Lectures and Hands-on Labs

3 Full-length Mock Exams (165 unique Microsoft Azure DP-300 Certification Exam practice questions)

6 hours 59 minutes Training Videos for all the certification exam objectives. Our easy-to-understand explanation, even for the difficult concepts.

10 demonstrations (hands-on labs) within the lectures as a part of the video course.

Our support team consists of Azure Experts, ready to clarify all your questions.

Our Course comes with the unlimited access for 1 year.

Exam DP-300: Administering Microsoft Azure SQL Solutions Feedback from Our Customers.

AWS Certification Training Courses

AWS Cloud Practitioner certification demonstrates and validates your knowledge on the overall understanding of AWS Cloud Platfoliyo

Google Cloud Certifications

DevOps Certifications

Dear User,
Greetings from Whizlabs!Hope you are doing well.
We're thankful for your honest opinion.
Regards,
Jai Shree

Alan Eager

Very good content in terms of online videos and practice tests for the DP-300 certification exam. Helped me in passing the test.

Very helpful in getting my Azure DB Administrator Associate

It is exciting to see your passing score and we are glad to be a part of it!!!

DP 300 

It is indeed our pleasure to be able to support and help you in your journey!!!

The training manual was very helpful and I was able to gain insight that helped in passing the exam.

Highly recommended

Only took the practice tests. They are well put together and the explanation and links helped. The main thing with the tests and all of whizlabs is the ability to go question by question as sometimes we do not have the time to answer all questions on a seating, but answering a few and go into the learning rabbit whole for the one we truly have no idea is better than batches at least for me.

Rev DP-300

Muito útil e me ajudou muito, fui aprovado no exame DP-300

Muito útil e me ajudou muito 

Highly recommended 

Devkant Sharma

Practice tests are useful and many of the real exam questions are covered in them though with different answer options. Explanation to answers help build clarity of concept. Though at places marked answers are not correct so one should validate. I passed my exam. Thanks.

Practice tests are useful and many of the real exam questions are covered in them though with different answer options. Explanation to answers help build clarity of concept. Though at places marked answers are not correct so one should validate. 
However these need to be updated for change in course post AUG 04 2022.
Videos lessons are useful for knowing how to do but concept coverage wise they are not detailed and are very basic. One must refer MS Docs or their learning material for in-depth understanding.