Avatar of Alaska Cowboy
Alaska Cowboy
Flag for United States of America asked on

SSIS Certification

I'm in a company that uses SSIS, but I am an experienced oracle developer, and would like to transition.

I've researched Microsoft certification and found this:
http://www.microsoft.com/learning/en/us/certification/cert-sql-server-business-intelligence.aspx

466 (Implementing Data Models and Reports with Microsoft SQL Server 2012) looks like the starting point because the audience is BI developer.

The company also has Informatica but SSIS is taking over.

The starting point though seems like MCSA, which is three courses,
http://www.microsoft.com/learning/en/us/certification/cert-sql-server-MCSA.aspx

so my basic goal is to learn SSIS so I can find a slot in my company here but certifications are good in the long run.

I got certified in Sql Server a long time ago, so I'm familiar with some key differences in oracle and sql server, at least from a layman's perspective.

Can I download Sql Server (2012 ?) at home to get started ?

Just looking for some basic advice.
Microsoft SQL ServerSSRSSSAS

Avatar of undefined
Last Comment
Alaska Cowboy

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Jason Yousef

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
SOLUTION
Kelvin Sparks

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Jason Yousef

Jim is right, the 2008 exam is combined of the SSRS/SSAS/SSIS, so I'll echo him on going to the 2012 straight, although it's hard, I've blogged about the beta exam, as I had a free voucher to take that exam..
Alaska Cowboy

ASKER
huslayer, thank you, just what I was looking for

kelvinsparks, excellent too, thanks.

jimhorn, thanks, yes, just looking for a niche at SSIS

huslayer, ok, got it.

thanks all, just what I was looking for.
Alaska Cowboy

ASKER
and what about 461, 462, 463 ?

http://www.microsoft.com/learning/en/us/certification/cert-sql-server-MCSA.aspx

461 = Querying Microsoft SQL Server 2012
462 = Administering Microsoft SQL Server 2012 Databases
463 = Implementing a Data Warehouse with Microsoft SQL Server 2012

I don't do Oracle DBA work so I'm inclined not to do Sql Server DBA work, although I realize tings are not quite as difficult in Sql Server as opposed to Oracle.
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Alaska Cowboy

ASKER
thanks for the tips !