1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Hi To all - hoping for some good advice !

Discussion in 'New Members Introduction' started by jmdrake, Jul 3, 2009.

  1. jmdrake

    jmdrake New Member

    3
    0
    20
    Hi All Jon here.
    I have been reading some old posts and there seem to be a lot of people with good advice.
    I have been in IT for about 20 Yrs now and was recently made redundant and am looking to change path.
    I have mainly been an Infrastructure Technician dealing mainly with hardware and network support.
    I fancy training to become a SQL developer / programmer and was contemplating going on a MCTS in SQL Server 2005.
    After reading the course material I feel its a little out of my depth as I have not used it commercially in any depth.
    can anyone give me some sound advice as the way forward I could consider and what courses might help.
    I have been looking for jobs where I can get experiance but they are few & far between.
    I have been looking at doing a Writing Queries Using Microsoft SQL Server 2008 with Transact SQL as a starting point?
     
    Certifications: HND Electronic Engineering.
  2. jk2447

    jk2447 Petabyte Poster Moderator

    5,481
    352
    249
    Hi and welcome to Cert Forums. DMarsh will be able to give you good advice mate, Jim
     
    Certifications: BSc (Hons), HND IT, HND Computing, ITIL-F, MBCS CITP, MCP (270,290,291,293,294,298,299,410,411,412) MCTS (401,620,624,652) MCSA:Security, MCSE: Security, Security+, CPTS, VCP4, CCA (XenApp6.5), MCSA 2012, VCP5, VCP6-NV
  3. BosonMichael
    Highly Decorated Member Award

    BosonMichael Yottabyte Poster

    19,136
    462
    374
    It'll be more difficult to break into SQL administration without any SQL administration experience. Still, you do have quite a bit of other experience... have you considered a network administration job where you do SQL administration as part of your duties to build up your experience level?
     
    Certifications: CISSP, MCSE+I, MCSE: Security, MCSE: Messaging, MCDST, MCDBA, MCTS, OCP, CCNP, CCDP, CCNA Security, CCNA Voice, CNE, SCSA, Security+, Linux+, Server+, Network+, A+
    WIP: Just about everything!
  4. jmdrake

    jmdrake New Member

    3
    0
    20
    Hi mike .
    thanks for your reply - i thought i was in one where i was but after 10 years didnt get the chance - I have been trying to get a job which as similar to what you mentioned but the only ones I have seen also require VWware which again we didnt use so I dont know where to go now ?
     
    Certifications: HND Electronic Engineering.
  5. wagnerk
    Highly Decorated Member Award

    wagnerk aka kitkatninja Moderator

    10,831
    357
    341
    Hi & welcome to CF :)

    The candidate profile for the MCTS in SQL 2008 would be for people already working with the product, see here. However MS in the DB field is only one of the many companies there, there is MySQL and the CMA track for entry level personnel. There's also the intro exams from Oracle, the 1Z0-007 and the 1Z0-051. For a more general, non-version specific, qualification... There's always the college/Uni route.

    Saying that, I do not specialize in databases (I do work with SQL 2005).

    -Ken
     
    Certifications: CITP, PGCert, BSc, HNC, LCGI, PTLLS, MCT, MCITP, MCTS, MCSE, MCSA:M, MCSA, MCDST, MCP, MTA, MCAS, MOS (Master), A+, N+, S+, ACA, VCA, etc... & 2nd Degree Black Belt
    WIP: PGDip
  6. jmdrake

    jmdrake New Member

    3
    0
    20
    i'm a little old for college & Uni now - been there and got HND back in 96 need to be working again to support the family and i wanted to get into SQL development / programmer side of things now
     
    Certifications: HND Electronic Engineering.
  7. wagnerk
    Highly Decorated Member Award

    wagnerk aka kitkatninja Moderator

    10,831
    357
    341
    Mate,

    1. You're never to old to go back to Uni &
    2. There are part-time/distance learning courses available from both the local Uni/college and from the OpenU...

    -Ken
     
    Certifications: CITP, PGCert, BSc, HNC, LCGI, PTLLS, MCT, MCITP, MCTS, MCSE, MCSA:M, MCSA, MCDST, MCP, MTA, MCAS, MOS (Master), A+, N+, S+, ACA, VCA, etc... & 2nd Degree Black Belt
    WIP: PGDip
  8. Notes_Bloke

    Notes_Bloke Terabyte Poster

    3,230
    54
    146
    Hi & welcome to CF:D

    NB
     
    Certifications: 70-210, 70-215, A+,N+, Security+
    WIP: MCSA
  9. dmarsh

    dmarsh Terabyte Poster

    3,782
    302
    184
    Rudimentary SQL is not that hard to pick up and SQL Server is very user friendly.

    The course material for MCTS 2005 is pretty straightforward, sounds like you need to do more studying about SQL and SQL server then. Buy a couple of non certification books and work your way through them along with the product.

    You could look for SQL courses at local colleges, they tend to be reserved for enrolled students though. The OU has some DB modules. Both at the masters and undergrad level.

    In reality most places will not give you a job on the basis of knowledge of rudimentary SQL, you either have to be a hard core DBA, progammer, infrastructure guy, or something else.

    Learning Microsoft SQL Server 2008 with Transact SQL is the obvious starting point.

    Most developer jobs however will expect far more, .NET, C#, XML, LINQ, ADO .NET, and probably a whole lot more.

    If you really want to be a programmer I'd probably learn C# first. Developer jobs will be thin on the ground in this climate though, especially for people without experience.

    Best of luck ! :D
     
    Certifications: CITP, BSc, HND, SCJP, SCJD, SCWCD, SCBCD, SCEA, N+, Sec+, Proj+, Server+, Linux+, MCTS, MCPD, MCSA, MCITP, CCDH

Share This Page

Loading...