How to Update data on a SQL database on Azure

Learn How to update data in a SQL Database on Azure by running SQL Update statements on the SQL Query editor in Azure.
SQL on Azure for Beginners series
This is the 4th video in the SQL on Azure series.
The series consist of the following videos on the Dida-Do channel:
Step 1 - How to create a SQL database on Azure video:
Creating a SQL database on Azure - YouTube
Step 2 - How to create tables on a SQL database on Azure:
How to create tables for a SQL database on Azure - YouTube
Step 3 – How to insert data into tables on a SQL database on Azure:
How to Insert data into tables on a SQL database on Azure - YouTube
This video Content
Step 4 – How to update data in tables on a SQL database in Azure:
Topics:
 Prerequisites for updating data
 What will we be updating?
 The Update statement – syntax
 The Where clause
 Operators in the Where clause
 Update scripts we will be using
 Logging into Azure and the SQL query editor
 Running our Update statements in the query editor
Why use Azure while learning SQL?
Instead of installing SQL and SSMS (SQL Server Management Studio) on your PC or laptop, create a free subscription on Azure and create your database, tables and do your inserts and updates on Azure. Get ahead by using the latest cloud technologies for your SQL learning journey.
The Exercises in this video
This video is based on the MTA 98-361 Objective 6 study guide and exercises on the Dida-Do Treasure chest for Software Development students. Find all the links you need below.
The music used in this video
Thanks to Ben Cross – For the love of music for the background music. I just love the RONDO for ERHU and DUDUK, so if you like the background music, you can download the full Rondo here: https://bencrossmusic.com/single/42061/rondo-for-erhu-and-duduk
Important links
1. Database Fundamentals study guide
It makes sense to acquire the following study guide, on which the exercises are based, from the Dida-Do Treasure chest for Software Development students: MTA 98-361 Objective 6 study guide -All about SQL for beginners. Here is a discounted link for the study guide: https://gumroad.com/l/MTA98361_Obj6_StudyGuide/MTA98361SQL_3.
You will also find all the scripts you need in in a separate file when you purchase the study guide, as well as a separate Exercises book.
The best way to learn SQL is by doing it. The MTA 98-361 Objective 6 study guide is all about learning SQL by doing:
• Creating a SQL database: Create database statement
• Creating tables on your SQL database: Create table statements with columns and data types.
• Inserting data into tables using SQL Insert statements (This is what this video is about).
• Updating rows by using SQL Update statements.
• Deleting rows by using SQL Delete statements.
• Selecting data from tables using SQL Select statements.
• Creating stored procedures.
• Creating an app in Visual studio and connecting to your SQL database.
• Using ADO.Net to access and update data.
Here is the link to the The MTA 98-361 Objective 6 study guide again: https://gumroad.com/l/MTA98361_Obj6_StudyGuide/MTA98361SQL_3
2. Create a free Azure account: https://azure.microsoft.com/
3. SQL on Azure for Beginners 1 – Create a database with tables and Insert data free product: https://zoniax.gumroad.com/l/SQLonAzure1
Includes: Roadmap, Walkthrough, Exercise book, 3 How-to videos, Copy-and-paste scripts.
4. Copy-and-paste Update scripts for this video: https://docs.google.com/document/d/1fpwYsKP1dFCD3LwggbWlLJQjcRRHd9pM/edit?usp=sharing&ouid=108879693201050292461&rtpof=true&sd=true
5. Dida-Do Treasure chest for Software Development students: https://gumroad.com/zoniax?sort=newest
6. Sonia Cross on Udemy: https://www.udemy.com/user/sonia-cross/
7. MTA 98-361 Software Development Fundamentals C# Exam Prep on Udemy: https://www.udemy.com/course/mta-98-361-software-development-fundamentals-cs-exam-prep/?referralCode=D6483024DBD8757E3022
8. Dida-Do For the love of learning blog: https://www.dida-do.com/
9. Sonia Cross on LinkedIn: https://www.linkedin.com/in/sonia-cross-0674b017/
10. Ben Cross - For the love of music: Visit the site for more free and beautiful music you can use and listen to:
https://bencrossmusic.com/
I hope you find this video valuable in your learning journey!
Please like and subscribe if you want to be notified of upcoming releases.