ER Model

1. ER Model to Relational Model

SQL Tutorial

1. SQLZ
2. W3Schools.com
3. Vertabelo Academy
4. tutorials point
5. SQL Course.com

Oracle Database SQL Reference

1. Schema Objects
2. Data Types
3. Oracle Data Types
4. Transaction Management

Useful Tools

1. Oracle SQL Developer 4.2
2. ER tools

Useful oracle queries

1. Switching to a different schema: ALTER SESSION SET CURRENT_SCHEMA = <schema name>;
2. List the column definitions for the table: DESCRIBE <table name>;
3. Show all tables: select * from tab;
4. Drop all tables: select 'drop table ', table_name, 'cascade constraints;' from user_tables;
5. Remove the Contents of Your Recycle Bin: PURGE RECYCLEBIN;
6. Grant privileges to public: GRANT SELECT, INSERT, UPDATE, DELETE ON <table name> TO public;
7. to_date usage tips: to_date('01-31-17','MM-DD-YY') to_date('2017-01-31','YYYY-MM-DD') to_date('01-31-2017 08:00','MM-DD-YYYY HH:MI')
8. Show the service name: Show parameter service_name
9. Batch insertion: sqlplus -s "ID"/"PASSWORD" @"SQLFILE.sql"
10. See the quota allocation: SELECT * FROM user_ts_quotas;
11. See the quota allocation: SELECT * FROM dba_ts_quotas WHERE username='YANGK';
12. ALTER USER scott QUOTA unlimited ON ORACLE_CLASS;

SampleDatasets

click Fundamental of Database Systems BOOK

click COW BOOK

CA ERwin Data Modeler Community Edition

ERwin Data Modeler Community Edition

JDBC Programming Practice

Eclipse Download

Oracle JDBC Driver

JDBC Programming Sample

Sample datasets for tb201