What is an aggregate function?
An aggregate function where the values are grouped together to form a single response. The more common SQL aggregate functions are SUM, COUNT, AVG, MIN and MAX.
Handling Strings in SQL Server
“How could I split a SQL field by a delimiter?”, “How could I get with the first word of a SQL field?”, “How could I get the first three letters of an SQL field?”
How to install OracleDB on Docker
I come up with this problem yesterday, Oracle is potentiating their cloud solutions so they are not making it that easy to install their star product on a testing environment.
How to use Parameters in Stored Procedures?
The Stored Procedures are an elegant way to store your code inside a SQL database. You can save your code and reuse it whenever you want to.
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.
What is Redis? And when you should use it
In this article, we are going to talk about Redis, an open-source, in-memory, key-value NoSQL data store that you should know about and when you should use it.
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?
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 SQL Server on Docker
How to Install SQL Server on Docker
SQL Server can be installed on Linux distributions, one of them is a Docker Containter. Let’s get started!
How to 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.