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 the fast-paced world of software development, efficiency and consistency are key. Docker, a powerful containerization platform, has revolutionized the way we build, ship, and run applications. In this tutorial, we show you how to get started with Docker. Step 1: Install Docker (if not already installed) First of...
Introduction PostgreSQL is one of the most widely used database management systems. One of the easiest ways to use PostgreSQL on macOS is the Postgres.app. Postgres.app provides a simple interface for setting up a server and a command-line interface (psql) for interacting with databases via the terminal. In...
Introduction In the landscape of software development, Docker has emerged as a game changer, offering a streamlined approach to building, shipping, and running applications. In this blog post, we explain the fundamental concept of Docker focusing on Dockerfiles, Docker images, and containers. What is Docker? Docker is an open-source platform...
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...