I have begun training for 8i OCP certification but I lack any real world professional experience. To attempt to partially counteract this I want to play around with some test databases to apply my new learnings. Anyone have any links for downloading/purchasing simple databases? Or would it be better to create my own?
Thanks in advance
There is a demo schema that comes with oracle. Check out your $ORACLE_HOME/sqlplus/demo/demobld.sql script...
Thanks Jeff...I have identified that schema as a start but am curious if multiple schema of different types (i.e financial, HR, manufacturing) would give me a more rounded understanding of the capabilities as well as make me more rounded as far as job possibilities down the road??.....
All thoughts appreciated
Try to get oracle 9i. With 9i, there are a couple of sample schemas. One example from HR schema:
SQL> select table_name from user_tables;
7 rows selected.
Each table has more than 100 rows. It is good for studying database desgine too.
I have found the demobld.sql and the demodrop.sql scripts for my 9i for win98... how do i run these? thanks for any help, kyle
You can run it easily from sql plus.with @demo.sql
Click Here to Expand Forum to Full Width