Database Administration for Beginners/

...

/

Exercise: Data Manipulation and Querying

Exercise: Data Manipulation and Querying

Practice and test your understanding of data manipulation and querying.

We'll cover the following...

Let’s get some hands-on practice with DML and DQL commands using our OnlineStore database.

Question 1

Given the following structure of the Suppliers table:

Field

Type

SupplierID

int

SupplierName

varchar(50)

Email

varchar(50)

Phone

varchar(15)

Address

varchar(100)

OnTimeDeliveryRate

decimal(5,2)

AvgLeadTime

int

The Suppliers table stores detailed information about suppliers, including their contact details (such as email, phone, and address), as well as performance metrics like on-time delivery rate and average lead time. It helps track and evaluate suppliers involved in providing products to the store.

Insert a new supplier into the Suppliers table.

  • Name: Global Goods Inc.

  • Email: ...