Database

SQL commands
How to use the most important SQL commands
  • Configuration

If you routinely work with databases, you’re probably familiar with some SQL commands: SELECT to query data, CREATE TABLE to define a table, or INSERT INTO to insert data. And, unusually many for a programming language, there are many, many more SQL commands. Find out how and why the most useful SQL commands work.

How to use the most important SQL commands
Samba server: the cross-platform network
Samba Server - The solution for a cross-platform network
  • Configuration

Network administrators are often faced with the challenge of coordinating different operating systems such as Windows or Linux. But with the use of a Samba server, sharing services in a network environment is a piece of cake.

Samba Server - The solution for a cross-platform network
Elasticsearch
Elasticsearch Tutorial - the flexible search engine
  • Configuration

If you work with large amounts of data, you’ll need a powerful search engine. Elasticsearch offers you a full-text search that you can configure so that it is perfectly tailored to your needs. But first you have to understand the principle behind it – what is Elasticsearch?. In this Elasticsearch tutorial we’ll explain the first steps in using the search engine, from installation to creating a...

Elasticsearch Tutorial - the flexible search engine
SQL introduction with examples
How to learn SQL with examples
  • Configuration

If you work in web development or routinely analyze data, you’re probably familiar with SQL. It might be a surprise to hear that the domain-specific, declarative language is most-closely related to the design language CSS. Built on the mathematical theory of “relational algebra”, SQL brings some special features to the table. We’ll show you how the language works using examples.

How to learn SQL with examples
MariaDB vs. MySQL
MariaDB vs. MySQL
  • Technical matters

MySQL is the most used database management system in the world. This open source software has been available for productive use since 1995 and is generally considered a standard solution for users of relational databases. This could change in the near future. MariaDB, a community-developed fork of MySQL is catching up on its predecessor and is consequently becoming an increasingly attractive...

MariaDB vs. MySQL
CMS without database – a useful alternative?
CMS without database: the simple solution for small web projects
  • CMS

Do you know any content management systems without databases? These simple CMS systems are usually free, can be downloaded online, and can often be extended and adjusted to the user’s needs. Despite these advantages, are simple CMS platforms really a serious alternative to the classic CMS giants Drupal, Joomla and Typo3, which are linked to databases such as MySQL or MariaDB?

CMS without database: the simple solution for small web projects
Best cloud storage providers
The best cloud storage providers – an overview of the best online storage
  • Tools

Storing files online on a cloud platform has become part of everyday life for many people. Storing files with online storage providers takes the load off your hard drive and ensures that they are available anytime and from anywhere. But what are the best cloud storage providers on the market? And what differences are there between them? Which one would be best for me?

The best cloud storage providers – an overview of the best online storage
PostgreSQL
PostgreSQL: a closer look at the object-relational database management system
  • Know-how

The PostgreSQL database management system, also known to many as Postgres, has many decades of development behind it. It originally started as a project at Berkeley University in California. Today, the open source database continues to defy solutions from commercial competitors, since the development team is constantly working on its functionality and performance. But what exactly is PostgreSQL?...

PostgreSQL: a closer look at the object-relational database management system
Backing up data
Backing up data: methods and storage media
  • Security

Whether important documents or holiday photos: regular data backups on your PC or smartphone should be part of your digital routine. A regular back up of data is crucial for all companies, especially since more and more processes are being digitalized. Find out what’s important when backing up data, how to perform a data back up, and what the pros and cons of various storage media are.

Backing up data: methods and storage media
WordPress Migration: Tips for server migration
WordPress migration: steps for a successful server migration
  • Blogs

There is much more going on behind WordPress blogs than the average visitor is aware of. In addition to texts, pictures and other graphics, it is primarily the behind-the-scenes aspects like plugins and user settings that make the site what it is. All of these features have to be taken into account when migrating from A to B. Thanks to tools like migration plugins, moving your WordPress blog to a...

WordPress migration: steps for a successful server migration