PL00, PostgreSQL

Back to the previous page ｜page management ｜DB-Engines Ranking
List of posts to read before reading this article

• post1
• post2
• post3

Contents

• Installation
• pgAdmin4
• SQL(Structured Query Language)
• Data Pre-processing
  • ER Model
  • Example : Movie Lens
• DB Design & Modeling & Architecture
  • Enterprise Data
  • Information Architecture
  • Interaction Architecture
  • Data Architecture
  • Data Modeling
• Application

Installation

• postgresql 1 or postgresql 2
• dbeaver

pgAdmin4

$ sudo apt-get install build-essential libssl-dev libffi-dev libgmp3-dev virtualenv libpq-dev python3-pip python3-dev
$ wget https://ftp.postgresql.org/pub/pgadmin/pgadmin4/v2.1/pip/pgadmin4-2.1-py2.py3-none-any.whl
$ pip3 install pgadmin4-2.1-py2.py3-none-any.whl
$ python3 /usr/local/lib/python{Version}/dist-packages/pgadmin4/pgAdmin4.py

SQL(Structured Query Language)

Data Pre-processing

ER Model

Example : Movie Lens

DB Design & Modeling & Architecture

Enterprise Data

Information Architecture

Interaction Architecture

Data Architecture

Data Modeling

Application

List of posts followed by this article

• post1
• post2
• post3

Reference

• 유닉스와 리눅스, 명령어 사전
• post3

<details markdown="1">
<summary class='jb-small' style="color:red">OUTPUT</summary>
<hr class='division3_1'>
<hr class='division3_1'>
</details>