Question

1. Start SQL Server.
   Remember, as described in the Required Survey: How will you access SQL Server?, you can either access SQL Server via room N252 or install in on your own personal computer.
   
2. Locate the AdventureWorksLT database. This can be any version of the "LT" database, e.g. AdventureWorkLT2012, AdventureWorksLT2017, or even simply AdventureWorksLT - all have the same data.
   
3. Start a new query and write a SQL statement that displays all of the data from the Customer table.
   Yikes! How do you know how to do this? Demonstrations of all concepts are available on our Watch these VIDEOS page.
   
4. Take a screen shot that shows SQL Server and your new query, including your code and the query results.
   
5. Save the screen shot image as a file or paste the screen shot into the Word document. You may exit SQL Server without saving the query.
   
6. Return to this assignment page, attach your screen shot file, and submit.

Answer 1

Hi,

To install SQL Server on your own personal computer, your computer should meet the system requirements of the version of SQL Server. If your PC meets all the requirements, you can install
SQL server on your PC.

-------------------------

To display all the data from the Customer table, we can use the below SQL query.

SELECT *
FROM Sales.Customer ;

------------------------

Let me know if you need more help on this.

Hope this helps.