Folks,
I'm new to sql server and want to know
1) what are the possible ways to program ( I mean do we have any frontend tools OR where do we write program which eventually talks to sql database)so we can do ETL operation for data of sql server DB.
2) How to learn that programing ( meaning what are the resources? )
3) I'm new to database concepts as i'm Java Programer - what basic things I must know in order to design sql database?
all above que is to support my current new job, PLS advise asap.
thanks.
Well, the ETL function of SQL Server 2005 is called SSIS, so you will want to study up on that. I, like you, have had to learn by pretty much diving into it head first. I do, however have a VS .Net 2003 and Visual Basic background.
I have used MSDN heavily, these forums heavily and have many books pertaining to Visual Basic, ADO.Net, SQL Server, etc.
I know that this is not much, but it might be a start. I do like the books from Microsoft Press. I also have some from McGraw-Hill.
|||you may want to start learning sql with then
database normalization, select statement , views, sp, udfs,index,file and filegroups
|||This is helpful..I'll check these things from some sql books.
Thanks a lot.
|||Good Info but can you tell me little more specificaly that if i don't use any .Net langauge to write small program is there anyh tool in sql server 2005 which provides me development enviroment? for example editor where I can write queries/procedures/programmes.
OR Let me ask you that,
Do i have to use some .Net lang as frontend OR there is some tools/editor/enviroment which i can use from sql server/client installation?
|||If you already have an existing database, you can start using it with SqlConnection and SqlCommand. Look them up in the MSDN. You’ll need a book to get started with the T-SQL language. Then you’ll use the Books Online of SQL Server.
About OR – we are working on it. A CTP is about to be released. Keep an eye on http://www.microsoft.com/data.
No comments:
Post a Comment