Database management

profilePrettygirl80

n the Week 3 Virtual Lab, you will use MS SQL Server to perform database functions on the AdventureWorks relational database. The functions include creating tables to add to the database. You will add data into the new tables using SQL statements. 

Complete the Week 3 Understanding Core Database Concepts lab exercise: 

  • Post your results of the Screenshot1 - Week 3 INSERT Query and Results in Waypoint.
    • Screenshot1 – Week 3 INSERT Query and Results
    • Click New Query from the menu. Type the following SELECT statement in the new query window. Please note that the asterisks in the SELECT statement denote all the rows and all the columns to be returned in the result set.

      Use AdventureWorks2008
      Go
      SELECT * from Person
      GO 

    • Take a screen shot of your query results. Copy your query statement and add the screenshot of your query results to a MS Word document or PDF for upload.
    • Label Query and Screenshot in your document – Screenshot1 Week 3 INSERT Query and Results.
  • Post your results of the Screenshot2 - Week 3 Table Relations Query and Results in Waypoint. 
    • Screenshot2 – Week 3 Table Relations Query and Results
    • Take a screen shot of your query results. Copy your query statement and add the screenshot of your query results to a MS Word document or PDF for upload.
    • Label Query and Screenshot in your document – Screenshot2 Week 3 Table Relations Query and Results.
  • Post your results of the Screenshot3 - Week 3 Departments Query and Results in Waypoint. 
    • Screenshot3 – Week 3 Departments Query and Results
    • Take a screen shot of your query results. Copy your query statement and add the screenshot of your query results to a MS Word document or PDF for upload.
    • Label Query and Screenshot in your document – Screenshot3 Week 3 Departments Query and Results.
  • Post your results of the Screenshot4 - Week 3 UPDATE Query and Results in Waypoint.
    • Screenshot4 – Week 3 UPDATE Query and Results
    • Take a screen shot of your query results. Copy your query statement and add the screenshot of your query results to a MS Word document or PDF for upload.
    • Label Query and Screenshot in your document – Screenshot4 Week 3 UPDATE Query and Results.
  • Post your results of the Screenshot5 - Week 3 DELETE Query and Results in Waypoint.
    • Screenshot5 – Week 3 DELETE Query and Results
    • Take a screen shot of your query results. Copy your query statement and add the screenshot of your query results to a MS Word document or PDF for upload.
    • Label Query and Screenshot in your document – Screenshot5 Week 3 DELETE Query and Results.
    • 2 years ago
    • 25
    Answer(0)