Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Urgent: New to SQL Please help

Author  Topic 

aloeyey
Starting Member

2 Posts

Posted - 2010-09-05 : 01:18:20
Dear All,

I am new to SQL and undergoing a project on Data Warehouse.Sincere
request to all.Please guide me installing Microsft SQL 2008 and how to use it for creating Cubes,loading data and ceating reports.

Please help.

Thanks in Advance.

Dubey,Alok

slimt_slimt
Aged Yak Warrior

746 Posts

Posted - 2010-09-05 : 09:53:53
is this a school project?

- you can find some instructions on how to install MSSQL 2008, but it's relatively simple if you follow wizard.
- creating cubes ? you should know some basics for datawarehousing first, campell's schema, star schema, etc.
- loading data - ETL - is also another big issue, not so straightforward to explain in one post
- creating reports as well

i suggest you to take some books on Datawarehousing, on MSSQL SSRS, MSSQL SSIS and MSSQL SSAS.
Go to Top of Page

slimt_slimt
Aged Yak Warrior

746 Posts

Posted - 2010-09-05 : 09:54:29
is this a school project?

- you can find some instructions on how to install MSSQL 2008, but it's relatively simple if you follow wizard.
- creating cubes ? you should know some basics for datawarehousing first, campell's schema, star schema, etc.
- loading data - ETL - is also another big issue, not so straightforward to explain in one post
- creating reports as well

i suggest you to take some books on Datawarehousing, on MSSQL SSRS, MSSQL SSIS and MSSQL SSAS.
Go to Top of Page
   

- Advertisement -