Blog | HOSTAFRICA Blog

HOSTAFRICA's Blog

Howto – A short MySQL tutorial with examples – 02

27/04/2018

In our previous MySQL tutorial, we created a small database with four tables. In this article, we will learn to manipulate the data we entered using JOIN to derive data from a table using data from another table. We will also modify the output using the MySQL CONCAT command. Our MySQL Data Our data consists […]

Blog Database Web Tutorials

Howto – A short MySQL tutorial with examples – 01

26/04/2018

Following on my previous article on databases and database planning, I have decided to add a quick practical tour of a MySQL database. MySQL and MariaDB are equivalent for the purpose of this article as they both use the exact same syntax. We will assume that you have access to a MySQL/MariaDB server and have […]

Security

Firewalls – General Concepts explained

26/04/2018

Most of us have heard of firewalls, but do we understand the concepts that make them work. This week, Host Africa will take a look at some basic firewall concepts and try to make them a bit easier to understand. Types of firewall Traditionally, there are two main types with many variations in-between. These two […]

Domain Name Hosting Security

SSL certificates at Host Africa

23/04/2018

The assortment of SSL certificates available may be confusing and could result in purchasing more (or less) than we need. Using a few questions, we can quickly arrive at a correct decision. Is your website for personal or business use? This hinges on what you want your website visitor to see. Is a valid HTTPS […]

Database

Howto – Planning your SQL database structure – a simple example

21/04/2018

This article is not from a professional SQL Database Administrator’s perspective. It is from someone who has been using MySQL, PostgreSQL and MariaDB for the last 18 years. I have found some basic principles around database design that make life a lot easier. And then researched the best practice whitepapers to confirm the soundness of that […]

DNS

Extended DNS Records – SVR, DNAME and AAAA records

19/04/2018

We continue looking at less commonly used DNS records, but we also look at the soon to be common AAAA record which is merely the IPV6 version of an A record. Before that, we will first examine the SRV and the rare DNAME records. The SRV extended DNS record SRV records are DNS entries that […]

Howto – A short MySQL tutorial with examples – 02

Howto – A short MySQL tutorial with examples – 01

Firewalls – General Concepts explained

SSL certificates at Host Africa

Howto – Planning your SQL database structure – a simple example

Extended DNS Records – SVR, DNAME and AAAA records

we're happy to help!

Call us on +27 21 554 3096

Company

Our Products