As a DevOps Engineer, I build, test and maintain IT infrastructure and CI/ CD pipelines in order to enable efficient Software Development and Deployment.
Introduction In this tutorial, we want to delete an existing database by using a SQL Statement. In order to do this, we use the DROP DATABASE Statement. We have already created a server called DLNerdsServer and a database called dlnerdsacademy. Now, we want to delete the database dlnerdsacademy. SQL Statement...
Introduction In this tutorial, we want to create a database by using a SQL Statement. In order to do this, we use the CREATE DATABASE Statement. We have already created a server called DLNerdsServer. The database should be called dlnerdsacademy. SQL Statement We navigate to the default database of the...
Introduction In this turorial, you will learn how to create a database with the pgAdmin interface. Create Database We have already created a server called DLNerdsServer. In order to create a database, we right-click on the databases node and select Create>Database. Set properties Now, we can set certain...
Introduction In this turorial, you will learn how to create a server with the pgAdmin interface. Register Server First, we right-click on the servers node and select Register > Server. General Configuration Next, we enter a name for the server. We choose DLNerdsServer as the name for the server. We...