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
Important links
1. Database Fundamentals study guide
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.
Includes: Roadmap, Walkthrough, Exercise book, 3 How-to videos, Copy-and-paste scripts.
10. Ben Cross - For the love of music: Visit the site for more free and beautiful music you can use and listen to:
I hope you find this video valuable in your learning journey!
Please like and subscribe if you want to be notified of upcoming releases.

[dida-dofortheloveoflearnin]

Thanks a lot for the beautiful music and the assistance with the sound!