• Post category:StudyBullet-4
  • Reading time:6 mins read


Explore Azure Services, Load Data, Query Data,Create Database.

What you will learn

Learn how to create a free Microsoft Azure Account

How to explore Azure services through azure portal

How to create a synapse workspace

How to launch synapse studio

How to load sample data

How to query data with serverless SQL Pool


Get Instant Notification of New Courses on our Telegram channel.


How to create and SQL Database

Description

The Azure cloud platform is more than 200 products and cloud services designed to help you bring new solutions to life – to solve today’s challenges and create the future. Build, run and manage applications across multiple clouds, on-premises and at the edge, with the tools and frameworks of your choice.

Cloud is everywhere. It has completely changed the way businesses think about IT resources and software solutions. Organizations of every type, size, and industry are using the cloud for a wide variety of use cases. Even individuals like you and me are using cloud and cloud services on a daily basis.

Azure is a cloud computing platform from Microsoft. Initially it was called Windows Azure. Later renamed to Microsoft Azure. It is an ever expanding set of services to help you build solutions to meet your business goals. It offers a wide variety of services. For example, we have

  1. Virtual machines running in the cloud for you to host and run your software.
  2. Storage services to store all sorts of data – relational, non-relational etc.
  3. Software development and deployment services.
  4. Networking and Data analysis services.
  5. Artificial Intelligence, Machine learning, Internet of Things etc. The list goes on.

When we think about moving to a cloud from an on-permise datacenter, 2 immediate things that come to our mind are security and availability.

How secure is my data. If you are thinking, your applications and data are more secure in your own data center than in the cloud, you are almost certainly mistaken. Security and privacy are foundational for Azure. Microsoft is committed to the highest levels of trust, transparency, standards and regulatory compliance. In fact, if you compare Azure with other cloud service providers, it has the most comprehensive set of compliance offerings. As of this recording, Azure has over 90+ compliance offerings – the largest portfolio in the industry.

English
language

Content

Setting up free azure account

Introduction
What is Azure
What is Cloud computing
Benefits of Cloud computing
Why moving to the cloud might be good
Why cloud computing could be cheaper
Creating a free azure account

Microsoft Azure Basics

How to access Azure Services
How to create a synapse workspace
How to open Synapse Studio
Load sample data
Query data with serverless SQL Pool
Create a new SQL Database in Azure
Query Azure SQL Database
Connect and Query Azure Database with SSMS
What is a Database Schema
Insert data into azure database
Update data in azure database
Delete data in azure database