Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Oracle Database Expand / Collapse
Author
Message
Posted Monday, August 27, 2012 6:01 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Monday, August 27, 2012 12:28 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 4:28 AM
Points: 1,400, Visits: 6,794
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
Posted Monday, August 27, 2012 1:00 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 1:23 PM
Points: 12,927, Visits: 32,330
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
Posted Monday, August 27, 2012 1:56 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 4:28 AM
Points: 1,400, Visits: 6,794
Nice link, pity I'm slimming down.
Post #1350564
Posted Tuesday, August 28, 2012 11:19 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, January 28, 2014 8:15 AM
Points: 3,065, Visits: 4,639
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.
Post #1351136
Posted Wednesday, September 19, 2012 9:17 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 9:10 AM
Points: 13,230, Visits: 12,709
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
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1361430
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse