Lab Activity: Relational Databases

Module 2 Lab Activity: Relational Databases

Module 2 is all about relational data. You’ll be looking at how relational databases are managed in Microsoft Azure as well as continue to learn SQL using PostgreSQL and Azure.

Follow the instructions below for this Lab Activity. Once completed, upload the appropriate deliverable(s) to the corresponding assignments submission folder for this activity.

Deliverable:

· Submit five original queries 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 2.

Part 1 – More SQL using PostgreSQL

Instructions:

Sample databases are linked throughout the tutorials for PostgreSQL.

· Complete the PostgreSQL WHERE tutorial: https://www.postgresqltutorial.com/postgresql-where/

· Complete the PostgreSQL LIMIT tutorial: https://www.postgresqltutorial.com/postgresql-limit/

· Complete the PostgreSQL FETCH tutorial: https://www.postgresqltutorial.com/postgresql-fetch/

· Complete the PostgreSQL IN tutorial: https://www.postgresqltutorial.com/postgresql-in/

· Complete the PostgreSQL BETWEEN tutorial: https://www.postgresqltutorial.com/postgresql-between/

· Complete the PostgreSQL LIKE tutorial: https://www.postgresqltutorial.com/postgresql-like/

· Complete the PostgreSQL IS NULL tutorial: https://www.postgresqltutorial.com/postgresql-is-null/

· Complete the PostgreSQL Alias tutorial: https://www.postgresqltutorial.com/postgresql-alias/

Part 2 – Relational Databases with 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 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 Azure relational database services

· Exercise – Use SQL to query Azure to SQL Database