|
Home > Archive > Oracle certifications > April 2003 > Starting Off
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Taqwus 2003-04-17, 10:39 am |
| I would like to learn some DB stuff so I was thinking of going into a little Oracle
Where is a good place to start?
Can Oracle be ran on a Laptop 1 Ghz, 256 RAM, 20 Gb HD
I am running Red Hat Linux on the laptop and have about 5 gb free on it
I also have a Win2k server 450 Mhz 128 Gb RAM I can try installing it on
Also, I see a lot of references to SQL, is that the language Oracle is in? | |
|
| While,you have no problem running oracle on both of your machines. They are good enough to run Oracle on them.
Win2000 should'nt have any problem running it. But,as for Red Hat, it's totally different things. You need to run different patches for different versions of Oracle. It's kind of tricky. Previously, i have run Oracle 8i on Red Hat Linux version 8. Lot of patches need to be installed. Otherwise, the Oracle DB will be damn buggy.
Anyway, there's no different running on Windows or Unix. As long, you know Oracle, it's just like running certain commnands on the unix to get the Oracle commands up. The only things, is the administration for both different OS.
Try to get the Offical Study guide for Oracle and learn Oracle from there. That's one of the best book you can learn Oracle. Oracle press books not really that good in learning Oracle. Quite brief, same go along with Sybex books. They can be use for reference only.
One last thing, the book, which you have refer is only the fundamentals for SQL language. There's only some differences running them on Oracle or MS SQL. As, i have mention, if you are keen on learning Oracle, get the student guides,you will learn from the basic to the advance level of Oracle from administration, using SQL languages,backup and performance tuning.
Good luck in your Oracle learning.
Cheers !!! | |
| Taqwus 2003-04-18, 6:21 am |
| How close is SQL to Oracle
I am trying to get MySQL up and running on my laptop, but running into a few errors | |
|
| MS SQL is totally different from Oracle. The basic fundamentals of using SQL is almost the same. But, the administration for both DB is totally different.
I have never use MySQL. According the market industry, most of the companies will be using MS SQL with Oracle.
MS SQL is much easier to learn compare to Oracle. Try to focus on one DB at a time, then move to another DB.
Good luck in your learning.
Cheers !!! | |
| Taqwus 2003-04-19, 5:16 am |
| Bah so I spent 2 days trying to get MySQL to talk with OpenOffice.org for nothing
I am going to University of Phoenix and there is 3 Database Classes I will be taking in around September till mid January these look like they will focus on SQL
Before that I will be taking 3 courses on programing which look to be mostly basedon Java
I am also looking to learn Linux, I got it installed on my laptop currently, which is where MySQL database is. | |
|
| Sorrie abt that. The basic of learning SQL can be done on MySQL. But, most of the companies are running their databases on Oracle and MS SQL. Including mine. We have both of them running in the production environment.
I believe in the near future under the Microsoft .net framework, more and more companies will be running MS SQL Server. This can be competitive to Oracle DB. I not saying,it's unless learning Oracle. Indeed, Oracle have it's own advantage and disadvantages.Learning both of them, definately will put you ahead in this DB markets.
Good lucks and may you succeeded in your learning.
Cheers !!! | |
| Taqwus 2003-04-20, 11:47 am |
| Once you know one, how hard is it to learn the other one | |
|
| MS SQL and Oracle are totally different products as we know.
Once,you know MS SQL overall from database design,SQL landguage, admin. The basic concepts and theory can brought over to Oracle.
But, to admin Oracle. That's a totally different question. Need to know the architecture of Oracle,admin,backup and performance tuning. There's a lot more stuff to learn in Oracle compare to MS SQL.
In US, some ppl will focus on one specific database products, either they are very good in MS SQL or Oracle.
But, in my country, companies prefer their employer to be cross train in both DB...MS SQL and Oracle.
Take me for example. I am quite well verse in MS SQL from data admin and design. Covering almost everything, except, i need to put in more effort on the Store procedure and triggers programming.
As for Oracle, i am still learning it. While, it's not easy nor difficult. Coz, i just started learning Oracle less than 3 months. I believe in 6 months time, i am able to do most of the Oracle tasks with ease and speed. Just like my MS SQL. |
|
|
|
|