Installing PostgreSQL and Querying Data

Follow the instructions below for this Lab Activity. The data you will need to use is linked below. Once completed, upload the appropriate deliverable(s) to the corresponding assignments submission folder for this activity.

 

Don't use plagiarized sources. Get Your Custom Essay on
Installing PostgreSQL and Querying Data
Just from $13/Page
Order Essay

Deliverables:

Compile a Word document with the following screenshots:

· a successful install of PostgreSQL

· a successful load for the dvdrental database

· a successful use of the SELECT DISTINCT command

A print out of your unlocked achievements in Microsoft. These can be found under your Profile > Achievements.

 

Part 1 – Getting started with SQL Using PostgreSQL

 

For the first few modules we will look at building a relational database and learning SQL. These are both important areas of knowledge in the scheme of data warehousing.

 

These tutorials cover how to complete the task using both a terminal shell and a browser-based user interface. You are welcome to work through either version or both.

 

For troubleshooting, please check out the recordings posted for how to work through each tutorial below.

 

Instructions:

· Read about PostgreSQL here: https://www.postgresqltutorial.com/what-is-postgresql/

· Download and install PostgreSQL: https://www.postgresqltutorial.com/install-postgresql/

· Connect to a PostgreSQL Database Server: https://www.postgresqltutorial.com/connect-to-postgresql-database/

· Download the PostgreSQL Sample Database: https://www.postgresqltutorial.com/postgresql-sample-database/

· Load PostgreSQL Sample Database: https://www.postgresqltutorial.com/load-postgresql-sample-database/

· Complete the PostgreSQL SELECT tutorial: https://www.postgresqltutorial.com/postgresql-select/

· Complete the PostgreSQL ORDER BY tutorial: https://www.postgresqltutorial.com/postgresql-order-by/

· Complete the PostgreSQL SELECT DISTINCT tutorial: https://www.postgresqltutorial.com/postgresql-select-distinct/

 

 

ORDER NOW »»

and taste our undisputed quality.