Learn Sql

Kateryna Koidan

What Is SQL?

SQL may be something you hear about from your colleagues. Or you may see it in the job description for your dream role or notice it in a list of the most popular programming languages. So, what is SQL? Should you learn it? Let's find out. Do you think about a career in data analysis and data science? Do you need to interact with relational databases at work? Do you want to improve your performance as a marketer, HR specialist, or researcher by making more informed decisions?

Tihomir Babic

An Overview of Microsoft SQL Server Text Functions

Data analysts use text values when creating SQL reports. You can create your own labels with functions, classify rows based on text value, or do computations based on it. This article covers how to do all that. The text values in databases are not just for reading. As with numeric values, we perform operations on them and manipulate the text. SQL Server has a fair number of text functions.

Himanshu Kathuria

Learn SQL in 4 Steps

Want to work with data? You’ll need SQL. Fortunately, you can learn SQL in just 4 steps! If you are interested in data crunching or working with data in general, you’ve probably heard something about SQL. Now that data storage is cheap and accessible, data from every transaction can be stored and analyzed. Hence, there’s great demand for people who can capture and work with this data. We’ve even seen entire companies profit from being proficient with data; for example, consider the ever-growing value of Google and Facebook (now Meta).

Himanshu Kathuria

These SQL Queries Will Help You With Data Analysis

Need to streamline your everyday data analysis tasks? This article explains how basic SQL queries can help. If you are planning a corporate career or any field that involves working with data, you must have come across SQL, or Structured Query Language. SQL was first developed in the 1970s and it continues to be the industry standard for database interactions. Many of you may already have decided to learn this language, given how powerful it is.

Tihomir Babic

How to Combine Two Aggregate Functions in SQL

Having trouble using two aggregate functions in one query? This article will show you how to do it the right way – actually, the two right ways. In data analysis and reporting, we often need to count the number of records or sum them up and then calculate the average of this count or sum. Translated to SQL logic, this is the aggregation of aggregated data, or multi-level aggregation. For aggregation purposes, there are the SQL aggregate functions.

Dorota Wdzięczna

How to Install a MySQL Database on a Windows PC

Do you want to install a MySQL database on your Windows computer? And maybe find out how to start using a MySQL database? In this article, we’ll cover the installation process. MySQL is one of the most popular relational database servers. This is one reason to start using a MySQL database. Among the various editions of MySQL delivered by Oracle, the Community edition is available for free. You can download it from the MySQL website.

Marcin Koryszewski

Over 40 and Want to Upskill? Learn SQL!

You have several years of experience. Your work has even been written up in a few case studies. Yet, you still have a hard time finding the right path to improve your career. If that's true for you, the answer is to learn SQL. In this article, I'll tell you why. Why learn SQL when you’re already an experienced professional? It’s always good to learn something new. You may want to pick up a new hobby, try out a different industry, or get a new skill to help your career.

Ignacio L. Bisso

How to Use the COALESCE() Function in SQL

SQL users are often faced with NULL values in their queries and need to process them properly. The COALESCE() function helps handle NULL values. Read this article to learn how to use COALESCE() in your queries. SQL tables store data in records, and records are composed of fields. There can be situations where we don’t know the value for a specific field. For example, let’s suppose we have a table with data for persons.

András Novoszáth

The Recent Rise of DBT and the Analytics Engineer

If you’re interested in data engineering or data analytics, you should know about DBT. And you should also learn about the role of an analytics engineer. We cover both in this article. The rise of Cloud data providers has led to new challenges and possibilities. If you are thinking about entering the data analytics space, it is important to be aware of them; it can help you decide what roles to aim for and what skills to learn.

Tihomir Babic

Top 9 SQL GROUP BY Interview Questions

Preparing for an SQL job interview? This guide will walk you through nine basic, intermediate, and advanced GROUP BY questions that you may have to answer. There are common GROUP BY questions that pop up in a lot of SQL job interviews; in this article, we’ll explain how to answer them. If you are a data analyst or another data professional preparing for an interview, this article aims to help you out.

Tihomir Babic

What Are Window Functions in SQL?

In this article, we discuss what window functions are and how they help you do your job as a data analyst or specialist. No, window functions have nothing to do with the operating system. The window here refers to a set of rows over which the function aggregates data. To learn how window functions work, what functions there are, and how to apply them to real-world problems, it’s best to take the Window Functions course.

Himanshu Kathuria

Why Should Every Data Analyst Know SQL?

In the 1980s and 90s, it was the emergence of ERPs, processing a few thousand transactions a day. Now, sophisticated Cloud-based systems work with billions of transactions each day. How data is captured and handled has come a long way! Anybody who understands how to use this data has an edge. The good thing is that while the technology working in the background has become more complex, we don’t necessarily need to understand the underlying system’s details to use it.

Jakub Romanowski

Free SQL Course of the Month – PostgreSQL INSERT, UPDATE, and DELETE Commands

Do you want to be a data engineer or data analyst? Do you work with databases daily and need to expand your skill with the basics of data manipulation? You've come to the right place. For May 2022, our SQL course of the month is PostgreSQL INSERT, UPDATE, and DELETE Commands! Learn SQL for FREE! How do you get this free PostgreSQL course in May? Create a free LearnSQL.

Kateryna Koidan

How to Update Only the First 10 Rows in SQL

Real-world databases require continuous updating. Often, you need to update specific records; you may even want to update only the first row, or the first 10, 100, or 1000 rows. Let’s explore how to update rows for a specified quantity from the top in SQL. What Is the SQL UPDATE? In SQL, an UPDATE statement modifies existing records of a table. You may choose to update entire columns or update rows filtered with a WHERE statement.

Kamila Ostrowska

Top 5 MySQL Query Tools

Are you looking for a software solution that will make working with the MySQL database even easier? In this article, I’ll tell you about five highly recommended query tools that will save you time. MySQL may already be familiar to you as the most popular open-source relational database management system (DBMS). It works in most applications, which is why the last Stack Overflow report rated MySQL as the most used database.

Himanshu Kathuria

The SQL Syntax Is Simple: True or False?

Are you contemplating learning SQL but are concerned about how difficult it may be, especially if you have no prior coding experience? If so, you are not alone. In this article, I show you how simple SQL is and that it is worth your time learning it. You just need to know how to approach it properly. Many people carry the notion that learning SQL is much like learning other programming languages.

Dmitri Vaitkun

What Are the Different SQL JOIN Types?

You just can’t understate the importance of the JOIN when learning SQL. Not only is it one of the most fundamental operations in relational databases, but it is also very versatile with many different types. Although SQL JOIN may be intimidating at first, it becomes a very handy instrument in your arsenal once you understand it. Let’s explore all the SQL JOIN types! We can safely say the JOIN operation is one of the most powerful features of SQL.

Jakub Romanowski

SQL Track of the Season: SQL from A to Z in MySQL

Do you feel the spring already? Everything is in full bloom at this time of the year. Why shouldn’t it be the same with your career? You just need to water it with a new skill. Here is the brilliant SQL from A to Z in MySQL track, our Track of the Season. In this article, I answer common questions about this awesome set of online MySQL courses. Why should you care about relational databases at all?

Jakub Romanowski

Join the LearnSQL.com Affiliate Program!

Are you a creator, blogger, or YouTuber? Do you have an audience, do you appreciate our interactive SQL courses, and would you like to help promote them? By the way, you can earn some money! Here is our SQL Affiliate Program. We create our SQL courses with a passion and a love for databases. Looking at the reactions and the reviews of our users, we do quite well. If this is your first visit to LearnSQL.

Pierre Timms

Are You a Student? Choose LearnSQL.com

If the answer to this question is yes, then let’s talk about how learning SQL as part of your educational journey benefits you down the road. We’ll focus on the importance of SQL for students – whether you are preparing for an exam, are thinking about a career in IT, or need new skills for a research project. Later, we will explain why LearnSQL.com is the way to go, whatever your learning goals are.

Tihomir Babic

How to Write Multiple CTEs in SQL

Leverage the full potential of the CTE by combining two or more of them in a single SQL query. Common table expressions, or CTEs, can be a powerful SQL tool. When you write two (or even more) CTEs together, this power multiplies. In this article, I’ll show you three ways of writing multiple CTEs: Using two independent CTEs in one SQL query. Using two CTEs where the second CTE refers to the first.

Tihomir Babic

The SQL Substring Function in 5 Examples

Working with text data in SQL? We explain how to get values from any point in a string. When you think of working with data in SQL, your first thought is probably a database full of numbers and your SQL code doing very fancy calculations. But text is data, too! It’s very common to find text data in databases. Not only do you have to extract it, but often you also have to manipulate it.

Kateryna Koidan

Are You Ready to Become a Data Analyst?

Data analysts enjoy strong career prospects. Do you have the skills required for this role? Let’s find out! If you enjoy working with data, searching for interesting patterns and valuable insights, you may wonder “Should I become a data analyst?” In this article, I’ll explain what data analysts do and what skills a successful data analyst needs. What Does a Data Analyst Do? Data-driven organizations rely on specialists who know how to get value out of data.

András Novoszáth

SQL and Cloud Databases Are the Perfect Match!

Do you want to do analytics in the cloud? Are you considering learning SQL and wondering whether you can use it with cloud-based databases? Do you want to know how cloud databases and SQL work together? We answer your questions in this article. Read on! You may be an analyst who has heard about cloud databases and SQL and want to learn more. Maybe you are already familiar with them and want to know if the two technologies fit together.

Karolina Niewiarowska

Is Your Learning SQL Plan Stuck in Neutral?

Are you stuck on some tricky point of learning SQL and don't know how to move on? This article will help you move on in your SQL journey. Have you been learning SQL, only to get discouraged by some difficult concept? Everybody gets stuck when they try to learn something new. Most of us have probably given up trying to learn that thing, only to come back to it later.

Jakub Romanowski

New MySQL Courses Are Here!

A lot of you have been waiting for new MySQL courses on LearnSQL.com – and finally, they’re here! Now you can learn everything MySQL in a simple, understandable, and fun way. We've worked a lot with these online SQL courses and created hundreds of interactive exercises to help you learn this popular SQL dialect. If you want to communicate with the world’s most popular open-source database, our MySQL courses will help you achieve that goal!

LearnSQL.com Team

LearnSQL.com’s Monthly SQL Practice in 2022

Are you looking for ways to practice SQL? Tired of boring exercises based on unreal scenarios? We have something for you! Every month, we publish a new set of SQL practice exercises. You'll find all of them in the monthly SQL Practice. Here at LearnSQL.com, we believe the best way to learn SQL is through practice. All of our SQL courses (and there are over 30 of them!) are hands-on.

Dominika Florczykowska

An Overview of MySQL Data Types

What data types are available in a MySQL database? In this article, you’ll learn about numeric data types, text data types, and much more! You may have seen our article about data types in SQL. Here, we focus on the MySQL data types. We will discuss the most commonly used ones: numeric, text, and date and time. If you are interested in the topic, be sure to check out our Data Types in SQL course.

LearnSQL.com Team

2nd Anniversary of LearnSQL.com

It’s happening! Today we celebrate the 2nd anniversary of Learn SQL.com. We have come a long way together. Thank you for being with us and we promise to get even better every day! 731 days have passed since February 23, 2020, when we launched the LearnSQL.com platform. That's 17544 hours or 63158400 seconds if you prefer. It's been a long time, but it feels like yesterday that we started out together.

Tihomir Babic

How to Query a Parent-Child Tree in SQL

What are parent-child tree structures in SQL? In this article, we answer that question, talk about query hierarchy, and demonstrate the five most common SQL queries you’ll need for these data structures. Yes, you can use SQL on a parent-child tree structure. I’ll show you how in this article. Along the way, I’ll walk you through five query examples, starting with the easiest and ending with the most complex.

Karolina Niewiarowska

Is Learning PostgreSQL in 2022 Worthwhile?

You want to take a SQL course, but selecting the right one can be too challenging. Perhaps you don't know which dialect you should start with? PostgreSQL is one of the best options. Check out if it is worth it to learn PostgreSQL in 2022. When you search the web, there are many job advertisements for database specialists. Perhaps that is why you have chosen the direction toward development. Or maybe you are just fed up with Excel in your day-to-day duties (which is not surprising) and want to make work easier.

LearnSQL.com Team

Free Course of the Month – SQL Practice Set in PostgreSQL

Do you know the basics of PostgreSQL but still need good practice? Look no further! Here is a great interactive course, SQL Practice Set in PostgreSQL. Throughout the month of February, you have access to it for FREE! We at LearnSQL.com believe that to learn a new skill, you need basic theoretical knowledge and, above all, a lot of practice. It's the same with writing PostgreSQL queries – you need a lot of PostgreSQL practice.

Kateryna Koidan

How Do You Get Rid of Duplicates in an SQL JOIN?

Do you have unwanted duplicates from your SQL JOIN query? In this article, I’ll discuss the possible reasons for getting duplicates after joining tables in SQL and show how to fix a query depending on the reason behind the duplicates. Data analysts with little experience in SQL JOINs often encounter unwanted duplicates in the result set. It’s challenging for beginners to identify the reason behind these duplicates in JOINs.

Tihomir Babic

The SQL OVER() Clause Explained

Here is a detailed explanation of the OVER() clause in SQL window functions. This is a detailed guide on using the OVER() clause in SQL window functions. I will focus specifically on this clause, which requires that you have at least a general idea of how window functions work. To make the best out of this article, take a look at the SQL Window Functions Cheat Sheet. Feel free to have it by your side as we go.

Andrew Bone

PostgreSQL Interview Questions and Answers

Job interviews are always stressful. Interviewing and getting asked technical questions about PostgreSQL is even more of a challenge! In this article, we’ll cover some of the PostgreSQL interview questions you can expect when applying for a new job. By the end of the article, you should be able to handle most of the questions you are likely to face. We’ve previously covered common questions you can expect at a SQL job interview, but this article will be focused on Postgres specifically.

Ignacio L. Bisso

What Is a Common Table Expression (CTE) in SQL?

The common table expression (CTE) is a powerful construct in SQL that helps simplify a query. CTEs work as virtual tables (with records and columns), created during the execution of a query, used by the query, and eliminated after query execution. CTEs often act as a bridge to transform the data in source tables to the format expected by the query. A common table expression, or CTE, is a temporary named result set created from a simple SELECT statement that can be used in a subsequent SELECT statement.

Kamila Ostrowska

The Top 5 SQL Courses and Learning Platforms for 2022

It’s the New Year! Time to start thinking what good you can do yourself in 2022. If you haven’t decided yet, we want to recommend learning something new – specifically, learning SQL. Maybe learning SQL is already on your 2022 to-do list. If so, take it seriously – learning SQL can change your career path and even your life! It makes sense to find the best SQL courses so you can learn effectively.

Jakub Romanowski

Free Course of the Month – PostgreSQL JOINs

Our PostgreSQL JOINs course will help you consolidate your knowledge of working with data from two or more tables in a PostgreSQL database. Throughout the month of January, this awesome SQL course is absolutely FREE! Wondering why we want to give you this SQL course for free? We've been doing this for a long time. Every month, we choose one of our interactive online SQL courses and give users free access to it.

Tihomir Babic

How to Include Zero in a COUNT() Aggregate

Explaining how to include zero (0) counts in your SQL query result. Here’s the problem: you want to count something that doesn’t exist, and you want to show your result as zero. How do you do that in SQL? Using the COUNT() aggregate function is a reasonable first step. It will count all the data it finds and return the number of occurrences. But what if there are no occurrences of certain data?

Kamil Bladoszewski

Is SQL Case-Sensitive?

Is SQL case-sensitive? The question seems simple, and you may think it’s a yes-no question. However, the answer depends on multiple factors. Let’s take a look at the possible answers. First of all, this question can be understood in multiple ways. Which part of SQL are you asking about? Do you mean keywords (e.g., SELECT, WHERE, etc.), table and column names, or values in the columns? Which database management system (DBMS) do you have in mind?

LearnSQL.com Team

Christmas SQL Scholarship 2021

We know 2021 was very difficult for many of you. Now that it is slowly coming to an end, we’ve decided to end it with something positive. Here is the Christmas SQL Scholarship 2021! Let's enter the new year together with new energy and a chance for change! It was another year in which Coronavirus did not give up. The crisis has also affected the economy and our wallets.

Jakub Romanowski

Top 5 MS SQL Server Courses for Beginners

Every journey, including a career change, begins with the first step. If you're thinking about learning data analysis or strengthening your MS SQL Server skills arsenal, you've come to the right place. Here are the top 5 MS SQL Server online courses. Enjoy! You've probably heard that today’s organizations rely heavily on data analysis. You heard right. They are looking for employees who can navigate the world of databases and draw conclusions from data.

Kateryna Koidan

Will SQL Ever Be Replaced?

Is it worth learning SQL? Is it possible that one of the modern programming languages or no-code solutions will replace SQL very soon? No; it is not that easy to replace SQL and relational databases. Let’s see why SQL is future proof – and why learning it will pay off for many years to come. If you are building your career in a data-driven company, you are probably looking into opportunities to enhance your skill set in data management and data analysis.

Jakub Romanowski

Free Course of the Month – Common Functions in PostgreSQL

Do you want to be able to use popular PostgreSQL functions and process different types of data more easily? You've come to the right place! Here is the Common Functions in PostgreSQL course. Throughout the month of December, this SQL course is absolutely FREE! You are probably wondering: why is LearnSQL.com offering a free SQL course? Well, we've been doing this for a long time. We choose one of our courses every month and give users free access to it.

Kateryna Koidan

5 SQL Subquery Examples

SQL subqueries are basic tools if you want to communicate effectively with relational databases. In this article, I provide five subquery examples demonstrating how to use scalar, multirow, and correlated subqueries in the WHERE, FROM/JOIN, and SELECT clauses. A subquery, or nested query, is a query placed within another SQL query. When requesting information from a database, you may find it necessary to include a subquery into the SELECT, FROM , JOIN, or WHERE clause.

Jakub Romanowski

Black Week 2021 is Here!

We know you've been waiting for it, and it's finally here: Black Week, and with it, a great promotion for our SQL courses. This is the best offer in the history of LearnSQL.com! Sometimes we surprise ourselves. Last year's Black Week promotion on theAll Forever Plan and individual courses was great, many people took advantage of it, and we thought it would be hard to come up with something better.

Kamila Ostrowska

SQL for Startups – Do You Need It?

If you’ve been wondering whether to use SQL in your startup, it’s probably high time to do so. SQL can be an amazing tool for small, fast-growing businesses. But don’t worry if you’re unfamiliar with SQL for startups. Maybe you are not sure what SQL is all about. Don’t worry; you don’t have to make any decisions this second! First, answer these questions: Can you think of any data related to your business – prices, clients, details about clients, production details, budget, costs, strategy, or anything else?

Martyna Sławińska

What Are Aggregate Functions in SQL, and How Do I Use Them?

Data is your source of knowledge. And thanks to SQL aggregate functions, you can extract the precise knowledge you need from your data efficiently. Read along to find out more. The core SQL aggregate functions are the following: COUNT(column_name | *) returns the number of rows in a table. SUM(column_name) returns the sum of the values of a numeric column. AVG(column_name) returns the average value of a numeric column.

Himanshu Kathuria

How to Write a WHERE Clause in SQL

We explain how to use the SQL WHERE clause with practical examples. If you have just started learning SQL and want to know how to retrieve or work with only a specific portion of the data stored in your tables, then this article is for you! The SQL WHERE clause is something you must master if you wish to use SQL for working with data. It is arguably one of the most basic and must-learn constructs of SQL.

Karolina Niewiarowska

How Can SQL Developers Remember Everything They Learn?

Are you at the beginning of your SQL journey? Congratulations, great choice! But you may find the knowledge you gain leaks with time. Find out what SQL developers do to remember everything they learn for a long time. If you learn SQL, the road to the expert level is long, winding, and bumpy. But don't worry – we've all been through it. You know perfectly well it's worth it. And if you don't already know, here are the reasons why you should start learning SQL NOW!

Ignacio L. Bisso

What Is a Rolling Average and How Do You Compute It in SQL?

