Skip to content

SQL Trailheads

Menu
  • NoSQL
  • Advanced SQL
  • SQL tutorials for beginners
  • Transact-SQL
  • en_USCurrent Language
Home
Advanced SQL / Transact-SQL

Creating a stored procedure in Microsoft SQL Server

Creating a Stored Procedure in Microsoft SQL Server

Advanced SQL / PostgreSQL / SQL Tutorials

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.

Advanced SQL / MySQL tutorials / SQL Tutorials

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.

Advanced SQL / PostgreSQL / SQL Tutorials / SQL tutorials for beginners

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.

PostgreSQL / SQL Tutorials / SQL tutorials for beginners

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.

PostgreSQL / SQL Installation manual / SQL Tutorials / SQL tutorials for beginners

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.

Advanced SQL / SQL Tutorials

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?

SQL Tutorials / SQL tutorials 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.

MySQL tutorials / SQL Tutorials / SQL tutorials for beginners

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.

Miscellaneous / NoSQL

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?

Posts navigation

Older posts

Recent Posts

  • Creating a stored procedure in Microsoft SQL Server
  • Creating a View in PostgreSQL
  • Creating a Stored Procedure in MySQL
  • What is PostGIS? When and how should I use it?
  • Creating a table in PostgreSQL with PgAdmin

Archives

  • August 2023
  • January 2023
  • December 2022
  • November 2022
  • October 2022

Categories

  • Advanced SQL
  • Miscellaneous
  • MySQL tutorials
  • NoSQL
  • NoSQL Tutorials
  • PL/SQL
  • PostgreSQL
  • SQL Installation manual
  • SQL Integrations
  • SQL Tutorials
  • SQL tutorials for beginners
  • Transact-SQL
Copyright © 2024 SQL Trailheads – OnePress theme by FameThemes
Manage Cookie Consent
We use technologies like cookies to store and/or access device information. We do this to improve browsing experience and to show (non-) personalized ads. Consenting to these technologies will allow us to process data such as browsing behavior or unique IDs on this site. Not consenting or withdrawing consent, may adversely affect certain features and functions.
Functional Always active
The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
Preferences
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
Statistics
The technical storage or access that is used exclusively for statistical purposes. The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
Marketing
The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.
Manage options Manage services Manage {vendor_count} vendors Read more about these purposes
View preferences
{title} {title} {title}
https://sqltrailheads.com/wp-content/cache/breeze-minification/js/breeze_9ab66c366164629e12c79e27c1b891fe9900b0c3056f6cabff8c587d1f5df879142118b0c40bbd98bcd3bf1e9684d1bbe197dafbd1d722eae0df0c618493419b.js