August 19, 2011 at 7:44 am
I'm relatively new to SQL Server. In fact I have little experience. I've used the training kit with little success. The test was a bit hard, so I decided that the best way to learn SQL Server 2008 was to build an entire database from scratch. The adventure works database is… inferior in some respects. It provides poor test prep for beginners. Therefore, I want to design an entire database by myself and I am wondering the steps I may need to take. I want to create the SSIS code, and all the programs I will need for a database. So my first question is how do you build an ETL (SSIS) based server? We have multiple computers at home so storage and learning won’t be an issue.
August 19, 2011 at 8:41 am
New Horizons (8/19/2011)
I'm relatively new to SQL Server. In fact I have little experience. I've used the training kit with little success. The test was a bit hard, so I decided that the best way to learn SQL Server 2008 was to build an entire database from scratch. The adventure works database is… inferior in some respects. It provides poor test prep for beginners. Therefore, I want to design an entire database by myself and I am wondering the steps I may need to take. I want to create the SSIS code, and all the programs I will need for a database. So my first question is how do you build an ETL (SSIS) based server? We have multiple computers at home so storage and learning won’t be an issue.
Awfully big question.
You could start by reading up on database design, normal forms, referential integrity. Then make sure you understand the data you need to store. Create a logical & physical model of the data. Create your DDL, then you can populate it in SSIS. Piece of cake -- you're done.
August 19, 2011 at 8:45 am
This was removed by the editor as SPAM
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply