CASE… WHEN… ELSE… END
November 12, 2022
Case… When.. Else… End maybe one of the most used SQL statements. Did you know you could use CASE with aggregate functions?
Advanced SQLSQL TutorialsTop 10 SQL tips for beginners
November 12, 2022
As a beginner, maybe you are having some problems using SQL, tutorial to learn a bit more about this beautiful language called SQL.
SQL TutorialsSQL tutorials for beginnersWhy is NoSQL faster than SQL?
October 20, 2022
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?
MiscellaneousNoSQLHow to use a QUALIFY clause in SQL?
October 7, 2022
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.
Advanced SQLPL/SQLSQL TutorialsTransact-SQLSQL vs NoSQL – What is the difference?
October 5, 2022
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?
Advanced SQLMiscellaneousNoSQLNoSQL TutorialsSQL IntegrationsWhy is my SQL query taking so long?
October 4, 2022
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.
Advanced SQLMiscellaneousPL/SQLTransact-SQLHow to Install SSMS SQL Server: Quick Guide
October 1, 2022
Let’s learn how to install SQL Server Management Studio (SSMS) from zero. SSMS and create our SQL Server test enviroment.
SQL Installation manualSQL tutorials for beginners