Sample SQL Server Database for Learning SQL

1- Introduction

LearningSQL is a small database, used as an example in the instructions of learning SQL on the website of  o7planning. There are 3 version on Databases: 
  • Oracle
  • MySQL
  • SQLServer.
In this document, I will instruct you to create this database on SQLServer.

2- Download Script

Download script at:
Direct Mediafire
Download Download
With SQLServer, you just need to care about the file:
  • LearningSQL-SQLServer-Script.sql

3- Run Script

3.1- Create SCHEMA LearningSQL in SQLServer Management Studio

Create Database
  • Database Name: learingsql
Copy content of LearningSQL-SQLServer-Script.sql into SQL Window and execute:

4- Overview LearningSQL Database

LearningSQL is a small database simulating the data of a bank:

5- The structure of the tables

5.1- ACCOUNT

5.2- ACC_TRANSACTION

5.3- BRANCH

5.4- BUSINESS

5.5- CUSTOMER

5.6- DEPARTMENT

5.7- EMPLOYEE

5.8- INDIVIDUAL

5.9- OFFICER

5.10- PRODUCT

5.11- PRODUCT_TYPE