Create a BD and make requests for a BD according to the requirements below in SQL Server Management Studio.
Online portal for learning English.
1 . Creation of BD
Create a BD
Create tables
Check the data (LIKE, IN)
Add a calculation column.
Create primary and external keys.
Add a new column.
Remove the created column.
2nd Add/Change data to the BD using INSERT, UPDATE, DELETE
Three Selection of data
a sample from one table with a condition
A sample of several tables.
Examples using the left external combination
- request using the date functions (MONTH, DAY, YEAR)
Request with the group
Online portal for learning English.
1 . Creation of BD
Create a BD
Create tables
Check the data (LIKE, IN)
Add a calculation column.
Create primary and external keys.
Add a new column.
Remove the created column.
2nd Add/Change data to the BD using INSERT, UPDATE, DELETE
Three Selection of data
a sample from one table with a condition
A sample of several tables.
Examples using the left external combination
- request using the date functions (MONTH, DAY, YEAR)
Request with the group