Why it is absolutely vital to register your .uk domain right now

Cybersquatting, typosquatting or legal battles over domain names – these are the potential risks of not taking advantage of the right to register your...

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...

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 your Sunday football team: if you’re not using WhatsApp, you run the risk of...

Less redundancy thanks to database normalisation

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 normalisation. 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 normalisation, 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...

Social networks: the 5 most common dangers and which actions to take

Social media brings millions of people together from around the world. They chat, send pictures and videos, and share information with each other. Companies like to use these platforms to extend their reach, but the more popular a network is, the more likely it is for dangers to be lurking. Tragedies, PR scandals, or an emptied bank account can be the result. We reveal which social network risks...

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.