Question 1 :  Introduction to R on DataQuest.comThere are two parts to this assignment:1) Finish the first course Introduction to R on DataQuest.com. The main objective of this short course is to introduce the foundational concepts and the data structures in R. The course is divided into six missions, you are required to finish the below (which are free of cost)as follows:

Introduction to programming in R

Working with Vectors

The assignment is to take screenshots of the completion of the three missions, paste them in a word document and submit.2) Open R-Studio on your computer and start a new script. Now type getwd() in the script and run it. Take the screenshot including the console screen that contains the version number and the working directory. Paste the screenshot in a word document and submit it.

1a) Importance of Programming

Write a short paragraph (< 100 words) on the importance of programming in data analytics. Also, write the advantage of open source language like R over other licensed programming software.

Requirements for Discussion Assignments

Compose a well-developed post (< 100 words) that is comprehensive in answering questions posed on the discussion board

Demonstrate integration of the required reading, other course materials, critical thinking, scholarly or peer-reviewed sources (as applicable), using APA. 

Question 2 :  

Go to this  site(https://www.postgresql.org/download/) to install PostgreSQL and pgadmin.Here is a  video tutorial(https://www.youtube.com/watch?v=JFELFNII60U) 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(https://www.python.org/downloads/)  to install the latest Python distribution. 

Go to this  site(https://www.r-project.org/) to install the R programming language and this  site(https://rstudio.com/products/rstudio/download/) to download the free R Studio development environment.

After watching this  video(https://www.youtube.com/watch?v=J_Clau1bYco), 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(https://www.youtube.com/watch?v=3Zurg16Q4UI) and  here(https://www.youtube.com/watch?v=bOvqYw1SZJg))

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. 

2a)

Using PGAdmin4 create the database sqlda. Then, use the psql command line tool available in the Postgres 12 program folder to restore the database.
Here is the sample text that I used.
c:\Program Files\PostgreSQL\12\bin>psql -U postgres -d sqlda -f “C:\Users\davep\OneDrive\Desktop\data2.dump”
In the cmd window, navigate to the foler where psql.exe resides. You can see above where it resides on my Windows computer after a default installation.
Execute the psql command tool and input these responses to the questions posed as follows:
c:\Program Files\PostgreSQL\12\bin>psql
Server [localhost]: localhost
Database [postgres]: postgres
Port [5432]: 5432
Username [postgres]:postgres
Password for user postgres:
You can list your databases in the command line with \l
You can connect to the sqlda database with \c
Then you can list the database tables with \dt
You can also check in PFAdmin4 for the new database (you may need to refresh).