Answer Happy

Use this lab guide to store your answers to each question. Be sure to include all T-SQL unless otherwise specified.
You should save all of your T-SQL code on your vm for futurereference.
Part1
Restore AdventureWorks2012 Database with the SSMS – no T-SQLrequired.
Part2
1. Create a listing of all tables in the AdventureWorks2012database
a. Note the query & show how you would save the results
2. Create a listing of all the columns in just theSales.Currency table
a. What is the datatype for each column?
b. Show schema, table, character type, and length of eachdatatype
3. Create a listing of all views in the database usingT-SQL.
a. provide the query:
Part3
1. Locate the table where all Employee names are stored
2. Locate the table where all Employee usernames are stored
3. Locate the table where all Employee email addresses arestored
4. Locate the table where the street addresses for employees arestored
5. Locate the table where employee phone numbers are stored
a. Figure out how to determine the phone type Cell, Home, orWork
6. Create a query that will show all employees by loginID,jobTitle, name, and email address
7. Create a query that shows all employees as per step6 + allother people who are not employees
8. Locate the CEO and:
9. Locate all Production Technician jobtitles.
Part4
Part5
* Be prepared to show the contents of your view and how yourview works
Part6
Part 7