dataanalytics

 
Attached Files:
 data2.zip   (8.919 MB)  Restoring_Postgres.txt   (996 B)Go to this  site to install PostgreSQL and pgadmin.
Here is a video tutorial on how to install Postgres on the Mac.
Extract the data.dump file from the attached data.zip file and use the psql command to create the sqlda database (see attached file)
Go to this site to install the latest Python distribution. 
Go to this site to install the R programming language and this site to download the free R Studio development environment.
After watching this video, install Git and Github. 
Submit one document with five screen shots from your computer. Include enough of the screen so the viewer can see that the image is of your computer.
1. sqlda tables in pgadmin
2 use l to show a list of your PostgreSQL databases
3. An Idle page with a hello World script (tutorial here and here)
4. Github
5. R Studio
Please make sure that your images are large enough and high enough resolution for the reader to see the text in your queries and the results. 
Please note that all code assignments must be submitted as a screenshot with a slice of your desktop showing the timestamp.If the time and date are not visible, you will be graded 0.