Deepfakes: the next generation of counterfeits

Thanks to deepfakes, the internet is experiencing a new generation of counterfeits: they enable realistic video manipulation with little effort...

General Data Protection Regulation: new laws from 2018

On 25 May 2018 a new European law on data protection will take effect. However, many companies and website operators are unprepared for the new...

How to create the perfect out of office message

The out of office message is a crucial part of email communication in the workplace. If you don’t have access to your email, your contacts will want...

The best WhatsApp alternatives

Invitations to dinner parties; updates about work; an away day with the college football team: if you’re not using WhatsApp, you run the risk of...

Less redundancy thanks to database normalization

Redundancies occur when various details are combined in a single database table. These redundancies use up storage capacity and prevent efficient data processing. The relational database model offers strategies for splitting datasets among several linked tables, in a process called database normalization. Find out what it’s all about with practical examples.

SQL OUTER JOIN

OUTER JOINs are queries that take place across several database tables. There are LEFT OUTER JOINs, RIGHT OUTER JOINs and FULL OUTER JOINs. Each of these JOIN types has a larger result set than the INNER JOIN. But what exactly is the difference between the individual types? Here, we will distinguish OUTER JOINs from INNER JOINs, compare the different subtypes of OUTER JOINs and explain how they...

INNER JOIN: definition and application

The INNER JOIN is the most important JOIN type in the relational database model. If you want to query database tables in a group, you would usually use INNER JOINs based on equality relationships between primary and foreign keys. We will show you how to use INNER JOINs in practice, delineate the JOIN type from OUTER JOINs, and also deal with the different subtypes of INNER JOINs.

SQL JOIN – queries across multiple data tables

A major strength of the relational database model is that information is stored in separate database tables structured according to semantic relationships. This concept, known as normalization, is the basis for data storage that is as redundancy-free as possible, but requires a mechanism with which data from different tables can be merged for queries. The different JOIN types provide users with...

In-memory databases: the storage of big data

In-memory databases enable big data to be analyzed and made available in real time. The quick access speeds are made possible by storing the data on the working memory – hence the name in-memory database. Traditional databases, on the other hand, are based on the method of storing data on the hard disk. How do in-memory databases differ from traditional database systems? And what are the go-to...

UML - a graphical-type modeling language

If you need to run object-oriented programming, to represent a system clearly, and also make it accessible to external specialists, you may find the Universal Modeling Language to be ideal. UML is a modeling language, but has many other possible uses. Since the introduction of UML 2.0, UML diagrams are also suited to the graphical representation of non-computer-based concepts, such as use case...

30 Excel shortcuts to speed up your work

Excel shortcuts enable you to carry out your work a lot faster, but you first have to learn them. We present you with 30 useful Excel key combinations that faciliate your daily work. From navigation, to inserting cells, to calculating totals. If there isn’t already a shortcut for a function you regularly use, you can easily create your own Excel shortcuts.

Crowdfunding

Crowdfunding is a way of raising funds for a project using an online campaign. It’s a popular way of financing, especially for private individuals and startups. Usually private individuals are addressed directly. Four main crowdfunding models have been established, which differ depending on the rewards you promise your donors in return. In our article, you will also learn about what makes a good...

Webinar: definition, basics, and possible uses

The internet and World Wide Web have brought humanity closer together – it has never been easier to share information, experiences, and memories than it is today. More and more often, the web also serves as a platform for further education. So-called webinars - i.e. online seminars – are replacing classic face-to-face lectures. Companies and teachers now communicate knowledge online instead of in...

All you need to know: what is a hostname?

A computer’s unique name on a network is the hostname, site name or computer name. The hostname is part of the fully qualified domain name, which can be used (for example) to find and access websites on the internet. Here you’ll learn what a hostname looks like, and we’ll show you various ways to determine the hostname using an IP address or how to change it.