Also look at:  https://oracle.github.io/learning-library/data-management-library/autonomous-database/shared/workshops/freetier-overview/?lab=adb-query

·        Oracle Cloud Storage files into Oracle: https://database-heartbeat.com/2021/09/20/imp-exp-oss/

·        AWS files into Oracle: https://database-heartbeat.com/2022/02/21/aws-s3-to-oracle-database/

·        Azure files into Oracle: https://database-heartbeat.com/2022/03/03/azure-blob-to-oracle-database/

Bud Endress – Data Loading & External Tables & Analytic Views:  https://www.youtube.com/watch?v=GOZ_LvbZZ1c

Load Oracle data in Autonomous:  https://www.youtube.com/watch?v=SJUw4wIvkS4

User encryption, tablespace encryption, auditing database security:  https://www.youtube.com/watch?v=v8KaabwPw9U

 

 

     ot_create_user.sql is for creating OT user and grant privileges

     ot_schema.sql is for creating database objects such as tables, constraints, etc.

     ot_data.sql is for loading data into the tables.

     ot_drop.sql is for removing all objects in the sample database.

-----------------------------------------------------------------------------------------

Global fictitious company that sells computer hardware including storage, motherboard, RAM, video card, and CPU.

The company maintains the product information such as name, description standard cost, list price, and product line. It also tracks the inventory information for all products including warehouses where products are available. Because the company operates globally, it has warehouses in various locations around the world.

The company records all customer information including name, address, and website. Each customer has at least one contact person with detailed information including name, email, and phone. The company also places a credit limit on each customer to limit the amount that customer can owe.

Whenever a customer issues a purchase order, a sales order is created in the database with the pending status. When the company ships the order, the order status becomes shipped. In case the customer cancels an order, the order status becomes canceled.

In addition to the sales information, the employee data is recorded with some basic information such as name, email, phone, job title, manager, and hire date.

Oracle Sample Database

Table Names

Description

Records

 CONTACTS

store contact person information of customers

319 records

 COUNTRIES

store country information

25 records

 CUSTOMERS

store customer master

319 records

 EMPLOYEES

store employee master

107 records

 INVENTORIES

store inventory information of products

1112 records

 LOCATIONS

store locations of warehouses

23 records

 ORDERS

store order header information

105 records

 ORDER_ITEMS

store order line items

665 records

 PRODUCT_CATEGORIES

store product categories

5 records

 PRODUCTS

store product information

288 records

 REGIONS

store regions where the company operates

4 records

 WAREHOUSES

store warehouse information

9 records