SSIS Certification

Alaska Cowboy
Alaska Cowboy used Ask the Experts™
on
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.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Sr. BI  Developer
Commented:
Hi,
You might need to start by taking the SQL 2008 certifications and upgrade later as the path will be shorter and the 2012 has not been released yet, they announced it'll be released in June.

So you might be looking at http://www.microsoft.com/learning/en/us/exam.aspx?id=70-448 as your start point.

And yes, you can download the sql 2012 evaluation, or buy the developer edition to learn non for as low as $50.

download
http://technet.microsoft.com/en-us/evalcenter/hh225126.aspx

buy
http://www.amazon.com/SQL-Server-Developer-Edition-2012/dp/B007RFXQAM

Let me know if you have any other questions...
You can download SQL Server Express for free - you need the advanced tools option with the Management Studio etc...

I don't know how much BI that gives you however. The next best option is to join as a NS partner and pass the 10 minute test for the Action Pack - which you then buy a year long subscription. Thgis will provide you with access to a heap of software including a full version of SQL Server. If your firm offers you a MSDN license, you may also get it through that, and I understand you can download a copy for home use.


Kelvin
Jim HornSQL Server Data Dude
Most Valuable Expert 2013
Author of the Year 2015
Commented:
>Can I download Sql Server (2012 ?) at home to get started ?
Both Amazon and Microsoft Store have SQL Server 2012 Developer Edition available for around $50-60, and contains the same BI stack as Enterprise but is licensed only for a developer, meaning you can't put it in production.

>so my basic goal is to learn SSIS so I can find a slot in my company here
My hunch is that you'd have to learn T-SQL first, which would be the 461 exam, before taking a shot at the BI exams.   If you'd like to go straight to the 466 exam to carve out an SSIS niche, there's nothing stopping you.

The 2008 exam is combined SSIS-SSRS-SSAS, so unless you know all three I'd go straight to the 2012 exam.

Good luck.
Jim
11/26 Forrester Webinar: Savings for Enterprise

How can your organization benefit from savings just by replacing your legacy backup solutions with Acronis' #CyberProtection? Join Forrester's Joe Branca and Ryan Davis from Acronis live as they explain how you can too.

Jason YousefSr. BI  Developer
Commented:
Kelvin,

The free express edition doesn't give you the option to use SSIS  !! there's also a free express with advanced features, but still no SSIS !!

Look at the several editions here: http://msdn.microsoft.com/en-us/library/cc645993.aspx

@williampeck, you might need to look at that post for how to build a virtual machine...

http://www.real-sql-guy.com/2012/03/building-for-free-virtual-server-for.html
Jason YousefSr. BI  Developer

Commented:
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..

Author

Commented:
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.

Author

Commented:
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.
Jim HornSQL Server Data Dude
Most Valuable Expert 2013
Author of the Year 2015
Commented:
461 is T-SQL development, so only a small percentage of it would be DBA-related
462 All DBA
463 Data Warehouse development, probably a smaller percentage than 461 would be DBA-related
Jason YousefSr. BI  Developer
Commented:
Well that's why I suggested the shorter path using 2008. and also that's why Jim suggested learning the T-SQL, as you'll need to get the foundation in the SA track, then go to the SE track to be MCSE in BI.

check that link http://www.microsoft.com/learning/en/us/certification/cert-sql-server-business-intelligence.aspx

Microsoft has re-designed their sql 2012 completely, you may watch that video to get the idea

http://www.brentozar.com/archive/2012/04/sql-server-certification-changes-video/

Author

Commented:
thanks for the tips !

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial