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

SQL 70-228 For begginer

Discussion in 'SQL Exams' started by Luddym, Dec 21, 2005.

  1. Luddym

    Luddym Megabyte Poster

    797
    19
    74
    Hi people,

    Im currently studying for my MCSA/E and was having trouble finding an elective. I saw the 70-228 for SQL and thought it would be an interesting challenge.

    However, reading some posts and some other websites, it sounds like this may be a little daunting.

    About ten years ago I studied Databases with A-Level computing, packages such as Foxpro, and MS Access. I have a little grounding, but obviously nothing up to date, and nothing as far as servers are concerned.

    Am I getting myself in too deep with this one?

    Any advice would be much appreciated guys, and gals.

    Many thanks In Advance.
     
    Certifications: VCP,A+, N+, MCSA, MCSE
    WIP: Christmas Drunkard
  2. simongrahamuk
    Honorary Member

    simongrahamuk Hmmmmmmm?

    6,199
    125
    199
    It really depends on how much hands on you are able to get with SQL.

    SQL is a hard topic if you have no hands on experience with it, and not something you can simply read up on.

    I spent a good few months reading up and playing with SQL databases once but ended up giving up because I simply couldn't get enough hands on with it, and struggled to grasp the SQL language.

    If this is an elective that you really want to do, but don't have any prior dealings with it I'd recommend trying to do a hands on course with a training provider.

    8)
     
  3. Luddym

    Luddym Megabyte Poster

    797
    19
    74
    Excellent, thanks for the reply simon.

    I think i will go ahead for it, but will try and lay my hands on a copy of SQL server and some learnkey or CBT nuggets too.

    Thanks again.
     
    Certifications: VCP,A+, N+, MCSA, MCSE
    WIP: Christmas Drunkard
  4. Boycie
    Honorary Member

    Boycie Senior Beer Tester

    6,281
    85
    174
    Luddy,

    I would appreciate any feedback on SQL stuff. If you don't mind PM'ing me when you do as this thread will probably be gone............
     
    Certifications: MCSA 2003, MCDST, A+, N+, CTT+, MCT
  5. hbroomhall

    hbroomhall Petabyte Poster Gold Member

    6,623
    115
    224
    On a Windows platform other than paying serious money for MSSQL there is always MySQL and PostgreSQL.

    The latter is a very good RDBMS, while MySQL is OKish.

    Under Unix/Linux then these two are the standard choice, with one or both being installed by default quite often.

    The great thing about both is that they are free. In the case of Postgres this is unconditional, for MySQL there are weird licensing rules, but personal use is OK.

    Harry. (Who uses and admins both on a daily basis)
     
    Certifications: ECDL A+ Network+ i-Net+
    WIP: Server+
  6. Boycie
    Honorary Member

    Boycie Senior Beer Tester

    6,281
    85
    174
    Thanks for that Harry, appreciated`:thumbleft
     
    Certifications: MCSA 2003, MCDST, A+, N+, CTT+, MCT
  7. ffreeloader

    ffreeloader Terabyte Poster

    3,661
    106
    167
    I agree. While I know SQL Server 2000 better than I know MySQL or PostgreSQL it's been my experience that PostgreSQL is the better of the two, at least for what I've been using it for. It has a capabilities that MySQL just doesn't have.
     
    Certifications: MCSE, MCDBA, CCNA, A+
    WIP: LPIC 1
  8. Luddym

    Luddym Megabyte Poster

    797
    19
    74
    Thanks for the replies guys.


    Just a thought, If I learnt MySql (I already have the book, and have had for quite some time) would it help me with MS SQL and the SQL Exam?


    Boyce, as soon as I start it, I will definately let you know about the stuff. :D
     
    Certifications: VCP,A+, N+, MCSA, MCSE
    WIP: Christmas Drunkard
  9. JonnyMX

    JonnyMX Petabyte Poster

    5,239
    211
    236
    228 goes hand in hand with 229 quite well.
    I've done 229, but not 228 yet.

    It might be a bit odd to do 'installing and configuring' then not the 'using'.
     
    Certifications: MCT, MCTS, i-Net+, CIW CI, Prince2, MSP, MCSD
  10. Boycie
    Honorary Member

    Boycie Senior Beer Tester

    6,281
    85
    174
    Thanks, appreciated :thumbleft
     
    Certifications: MCSA 2003, MCDST, A+, N+, CTT+, MCT
  11. hbroomhall

    hbroomhall Petabyte Poster Gold Member

    6,623
    115
    224
    The main problem with SQL is that while there is a standard many products don't follow that standard very well. There are many reasons for this, some of them historical, and some because the standard is lacking in some areas.

    The result of this is that while use of MySQL may help with some basics, if you are doing a M$ exam you need to know Microsofts take on things, so you *may* wind up confused by the differences.

    Harry.
     
    Certifications: ECDL A+ Network+ i-Net+
    WIP: Server+
  12. Boycie
    Honorary Member

    Boycie Senior Beer Tester

    6,281
    85
    174
    oh, i was under the impression was like learning English...
     
    Certifications: MCSA 2003, MCDST, A+, N+, CTT+, MCT
  13. hbroomhall

    hbroomhall Petabyte Poster Gold Member

    6,623
    115
    224
    Really? :biggrin

    The trouble with SQL is that it may have english-like appearance in parts, but many words have very precise meanings which is unlike ordinary language where imprecision rules!

    A small sample:
    create view ic_bill_summary as select refday, class_id, sub_class, call_categ, chargeband_id, mins, call_count, rate from rate join (select refday, class_id, sub_class, call_categ, chargeband_id, mins, call_count, id from ic_day_summary join rate_selector using (class_id, sub_class, call_categ) where ratesetid = 2) as part1 on id = rate_selector_id and chargeband_id = chargeband and refday between rate_date_start and rate_date_end;

    This is two nested inner joins. I have other examples with even more nested joins. English-like perhaps, but readable.....

    Harry.
     
    Certifications: ECDL A+ Network+ i-Net+
    WIP: Server+
  14. zimbo
    Honorary Member

    zimbo Petabyte Poster

    5,215
    98
    181
    Luddym since you doing the MCSE doing the 228/229 aswell will give you the MCDBA cert.. but like the guys have said SQL will be hard work!
     
    Certifications: B.Sc, MCDST & MCSA
    WIP: M.Sc - Computer Forensics
  15. JonnyMX

    JonnyMX Petabyte Poster

    5,239
    211
    236
    Yeah.
    I did an MCSD, so if I can do 228 and 290 I'll have an MCDBA too, so that's my next project.
    I love SQL, and it has a fairly gentle learning curve.
    You think to yourself 'this is quite easy', but it turns into a monster quite quickly.
     
    Certifications: MCT, MCTS, i-Net+, CIW CI, Prince2, MSP, MCSD
  16. bosox2004

    bosox2004 New Member

    9
    1
    19
    Luddym

    I took 70-228 as one of my electives when I did my MCSE and it is not the easiest option if you've never used SQL before. If you're going to be dealing with DBs on SQL Server it is a useful option but as some of the others have pointed out SQL is skill you have to use on a fairly regular basis in order to stay proficient.
    The main thing to note is that from my recollection of taking the exam (now 2 years ago) was that it focuses heavily on administering the SQL Server itself in terms of backups, restores, database sizes etc. The sql used for a lot of this is transact-sql that is used on SQL Server.
    A basic understanding of sql in terms of data manipulation is useful (such as SELECT, INSERT etc as well as Joins) but otherwise a lot of it was understanding how to use the stored proceedures (pre written sql script) as an alternative to the GUI driven wizards available through SQL Server's Enterprise Manager.
    I hope this is helpful for you in making your decision
     
    Certifications: MCSE(W2K/W2K3),MCSA(W2K/W2K3),MCDBA
    WIP: CCNA
  17. nugget
    Honorary Member

    nugget Junior toady

    7,796
    71
    224
    Well it sort of is like that Boyce. It's just which version of English do you want to learn, American, Australian, Queen's or Zimbabwe?
     
    Certifications: A+ | Network+ | Security+ | MCP (270,271,272,290,620) | MCDST | MCTS:Vista
    WIP: MCSA, 70-622,680,685
  18. Boycie
    Honorary Member

    Boycie Senior Beer Tester

    6,281
    85
    174
    LOL Anyhow, English is supposed to be one of the hardest languages to learn :tongue After SQL that is!
     
    Certifications: MCSA 2003, MCDST, A+, N+, CTT+, MCT
  19. Luddym

    Luddym Megabyte Poster

    797
    19
    74
    Hey Bosox,

    Thanks for the detail info, much appreciated. It does help, sort of puts my mind at ease.

    My 'All in one' SQL 2000 book dropped through the door today, for the 70-228 and 70-229. It had really bad reviews from Amazon, but to me, that is only a good thing. (Stay with me here, I have strange reasoning.) Now I know that the content of the book needs a lot to be desired, I won't read the book, partake the examples and test, pass those with flying colours and then think I'm ready to take on the world . . . uhm, Exam.

    So this way, I will be forced to learn the book, then explore other manuals to try to find bits that were missed, thus filling in the gaps AND reiterating the bits I'd already learn't. See, some method in my madness. :)

    Thanks again everyone for your posts. :)
     
    Certifications: VCP,A+, N+, MCSA, MCSE
    WIP: Christmas Drunkard
  20. Gaz 45

    Gaz 45 Kilobyte Poster

    404
    4
    39
    Too right!

    And Harry, it's a little unfair putting no structure whatsoever into that SQL statement... :blink
     
    Certifications: MCP (70-229, 70-228), MBioch
    WIP: MCDBA (70-290)

Share This Page

Loading...