Introduction
SQL stands for Structured Question Language, and it’s used to govern the information from databases. Each database incorporates many tables, when the tables are made by ROWS & COLUMNS. The columns are represented as “Fields” and Rows are represented as “Data”.
By studying this text, you’ll find out about CRUD operations within the Azure SQL database.
Conditions for creating SQL Server
-
Azure cloud account
-
Edge or different browsers
-
Secure Web Connection
-
Minimal data of the database
-
Azure SQL server & database
When you have not created SQL server and database in Azure, confer with my earlier articles:
Step 1
Step 2
Go to the database dashboard after which click on the “Set Server Firewall” from the highest of the dashboard.
Step 3
Subsequent, in our firewall settings web page, Click on the “Add Consumer IP” choice. After our consumer IP Deal with is added then click on the “Save” choice.
Step 4
After coming to the database dashboard, click on the “Question editor (preview)” from the left pane.
Step 5
Question editor asks our database credentials to login. Enter your credentials after which click on the “Okay” button.
Step 6
After logging in, you’re within the question editor. We’re performing CRUD operations within the database.
We will do step-by-step operations within the database:
-
Making a desk within the database
-
Inserting values right into a desk
-
Retrieving information from a desk
-
Updating values in desk data
-
Deleting values from desk data
Making a desk in database
Write the under question in QUERY editor after which click on the “Run” button on the high of the question editor. On the backside of the question editor “Question succeeded” message is displayed.
We’re making a desk by following the schema construction utilizing the under question.
| Column Title | Knowledge sort |
| author_id | Int |
| author_name | varchar |
| author_mail | varchar |
| author_mobile | varchar |
- Create desk author_information(author_id Int,author_name varchar(15),author_mail varchar(100),author_mobile varchar(50))
Inserting values into desk
Write the under insert queries within the question editor after which click on the “Run” button. On the backside of the question editor “Question succeeded” message is displayed.
- insert into author_information values(1,‘Naveenkumar’,‘naveen@gmail.com’,‘7904106689’),(2,‘Vijayakumar’,‘vijay@gmail.com’,‘7904106333’),(3,‘Shalini’,‘shalravi@gmail.com’,‘8904106459’)
Retrieving information from desk
Write the under queries to retrieve information from the SQL database. After you write a question then click on the “Run” button to execute. On the backside aspect our retrieved information could be displayed.
- choose * from author_information
Updating Values in Desk Data
Write the under queries to replace information to SQL database. After you write a question, then click on the “Run” button to execute. On the backside aspect our retrieved information could be displayed.
- replace author_information set author_mobile=9943304512 the place author_id=1
- choose * from author_information
Delete Values from Desk Data
Write the under queries to delete information from the SQL database. After you write a question, then click on the “Run” button to execute. On the backside aspect our retrieved information could be displayed.
- delete from author_information the place author_id =1
- choose * from author_information
Abstract
Lastly we efficiently carried out the CRUD operations within the SQL database.
