SQL OUTER JOIN
SQL OUTER JOIN
  • Technical matters

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 OUTER JOIN
SQL JOIN
SQL JOIN – queries across multiple data tables
  • Technical matters

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 JOIN – queries across multiple data tables
UML: Unified Modeling Language
UML - a graphical-type modeling language
  • Web development

If you need to run object-oriented programming, to represent a system clearly, and also make it accessible to external specialists, you may find the Universal Modeling Language to be ideal. UML is a modeling language, but has many other possible uses. Since the introduction of UML 2.0, UML diagrams are also suited to the graphical representation of non-computer-based concepts, such as use case...

UML - a graphical-type modeling language
What's a hackathon?
Hackathons: intense and innovative programming retreats
  • Web development

What is a hackathon, and what happens at one? Very little sleep, innovative ideas, and a lot of hard work! In addition to a definition of a hackathon, and an explanation of how it works, we also provide a few examples of hackathons in the US, as well as some of the amazing projects that came from them, such as mental health apps, and organ transplant aides.

Hackathons: intense and innovative programming retreats
Creating a Wikipedia page
Create your own Wikipedia page
  • Website creation

Have you ever toyed with the idea of creating your own Wikipedia entry? There are certain criteria Wikipedia requires in order to publish an article – and to ensure that content is fact-based, new entries are extensively checked by Wikipedia editors. Learn how to make your own Wikipedia page, and reduce the risk of your article being deleted.

Create your own Wikipedia page
Facebook Lead Ads
Facebook lead ads: gain valuable data, and new customers!
  • Social media

Whether contact data for more newsletter registrations or demographic information for individual customers: with the Facebook lead ads format, you will be able to collect valuable user information. The trick: based on the user profile, Facebook automatically completes a question form so that impatient users do not have to enter the data manually. Interested parties only need two clicks to...

Facebook lead ads: gain valuable data, and new customers!
Best bill splitting apps
Splitting the bill: the best apps for sharing the cost
  • Web analytics

Whether it’s splitting the bill at the restaurant, keeping track of a household budget, or keeping a tab on vacation with friends: bill splitting apps help you share costs, calculate expenses, manage invoices, and pay off debts. They can also help facilitate financial cooperation. In the meantime, there are a number of tools that you can install for free. Here is a guide to the best apps for...

Splitting the bill: the best apps for sharing the cost
Google Tag Manager
Google Tag Manager: the hub for your tracking and testing snippets
  • Web analytics

Tools for recording and analyzing user behavior are part of everyday life for website operators. Yet the more codes you need to embed and keep track of, the more difficult and time-intensive the task becomes. How can you keep track of everything? The Google Tag Manager offers the perfect answer. Here you will learn how the tool created by the search engine giant works and how you can make best use...

Google Tag Manager: the hub for your tracking and testing snippets
Replacing an SSL Certificate affected by Browser Distrust
Replacing SSL (Secure Socket Layer) Certificates affected by browser distrust
  • Website creation

Due to browser community distrust in Symantec, Google Chrome and Mozilla Firefox have decided to distrust websites with SSL certificates issued by Symantec before December 1st, 2017. This article outlines the steps and important key dates that website operators need to be aware of in order to sucessfully renew or replace their SSL certificates before their website is branded with a warning...

Replacing SSL (Secure Socket Layer) Certificates affected by browser distrust
What is Internet protocol? – IP definition, etc.
What is Internet Protocol (IP)?
  • Know-how

When networking a computer system, protocols play an important role. An example is the Internet Protocol, which was published in a first specification in 1981, and is the indispensable basis for the smooth sending and receiving of data packets. But what is behind the RFC standard? And how does the internet protocol actually work?

What is Internet Protocol (IP)?