BIS 445 Business Intelligence and Data Analysis Week 1 Lab 1A Solution – Homeworkmade

DOWNLOAD: BIS 445 Business Intelligence and Data Analysis Week 1 Lab 1A Solution – Homeworkmade

BIS 445 Week 1 Lab 1A

• Lab 1A Student Answer Sheet  

• Student Name: Name
• Using Lab 1A answer the questions and provide copies of your SQL Statements and/or results for each Section listed below
•  
• Part A: Import comma delimited text file
• a.What does Edit Mappings do?
•  
• Part B: Review your imported table data
• Part C: Create a SQL query to insert a record into your CustomerData table
• Part D: Create SQL queries to delete records by certain criteria
• Part E: Create queries to modify your CustomerData table records