Create free account
User profile menu open
Open user profile menu
Payment & Billing
Payment & Billing
Create free account
15 Oct 2021
How to Join Only the First Row in SQL
In your projects, you may encounter situations when you have many orders corresponding to one customer or many temperature observations corresponding to the same location, but you only need to join the first row with the most recent order or the most recently observed temperature to the corresponding record in another table. In this article, I’ll go through several ways to do this in SQL. The Problem There are many different scenarios where you have a one-to-many relationship between two tables and you need to join only the first match from one table to the corresponding record in another.
14 Oct 2021
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.
13 Oct 2021
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.
12 Oct 2021
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.
8 Oct 2021
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.
7 Oct 2021
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.
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.