{"id":92986,"date":"2024-02-12T05:00:44","date_gmt":"2024-02-12T10:30:44","guid":{"rendered":"https:\/\/www.whizlabs.com\/blog\/?p=92986"},"modified":"2024-02-14T21:40:10","modified_gmt":"2024-02-15T03:10:10","slug":"azure-database-services","status":"publish","type":"post","link":"https:\/\/www.whizlabs.com\/blog\/azure-database-services\/","title":{"rendered":"Understanding Azure Database Services using Hands-on Labs"},"content":{"rendered":"<p><span style=\"font-weight: 400;\">Azure Database Services is a Microsoft Azure cloud offering comprising managed database solutions such as <strong>Azure CosmosDB, Azure SQL Database, and much more to simplify data management.<\/strong><\/span><\/p>\n<p><span style=\"font-weight: 400;\">In this blog article, we are going to explore<\/span><a href=\"https:\/\/www.whizlabs.com\/databases-in-azure\/\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\"> Azure Database Services<\/span><\/a><span style=\"font-weight: 400;\"> with the help of our Guided hands-on labs.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">By going through these hands-on labs, you&#8217;ll be well-equipped to harness the full potential of Azure Database Services, enabling you to architect, deploy, and manage databases with confidence and proficiency.<\/span><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_76 ez-toc-wrap-left counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #ea7e02;color:#ea7e02\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #ea7e02;color:#ea7e02\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.whizlabs.com\/blog\/azure-database-services\/#Introduction_to_Azure_Database\" >Introduction to Azure Database<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.whizlabs.com\/blog\/azure-database-services\/#What_is_Azure_Database_Services\" >What is Azure Database Services?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.whizlabs.com\/blog\/azure-database-services\/#Benefits_of_Using_Azure_Database_Services\" >Benefits of Using Azure Database Services<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.whizlabs.com\/blog\/azure-database-services\/#Understanding_Azure_Database_Services_using_Hands-on_Labs\" >Understanding Azure Database Services using Hands-on Labs<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.whizlabs.com\/blog\/azure-database-services\/#FAQs\" >FAQs<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.whizlabs.com\/blog\/azure-database-services\/#Conclusion\" >Conclusion<\/a><\/li><\/ul><\/nav><\/div>\n<h3><span class=\"ez-toc-section\" id=\"Introduction_to_Azure_Database\"><\/span><span style=\"font-weight: 400;\">Introduction to Azure Database<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400;\">Azure, developed by Microsoft, stands as a comprehensive cloud platform offering a plethora of services, notably databases. These database solutions empower users to effortlessly store, oversee, and delve into data within the cloud environment.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">\u00a0Here&#8217;s a breakdown of Azure&#8217;s primary database choices:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Azure SQL Database: <\/b><span style=\"font-weight: 400;\">Operating on the robust SQL Server engine, this is a meticulously managed relational database service. It guarantees consistent performance, scalability, and top-tier security, catering to diverse applications like web apps, mobile platforms, and data analytics.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Azure Cosmos DB:<\/b><span style=\"font-weight: 400;\"> Recognized for its global distribution, Azure Cosmos DB stands out as a versatile, multi-model database service. It&#8217;s crafted for creating applications that demand expansive scalability, minimal latency, and unwavering availability.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Azure Database for MySQL: <\/b><span style=\"font-weight: 400;\">This fully managed MySQL database service is tailored for developers and it helps in application development using the developers&#8217; desired languages and frameworks. It stands as a high-performing, scalable, and secure choice for various applications, from web platforms to data analytics.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Azure Database for PostgreSQL:<\/b><span style=\"font-weight: 400;\"> Much like its MySQL counterpart, this PostgreSQL service offers developers the flexibility to craft applications using their chosen tools and languages. It promises stellar performance, scalability, and robust security, making it apt for a myriad of applications.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Azure Cache for Redis:<\/b><span style=\"font-weight: 400;\"> Positioned as an in-memory data reservoir, Azure Cache for Redis ensures rapid data accessibility for applications. With its support for multiple coding languages, it finds its niche in real-time analytics, messaging systems, and more.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">To encapsulate, Azure&#8217;s database suite presents a diverse array of solutions ranging from relational databases to memory-centric stores, each tailored to cater to distinct application needs in the cloud landscape.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"What_is_Azure_Database_Services\"><\/span><span style=\"font-weight: 400;\">What is Azure Database Services?<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400;\">Azure Database Services ensures the protection and monitoring of customer databases through the implementation of robust backup and recovery procedures. This involves regularly backing up database information, allowing for the restoration of data in the event of data loss or system failures.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">In addition, Azure Database Services provides a<\/span><b> secure database environment<\/b><span style=\"font-weight: 400;\"> by incorporating various security measures. These measures may include encryption of data at rest and in transit, access controls, and authentication mechanisms to safeguard sensitive information and restrict unauthorized access.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Furthermore, the service actively monitors database performance to ensure optimal functionality. Performance monitoring involves tracking key metrics, identifying potential bottlenecks, and addressing issues that may impact the efficiency of the database. This proactive monitoring helps maintain the overall health and responsiveness of the database environment.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Benefits_of_Using_Azure_Database_Services\"><\/span><span style=\"font-weight: 400;\">Benefits of Using Azure Database Services<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400;\">\u00a0Azure Database Services offers the following benefits:<\/span><\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Scalability: <\/b><span style=\"font-weight: 400;\">Azure\u2019s database options provide a wide range of scalability options, such as auto-scaling and read replicas to scale your database to meet the demanding needs of the workload.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>High Availability:<\/b><span style=\"font-weight: 400;\"> Azur&#8217;;e has built-in high availability and disaster recovery options which include Always On Availability Groups and Geo-Replication to achieve the availability and durability of the database.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Managed Maintenance:<\/b><span style=\"font-weight: 400;\"> Azure\u2019s managed database services include Azure SQL Database and Azure Cosmos DB help to maintain and manage the underlying infrastructure allowing you to focus on deploying and scaling your applications.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Security:<\/b><span style=\"font-weight: 400;\"> Azure offers security features such as encryption at rest and in transit to secure your database.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Compliance: <\/b><span style=\"font-weight: 400;\">Azure\u2019s database options comply with various industry standards such as GDPR and HIPAA to ensure the safety of the databases stored.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Integration with other Azure Services:<\/b><span style=\"font-weight: 400;\"> Azure\u2019s database options can be integrated with other Azure services, such as Azure Functions, Azure Data Lake, and Azure Machine Learning to apply in varied scenarios and use cases.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Monitoring and Performance Optimization: <\/b><span style=\"font-weight: 400;\">The Azure platform offers various tools and features, including Azure Monitor and Query Store to monitor and optimize the performance of the database.<\/span><\/li>\n<\/ol>\n<p><span style=\"font-weight: 400;\">By leveraging Azure&#8217;s database solutions, businesses can streamline their operations, cutting down on the time and resources traditionally spent on database infrastructure upkeep.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Additionally, Azure grants access to a robust suite of tools and functionalities tailored for efficient storage, management, and in-depth analysis of data within the cloud environment.<\/span><\/p>\n<p><em><span style=\"font-weight: 400;\">Note: For comprehensive details on Azure Database pricing and in-depth guidance on usage, refer to the official Azure Database documentation.<\/span><\/em><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Understanding_Azure_Database_Services_using_Hands-on_Labs\"><\/span><span style=\"font-weight: 400;\">Understanding Azure Database Services using Hands-on Labs<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400;\">To delve into the diverse offerings of Azure Database Services, it&#8217;s essential to set up a lab environment for hands-on exploration. Begin by navigating to the Whizlabs platform. From the Whizlabs main page, select the &#8216;<\/span><strong>hands-on labs<\/strong><span style=\"font-weight: 400;\">&#8216; option.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Once you land on the labs&#8217; interface, employ the search functionality located at the page&#8217;s top. Enter the query &#8220;<a href=\"https:\/\/www.whizlabs.com\/labs\/understanding-azure-database-services\" target=\"_blank\" rel=\"noopener\">Understanding Azure Database Services<\/a>&#8221; to pinpoint the relevant lab session.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">With the lab details displayed, proceed by clicking the &#8216;<strong>start lab<\/strong>&#8216; button positioned at the top-right corner of the lab&#8217;s page. Await a brief moment as the cloud environment initializes, ensuring you&#8217;re set for an immersive Azure experience.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Follow the tasks mentioned in the task details:<\/span><\/p>\n<h4>Task 1: Sign in to Azure Portal<\/h4>\n<p>Navigate to the Azure portal by clicking the Open Console button or using the URL <a href=\"https:\/\/portal.azure.com\/\" target=\"_new\" rel=\"noopener\">https:\/\/portal.azure.com<\/a>.<\/p>\n<p>If automatically logged in with another Azure account, log out, and clear the cache.<\/p>\n<p>Sign in with the provided username and password on the Azure portal.<\/p>\n<p>If login issues persist, click on End lab and restart the lab.<\/p>\n<h4>Task 2: Create a CosmosDB Account with SQL API<\/h4>\n<p>In the Azure portal, select +Create a resource.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-93265\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/cosmosdb-2.webp\" alt=\"cosmosdb\" width=\"726\" height=\"355\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/cosmosdb-2.webp 726w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/cosmosdb-2-300x147.webp 300w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/cosmosdb-2-150x73.webp 150w\" sizes=\"(max-width: 726px) 100vw, 726px\" \/><\/p>\n<p>Choose Databases &gt; Azure CosmosDB in the Create a Resource section.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-93266\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/azdb1-1.webp\" alt=\"azdb1\" width=\"814\" height=\"574\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/azdb1-1.webp 814w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/azdb1-1-300x212.webp 300w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/azdb1-1-768x542.webp 768w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/azdb1-1-150x106.webp 150w\" sizes=\"(max-width: 814px) 100vw, 814px\" \/><\/p>\n<p>On the Select API page, pick Azure Cosmos DB for NoSQL and click Create.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-93267\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/azdb2-1.webp\" alt=\"azdb2\" width=\"919\" height=\"474\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/azdb2-1.webp 919w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/azdb2-1-300x155.webp 300w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/azdb2-1-768x396.webp 768w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/azdb2-1-150x77.webp 150w\" sizes=\"(max-width: 919px) 100vw, 919px\" \/><\/p>\n<p>On the Basics tab, provide details: <strong>Resource group, Account Name, Capacity mode, and Location.<\/strong><\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-93269\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/azdb3-1.webp\" alt=\"azdb3\" width=\"881\" height=\"450\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/azdb3-1.webp 881w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/azdb3-1-300x153.webp 300w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/azdb3-1-768x392.webp 768w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/azdb3-1-150x77.webp 150w\" sizes=\"(max-width: 881px) 100vw, 881px\" \/><\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-93268\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/azdb4-1.webp\" alt=\"\" width=\"953\" height=\"352\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/azdb4-1.webp 953w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/azdb4-1-300x111.webp 300w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/azdb4-1-768x284.webp 768w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/azdb4-1-150x55.webp 150w\" sizes=\"(max-width: 953px) 100vw, 953px\" \/><\/p>\n<p>In the Data Explorer, click +New Container and enter details for the container.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-93270\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/azdb5-1.webp\" alt=\"azdb5\" width=\"487\" height=\"805\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/azdb5-1.webp 487w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/azdb5-1-181x300.webp 181w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/azdb5-1-150x248.webp 150w\" sizes=\"(max-width: 487px) 100vw, 487px\" \/><\/p>\n<p>Click OK.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-93273\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/azdb6-2.webp\" alt=\"azdb6\" width=\"750\" height=\"547\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/azdb6-2.webp 750w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/azdb6-2-300x219.webp 300w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/azdb6-2-150x109.webp 150w\" sizes=\"(max-width: 750px) 100vw, 750px\" \/><\/p>\n<p>In the Items section, click +New Item and add JSON documents.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-93274\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/azdb7-2.webp\" alt=\"azdb7\" width=\"1338\" height=\"591\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/azdb7-2.webp 1338w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/azdb7-2-300x133.webp 300w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/azdb7-2-1024x452.webp 1024w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/azdb7-2-768x339.webp 768w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/azdb7-2-150x66.webp 150w\" sizes=\"(max-width: 1338px) 100vw, 1338px\" \/><\/p>\n<p>Execute queries in the New SQL query section.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-93275\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/azdb8-1.webp\" alt=\"azdb8\" width=\"1466\" height=\"163\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/azdb8-1.webp 1466w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/azdb8-1-300x33.webp 300w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/azdb8-1-1024x114.webp 1024w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/azdb8-1-768x85.webp 768w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/azdb8-1-150x17.webp 150w\" sizes=\"(max-width: 1466px) 100vw, 1466px\" \/><\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-93276\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/azdb9-1.webp\" alt=\"azdb9\" width=\"796\" height=\"297\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/azdb9-1.webp 796w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/azdb9-1-300x112.webp 300w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/azdb9-1-768x287.webp 768w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/azdb9-1-150x56.webp 150w\" sizes=\"(max-width: 796px) 100vw, 796px\" \/><\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-93277\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/azdb11-1.webp\" alt=\"azdb11\" width=\"944\" height=\"713\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/azdb11-1.webp 944w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/azdb11-1-300x227.webp 300w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/azdb11-1-768x580.webp 768w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/azdb11-1-150x113.webp 150w\" sizes=\"(max-width: 944px) 100vw, 944px\" \/><\/p>\n<div class=\"react-scroll-to-bottom--css-xinyi-1n7m0yu\">\n<div class=\"flex flex-col pb-9 text-sm\">\n<div class=\"w-full text-token-text-primary sm:AIPRM__conversation__response\" data-testid=\"conversation-turn-9\">\n<div class=\"px-4 py-2 justify-center text-base md:gap-6 m-auto\">\n<div class=\"flex flex-1 text-base mx-auto gap-3 md:px-5 lg:px-1 xl:px-5 md:max-w-3xl lg:max-w-[40rem] xl:max-w-[48rem] group final-completion\">\n<div class=\"relative flex w-full flex-col lg:w-[calc(100%-115px)] agent-turn\">\n<div class=\"flex-col gap-1 md:gap-3\">\n<div class=\"flex flex-grow flex-col max-w-full\">\n<div class=\"min-h-[20px] text-message flex flex-col items-start gap-3 whitespace-pre-wrap break-words [.text-message+&amp;]:mt-5 overflow-x-auto\" data-message-author-role=\"assistant\" data-message-id=\"9b07fcfc-452f-4a8a-8fc4-538f38a78ebe\">\n<div class=\"markdown prose w-full break-words dark:prose-invert light AIPRM__conversation__response\">\n<p>This is the process for interacting with CosmosDB. There are various APIs available for working with CosmosDB, offering flexibility and versatility based on your specific requirements.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<h4>Task 3: Create Azure Database for MySQL<\/h4>\n<p>In the Azure portal, select +Create a resource.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-93279\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/azmysql.webp\" alt=\"azmysql\" width=\"754\" height=\"381\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/azmysql.webp 754w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/azmysql-300x152.webp 300w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/azmysql-150x76.webp 150w\" sizes=\"(max-width: 754px) 100vw, 754px\" \/><\/p>\n<p>Choose Databases &gt; Azure Database for MySQL.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-93280\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/azmysql1.webp\" alt=\"azmysql1\" width=\"918\" height=\"718\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/azmysql1.webp 918w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/azmysql1-300x235.webp 300w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/azmysql1-768x601.webp 768w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/azmysql1-150x117.webp 150w\" sizes=\"(max-width: 918px) 100vw, 918px\" \/><\/p>\n<p>On the deployment option page, select Flexible server and click Create.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-93281\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/azmysql2.webp\" alt=\"azmysql2\" width=\"932\" height=\"492\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/azmysql2.webp 932w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/azmysql2-300x158.webp 300w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/azmysql2-768x405.webp 768w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/azmysql2-150x79.webp 150w\" sizes=\"(max-width: 932px) 100vw, 932px\" \/><\/p>\n<p>On the Basics tab, provide details:<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-93282\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/azmysql3.webp\" alt=\"azmysql3\" width=\"933\" height=\"726\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/azmysql3.webp 933w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/azmysql3-300x233.webp 300w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/azmysql3-768x598.webp 768w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/azmysql3-150x117.webp 150w\" sizes=\"(max-width: 933px) 100vw, 933px\" \/><\/p>\n<p>On the Networking tab, select Public access and add firewall rules.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-93283\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/azmysql4.webp\" alt=\"azmysql4\" width=\"950\" height=\"671\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/azmysql4.webp 950w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/azmysql4-300x212.webp 300w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/azmysql4-768x542.webp 768w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/azmysql4-150x106.webp 150w\" sizes=\"(max-width: 950px) 100vw, 950px\" \/><\/p>\n<p>Select Review + Create and then Create.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-93285\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/azmysql5.webp\" alt=\"azmysql5\" width=\"945\" height=\"281\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/azmysql5.webp 945w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/azmysql5-300x89.webp 300w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/azmysql5-768x228.webp 768w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/azmysql5-150x45.webp 150w\" sizes=\"(max-width: 945px) 100vw, 945px\" \/><\/p>\n<p>Download and install MySQL Workbench.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-93306\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/wk1.webp\" alt=\"wk1\" width=\"1146\" height=\"513\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/wk1.webp 1146w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/wk1-300x134.webp 300w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/wk1-1024x458.webp 1024w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/wk1-768x344.webp 768w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/wk1-150x67.webp 150w\" sizes=\"(max-width: 1146px) 100vw, 1146px\" \/><\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-93307\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/wk2.webp\" alt=\"wk2\" width=\"1126\" height=\"663\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/wk2.webp 1126w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/wk2-300x177.webp 300w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/wk2-1024x603.webp 1024w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/wk2-768x452.webp 768w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/wk2-150x88.webp 150w\" sizes=\"(max-width: 1126px) 100vw, 1126px\" \/><\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-93308\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/wk3.webp\" alt=\"wk3\" width=\"1139\" height=\"784\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/wk3.webp 1139w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/wk3-300x206.webp 300w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/wk3-1024x705.webp 1024w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/wk3-768x529.webp 768w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/wk3-150x103.webp 150w\" sizes=\"(max-width: 1139px) 100vw, 1139px\" \/><\/p>\n<p>Once downloaded, install it.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-93309\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/wk4.webp\" alt=\"wk4\" width=\"1146\" height=\"599\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/wk4.webp 1146w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/wk4-300x157.webp 300w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/wk4-1024x535.webp 1024w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/wk4-768x401.webp 768w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/wk4-150x78.webp 150w\" sizes=\"(max-width: 1146px) 100vw, 1146px\" \/><\/p>\n<p>Configure a new connection in MySQL Workbench using Azure portal details.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-93310\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/wk5.webp\" alt=\"wk5\" width=\"580\" height=\"195\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/wk5.webp 580w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/wk5-300x101.webp 300w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/wk5-150x50.webp 150w\" sizes=\"(max-width: 580px) 100vw, 580px\" \/><\/p>\n<p>Open the &#8220;Setup New Connection&#8221; dialog box and enter the following information:<\/p>\n<ul>\n<li><strong>Connection name:<\/strong> Enter &#8220;demo connection.&#8221;<\/li>\n<li><strong>Hostname:<\/strong> Copy the Server name of the MySQL database server from the Azure portal and paste it here.<\/li>\n<li><strong>Username:<\/strong> Copy the Server admin login name of the MySQL database server from the Azure portal and paste it here.<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-93311\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/wk6.webp\" alt=\"wk6\" width=\"1126\" height=\"699\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/wk6.webp 1126w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/wk6-300x186.webp 300w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/wk6-1024x636.webp 1024w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/wk6-768x477.webp 768w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/wk6-150x93.webp 150w\" sizes=\"(max-width: 1126px) 100vw, 1126px\" \/><\/p>\n<p>Click on &#8220;Test connection.&#8221;<\/p>\n<p>Enter the password when prompted and click &#8220;Ok.&#8221;<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-93312\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/wk8.webp\" alt=\"wk8\" width=\"603\" height=\"358\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/wk8.webp 603w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/wk8-300x178.webp 300w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/wk8-150x89.webp 150w\" sizes=\"(max-width: 603px) 100vw, 603px\" \/><\/p>\n<p>Click on the newly created connection, and an SQL Editor will open.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-93313\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/wk9.webp\" alt=\"wk9\" width=\"1188\" height=\"564\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/wk9.webp 1188w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/wk9-300x142.webp 300w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/wk9-1024x486.webp 1024w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/wk9-768x365.webp 768w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/wk9-150x71.webp 150w\" sizes=\"(max-width: 1188px) 100vw, 1188px\" \/>You can now proceed to run your queries in the SQL Editor.<\/p>\n<p>Test the connection.<\/p>\n<h4>Task 4: Create Azure Database for PostgreSQL<\/h4>\n<p>In the Azure portal, select +Create a resource.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-93327\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/adb1.webp\" alt=\"\" width=\"891\" height=\"450\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/adb1.webp 891w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/adb1-300x152.webp 300w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/adb1-768x388.webp 768w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/adb1-150x76.webp 150w\" sizes=\"(max-width: 891px) 100vw, 891px\" \/><\/p>\n<p>Choose Databases &gt; Azure Database for PostgreSQL.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-93326\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/adb2.webp\" alt=\"\" width=\"991\" height=\"787\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/adb2.webp 991w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/adb2-300x238.webp 300w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/adb2-768x610.webp 768w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/adb2-150x119.webp 150w\" sizes=\"(max-width: 991px) 100vw, 991px\" \/><\/p>\n<p>On the deployment option page, select Single server and click Create.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-93325\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/adb3.webp\" alt=\"\" width=\"1157\" height=\"552\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/adb3.webp 1157w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/adb3-300x143.webp 300w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/adb3-1024x489.webp 1024w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/adb3-768x366.webp 768w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/adb3-150x72.webp 150w\" sizes=\"(max-width: 1157px) 100vw, 1157px\" \/><\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-93324\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/adb4.webp\" alt=\"\" width=\"765\" height=\"775\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/adb4.webp 765w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/adb4-296x300.webp 296w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/adb4-96x96.webp 96w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/adb4-150x152.webp 150w\" sizes=\"(max-width: 765px) 100vw, 765px\" \/><\/p>\n<p>On the Basics tab, provide details:<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-93323\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/adb5.webp\" alt=\"\" width=\"850\" height=\"439\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/adb5.webp 850w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/adb5-300x155.webp 300w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/adb5-768x397.webp 768w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/adb5-150x77.webp 150w\" sizes=\"(max-width: 850px) 100vw, 850px\" \/><\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-93319\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/abd9.webp\" alt=\"\" width=\"845\" height=\"484\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/abd9.webp 845w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/abd9-300x172.webp 300w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/abd9-768x440.webp 768w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/abd9-150x86.webp 150w\" sizes=\"(max-width: 845px) 100vw, 845px\" \/><\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-93315\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/abd13.webp\" alt=\"abd13\" width=\"869\" height=\"362\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/abd13.webp 869w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/abd13-300x125.webp 300w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/abd13-768x320.webp 768w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/abd13-150x62.webp 150w\" sizes=\"(max-width: 869px) 100vw, 869px\" \/><\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-93322\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/adb6.webp\" alt=\"\" width=\"849\" height=\"301\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/adb6.webp 849w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/adb6-300x106.webp 300w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/adb6-768x272.webp 768w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/adb6-150x53.webp 150w\" sizes=\"(max-width: 849px) 100vw, 849px\" \/><\/p>\n<p>Download and install Azure Data Studio.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-93321\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/adb7.webp\" alt=\"\" width=\"868\" height=\"599\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/adb7.webp 868w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/adb7-300x207.webp 300w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/adb7-768x530.webp 768w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/adb7-150x104.webp 150w\" sizes=\"(max-width: 868px) 100vw, 868px\" \/><\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-93320\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/adb8.webp\" alt=\"\" width=\"854\" height=\"275\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/adb8.webp 854w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/adb8-300x97.webp 300w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/adb8-768x247.webp 768w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/adb8-150x48.webp 150w\" sizes=\"(max-width: 854px) 100vw, 854px\" \/><\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-93318\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/abd10.webp\" alt=\"\" width=\"857\" height=\"131\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/abd10.webp 857w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/abd10-300x46.webp 300w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/abd10-768x117.webp 768w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/abd10-150x23.webp 150w\" sizes=\"(max-width: 857px) 100vw, 857px\" \/><\/p>\n<p>Add client IP in the Connection security of the PostgreSQL server.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-93317\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/abd11.webp\" alt=\"\" width=\"530\" height=\"282\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/abd11.webp 530w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/abd11-300x160.webp 300w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/abd11-150x80.webp 150w\" sizes=\"(max-width: 530px) 100vw, 530px\" \/><\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-93316\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/abd12.webp\" alt=\"\" width=\"840\" height=\"636\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/abd12.webp 840w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/abd12-300x227.webp 300w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/abd12-768x581.webp 768w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/abd12-150x114.webp 150w\" sizes=\"(max-width: 840px) 100vw, 840px\" \/><\/p>\n<p>Connect to the PostgreSQL server using Azure Data Studio.<\/p>\n<h4>Task 5: Validation Test<\/h4>\n<p>After completing the lab steps, click on the Validation button or go to the Lab Validation section. Click Validate My Lab to check the overall status of the completed lab.<\/p>\n<h4>Task 6: Deleting Resources<\/h4>\n<ol>\n<li>In the Azure portal, search for Resource Groups and select it.<\/li>\n<li>Click on the name of the resource group.<\/li>\n<li>Select all resources, click on the three dots, and choose Delete.<\/li>\n<li>Confirm the deletion by typing Delete.<\/li>\n<\/ol>\n<h3><span class=\"ez-toc-section\" id=\"FAQs\"><\/span><span style=\"font-weight: 400;\">FAQs<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><b>What are the different types of Azure databases?<\/b><\/p>\n<p><span style=\"font-weight: 400;\">The Azure databases are classified into the following types:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Azure SQL Database.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Azure Database for MySQL<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Azure Cache for Redis<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Azure Managed Instance for Apache Cassandra<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Azure Database for MariaDB<\/span><\/li>\n<\/ul>\n<p><b>Is Azure database SaaS or PaaS?<\/b><\/p>\n<p><span style=\"font-weight: 400;\">Azure SQL Database is categorized as a Platform-as-a-Service (PaaS) offering within the Azure ecosystem. It provides a managed relational database service, making it easier for users to deploy, manage, and scale their databases without the overhead of traditional infrastructure management.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">In simpler terms, while it&#8217;s a managed service like a Software-as-a-Service (SaaS) offering in that Microsoft handles much of the underlying infrastructure, Azure SQL Database offers a higher degree of flexibility and customization typical of PaaS solutions.<\/span><\/p>\n<p><strong>How to connect to the Azure database?<\/strong><\/p>\n<p>Follow the below steps to connect the Azure database:<\/p>\n<ol>\n<li>Connect to Azure SQL Database<\/li>\n<li>Create a Database<\/li>\n<li>Create a Table<\/li>\n<li>Insert Rows<\/li>\n<li>Query the Table<\/li>\n<li>View Results<\/li>\n<li>Use Query Window Table Verification<\/li>\n<\/ol>\n<div class=\"w-full text-token-text-primary\" data-testid=\"conversation-turn-30\">\n<div class=\"px-4 py-2 justify-center text-base md:gap-6 m-auto\">\n<div class=\"flex flex-1 text-base mx-auto gap-3 md:px-5 lg:px-1 xl:px-5 md:max-w-3xl lg:max-w-[40rem] xl:max-w-[48rem] group\">\n<div class=\"relative flex w-full flex-col lg:w-[calc(100%-115px)]\">\n<div class=\"flex-col gap-1 md:gap-3\">\n<div class=\"flex flex-grow flex-col max-w-full\">\n<div class=\"min-h-[20px] text-message flex flex-col items-start gap-3 whitespace-pre-wrap break-words [.text-message+&amp;]:mt-5 overflow-x-auto\" data-message-author-role=\"user\" data-message-id=\"aaa2a02d-e64d-4746-9fa3-d952a3fd83dc\">\n<div class=\"\"><strong>What are the benefits of Azure database?<\/strong><\/div>\n<\/div>\n<\/div>\n<div class=\"mt-1 flex justify-start gap-3 empty:hidden\">\n<div class=\"text-gray-400 flex self-end lg:self-center justify-center lg:justify-start mt-0 -ml-1 visible\">\n<div class=\"flex items-center gap-1.5 text-xs\">The benefits of using the Azure database such as:<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<ol>\n<li>Scalability<\/li>\n<li>High Availability<\/li>\n<li>Security<\/li>\n<li>Managed Services<\/li>\n<li>Global Reach<\/li>\n<li>Integration with Azure Services<\/li>\n<li>Cost Efficiency<\/li>\n<li>Automatic Patching and Updates<\/li>\n<li>Built-in Intelligence<\/li>\n<\/ol>\n<h3><span class=\"ez-toc-section\" id=\"Conclusion\"><\/span><span style=\"font-weight: 400;\">Conclusion<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400;\">Through a blend of theory and practical exercises, I hope you have gained actionable insights and skills that empower them to harness Azure&#8217;s database capabilities effectively.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">With the knowledge gained from these labs, you&#8217;re well-positioned to navigate and leverage the dynamic landscape of Azure Database Services.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">To play around with the Azure database in controlled live environments, explore the <\/span><a href=\"https:\/\/www.whizlabs.com\/azure-sandbox\/\"><span style=\"font-weight: 400;\">Azure sandboxes<\/span><\/a><span style=\"font-weight: 400;\">.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Azure Database Services is a Microsoft Azure cloud offering comprising managed database solutions such as Azure CosmosDB, Azure SQL Database, and much more to simplify data management. In this blog article, we are going to explore Azure Database Services with the help of our Guided hands-on labs. By going through these hands-on labs, you&#8217;ll be well-equipped to harness the full potential of Azure Database Services, enabling you to architect, deploy, and manage databases with confidence and proficiency. Introduction to Azure Database Azure, developed by Microsoft, stands as a comprehensive cloud platform offering a plethora of services, notably databases. These database [&hellip;]<\/p>\n","protected":false},"author":389,"featured_media":93570,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_uag_custom_page_level_css":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"default","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"set","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[10],"tags":[],"class_list":["post-92986","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-cloud-computing-certifications"],"uagb_featured_image_src":{"full":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/Azure-Database-Services.webp",1280,720,false],"thumbnail":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/Azure-Database-Services-150x150.webp",150,150,true],"medium":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/Azure-Database-Services-300x169.webp",300,169,true],"medium_large":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/Azure-Database-Services-768x432.webp",768,432,true],"large":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/Azure-Database-Services-1024x576.webp",1024,576,true],"1536x1536":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/Azure-Database-Services.webp",1280,720,false],"2048x2048":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/Azure-Database-Services.webp",1280,720,false],"profile_24":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/Azure-Database-Services.webp",24,14,false],"profile_48":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/Azure-Database-Services.webp",48,27,false],"profile_96":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/Azure-Database-Services.webp",96,54,false],"profile_150":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/Azure-Database-Services.webp",150,84,false],"profile_300":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/Azure-Database-Services.webp",300,169,false],"tptn_thumbnail":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/Azure-Database-Services-250x250.webp",250,250,true],"web-stories-poster-portrait":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/Azure-Database-Services-640x720.webp",640,720,true],"web-stories-publisher-logo":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/Azure-Database-Services-96x96.webp",96,96,true],"web-stories-thumbnail":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2024\/02\/Azure-Database-Services-150x84.webp",150,84,true]},"uagb_author_info":{"display_name":"Karthikeyani Velusamy","author_link":"https:\/\/www.whizlabs.com\/blog\/author\/karthikeyani-velusamy\/"},"uagb_comment_info":4,"uagb_excerpt":"Azure Database Services is a Microsoft Azure cloud offering comprising managed database solutions such as Azure CosmosDB, Azure SQL Database, and much more to simplify data management. In this blog article, we are going to explore Azure Database Services with the help of our Guided hands-on labs. By going through these hands-on labs, you&#8217;ll be&hellip;","_links":{"self":[{"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/posts\/92986","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/users\/389"}],"replies":[{"embeddable":true,"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/comments?post=92986"}],"version-history":[{"count":10,"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/posts\/92986\/revisions"}],"predecessor-version":[{"id":93522,"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/posts\/92986\/revisions\/93522"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/media\/93570"}],"wp:attachment":[{"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/media?parent=92986"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/categories?post=92986"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/tags?post=92986"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}