Dofactory.com
Dofactory.com

SQL Introduction

What is a Database?

#

A database is a place to store data.

A relational database system (RDMS) stores data in tables.

Each table has rows and columns, much like a spreadsheet.

Each row has one or more columns to store data values.


What is SQL?

#

SQL stands for Structured Query Language.

SQL is a language used to retrieve and manipulate data in a RDMS.

Relational Database Tables

In a relational database, data is stored in tables.
As an example, the table below has data in 4 rows and 3 columns.


SQL and Relational Databases

A relational database contains tables which store data that is related in some way. SQL is the language that allows retrieval and manipulation of table data in a relational database.

The database below has 2 tables: one with data on Users and another with data on Products. SQL is the language with which you retrieve data, update data, and remove data.

SQL Server database

Example Database

This tutorial uses a modernized version of Microsoft's Northwind database. Northwind is a fictitious store that sells specialty food products from all over the world. The database has 5 tables with information on Products, Suppliers, Customers, and Orders.

This Entity Relationship Diagram (ERD) shows the tables and their relationships.

Additional details of the data model are available on the Sample Database page. You can also run custom SQL against a live database using our SQL Editor.


You may also like



Last updated on Dec 21, 2023