Resources for New SQL Server Developers

Resources for New SQL Server Developers

About every month or so a new group of students tour the Pragmatic Works office. They’re a part of the Pragmatic Works foundation, a non profit organization created to help unemployed, underemployed, and returning veterans gain the skills needed to gain access into the IT industry as database developers. I always enjoy giving tips and tricks, and recommendations to students on skills they need, areas to focus on, and how to think like a developer.  However, one thing has always bothered me. I’m never able to keep in touch with everybody, so the amount guidance I can provide these students is limited to one week.

That’s my inspiration for this posting. I want to provide a honeypot of resources for ambitious young developers to begin and continue their education on the SQL Server platform. This post is going to be an on-going work in progress so I encourage you to contribute in the comments section with any thoughts or new resources that you think should be added to this list. Remember, this is geared toward novice developers.

Software

 SQL Server 2012 Express Edition (free download of SQL Server)

Database Fundamentals

Videos

  1. SQL Server: Ground Zero – by Jorge Segarra
  2. Database Fundamentals – by Microsoft Virtual Academy

Recommended Reading

  1. Microsoft SQL Server: Step by Step – by Patrick LeBlanc

T-SQL Programming

Videos

  1. Querying Microsoft SQL Server 2012 Databases Jump Start by Microsoft Virtual Academy

Recommended Reading

  1. Beginning T-SQL 2012 by Kathi Kellenberger and Scott Shaw
  2. Microsoft SQL Server 2012 T-SQL Fundamentals by Itzik Ben-Gan
  3. Querying Microsoft SQL Server 2012 (Exam 70-461 Training Kit) by Itzik Ben Gan

SQL Server Database Administration

 Videos

  1. Administering Microsoft SQL Server 2012 Jump Start by Microsoft Virtual Academy
  2. SQL Server 2008 R2 for the DBA by Patrick LeBlanc

Recommended Reading

  1. SQL Server DBA Training Plan – (Free ebook) by Brent Ozar
  2. Beginning SQL Server 2012 Administration by Robert Walters and Grant Fitchley
  3. The Accidental DBA Blog Series – by various authors, via SQLSkills.com

SQL Server Business Intelligence

 Videos

  1. Back to Basics: SQL Server Integration Services (SSIS) 2012 for Beginners by Bradley Schacht
  2. Getting Started with SQL Server Reporting Services(SSRS) 2012 by Chris Albrektson
  3. Introduction to SQL Server Analysis Services (SSAS) by Devin Knight
  4. Implementing a Data Warehouse with SQL Server Jump Start by Microsoft Virtual Acedemy

Recommended Reading

  1. Knight’s Microsoft Business Intelligence 24-hour Trainer by Brian Knight, Devin Knight, Adam Jorgensen, Patrick LeBlanc and Mike Davis
  2. Knight’s 24 – Hour Trainer: Microsoft SQL Server 2008 Integration Services by Brian Knight, Devin Knight, and Mike Davis

 

Educational Sites

 
Comments

This is a great collection of information! Thanks a lot!
However, I have difficulity to read it due to the grayish color on the article. If the color can be changed to darker color that will be greatly appreciated. Thanks again!

What do you think of the sqlskills.com offering:
http://www.sqlskills.com/help/accidental-dba/

Thanks for for comment, Greek49!
The Accidental DBA blog series looks great, although I’ve only had time to skim a few sectoins. I’m adding it to the DBA Recommended Reading section.

thanks for sharing information,nice article
MSBI Training In Hyderabad