Sample SQL Server Database for Learning SQL
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:
In this document, I will instruct you to create this database on SQLServer.
This database is provided as a sample database for learning SQL Server at:
2. Download Script
Download script at:
With SQLServer, you just need to care about the file:
3. Run Script
Create SCHEMA LearningSQL in SQLServer Management Studio
- Database Name: learingsql
Copy content of LearningSQL-SQLServer-Script.sql into SQL Window and execute:
4. Overview LearningSQL
LearningSQL is a small database simulating the data of a bank:
The table saves the bank accounts. Each of customer can register multiple accounts each of which corresponds to a product type provided by the bank.
(See more: PRODUCT)
The table saves the transaction history between the bank and a certain account.
The branch of bank.
The table of customers
The department table of bank
The employee table of bank
The products and services of bank, such as:
The types of products and services, such as: