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

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.

The relational database model

With relational database systems, you use tables to store and manage information. This sounds simple but involves quite complex concepts such as normal forms, key relationships, and JOINs. This article will introduce the basics of the relational database model, compare its advantages and disadvantages, and delimit this type of data storage from alternative approaches, like object databases,...

What is the WordPress Maintenance Mode?

  • CMS

When updating a WordPress website, perhaps with a switch to a new theme and the corresponding layout changes, or with an update to core files, you should utilise the WordPress Maintenance Mode. This prevents users from being met with an error message or even a blank page during the maintenance process. The maintenance mode allows you to create a static site that informs readers that the website is...

Create your own WordPress website: It’s that easy!

Do you want to have your own website, but hardly have any programing skills? With a content management system, you can create a homepage for yourself or your company without HTML knowledge. Our WordPress guide will guide you step-by-step through the website making process, from installing and setting up WordPress, to creating content and publishing your material.

Creating an online store with WordPress and WooCommerce: This tutorial shows you how

  • CMS

In order to successfully sell products in the age of mobile internet and digital offers, having a well-functioning online shop is a necessity. But how can you create your own online shop without resorting to expensive help? With WordPress and WooCommerce, you can quickly and easily set up your own web shop. We will show you how to do it with this step by step WooCommerce tutorial.

CMS comparison 2018: The 5 most popular open source systems

  • CMS

Range of functions, ease of use, and technical aspects: If you’re searching for the right content management system (CMS) for your website, many factors must be taken into consideration. Worlds lie between a small blog and a huge company website, but sometimes the same system is behind both. The market for open source solutions of the CMS variety is huge. Among the best known are WordPress, TYPO3,...