this week we introduced the database environment and various database architectures. log in to the virtual desktop interface (vdi) and ensure that you have access. reminder: to log into the vdi, use t

Project Description:

this week we introduced the database environment and various database architectures. log in to the virtual desktop interface (vdi) and ensure that you have access. reminder: to log into the vdi, use the document: virtual desktop instructions. microsoft sql server is preloaded into the virtual environment.

open sql server.
create a new database called “lastname” (enter your last name).
create a new table called “student_records.”
add a record with your name and last name.
create a screenshot capturing the database name and table with your information displayed.
name should be mahender reddy kandadi

log in to the vdi and complete the following tasks:

create an sql statement that lists all the rows in the database.
sort the list by last name and by state.
download the file and save it to your computer as a *.csv file.
name the *.csv file last name, first name.csv (insert your last name and first name).
now that you have identified an employee that is no longer with the organization, create a delete statement to remove the employee record for “bob smith”.
create an insert statement that adds a new employee record.
make the new employee record be your “first name and last name”.
write an sql statement that calculates the total number of records in the table.
create a screenshot showing the table with your record added.
Skills Required:
Project Stats: Edited

Price Type: Fixed

Project Budget: $0 to $10
Expired
Total Proposals: 2
1 Current viewersl
38 Total views
Project posted by:

Proposals

Proposals Reputation Price offered
  • 4.5
    1 Jobs 1 Reviews
    $20 in 1 Day
  • 4.8
    175 Jobs 91 Reviews
    $100 in 1 Day