In this article, we will show three different examples of using SQL to calculate rolling averages. Learn this and you will take an important step in your SQL growth! A rolling average is a metric that allows us to find trends that would otherwise be hard to detect. It is usually based on time series data. In SQL, we calculate rolling averages using window functions. First, let’s talk about what rolling averages are and why they’re useful.

Jakub Romanowski

New Window Functions Practice Set Is Here!

Have you learned the SQL window functions? Or maybe, you forgot when and how to use them correctly? Are you preparing for an advanced SQL job interview? You've come to the right place! This is the new Window Functions Practice Set. This is very good news for all SQL learners and database professionals who want to improve their skills. The LearnSQL.com Team is proud to present the new Window Functions Practice Set!

Himanshu Kathuria

The SQL Count Function Explained With 7 Examples

One of the most useful aggregate functions in SQL is the COUNT() function. If you are new to SQL and want to learn about the various ways to use the COUNT() function with some practical examples, this article is for you. The COUNT() function is one of the most useful aggregate functions in SQL. Counting the total number of orders by a customer in the last few days, the number of unique visitors who bought a museum ticket, or the number of employees in a department, can all be done using the COUNT() function.

Marcin Koryszewski

2021’s Most Popular Databases

What was the most popular database in 2021? And what do you need to know to use it? If you’re learning SQL, you’re in luck. This year’s most popular database uses SQL. But the list doesn’t end there. Read our article and find out the 5 most popular databases this year. My list was based on the latest research of one of the most important platforms in the IT world: Stack Overflow.

Tihomir Babic

What Is a Recursive CTE in SQL?

The article that’ll show you practical examples of using recursive CTEs in SQL. If you’ve heard about SQL’s recursive CTEs but never used them, this article is for you. It’s also for you if you never get tired of recursive CTE examples. Before we dig into recursion, I’ll remind you what CTEs are and what their syntax is. Then I’ll do the same for recursive CTEs. After that, I’ll show you how recursive CTEs work in three examples.

Kateryna Koidan

Still Using Excel for Data Analysis? See Why SQL Is Better!

Are you working with data and still using spreadsheets? Many people think that only programmers or professional data analysts can leverage SQL for data analysis. In this article, I’ll show how people with no IT background can use SQL for their daily work tasks. Not all people working with data have the corresponding job titles like data scientist, data analyst, or data engineer. Following the data democratization trend, almost all office workers do something with data as part of their daily duties – marketers analyze advertising campaigns, HR specialists analyze employee dynamics, auditors analyze credit portfolios, etc.

András Novoszáth

Read These 5 Data Analysis Books to Jump-Start Your Career

Do you want to pivot into a data analyst role, but you are unsure where to start? Do you do analytics in your job and would like to learn more about the big picture of data? Are you looking for a great data analysis book to read? In this article, you will find our selection of the best books on data analysis! If you are a business professional thinking about picking up data analytics skills, you may be wondering how you should start.

Andrew Bone

Numeric vs. Decimal Data Types in SQL

In standard SQL, there is a slight difference between the NUMERIC and DECIMAL data types. However, in some variants of SQL, there is no difference! This article will clear up any confusion. In this article, I’ll explain the differences and similarities between SQL’s standard NUMERIC and DECIMAL data types. Then I’ll discuss how these data types work in common SQL dialects. We’ve already posted a more general article on SQL data types; this time, we’ll drill down further on just the DECIMAL and NUMERIC data types.

Andrew Bone

How to Sort Values in a Specific Order in SQL

Sometimes you will be required to order your data in a particular way, and often the use of typical sort modifiers like ASC and DESC are not enough. This article will show you how to use the CASE statement to order your data exactly how you need it to be. Have you ever needed to order your data in a very specific way? One of the best methods for handling complex sorting is using CASE.

Tihomir Babic

How to Use CASE in ORDER BY in SQL

This article will show you how and when to use CASE in an ORDER BY clause. Have you ever used a CASE statement? I’m sure you have, at least in a SELECT statement. But have you ever used it in an ORDER BY clause? No? You will, once I show you how! Don’t worry if you’ve never used a CASE statement. I’ll show and explain it to you with a short example.

Karolina Niewiarowska

How SQL Helps Everyone in Your Office

I don't know about you, but I really like to make my life easier. If something can be done faster and more efficiently, especially if it's everyday, routine tasks, I’m all for it! This is where SQL works brilliantly. It's not just about complicated data analysis. Everyone in the office works with different types of data, and SQL can help anyone. How? Anything is possible once you learn SQL!

Kamila Ostrowska

Best Places to Practice SQL JOINs Online

You’ve just started your journey with SQL and you’re not sure what a JOIN is or where to use it. Don’t worry! In this article, you will find out what JOINs are and where you can practice them online. If you have just started learning SQL, you have a lot of topics to cover before you can call yourself a data professional. If you are serious about using SQL, you’ll have to understand JOIN – what it does, when you can use it, and what its different variants do.

LearnSQL.com Team

Free Course of The Month – SQL Practice Set in MS SQL Server

You have to train a lot to learn a new skill. It is the same with MS SQL Server. Do you want to write good SQL queries? Or maybe you are preparing for a job interview? You've come to the right place! Throughout October you will have access to our amazing hands-on MS SQL Server course for FREE! You probably just thought: “There must be a catch. Why would someone give away SQL courses for free?

Tihomir Babic

Difference Between ROWS and RANGE in Window Functions

Are you familiar with ROWS and RANGE window functions but not sure how they are different? This article makes those differences clear. In using SQL window functions, you’ve probably come across ROWS and RANGE clauses. If you haven’t, they are both parts of the Window Functions course. If you have, it’s quite likely you have been left confused why there are two keywords for the same function. Well, they are not the same!

Kateryna Koidan

7 Things Every Data Engineer Should Know

People generate massive amounts of data every day. To get insights from data, organizations need to capture and process them efficiently. That is when data engineers are called up. In this article, I’ll discuss the data engineering role and the skill set necessary to succeed in the role. As the world generates more and more data every year, the IT industry creates new roles to deal with it. These roles include data analysts, data scientists, machine learning engineers, and data engineers.

Himanshu Kathuria

Who Has the Highest Salary, Department-wise? Use SQL to Find Out!

This article shows how to get the total salary by department for an organization, using the GROUP BY functionality of SQL. We explain the SQL GROUP BY clause in detail along with conditional filtering using a HAVING clause. Understanding the salary outlay for an organization is one of the common starting points for business leaders. It helps them see who in the organization has the highest total salary cost, department-wise.

Tihomir Babic

The 7 Best Articles about the SQL Recursive Query

Do you want to learn about recursive queries but don’t know where to start? Here’s our selection of seven articles that should help you with diving into the recursive queries world. I won’t lie to you. Learning and understanding recursive queries can be difficult. But difficult things are usually worth trying. And by learning recursive queries, you’re making sure you know how to work with this very powerful tool.

Kateryna Koidan

5 Practical Examples of Using ROWS BETWEEN in SQL

SQL window functions are tremendously useful for calculating complex aggregations like moving averages or running totals. The ROWS clause allows you to specify rows for your calculations, enabling even more sophisticated window frames. Here are five practical examples of leveraging the ROWS BETWEEN clause in SQL. Window functions (also called OVER functions) compute their result based on a sliding window frame (i.e. a set of rows). They are similar to aggregate functions in that you can calculate the average, total, or minimum/maximum value across a group of rows.

Dorota Wdzięczna

How to Export a CSV File From a T-SQL Query

Knowing SQL queries to select data from databases allows you to obtain information easily. However, there are many situations in which we need to export data to another platform or application. The CSV file is a solution to this problem. If you'd like to master complete SQL, try out our interactive SQL from A to Z track. It contains 7 hands-on SQL courses that will take you from a beginner to an advanced SQL user.

Kateryna Koidan

How Developers Can Build SQL Skills

Even though you cannot build an application using SQL, employers continue to add SQL skills to their job requirements for software developers. In this article, I’ll elaborate on why developers need to know SQL and how you can learn SQL most efficiently. As a developer, you may work on different kinds of projects. Not all of your projects require doing string manipulation, but that doesn’t mean you don’t need to know how to do this.

Himanshu Kathuria

Top 10 Tools for Business Analytics

Business Analytics is one of today’s hottest career fields. However, success as a business analyst requires that you learn the right skills and software programs. Let’s see what tools you should know if you want to be a business analyst. With the world generating immense amounts of data – and having systems in place to capture and manipulate that data to fuel business growth – job opportunities for business analysts are only going to grow.

Andrew Bone

How to Use Aliases with SQL JOINs

SQL aliases are custom names that you can give to the columns and tables you include in your queries. Aliases are very useful, as they can greatly improve the readability and maintainability of your query. We’ll be taking a closer look at using SQL aliases with JOIN and why you might need to do so. There are several types of aliases you can use in SQL: Aliases for tables.

LearnSQL.com Team

We Have Changed For You!

It's even better than before! LearnSQL.com doesn't just have a new awesome look. We've also been working very hard on the "behind the scenes" stuff, and have changed many functions on our platform to ensure that you have the best possible learning experience. The first glance at the new LearnSQL.com platform shows immediately that a lot has changed. It was very good before, but now it's awesome! We are very proud of our new look and hope that it will make learning SQL even more fun and effective.

Tihomir Babic

Frequently Asked Questions About SQL

Ten SQL questions that you should be able to answer if you’re applying for an SQL job. SQL is a vast topic and a source of endless questions from its users. However, some questions are asked more frequently – usually about concepts that most SQL users will need to know. It’s not surprising that interviewers tend to ask these same questions to SQL job candidates. Either way, knowing these questions is a first step to learning SQL.

Karolina Niewiarowska

How to Show Your Sql Experience

Do you want to work in the IT industry? This is now one of the best ideas for a good career. What should convince you to do so? Demand for specialists, high earnings, and the fact that it is a future-proof profession. Interestingly, it's not gonna be that hard – especially for you, smartie! You just need some skills and good preparation for an interview to be successful. I'll tell you how to land a great job!

LearnSQL.com Team

LearnSQL Track of the Season: SQL from A to Z

The ability to analyze data is one of the most sought-after skills in job applicants. Why? Because all organizations want to take advantage of the power of data. And one of the basic tools for that is SQL! See why we have chosen the SQL A to Z track as our track of the season. This fall, take your analytical skills to the next level! Let's start with the basics.

András Novoszáth

Why You Should Use SQL in Marketing Analytics

Have you been wondering how you could use SQL in your marketing data analysis work? Would you like to create SQL reports to guide your marketing decisions? In this article, you will learn how to use SQL for marketing through plenty of use cases. Are you a marketing professional wanting to better understand the results of your marketing efforts? Do you want better means to prove your point and demonstrate the value you create?

Karolina Niewiarowska

How Hard Is It for People Without IT Experience to Learn SQL?

Learning SQL doesn't have to be difficult! Taking an interactive SQL course is a great way to start your career in the high-paying world of IT. When you started your adventure with computers, you surely didn't realize how far you could go. You were probably only a few years old, and your first experience with a computer was probably gaming. Today, computers provide more than just quick access to entertainment; they’re a great tool for earning money.

Jakub Romanowski

Free Course of The Month – Revenue Trend Analysis in SQL Server

It is impossible to run a business without a good analysis of revenue trends. But how do you do it effectively? You can rely on good old Excel, but a much better idea is to use SQL and databases. Learn how to create SQL reports and track the growth of your business with MS SQL Server. Here is the course, Revenue Trend Analysis in SQL Server. It’s FREE throughout September!

Dorota Wdzięczna

SQL MIN and MAX Functions Explained in 6 Examples

What are the SQL MIN() and MAX() functions? When should you use them as aggregate functions, and when should you use them with window functions? We explain using practical examples. It’s difficult to imagine SQL without the MIN() and MAX() aggregate functions. They are very useful among many data professionals because they allow us to resolve a lot of business problems. In this article, I will explain what each function does and discuss several use cases.

Marcin Koryszewski

How Much Do Data Analysts Earn in 2021?

How Much Do Data Analysts Earn in 2021? How much does a data analyst earn? We did some data analysis ourselves. Nothing fancy, but it will give you some extra motivation for learning SQL for your data analyst gig. Data, data everywhere! We live in the world of (big) data. Having data is just the first step. Knowing what to do with it, how to interpret it, and what insights it holds, is true greatness.

Tihomir Babic

3 Real-Life Business Questions That Are Perfect for SQL Common Table Expressions

We answer three SQL business questions using CTEs. There are business problems that are often solved in a very roundabout way. While they might get you the correct result, there’s usually a more elegant way to write a solution. Enter the CTEs! They are extremely helpful when it comes to getting a more direct and elegant solution. I’ll show you three business situations where CTEs can be very helpful. You’ll get an idea of when CTEs can be useful.

Jakub Romanowski

Why Is the SQL Practice Set my Favorite Online Course?

My friends know that I cannot sit still. I always have to do something, read something, and learn new stuff. It's stronger than me. But I don't complain, because this approach has only helped me in my life. I have done a ton of different online courses, but the SQL Practice Set has proved to be the best so far. Find out why. Learning SQL was not easy for me.

Jakub Romanowski

Best SQL Courses for Business Owners

Do you have a business? Can you use the data you collect every day? You would probably do anything for it to succeed. Learn SQL and achieve your goals. Here are the best online SQL courses for business owners. SQL is a great tool that allows you to work with databases. Are you looking to acquire a skill or two to help your business grow? SQL is the answer!

Himanshu Kathuria

The SQL AVG() Function Explained With Examples

We explain the SQL AVG() function with practical examples, covering how and where you can and cannot use it. The average is probably one of the most widely used metrics to describe some characteristics of a group. It is so versatile and useful that it can describe something about almost anything. If you like sports, you see things like average runs per game in baseball, average assists per game or per season in basketball, and so on.

Kateryna Koidan

5 Practical SQL CTE Examples

Common table expressions (CTEs) were introduced into SQL to improve the readability and the structure of SQL queries, especially those requiring multiple steps to get the necessary output. In this article, we will go through several examples to show how SQL CTEs can help you with complex calculations and hierarchical data structures. Common Table Expressions in SQL Common table expressions (CTEs), also called WITH clauses, allow creating named subqueries that are further referenced in the main query.

Himanshu Kathuria

How to Use CASE in SQL

If you need to evaluate multiple conditional statements, the SQL CASE statement will do the job. Here’s what you need to know to use CASE like a pro. Why is CASE so important in SQL? If you’re analyzing or manipulating data, you’ll often want to define rules based on certain conditions, e.g. if an employee’s performance is above average, give them a 10% raise; if it is outstanding, give them a 15% raise; otherwise, give them a 5% raise.

Kateryna Koidan

How to Join Two Tables by Multiple Columns in SQL

The SQL JOIN is an important tool for combining information from several tables. Most often, you’ll be joining tables based on a primary key from one table and a foreign key from another table. However, it is also often the case that you need to join tables by two or more columns. In this article, I’ll discuss why you would want to join tables by multiple columns and how to do this in SQL.

Martyna Sławińska

An Overview of MS SQL Server Data Types

SQL Server data types define what can be stored in a column, local variable, expression, or parameter. It is essential to pick the right data type. Ultimately. your choice of data types affects the whole database. Read on to learn about all of the data types available in MS SQL Server. In this article, we’ll cover numerical, text, and date and time data type categories in detail. We’ll go through their syntax, storage size, and typical use cases.

Tihomir Babic

How to Find the Nth-Highest Salary by Department with SQL

Learn how to find the nth-highest salary in SQL, and you’ll learn how to get the nth value in any data. In this article, I’ll focus on one problem and give you several solutions to that problem. The problem is stated in the title already: find the nth-highest salary by department using SQL. This may sound too specific. But by learning how to solve this, you’ll be able to find the nth value in any data, not just salaries.

Andrew Bone

What Is the UPDATE Statement in SQL?

The SQL UPDATE statement is used to update existing data in your database. This article will explain its syntax and show you clear examples of the UPDATE statement in action. Effectively updating existing data in a database is required for anyone using SQL; data is only useful if it is kept up-to-date and relevant. In this article, we’ll examine the syntax of the UPDATE statement in great detail. Then we’ll dive into detailed step-by-step examples that will drive home the rules, potential uses, and limitations associated with the SQL UPDATE statement.

Karolina Niewiarowska

I Needed a Good SQL Course… So I Chose SQL Basics.

Why did I decide to take a SQL course? And how did I come across LearnSQL.com? It’s story time! Did I ever think that my professional career would deal with databases? Absolutely not. It didn’t even cross my mind that it would happen. Let me explain why I started learning SQL … and how I got to where I am today. Meet the SQL Newbie I suppose few people have their lives planned from A to Z.

Ignacio L. Bisso

How to Define a Window Frame in SQL Window Functions

The window function is a super powerful resource of the SQL language. At the core of any window function, there is a set of records, called the window frame, defined using an OVER clause. Knowing what records are in the window frame, how they are ordered, and what their upper and lower bounds are, are critical in understanding how window functions work. In this article, we will analyze and explain with examples how you can define different types of window frames.

Andrew Bone

Use SQL on a Movie Database to Decide What to Watch

We’ll demonstrate how to use SQL to parse large datasets and gain valuable insights, in this case, to help you choose what movie to watch next using an IMDb dataset. In this article, we’ll be downloading a dataset directory from IMDb. Not sure what to watch tonight? Are you browsing Netflix endlessly? Decide what to watch using the power of SQL! We’ll be loading an existing movie IMDb dataset into SQL.

Jakub Romanowski

Free SQL Course of the Month – Creating Basic SQL Reports in SQL Server

This is another in our series of free SQL Courses of the Month. This time, you can learn SQL Reporting in MS SQL Server for free. Do you want to be able to prepare even better SQL reports? Or maybe you have some basic knowledge of SQL Server (one of the major SQL dialects) and would like to go a step further? This is the course for you.

Himanshu Kathuria

New to Data Engineering? Don't Make These Mistakes

It's best to learn from the mistakes of others. This advice also works for data engineering. In this article, you'll find tips to help you advance your career and avoid common data engineering mistakes. The data revolution has produced tremendous opportunities and created various high-paying jobs related to the collection, maintenance, and manipulation of data. Data engineering is one of the most lucrative and interesting jobs of this family.

Michal Stín

SaaS KPI Metrics, Part 1: Using SQL to Calculate Customer Lifetime Value (LTV) and Related Metrics

Working with data is an essential skill for marketers in today's data-driven world. As a marketer myself, I decided to create a series of articles about calculating key performance indicator (KPI) metrics for SaaS (Software as a Service) companies. We’ll start by calculating customer lifetime value (LTV) using SQL. Data is one of today’s most valuable resources. If you work in a SaaS company, you are flooded with a huge amount of data every day.

Zahin Rahman

An Overview of SQL Text Functions

In this article, we will discuss the ins and outs of the most common SQL text functions, which make it possible for you to find and work on string values. Before we dive into text functions, let’s quickly recap what an SQL function is. Simply put, a function is a predefined built-in piece of code that you can use in your SQL query. For example, the functions SUM(), AVG(), and COUNT() are applied to numerical variables to calculate the sum, average, and number of records respectively.

Jakub Romanowski

How Will a SQL Course Improve the New Employee Onboarding Process?

Are you looking for something to improve the onboarding process of new employees at your company? If they will be working with databases and SQL, and if you need resources for them to learn quickly, choose interactive SQL online courses. You’ve just hired some new employees. Great! After a long recruitment process, you have finally managed to find people who can do the job and meet your expectations. You may have even used our advice on why it makes sense to Practice SQL Before Interviewing a Potential Employee.

Dorota Wdzięczna

SQL SUM() Function Explained with 5 Practical Examples

Aggregate functions are an important part of SQL knowledge – and there’s no better place to start learning them than with the SUM() function. In this article, you can expand or refresh your SQL with 5 practical examples of SUM(). SQL allows us to do more than select values or expressions from tables. Most operations on relational databases use aggregate functions like SUM() to do computations on data.

Kateryna Koidan

What Is the Difference Between WHERE and ON in SQL JOINs?

When you join tables in SQL, you may have conditions in an ON clause and in a WHERE clause. Many get confused by the difference between them. In this article, we will discuss this topic by first reminding you the purpose of the ON and WHERE clauses then by demonstrating with examples which types of conditions should be in each of these clauses. Both the ON clause and the WHERE clause can specify conditions.

Tihomir Babic

How to Keep Unmatched Rows When You Join two Tables in SQL

Learn how to use JOIN to keep both matched and unmatched rows when you join two tables. Joining two or more tables is a skill you need a lot if you’re working with databases. To review and practice your SQL joining skills, I recommend the interactive SQL JOINs course. It contains over 90 exercises and sections on different joining challenges. If you often join tables in SQL, you’ve probably noticed not all data from one table corresponds to data from another table all the time.

Ignacio L. Bisso

Top 10 SQL Window Functions Interview Questions

Many interesting job positions require SQL skills – and that includes window functions, which are not commonly taught in online courses. In this article, I will cover the top window function questions for every experience level. If you’re going for a job interview for an advanced SQL position or for intermediate to advanced data analyst positions, you’ll probably be asked about your knowledge of SQL window functions. Don’t panic! Although these functions aren’t commonly covered in online courses, we’ve got the answers right here.

Kateryna Koidan

5 Reasons Why You Should Use CTEs Instead of Subqueries

Common Table Expressions, or CTEs, were introduced in SQL:1999 to handle cases where the output of one query is used within another query. But didn’t we already have subqueries for this? In this article, I’ll demonstrate with multiple examples why CTEs are better than subqueries for the structure and readability of your SQL queries. Let’s start by reminding ourselves what CTEs and subqueries are and how they differ. Common Table Expressions vs.

Jakub Romanowski

SQL Track of the Season: SQL Reporting in MS SQL Server

It's the best time of the year for a change! Learn something new and boost your career! This is our SQL Track of the Season: SQL Reporting in MS SQL Server! In this article, we’ll answer common questions about this track. Summer is here. Does the sun make you want to learn something new? Maybe surfing or Portuguese? Maybe you've wanted to learn crocheting all your life? Follow your dreams!

Andrew Bone

What Is the SQL GROUPING SETS Clause, and How Do You Use it?

GROUPING SETS are groups, or sets, of columns by which rows can be grouped together. Instead of writing multiple queries and combining the results with a UNION, you can simply use GROUPING SETS. GROUPING SETS in SQL can be considered an extension of the GROUP BY clause. It allows you to define multiple grouping sets in the same query. Let’s look at its syntax and how it can be equivalent to a GROUP BY with multiple UNION ALL clauses.

Kamila Ostrowska

Best SQL Certifications for Leveling up Your Career

Career If you want to build and strengthen your position in the IT industry, you should look into these SQL certifications. We always encourage you to learn, to gather new skills and experience. Training is really important; without it, you will not make much progress if you want to advance in IT or specifically in the SQL industry. That said, you also need something that can validate your competencies, like SQL certifications.

Andrew Bone

What Is the INSERT Statement in SQL?

The INSERT statement in SQL is used to add new data to your database. This article will explain how to use it and show you practical examples along the way. When you learn SQL, you focus on getting data out of a database, working mostly with SELECT. In SQL, there are also statements that let you modify data in a database. The first one is the INSERT statement: it adds data to a table.

Martyna Sławińska

What Is the Difference Between a Primary Key and a Unique Key?

When designing a database, we often need to decide between defining a primary key vs. a unique key. Both of them are crucial during the design and further phases of a database. They allow us to uniquely identify each row, ensure the uniqueness of values in the column(s), and more. Let’s take a deep dive to learn more. This article will go through the primary and unique keys, their functions, and features.

Tihomir Babic

The RANGE Clause in SQL Window Functions: 5 Practical Examples

What is a RANGE clause in SQL window functions? Five practical examples will show you how and when to use it. The RANGE clause is used quite rarely in SQL window functions. I don't know why; maybe people are not used to it. This is a shame, because it's far from a pointless clause; it can be very useful, and I'll show you that in five examples. RANGE Clause Syntax When I'm talking about the RANGE clause, I'm talking about the one used in SQL window functions, which have the following syntax:

Karolina Niewiarowska

How to Learn SQL Faster

Struggling with learning SQL? Does it seem like you’re doing everything right, but not making progress as fast as you’d like? Don't worry, I'll help you. Here are some tips for learning SQL quickly and painlessly. Are you wondering how to learn SQL faster? If so, I’m here to help with some practical tips. And once you’ve found the right motivation and the right sources of knowledge, you’ll be able to learn faster.

Jakub Romanowski

Free Course of the Month – Recursive Queries in MS SQL Server

Do you want to become a SQL expert? To do this, you need to learn SQL CTEs or Common Table Expressions. They can make your queries clearer and more readable. And during July 2021, you can learn CTEs for free using our interactive Recursive Queries in MS SQL Server course! How can you get this free SQL course? Create a free LearnSQL.com account or log in if you already have one.

Zahin Rahman

Top 15 SQL Interview Questions in 2021

If you are on the lookout for a job in the field of data, you’re almost guaranteed to face SQL interview questions. You might even be asked to complete some kind of SQL coding test. According to KDnuggets, irrespective of the specific role in data – data analyst, data engineer, data scientist, or business intelligence analyst – SQL lands in the top three skills found in postings across Indeed, SimplyHired, and Monster.

Kate Stolarek

Skills Every Data Analyst Should Have

If you’re a student looking for career advice or a specialist seeking new job opportunities, find out if a data analyst job is something worth considering. In today's article, I explain the essential skills required for data analysts and benefits that come from performing such a job. What Is a Data Analyst? Let’s start by defining exactly what a data analyst is. A data analyst is someone who uses their skills to collect, analyze, and report insights from company data.

András Novoszáth

Data Analyst vs. Data Engineer: A Full Comparison

Do you want to become a data analyst? Or maybe you dream about being a data engineer? Can't make up your mind? I'll help you. Read about the two roles’ history, their market situation, and the skills you need to become one. You already know that it's a good idea to enter the data world and work with databases. But how to do it? Behind which door is the better career waiting for you?

Jakub Romanowski

New Basic SQL Practice Course on LearnSQL.com

Hey, did you hear that there’s a brand-new Basic SQL Practice course on LearnSQL.com? This is a great opportunity to refresh your SQL, write some queries, and take your analytical skills to the next level. We’re proud to introduce Basic SQL Practice: A Store! Where did the idea for this new SQL practice course come from? From our users! They’ve let us know that they need more hands-on SQL exercises at a beginner level.

Kateryna Koidan

Do You Need to Learn SQL To Become a Programmer?

SQL is primarily used by database administrators (DBAs), business analysts, and data analysts. But what about other programming roles? In this article, I’ll show how software engineers, web developers, and app developers use SQL and why you need to learn SQL to become a programmer. Like many other aspiring programmers, you are probably wondering “Do I need SQL?”. To answer this question, you should know that you’ll encounter data everywhere in software development.

Himanshu Kathuria

Why Does Your Company Need Data Analysis?

Data is the new gold. That is what the biggest in the business say, knowing the value of the data, the analyses, and the conclusions they bring. If you are wondering why your company needs data analysis and what value it could bring to your business, then this article is for you. Historically, many companies have gone into analytics mainly through financial and accounting data to improve revenue, reduce costs, and eventually increase profitability.

Martyna Sławińska

An Overview of PostgreSQL Data Types

It’s vital to know what you actually store in your database. That’s why every column has its data type. There are numerous PostgreSQL data types across various categories. Read on to see which data type suits which use case! In this article, we’ll go through the most common data types used in PostgreSQL. PostgreSQL, also called Postgres, is a well-known open-source object-relational database management system (DBMS). It is SQL-compliant, extensible, and includes all standard relational database features, such as database constraints, transactions, views, triggers, stored procedures, and more.

Kamila Ostrowska

SQL Terms Beginners Should Know - Part 4

Here it is – another batch of must-know SQL terms. In the first two parts, we covered tables, relational databases, queries, aliases, SQL JOINs, primary keys, and subqueries. Last time, we moved to more advanced terms like INSERT INTO, GROUP BY, and HAVING. Are you ready to dive deeper into SQL terminology? This is the fourth installment of our series on basic SQL terms for beginners (and everyone else). Don’t worry if you missed the previous articles; you can find Part 1 (essential SQL terms), Part 2, and Part 3 in our blog.

Tihomir Babic

Business SQL: How to Calculate Revenue Growth in SQL

Can you use SQL in business? Of course you can! For example, you can calculate revenue growth in SQL – here’s how. As someone who works with data, you already know that SQL is the most used tool in data analysis. But how is SQL helpful in business use? Well, the answer is obvious: analyze business data using SQL! However, there are some specifics with business data that can be tricky if you’re not used to it.

Jakub Romanowski

I Took the SQL Basics Course... Here's What Happened!

In this article, I will share my personal story with you. But don't worry – it's not about a scandal or a sad story of failure. I'll tell you how a successful news journalist fell in love with SQL. It all started when I took the SQL Basics course at LearnSQL.com. There are moments in life that change everything. Mine happened when I decided to give up my long-term career and start a completely new chapter in my professional life.

András Novoszáth

What Is the SQL HAVING Clause?

Are you learning SQL? Are you wondering what you can use the HAVING clause for? Or, perhaps, have you tried to use WHERE on your GROUP BY aggregates? You are in the right place! In this article, we explain how to use HAVING with plenty of examples. Have you tried to filter your metrics you created with GROUP BY with a WHERE clause and found out that it did not work?

LearnSQL.com Team

Who Will Win UEFA Euro 2020? Pick Your Team And Get a Refund!

This is one of the most important sporting events of this year. UEFA Euro 2020 is here! Are you a soccer fan? Cheer on your favorite team and get rewards. Become the SQL Champion! We waited a long time for the European football championship. Due to the Covid-19 pandemic, they were postponed. Fans around the world had to be patient. But the wait is over, the soccer feast begins!

Tihomir Babic

Fun With SQL: How to Generate a Picture Using Recursive SQL Queries

Did you know that SQL can be used for fun? You can even ‘draw’ in SQL using recursive queries! Find out how in this article.  As an SQL user, you already know this language is great for data analysis and data manipulation in general. This is something people get very serious about. But you can also have fun with it by drawing ASCII-art pictures using the SQL code. To do that, you have to know how recursive SQL queries work.

Kateryna Koidan

4 Simple Ways to Finally 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.

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.

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 division operator in SQL is considered an arithmetic operator. The arithmetic operators are addition (+), subtraction (-), multiplication (*), division (/), and modulus (%). This article will focus on the division operator, discussing the rules that must be followed along with some common mistakes to look out for when trying to divide in SQL.

Tihomir Babic

Top 10 SQL JOIN Articles for Beginners

Can’t find your way around the vast number of SQL JOIN articles? We’ve chosen ten JOIN articles that are worth beginning SQLers’ time. You probably know that there are many articles covering SQL JOINs. Some can be confusing because they assume pre-existing knowledge. Others are not written clearly and can leave even advanced users bewildered. The 10 SQL JOIN articles I’ve chosen are entirely the opposite. They’re written clearly and have some nice examples and visualizations.

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.

Jakub Romanowski

Free Course of the Month – GROUP BY Extensions in MS 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?

Andrew Bone

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

Difference? UNION and UNION ALL are both used to retrieve records from multiple tables. This article will detail the differences between the two, allowing you to make the best choice for each unique scenario. You can use SQL’s UNION and UNION ALL commands to get data from multiple tables in your database. It’s a common use case, considering that most databases have many tables. Both UNION and UNION ALL are known as set operators.

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! 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. I will tell you where to find data analyst internships and what you should know about them. That's right! To gain experience, you need experience – especially when you’re entering the labor market or embarking on a new career.

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.

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.

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.

Martyna Sławińska

What’s the Difference Between UNIQUE and DISTINCT in SQL?

We use the words unique and distinct interchangeably in our day-to-day life. However, these words play very different roles in SQL. Let’s find out what is so different about them and how we can use them in SQL. Despite the words unique and distinct being synonyms, they cover very different things in SQL. The UNIQUE keyword in SQL plays the role of a database constraint; it ensures there are no duplicate values stored in a particular column or a set of columns.

Andrew Bone

How to Use Aliases in SQL Queries

An SQL alias is useful for simplifying your queries and making the query and its result more readable. This article explains why and how you can use aliases in your SQL queries. You can temporarily rename a table or a column by giving it another name. This is known as an SQL alias. It’s a temporary change that does not affect the actual table name in the database. A temporary table name can also be called a correlation name.

James Wondrasek

How to Use Comparison Operators with NULLs in SQL

The SQL NULL value serves a special purpose. It also comes with counterintuitive behaviors that can trip up SQL beginners or even experienced programmers. Learn how to avoid these problems when you use NULL with comparison operators. This article is going to help you master best practices for crafting SQL queries that work with NULL values and use comparison operators ( =, <>, <, > ) – which, if you have written any SQL queries before, you know is just about every query you will ever write!

Kateryna Koidan

A Detailed Guide to SQL ORDER BY

It’s often necessary to display the output of SQL query in specific order rather than arbitrarily. In this article, I’ll explain the many ways you can do it with the SQL ORDER BY clause. To sort records in SQL, you’ll need to use the ORDER BY clause.  In this article, I’ll explain in detail how to use ORDER BY to sort output by one or more columns, in ascending (A-Z) or descending (Z-A) order, and by using existing column(s) or using column(s) calculated by an aggregate function.

Kamila Ostrowska

The Best Books for Data Engineers

Are you tired of staring at a computer all day? Maybe it’s time to read a book. Take a moment to check out our list of recommended books for data engineers. They will help you deepen your knowledge about databases. Last year, we shared a list of the best books to learn SQL. This time, I want to introduce five books for data engineers. They are worth reading and will help you learn more about databases.

Karolina Niewiarowska

Best Online SQL Courses for 2021

In this pandemic era, it's no surprise that online learning has become even more popular. To help you narrow things down, I’ve prepared a list of 2021’s 10 best online SQL courses. Find out where you can learn SQL effectively! The number of online courses on offer – especially in the tech industry – is now impressive. You can find something that suits your interests, competences, and professional ambitions. But how do you know which to choose among the many online SQL courses out there?

Zahin Rahman

What Is the WITH Clause in SQL?

In this article, you will learn about the SQL WITH clause, also known as common table expression (CTE). We will go over some examples to demonstrate some of their use cases in light of their benefits. Introduction to the SQL WITH Clause The WITH clause in SQL was introduced in standard SQL to simplify complex long queries, especially those with JOINs and subqueries. Often interchangeably called CTE or subquery refactoring, a WITH clause defines a temporary data set whose output is available to be referenced in subsequent queries.

Jakub Romanowski

Want to Work With Data? Learn SQL!

Are you looking for a database job? How are things working out? If you don't know what to do, I suggest you start by learning SQL. Here’s why. In this article, I’ll explain how you can succeed at finding a database job. If you are tired of your current job and fed up with your boss (who hasn't given you a raise in years), read on. Stay with me too if one more stupid Zoom call will make you scream.

Kateryna Koidan

A Guide to SQL Common Table Expressions

Common table expressions are a relatively new SQL feature that is sometimes overlooked by experienced practitioners working with relational databases. Don’t be one of them! Learn how to use SQL CTEs and join the many data analysts enjoying the benefits of this great tool. Common table expressions (CTEs), also known as WITH clauses, are used to create named subqueries that can be referenced in the main query. CTEs are not saved for future use and can be referenced only within the query where they are defined.

LearnSQL.com Team

SQL Course of the Month – SQL Practice Set

Are you starting your adventure with SQL and looking for a place to practice your SQL queries? Or maybe you are preparing for a job interview? I have good news for you. Throughout May, you will have access to our amazing SQL practice course for FREE! Why is LearnSQL.com giving you a free SQL course? Every month, our users get the opportunity to take one of our great SQL courses for free.

LearnSQL.com Team

Star Wars Day 2021

May 4th is here! And that means one thing - World Star Wars Day. We're fans of the Skywalker saga, and we're proud of it! That’s why we’ve decided to celebrate the anniversary of the premiere of the best film franchises in the history of cinema! Hello young Padawan, you have come to the planet Coruscant at the Jedi Temple to study. You want to become a lightsaber and of the force master to tame the databases and defeat the Sith in a data battle.

Ignacio L. Bisso

Why Do You Need a Primary Key in a Database Table?

What is a primary key and why is it so important in SQL? Find out in this article. Primary keys are a central element in SQL databases. They provide a unique value that can identify a specific row in a table, which opens up a lot of other benefits. This article covers what a primary key is, how it works, and how to use it in an SQL database.

LearnSQL.com Team

Breaking With Filing Cabinets: The History of PostgreSQL

This July, PostgreSQL turns 25. It has had an extensive influence on computing. Thanks to PostgreSQL, the world said “Goodbye!” to filing cabinets as the standard for storing and processing data. So, who created PostgreSQL, and how has it changed over the decades? There are quite a few PostgreSQL enthusiasts among my colleagues at LearnSQL.com. It is simply a great database solution. Why? It is free and open-source. So, you can use it for free, even for commercial uses.

Martyna Sławińska

What Is the Benefit of Foreign Keys in SQL?

What is a foreign key and why is it so important in relational databases? Learn all the details about foreign keys in this article. One of relational databases’ key features is the ability to link data stored in different tables. These links, called references, essentially act as connections between tables. They are created using the FOREIGN KEY constraint on table columns. In this article, we’ll learn what the FOREIGN KEY constraint does in SQL.

Andrew Bone

What Is the Role of DISTINCT in SQL?

The DISTINCT keyword in SQL plays an important role in removing duplicate values from your results. This article provides examples showing exactly how DISTINCT works. By default, SQL queries show all the returned rows, including duplicate rows, in the result set. The DISTINCT keyword in the SELECT clause is used to eliminate duplicate rows and display a unique list of values. In other words, the DISTINCT keyword retrieves unique values from a table.

Tihomir Babic

Training SQL JOINs Doesn't Have To Be Difficult

How can you train your SQL JOIN skills? And where can you do this? Also, why should you even learn SQL JOINs in the first place? All of these questions will soon be answered. One of the positive sides of the internet era is information abundance. One of the negative sides of the internet era is, well, information abundance. The amount of information and knowledge available can be overwhelming.

Andrew Bone

What Do the SQL INTERSECT and MINUS Clauses Do?

Do you know the difference between SQL’s INTERSECT and MINUS clauses and how to use them? You will find examples and explanations in this article. SQL INTERSECT and MINUS are useful clauses for quickly finding the difference between two tables and finding the rows they share. INTERSECT compares the data between tables and returns only the rows of data that exist in both tables. MINUS compares the data between tables and returns the rows of data that exist only in the first table you specify.

Tihomir Babic

Hierarchical Data and How to Query It in SQL

How do you recognize hierarchical data, and how do you query it? Two common SQL questions are about to be answered. Querying hierarchical data is a rather common situation if you’re working with SQL and relational databases. Not that hierarchical data is something mystical and rare; on the contrary, it’s everywhere. So why is hierarchical data so challenging when it comes to relational databases? Mainly, the difficulties occur in translating hierarchical data to relational database principles.

Himanshu Kathuria

Analyze, Get Insights, and Make Money: SQL Data Analysis for Small Datasets

If you think SQL data analysis is useful only when a business is generating millions of rows of data – that SQL cannot help you if you are generating a limited dataset – think again and read on! There is so much talk about how SQL is useful in analyzing Big Data that sometimes the applications of SQL data analysis for small datasets can go unnoticed. Having worked with early-stage businesses – which have just started generating data through daily transactions – as well as big established clients generating terabytes of data, I can tell you for sure that SQL can be an extremely handy tool for just about any business.

Karolina Niewiarowska

Does Music Improve Work Efficiency?

Do you sometimes have trouble focusing when working or studying? Do you ever lack motivation? I have the perfect solution for you. Music! I am excited to tell you about how music can influence your efficiency. Music can soothe the savage beast, they say. It can also inspire action. In general, music is an important element of human life. Most activities are just more enjoyable with background music. However, listening to music while studying or working is a bit different.

Kamila Ostrowska

Who Should Learn SQL?

If you learn SQL, will you use it in your current (or dream) job? If you learn it, will it help you with your daily tasks? SQL has so much potential that everyone can benefit from it – including you! Read this article to find out how much you will gain by knowing SQL. I could answer the title question with one word: everyone! But not everyone wants to learn SQL.

Zahin Rahman

What FULL JOIN Is and When to Use It

Learn about FULL JOIN, how to implement it, how it compares with the other types of SQL JOINs, and some of its unique use cases. Before we jump into FULL JOINs, let’s quickly recap what an SQL JOIN is. At its core, a JOIN combines data from two or more tables within a database. Tables are usually linked together using unique identifiers in each table, i.e. primary and foreign keys.

Kateryna Koidan

7 SQL JOIN Examples With Detailed Explanations

Do you need to join several tables to get the necessary result set? The SQL JOIN is a basic yet important tool used by data analysts working with relational databases. And I understand it can be difficult to choose from the zillions of introductory guides to joins. In this article, I will focus on real-world examples with detailed explanations. Introduction to JOIN With relational databases, the information you want is often stored in several tables.

Zahin Rahman

SQL CTE Explained

In this article, you will learn about SQL Common Table Expressions (CTEs). This powerful SQL tool will help you simplify complex queries. Additionally, I will introduce you to the two main types of CTEs and some of their use cases.  CTE Primer The Common Table Expression (CTE) was introduced to standard SQL to simplify long, complex queries (especially joins and subqueries). It is a temporary data set returned by a query that contains data separate from the main query.

Jakub Romanowski

SQL Track of the Season: SQL Fundamentals in PostgreSQL

Are you ready for a new challenge this spring? Check out our SQL Track of the Season: SQL Fundamentals in PostgreSQL! In this article, we’ll answer common questions about this track. It’s getting warmer. The flowers are slowly beginning to bloom. This can mean only one thing – spring is here. The world is coming to life after its wintertime lethargy. This is a great time for new challenges. Do you want to add something to your skillset?

Tihomir Babic

How to Find the Next Non-NULL Value in SQL

You need to find the next non-NULL value in a time series, but you don’t know how. Can you even do that in SQL? Yes, you can! This article will show you what to do. If you work with SQL, you will sooner or later confront NULL values. Having NULLs in a database is almost unavoidable. However, sometimes you want to avoid them in your reports. This is quite often true when you’re analyzing time series data; NULL values mean there’s no data available.

Kateryna Koidan

What Is the RANK() Function in SQL, and How Do You Use It?

Who are your top 10 customers? Who are the top-performing employees in each department? To answer questions like these, you’ll need to rank the output of your SQL query. Let’s see how the RANK() function assists with ranking results in SQL.   There are many use cases in which you might need to rank rows in SQL. You may want to rank customers based on the sales volume, students based on their exam results, company assets based on their present value, departments based on the number of employees, or users based on their date of registration.

Jakub Romanowski

Free SQL Course of the Month – Creating Basic SQL Reports

Do you want to create good SQL reports from scratch? Are you looking for a course that will help you spread your analytical wings? What if I told you that throughout April 2021, you could access one of the best SQL Reports courses for FREE? Here it is: Creating Basic SQL Reports. What's the catch? There is none. LearnSQL.com provides one of their courses for free from time to time.

Andrew Bone

What Is CASE in SQL?

SQL CASE is a very useful expression that provides if-else logic to your SQL queries. It’s a slightly more advanced topic, but you’ll need it when preparing reports – it will deliver massive value to your personal and professional projects. The SQL CASE statement is a control flow tool that allows you to add if-else logic to a query. Generally speaking, you can use the CASE statement anywhere that allows a valid expression – e.

Jakub Romanowski

Where to Practice JOINs in MS SQL Server

Are you tired of looking for exercises that will help you master SQL JOINs in MS SQL Server? Find out about an online course that will take your JOINs skills to the next level! There are tons of MS SQL Server courses out there. Some are good, although they often lack the most important thing ... the possibility of practicing what you learn with interactive exercises. This is one of the main reasons I advise people (especially beginners) not to learn SQL exclusively from YouTube clips.

Dorota Wdzięczna

How to Install Microsoft SQL Server 2019 and SQL Server Management Studio

Do you want to install SQL Server 2019 on your Windows PC? How about the latest version of SQL Server Management Studio? I’ll walk you through the process. Soon you’ll be writing T-SQL queries and operating on SQL Server databases! As I write this article, Microsoft SQL Server 2019 is the latest version of SQL Server. It’s the 15th version of one of the most popular database servers in the world.

Jakub Romanowski

Is MS SQL Server Still Worth Learning in 2021?

There are some open-source database solutions for MS SQL Server. Some have more support from the online community, and others may run faster in certain situations. Nevertheless, MS SQL Server is still hot and is not going anywhere. Is it worth learning MS SQL Server in 2021? In this article, I will try to answer this question. Read on. What is MS SQL Server? Let's start with the basics. You've probably heard that MS SQL Server is a popular Relational Database Management System (RDBMS).

Ignacio L. Bisso

What Is a NOT NULL Constraint in SQL?

SQL has several ways of dealing with NULLs. In this article, we’ll focus on the NOT NULL constraint and other NULL-related clauses. Understand this and you’ll take an important step in your SQL growth! Before we get straight into the NOT NULL constraint, let’s quickly define what NULLs and constraints are. NULL values are a central concept in SQL databases. The idea behind a NULL value is simple: a NULL value means that we do not have a known value for that field.

Kamila Ostrowska

Best SQL IDEs for You in 2021

Maybe you just started learning SQL. Maybe you already have some experience. Whatever your situation is, choosing the right IDE for you is another step in your development. Why IDE? IDE stands for integrated development environment. It is a software application that enables us to combine various aspects of writing a computer program. An IDE usually contains a source code editor, build automation tools, and a debugger. You might ask why you need an IDE when you have the command line available on your computer.

Marija Ilic

7 Real-Life Situations When You Need a Running Total and How to Compute It in SQL

Do you want to learn what a running total is and how to compute it SQL? In this article, I will describe different business scenarios in which a running total is needed. I will also teach you how to calculate a running total in SQL with the help of window functions. Ready? Let’s go! Running Total Definition A running total is the cumulative sum of a value and all previous values in the column.

Jakub Romanowski

Want to Learn GROUP BY Extensions in PostgreSQL? You've Come to the Right Place!

Do you want to take your knowledge of PostgreSQL to the next level? I have something for you: LearnSQL.com’s new GROUP BY Extensions in PostgreSQL course! It will help you get even more out of your data and create better reports and summaries. Fasten your seat belts and prepare to see what GROUP BY can do when it’s turbocharged. First, I have to confess something. I am not objective – I think PostgreSQL is the best and coolest SQL dialect.

Gustavo du Mortier

What Is a NULL in SQL?

SQL uses NULLs as a special flag that signals the lack of a value for a field or a variable. NULLs should be used wisely so the database gives a faithful picture of the reality it represents. Some people associate NULLs with zeros; others think that NULL means “none”. In SQL, neither of these are true. Simply put, an SQL NULL means that we don’t have a value for that particular field.

Jakub Romanowski

Give Yourself the Green Light to Learn SQL

Green and shamrocks everywhere and that can only mean one thing: St. Patrick's Day! Whether you are a native of Ireland or not, this is a great time to have some fun. However, when you wake up the next morning with a slight headache caused by too much intense ... céilí dancing, think about what is worth learning. We suggest SQL. This is a really good opportunity to learn the database language that is SQL.

Tihomir Babic

SQL JOIN Topics That Require Practice

Are you interested in learning how to join tables in SQL? Where do you start? Many JOIN topics require practice. In this article, we’ll explore these topics by writing codes to solve real-life situations. Hopefully, you will learn which JOIN topics require attention. To make it easier for you, the topics are divided into beginner, intermediate, and advanced. Joining two or more tables in SQL lifts data analysis to another level.

Jakub Romanowski

Where Can I Find Good Courses to Practice MS SQL Server?

You’ve got the basics of MS SQL Server. Where can you find practice exercises in this SQL dialect? You've started learning MS SQL Server. Maybe you've done a course, watched some YouTube tutorials, and feel pretty confident in your knowledge. What now? Let me tell you, you need to practice. Only by writing queries can you truly master SQL. In this article, I will show you where to find practice MS SQL Server exercises.

Kateryna Koidan

Why the SQL WITH Clause Is Awesome

If you’re not using WITH clauses yet, it’s definitely time to start! SQL WITH clauses, or common table expressions, help improve the structure of SQL queries by making them more readable. That’s already a lot, but WITH clauses have many more benefits. Let’s see together! The WITH clause was introduced in SQL:1999 to define views that are only valid for the query they belong to. Also known as common table expressions (CTEs), WITH clauses allow us to improve the structure of an SQL statement without polluting the database namespace.

Tihomir Babic

How to Get Descendants of a Parent in SQL

Want to learn how to handle family trees and find descendants of a parent? By reading this article, you’ll learn how to handle hierarchical data. Finding descendants from a parent is a common problem in SQL. If you imagine a family tree, the basic building block that forms the relationships within it is the parent-child relationship. The parent-child relationship is precisely what defines all hierarchical data. Another example of hierarchical data is the manager-employee relationship.

Andrew Bone

What Do the Operators LIKE and NOT LIKE Do?

The SQL LIKE and NOT LIKE operators are used to find matches between a string and a given pattern. They are part of standard SQL and work across all database types, making it essential knowledge for all SQL users. Gaining an understanding of these operators will allow you to write better queries and demonstrate to potential employers that you have the skills required to filter through expansive data sets.

Kateryna Koidan

How to JOIN Tables in SQL

Do you need to display data stored in different tables? Then it’s time to use SQL JOINs! This can be a challenging topic for beginners, so I’ve prepared this comprehensive step-by-step guide on joining tables in SQL. Often, the information that you want to display is stored in several tables. In such cases, you’ll need to join these tables by specifying which rows should be combined with other rows. That’s exactly what JOIN does.

LearnSQL.com Team

Free SQL Course of the Month – Window Functions

Are you looking for a good SQL window functions course? What if I told you that throughout March, you could access the best window functions course in the world for absolutely FREE? You read that right: you won't pay a dime! Hurry up! Time is running out! But wait – why is LearnSQL.com giving you a free SQL course? Well, we believe sometimes you just have to be good to others.

Martyna Sławińska

MS SQL Server vs. PostgreSQL: Which Should You Choose for a New Project?

Choosing the DBMS you will use for a new project is a very important and difficult decision. Two popular choices are MS SQL Server and PostgreSQL. To help you decide which would be best for you, I'll compare their features, list pros and cons, and give you some examples. Your selection of database management system (DBMS) depends on the type of business or project you're implementing. First, you need to know:

Timothy Edison

How Much SQL Practice Do You Need to Become a Pro?

Are you wondering how long it will take to learn and practice SQL before you can call yourself a pro? In this article, I will try to help you answer this question. Being a pro in SQL can mean many different things. Some people would say that being a professional is about mastery of advanced SQL, i.e. window functions or complex subqueries. For other people, being a professional means getting paid for your skills.

Jakub Romanowski

SQL Terms Beginners Should Know - Part 3

This is the third part of my list of essential SQL terms for beginners. In the first, you learned what tables, relational databases, and queries are. In the second part of the tutorial, I told you about aliases, SQL JOINs, primary keys, and subqueries. Now, it's time for more advanced database terms. But don't be afraid! I won’t crush you with scientific definitions. I will explain everything simply so that you can easily understand.

Kate Stolarek

Use SQL to Filter Your Client Email Database & Organize a B2B SaaS Cross-Promotion

Looking for ways to be on friendly terms with your email database? Here's my way of using SQL to evaluate a promotion. A client database plays an essential role in developing your sales and marketing strategies. Having a clear and well-structured database has several benefits. For example, you can increase your company's revenue by managing your current and new clients – they can be monitored and offered special promotions. Moreover, such an effort develops customer satisfaction and increases value for your current customers.

LearnSQL.com Team

Anniversary of LearnSQL.com

Consider the period from Feb. 23, 2020 to Feb. 22, 2021. A year, 255 working days. Is that a lot of time? Well, it depends. For the LearnSQL.com Team, the time has passed blazingly fast. If someone had told us a year ago that we would be where we are now, we would have said, ‘We wish!’. We had a clear vision and a plan to create the most comprehensive SQL training platform in the world, with the best set of hands-on online SQL courses, and top-notch reading materials.

Karolina Niewiarowska

Learn SQL And Start Your Journey Towards Personal Growth

Are you at the very beginning of your career and don't know what employers are looking for? Maybe you already have a lot of experience, but feel like it's time to change or update your skillset. Learning SQL can be a great choice. Read on and find out why. Regardless of your career stage, you cannot neglect your personal development. Whoever does not move forward falls behind. As you start learning new things, new opportunities will open up for you, both in your personal and professional life.

Kamila Ostrowska

How to Practice PostgreSQL Online

PostgreSQL is hot right now!If you want to join a community of people passionate about data, this open-source database system is something you need to try. Like everything we teach on LearnSQL.com, PostgreSQL requires practice. To profit from Postgres – as this dialect is sometimes called – you need to start with the basics. You can watch some tutorials on YouTube or read articles to get to know what a Database Management System (DBMS) is.

Marija Ilic

What Is GROUP BY in SQL?

GROUP BY is a great SQL feature that allows you to perform powerful calculations on grouped data. Do you want to learn how to get powerful insights from your data? Would you like to know what GROUP BY does and when you should use it? If your answer is yes, keep reading. In this article, you will learn exactly that. Why You Need GROUP BY In today's digitized world – no matter what business you are in – database tables are usually huge, with millions of records.

Jakub Romanowski

Which SQL Books Should You Read in 2021?

Readers keep asking for books that I can recommend to complement our SQL courses. There are quite a lot of SQL books on the market, but only a few are worth your attention. See which SQL-related books to read in 2021. A while ago, I wrote an article about my favorite SQL books for 2020. I chose books about various aspects of working with databases with the goal of helping you get a clear picture of SQL in the real world.

Kateryna Koidan

Enumerate and Explain All the Basic Elements of an SQL Query

“What are the basic elements of an SQL query?” is a popular SQL job interview question. In this article, we review the basic syntax of an SQL query. An SQL query, which requests information from a relational database, consists of several elements. These allow you to select specific columns from specific tables and to filter and sort this information if necessary. In this article, I’ll briefly review these elements by explaining what each element does and how to use it.

Tihomir Babic

Want to Learn Advanced PostgreSQL? Try This!

Why and how should you learn advanced PostgreSQL? I’ll give you some tips that will help you achieve your goals. Keeping up with technology is hard; anyone who has foolishly tried to do so can confirm this (me, for example!). Most of the time, it just doesn't work. And to be brutally honest, keeping up with all the technologies all the time is pointless. You shouldn’t know everything about everything; it’s better to know as much as you need within the technology you use or want to use.

Kateryna Koidan

What Does ORDER BY Do?

When analyzing data, it often helps to have rows ordered in a specific way. In this article, I’ll use multiple examples to show how SQL ORDER BY sorts data according to one or more columns in ascending or descending order. Introduction to ORDER BY By default, the order of rows in the output of an SQL query is arbitrary. If you want to sort the output in a particular order, you’ll need to use the ORDER BY keyword.

Jakub Romanowski

How to Import CSVs to PostgreSQL Using PgAdmin

Do you work with data and use CSV files? Here is a practical guide on how to import such files into a PostgreSQL database using pgAdmin, one of the best PostgreSQL editors on the market. Let's get right into importing CSVs into a Postgres database. We’ll start by explaining what a CSV file is, then we’ll introduce you to pgAdmin and show you how to do the import process. Don’t worry – it’s easy!

Martyna Sławińska

What Is a Unique Constraint in SQL?

To ensure the uniqueness of data in a database, we use the SQL UNIQUE constraint. In this article, we’ll discuss how, when, and why to implement it. The idea of a unique constraint is not unique to SQL; it’s a familiar concept in real life, although we probably call it something else! For example, think of ID numbers. There can be only one social security number (SSN) per person and each one must be unique.

Rebecca McKeown

How Much SQL Do I Need to Know?

Learning a new skill or starting a new profession can be a real challenge, especially when you’re unsure of how much you really need to know before taking the plunge. Imposter syndrome is also a real thing – how could you possibly catch up with all those SQL ‘experts’ who seem like they’ve been doing this since they were in diapers? The good news is you can learn SQL quickly and easily, and you don’t need to know nearly as much as you think you do.

LearnSQL.com Team

SQL Course of the Month – SQL JOINs

If you want to really learn SQL, you can’t skip SQL JOINs. They are some of the most fundamental and commonly used features of the SQL language. That’s why SQL JOINs is our February SQL Course of the Month. What makes SQL JOINs so important? I asked Agnieszka Kozubek-Krycuń, Vertabelo's Chief Content Officer, about it. Here's what she said. Is it true that SQL JOINs are one of the foundations of SQL?

Ignacio L. Bisso

Data Types in SQL

