Skip navigation
Courses
Pricing
For Students
SQL Library
Articles
Cookbook
Cheat Sheets
For Beginners
Best Way to Learn SQL
SQL Primer
Flashcards
Guides
SQL Practice
GROUP BY and Aggregate Functions
SQL JOINs
Numeric Functions
String Functions
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
SQL Practice
GROUP BY and Aggregate Functions
SQL JOINs
Numeric Functions
String Functions
Dashboard
My Profile
Payment & Billing
Log in
Create free account
Log out
Articles
Cookbook
1 Jan 2022
LearnSQL.com Team
New Monthly SQL Practice for January 2022!
Ready for our new SQL challenge? This time, we have prepared some slightly more difficult SQL tasks. Here’s January’s SQL Practice course! This time you will be helping Monica, the owner of an online store. She’d like to analyze her business data and earn more. It’s the perfect opportunity to use your SQL window functions skills. Can you find out how many customers she has in each country? Can you create reports to help her see sales trends?
Read more
30 Dec 2021
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?
Read more
28 Dec 2021
Karolina Niewiarowska
Here’s How I Started Creating SQL Reports
Once upon a time, there was a girl who was just starting her adventure with learning SQL. As a marketer, one of her tasks was writing reports. Previously, she used Excel, a calculator, and written notes to prepare the reports her boss required. One day, it turned out that she could do her job much faster and easier. That was the day she read about SQL reports for the first time.
Read more
23 Dec 2021
Ignacio L. Bisso
How to Use the SQL PARTITION BY With OVER
At the heart of every window function call is an OVER clause that defines how the windows of the records are built. Within the OVER clause, there may be an optional PARTITION BY subclause that defines the criteria for identifying which records to include in each window. Read on and take an important step in growing your SQL skills! What Is the PARTITION BY Clause in SQL? The SQL PARTITION BY expression is a subclause of the OVER clause, which is used in almost all invocations of window functions like AVG(), MAX(), and RANK().
Read more
16 Dec 2021
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?
Read more
14 Dec 2021
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.
Read more
9 Dec 2021
Tihomir Babic
How to Join Tables in SQL Without Using JOINs
Here’s how you can combine tables without the JOIN keyword. It seems like it shouldn’t be possible: join tables in SQL without using the JOIN keyword. But using the JOIN keyword is not the only way to join tables in SQL. This article will show you two additional methods for joining tables. Neither of them requires the JOIN keyword to work. They are: Using a comma between the table names in the FROM clause and specifying the joining condition in a WHERE Using UNION/UNION ALL.
Read more
7 Dec 2021
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.
Read more
1 Dec 2021
LearnSQL.com Team
New Monthly SQL Practice for December 2021!
If you are a more advanced SQL user who is comfortable writing complex JOINs, you can check your knowledge with December's SQL Practice. Every month on LearnSQL.com, you'll find a new challenge to solve. Maybe this is the first time you've come across our Monthly SQL Practices. LearnSQL.com offers one SQL Practice each month: basic levels on even-numbered months and advanced levels on odd-numbered months. Each SQL Practice takes about an hour to complete and contains 5–10 exercises to help you hone your skills.
Read more
26 Nov 2021
András Novoszáth
Here’s Why You Should Use SQL for Sales Analytics
Would you like to understand how your sales efforts play out so that you know where to put your focus? Do you want to empower your sales teams with sales analytics? This article shows you how you can use SQL to use your sales data to your advantage. If you work in sales, understanding the activities that produce results has financial consequences for you, your team, and your company. This is where sales analytics can really help you.
Read more
««
«
1
2
3
29
30
31
80
»
»»