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.