SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Oracle Database


Oracle Database

Author
Message
prajwal261187
prajwal261187
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 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.
Jo Pattyn
Jo Pattyn
SSChampion
SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)

Group: General Forum Members
Points: 13108 Visits: 10244
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.
Lowell
Lowell
SSC Guru
SSC Guru (138K reputation)SSC Guru (138K reputation)SSC Guru (138K reputation)SSC Guru (138K reputation)SSC Guru (138K reputation)SSC Guru (138K reputation)SSC Guru (138K reputation)SSC Guru (138K reputation)

Group: General Forum Members
Points: 138819 Visits: 41519
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
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!
Jo Pattyn
Jo Pattyn
SSChampion
SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)

Group: General Forum Members
Points: 13108 Visits: 10244
Nice link, pity I'm slimming down.
PaulB-TheOneAndOnly
PaulB-TheOneAndOnly
One Orange Chip
One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)

Group: General Forum Members
Points: 26525 Visits: 4639
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". :-)

_____________________________________
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.
Sean Lange
Sean Lange
SSC Guru
SSC Guru (113K reputation)SSC Guru (113K reputation)SSC Guru (113K reputation)SSC Guru (113K reputation)SSC Guru (113K reputation)SSC Guru (113K reputation)SSC Guru (113K reputation)SSC Guru (113K reputation)

Group: General Forum Members
Points: 113436 Visits: 18297
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 Modens splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum







































































































































































SQLServerCentral


Search