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
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
Dashboard
My Profile
Payment & Billing
Log in
Create free account
Log out
Articles
Cookbook
31 Jan 2023
LearnSQL.com Team
New Monthly SQL Practice for February 2023!
Are you a SQL beginner that needs some interactive exercises to practice writing queries? Take the challenge and choose our February 2023 SQL Practice course. This is the next step towards becoming a pro. In our February SQL Practice, you’ll meet Hazel, the manager of a local gym. She needs your help to gather statistics on the gym members and the memberships they have purchased. Can you use your SQL skills to help her find the data?
Read more
26 Jan 2023
Gustavo du Mortier
How to Group by Multiple Columns in SQL
When analyzing large data sets, you often create groupings and apply aggregate functions to find totals or averages. In these cases, using the GROUP BY clause with multiple columns unfolds its full potential. GROUP BY is a clause of the SELECT command. It allows you to compute various statistics for a group of rows. For example, you can use GROUP BY with an employee table to know how many employees are of each gender.
Read more
24 Jan 2023
Maria Durkin
SQL for the Business Analyst
How can SQL benefit business analysts? In this article, we’ll discuss why SQL is a fundamental skill in this role. You’ll also learn what a business analyst does and what they need to advance their career. According to BrainStation, the already high demand for business analysts is set to grow even more. One of the driving forces behind the rising demand is the digital revolution, which has been accelerated by the recent pandemic.
Read more
19 Jan 2023
Tihomir Babic
What Is a CTE in SQL Server?
What is a CTE, and how do you write a CTE in SQL Server? Join us on a journey where we’ll see all the typical usage of a CTE in SQL Server. CTEs (or Common Table Expressions) are an SQL feature used for defining a temporary named result. You can think of it as a temporary table whose output is available only when the main query is run. This is practical because the CTEs result isn’t stored anywhere but can always be referenced inside the query like any other table.
Read more
17 Jan 2023
Jill Thornhill
Is SQL Hard to Learn?
If you have no IT skills, how hard is it to learn SQL? Will it be too technical for you? Is it worth the effort? And where would you start? In this article I will answer those questions. As an IT consultant and trainer, I've often advised people to learn SQL. And, almost as often the reply has been, "Is it hard to learn SQL? Do I need technical or IT skills to learn it?
Read more
12 Jan 2023
Tihomir Babic
How to Practice SQL Window Functions Online
Learn and practice SQL window functions from the comfort of your home! Here’s how to do it. The last few years have shown that working from home has many benefits over the daily commute. No wonder people are reluctant to go back to the office! They have much more time while doing the same work. What do you do with the extra time? Whatever you want. It’s your time!
Read more
10 Jan 2023
Alexandre Bruffa
Database Jobs to Choose in 2023
In this article, we will explore some of the top database jobs to choose from in 2023. So you want to land yourself a database job in 2023. It’s a great choice, and there are lots of options. Let’s talk about the most popular data-related jobs and what you need to do to get one. SQL Is Essential for a Database Job It’s important to mention that most of the popular databases nowadays are relational – i.
Read more
5 Jan 2023
Nicole Darnley
UNION and UNION ALL in SQL Explained
In this article, we’ll explore the SQL clauses UNION and UNION ALL. Learn what they do and when to use each one. I had been an analyst for probably four years before I knew about the SQL clause UNION ALL. I used UNION on a regular basis, but had never heard of its counterpart. Then one day when I heard a coworker talking about it. I thought to myself, “What is he talking about?
Read more
3 Jan 2023
Kamila Ostrowska
SQL Books for Beginners
How can you learn SQL more efficiently? Besides a good online course, find an interesting book to enrich your knowledge. Here are the best SQL books for beginners. SQL, or Structured Query Language, is a very powerful tool to work with many types of data. If you are interested in learning SQL you probably know how useful it is, and how widely it is needed. To learn SQL successfully, a solid online course for beginners like our SQL Basics is a great start.
Read more
1 Jan 2023
LearnSQL.com Team
New Monthly SQL Practice for January 2023!
Ready for our new SQL challenge? This time, we have prepared slightly more difficult SQL tasks. Here's the January SQL Practice course! This SQL Practice is at an advanced level and is aimed at those who have finished our SQL Basics and Window Functions course or otherwise have the equivalent knowledge. If you do not feel comfortable working with SQL window functions yet, make sure to check out these courses first and then come back here for more practice.
Read more
««
«
1
2
3
17
18
19
79
»
»»