---
title: Database Systems Pre-Lab 1
---
<h1 style='border: none'><center>Database Systems Pre-Lab 1</center></h1>
<h2 style='border: none'><center>DBeaver Enterprise & PostgreSQL</center></h2>
<h5><center>The Islamic University of Gaza<br>Engineering Faculty<br>Department of Computer Engineering</center></h5>
<h6>Authors: Usama R. Al Zayan & Rasha E. Kahil<span style="float:right">2023/02/06</span></h6>

---

## Expecteed outcomes
1. Getting esstential tools installed and successfully working.
2. If you miss this lab, you shall do the steps at home and do it by yourself. It is your responsiblity.
3. Next labs will assume that your machine/laptop is ready to apply Database tasks.

## Lab 1: Time and Plan

| Tasks | Timing |
| -------- | -------- |
| Task 1 | 20 min |
| Task 2 | 10 min |
| Task 3 | 10 min |
| Task 4 | 15 min |
| Task 5 | 20 min |

## Introduction

<p style="text-align:justify">
In this Pre-lab, we are going to talk about how to download DBeaver EE and PostgreSQL, then how to get your <B>DBeaver Enterprise Academic License</B>. You can skip these steps and download
<a href="https://dbeaver.io/">Community Edition</a> (Free Edition) if you like.</p>

## Student’s To Do list:

1. Download DBeaver installer.
2. Download PostgreSQL installer.
3. Request your DBeaver Academic License.
4. Bring your laptop with you next lab to handle and fix any expected problem.

## What is DBeaver Enterprise

<p style="text-align:justify"> <B>DBeaver Enterprise</B> is a comprehensive database management tool with advanced features for database administration and maintenance, SQL editing and execution, and leading cloud providers integration.</p>

For more information, please visit [DBeaver Enterprise](https://dbeaver.com/dbeaver-enterprise/).

## What is PostgreSQL

<p style="text-align:justify"> <B>PostgreSQL</B> is a powerful, open source object-relational database system with over 35 years of active development that has earned a strong reputation for reliability, feature robustness, and performance.</p>

For more information, please visit [PostgreSQL about](https://www.postgresql.org/about/).

## How to download PostgreSQL installer

* Go to [Community DL Page](https://www.enterprisedb.com/downloads/postgres-postgresql-downloads), and Choose version higher than `11.18` because these versions of PostgreSQL are no longer supported.


## How to Install PostgreSQL

1. Run `postgresql-15.1-1-windows-x64.exe` installer, then click `Next>`.


2. Click `Next>`.


3. (optional) Unselect `PgAdmin 4` and `Stack Builder`, we wil use DBeaver instead, then click `Next>`.


4. Click `Next>`


5. Enter the password, the click `Next>`. (don't forget the password)


6. Use the default Port and Click `Next>`.


7. Select the default Location. (You can choose a specific location if your C drive is full)


8. Click `Next>`.


9. Click `Next>` and wait for the installation to finish.


10. Unselect `Stack Builder` If you download it and click `Finish`.


11. To verify the installation open the `SQL Shell (psql)`.


12. Press `Enter` 4 times. (default server, database, port and username)


13. Enter the password that you entered during installing the PostgreSQL.


14. Enter the command `SELECT version();` you will see the result as follows.


## How to get your DBeaver Academic License

1. Go to the [DBeaver PRO | One tool for all data sources](https://dbeaver.com/) website, and `Sign up` using your academic email `@students.iugaza.edu.ps`.


2. Click `Academic License`.


3. Select `Enterprise` Edition, then fill your info, then click `request it`.


4. Open `Profile` page and click on `License ID`.


5. Click `DOWNLOAD LICENSE`. License key starts with `-- DBeaver EE LICENSE -` and ends with `==`

Note: Keep track of your request status or email, License Keys will be sent to you within 3 days.


## How to download DBeaver EE installer

* Go to [Download DBeaver Edition](https://dbeaver.com/download/), and Download DBeaver EE.


## Import DBeaver license
* Run DBeaver, the click `Import License`
* Paste your key here. License key starts with `-- DBeaver EE LICENSE -` and ends with `==`


###### tags: `Database Systems` `Pre-Lab` `IUG` `Computer Engineering`

<center>End Of Pre-Lab 1</center>