Articles Cookbook
16 Feb 2023
Alexandre Bruffa

How to Concatenate Two Columns in SQL – A Detailed Guide

In SQL, concatenation is the operation of joining together strings, or pieces of text information. Learn how to concatenate two columns in SQL with this detailed guide. SQL concatenation is the process of combining two or more character strings, columns, or expressions into a single string. For example, the concatenation of 'Kate', ' ', and 'Smith' gives us 'Kate Smith'. Enhance your SQL skills with our interactive SQL Practice Set! This comprehensive course contains nearly 90 hands-on exercises, divided into five topic-based sections, including a section dedicated to SQL concatenation.
Read more
14 Feb 2023
Nicole Darnley

Data Cleaning in SQL

Data cleaning is an important part of any data analysis. Here we’ll discuss techniques you can use to do data cleaning in SQL. I find it nearly impossible to focus on work when my desk is a mess. If it’s cluttered with paper, coffee mugs, or random toys my daughter has somehow snuck into my office, there is no chance I will be able to get anything done until my desk is back in order.
Read more
9 Feb 2023
Nicole Darnley

Learn SQL for Data Analysis with LearnSQL.com

Discover how to learn SQL for data analysis and start making sense of your data today. Our guide provides a clear and simple SQL learning path for data analysts, helping you query databases and analyze data with ease. Whether you're starting from scratch or looking to polish your skills, we'll help you every step of the way. When I was in high school, I planned to go to college and major in interior design.
Read more
7 Feb 2023
Jill Thornhill

Top SQL Certificates in 2023

SQL is an essential skill in today’s data-driven world. Looking for the best SQL certificates to further your career can be confusing. This article gives some pointers that will help you make the best choice to fit your goals. Who needs an SQL certificate? If you can write advanced SQL queries, surely you can just demonstrate your skills at the interview and you'll be hired. Yes ... but ... you won't reach the interview unless the recruiter invites you.
Read more
2 Feb 2023
Valentyn Kucherenko

Introducing Our New Ultimate SQL Cheat Sheet!

Do you ever find yourself writing an SQL query and forgetting the syntax of some function? That sometimes happens to me too. Fortunately, LearnSQL.com has prepared this awesome Ultimate SQL Cheat Sheet you can always have on hand. Print it or save it to your browser's favorites and make your data querying more efficient! If you are looking for an SQL Cheat Sheet, it is safe to assume that you already know what SQL is.
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
25 Jan 2023
LearnSQL.com Team

2023 Monthly SQL Practice: New Courses & Opportunities

Looking to level up your SQL skills in 2023? LearnSQL.com’s Monthly SQL Practice offers the perfect way to stay sharp, with real-world exercises designed for all levels. If you're looking to build your SQL skills and stay sharp, our Monthly SQL Practice for 2023 is exactly what you need. Designed to help both beginners and advanced users hone their SQL abilities, these challenges give you a structured way to practice real-world SQL queries every month.
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