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.
| Author |
Topic |
|
AndyTheAnimal
Starting Member
2 Posts |
 Posted - 2010-05-26 : 04:57:50
|
| Hi there, I've worked in the NHS (UK Health Service) for a while with information/data and have used COGNOS and Business Objects quite a bit. There are a number of jobs that I am looking to apply for and they all require SQL server experience. What I would like to do, is to find the right version and get learning for the future. I really need initially to understand the difference between SSIS and SQL server as well as some good ways of learning that don't cost the Earth. Any help at all greatly appreciated, specifically from NHS SQL people. |
|
|
chris_cs
Posting Yak Master
223 Posts |
Posted - 2010-05-26 : 06:54:23
|
| I guess the main difference you need to know about SQL Server itself and SSIS is that SQL Server is the core DB system i.e. it stores and looks after structured data.SSIS gives you the ability to transform data and then import it into your SQL Server database. For example, if you had a spreadsheet with a large amount of data, and this data needed to be 'cleaned' before being imported, you could create an SSIS package to extract, clean and then insert the data into your SQL Server DB.I'd say the easiest way is to learn by doing. You could download SQL Server express which is free and buy a book to start playing around with it. A course might be the quickest way to learn and get started but this could be expensive.If you're learning for the future you should look at SQL Server 2008.Hope this helps |
 |
|
|
AndyTheAnimal
Starting Member
2 Posts |
Posted - 2010-05-26 : 07:05:19
|
| Cheers, the difference is now a bit more obvious and to be honest, I think that I would need a bit of both but neither in an expert capacity.I'll take a look about. Could you recommend any good training/learning web-sites that are free at all? |
|
|
|
chris_cs
Posting Yak Master
223 Posts |
Posted - 2010-05-26 : 07:11:34
|
| This site has a lot of good articles about various parts of SQL Server and there are a couple of other similar ones.Maybe some other people can suggest some good sites.If you were to download SQL Express and find that something didn't quite make sense then you can always post something on this forum and people will only be happy to help.As I said, it's best to learn by doing! |
|
|
|
Sachin.Nand
2937 Posts |
Posted - 2010-05-26 : 07:20:23
|
| But SQL Express Edition does not include SSIS module.You will have to move to Standard edition and above.PBUH |
|
|
|
chris_cs
Posting Yak Master
223 Posts |
Posted - 2010-05-26 : 08:27:41
|
| Oops...I should have mentioned that |
|
|
|
|
|
|
How to learn SQL server/SSIS