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.
Training 2 or more people?Try DataCamp for Business
R

Building Data Pipelines using R

Learn how to transform and load (ETL) a data pipeline from scratch using R and SQLite to gather tweets in real-time and store them for future analyses.

Francisco Javier Carrera Arias

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

R

SQLite in R

In this tutorial, you will learn about using SQLite, an extremely light-weight relational database management system (RDBMS) in R.

Francisco Javier Carrera Arias

SQL

Aggregate Functions in SQL

Learn how to use aggregate functions for summarizing results and gaining useful insights about data in SQL.

Sayak Paul

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

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