# Blog

- [Creating a stored procedure in Microsoft SQL Server](/creating-a-stored-procedure-in-microsoft-sql-server) — Creating a Stored Procedure in Microsoft SQL Server
- [Creating a View in PostgreSQL](/creating-a-view-in-postgresql) — A View is a way of protecting your SQL tables and formatting your table’s raw data into useful information that can be queried by your organization individuals.
- [Creating a Stored Procedure in MySQL](/creating-a-stored-procedure-in-mysql) — A stored procedure is a prepared SQL code that is stored in our Schema to reuse whenever we need to.
Most SQL databases have stored procedures as a built-in tool as part of SQL’s original language. Nevertheless, stored procedures SQL coding might be slightly different between the SQL databases.
- [What is PostGIS? When and how should I use it?](/what-is-postgis-and-when-should-i-use-it) — Postgis is essentially an open-source add-on for PostgreSQL database which adds support for Geographic objects and converts PostgreSQL into a spatial database.
- [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?
- [What is an aggregate function?](/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](/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 use Parameters in Stored Procedures?](/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?](/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](/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-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 SQL Server on Docker](/install-sql-server-in-docker-quick-guide) — 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!