Home Forums Career Certification I'm totally new. Need some guide on SQL 2012 RE: I'm totally new. Need some guide on SQL 2012

  • Go here:

    http://www.microsoft.com/en-gb/download/details.aspx?id=29062

    download and install this file:

    ENU\x64\SQLEXPRWT_x64_ENU.exe this one is With Tools (i.e. includes SSMS - SQL Server Management Studio). I don't think you will need the advanced tools version, but you can

    (I am assuming English, get whatever language suits you best)

    SQL Express is a cut down version of SQL Server but only cut down in terms of the size of database file and number of CPUs supported and some other really advanced features - you can still use it to learn most of SQL Server.

    Now you have the tools to begin.

    Most things can be done in two ways, either using the GUI interface - i.e. the Object Explorer window in SSMS - right click on the treeview to create database query tables etc - or using T-SQL using the Query window in SSMS. You have to learn both for the exam.

    I had a quick look at the exam syllabus - and from complete newbie to being prepared for exam by September is a tall order - but I have done a Microsoft Exam (ASP.NET) from virtually nothing to pass in 6 weeks so it is doable - but be warned you will have to treat it as a full time job in itself - we had a very quiet time at work so I could use spare time at work, and all evenings and weekends to study.

    Good luck.