I am currently unemployed and am using my current downtime to get trained in SQL Server . I worked in Excel a great deal in my previous career as a mid level Customer Service Analyst / Data Validator so learning a database wont be as difficult as a total newbie to working with large volumes of data .
I am currently learning SQL 2008R2 as that is the training I have available for me and it breaks everything down from proper syntax for writing clean readable code to the differences with SQL and TSQL so I am pleased with the course material and it also has exercises to reinforce the course material.
I have two concerns one to do with future employment and the other to do with future releases of SQL Server .
A)I am unemployed as stated previously . I am realistic with my career options as my SQL knolwdge will be limited , however in the interest of heading back to the workforce by the Spring of 2014 I have my nose pointed to be a Junior Report Developer / Analyst . I would feel very comfortable generating reports for Excel Or Access using SSRS as I have had to show spreadsheet presentations i.e. graphs, Pivot Charts in past jobs . So my question is can I jump directly into learning SSRS AFTER I have completed my SQL and TSQL training (this includes such topics as Inner and Outer Joins, Writing Aggregate Queries ,SubQueris ,CTE's , Design Patterns , Indexes , Triggers ,Geospatial Data ,CLOBs and BLOBs ,Creating Tables ) . Is SSIS necerrary to get position as a Report Writer ? I am anxious about returning to work so if I could would like to only study things I need now . If however it is necessary to learn SSIS then I wont take any shortcuts as I want to be a well rounded as possible since my knowledge wont be very advanced . Also is SSRS necessary for the same reason ?
B). With SQL2014 coming out is my training on SSRS 2008R2 in any way obsolete ? I do see some jobs still asking for 2005 users (I live in the North East , NYC to be exact) .. Will I still be able to gain employment at a junior level even if the role only needs SQL but may not necessarily be a Report Developer position per say . Also what jobs should I be looking for coming out ? A vague inquiry I know but if someone could ballpark it .