Lab - Azure SQL Database - Adding data - Resource

The following commands can be used as a reference to the previous chapter

1. The following command can be used to create a table in the SQL database

CREATE TABLE Course
(
   CourseID int,
   CourseName varchar(1000),
   Rating numeric(2,1)
)

2. The following commands can be used to insert data into the table

INSERT INTO Course(CourseID,CourseName,Rating) VALUES(1,'AZ-204 Developing Azure solutions',4.5)

INSERT INTO Course(CourseID,CourseName,Rating) VALUES(2,'AZ-303 Architecting Azure solutions',4.6)

INSERT INTO Course(CourseID,CourseName,Rating) VALUES(3,'DP-203 Azure Data Engineer',4.7)

3. The following command can be used to fetch data from the table

SELECT * FROM Course