Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003
    Posts
    3

    New to DataBases

    Hi,

    I am new to Database World. I have been with computers for a while and been graduate school but never had an opportunity to work with databases. So i need your advice on getting started , some good books and links, so that i get my baiscs right.

    In near future, i might have an opportunity to built DataWare house and data marts. So i am trying to new basics and some good practices.

    I have seen a post listing topics on Data Ware housing.

    An Introduction to Data Warehousing:

    Database systems -- OLTP& DSS
    Warehouse Architecture
    Staging Areas & Data Marts
    Data Modeling
    Normalization and De- Normalization
    Schemas
    Fact Tables
    Dimension Tables
    Star and Snowflake Schemas
    Concept of ETL ( Extract ,Transaction and Load Process )
    OLAP concepts
    Understanding Dimensions, Details and Measures.

    But before getting there. What concepts i need to know about databases in general and some very specific details to built a DataWare house.

    Can the experts help me with this.

    I really appreciate all your time and help.

    thanks
    Praveen.


    __________________
    --praveen

    P.S: I apologize for cross posting, but just found that this question is more appropriate here.

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171

    Re: New to DataBases

    Originally posted by pcheruvu
    Hi,

    I am new to Database World. I have been with computers for a while and been graduate school but never had an opportunity to work with databases. So i need your advice on getting started , some good books and links, so that i get my baiscs right.

    In near future, i might have an opportunity to built DataWare house and data marts. So i am trying to new basics and some good practices.

    I have seen a post listing topics on Data Ware housing.

    An Introduction to Data Warehousing:

    Database systems -- OLTP& DSS
    Warehouse Architecture
    Staging Areas & Data Marts
    Data Modeling
    Normalization and De- Normalization
    Schemas
    Fact Tables
    Dimension Tables
    Star and Snowflake Schemas
    Concept of ETL ( Extract ,Transaction and Load Process )
    OLAP concepts
    Understanding Dimensions, Details and Measures.

    But before getting there. What concepts i need to know about databases in general and some very specific details to built a DataWare house.

    Can the experts help me with this.

    I really appreciate all your time and help.

    thanks
    Praveen.


    __________________
    --praveen

    P.S: I apologize for cross posting, but just found that this question is more appropriate here.
    Look for "Introduction to Database Systems" by C J Date, for a grounding in relational database theory. All the big name SQL-based databases are imperfect implementations of relational theory, so it's good to know the basics first.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •