Blog
21 posts
Creating a stored procedure in Microsoft SQL Server
August 7, 2023
Creating a Stored Procedure in Microsoft SQL Server
Advanced SQLTransact-SQLCreating a View in PostgreSQL
January 20, 2023
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.
Advanced SQLPostgreSQLSQL TutorialsCreating a Stored Procedure in MySQL
December 1, 2022
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.
Advanced SQLMySQL tutorialsSQL TutorialsWhat is PostGIS? When and how should I use it?
November 24, 2022
Postgis is essentially an open-source add-on for PostgreSQL database which adds support for Geographic objects and converts PostgreSQL into a spatial database.
Advanced SQLPostgreSQLSQL TutorialsSQL tutorials for beginnersCreating a table in PostgreSQL with PgAdmin
November 23, 2022
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.
PostgreSQLSQL TutorialsSQL tutorials for beginnersHow to install PostGIS, PgAdmin, and PostgreSQL in Docker
November 22, 2022
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.
PostgreSQLSQL Installation manualSQL TutorialsSQL tutorials for beginnersCASE… WHEN… ELSE… END
November 12, 2022
Case… When.. Else… End maybe one of the most used SQL statements. Did you know you could use CASE with aggregate functions?
Advanced SQLSQL TutorialsTop 10 SQL tips for beginners
November 12, 2022
As a beginner, maybe you are having some problems using SQL, tutorial to learn a bit more about this beautiful language called SQL.
SQL TutorialsSQL tutorials for beginnersHow to install MySQL on Docker
October 22, 2022
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.
MySQL tutorialsSQL TutorialsSQL tutorials for beginnersWhy is NoSQL faster than SQL?
October 20, 2022
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?
MiscellaneousNoSQLWhat is an aggregate function?
October 19, 2022
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.
Advanced SQLSQL TutorialsSQL tutorials for beginnersTransact-SQLHandling Strings in SQL Server
October 17, 2022
“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?”
Advanced SQLSQL TutorialsSQL tutorials for beginnersTransact-SQLHow to install OracleDB on Docker
October 17, 2022
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.
PL/SQLSQL tutorials for beginnersHow to use Parameters in Stored Procedures?
October 15, 2022
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.
Advanced SQLPL/SQLSQL TutorialsTransact-SQLHow to use a QUALIFY clause in SQL?
October 7, 2022
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.
Advanced SQLPL/SQLSQL TutorialsTransact-SQLWhat is Redis? And when you should use it
October 6, 2022
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.
Advanced SQLMiscellaneousNoSQLNoSQL TutorialsSQL vs NoSQL – What is the difference?
October 5, 2022
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?
Advanced SQLMiscellaneousNoSQLNoSQL TutorialsSQL IntegrationsWhy is my SQL query taking so long?
October 4, 2022
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.
Advanced SQLMiscellaneousPL/SQLTransact-SQLHow to Install SQL Server on Docker
October 2, 2022
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!
Advanced SQLSQL Installation manualSQL IntegrationsSQL TutorialsHow to Install SSMS SQL Server: Quick Guide
October 1, 2022
Let’s learn how to install SQL Server Management Studio (SSMS) from zero. SSMS and create our SQL Server test enviroment.
SQL Installation manualSQL tutorials for beginnersHow to Install SQL Server: Quick Guide
October 1, 2022
Want to Start learning SQL Server and don’t know where to start? Come and learn how to Install your first SQL Server here!
SQL Installation manualSQL tutorials for beginners