Go to VM-Ware link : Https://173.220.192.220 Login information to VM-Ware username: jzuma8795 password: Jz3472619093 BOOK Info: MCSA Guide to Microsoft SQL Server 2012 (Exam 70-462) 1st edition EISBN: 1285821130 EISBN-13: 9781285821139 Authors:Faisal Akkawi Kayed Akkawi Gabriel Schofield Gabriel J Schofield (Chegg.com) to get free access to book. user ID: jaminazuma@outlook.com Password: Jz3472619093 See this : Accessing SQL Class Environment: https://s3.us-east-1.amazonaws.com/blackboard.learn.xythos.prod/598f7c7b2dee3/915572?responsecontent-disposition=inline%3B%20filename%2A%3DUTF8%27%27Accessing%2520Your%2520Server%25282%2529%25281%2529.pdf&response-contenttype=application%2Fpdf&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Date=20181119T051251Z&XAmz-SignedHeaders=host&X-Amz-Expires=21600&X-AmzCredential=AKIAIL7WQYDOOHAZJGWQ%2F20181119%2Fus-east-1%2Fs3%2Faws4_request&X-AmzSignature=13b2a03954a04c5234a607f87a786ef6b6e30afe9e5635152e885a427d6eae47 Your Server: https://s3.us-east-1.amazonaws.com/blackboard.learn.xythos.prod/598f7c7b2dee3/915573?responsecontent-disposition=inline%3B%20filename%2A%3DUTF8%27%27Server%2520Information%25282%2529%25281%2529.pdf&response-contenttype=application%2Fpdf&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Date=20181119T051242Z&XAmz-SignedHeaders=host&X-Amz-Expires=21600&X-AmzCredential=AKIAIL7WQYDOOHAZJGWQ%2F20181119%2Fus-east-1%2Fs3%2Faws4_request&X-AmzSignature=c8d5f7a80929dfbeaa83ebc7882be3af46fe38454d0d237acefc34a5f1097347 Part 1 Assignment 6 Dropbox Read Chapter 5 and do the Hands on Project 5-1 on Page 195. 1. Make sure to follow all steps to insert all the data 2. Place all SQL Queries used to complete the steps on a word document and take screenshots of the results, label the screenshots 3. Make sure to perform these task on your VM Once complete submit your screen shots and descriptions of those screenshots on a word document. Note: Before you do this assignment you need to complete assignment 5 (hands 4-1 on from chapter 4) *It is important to do all the activities in chapter 5 so that you understand all the concepts to complete this assignment. Due 10/14/2018 5:00PM Part 2 Assignment 7 Dropbox Attached Files: • Assignment 7.pdf 301.801 KB)( https://s3.us-east1.amazonaws.com/blackboard.learn.xythos.prod/598f7c7b2dee3/1034733?response-contentdisposition=inline%3B%20filename%2A%3DUTF8%27%27Assignment%25207%25281%2529.pdf&response-content-type=application%2Fpdf&X-AmzAlgorithm=AWS4-HMAC-SHA256&X-Amz-Date=20181119T045951Z&X-Amz-SignedHeaders=host&XAmz-Expires=21600&X-Amz-Credential=AKIAIL7WQYDOOHAZJGWQ%2F20181119%2Fus-east1%2Fs3%2Faws4_request&X-AmzSignature=2cf126d7938aa8c90591989d3c3a03311263b6cb9deb279eafb6aa88a3b73e64 Read Chapter 6 and follow the steps on the attached document 1. Make sure to follow all steps 2. Make sure to perform these task on your VM Once complete submit your screen shots and descriptions of those screenshots on a word document. Note: Before you do this assignment you need to complete assignment 6. Due 10/21/2018 5:00PM Part 3 • Assignment 8: Hands-On Project 8-1 Part 4 Assignment 9 Dropbox Attached Files: • • 1. 2. 3. 4. Assignment 9.pdf (206.423 KB) https://s3.us-east1.amazonaws.com/blackboard.learn.xythos.prod/598f7c7b2dee3/1060626?response-contentdisposition=inline%3B%20filename%2A%3DUTF8%27%27Assignment%25209%25281%2529.pdf&response-content-type=application%2Fpdf&X-AmzAlgorithm=AWS4-HMAC-SHA256&X-Amz-Date=20181119T050441Z&X-Amz-SignedHeaders=host&XAmz-Expires=21600&X-Amz-Credential=AKIAIL7WQYDOOHAZJGWQ%2F20181119%2Fus-east1%2Fs3%2Faws4_request&X-AmzSignature=5e1d64e263b32ffda122917c243e771da79f3937a60c33259647a7eb1df527ab UsCityPopulations.csv (114.863 KB) Read Chapter 9 and then follow the instructions in the Assignment 9 document attached Make sure to follow all steps, the UsCityPopulations.csv file needed is attached. Document your steps on a word document and take screenshots of the results Make sure to perform these task on your VM Due 11/18/2018 5:00PM Part 5 Assignment 10 Dropbox • • • • • Read Chapter 10 and do the case project 10-3: Blue Water Insurance, LLC. Make sure to give detailed answers to each of the 3 items (At least a paragraph for each response to an item). Make sure to add references to your assignment Post your assignment to the Dropbox below. Due 11/25/2018 5:00PM
Purchase answer to see full attachment