Blog Posts

An Illustrated Guide to the SQL Non-Equi Join

join, sql join, non-equi join, equi, non-equi

Did you know that an SQL join doesn’t have to be based on identical matches? In this post, we look at the non-equi join, which uses ‘non-equal’ operators to match records. We’ve already discussed several types of joins, including self-joins and CROSS JOIN, INNER JOIN and OUTER JOIN. These types of joins typically appear with the equals sign (=). However, some joins use conditions other than the equals (=) sign. These are called non-equi joins, and they’re what we will

Continue Reading

An Illustrated Guide to the SQL Self-Join

What is an SQL self-join and how does it work? When should it be used? We’ll provide answers to those questions! In SQL, we can combine data from multiple tables by using a JOIN operator. JOIN has several variants; we’ve already discussed CROSS JOIN, INNER JOIN, and OUTER JOIN. Most of the time, these operators join data from two or more different tables. In this article, however, we will explain how to join records from the same table. A self-join

Continue Reading

So You Want to Be a Data Scientist?

A career in data science is hot right now. What is a data scientist, and how can you become one? Very few of us said “I want to grow up to be a data scientist” when we were kids. But now, in the age of Big Data and economic uncertainty, a career in data science is looking mighty attractive. If you like the idea of working with information and earning a good paycheck, read on. If you’re interested in cutting-edge

Continue Reading

What Is Vertabelo’s SQL Cheat Sheet?

Everyone, from rookie programmers to SQL ninjas, needs a bit of help now and again. Enter Vertabelo’s SQL Cheat Sheet! Working with databases is hard. There’s a lot of data to manage, which can be daunting. But the main challenge many database users face is the SQL commands themselves. It’s all right when you’re using the same familiar ones day after day, but what about the commands you dust off once or twice a year? Or what if you’re just

Continue Reading

Data Science: Market Demand or Just Hype?

Earth’s 7.5 billion people together use several billion different devices, generating an annual global IP traffic of more than one zettabyte. Out of these impressive numbers rises a new field above the others — “data science”. Is data science an inevitable reality, or will it yet be dismissed as just another “wave of the future” that never came to be? A few days ago I signed a new employment contract with my company. Finally, my long-time wish came true! After

Continue Reading

The 5 Highest Paying SQL and Database Jobs

IT provides a wide and growing job market, offering many excellent opportunities in both career development and earning potential. Today we’ll take a look at several very interesting SQL/Database-related jobs. Every year, many in the work force set their sights and aim for new and better jobs. When it comes to jobs, “better” means different things to different people, but earning potential is almost always a top priority. Enter the growing field of IT, in which new challenges wait around

Continue Reading

GET ACCESS TO EXPERT SQL CONTENT!