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 Data comes in different forms, each with its own characteristics and challenges. Basically, there are three main categories of data: Structured, Semi-structured and Unstructured Data. In this tutorial, we explore the characteristics and some examples for each kind of data. Structured Data First, let's have a look...
Introduction In this tutorial, we show you step-by-step how to set up a Python virtual environment on your Mac. Why Use a Virtual Environment? A virtual environment allows you to create isolated environments for different Python projects. This helps to avoid conflicts between project dependencies and ensures that each project...
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...