# 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.
- [Creating a table in PostgreSQL with PgAdmin](/creating-a-table-in-postgresql-with-pgadmin) — PgAdmin is a useful tool to connect to our PostgreSQL server instance, it comes with a lot of features and functions that are useful for managing and visualizing our PostgreSQL databases.
- [How to install PostGIS, PgAdmin, and PostgreSQL in Docker](/how-to-install-postgis-pgadmin-postgresql-in-docker) — PostgreSQL must be one of the most used and advanced SQL Servers. We are going to learn how to install it in a Docker container with PostGIS and PgAdmin.
- [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.
- [How to install MySQL on Docker](/how-to-install-mysql-on-docker) — MySQL is one of the most popular SQL Databases and maybe the most used database on the web. Today we will learn how to install MySQL on a Docker Container.
- [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?
- [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 install OracleDB on Docker](/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?](/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!
- [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.
- [How to Install SQL Server: Quick Guide](/sql-server-installation) — Want to Start learning SQL Server and don’t know where to start? Come and learn how to Install your first SQL Server here!