Database

Securing servers with Fail2ban

Securing your server with Fail2ban

For server operators, security is of the utmost importance. Only those who have developed and set up a foolproof defense strategy are ready for drastic situations. As well as regular protection mechanisms, like security software, backups, and encryption, there are also some useful tools and frameworks that may come in handy in the fight against intruders. We have laid out essential details on the...

MAMP: the practical software stack for Mac OS X

MAMP: the local development environment for Mac OS X

If you’re developing a website, it’s important to regularly ensure that all the elements function as intended. Although there are no specific tools required for creating a basic info page with static content, it’s not possible to preview a project containing dynamic elements without some additional tools. The simplest solution is to use an all-in-one development environment like MAMP.

Elasticsearch

Elasticsearch: the flexible search engine

If you work with large amounts of data, you’ll need a powerful search engine. Elasticsearch offers you a full-text search that you can configure so that it is perfectly tailored to your needs. But first you have to understand the principle behind it – what is Elasticsearch?. In this Elasticsearch tutorial we’ll explain the first steps in using the search engine, from installation to creating a...

How PHP7 speeds up the internet

PHP7 – shorter loading and access time online

Running dynamic websites that use complex content management systems benefit from quick loading times. This is because they ensure good performance and therefore increase user-friendliness. With the release of PHP7, a new scripting language is now available with which the loading times of your own website can be significantly shortened compared to the older script version.

The basics for modern web development

Modern web development: the basics

The trends driving web development are moving away from static web presences and heading increasingly in the direction of interactive content. Even though languages like HTML and CSS still rule the roost, a growing number of developers prefer the server-side programming language, PHP, for dynamic websites. Client-side script languages like JavaScript make it possible for a site to react to user...

Managed cloud hosting: customized servers

Managed cloud hosting: flexible server structures at the click of a button

More and more website operators are turning to managed cloud hosting as a solution for their server environment. This option promises flexible scalability of required resources in real time, along with a wide range of services offered by the provider including the installation, maintenance, and protection of the hosting platform. So how does managed cloud hosting work? Find out what services...

A comparison of data mining tools

Data mining tools for better data analysis

In the digital age, it’s normal for data from small and medium-sized companies to grow to unmanageable amounts. Data mining tools are used to extract desired information from data sets. These extract recurring patterns from the data and make them available to marketers and statisticians. We have compared the most important data mining software and show where their strengths and weaknesses lie.

Database normalization

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

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


Wait! We’ve got something for you!
Have a look at our great prices for different domain extensions.


Enter the web address of your choice in the search bar to check its availability.
.club
$1/1st year
then $15/year
.com
$1/1st year
then $15/year
.info
$1/1st year
then $20/year
.me
$1/1st year
then $20/year