
Database Development and Management with SQL ◾ 153
TASK 2: POPULATE CLASS_REGISTRATION DATABASE
Follow the steps below to populate the Class_Registration database with SQL statements in
Windows Azure SQL Database:
1. Assume that you have logged on to the Windows Azure Management Portal. Select
SQL DATABASES and the Class_Registration database. Click MANAGE to log on
to the SQL Database portal as shown in Figure 4.16.
2. Once the SQL Database portal is opened, click New Query. Enter the following SQL
statements in the New Query pane. en, click Run.
— - inserting records into BUILDING
INSERT INTO BUILDING (BuildingId, BuildingName)
VALUES(1, 'East') ...