Post reply

Oracle Database

  • August 27, 2012 at 6:01 am

    #393029

    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.

  • August 27, 2012 at 12:28 pm

    #1530467

    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.

  • August 27, 2012 at 1:00 pm

    #1530478

    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!

  • August 27, 2012 at 1:56 pm

    #1530499

    Nice link, pity I'm slimming down.

  • August 28, 2012 at 11:19 am

    #1530976

    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.

  • September 19, 2012 at 9:17 am

    #1539628

    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 http://www.sqlservercentral.com/articles/Tally+Table/72993/.

    Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
    Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
    Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
    Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply