Create free account
User profile menu open
Open user profile menu
Payment & Billing
Payment & Billing
Create free account
6 Oct 2021
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!
5 Oct 2021
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.
1 Oct 2021
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?
1 Oct 2021
New Monthly SQL Practice for October 2021!
Do you have fundamental SQL knowledge? Do you know how to write basic SQL queries and join more than one table? If the answer is yes, you have a chance to test your knowledge by solving business problems with a new SQL Practice, available every month on LearnSQL.com. The October SQL Practice is at the basic level. You will check your SQL skills with data about a furniture store. Currently, the store operates only in Cleveland, Ohio in the U.
30 Sep 2021
Ignacio L. Bisso
What Is the OVER() Clause in SQL?
Window functions are one of SQL’s most powerful resources, but they are not frequently used by the average SQL developer. In this article, we will explain how you can define different kinds of window frames using the OVER clause. The OVER clause is essential to SQL window functions. Like aggregation functions, window functions perform calculations based on a set of records – e.g. finding the average salary across a group of employees.
29 Sep 2021
Why Do Relational Databases Use Primary Keys and Foreign Keys?
Relational databases organize data in a standardized manner. All data is entered into tables, the so-called relations. The tables are linked with one another to create connections between the data. The backbone of any relational database is the primary and foreign keys. Read along to find out why they are so important. In this article, we focus on the reasons why relational databases use primary and foreign keys. First, we review what primary and foreign keys are.
28 Sep 2021
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!
24 Sep 2021
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.
23 Sep 2021
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.
22 Sep 2021
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.