Free database tutorials

Learn Databases from Scratch with Practical SQL Tutorials

DatabaseFAQs.com has 640+ step-by-step tutorials on SQL Server, Azure SQL, PostgreSQL, MariaDB, Oracle, MongoDB and MySQL. Every guide shows the real queries, the exact screens and the fixes for the errors you actually run into.

SQL Server tutorials Browse all databases

640+Free tutorials
7Databases covered
14+ yearsHands-on data experience

-- Find the answer in minutes, not hours
SELECT title, database
FROM   tutorials
WHERE  database IN ('SQL Server', 'PostgreSQL',
                   'Azure SQL', 'MongoDB')
ORDER BY published DESC;

Real queries you can copyT-SQL, PL/pgSQL, MongoDB and more, with the output
Fixes for common errorsConnection, login, permission and syntax errors solved
Azure SQL in the cloudCreate, connect, secure and migrate your databases

Browse by database

SQL Server, PostgreSQL, MariaDB, Oracle & More

Pick a database to see every tutorial for it, newest first.

Start learning

Step-by-Step Database Tutorials by Topic

Each topic starts with one main tutorial, followed by the related lessons readers look for most.

SQL Server

SQL Server Create Stored Procedure (15 Ways)

Write, run and debug stored procedures, from a simple SELECT to parameters and error handling.

Stored procedure parameters Output parameters Try catch in a stored procedure
SQL Server

SQL Server INNER JOIN

Combine rows from two or more tables and pick the right join for the result you need.

LEFT JOIN tutorial INNER JOIN vs LEFT JOIN What is a CROSS JOIN?
SQL Server

SQL Server Trigger Tutorial with Examples

Run code automatically when rows are inserted, updated or deleted, and keep audit tables in sync.

Trigger after insert Trigger for update INSTEAD OF trigger
Azure SQL

What Is Azure SQL?

Create an Azure SQL database, open the firewall, connect to it and move your data to the cloud.

Create a single database Configure the firewall Migrate SQL Server to Azure SQL
PostgreSQL

How to Download and Install PostgreSQL on Windows

Install PostgreSQL, create your first tables and learn the data types and queries you will use daily.

Create a table PostgreSQL data types Back up a database
MariaDB

How to Install MariaDB

Set up MariaDB, create databases and users, and write the SELECT, INSERT and UPDATE queries you need.

Create a database Create a user SELECT statement
Oracle

Oracle 19c Installation on Windows 10

Install Oracle, understand its datatypes and manage users, tables and stored procedures.

Oracle database datatypes Create a user Create a table
MongoDB

How to Install MongoDB

Get MongoDB running, then create collections, update documents and join data across collections.

Create a collection Update documents Join two collections
MySQL

MySQL Tutorial

Learn MySQL from installation to tables, datatypes, users and joins, one short lesson at a time.

Install MySQL on Windows Create a table MySQL joins

Troubleshooting

Fix Common Database Errors

Seeing an error message? Find it below for the cause and the exact steps that fix it.

SQL Server

Azure SQL

PostgreSQL, MariaDB & MySQL

MongoDB

Compare databases

Reader favorites

Latest Database Tutorials

Azure Lessons on YouTube

Prefer to Watch? Learn with Free Video Tutorials

Follow along on screen as Rajkishore creates Azure SQL databases, connects from SSMS, writes T-SQL and fixes real errors, one short step-by-step video at a time.

600+Free videos
Step by stepReal Azure portal & SSMS screens

Azure SQL Database
SQL Server
SSMS
Azure Functions
Azure DevOps

Subscribe on YouTube Browse all videos

Rajkishore Sahoo Microsoft Azure consultant

About the author

Meet Rajkishore Sahoo

Rajkishore Sahoo is a Microsoft Azure consultant with more than 14 years of hands-on experience building cloud-native data solutions across Azure and AWS, focused on Azure SQL Database, Azure SQL Managed Instance, and the pipelines that connect them to production apps. Day to day, he provisions Azure SQL instances, configures firewalls and connection strings, tunes queries for cloud workloads, and wires databases into Azure Functions and Logic Apps.

Every guide on DatabaseFAQs comes from that real project work: the exact portal screens, T-SQL commands, and connection errors he has personally hit and fixed. He holds Microsoft Certified: Azure Developer Associate and Azure Fundamentals credentials, with database-related project experience at Tata Consultancy Services and Nous Infosystems.

Rajkishore writes the guide he wishes he’d found, so you can solve a database problem in minutes instead of hours. He also publishes cloud and database tutorials at Azure Lessons and on YouTube. Connect with him on LinkedIn or follow his tutorials on YouTube.

14+Years hands-on experience
640+Free tutorials
2Microsoft Azure certifications

Azure SQL Database
Azure SQL Managed Instance
T-SQL
SQL Server
Azure Functions
Logic Apps
AWS

Connect on LinkedIn Watch on YouTube Contact us

Learn Databases from Scratch with Practical SQL Tutorials