Database

SQL JOIN

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

SQL OUTER JOIN

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

Set up ownCloud with Raspberry Pi

Creating a Raspberry Pi cloud server with owncloud

With ownCloud software, your Raspberry Pi can be used as a private cloud, performing the same kind of tasks as clouds from major providers such as Google, Amazon, and Dropbox. Cost-effectiveness is just one of many the benefits of creating your own personal cloud; another is the privacy and security of your data. This step-by-step Raspberry Pi cloud tutorial explains how to set up ownCloud.

What are quotas?

Quotas – storage for web space and e-mail

Did you encounter the word 'quota' from your web space provider or as part of mail hosting and wonder what is it? When does this storage limit come into play? We show you when and why quotas are used and how to differentiate between the different types.

CMS without database – a useful alternative?

CMS without databases: the simple solution for small web projects

Do you know of 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?

Information Retrieval: how Search Engines retrieve Data

Information Retrieval: the Great Search for Knowledge

In our everyday life, we search for and receive a lot of information. Through the Internet, the searching for data and facts has changed tremendously. Search engines help us find the information we need from the vast amount available. But how do Google and other search engines actually gather the information? Behind both large search engines and smaller library databases, there are so-called...

Microsoft Access alternatives at a glance

Microsoft Access alternatives: are there any free applications that achieve the same result?

MS Access is widely used office software and enables people with no prior programming knowledge to work with databases. The license for the programme, however, is not exactly cheap. Several free alternatives to Microsoft Access promise to do essentially the same thing. But which are the best Microsoft Access alternatives? And can they actually keep up with the range of functions and standard of...

Your own knowledge base with wiki software

Your own knowledge base wiki software

Do you ever find yourself grabbing your smartphone mid-conversation to look something up on Wikipedia? Since the boom in mobile technology, instant access to information has become a part of everyday life, and Wikipedia is the most prominent knowledge bank of all, demonstrating the possibilities of this slimmed down CMS. But how exactly do you go about creating a wiki?


Wait! We’ve got something for you!
Get your .co.uk domain for just £1/1st year.

Enter the web address of your choice in the search bar to check its availability.
12 months for £1
then £10/year