Table Of Content
Sample Oracle 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 Oracle.
This database is used in the documentation to learn SQL (Oracle) at:
Download script at:
With Oracle, you just need to care about the file:
There are two ways to create SCHEMA: LearningSQL
- Using SQL Plus
- Using visual tools.
Run 2 commands:
-- Create Schema named learningsql, password 1234 Create user learningsql identified by 1234; -- For learning purposes: -- Grant highest privilege DBA (DB Admin) for the newly created user. grant dba to learningsql;
Connect to the newly created SCHEMA:
-- Connect to Schema -- Syntax: connect <user>/<pass>@<sid> connect learningsql/1234@db11g;
-- Run Script file in SQL Plus @F:\LEARNING_SQL\LearningSQL-Oracle-Script.sql
Script run successfully:
On the visual tools (Here I use PL/SQL Developer), connected to the user with DBA authority (for example: system).
Execute script to create schema: learningsql.
-- Create schema named learningsql Create user learningsql identified by 1234; -- For learning purposes: -- Grant highest privilege DBA (DB Admin) for the newly created user. grant dba to learningsql;
Connect to Schema you just created:
Copy content of LearningSQL-Oracle-Script.sql into PL/SQL Developer and execute.
Create Schema success.
LearningSQL is a small database simulating the data of a bank:
|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.|
|CUSTOMER||The table of customers|
|DEPARTMENT||The department table of bank|
|EMPLOYEE||The employee table of bank|
|PRODUCT||The products and services of bank, such as:
|PRODUCT_TYPE||The types of products and services, such as: