Sample SQL Server Database for Learning SQL
View more Tutorials:
Follow us on our fanpages to receive notifications every time there are new articles.
Facebook
Twitter
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.
This database is provided as a sample database for learning SQL Server at:
Download script at:
With SQLServer, you just need to care about the file:
- LearningSQL-SQLServer-Script.sql
Create Database
- Database Name: learingsql
Copy content of LearningSQL-SQLServer-Script.sql into SQL Window and execute:
LearningSQL is a small database simulating the data of a bank:
| Table Name | Description |
| ACCOUNT | 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) |
| ACC_TRANSACTION | The table saves the transaction history between the bank and a certain account. |
| BRANCH | The branch of bank. |
| BUSSINESS | |
| CUSTOMER | The table of customers |
| DEPARTMENT | The department table of bank |
| EMPLOYEE | The employee table of bank |
| OFFICER | |
| PRODUCT | The products and services of bank, such as:
|
| PRODUCT_TYPE | The types of products and services, such as:
|
