A brief introduction to PostgreSQL | SQL courses

OBS: download the application please visit www.mrbool.com/player

 

Title: A brief introduction to PostgreSQL

 

Duration: 15:58  min.

 

Summary: The PostgreSQL database server is the most used open-source database used on Linux. This video presents an introduction to this database by means of an explanatory demonstration of how to connect to the Linux, via a SSH client called Putty, and how to start the PostgreSQL server from the bash console of the an Ubuntu Linux distribution. After the service has started, the video shows a demonstration of how to send simple queries to retrieve the data that is stored on this database. Also, during the video the some details of the command-line tool called PostgreSQL Interactive Terminal are presented, such as how to connect, disconnect, finalize commands, change the database context and to create a table. The video ends explaining how to verify the operating system's process to check if the PostgreSQL demon server is up and running.

 

Technologies : PostgreSQL, SSH, Linux

 

Example: How to log in on Linux via a SSH client, start the PostgreSQL demon on Linux, connect to a database and send some queries to return information about the databases and tables via PostgreSQL Interactive Terminal.

 

Keywords: SQL, PostgreSQL, SSH, Linux.