SQL Trailheads
Practical SQL and database tutorials
Recent posts
View allCreating 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 beginners