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




Create and perform CRUD Operations on Azure SQL Database

What you will learn

 

Provision Azure SQL Database

 

Query Azure SQL Database

 

Insert Data into Azure SQL Database

 

Update Data in Azure SQL Database

 

Delete Data from Azure SQL Database

 

Connect Azure SQL to SSMS

Description

Microsoft Azure SQL Database is a managed cloud database provided as part of Microsoft Azure. A cloud database is a database that runs on a cloud computing platform, and access to it is provided as a service. Managed database services take care of scalability, backup, and high availability of the database.

 

Azure SQL Database is an intelligent, scalable, relational database service built for the cloud. Optimize performance and durability with automated, AI-driven features that are always up to date. Focus on building new applications without worrying about storage size or resource management with serverless compute and Hyperscale storage options that automatically scale resources on demand.


Get Instant Notification of New Courses on our Telegram channel.


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.

In this course we will perform some CRUD Operations on and Azure SQL Database.

CRUD is an acronym that stands for CREATE, READ, UPDATE, and DELETE. In SQL Server, CRUD is represented by 4 operations performed on the selected data against a specific SQL database: CREATE refers to inserting columns and values into the table. READ refers to retrieving data from the table.

 

 

English
language

Content

Azure SQL Database Setup

Introduction
What is Azure
What is Azure SQL
Creating Azure Account
Accessing Azure Services
Creating database on Azure Portal
Query SQL Database on Azure Portal

Connecting Azure SQL Database to SSMS

Installing SSMS
Connecting to Azure SQL Database
Inserting Data into Azure SQL Database
Updating Data into Azure SQL Database
Deleting Data into Azure SQL Database