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.
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.
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 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
Want to Start learning SQL Server and don’t know where to start? Come and learn how to Install your first SQL Server here!