Creating a stored procedure in Microsoft SQL Server
Creating a Stored Procedure in Microsoft SQL Server
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
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?
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
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
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 maybe one of the most used SQL statements. Did you know you could use CASE with aggregate functions?
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
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?
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?