How to study for the MCSA: SQL Server Exams?


hi guys, 

forgive me if question has been answered i'm trying find out best way tackle 3 exams required mcsa in sql server. read blog post on pluralsight website which, in discussing mcsa in windows server, advised best approach study 3 exams rather 1 @ time there's amount of overlap.

my question apply sql server 2012 too? or bets study for, , take, 3 exams separately , 1 @ time? i'm completing trainsignal (now pluralsight) sql server 2012 administration essentials 28-video course , begin going through equivalent book when read blog post.

my background in desktop/server support (10years following degree) , before now, have had no real exposure sql server. asked year ago current manager "keep eye" on sql instances have , began replicating our fail-over cluster in virtual environment testing purposes , gain understanding of set-up. i've since developed keen interest in sql server , plan certified...  

many in advance.

marcus.

exams are:



1

querying microsoft sql server 2012


2

administering microsoft sql server 2012 databases

3

implementing data warehouse microsoft sql server 2012
 

it better go 1 @ time rather studying together.

go through skills measured section of each paper. find out paper looks more familiar , easy you. start paper. being desktop/server support guy has started working on sql, 70-462 might easier if have tried out administration related things in last year.

to make easy 70-461 querying/programming , 70-462 administration, 70-463 bi/ssis

i did 70-462 first 461 , 463. personal preference.

regards, ashwin menon blog - http:\\sqllearnings.com



SQL Server  >  Getting started with SQL Server



Comments

Post a Comment

Popular posts from this blog

SQL server replication error Cannot find the dbo or user defined function........

hi there, i ran problem while deploying sql 2008 transactional replication between 2 servers lets assume server , b. actually created  both distributor , publisher on server , after created subscriber pointed server b, launch replication monitor , found big red cross. when click on tab "distributor subscriber history" error says "cannot find either column "dbo" or user defined-function or aggregate "dbo.ufnleadingzeros", or name ambiguous". can body regarding issue. regards, ishuv hi, you need compare data , others reseved, index size, unused should not compared. differs. here server - data - 87896 kb server b - data - 78152 kb server data size includes publication tables, can't compare directly. need check article article know exact data size. SQL Server  >  ...
Read more

BIT Version

  hi,     knows how find out ther bit version in sql  , windows os (32 or 64)   regards, s.balavenkatesh   microsoft sql server 2005 - 9.00.1399.06 (intel x86) oct 14 2005 00:33:37 copyright (c) 1988-2005 microsoft corporation standard edition on windows nt 5.2 (build 3790: service pack 2)     intel x86)   -- says sql server 32 bit   madhu SQL Server  >  SQL Server Tools
Read more

Admin Permissions

hi need create new 'role' following permissions, 1. access sql server logs. 2. access maintenance plans ( can avoid access) 3. access activity monitor 4. normal access product databases , not system db´s need guidance on how it, can point me in right direction please? thanks 1.grant  execute on xp_readerrorlog [domainname\ad user or group]; 2. http://technet.microsoft.com/en-us/library/ms191002.aspx 3.view server state permission 4. make user member of dbo_owner database role. best regards,uri dimant sql server mvp, http://sqlblog.com/blogs/uri_dimant/ ms sql optimization: ms sql development , optimization ms sql consulting: large scale of database , data cleansing remote dba services: improves ms sql database performance sql server integration services: business intelligence SQL Server  >  ...
Read more