Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-sqlserver > #904

Re: Going into DB war zone. Need help !

Show all headers | View raw

On Jan 21, 1:58 am, "Bob Barrows" <reb01...@NOSPAMyahoo.com> wrote:
> vaib wrote:
> > Hi all,
>
> > I am a .net developer for the past 2.5 years. I am very good with
> > coding as far as C#, Asp.Net, JScript, etc. is concerned but I am not
> > very well versed with databases(sql server). Although I can write
> > simple joins and stuff but it give me jitters when it comes to more
> > advanced stuff like writing complex dynamic sql and stuff. Also, I
> > feel the need to consult google for syntax of a lot of things. I know
> > sql is just like any other language and it's only a matter of time and
> > practice before I become really good at it. But the thing is that I
> > would be joining a startup soon where there is a lot of DB intensive
> > work and I don't want to go there without good DB knowledge. It would
> > also be a very good opportunity for me to learn DB.
>
> > So, basically what I am asking here is for help. Please tell me some
> > resources\site\tutorial\book that you know of that can give me a lot
> > of hands-on exercises. All I want is a lot exercises to do. Writing
> > lots of dynamic sql. Scenario based questions. Stuff that can prepare
> > me for the war!
>
> > Thanking in anticipation. I only turn to usenet when I am need some
> > serious help.
>
> Avoiding dynamic sql is a better goal, especially if writing web-based
> applications (sql injection is enabled by the use of dynamic sql).
> Parameterized stored procedures are a must for the serious sql server
> developer.
>
> Anyways, you're putting the cart before the horse here. You really need to
> learn to write queries (sql) before moving on to dynamic sql. Dynamic sql is
> simply the process of concatenating some strings together to form a sql
> statement that gets passed to a database to be executed. If you can't write
> sql statements, dynamic sql is out of the question.
>
> But if you must, Erland's written some good articles on the subject. You can
> find them along with several other good articles atwww.sommarskog.se
>
> www.sqlservercentral.comis an excellent resource.
> I've heard some good recommendations for a book called Database Design For
> Mere Mortals, although I've never read it myself.
>
> Other than that - dive into SQL Books Online (BOL - it's installed on your
> machine when you install sql server client tools - you can also read them
> online at microsoft.com - use those google skills to find it <g>), and start
> reading.

Hi,

Not putting the cart before the horse. You should not expect that from
someone who is 2.5 years experienced! I am just asking for hands on
practice resources. And I know what dynamic sql is. Just want to have
practice on it too.

Thanks anyways.

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Going into DB war zone. Need help ! vaib <vaibhavpanghal@gmail.com> - 2012-01-20 12:36 -0800
  Re: Going into DB war zone. Need help ! "Bob Barrows" <reb01501@NOSPAMyahoo.com> - 2012-01-20 15:58 -0500
    Re: Going into DB war zone. Need help ! vaib <vaibhavpanghal@gmail.com> - 2012-01-21 06:25 -0800
    Re: Going into DB war zone. Need help ! "Andrew Morton" <akm@in-press.co.uk.invalid> - 2012-01-23 09:18 +0000
  Re: Going into DB war zone. Need help ! Erland Sommarskog <esquel@sommarskog.se> - 2012-01-20 23:32 +0100
    Re: Going into DB war zone. Need help ! vaib <vaibhavpanghal@gmail.com> - 2012-01-21 06:22 -0800
      Re: Going into DB war zone. Need help ! Erland Sommarskog <esquel@sommarskog.se> - 2012-01-21 17:42 +0100
        Re: Going into DB war zone. Need help ! vaib <vaibhavpanghal@gmail.com> - 2012-01-22 01:57 -0800

csiph-web