LAB Activity: Installing PostgreSQL and Querying Data

Module 1 Lab Activity: 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.

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/

Part 2 – Getting Started with Data Storage in Microsoft Azure

Throughout the readings this week you will find several exercises built in. These will help you learn the Microsoft Azure platform had how it is used for data storage.

Instructions:

· Make sure you are logged into your NLU Microsoft Account when accessing the following modules. NOTE - You are most likely already signed in if you have checked your email through the online portal.

· Work through the following exercises while completing the readings. The readings can be found on D2L Module 1: Activities & Assignments:

· Exercise – Create a storage account using the Azure portal

· Exercise – Create a new app to work with Azure storage

· Exercise – Create an Azure storage account

· Exercise – Add the storage client library to your app

· Exercise – Add Azure Storage configuration to your app

· Exercise – Connect with your Azure Storage configuration

· Exercise – Create Azure storage resources

· Exercise – Configure and initialize the client library

· Exercise – Get blob references

· Exercise – Blob uploads and downloads