Read this article and learn the ABC of SQL data types. Data types are used to define the type of data stored in a database. However, there are related concepts that a good SQL developer should know: data type conversion, what operations are possible between different data types, date arithmetic, etc. SQL also provides functions that manipulate values of different data types (i.e. functions for string data, date and time data, etc.

Andrew Bone

Using AND, OR, and NOT Operators in SQL

AND, OR, and NOT are important logical operators in SQL. They help you combine the conditions used to filter records. They are most commonly used in conjunction with the WHERE or HAVING clauses. Furthermore, this topic is a pretty common SQL job interview question. To help you completely understand these operators, I’ll take you through some examples, fully explaining the syntax and purpose of each. Practicing using examples like these is one of the best methods for learning SQL.

Agnieszka Kozubek-Krycuń

Why Aren’t SQL Window Functions Allowed in GROUP BY?

It’s true – the SQL order of operations means window functions aren’t allowed in GROUP BY. But you can use them anyway with this special trick. SQL window functions are one of the language’s most powerful features. However, the syntax of window functions is not easy to master. It has lots of details that can cause beginners to stumble. One of the most common traps is trying to use window functions in GROUP BY.

Marija Ilic

7 Common GROUP BY Errors

Are you making these errors with GROUP BY in SQL? Find out what they are, how to avoid them, and how to fix them. SQL’s GROUP BY statement can quickly uncover powerful data insights. At first, using GROUP BY can seem easy – e.g. when creating basic SQL reports that you’ll present to business decision-makers. But while learning this powerful feature, you could become trapped in weird errors or get incorrect results caused by improperly written GROUP BY statements.

Zahin Rahman

Why Learn SQL Window Functions in 2021?

SQL window functions provide some extremely powerful and convenient features for data practitioners. This article explains why you should learn window functions and when you should use them. I’ll also provide some examples to help you visualize the concepts. Window functions are part of advanced modern SQL – knowledge of which will definitely enrich the repertoire of any SQL user. Window functions have a broad range of uses and can be applied to almost all facets of business.

Zahin Rahman

Where Can I Find Good SQL CTE Exercises?

Find the top online resources for SQL Common Table Expression (CTE) exercises! CTEs allow you to structure and organize SQL queries efficiently, which is essential if you want to advance your SQL knowledge. A Common Table Expression, or CTE, is a SQL syntax that creates a temporary data set. This set contains separate data than the main query, which can typically be referenced or reused in a subsequent query. A CTE is considered temporary because the result is not permanently stored anywhere and only exists for the duration of the query.

Jakub Romanowski

Stories of the LearnSQL Scholarship Program

2020 is behind us. It was an extremely difficult year: We’ve struggled with the Covid-19 pandemic, a worldwide economic crisis, and constant anxiety. Many people have lost their jobs and their prospects for a better tomorrow. That's why we decided to do something positive: establishing a SQL scholarship program. We decided to find people in difficult situations and try to help them. For many, learning SQL can be their chance to get a job and develop their career.

Andrew Bone

What Is the SQL WHERE Clause?

The WHERE clause is a fundamental part of SQL. This clause filters results and applies conditions to SQL queries. It is most commonly used alongside the SELECT statement. If you’re a complete newcomer to this topic, you can learn the basics of SQL, including WHERE, in our SQL Basics course This article will clearly explain how to use WHERE in a SQL query. After reading it, you’ll have the confidence and knowledge to integrate WHERE into your daily work.

Kateryna Koidan

What’s the Difference Between SQL CTEs and Views?

SQL views vs. CTEs: What do they do? How are they different? Which one should you use and when? Get your answers here! In SQL, both CTEs (common table expressions) and views help organize your queries, leading to cleaner and easier-to-follow code. However, there are some important differences between them. This article will walk you through several examples of CTEs and views and explain when to use each one.

Agnieszka Kozubek-Krycuń

Monthly SQL Challenges in 2021

Did you know that LearnSQL.com provides a monthly SQL Challenge? Every month, we publish a new set of SQL practice exercises. Find out what to expect from our SQL challenges in 2021. Here at LearnSQL.com, we believe that the best way to learn SQL is through practice. After all, writing SQL is a practical skill. That’s why all our SQL courses (and there are over 30 of them!) are interactive: You learn SQL by writing SQL code.

Kateryna Koidan

What Is LEFT JOIN in SQL?

Get to know the details of LEFT JOIN, one of the most common SQL JOIN types. SQL is mainly about getting data from databases. Very often, you’ll need data to be combined from multiple tables in your database. That’s when JOINs come into play. LEFT JOIN is one of the JOIN types that you are likely to use very often. In this article, I’ll explain the syntax of LEFT JOIN and how it works using several examples and illustrations.

Jakub Romanowski

Best SQL Video Tutorials for 2021

Ready for this year’s picks for the best YouTube SQL video tutorials? Here are our top 5 choices! It's been well over a year since I last wrote about SQL tutorials on YouTube. Those seven channels can help you learn the basics of SQL quite painlessly, but now it's time to add to that list with 2021’s top contenders. Which YouTube SQL tutorials are worth your time and attention? I’ve got my favorites, but first, let’s consider an important question:

Martyna Sławińska

What Is Auto-Increment in SQL?

In this article, we’ll learn the basics of the auto-increment feature of SQL: what it is and how to use it efficiently. One of the many features offered by SQL is auto-increment. It allows us to automatically generate values in a numeric column upon row insertion. You could think of it as an automatically supplied default value – the next number in a number sequence – that’s generated when the row is inserted.

Tihomir Babic

An Overview of Aggregate Functions in SQL

Aggregate functions are commonly used in SQL. This article will lead you through their use and show examples of how they work. SQL aggregate functions are a useful tool, especially for creating reports. They’re not difficult to understand, especially if you have some experience with Excel or similar programs. You’ve probably used aggregate functions like SUM or AVERAGE in a spreadsheet. Even if you only occasionally use them, knowing aggregate functions can help you better understand your data and work more efficiently.

LearnSQL.com Team

LearnSQL Track of the Season: Creating Database Structure

New year, new challenges, and ... a new SQL Track of the Season! Start 2021 by learning SQL and data engineering. In this article, we answer frequently asked questions about our Creating Database Structure track. Maybe you haven't noticed yet that there’s an order to many LearnSQL.com courses; you can learn SQL by doing them in the right order. We call this option our ‘SQL tracks’. These are logically structured and well-thought-out learning paths that will help you take the next steps towards becoming an SQL expert.

LearnSQL.com Team

SQL Course of the Month – Standard SQL Functions

Are you dreaming of becoming a data analyst? Or maybe you just want to work effectively with your company’s databases? You can – with SQL functions. We’ve selected Standard SQL Functions to be our January 2021 SQL Course of the Month. What will you find inside? I asked Agnieszka Kozubek-Krycuń, Vertabelo's Chief Content Officer, about it. Here's what she said. What are SQL functions? The term reminds me of SELECT or JOIN.

Tihomir Babic

SQL JOIN Tips for Beginners

If you’re a beginner and want to know how to start using SQL JOINs in your queries, you’ve come to the right place. Using the SQL JOIN clause is necessary if you want to query multiple tables. Sooner or later, you’ll have to use more than one table in a query. It’s the nature of relational databases in general – they consist of data that’s usually saved in multiple tables; in turn, these form a database.

LearnSQL.com Team

Why Should Learning SQL be One of Your New Year's Resolutions?

In answering this question, we’ll take a look at the idea behind New Year’s resolutions, explore what SQL is, and see why learning it should be your goal for 2021. We’ve all heard of New Year’s resolutions, and we all have personal experience of how difficult it can be to see them through to a successful conclusion. We’ll examine the history of New Year’s resolutions, why they often fail, and how to ensure your resolution for learning SQL in 2021 doesn’t meet with the same fate as so many others that never made it past the end of January.

Jakub Romanowski

2020’s Best LearnSQL.com Articles

We published a whole lot of interesting SQL articles this year. I had a difficult task – choosing the best LearnSQL.com articles of 2020. And here they are. The crazy year of 2020 is coming to an end. How will we remember it? Probably by the COVID-19 pandemic; we stayed home and fought the virus. It was a difficult time. However, many of us did not give up and kept trying to achieve our professional goals.

Ignacio L. Bisso

What Is a Database Index?

Database indexes are critical to query speed and efficiency. Learn when, why, and how to use them – and when not to – in this post. Indexes are very important database objects; they optimize data access and improve database performance by helping the database execute SQL queries faster. Why not take this opportunity to learn how indexes work and how to create them? What Is a Database Index? Indexes are data structures that can increase a database’s efficiency in accessing tables.

Kamila Ostrowska

How to Practice SQL with LearnSQL.com

Practicing new skills online needs motivation and self-discipline, but it’s worth it. We’re facing a difficult, uncertain time. On one hand, the COVID pandemic caused a lot of fear. What will happen in the future? Will I keep my job? Will we stay safe and healthy? On the other hand, COVID is giving us a lot of time. Working remotely, not having anything to do but stay home and… And what?

Dorota Wdzięczna

What Is an SQL INNER JOIN?

How do you combine data from different tables in one query? An SQL feature called JOIN is the most common operator used to create complex queries. Learn the basics in this article. SQL allows us to select data from more than one table. In fact, the whole idea of using relational databases is selecting data from related tables. And we can use SQL’s JOIN operator to do this. There are many types of JOINs in SQL.

Marija Ilic

How SQL Window Functions Can Help Managers Decide Who Gets a Raise

Window functions are one of the most powerful features in modern SQL. In this article, you will learn why window functions are so great. I will list you the most useful window functions and briefly explain when and how you can use them. Simple SELECT statements, in combination with WHERE, GROUP BY, and HAVING, are sufficient for many analyses at work. I used standard SQL for many years before I realized there is something more.

Jakub Romanowski

The Best SQL Lectures on YouTube

YouTube contains a vast amount of information. The trick is to know how to find what’s valuable. If you type “SQL lectures” in the YouTube search engine, you will probably get a list of boring or unhelpful clips. However, there are hidden gems, and I’ve compiled a list of the best SQL talks I’ve found on YouTube so far. First, let's establish one thing. I didn't choose any YouTube SQL tutorials when making this list.

Zahin Rahman

Best Online Courses for SQL Window Functions

In this article, I will summarize the top online tutorials and courses available on SQL window functions for enthusiasts of data analysis, data science, and data engineering. The information is here to help you embrace the topic with ease and feel comfortable using window functions in SQL databases. SQL window functions can help you solve some of the most common analysis challenges in business: What are the N most popular products for each month of the year?

Tihomir Babic

How to Use CASE WHEN With SUM() in SQL

This article will teach you what a CASE WHEN expression is in SQL and how to use it with a SUM() function and a GROUP BY statement. The examples are included to bolster your understanding. Knowing how to use a CASE WHEN expression in SQL adds insight into the exciting possibilities in SQL. It elevates you from a simple user who depends on what SQL returns, to a user who is more in command and who sets specific criteria in SQL.

LearnSQL.com Team

SQL Scholarship Program 2020

2020 is slowly coming to an end. It was extremely difficult for everyone. We’ve therefore decided to end it with something positive. This Holiday, we want to help someone change their life. Learn SQL will fund 50 SQL Scholarships for people who cannot afford to learn SQL and who may find it helpful in a difficult situation. We’ll hand out our flagship track - SQL From A to Z - for FREE!

Martyna Sławińska

What is an SQL View?

A view is a well-known feature in SQL. It allows you to create a virtual table based on an SQL query referring to other tables in the database. A view stores an SQL query that is executed whenever you refer to the view. This is a convenient way to get the desired data because it is easier to run a query stored in a view than to type a query from scratch.

Arleta Więch

Practicing SQL for Your First Day of Work

Your new SQL job is likely to surprise you in many ways. To minimize the risk of getting lost in the jungle of data, I recommend you get some additional SQL practice before your first day. There are special SQL practice sets and projects on the internet to help you prepare. You’ll also get help from your colleagues, as programmers are usually open and supportive. If you’re reading this, you’ve probably heard about the opportunities SQL and data science offer.

Andrew Bone

The Top 10 SQL JOIN Interview Questions and How to Answer Them

Have you ever wondered what SQL JOIN questions you might be asked in an interview? Do you feel prepared to answer them? This article covers the most common SQL JOIN interview questions and how to answer them. If you are applying for a job as a data analyst or software developer, you will likely be asked about your SQL JOIN knowledge. SQL JOIN clauses are a great topic for interviewers to quiz you on.

Agnieszka Kozubek-Krycuń

The History of SQL Standards

Has the SQL standard changed in the 30+ years it's been around? Absolutely! Learn about the journey from SQL-86 to modern SQL, today’s standard data language. SQL was created in the early 1970s by IBM. In 1974, Donald Chamberlin and Raymond Boyce published the article SEQUEL: A Structured English Query Language, which introduced SQL to the world. The article contained the BNF grammar (a detailed technical description of the language syntax) for the language, which IBM later thought was a mistake.

Jakub Romanowski

SQL Terms Beginners Should Know – Part 2

This is the second part of my list of essential SQL terms for beginners. In the first, you learned what a table, relational database, and query are. Now, it's time for more advanced database terms. But don't be afraid! I won’t crush you with scientific definitions. I will explain everything simply so that you can easily understand. If you want to review the basic SQL terms, see my previous article, SQL Terms Beginners Should Know.

Kateryna Koidan

How Do You Write a SELECT Statement in SQL?

SQL is a language to communicate with relational databases, and the SELECT statement is the first thing you’ll learn when you start using SQL. In this article, you’ll learn how to write SELECT statements, from the basics to more advanced. What Is SQL? SQL stands for “Structured Query Language.” It has a long history that started in the 1970s. Being the standard for communication with relational databases, it has maintained its popularity.

Agnieszka Kozubek-Krycuń

SQL Technologies Are More Common Than You Think

Where is SQL being used today? The answers might surprise you! (Hint: SQL technology is basically everywhere.) Is it worth learning SQL? After all, the language was created in the 1970s. Is it still relevant today? The list of technologies that support SQL is very long – and it’s growing. Read on to find out what kinds of programs use SQL. SQL in Databases Relational Databases = SQL Databases It’s no surprise that SQL is used in relational databases.

LearnSQL.com Team

SQL Course of the Month – Customer Behavior Analysis in SQL

Do you run a business? Do you want to squeeze even more out of your data? Start by analyzing your customers' behavior using SQL! Throughout December, you can learn how to do it for free on LearnSQL.com! I asked Agnieszka Kozubek-Krycuń, Vertabelo's Chief Content Officer, about our December Course of the Month, Customer Behavior Analysis in SQL. Here's what she told me. Let's start with the basics: Why analyze customer behavior?

Ignacio L. Bisso

What Is a Foreign Key in SQL?

What does a foreign key do in SQL? Why would you need one? Learn the ABCs of foreign keys in five minutes. Foreign keys are a central concept in SQL databases; they allow us to enforce data consistency. Usually they work with primary keys to connect two database tables, like a virtual bridge. All SQL developers need to know what SQL foreign keys are, how they work, what data values are allowed in them, and how they’re created.

Kateryna Koidan

SQL Window Functions vs. SQL Aggregate Functions: Similarities and Differences

If you aren’t familiar with SQL’s window functions, you may wonder how they differ from aggregate functions. When should you use window functions? In this article, we’ll review window functions and aggregate functions, examine their similarities and differences, and see which one to choose depending on what you need to do. After you’ve tackled basic SQL, you’ll probably want to get into some of its more advanced functions. That’s great; these functions make reporting and analysis easier.

Tihomir Babic

How to Find All Employees Under Each Manager in SQL

Have you ever been tasked with building an organizational chart – i.e. finding the employees under each manager in a company? In SQL, you can do that easier than you think! This article will show you how to get the answer using a recursive query. In the business world, it’s a very common task to list all the subordinate employees for a given manager. Is doing this hard enough to warrant a whole article?

Jakub Romanowski

SQL in the Open-Source World

Did you know there are free, open-source databases that use SQL? In this article, I'll show you which open-source database solutions can meet your needs. Ever wonder why many people still use paid programs when the same things can be done with free options? Personally, I am an avid supporter of the open-source movement. For years, I have been trying to apply and promote such solutions and support an active community around them.

LearnSQL.com Team

SQL Black Week 2020. See how much you can save!

Wow, have you seen what discounts the LearnSQL.com Team has prepared for Black Week? We’ve cut all the prices of our SQL courses. We also have something special for students. But hurry up, time is short! Black Week - Special Pricing: Individual SQL course - $25 Forever plan - $179 Forever plan for Students - $90 We know just how much you love to bag great discounts. SQL Black Week 2020 is on!

Adrian Więch

How To Learn The SELECT Statement in SQL

When you think about learning SQL, one of the first things you come across is the SELECT statement. Selecting information is arguably the most important SQL feature. In this article, we’ll demonstrate the typical use cases for SQL SELECT with practical examples. Read this article if you’re a beginner database user and would like to know what SELECT can do for you. SQL, or Structured Query Language, is the programming language the IT world uses to communicate with databases.

Martyna Sławińska

What Is a SQL Constraint?

What are SQL constraints? When and why should you use them? We give examples of common constraints and demonstrate how to apply them. When you’re creating a relational database, you often want to impose certain restrictions on some columns. For example, a column containing a social security number should store only unique values; a column containing a date of birth should not be null, or left empty. These conditions can be ensured by using SQL constraints.

Agnieszka Kozubek-Krycuń

The History of SQL – How It All Began

Who created SQL and why? Find out in this article! Are you learning SQL? Or are you about to take the first step towards working with databases? Great decision! Either way, it's worth knowing the history of SQL – where it came from, who came up with it, and why. Here’s a brief history of SQL, starting with its foundational concept: the database. Ted Codd and the Relational Data Model The first computer databases appeared in the late 1960s.

Kamila Ostrowska

Practice SQL Before Interviewing a Potential Employee

Has your company grown to the point that you need to hire an SQL expert? Have you found a candidate for the job? How do you prepare for the interview, especially if you don’t know SQL? Don't worry! Follow our suggestions on how to practice SQL. We have tips and tricks to help you feel confident and find the perfect employee. Who You Want To Hire First of all, you need to know the requirements for the new employee.

Marija Ilic

SQL JOIN Types Explained

What’s the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN in SQL? When should you use each one? We’ve got your answers right here. You want to combine data from two or more different tables, but you’re not sure how to do it in SQL. No worries. In this article, I will show you how to use the SQL JOIN clause to merge data from two tables.

Zahin Rahman

Top 7 Online Courses for Data Engineers

This article summarizes the top online courses available for data engineers. We have picks suitable for beginners as well as intermediate learners. If you’re interested in database design and management, check these courses out! Most individuals who aspire to enter the realm of data aim for data scientist or data analyst roles. While these roles are indeed very rewarding because of their tangible links to customers and business direction, the role of data engineers is equally vital for businesses that operate in a data-rich environment.

Jakub Romanowski

SQL Terms Beginners Should Know

Have you started learning SQL? Do you feel a little lost in the maze of new words and ideas? Here’s a list of 10 absolutely essential SQL terms for beginners. When you start learning SQL, there’s a lot to process. And some of it – even basic SQL terms – gets lost in the shuffle. If this sounds like you, bookmark this article; it will be a handy reference.

Magdalena Wojtas

Where to Go After Learning SQL Basics

Learning to code is – in general – a lot of fun, for sure. Even after a few years in the IT industry, I still love learning new technologies. And I now know that learning with a good plan is even better than learning without one. This also applies to learning with advanced SQL courses. In this article, I'll show you how learning paths can save you some time and a lot of frustration.

Jakub Romanowski

Don't Be a SQL Noob! Start Learning with Our SQL Basics Course

Why learn SQL from our interactive online courses? Two reasons: 1) Power up your career. 2) Avoid being a noob. What does it mean to be a noob? “Noob” comes to us from the world of computer games. It’s a combination of “newbie” and “beginner”. It’s not a very nice word. It means that someone has found you an inexperienced player and (even worse) resistant to learning. This resistance is what’s important.

LearnSQL.com Team

SQL Course of the Month – GROUP BY Extensions in SQL

Do you want to develop your SQL skills? Do you want to get more out of your data and prepare better reports and summaries? The answer is learning to use SQL’s GROUP BY extensions. But how should you go about this? I asked the same question to Agnieszka Kozubek-Krycuń, Vertabelo’s Chief Content Officer. As she explains, the secret is in this November’s free SQL Course of the Month: GROUP BY Extensions in SQL.

Tihomir Babic

What is the Difference Between COUNT(*), COUNT(1), COUNT(column name), and COUNT(DISTINCT column name)?

Have you noticed there are different variations of the SQL COUNT() function? This article explains the various arguments and their uses. As a SQL user, you’re probably quite familiar with the COUNT() function. Even though it’s relatively simple, it can be used in several different ways. Each way has a very different use. I imagine you’ve seen code that contains the function COUNT(*) or COUNT(1). You’ve probably also seen some other uses of the COUNT() function, such as COUNT(column name) and COUNT(DISTINCT column name), even if you haven’t used them.

Tihomir Babic

What are SQL CTE Best Practices?

Are you wondering what the best practices for using common table expressions are? This article will help you learn when to use a CTE and how to write it. If you have heard about SQL CTEs, you have probably noticed they’re often mentioned together with subqueries. Sometimes, people think there’s no difference compared to the subqueries, and there’s often debate about whether a CTE or subquery should be used to get a particular result.

Kateryna Koidan

How to Fix a 'Not a GROUP BY Expression' Error

Whether you are an experienced SQL user or only a beginner, your SQL queries may return errors. The accompanying messages are supposed to help you fix them; however, sometimes the messages are not very helpful. The Oracle message “Not a GROUP BY expression” is one such example. Let’s review what this is about and how to fix it. We are going to assume some basic understanding of how GROUP BY works.

Jakub Romanowski

Haunted Halloween Promotion - Join the Scavenger Hunt!

Trick or treat! Halloween, the festival of monsters is approaching! The LearnSQL platform is overrun by ghosts. They have haunted our courses. Are you scared, do you feel chills? We are most concerned about the prices. It’s highly probable the wraights will bite them off. But to quote the classics - “Who ya gonna call? Ghostbusters!” So put on the costume, take the astral trap and find them all to win our scavenger hunt.

Kateryna Koidan

How to Learn SQL Common Table Expressions (CTEs)

Common table expressions are very useful for organizing, traversing, and improving the readability of long SQL queries.  Moreover, recursive CTEs, which can reference themselves, solve problems that cannot be addressed with other queries. But how do you master common table expressions in SQL? In this article, I discuss the most effective strategies for learning CTEs and suggest how to address the common challenges of learning common table expressions on your own.

Ignacio L. Bisso

What is a Primary Key in SQL?

Primary keys are an important concept in SQL databases. They provide a unique ID for every row in a database table. As an SQL developer, you should know what primary keys are, what data values are allowed in them, and how to create them. Read this article to learn the ABCs of primary keys in 10 minutes. How to Identify Rows in a Table Tables are the main objects in an SQL database, and as you probably know, tables store records or rows.

LearnSQL.com Team

Learning SQL for Free – Is It Worth Betting on Free Online Learning?

Everyone likes to get something for free, even when it comes to SQL courses. But is free always good? Find out how and where you can learn SQL for free – in a way that’s worth your time. Beginner-friendly database courses and SQL tutorials often promise to teach SQL fundamentals like SELECT, WHERE, GROUP BY, HAVING, and ORDER BY. These commands are the basis of a powerful set of skills for entry-level jobs in data analysis or databases.

