sphong

Assistant professor Department of Molecular Biology Jeonbuk National University

Seungpyo Hong

PostgreSQL

PostgreSQL is an open source database management software widely used in scientific researches. This post describe basic usage of PostgreSQL. This includes how to install PostgreSQL in Ubuntu (linux) system, create a user and a database, and use Python (psycopg2) interface. 1. Installation Installation in Ubuntu Administrator account PostgreSQL installation create a administrator account, postgres.

PostgreSQL Read More »

SQL – Language for Database managmeent

Introduction Structured Query Language (SQL) is a standardized language designed for three key database operations: (1) defining database structures, (2) manipulating data, and (3) retrieving data from databases. SQL facilitates interaction with Database Management Systems (DBMS), which are responsible for data storage, management, and retrieval. These systems, such as MySQL, Oracle, and Microsoft SQL Server,

SQL – Language for Database managmeent Read More »

Scroll to Top