MIS437 lab activity
Download the attached file.
Module 3 Lab Activity: Joins and Non-Relational Databases
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.
Deliverable:
· Submit five original queries centered around using what you have learned about joins and the results from the queries in a word document. For each query, note the sample database used.
· A print out of your unlocked achievements in Microsoft. These can be found under your Profile > Achievements. This should now include the content from Module 3.
Part 1 – Joins using PostgreSQL
Instructions:
– Complete the PostgreSQL Joins tutorial:
https://www.postgresqltutorial.com/postgresql-joins/
– Complete the PostgreSQL INNER JOIN tutorial:
https://www.postgresqltutorial.com/postgresql-inner-join/
– Complete the PostgreSQL LEFT JOIN tutorial:
https://www.postgresqltutorial.com/postgresql-left-join/
– Complete the PostgreSQL Self-Join tutorial:
https://www.postgresqltutorial.com/postgresql-self-join/
– Complete the PostgreSQL FULL OUTER JOIN tutorial:
https://www.postgresqltutorial.com/postgresql-full-outer-join/
– Complete the PostgreSQL CROSS JOIN tutorial:
https://www.postgresqltutorial.com/postgresql-cross-join/
– Complete the PostgreSQL NATURAL JOIN tutorial:
https://www.postgresqltutorial.com/postgresql-natural-join/
Part 2 – Non-Relational Data Storage with Microsoft Access
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 relational databases.
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: Provision non-relational Azure data services
· Exercise: Upload, download, and query data in a non-relational data store