| Author |
Topic |
|
coolforyou
Starting Member
3 Posts |
 Posted - 2012-07-04 : 14:58:39
|
| Hi all ,I am a newbie , actually was learning JAVA , but now i got job in SQL server as fresher . Now i want to know how to start my carrier in Sql server so help me inwhat to learn ? from where to learn ?And i want to know the difference between DBA and database developer . who plays the vital role and important role(highly paid salary) , DBA or database developer ?Do i have to learn C# for doing effective task? ....sorry for my too many newbie question s , i hope you all will kindly help me .. thanks in advance [Smile] |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-07-04 : 15:30:54
|
Depends on your learning style. If you like reading or self-paced tutorials, there are very many on the web. Here are a few (thanks to DonAtWork)http://www.sql-tutorial.net/ http://www.firstsql.com/tutor.htm http://www.w3schools.com/sql/default.asp There are introductory books as well - some that I think are good are these:Head first SQL: http://www.amazon.com/Head-First-SQL-Brain-Learners/dp/0596526849(not specific to SQL Server)Ben-Gan's T-SQL: http://www.amazon.com/Microsoft%C2%AE-Server%C2%AE-T-SQL-Fundamentals-PRO-Developer/dp/0735626014/Robert Vieira's book: http://www.amazon.com/Beginning-Microsoft-Server-Programming-Programmer/dp/0470257016/Knowledge of C# or another .Net programming language is useful, but not essential to get started. But if you want to become an expert in SQL Server, you will need to have at least working knowledge of a .net programming language.There are a number of companies offering immersive classes on various aspects of SQL Server. Many of them are week-long classes on a specific topic within SQL Server; they typically cost a few thousand dollars. I have not attended any such classes, so I can't speak to how good they are.All of what I said assumes your job involves Microsoft SQL Server. If the database server is from another vendor such as Oracle or MySQL, you would get better answers at another forum such as dbforums.com |
 |
|
|
coolforyou
Starting Member
3 Posts |
Posted - 2012-07-05 : 15:39:47
|
quote:
Originally posted by sunitabeck
Depends on your learning style. If you like reading or self-paced tutorials, there are very many on the web. Here are a few (thanks to DonAtWork)http://www.sql-tutorial.net/ http://www.firstsql.com/tutor.htm http://www.w3schools.com/sql/default.asp There are introductory books as well - some that I think are good are these:Head first SQL: http://www.amazon.com/Head-First-SQL-Brain-Learners/dp/0596526849(not specific to SQL Server)Ben-Gan's T-SQL: http://www.amazon.com/Microsoft%C2%AE-Server%C2%AE-T-SQL-Fundamentals-PRO-Developer/dp/0735626014/Robert Vieira's book: http://www.amazon.com/Beginning-Microsoft-Server-Programming-Programmer/dp/0470257016/Knowledge of C# or another .Net programming language is useful, but not essential to get started. But if you want to become an expert in SQL Server, you will need to have at least working knowledge of a .net programming language.There are a number of companies offering immersive classes on various aspects of SQL Server. Many of them are week-long classes on a specific topic within SQL Server; they typically cost a few thousand dollars. I have not attended any such classes, so I can't speak to how good they are.All of what I said assumes your job involves Microsoft SQL Server. If the database server is from another vendor such as Oracle or MySQL, you would get better answers at another forum such as dbforums.com
Thanks a lot for your wonderful reply ,link and help sunitabeck :). Can you please share names of any best books which teaches the overview , working of web application created in .net and sql server with some basic example with coding(like open source project available in source forge) on what to use and how to use the app server , web server and web service ext ... sorry for my too many request . i Just want to know the overview flow between front end(c# Asp dotnet ) and backend(sql server) ...it will be very helpful for me in my carrier .... Thanks in advance ...:) |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2012-07-05 : 16:23:24
|
| W3Schools has ASP.Net tutorials, actually has a lot of programming language tutorials. If you want some more advanced .Net stuff:http://www.4guysfromrolla.com/There are tons of other sites for ASP.Net learning too. I'd suggest checking them out before investing in a book. The only books I'd recommend in general would be O'Reilly or Pragmatic Programmers, they are almost always excellent. |
|
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2012-07-05 : 18:16:07
|
| Check outSeven Languages in Seven Weekshttp://pragprog.com/book/btlang/seven-languages-in-seven-weeksandSeven Databases in Seven Weekshttp://pragprog.com/book/rwdata/seven-databases-in-seven-weeks2 Amazingly good books. But read them at your own time if you are new to development. Seven weeks is pretty optimistic for a good understandingAs to Developer vs DBA -- it completely depends on the company. In some places the roles are more or less indistinguishable at first. In others there is a real division between who makes things and who keeps them going.... In others a developer is quite a junior role and there are 'architects' to design the databases. In others a developer will be responsible for the whole design including setting up replicaiton, indices and filegroups..I think, in general, (in the UK) an average DBA is probably paid slightly more than an average Database Developer.Transact CharlieMsg 3903.. The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION. |
|
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-07-05 : 20:11:01
|
| Another thing you could do, if you have the resources to do it, is to get a subscription to Safari Books. (http://www.safaribooksonline.com/). I think they have month to month personal subscriptions as well as annual corporate subscriptions. They have most of the books that I am interested in - from publishers such as Apress, O'Reilly, Sams, Wrox etc. Subscription to their service is better than buying individual books (at least in my opinion), because you can search a whole big library, browse through books, read them on your IPad etc. etc. |
|
|
|
coolforyou
Starting Member
3 Posts |
Posted - 2012-07-10 : 10:34:32
|
| hi guys ,Thanks a lot for all your valuable replies and help . I thank you all again .one more query now ; i want to learn the basic database concepts , so can any one suggest me some nice and good book ? thanks in adance |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2012-07-10 : 11:20:13
|
| I've always liked SQL For Dummies. It's a great intro. |
|
|
|
|
HI all . Glad to see you all . Need guidance :)