Adrian Więch

What Is a DBMS?

We generate vast quantities every day, and that data needs to be stored somehow. That’s where DBMSs come in handy. Find out what they are and how they relate to databases. If you go on a diet and simply want to keep track of your weight, you can probably use a piece of paper and a pencil. If you then want to chart your daily caloric intake, you’ll probably switch to something like a computer spreadsheet.

Adrian Więch

Google Analytics and SQL

Google Analytics is a very popular tool among website and blog owners alike. With a simple and quick setup, it lets you gather data about your web page visitors easily. However, did you know that you can export data from Google Analytics to create your own SQL reports? Read this article to find out how. Google Analytics is an extremely popular and powerful solution that lets you collect and analyze various kinds of information about your website.

Rebecca McKeown

How to Boost Your Company With SQL Courses

SQL has the power to supercharge the capabilities and performance of your entire company. But if you don’t dip your toes in the water and give some SQL courses a go, you’ll never realize the vast potential of the language. SQL, or Structured Query Language, is your ticket to expanding the scope and the results of your business or organization, no matter what sector you operate in. Whether you’re the owner or manager of your company or simply an employee interested in improving operations, learning SQL is undoubtedly, unquestionably, for you.

Zahin Rahman

SQL HAVING Tutorial

Learn how to use the SQL HAVING clause to filter groups using your own specified conditions. The SQL HAVING clause is often a challenging concept to grasp, especially for beginners. Additionally, its specific use cases can be difficult to visualize without specific examples based on real-world datasets. In this tutorial, you will learn how to apply the SQL HAVING clause to filter groups of records based on specified conditions. You’ll see examples where we apply this concept to solving business problems on a realistic dataset.

Martyna Sławińska

What Is a Self Join in SQL? An Explanation With Seven Examples

The self join is a popular special case of the SQL JOIN. While most JOINs link two or more tables with each other to present their data together, a self join links a table to itself. This is usually done by joining a table to itself just once within a SQL query, but it is possible to do so multiple times within the same query. Typically, each table in a database stores a specific type of information.

Marija Ilic

How to Join the Same Table Twice

JOIN is one of the most common statements in SQL. As you may know, it is used to join and combine data from two or more tables into one common data set. In this article, I’m going to discuss special types of joins? in which you combine the same table twice—including joining a table to itself, also known as the self join. When and why do you need to do this?

Marcin Koryszewski

5 Best Online SQL Courses for Business Analysts

Why bother to learn via an online SQL course? SQL is pure profit – it allows analysts to interpret data efficiently and companies to adopt better strategies. In this post, we’ll look at our top 5 SQL courses for business analysts. Being into finance, economics, and IT systems has brought you to business analysis. It’s a fascinating combination of skills; you’re combining business and technology, which makes you a valuable asset to your company.

Marija Ilic

How to Create Your First Table in SQL

Creating a database table with SQL is one of the core skills you’ll need to work with data. And it’s easy to learn, so let’s get started! Imagine you’re analyzing data and want to store your results in a database table. Sure, you've done this a million times in Excel. But you’re not sure how to create a table with SQL. Or maybe you’ve noticed that data engineering is in high demand and you want to start learning its core concepts.

Agnieszka Kozubek-Krycuń

Five Essential Features of a Good SQL Course: What to Look for When Choosing a Course for You

There are many different platforms offering SQL courses. If you’re a beginner, it may be difficult to choose the right one for you. Find out what we think are the essential features of a good SQL course. Remember, if you make a poor choice at the beginning, you may get discouraged or get into bad habits that will impact your work down the line. What Is SQL? SQL, or Structured Query Language, is a programming language you use to talk to databases.

Martyna Sławińska

A Comprehensive Introduction to Window Functions in MySQL

Do a deep dive into the working principles, syntax, and applications of various MySQL window functions. There are many open source databases you could choose; MySQL is consistently one of the most popular. But until 2018, there was no provision for including window functions in MySQL. Fortunately, all that has changed – starting from MySQL 8.0, SQL window functions were now available to MySQL users. Please note that window functions are available only in MySQL 8.

LearnSQL.com Team

SQL Course of the Month – How to INSERT, UPDATE, and DELETE Data in SQL

So, you've started learning SQL, and you already know what the SELECT command is and when to use it! Congratulations! Now, it's time to take the next step towards becoming an expert. You need to know the SQL UPDATE, INSERT, and DELETE commands to modify data in your tables. These are the basics that will allow you to work with tables. But what's the best way to learn them? I asked Agnieszka Kozubek-Krycuń, Chief Content Officer at Vertabelo.

Kamila Ostrowska

How Will Learning SQL Make You a Better Boss?

Want to improve the performance of your team, of your own, of your department, or of your entire company? Try SQL! Why should you learn SQL? Because it just pays off! What does learning SQL and being a better boss have to do with each other? Being a better manager can make your employees happier while growing your business. When employees feel a sense of fulfillment, they are more motivated to do well.

Tihomir Babic

Six Window Function Templates to Save in Your Code Editor

Do you use window functions often enough to know them well but not often enough to remember all the details? Here are six window function codes you should save as templates. Window functions are a handy SQL option, but it doesn’t mean you use them all the time. Maybe you only use them occasionally; if that’s the case, you probably find yourself needing to refresh your memory every time you use them.

LearnSQL.com Team

New Course: Customer Behavior Analysis in SQL

Good news! A new SQL course is here! We’re happy to announce the release of our Customer Behavior Analysis in SQL course. Do you want to get to know your clients and better understand their needs and behavior? If so, this great interactive SQL course is for you. Discover the power of full customer lifecycle analytics in SQL and know more than your competitors. The LearnSQL.com team is happy to announce the release of a new SQL course on our platform: Customer Behavior Analysis in SQL.

Jakub Romanowski

SQL Courses in New York City

If someone asks me where to learn SQL, I answer simply: online! A good interactive SQL course is much better than any classroom activity or bootcamp. First, you do everything at your own pace. You can always ask the tutor about anything, be a part of an online community, and read interesting things elsewhere on the web (e.g. on our blog). However, there are those who prefer full-time courses. They are traditionalists.

Ignacio L. Bisso

What Is the MySQL OVER Clause?

