How to create tables for a SQL database on Azure

Показать описание

Create tables for a SQL Database on Azure.
Instead of installing SQL and SSMS (SQL Server Management Studio) on your PC or laptop, create a free subscription on Azure, create a SQL database and add tables to your database using SQL scripts and the SQL Query editor on Azure.

Some prerequisite steps to follow before creating your tables (with links):
4. 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.
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 Exercise book.

Learn SQL by doing
The best way to learn SQL is by doing it. The MTA 98-361 Objective 6 study guide - Understanding databases is all about learning by doing:
1. Creating a SQL database: Create database statement
2. Creating tables on your SQL database: Create table statements with columns and data types.
3. Inserting data into tables using SQL Insert statements.
4. Updating rows by using SQL Update statements.
5. Deleting rows by using SQL Delete statements.
6. Selecting data from tables using SQL Select statements.
7. Creating stored procedures.
8. Creating an app in Visual studio and connecting to your SQL database.
9. Using ADO.Net to access and update data.
Here is the link to the The MTA 98-361 Objective 6 study guide again:

Other useful links:

I hope you enjoy this video!
Happy learning and see you soon!
Sonia
PS
A big thank you to Ben Cross for the background music - the track "Be happy!"