Oracle Database

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » Working with Oracle » Oracle Database

Oracle Database

Rate Topic

Display Mode

Topic Options

Author

Message

prajwal261187

Posted Monday, August 27, 2012 6:01 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, August 27, 2012 5:59 AM
Points: 1, Visits: 0

Hello all...

I am new to database learning. But really got interested in OCA studies.
So I have decided to opt that as my career in DBA. What is data warehousing and oracle database related to??
Can you suggest some ideas for it.
Right now I work in software field . Is oracle database a good future when compared to java.

Post #1350337

Jo Pattyn

Posted Monday, August 27, 2012 12:28 PM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 11:57 PM
Points: 1,329, Visits: 4,299

Hello,

I think it is a good feature choosing a database-variant to master. Work enough in the field. Relational databases are mostly the backbone of many applications.
If you are familiar with SQL Server, Oracle quite alike and yet different in its internals, tuning, handling,dialect...
Where SQL Server administration is becoming easier but broader, Oracle doesn't come with easy administration tools unless you pay the big bucks.

Goal of a database is usually consistency match with quick retrieval/writes with small datasets (OLTP).
Datawarehouse are more oriented on quick retrieval of large datasets and on the fly analysis of aggregated data.
There is quite a difference between sql-set-based thinking (like moving boxes with books instead of moving each book indivually) opposed to the object-oriented approach of java.

If you have a background of java, you have a plus as the oracle-stack (database,webserver,...) is more java-minded.
Not sure if it is better than java, any good programmer is also worth his/her weigth in gold.

Post #1350525

Lowell

Posted Monday, August 27, 2012 1:00 PM

SSChampion

Group: General Forum Members
Last Login: Today @ 9:15 AM
Points: 11,617, Visits: 27,679

Jo Pattyn (8/27/2012)

... any good programmer is also worth his/her weigth in gold.

lol according to this web site,

http://www.onlygold.com/tutorialpages/yourweightingold.asp

a fat boy like me is worth 5.4 million dollars or so; maybe more after lunch.

The weight of 224 pounds of gold is worth: $5,448,675.46
Based upon the current spot gold price of: $1,668.00

Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son

Post #1350538

Jo Pattyn

Posted Monday, August 27, 2012 1:56 PM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 11:57 PM
Points: 1,329, Visits: 4,299

Nice link, pity I'm slimming down.

Post #1350564

PaulB-TheOneAndOnly

Posted Tuesday, August 28, 2012 11:19 AM

SSCrazy

Group: General Forum Members
Last Login: Yesterday @ 1:08 PM
Points: 2,982, Visits: 4,396

prajwal261187 (8/27/2012)

.. What is data warehousing and oracle database related to?

Firstly... data warehousing is a particular application for databases, in general we divide them in two major categories which are OLTP and DSS - data warehousing is part of the DSS domain.

Secondly... Oracle is one of many RDBMS engines available - which also include Microsoft SQL Server. By the way, did you notice this is a SQL Server forum?

Finally... answering your question, I think that a fair anwser would be: "they relate to data management in a digital, computational environment". Smile

_____________________________________
Pablo (Paul) Berzukov

Author of Understanding Database Administration available at Amazon and other bookstores.

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

Post #1351136

Sean Lange

Posted Wednesday, September 19, 2012 9:17 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Today @ 9:06 AM
Points: 8,580, Visits: 8,223

tutblog1 (9/19/2012)

Want to learn SQL?

Goto
easysqlguide.blogspot.in

Easily learn SQL with the help of images.

No offense but you seem to keep posting this same link to your blog over and over. Sadly, your blog is basically empty with the sake of a few very basic instructions. I am not sure why you keep pointing people there???

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

Post #1361430

« Prev Topic | Next Topic »

Permissions