If you want to learn window functions in MySQL, you need to understand the OVER clause. In this article, we use real-world examples to explain what the MySQL OVER clause is, how it works, and why it’s so awesome. In 2018, MySQL introduced a new feature: window functions, which are accessed via the OVER clause. Window functions are a super powerful resource available in almost all SQL databases. They perform a specific calculation (e.

Jakub Romanowski

SQL Means Business - The Way of an Engineer

Have you been wondering why some companies fail and others achieve success? It's not a matter of luck but of the right people. Łukasz Kubicki at Vertabelo deals with business and product development. I asked him how he started his adventure with programming, how an engineer got into business, and if he liked playing computer games. Here's what he said. If you were to write one sentence about yourself, what would it be?

Jakub Romanowski

Did You Know LearnSQL.com Has Free SQL Courses?

Who doesn't like getting something for free? Each month, we give LearnSQL.com users a bit of help in their learning journey – a free, fully interactive SQL course. Since April, we have been giving our users the opportunity to learn SQL for free. Each month, we choose one of our SQL courses and give you full access to it for that month – completely free of charge! Cool, right?

Marcin Koryszewski

How Much Do Data Engineers Earn in 2020?

Data engineering is a hot job right now. What does a data engineer do? And just how much do they earn? We’ve done the research for you. If you are reading this, you’re either starting to learn SQL or you already know some and feel it’s time to look around for a SQL job. Maybe you’re in the midst of tackling our Creating Database Structure track. And, let’s be honest, maybe you need some extra motivation to keep on you track.

Tihomir Babic

How to Use 2 CTEs in a Single SQL Query

Have you ever wondered how to use multiple CTEs in one SQL query? Read this article and find out about recursive CTEs. After learning common table expressions or CTEs, a natural question is “Can I use several CTEs in one query?” Yes, you can! And you can do it quite easily, especially if you already have some basic knowledge of CTEs. Whether you know a bit about CTEs or you’re entirely new to the CTE world, reading about what a CTE is is always a good start.

Dorota Wdzięczna

How to Join Two Tables in SQL

Querying data from multiple tables is very common when working with relational databases. It is not difficult if you know how to use the dedicated SQL operators for doing this. In this article, you will learn how to join two tables by using WHERE and by using a special operator JOIN, and you will see how to filter rows in the result set. If you want to practice joining tables in SQL, check out our interactive SQL JOINs course.

Kateryna Koidan

GROUP BY in SQL Explained

The SQL GROUP BY statement is easy to use, but it can be hard to master. Learn what you can do with GROUP BY, how it works, and how to use it with aggregate functions. GROUP BY is one of the basic SQL tools. However, it might be difficult for beginners to understand how GROUP BY works and how it is used to compute statistics with different aggregate functions. In this article, I’ll use several examples to show exactly how GROUP BY organizes rows and how aggregate functions can be used to calculate statistics on one or more columns.

Arleta Więch

Top 5 Beginner Online SQL Courses in 2020

Looking for an exciting new career? Data analysis won’t disappoint you! The simplest way to make this possible is by learning SQL, and online SQL courses are the most effective learning method. Don’t know where to start? Here’s an overview of the best online SQL courses for complete beginners. There are infinite reasons for changing your industry. You may want to land a new job because you’re burnt out. You may be bored and want something more challenging.

Agnieszka Kozubek-Krycuń

Behind the Scenes at LearnSQL.com: How Our SQL Courses Are Created

Take a peek behind the scenes and learn our secret for creating great SQL courses! Have you ever wondered how LearnSQL.com courses are created? Are we looking at a lot of hard work or just a bit of magic? Or maybe both? Here’s a hint: we rely on proven methods to create user-friendly online courses. But it’s not easy! Read on to see the 8 steps we take when creating a new SQL course.

Rebecca McKeown

Why and How to Find Freelance SQL Jobs

If Covid-19 has you all “I-want-to-stop-working-for-the-man-and-enjoy-a-more-fulfilling-life-as-the-master-of-my-own-destiny”, then I’ve got news for you. Not only is it possible to be an SQL freelancer, it’s also a potentially lucrative and liberating career move. It will allow you to work for a diverse range of clients and march to the beat of your own drum. Of course, SQL freelancing isn’t for everyone. You will need a strong sense of self-motivation, some serious hustling skills, and the ability to sell yourself and your services as THE ABSOLUTE BEST all the time, every time - day in, day out.

Dorota Wdzięczna

Six Examples Using MySQL Window Functions

Window functions are an advanced SQL feature available in most popular databases. MySQL had not supported them for a long time, but that changed in Version 8.0. They are helpful not only for analysts and people who create reports, but also for other professionals who use databases to select data needed. In this article, we explain the syntax of some popular window functions with practical examples. What Is a Window Function?

Marija Ilic

What a Moving Average Is and How to Compute it in SQL

Want to dive deep into time series data and examine long-term trends? Want to know what a moving average is and how to compute it in SQL? Then this article is for you. I’ll explain a powerful feature in SQL called window functions and show how you can calculate moving averages using them. The best way to learn about SQL window functions is the interactive Window Functions course at LearnSQL.

LearnSQL.com Team

LearnSQL Track of the Season: SQL from A to Z

During Fall 2020, our main SQL track, SQL from A to Z, will be in the spotlight. In this article, we answer the most frequently asked questions about this track. At LearnSQL.com, our SQL courses are organized into tracks. A track is a sequence of courses designed to help you achieve a specific learning goal. The courses in the track are in a recommended order that progresses from the easiest to the most challenging.

Zahin Rahman

How to Find Duplicate Values in SQL

Duplicate records waste time, space, and money. Learn how to find and fix duplicate values using SQL’s GROUP BY and HAVING clauses. Database best practices usually dictate having unique constraints (such as the primary key) on a table to prevent the duplication of rows when data is extracted and consolidated. However, you may find yourself working on a dataset with duplicate rows. This could be because of human error, an application bug, or uncleaned data that’s been extracted and merged from external sources, among other things.

LearnSQL.com Team

SQL Course of the Month – Analyzing Revenue Trends in SQL

We work hard, we learn SQL, and we develop professionally. But why? For our own satisfaction, but also for money! The knowledge of SQL will increase your income significantly. If you are proficient in SQL, you can better analyze your company's revenue. How? I asked Agnieszka Kozubek-Krycuń, Chief Content Officer at Vertabelo. In this article, she answers your questions about our September SQL Course of the Month: Analyzing Revenue Trends in SQL.

Adrian Więch

How CTEs Work

The SQL language offers a feature named Common Table Expressions, or CTEs. Also known as WITH clauses, CTEs are a fairly new addition to SQL. They help you break longer queries into smaller chunks, making your queries much easier to understand. Read the article to find out how to use CTEs and how they differ from traditional subqueries. Common Table Expressions (CTEs), which are essentially named subqueries, were first mentioned in the SQL standard between 1999 and 2000.

Ignacio L. Bisso

How Does SQL GROUP BY Work?

Grouping results is a powerful SQL feature that allows you to compute key statistics for a group of records. GROUP BY is one of SQL’s most powerful clauses. It allows you to see data in a new way and find key metrics (like the average, maximal, and minimal values in a group of records). Without GROUP BY, all the results we obtain are oriented to records. With GROUP BY, we can create groups of records and calculate metrics on each group.

Kateryna Koidan

SQL CTEs Explained with Examples

Learn how you can leverage the power of Common Table Expressions (CTEs) to improve the organization and readability of your SQL queries. The commonly used abbreviation CTE stands for Common Table Expression. To learn about SQL Common Table Expressions through practice, I recommend the interactive Recursive Queries course at LearnSQL.com. It contains over 100 hands-on exercises on simple and complex recursive CTEs. What does a CTE do? Why might you want to use one in your SQL code?

Tihomir Babic

How to Calculate the Length of a Series with SQL

What is a time series and why bother to calculate its length using SQL? How do we calculate the length of a series in SQL? I can answer that in two words: window functions! Yes, you’ll need some knowledge of SQL window functions to calculate series length. But what is a time series, and why would you want to find out how long it is? What Is a Series?

Jakub Romanowski

Where Can I Find Free Online Data Sets to Practice SQL?

Okay, you've installed the RDBMS of your choice. You know the basics of SQL and ... what's next? You would like to be able to practice SQL functions you learned in our course. Maybe you have even done our SQL Practice Set course and are hungry for more. To work with a database, first of all, you need—yes, this is not a surprise—a database! Where do you get the data for your SQL queries?

Adrian Więch

5 Examples of GROUP BY

When you start learning SQL, you quickly come across the GROUP BY clause. Data grouping—or data aggregation—is an important concept in the world of databases. In this article, we’ll demonstrate how you can use the GROUP BY clause in practice. We’ve gathered five GROUP BY examples, from easier to more complex ones so you can see data grouping in a real-life scenario. As a bonus, you’ll also learn a bit about aggregate functions and the HAVING clause.

Dorota Wdzięczna

How to Create a Table in SQL

Creating tables in databases is a very helpful skill, and not just for software engineers or database administrators. It allows you to design or change the structure of a database and store data that’s related to each other. In this article, you’ll learn what a database table is, who creates them, and how to use the syntax of the CREATE TABLE command. What Is a Database Table? A relational database is built of various structures like tables, views, procedures, and triggers.

Jakub Romanowski

The Most Popular Databases in 2020

Which database solution is currently most popular? Which SQL dialect should you study? In this article, I’ll share the results of my research and my personal experience. Here are the databases that are worth learning SQL to use. First, let's answer some simple questions: Is SQL still useful? Is it worth learning? If you complete an online SQL course, will it make your work easier? The answer is YES! Why?

Martyna Sławińska

What Is the Difference Between WHERE and HAVING Clauses in SQL?

As the amount of data in the world grows day by day, the need increases for managing and querying data efficiently. SQL offers ways to manipulate and query data at any scale. As an important part of this, the WHERE and HAVING clauses allow you to filter data as you need, but they are not the same. We will explain the differences between them in detail. One of the most common tasks in manipulating and querying data is filtering using the WHERE and HAVING clauses.

Adrian Więch

How to Spend Less by Mastering the Monthly Budget in SQL

Do you struggle to keep your budget under control? You must have heard about various budget planning materials available as printouts, Excel spreadsheets, or smartphone apps. In this article, we’ll show you another possibility. You’ll learn how to use databases and SQL to identify the weak points of your home budget and spend less. We all need to pay for everyday necessities such as groceries or medical appointments. With money coming in and out of our pockets, it’s easy to lose track of how much we spend and if we have any savings.

Rebecca McKeown

Is There any Demand for SQL Language Nowadays?

SQL is 46 years old. That’s 14 years older than I am, and at least 23 years older than the jar of pickles in my refrigerator. SQL is the still-hip granddaddy of the programming world. You know the one: non-ironic suspenders, twirled mustache, tattoo peeking out over his spotted socks. He may be old, but boy, is he fly. If you’ve heard of the NoSQL movement, you may be wondering: why learn SQL in this day and age?

Kamila Ostrowska

5 Reasons You Might Fail to Learn SQL

Learning SQL isn’t hard, but that doesn’t mean you’ll sail through, problem-free. Here are five things that might cause unwary SQL learners to fail. For me, learning SQL wasn’t always about the joy of discovery. Learning itself is not all about curiosity and the satisfaction of succeeding. Sometimes there is a sense of failure. We’re often told it is better to focus on positives. I believe this. However, it is also crucial to find out what went wrong when we don’t succeed at something.

Jakub Romanowski

Learning SQL When You Work and Have a Family

Do you want to learn SQL but feel you can’t squeeze one more thing into your jam-packed life? Here are my tips on learning SQL when you work and have kids. You work full-time and have a family. Daily responsibilities overwhelm you. I’ve been there. Heck, I live there. I work from home and have a family. While I was writing this article, I was also waiting for a call on Zoom, doing the laundry, and cooking some pasta for my son’s dinner.

Kateryna Koidan

Can you Join two Tables Without a Common Column?

Yes, you can! The longer answer is yes, there are a few ways to combine two tables without a common column, including CROSS JOIN (Cartesian product) and UNION. The latter is technically not a join but can be handy for merging tables in SQL. In this article, I’ll guide you through the different solutions with examples. When Do you Need to Join Tables Without a Common Column? Beginners just getting started with SQL are usually introduced to standard equi joins, in which two tables are combined by a common column.

Tihomir Babic

Who Should Learn SQL Window Functions?

Do you want to learn how SQL window functions can help you at your job? This article will show you examples from various business applications where they can be very useful. I won’t be explaining what SQL window functions are in this article, but rather how to use them. If you’re not familiar with window functions or their syntax, don’t worry. Here’s an article that can help you with an introduction to SQL window functions.

LearnSQL.com Team

SQL Course of the Month – Recursive Queries

Recursive Queries is one of SQL’s more advanced features. You could say they divide SQL users into beginners and experts. But how do you learn recursive queries? And why do you need them, anyway? Agnieszka Kozubek-Krycuń, Chief Content Officer at Vertabelo, is here to help. In this article, she answers your questions about our August SQL Course of the Month: Recursive Queries. Recursive queries … that sounds very serious.

Dorota Wdzięczna

The SQL HAVING Clause Explained

What is the SQL HAVING clause? Why do you need it, and where do you use it? We’ll explain HAVING in detail. HAVING is a very common clause in SQL queries. Like WHERE, it helps filter data; however, HAVING works in a different way. If you are familiar with the GROUP BY clause and have only heard about HAVING – or if you’re not familiar with HAVING at all – this article is what you need.

Ignacio L. Bisso

How to Use Subqueries in INSERT, UPDATE, and DELETE Statements

Did you know that subqueries can also be used in UPDATE, INSERT, and DELETE statements? Subqueries in SQL are like building blocks that can be used in a variety of statements, not just SELECT. If you find subqueries useful in SELECT, read this article to find out how useful they can be in other instructions. You will be able to create much more complex and powerful SQL queries in no time!

Jakub Romanowski

Our 6 Favorite SQL Books

So you want to learn SQL and query databases? Great! Check out these six SQL books for an in-depth look at the language and you’ll be writing queries in no time! You take SQL courses, participate in internet discussions and forums, watch tutorials on YouTube... What else can you do to develop your skills? Sometimes it’s good to reach for old-fashioned sources of knowledge: SQL books. Which book(s) should you choose?

Adrian Więch

Who Is a Data Engineer?

A new kind of job has recently emerged in the IT world: Data Engineer. At first sight, it may seem very similar to Data Analyst or Data Scientist positions. However, our article explains all the important differences. We present the skills, tools, and everyday tasks of Data Engineers. We also explain how you can get started with this career path.   Thirty years ago, we typically used terms such as “Computer Scientist” when referring to anyone working with computers.

Kateryna Koidan

What's the Difference Between Having Multiple Tables in FROM and Using JOIN?

What’s your approach to joining tables in SQL? In this article, we discuss two approaches and explain why many SQL developers have a definite preference for JOIN. Do you prefer to list multiple tables in FROM and use WHERE to set the join conditions? Or do you use the JOIN keyword? SQL supports both, but there are significant differences between them. Let’s look at each one in detail and then discuss why JOIN is generally preferred.

Marija Ilic

How to Analyze a Time Series in SQL

Values ordered by time are called a time series. In this article, I’ll show you the most frequent patterns and teach you how to write queries for time series in SQL with the help of window functions. Maybe you’ve had the opportunity to analyze some variables where each value was associated with a time value. Such data – where values are ordered by time – is called time series data.

LearnSQL.com Team

LearnSQL.com’s New Learning Path: Data Engineering

Calling all future data engineers! Would you like to learn to use SQL? Then our new Data Engineering Learning Path is just for you! We’re very excited to announce the release of a new learning path at LearnSQL.com: Data Engineering, published in July 2020. This is the second learning path offered in our platform. So far, we offered an analytical path, SQL Querying & Reporting, that focuses on writing queries and business reports in SQL.

Zahin Rahman

Using GROUP BY in SQL

Now that you know SQL’s core commands, power up your queries with the GROUP BY clause and aggregate functions. GROUP BY is a SQL clause that arranges data into groups based on a common value (or values). It is widely used to obtain summary information for large datasets as well as for computing basic aggregate statistics. Once you have grasped SQL’s basic commands like SELECT, WHERE, and JOIN, mastering the GROUP BY clause can help you implement your SQL knowledge in real-world business intelligence scenarios.

Dorota Wdzięczna

The LAG Function and the LEAD Function in SQL

LAG() and LEAD() are positional functions. A positional function is a type of window function. If you are not familiar with when and how to use them, what the syntax of each function is, why you might want to use them, and what the differences are, read on! LAG() and LEAD() are positional functions. These are window functions and are very useful in creating reports, because they can refer to data from rows above or below the current row.

Tihomir Babic

When Should I Use a Common Table Expression (CTE)?

Interested in hearing more about common table expressions or CTEs? Would you like to know when CTEs are useful? Read on—we’ll discuss in this article. If you’ve heard of common table expressions, you’ve probably wondered what they do. Even if you have not, it’s good that you’re here! CTEs can be very useful, especially if you have already mastered the basics of SQL, such as selecting, ordering, filtering data, and joining tables.

Jakub Romanowski

How to Learn SQL Fast

Are you in a hurry to improve your data skills? I’ve got good news: you can learn SQL fast and move to a whole new level of data proficiency. You work with data every day, but you've had enough of how long it takes to process your giant table in Excel. The time has come for a much better tool: SQL! But how long does it take to learn SQL?

Ignacio L. Bisso

How to Calculate the Difference Between Two Rows in SQL

Calculating the difference between two rows in SQL can be a challenging task. It is possible – and there’s more than one way to do it. In this article, I’ll explain how to use the SQL window functions LEAD() and LAG() to find the difference between two rows in the same table. I like to think of this as a “happy hour" article – you can learn about two topics (calculating the difference between two rows and SQL window functions) by reading just one article.

Adrian Więch

What Is Data Engineering?

Data Engineering is a fairly new term in IT. And it’s getting more and more attention. You may have heard about a few similar fields like data science, Big Data, and machine learning. This article explains the difference between these concepts and shows how they can be combined to analyze vast amounts of data. When computers first appeared, their storage capacity was very limited. Do you remember floppy disks? They were popular in the late 20th century and typically offered around 1.

Marija Ilic

What Is a CTE?

After mastering statements like SELECT, DELETE, INSERT, and GROUP BY, you might search for ways to improve code maintainability, reproducibility, and readability. At that point, you will probably start learning about modern SQL concepts that were introduced in the early 2000s. One such SQL technique is the CTE? (common table expression) —?a temporary named result set. In this article, you will learn what a CTE is and how to use it to improve the maintenance and the readability of your code.

Jakub Romanowski

Top 10 Laptops for Learning SQL in 2020

If you want to learn SQL, you’re going to need a device that’s portable and powerful. I recommend a laptop. Here are the features you’ll need, as well as my picks for laptops to get you learning SQL in 2020! I must admit that browsing Amazon’s computer offers or entering any computer store can give you a headache. So many models, with so many options! They differ in components, workmanship, battery life, and screen size and resolution.

Agnieszka Kozubek-Krycuń

What Is a SQL Dialect, and Which one Should You Learn?

SQL, standard SQL, SQL Server, MySQL, PostgreSQL, Oracle, … You’d like to learn SQL, but you feel overwhelmed with keywords and you don’t know where to start. Let’s explain what each of those terms mean. SQL Is the Language for Talking to Databases A database is a computer program that can store and process large amounts of data. There are many different vendors of databases. PostgreSQL, MySQL, Oracle, and SQL Server are all database products by different vendors.

Rebecca McKeown

Why Learn SQL for iOS and Android Development?

App and program development with iOS and Android is a huge and rapidly growing field in the software world. While some developers get through their careers knowing only their chosen development language, there are plenty of reasons to add SQL to that skill set. Here at LearnSQL.com, we are often asked: “why Learn SQL for iOS and Android development?” To answer that question, we’ve put together a little explanation about exactly why learning SQL makes sense for those in the app development space.

Jakub Romanowski

SQL Course of the Month – PostGIS

It's summer, and it's travel time ... at least it would be under normal conditions. The pandemic is still going on, but that doesn't stop us from dreaming about distant trips and visits to beautiful places. For now, most of us will have to do it on a map. Did you know that databases can store geographical data? With interactive maps, if you find a nice summer house on the internet, you can accurately track it and plan the best route there.

Marcin Koryszewski

Listen to These 7 SQL Podcasts

Are you learning SQL online but craving more? If you're looking for a way to squeeze some sweet SQL knowledge into your day, try listening to a SQL podcast. Choose one of our picks and get ready to amp up your SQL game! If you're like me, you like to get deep into a topic. You’re practicing it whenever there’s an opportunity. Of course, It’s hard to make time. I cherish the days I’m able to sit down and just get some hands-on learning done.

Kateryna Koidan

How ORDER BY and NULL Work Together in SQL

Do NULL values come first or last when you use ORDER BY? Are they considered higher or lower than non-NULL values? In this article, I’ll explain how different relational databases treat NULL values when sorting output and how to change the default behavior of the ORDER BY clause. When LearnSQL users practice the ORDER BY clause in our SQL Basics course, they often ask why NULL values appear first in the output and how they can change this behavior.

Jakub Romanowski

How to Publish a LearnSQL.com Course Certificate on LinkedIn

LinkedIn draws both job seekers and recruiters. Showcasing your knowledge, skills, and experience on this professional networking site can lead to great opportunities. We know this well at LearnSQL.com. Have you finished one of our courses? Great! Tell your future employer about what you have learned. Here's a step-by-step how-to guide for publishing a course certificate on LinkedIn. I will show you how easy it is to publish a LearnSQL.

Dorota Wdzięczna

TRUNCATE TABLE vs. DELETE vs. DROP TABLE: Removing Tables and Data in SQL

What’s the difference between truncating, deleting, and dropping a table in SQL? Find out in this article. There are a lot of ways to delete data in SQL, including the DELETE, TRUNCATE TABLE and DROP TABLE commands. Which one should you use in a given situation? In this article, you’ll learn the syntax of each command in different database engines like MySQL, PostgreSQL, SQL Server, and Oracle. And you’ll understand the DROP TABLE vs.

Kate Stolarek

How to Learn the SQL Syntax

Read about what SQL is, and choose the best way for you among a wide variety of possibilities for learning SQL and remembering its syntax. What Is SQL? “SQL” stands for “Structured Query Language,” and as it sounds, it is a language dedicated to querying a relational database. In practice, it is used for creating, designing, and managing a relational database. People use SQL to: Create sets of tables and rows Modify database tables and index structures Insert, update, and delete data Retrieve information from a database for a variety of uses such as analytics Relational databases consist of a set of tables containing rows and columns of data.

Jakub Romanowski

A Mathematician in the World of SQL

She has a PhD in Mathematics and over 10 years’ experience teaching mathematics and computer science at the University of Warsaw. She knows SQL better than just about anyone I’ve met. Let’s get to know Agnieszka Kozubek-Krycuń, Vertabelo’s Chief Content Officer at Vertabelo. Let's go back in time. How did your adventure with math start? I’ve always enjoyed abstract concepts and problem solving. I was fascinated by variables when we learned to solve simple equations like x+2=5 in primary school.

Adrian Więch

Last-Minute Preparation Tips for a Database Class Exam

Getting to learn SQL is fun. You don’t really need to spend much time to understand some basic SQL concepts and use them fluently. If you’re a student facing your first database class exam soon, we’ve got you covered. In this article, we explain what you should focus on while learning SQL and studying for an entry-level database exam. Check your knowledge with our 10 sample questions and discover where you can find more SQL practice.

Tihomir Babic

How to Practice SQL Window Functions at Home

Are you looking for a way to maintain your knowledge of SQL window functions? What’s the best way to practice them at home? Here are some suggestions. Learning something new feels great, but it’s also arguably the easiest part of gaining knowledge. You’ve probably experienced that yourself. You struggle with learning an idea, and then you finally get it! There’s the feeling you’ve learned something. And then, very soon, you practically have to start all over again with the very same concepts.

Jakub Romanowski

The Best SQL Social Media Groups and Channels to Follow in 2020

We get news, advice, and funny videos from Facebook, Twitter, and YouTube. Why not use social media to help you learn SQL? You wake up and the first thing you do is check for Facebook notifications. Do you take a photo of your breakfast and share it with friends on Instagram? Maybe you argue with someone on Twitter about which James Bond was the best? Or maybe you are recording a short TikTok video of you singing Lady Gaga?

Kamil Bladoszewski

What’s an SQL Inline Query?

Have you ever heard the term “inline query”? How are they different from subqueries and derived tables? Have you looked this up in numerous places and still don’t know the answer? Let’s embark on a journey and find out together! The first time I heard the term “inline query”, I was a little bit surprised. It doesn’t sound like one of SQL’s nuances and I thought I knew all the basic concepts.

Dorota Wdzięczna

Monthly SQL Challenges

SQL learners sometimes need challenges. Do you want to test your problem-solving skills or your knowledge of SQL? Then take our monthly SQL Challenges! We prepare them on LearnSQL.com every month. Each Challenge relates to a different interesting topic and will help you keep your SQL game sharp. In this article, you'll discover what our LearnSQL.com Monthly Challenges are and where to find them. We’ll also look at the Challenges collected in our Monthly SQL Challenge Mini Track.

Kateryna Koidan

Practical Examples of When to Use Non-Equi JOINs in SQL

If you think that two tables in SQL can be joined only using the common field, you will be excited to learn that there are other ways of joining. Non-equi JOINs use different kinds of comparison operators in the JOIN condition. In this article, I’ll guide you through non-equi JOIN examples to show the common use cases for this type of JOIN. Equi JOIN vs. Non-Equi JOIN How do you usually join two tables in SQL?

LearnSQL.com Team

SQL Course of the Month – SQL Practice Set

It is said that practice makes perfect. I agree with this statement one hundred percent. What is applicable in basketball training, playing an instrument, or learning a foreign language is also useful in learning SQL. Practicing writing queries, using functions, and putting together clauses is the basis for learning the true power of SQL. But how and where do you practice SQL? I spoke with Agnieszka Kozubek-Krycuń, Chief Content Officer at Vertabelo about this.

Pierre Timms

How to Convince Your Boss That You Need to Start Learning SQL

Learning SQL is a great goal. Now, if you could only convince your boss that it’s good for the company as well as for you ... You’re aware of the benefits of adding SQL to your skill set. You believe that the rewards gained from you learning SQL will also benefit your employer – it’s not just another way for you to develop your professional profile. But how do you articulate this to your boss?

Rebecca McKeown

Top 5 Programming Languages to Learn Alongside SQL

If you already know or are about to learn SQL, you’re well on your way to being a sought-after database administrator, database engineer, or just a general database whizz kid! SQL is a modern, widely-used language that finds application in almost every industry. There is no shortage of jobs with SQL. But what if you want to branch out and learn another language to complement your SQL knowledge and skills?

Zahin Rahman

How to Learn SQL JOINs

JOINs are one of the most fundamental and commonly used SQL commands for manipulating and querying real-world data sets. They are also one of the more challenging SQL topics to master! In this article, you’ll learn an effective strategy to learn the different types of SQL JOINs. When data is stored in a single table, we can easily retrieve rows and get all the information we need. But when businesses scale, so does their data.

Kateryna Koidan

What Are the Different Types of SQL Subqueries?

Subqueries can be used in many business cases. What subquery types does SQL offer? And how can you use them efficiently? In this article, I’ll guide you through different subquery types and the typical situations when they are useful. What Is an SQL Subquery? A subquery, or nested query, is a query placed within another SQL query. There are many different scenarios where you may want to include a query in the WHERE, FROM, or SELECT clauses of your main query.

Dorota Wdzięczna

Subquery vs. JOIN

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.

Tihomir Babic

5 Advanced SQL Constructions Every Data Analyst Should Learn

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.

Rebecca McKeown

Is it Difficult to Learn SQL?

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.

Kamil Bladoszewski

Subquery vs. CTE: A SQL Primer

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.

Ignacio L. Bisso

How to Number Rows in an SQL Result Set

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.

LearnSQL.com Team

SQL Course of the Month – Creating Basic SQL Reports

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?

Dorota Wdzięczna

Overview of Ranking Functions in SQL

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:

Ignacio L. Bisso

Beginner’s Guide to the SQL Subquery

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.

Tihomir Babic

Advanced SQL Interview Questions (and Answers)

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.

Adrian Więch

SQL in Google Sheets? Yes, We Can!

Did you know that you can write SQL-like queries in Google spreadsheets? This feature is incredibly powerful, versatile, and can replace most of the functionalities offered by Excel’s pivot tables. Read our article to find out how you can easily use the QUERY function to efficiently work with your Google Sheets data. Relational databases share many features with spreadsheets. When we explain what databases are, we often say that they are a bit like spreadsheets except they give us more control over larger amounts of data.

Marija Ilic

Why Should I Learn SQL Window Functions?

SQL has been around for more than 25 years. Its basic syntax – like SELECT, WHERE, GROUP BY, HAVING, and ORDER BY – is well known. But is there something besides traditional SQL? Can you go beyond the basics and improve your skills? The answer to this question is yes. There is a modern version of SQL. In this article, we are going to dive into the modern version and learn about SQL window functions.

Kateryna Koidan

What Is a Nested Query in SQL?

Have you ever wished that you could build a query with several SELECT statements? Good news! You can do this – and a lot more – with SQL’s nested queries. If you’ve been learning SQL (and maybe writing some queries) for a while, you’ve probably encountered cases where it looks like you need another SELECT statement inside your main statement. You may wonder “Is it possible to use nested SELECTs in SQL?

Dorota Wdzięczna

Advanced SQL Courses for Data Analysts – A Complete Review

Even data analysts who already know SQL need to keep their skills sharp. Where can you find the best advanced SQL courses for data analysts? Check out our review of the top online sources! In this article, I present a list of online SQL courses for data analysts. These courses are offered by various platforms. Why wait? Let’s jump right in! 8 Advanced SQL Courses for Data Analysts Let's take a closer look at these courses to decide which platform will be better for you in learning SQL.

Dorota Wdzięczna

You Want to Learn SQL? You've Come to the Right Place!

It is difficult to list all the benefits of learning SQL. You will work faster and more efficiently with a database, you will no longer be dependent on the IT department, and you will be able to analyze the data yourself and draw appropriate conclusions, among others. Add reporting to this, and you will get a very wide range of cool and useful skills. Maybe you want to change jobs or get a promotion?

Rebecca McKeown

What SQL Practice Do You Need to Prepare for a Technical Job Interview?

You’ve scored yourself an interview for an SQL-related job. Nice work! But perhaps uncertainty is creeping in as your interview date looms closer. Do you know enough SQL to make the cut? What questions are you likely to be asked? What SQL practice should you be doing before your interview? Almost all SQL job candidates go through exactly the same nerve-wracking process. Here at LearnSQL.com, we have the lowdown on all the SQL practice and preparation you’ll need to ace those interview questions and take your career to the next level.

Kateryna Koidan

Is SQL a Programming Language?

SQL is a powerful tool for communicating with database management systems. When you write SQL queries, you give instructions to the computer, and it performs these instructions—it sounds like programming. However, you cannot build an application with SQL as you can with Python or Java. So, is SQL a programming language? What Is SQL? Let’s start with the basic definition. SQL, or Structured Query Language, is a language used for communication with relational databases.

LearnSQL.com Team

SQL Course of the Month – Window Functions

Spring has come. It is nicer outside. It's a great time to learn something new. Which course should you choose? In April, it's worth it to bet on SQL window functions. What are they, what are they used for, and why are they worth knowing? I asked Agnieszka Kozubek-Krycuń, Chief Content Officer at Vertabelo, these questions. She has a PhD in mathematics and over 10 years’ experience teaching mathematics and computer science at the University of Warsaw.

Dorota Wdzięczna

What Is a SQL Running Total and How Do You Compute It?

The SQL running total is a very common pattern, used frequently in finance and in trend analysis. In this article, you’ll learn what a running total is and how to write a SQL query to compute it. The best way to learn SQL is through practice. LearnSQL.com offers over 30 interactive SQL courses at various level of difficulty. Each course is interactive: there is a little bit of reading, followed by an exercise to practice what you've just read.

Kate Stolarek

Is SQL Worth Learning?

We’re in the 21st century. These are the “ultimate data times” in which loads of information on all kinds of things is available. We want to explore this info even more, slice and dice it, understand where it comes from and what triggers it. With such large amounts of data coming in, people have discovered that spreadsheets aren’t enough. There’s a need for a greater solution, something like a spreadsheet on steroids.

Arleta Więch

Top 3 Platforms to Learn SQL Online: A Complete Comparison

Do you want to learn SQL online? Where do you start? There are many choices on the internet, and it can be hard to decide. But don’t worry—I tested and compared three major platforms to help you find the best place to learn SQL online! E-learning is on the rise. It gives us infinite possibilities of growing our professional careers without leaving our homes. And increasing our competencies is especially important now that the labor market has become dynamic and unstable.

Tihomir Babic

When Do I Use SQL Window Functions?

Have you heard one of your colleagues bragging about using SQL window functions? Do you know basic SQL but not much, or anything, about window functions? If you want to learn about window functions and how to use them in a business context, you’re in the right place! This happens often. You reach a certain level of knowledge, and you feel like the king (or queen) of the world.

Kamil Bladoszewski

How to Join 3 Tables (or More) in SQL

Using JOIN in SQL doesn’t mean you can only join two tables. You can join 3, 4, or even more! The possibilities are limitless. If you’ve just learnt JOINs in SQL, you might think that it’s limited to two tables. That’s not surprising – this concept can be hard to understand, and the idea that JOINs can get even more complicated may be really scary at first. The truth is that you can easily extend this idea to three tables or even more.

Agnieszka Kozubek-Krycuń

Why Take the “SQL Basics” Course at LearnSQL.com

LearnSQL.com’s interactive “SQL Basics” course teaches the foundations of SQL. Discover why we built this online course, our philosophy behind it, and what it contains! What Is SQL, and Why Should You Learn It? SQL is a language used to talk to databases, computer programs that hold data and can process it efficiently. SQL can select data from a database and perform various computations on the data, be they simple or complex.

Emil Drkušić

What Is the Difference Between a GROUP BY and a PARTITION BY?

Window functions are a great addition to SQL, and they can make your life much easier if you know how to use them properly. Today, we will address the differences between a GROUP BY and a PARTITION BY. We’ll start with the very basics and slowly get you to a point where you can keep researching on your own. PARTITION BY vs. GROUP BY The PARTITION BY and the GROUP BY clauses are used frequently in SQL when you need to create a complex report.

Zahin Rahman

What is the Best SQL Training Online?

In today’s data-driven world, SQL is a highly sought-after skill, but it cannot be mastered merely over a fortnight. With so many resources at your disposal to learn SQL, where do you even consider beginning, and how do you practice SQL? Savvy and knowledgeable database professionals have consistently been in high demand over the last five years. If you are aiming to advance your career as a database developer, administrator, warehousing specialist, or analyst, SQL training and mastery is an absolute necessity.

Marija Ilic

How to Analyze Time Series COVID-19 Data with SQL Window Functions

The COVID-19 pandemic really changed the way we live. No matter where you are, you're being impacted by this unpredictable virus. We do not know what the future holds, but we do believe in science and in better days to come. One thing that makes me as a data analyst particularly happy is that we have publicly available data. We can analyze that data and learn something from it. If you want to explore COVID-19 with the help of modern SQL constructions, keep reading — this article is intended for you.

Ignacio L. Bisso

SQL Window Functions vs. GROUP BY: What’s the Difference?

A very common misconception among SQL users is that there is not much difference between SQL window functions and aggregate functions or the GROUP BY clause. However, the differences are very significant. Perhaps the only similar point between GROUP BY and window functions is that both allow you to execute a function (such as AVG, MAX, MIN, or COUNT) on a group of records. I’d say that window functions’ special power is that they allow us to obtain results that otherwise would be almost impossible to achieve.

Arleta Więch

Choose the Best Way to Learn SQL

SQL has become a hot topic in the professional world, and many resources have appeared both online and offline for learning SQL. It’s easy to get lost in the jungle of books, tutorials, and courses. Which resources do you choose? If you want to know how to learn SQL quickly and effectively, take a look at my list. There are many reasons for learning SQL. We asked our users about them and learned that there was no universal motive.

Dorota Wdzięczna

SQL Cookbook with Recipes for Success

The internet holds a lot of information and can provide solutions to various problems. SQL users, both beginners and advanced, often turn to the internet for help with SQL queries. This article will help you find the right SQL queries to solve your problems. Learn what the SQL Cookbook is and why you should use it. You will also find a list of the most important recipes, from which you will prepare a great SQL dish with the taste of success.

Kate Stolarek

Are There Any Good SQL Courses for Marketers?

Looking for places to learn SQL online and level up your marketing efforts? Check out these SQL courses. Introduction With the help of IT experts, meticulous marketers analyze information to create advertising strategies. This commonplace state of affairs forces the marketer to rely on data experts and sometimes wait for their availability. But what if marketers could pull the data themselves? They can – by turning into a technical marketer.

Agnieszka Kozubek-Krycuń

How to Get the First Day of the Week in SQL Server

This is additional content for the LearnSQL.com course Customer Behavior Analysis in SQL Server. In the previous article, we talked about how you can use the SQL Server DATEPART() function with week or iso_week to group events by week. The query might look like this: SELECT DATEPART(week, RegistrationDate) AS Week, COUNT(CustomerID) AS Registrations FROM Customers WHERE '20180101' <= RegistrationDate AND RegistrationDate < '20190101' GROUP BY DATEPART(week, RegistrationDate) ORDER BY DATEPART(week, RegistrationDate); The result looks something like this:

Agnieszka Kozubek-Krycuń

How to Group Data by Week in SQL Server

This is additional content for the LearnSQL.com course Customer Behavior Analysis in SQL Server. In this course, we showed you how you can analyze the customer lifecycle (customer acquisition, conversion, activity, retention, and churn) with SQL. We discussed customer registration cohorts, or groups of customers who registered during the same period (e.g. same week, same month). Analyzing customer registration cohorts lets you see registration trends and relate registration cohorts with marketing campaigns.

Jakub Romanowski

Types of Database Jobs: Choose One of Them and Start Being Awesome

Do you dream of high earnings and interesting work? Are you fed up with your boss and his or her annoying vacation stories in exotic countries? Is it time to change your job? Why not learn SQL? Here are some examples of the types of database jobs that may lead you to a better life. What types of database jobs use SQL? Here are some examples, but first, a small caveat.

Rebecca McKeown

50 Best Resources for Learning SQL

Do you want to know where to learn SQL? We’ve got you covered with the ultimate list of 50 resources for learning SQL, including the best SQL courses, tutorials, books, and much, much more! Learning SQL can be hard enough without wading through thousands of websites and articles. So, we thought we’d do you a solid and put the top SQL resources here in this handy slice of the internet.

Agnieszka Kozubek-Krycuń

Why Window Functions Are Not Allowed in WHERE Clauses

Window functions are extremely powerful, but there are a lot of nuances and little details you need to learn about using window functions in order to use them correctly and efficiently. A fairly common question SQL users have is why window functions are not allowed in WHERE. TL;DR: You can use window functions in SELECT and ORDER BY. You cannot use window functions in WHERE, GROUP BY, or HAVING.

Magdalena Wojtas

How to Practice SQL After a Video Course

When you're just starting to learn coding, the most obvious first step is to watch online video courses. They're one of the most popular ways to learn the basics of a new technology without investing a lot of time and money. But you need to do more than that to master the topic. What should be your next step? When someone asks me about how to start learning to code, I often recommend trying video tutorials first.

Kamil Bladoszewski

How to Rank Rows in SQL: A Complete Guide

Don’t struggle with SQL ranking functions anymore! This article will guide you through the most common ranking use cases. Rankings are used around us every day. Sports tournaments, the best movies and TV series on Netflix, stores with the cheapest products—these are only a few examples of rankings you might’ve seen recently. Using SQL RANK functions might be hard sometimes. The variety of different constructions is enormous. You can easily get lost in everything there is to learn about ranking.

Emil Drkušić

How to Practice SQL JOINs

There is no better way to learn SQL joins than through practice. However, there will probably be obstacles along the way. I’ll cover some of these obstacles and give ideas for how to overcome them. While this article won’t turn you into SQL JOINs expert, it will show you how to become one. So, let’s start! Challenges When Practicing SQL JOINs It’s hard to answer “How do you master SQL JOINs?

LearnSQL.com Team

Stay at Home and Learn SQL for Free with LearnSQL.com

Working remotely is a dream come true for some. You ditch commuting and have more time for the people you love and the things you enjoy. For others, it's a challenge to maintain their focus when there are new distractions. It's also an opportunity to invest the few gained hours in learning something new. Staying at home can be a time when you might find yourself busier than you've ever been, but not getting many things done, and worse, not learning what you planned to.

Kate Stolarek

Video Tutorial or Interactive SQL Course – Which Is Better?

Are you ready to get started with SQL but unsure which learning method is the most effective? In this post, we’ll talk about the pros and cons of learning SQL from an instructional video vs. an interactive online course. Are you a chronic Internet-using student who’s planning to learn SQL? Maybe you did some research but still don’t know which kind of training is worth your (limited) time. We all have families, hobbies, and other after-work commitments, and finding the right resource for learning SQL will save you some time.

Zahin Rahman

The Top 7 Platforms with the Best SQL Courses for 2020

Are you struggling to narrow down which platforms are the best for learning SQL online? We have all been there. I know how confusing it can be when choosing amongst the hundreds of resources available. Find out below which platforms offer the most enriching and seamless SQL learning experiences online. In this article, I will review the platforms with the best online SQL courses offered this year. Whether you are a student looking for your first job, a professional hoping to transition to a data analysis, or an experienced data practitioner, there are plenty of great opportunities to learn SQL online at various levels of technical ability.

Rebecca McKeown

Learning SQL? 12 Ways to Practice SQL Online

If you’re currently learning SQL, you may have found yourself knee-deep in reading material and may be wondering how on earth you can bridge the gap between book knowledge and real-life SQL application. In this article, we bring you 12 of the most effective ways to practice SQL online, taking you from a bookworm to a database butterfly in no time at all! All theory and no practice will make you a frustrated SQL user!

Jakub Romanowski

How to Stay Healthy When Learning SQL

So, maybe you’re learning SQL. Congratulations! Or maybe you already work as a data analyst, DBA, or data scientist. That’s great too! Either way, you are most likely spending hours in front of a computer. I will give you tips on how to avoid bad habits and take care of your health while learning and/or working with SQL. Have you ever wondered how sitting in front of a computer affects your health?

Emil Drkušić

How to Become an SQL Developer

There is no simple answer to the question “How do you become an SQL developer?” However, if the answer were too complex, there would be no point in writing this article, and yet I’m doing it. So, somewhere along the way, we’ll find the answer. As said in the intro, there is no magic wand that will turn you into an SQL developer. But reading this article will save you some time and help you focus on what is important to achieve your goal.

Rebecca McKeown

How Long Does It Take to Learn SQL? Top Tips for SQL Proficiency

Is it hard to learn SQL? How long does SQL mastery take? This article will answer those questions and get you started with the most useful SQL commands. How long does it take to learn SQL? If you’ve ever dabbled in Spanish or French, you know that learning a new language is tough and can take years. Luckily, mastering SQL is a much faster journey than conquering por/para or un, deux, trois.

Ignacio L. Bisso

HAVING vs. WHERE in SQL: What You Should Know

This article is about SQL’s WHERE and HAVING clauses. Both clauses are part of the foundations of the SQL SELECT command. They have similar uses, but there are also important differences that every person who uses SQL should know. Let’s see what’s behind the HAVING vs. WHERE debate. In this article, we’ll suppose we work for a government social agency supporting people or families whose income is below a certain threshold.

Dorota Wdzięczna

19 Top SQL Articles for Beginners Published in 2019

In 2019, a lot of new SQL articles were written for beginners. This kind of resource is useful not only for professionals. SQL articles allow you to develop skills, expand your knowledge, and use SQL in practice. They are a very good way to learn SQL. In this post, I gathered 19 top SQL articles of 2019. Let’s also learn SQL from articles! List of Top SQL Articles Published in 2019 We will start with five of the best articles published on the LearnSQL.

Jakub Romanowski

How to Practice SQL

Do you already know what SQL aggregation functions are, what JOINs are, and how “group by” is different than“order by”? Great, congratulations. But don't you think that in order to master SQL and be able to apply it, you need to practice? We advise you on how to practice SQL to prepare for a data analyst job interview or to simply boost your knowledge effectively. Because, as they say, SQL practice makes perfect.

Rebecca McKeown

SQL INSERT, SQL UPDATE, SQL DELETE – Oh My!

Need to understand SQL INSERT, UPDATE, or DELETE? We'll get you up to speed with a comprehensive How-To and useful examples! SQL INSERT, UPDATE, and DELETE statements—what are they all about? If you're a data engineer, a database administrator, or even just your average data fanboy or girl, one day you're going to find yourself with a database that becomes your "baby." Charged with this special bundle of joy, you're going to need to feed and change the little fella.

Jakub Romanowski

SQL, Databases, and Hollywood Movies

Policemen, doctors, lawyers, scientists, teachers: These are the professions that we often see in Hollywood movies. But are movies also trying to show what the work of data analysts looks like? Here is a list of six movies in which screenwriters, directors, and producers decided to cast SQL and databases in the main roles. Data analysis is most often associated with business, reporting, and making key decisions for the company.

Shanika Wickramasinghe

Difference between GROUP BY and ORDER BY in Simple Words

For someone who is learning SQL, one of the most common places to get stuck is when learning the GROUP BY command. GROUP BY and ORDER BY are two important keywords in SQL that we use to organize data. The difference between GROUP BY and ORDER BY is that ORDER BY is more simple than GROUP BY and is usually introduced early in an SQL course. Sometimes, people are quite confused over these two concepts (SQL ORDER BY vs.

Jakub Romanowski

Join us on Facebook–We Can Learn More Together

We are so happy that you have joined us to learn and develop your SQL skills! We want to invite you to a new Facebook group, We Learn SQL. It is a great place for anyone interested in meeting like-minded people who also want to learn about database-related concepts. Learning together is easier, don't you think? Joining this group is a great opportunity to begin sharing your learning experiences with others.

Belma Mesihovic

Grouping Data in SQL Server

People who work with data know that data grouping can sometimes be a chore. If you struggle and waste hours with Excel, OpenOffice, or some other tool trying to group various sets of data, take a look at this article and learn how to do the work much quicker and easier by using SQL. You often find yourself in a situation where you need to analyze data and present the results in a form other than the one in which the data is stored.

Ignacio L. Bisso

SQL Order of Operations

SQL is not a traditional programming language in which you write a sequence of instructions in a given order of execution. Instead, SQL is a "declarative" language, which means that by writing a SQL query, you declare what data you expect as a result of the query, but you don't indicate how to obtain it. Six Operations to Order: SELECT, FROM, WHERE, GROUP BY, HAVING, and ORDER BY By using examples, we will explain the execution order of the six most common operations or pieces in an SQL query.

Dorota Wdzięczna

The Most Important SQL Queries for Beginners

How do you get data from a table? How do you create or delete a table? How do you display distinct records? How do you select rows which store a specific value in a column? You can easily do all of this by writing basic SQL queries. This guide discusses the 30 most important SQL queries for beginners. Let's take a look. 1. Retrieving Data From All Columns This is a very basic query to display all data from a table.

Jakub Romanowski

YouTube Tutorials That Actually Teach You Some SQL

YouTube is not just funny cats, music clips, and viral videos. It can also be a mine of knowledge – if you know where to look. Can YouTube tutorials really help you learn SQL? Let's say you're a marketer or an accountant. You work with databases every day. But when it’s time to write a query and get specific data, you need to call someone from IT. Why not learn to do it yourself?

Dorota Wdzięczna

24 Rules to the SQL Formatting Standard

Writing queries to a database requires knowledge about SQL syntax, but this is not all you should know. Best practices for writing professional SQL code require good formatting skills. In this article I discuss why this is so important and what are the basic rules you should follow. Why is it Worthwhile to Format SQL Code? Beginner SQL programmers often don't pay much attention to formatting their code. If you think formatting is something that can be safely ignored, look at the code below:

Ignacio L. Bisso

SQL INNER JOIN Explained in Simple Words

In this article, I will cover perhaps the most important element of the SQL language. That's right! I'm talking about the SQL INNER JOIN clause. As you know, in a database the data are stored in several tables. In my last article, I covered how to create SQL queries when the data you need is in only one table. But what if the data you need is in two tables?

Adrian Więch

Forget About Excel, High Five With SQL

Find out why you should forget about Excel and start using SQL even if you're not an IT expert. We'll show you how easy it is to learn SQL, how it can make you work better, and how LearnSQL.com makes the learning process fun. "I Don't Deal With Data" We frequently hear the sentence above from people outside the IT industry. Well, it's not entirely true. Data is now almost everywhere.

Dorota Wdzięczna

14 Differences Between Standard SQL and Transact-SQL

In my last article, I roughly described how standard SQL differs from T-SQL and who should learn which. Now I'd like to focus on the syntax differences and illustrate these differences with examples. If you think T-SQL is an extension implementing all the features from standard SQL, you aren't right. However, in SQL Server you will find almost all the features of the SQL standard. In this article you will find examples of some of the differences in syntax between standard SQL and Transact-SQL.

Michał Kołodziejski

Get to Know the Power of SQL Recursive Queries

Most commonly, the SQL queries we run on a database are quite simple. Well, that depends on your role, of course. Analysts in data warehouses retrieve completely different sorts of information using (very often) much more complicated queries than software engineers creating CRUD applications. However, sometimes it's simpler or more elegant to run a query that is a little bit more sophisticated without needing further data processing in the code.

Dorota Wdzięczna

What's the Difference Between SQL and T-SQL?

If you are beginning to learn SQL and are confused by the differences between standard SQL and other similar languages like T-SQL, this article will help make things clear. You’ll not only learn about the difference between SQL and T-SQL but also find explanations concerning which topics would be better to start learning first: standard SQL or something more specific like MS SQL Server. What is Standard SQL? SQL (Structured Query Language) is a basic ANSI/ISO standard programming language designed to operate on data stored in relational databases.

Roman Pijacek

Microsoft SQL Server Pros and Cons

Thinking about using Microsoft SQL Server? If so, you’re in the right place. In this article, we’ll go over the pros and cons of Microsoft SQL Server and evaluate the platform from both a company’s and a data specialist’s perspective. What Is Microsoft SQL Server? Before diving into the pros and cons of Microsoft SQL Server, I’ll explain what it is. In technical terms, it is a relational database management system (RDBMS) developed by Microsoft.

Ignacio L. Bisso

How to Install PostgreSQL on Windows 10 in 5 Minutes

It may look like a complicated task to install PostgreSQL, Oracle, or SQL Server or any other database software, but it really isn’t! These days, most relational database management systems come with installation wizards that make the process much simpler. In this article, we’ll look at how to install PostgreSQL and test that the installation is working. Install PostgreSQL: Steps Involved To install PostgreSQL, we’ll complete the following tasks:

Aldo Zelen

How SQL supports data-driven organization

Typical business users make decisions based on gut feelings, but this can't get them so far. In this article, we'll look at how learning to write basic SQL queries helps your company become a data-driven organization. Businesses face many decisions. Do we increase our advertising budget in one region or the other? Are certain products selling quickly enough? What we should do if they aren't? Most of these decisions are driven by intuition, but organizations that make the most business impact use data-driven decision-making.

Dorota Wdzięczna

Microsoft SQL Server 2017 Installation Step by Step

Microsoft SQL Server is one of the most popular professional database servers on the market. In this guide, I’ll show you all SQL Server 2017 installation steps to help you install it on the Windows operating system together with SQL Management Studio. If you want to learn T-SQL, the dialect of SQL used in SQL Server, check out our SQL from A to Z in MS SQL Server track.

Ignacio L. Bisso

How to Begin Running SQL Queries

In this article, I’ll explain how to run a SQL query to help you execute your first one. Let’s jump right in! Running SQL queries for the first time is not a complex task, but it can seem intimidating at first if you’re a complete beginner. But once you get past that initial roadblock, you’ll be able to focus on learning SQL and writing more interesting queries to meet your business needs.

Dorota Wdzięczna

Our Picks for 2020’s 7 Best Online SQL Schools

If you’re looking for the best online SQL courses but aren’t sure where to start, you’re in the right place. I evaluated the top 7 ranked SQL schools available online to help you find the right solution. While summer is a great time to relax and get away from work, it’s also an excellent opportunity to learn new skills – like SQL! Thanks to SQL schools putting their courses on the internet, learning new tech skills is super easy and you can choose from a variety of formats to suit your needs.

Kate Stolarek

Here’s Why You Should Learn SQL

Why learn SQL? We asked our users about it. This is what we’ve learned. At LearnSQL.com, we help people with no computer science background to understand the core concepts of databases and data science. For example, we teach users how to extract the most important data from a database to build simple reports and how to understand key statistical metrics in data analysis. We love to provide easy-to-understand examples that thoroughly depict complex technical concepts.

Alex Briggs

5 Great Benefits of Learning SQL

If you want your business to succeed in 2017, it’s absolutely critical that you understand your data; this is why you should get acquainted with SQL ASAP. But there are other reasons to learn it that may not be obvious. In this article, I’ll show you 5 huge benefits of learning SQL! Don’t fall for the common trap—analyzing data isn’t just a concern for those competing at national or corporate levels.

Kacper Skawina

LearnSQL.com Review: “SQL Cookbook” by Anthony Molinaro

Recipes that make querying easy, even for the novice. In today’s information age, we have at our fingertips almost an overabundance of teaching and information on any and every subject. In the midst of this glut of information, it can be hard to decide which is the best source for our needs. But, fear not; we are here to assist you as you navigate through decisions about books on SQL topics!