Articles Cookbook

Subquery vs. JOIN

by Dorota Wdzięczna
28 May 2020 One of the challenges in writing SQL queries is choosing whether to use a subquery or a JOIN. There are many situations in which a JOIN is the better solution, and there are others where a subquery is better. Let’s consider this topic in detail. Subqueries are used in complex SQL queries. Usually, there is a main outer query and one or more subqueries nested within the outer query.
Read more

5 Advanced SQL Constructions Every Data Analyst Should Learn

by Tihomir Babic
27 May 2020 Does your job involve data analysis? Here are five examples of how advanced SQL can help you in your daily work. I’m a data analyst and I have to say – data analysts can be quite strange. Other people are usually afraid of immense amounts of data; we enjoy it. The deeper we get into data, the happier we are. An important tool for getting into data (and thus being a happier data analyst) is SQL.
Read more

Is it Difficult to Learn SQL?

by Rebecca McKeown
26 May 2020 It’s the number one question asked by the students of SQL and those new to the IT world. Is it difficult to learn SQL? If you came here because you’ve been pondering that very same question, take some comfort in the fact that in no way are you alone. Even the idea of SQL can be intimidating to those of us without a tech background, but it doesn’t have to be that way.
Read more

Subquery vs. CTE: A SQL Primer

by Kamil Bladoszewski
22 May 2020 Have you ever wondered about the differences between a subquery and a common table expression (CTE) in SQL? The concepts seem very similar, but knowing the difference – and when to use each one – will help you write efficient and readable queries. First, we’ll explain the concepts underlying subqueries and CTEs. Then we’ll look at a few examples and finally analyze the pros and cons of each technique.
Read more

How to Number Rows in an SQL Result Set

by Ignacio L. Bisso
21 May 2020 Have you ever needed to add a sequential number to the records in the result of an SQL query? It’s not as simple as it looks! Find out how to do it correctly in this article. To number rows in a result set, you have to use an SQL window function called ROW_NUMBER(). This function assigns a sequential integer number to each result row. However, it can also be used to number records in different ways, such as by subsets.
Read more

Course of the Month - Creating Basic SQL Reports

by LearnSQL.com Team
20 May 2020 In May, we chose Creating Basic SQL Reports as our course of the month. Why? Because the basis of every successful business is making the right decisions based on proven data and good SQL reports. I asked Agnieszka Kozubek-Krycuń, Chief Content Officer at Vertabelo, about this. She knows SQL better than just about anyone and is probably the best person to talk about SQL Reporting. What does it mean to create SQL reports?
Read more

Which Major Companies Use PostgreSQL? What Do They Use It for?

by Jakub Romanowski
19 May 2020 Which companies use the open-source relational database management system PostgreSQL? Find out … and learn why you should be a PostgreSQL user too. You know the blue elephant logo. You have heard that PostgreSQL is a very good solution. But which companies use it? Here is a list of the largest IT and business companies that use PostgreSQL (or Postgres, for short). Multinationals worth billions of dollars can't be wrong, right?
Read more

Overview of Ranking Functions in SQL

by Dorota Wdzięczna
15 May 2020 SQL ranking functions make working with relational databases easier, especially for data analysts, marketers, and financial specialists. These functions are used to assign a ranking number for each record and allow you to efficiently create useful reports. SQL ranking functions are window functions. Window functions compute the result based on a set of rows. The word “window” refers to this set of rows. Let’s look at the syntax of ranking functions:
Read more

Beginner’s Guide to the SQL Subquery

by Ignacio L. Bisso
14 May 2020 Subqueries are a powerful SQL resource, allowing us to combine data from multiple tables in a single query. In this article, we’ll teach you everything you need to begin using subqueries. Perhaps the simplest definition of a SQL subquery is “A query inside a query”. Subqueries are so easy to understand that they often appear in the opening chapters of SQL courses. However, there are many variants of subqueries that need to be explained.
Read more

Advanced SQL Interview Questions (and Answers)

by Tihomir Babic
13 May 2020 Do you want to move to a job that uses SQL? Are you unsure about what to expect during the job interview or how to benchmark your knowledge? This article will give you a good idea of where you stand. If you feel stuck in your job, you’re not the only one. The modern division of work pushes people to perform very specific tasks, expecting them not to look at what's on the other side.
Read more
go to top