dw8547
commented
8 years ago A powerful open source RDMS (Relational Database Management System): PostgreSQL.
Instructions for installing from the official Ubuntu documentation: https://help.ubuntu.com/community/PostgreSQL
On 14.04:
Add the repository:
sudo nano /etc/apt/sources.list.d/pgdg.list
Add this line:
deb http://apt.postgresql.org/pub/repos/apt/ trusty-pgdg main
Then run in the shell:
wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
sudo apt-get update
You need:
postgresql-9.4 - object-relational SQL database, version 9.4 server postgresql-client-9.4 - front-end programs for PostgreSQL 9.4 postgresql-contrib-9.4 - additional facilities for PostgreSQL postgresql-doc-9.4 - documentation for the PostgreSQL database management system
sudo apt-get install postgresql-9.4 etc.
These are also very useful packages to have:
autopostgresqlbackup - automated tool to make periodic backups of PostgreSQL databases postgresql-comparator - efficient PostgreSQL table content comparison and synchronization
A series of really good & informative videos on databases & data modelling, approximately 8 h in total (7h 51 min 26 sec):
Database Lesson #1 of 8 - Introduction to Databases (38:42) Database Lesson #2 of 8 - The Relational Model (47:03) Database Lesson #3 of 8 - The Structured Query Language (SQL) (1:18:24) Database Lesson #4 of 8 - Data Modeling and the ER Model (58:15) Database Lesson #5 of 8 - Database Design (50:10) Database Lesson #6 of 8 - Database Administration (1:37:02) Database Lesson #7 of 8 - Database Indexes (38:38) Database Lesson #8 of 8 - Big Data, Data Warehouses, and Business Intelligence Systems (1:03:12)