# Blog

- [CASE… WHEN… ELSE… END](/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?
- [Top 10 SQL tips for beginners](/top-10-sql-tips-for-beginners) — As a beginner, maybe you are having some problems using SQL, tutorial to learn a bit more about this beautiful language called SQL.
- [Why is NoSQL faster than SQL?](/why-is-nosql-faster-than-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?
- [How to use a QUALIFY clause in SQL?](/how-to-use-a-qualify-clause-in-sql) — 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 vs NoSQL – What is the difference?](/sql-vs-nosql-what-is-the-difference) — 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?
- [Why is my SQL query taking so long?](/why-is-my-sql-query-taking-so-long) — 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.
- [How to Install SSMS SQL Server: Quick Guide](/install-ssms-sql-server-quick-guide) — Let’s learn how to install SQL Server Management Studio (SSMS) from zero. SSMS and create our SQL Server test enviroment.