SQL Tutorials

In this tutorial, you will learn how to connect Tableau to a Microsoft SQL Server database and then analyze the data to get insights.

In this tutorial, you will learn how to use and apply the ALTER TABLE statement in SQL.

In this tutorial, you will learn what views are, the different types available, and the pros and cons of using them.

In this tutorial, you will learn how to use and apply the ORDER BY keyword in SQL.

In this tutorial, you will learn how to install PostgreSQL on two different operating systems - Windows and Mac.

In this tutorial, learn how to import a spreadsheet into PostgreSQL and perform analysis on it.

In this tutorial, you will learn how to create, drop and select a database in SQL.

In this tutorial, you will learn how to write simple SQL queries in PostgreSQL.

An intuitive guide for discovering the two most popular SQL commands to aggregate rows of your dataset

Learn about anti-patterns, execution plans, time complexity, query tuning, and optimization in SQL.

In this tutorial, learn about indexing in databases and different types of indexing techniques.

In this tutorial, you will learn about different factors that are taken into consideration before choosing your Analytics Platform both at the organization and individual level.