Database normalisation

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

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

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

"Error establishing a database connection" | Explanation & solution

"Error establishing a database connection": an explanation of the WordPress database error

"Error establishing a database connection": this WordPress database error can drive website operators and internet users mad! What do you do when your WordPress site displays this error message? We explain how to locate the error and which steps you need to take to fix it. Our instructions will help you to understand why this error occurs and what you have to do in order to make your website work...

Dereferrer | anonymiszing links made easy

Anonymising links – advantages and disadvantages of dereferrer

Privacy is one of the most important aspects of the Internet. Whoever wants to protect themselves will hopefully begin with one of the most basic elements of the World Wide Web: the hyperlink. References from one webpage to the other usually lead in one direction only – information exchange via HTTP, however, takes place in both directions. To prevent this from occurring, Internet users used to...

HTTP 503: how to fix website errors

HTTP 503 (Service Unavailable): meaning and troubleshooting

It’s very likely that you’ve stumbled on the 'HTTP Error 503 The service is unavailable' notification or something similar during your daily browsing. The error message appears whenever a web server can’t display the website that the user is trying to access. There are many reasons for these notifications, just as there are many solutions. It’s your responsibility as the website operator to...

Shop system or CMS – what’s the difference?

CMS or shop software: what’s the difference?

Until recently, content management systems (CMS) and online shop solutions have been developing separately from one another, each with its own set of strengths. But the recently-developed umbrella term ‘content commerce’ shows that a merger is taking place, in which differences between both applications are becoming more and more blurred. How does this trend influence the development and the...

What is a rewrite engine?

What is a rewrite engine?

A rewrite engine is a component of the web server software that allows website operators to internally rewrite URLs or to redirect them to external URLs. The most popular rewrite engine is mod_rewrite for the Apache HTTP server, but other web servers also offer similar functions. We show you how URL rewriting works in different web servers.

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.

Index management with the robots.txt file

Index management with robots.txt files

With the file, robots.txt, website operators are able to greatly influence which portions of their web projects are able to be read by search bots. In addition to HTML meta tags, redirects, and canonical tags, this seemingly insignificant text file located in the domain’s root directory is an important tool for index management. We’ve laid out how robot.txt files are built and what website...

Hosting

The IONOS Web Hosting Guide: advice for website administration

Hosting an internet presence (web hosting) is getting easier and easier thanks to the variety of tools and increasingly user-friendly content management systems. But it’s still good to familiarise yourself with the finer points of online service administration: and this is where our Web Hosting Guide comes in. In our Digital Guide to hosting, you’ll find in-depth information and recommendations on programs, tools, plugins as well as general hosting tips. These useful articles are designed for all levels, from beginners to professional users: with relevant content and comprehensive detail, the IONOS Web Hosting Guide offers expert knowledge to a broad readership.

CMS, blogs, and technical matters

The ‘Hosting’ category is one of six sections of the IONOS Digital Guide. This is then split into three further subcategories: ‘CMS’, ‘Blogs’, and ‘Technical matters’. The first of these is devoted to content management systems, looking at the considerable number of options available for website creation and administration. The ‘Blogs’ subcategory offers advice and guidance on the establishment and operation of a successful weblog. Here, we also introduce the many extensions and tweaks available for the most widely used blogging and CMS application of all – WordPress. Our final section focuses on information and tips on ‘Technical matters’. This subcategory explores the different sorts of web hosting, the various programs which lighten your web hosting workload, new hosting opportunities, and everything else you need to know about the administration of internet resources.

From beginner to expert: hosting tips for every ability

Our Web Hosting Guide isn’t just for checking basic requirements and techniques of site administration – trained professionals can also expand upon their existing knowledge by reading our articles. Articles like ‘What is shared hosting?’ or our ‘Blog with success’ series are suitable for readers who are new to web hosting, whereas specific posts like ‘Indexing management with robots.txt’ or ‘The top ten .htaccess tricks’ require prior knowledge and experience. This variety makes our Web Hosting Guide attractive and accessible for anyone interested in website administration. Whether you’re a small to medium-sized enterprise, a blogger, a developer, or simply a technology enthusiast: IONOS has got you covered.


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