Skip navigation
Courses
Pricing
For Students
SQL Library
Articles
Cookbook
Cheat Sheets
For Beginners
Best Way to Learn SQL
SQL Primer
Flashcards
About Our Courses
Guides
150+ SQL Practice Exercises
100+ SQL Interview Questions
SQL Interview Cheat Sheet
GROUP BY and Aggregate Functions Guide
SQL JOINs Guide
Window Functions Guide
Numeric Functions Guide
String Functions Guide
Common Table Expressions
Log in
Create free account
fullName
User profile menu open
Open user profile menu
fullName
Dashboard
My Profile
Payment & Billing
Log out
MENU
CLOSE
Courses
Pricing
For Students
Articles
Cookbook
Cheat Sheets
Best Way to Learn SQL
SQL Primer
Flashcards
About Our Courses
150+ SQL Practice Exercises
100+ SQL Interview Questions
SQL Interview Cheat Sheet
GROUP BY and Aggregate Functions Guide
SQL JOINs Guide
Window Functions Guide
Numeric Functions Guide
String Functions Guide
Common Table Expressions
Dashboard
My Profile
Payment & Billing
Log in
Create free account
Log out
Articles
Cookbook
6 Oct 2021
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!
Read more
5 Oct 2021
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.
Read more
1 Oct 2021
LearnSQL.com Team
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?
Read more
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.
Read more
29 Sep 2021
Martyna Sławińska
Why Use Primary Keys and Foreign Keys in Databases?
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.
Read more
28 Sep 2021
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!
Read more
24 Sep 2021
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.
Read more
23 Sep 2021
Himanshu Kathuria
Find Top Salaries by Department with SQL
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.
Read more
22 Sep 2021
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.
Read more
21 Sep 2021
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.
Read more
««
«
1
2
3
46
47
48
89
»
»»