Articles Cookbook
9 Jun 2021
Kateryna Koidan

4 Ways to Learn Which JOIN to Use in a SQL Query

You probably already know that you should use JOIN to combine data from several tables. But what kind of JOIN? In this article, I’ll introduce four simple ways to finally learn which JOIN to use in different scenarios. Before we jump into smart strategies for learning SQL JOINs, I suggest taking a brief overview of the major JOIN types. We’ll go through several examples to recall the difference between (INNER) JOIN, LEFT (OUTER) JOIN, RIGHT (OUTER) JOIN, and FULL (OUTER) JOIN.
Read more
8 Jun 2021
Karolina Niewiarowska

Free Online Courses You Should Take If You Use SQL

If you are an SQL enthusiast, already work with SQL, or want to learn it – you'll surely be interested in acquiring new skills that will support your growth. These free courses will increase your productivity, help you find your way around the work environment, and help you become a better analyst. By the way, they are also fun. Whoever said learning new things is easy has never tried to learn quantum physics (thank you, Mr.
Read more
4 Jun 2021
Andrew Bone

How the Division Operator Works in SQL

The division operator in SQL is used to divide one expression or number by another. This article will show you exactly how to use it and common mistakes to avoid along the way. The best way to practice SQL is our interactive SQL Practice track. It contains over 600 hands-on exercises that conver varios SQL topics, from simple one-table queries, through JOINs, to complex topics like subqueries. It lets you train your SQL skills on real business examples.
Read more
2 Jun 2021
Karolina Niewiarowska

A Brief History of MS SQL Server

Microsoft SQL Server is one of the best database management systems in the world. It’s constantly improved and widely used. But do you know how it was created? In this article, I’ll show you the history of MS SQL Server, a solution that changed the world of databases. We’ll explore the stages of MS SQL Server development, find out how the current version differs from the original, and talk about where you can learn or practice SQL Server.
Read more
1 Jun 2021
Jakub Romanowski

Course of the Month: GROUP BY Extensions in SQL Server

Do you create SQL reports? Do you want them to be even better and more effective? Are you working with MS SQL Server and want to expand your query writing skills? Here is a great, interactive GROUP BY Extensions in MS SQL Server course. For the month of June, you can learn and finish this course for absolutely free. How can you get this free SQL course in June?
Read more
28 May 2021
Andrew Bone

UNION vs. UNION ALL in SQL: What’s the Difference?

UNION and UNION ALL are SQL commands used to combine results from multiple SELECT statements. This article will detail the differences between the two, allowing you to make the best choice for each unique scenario. SQL UNION and UNION ALL commands are used to combine data from multiple SELECT statements. Both UNION and UNION ALL are known as set operators. In SQL, set operators combine the results of two or more queries into a single result.
Read more
27 May 2021
Karolina Niewiarowska

Where Can I Find a Data Analyst Internship?

Are you wondering how to land a data analyst job without any professional experience? This article is the answer! A key step in this journey is securing a position as a data analyst intern, which will be the focal point of our discussion. Finding an SQL-related internship – an important part of eventually landing a data analyst job. Internships enrich your CV and, more importantly, help you learn SQL from the practical side.
Read more
26 May 2021
Ignacio L. Bisso

How to Compute Year-Over-Year Differences in SQL

How did your business do this year compared to last year? The year before? Find out how to use SQL to calculate year to year and month to month differences. Year-over-year (YOY) comparisons are a popular and effective way to evaluate the performance of several kinds of organizations. Year to year differences are easy to understand – e.g. it’s easy to understand that your revenue growth is 35% year to year.
Read more
25 May 2021
Karolina Niewiarowska

How to Keep Focused While Learning SQL

Learning SQL can be a challenge, but it’s one you can handle! I’ve prepared 5 tips to help you stay focused during your learning journey. By choosing the right methods and tricks, you can achieve your goals! If you’re interested in learning SQL, I bet that you are a very ambitious person who wants to constantly develop. You may even be taking your first steps in your career. I don't think I need to explain to you the obvious advantages of learning how to operate database systems; Data is everywhere, applies to everyone, and is increasing by the day.
Read more
21 May 2021
Tihomir Babic

8 Best SQL Window Function Articles

Do you need a starting point for learning SQL window functions? Not sure which articles provide a solid foundation? We dove into the internet rabbit hole and found the eight best articles dealing with window and analytic functions. There are plenty of articles dealing with SQL window functions. Type those words into Google and you’ll find a huge number of articles returned. Reading articles is a good start if you want to learn something about window or analytic functions in SQL – provided, of course, that the articles you choose are trustworthy and up to date.
Read more