SQL Archives | SQL Trailheads

CASE… WHEN… ELSE… END

Case… When.. Else… End maybe one of the most used SQL statements. Did you know you could use CASE with aggregate functions?

As a beginner, maybe you are having some problems using SQL, tutorial to learn a bit more about this beautiful language called SQL.

SQL and NoSQL are different types of databases languages, they have their pros and their cons, but why is better to use one or the other one?

Qualify may be one of the most underestimate commands in SQL, as a Data Analyst, I use it a lot and I really hope after this tutorial you use it too.

SQL and NoSQL have been in the market for a while now, but what are the real differences between each other? Why should we use one or the other?

This is one of the questions we almost always ask ourselves.
In this article, we are going to learn a bit about how to make an efficient query.

Let’s learn how to install SQL Server Management Studio (SSMS) from zero. SSMS and create our SQL Server test enviroment.