Skip to main content
Category
Technologies

SQL Tutorials

Keep up to date with the latest techniques and resources for SQL Server. Our tutorials are full of free SQL Server training tips to help you learn, build, & grow.
Other technologies:
SQL

SQL Interface within JupyterLab

Learn how to use and modify SQL tables within JupyterLabs.

Parul Pandey

July 23, 2019

SQL

User Defined Stored Procedures in SQL

Learn how to use and apply the user-defined stored procedure along with examining different types of stored procedures in SQL.

Olivia Smith

July 15, 2019

SQL

Materialized Views in PostgreSQL

Learn how to store the results of a query with the help of materialized views in PostgreSQL.
Sayak Paul's photo

Sayak Paul

May 2, 2019

SQL

Cleaning Data in SQL

In this tutorial, you'll learn techniques on how to clean messy data in SQL, a must-have skill for any data scientist.
Sayak Paul's photo

Sayak Paul

April 24, 2019

SQL

Aggregate Functions in SQL

Learn how to use aggregate functions for summarizing results and gaining useful insights about data in SQL.
Sayak Paul's photo

Sayak Paul

April 17, 2019

SQL

CASE Statements in PostgreSQL

In this tutorial, you'll learn how to write conditional queries in PostgreSQL using the PostgreSQL CASE conditional expression.
Sayak Paul's photo

Sayak Paul

April 3, 2019

SQL

10 Command-line Utilities in PostgreSQL

In this tutorial, learn about 10 handy command-line utilities in PostgreSQL which can enable you to interact with databases efficiently.
Sayak Paul's photo

Sayak Paul

March 29, 2019

SQL

SQL with Power BI

In this tutorial, you'll learn how to connect Power BI to a Microsoft SQL Server database and then analyze the data to get insights.
Parul Pandey's photo

Parul Pandey

March 28, 2019

SQL

Beginners Guide to SQLite

Learn the basics of SQLite databases from SQLite dot commands to an example of their practical applications using the command line interface.
Francisco Javier Carrera Arias's photo

Francisco Javier Carrera Arias

March 22, 2019

SQL

Introduction to SQL Joins

In this tutorial, you'll learn about the mechanics of joins in SQL and its different types.
Sayak Paul's photo

Sayak Paul

March 20, 2019