Re: Oracle demo?

Sara Kane wrote:

> Hi all,
>
> Id really like to have a go learning Oracle, is there a small demo or cut
> down version that I could install on my machine (Windows ME) and then use to
> just test SQL etc and learn more about it, rather than paying millions to
> buy the real thing?
>
> Does anyone have any guides to doing this?
>
> Thanks
>
> Sara

The first thing you need to do is get a real operating system. Upgrade to either Win4 SP6 or Win2000 (don't go to XP). Then go to http://store.oracle.com and for $39.95 USD you can order the CD Pack (demo pack). When you get it install the Enterprise Edition. Then hit the bookstores and find a book that will take you through the following:

1. CREATE USER
2. CREATE TABLE
3. Creating CONSTRAINTS (ALTER TABLE)
4. CREATE INDEX
5. CREATE SEQUENCE
6. lots of SQL with INNER and OUTER JOINS
7. understanding the security model of users, schemas, roles, system privileges, and object privileges

After that think about a book that will help you with writing functions, procedures, packages, and triggers.

Best of luck.

Daniel Morgan Received on Fri Jun 28 2002 - 10:41:56 CDT