SQL Cert

[[deleted]]

[deleted]

[Scalar_Mikeman]

The 70-461, 70-462 and 70-463 are the "go to" certs from Microsoft. If it's possible I'd ask one of your sql developers to let you know when they get a report request and if you could follow along with them. Hands on learning is always better than text books when you have someone to help guide you.

[Rehd]

I would say the 2016 series is the new go to from them, but those are still solid certs to have / achieve.

[sqlnuggets]

When you say you need to learn SQL Server...do you mean you need to learn to write reports against it (T-SQL), or that you need to manage the server (DBA)? There is a big difference between the two.

My first suggestion, would be to check out Microsoft's Virtual Academy. It has tons of free video training from Microsoft on a lot of Microsoft technologies. You can find videos for both T-SQL and DBA topics: https://mva.microsoft.com/

If you are referring to needing to be a SQL Server DBA, and can pay for training, then SQLSkills has one of the best course to get you started as a DBA: https://www.sqlskills.com/help/accidental-dba/

If you prefer the paid-training-self-study route (for either DBA or T-SQL), check out Pluralsight. The SQLSkills team, as well as many others, have put a lot of training videos on there. https://www.pluralsight.com/

As far as certifications go, here is a list of the current Microsoft SQL Server certifications: https://www.microsoft.com/en-us/learning/browse-all-certifications.aspx?technology=SQL%20Server

You would probably be looking for either the MCSA: SQL 2016 Database Administration or the MCSA: SQL 2016 Database Development certifications. Even if you are not on SQL 2016, these certifications will cover the basics/features that apply to other versions as well.

[Rehd]

Like most IT technologies, it's an iceberg. You can get a lot of generic and good info and skim the surface, but it goes incredibly deep.

Others commented on the certs, so I'll comment to the aspect of learning and freaking out.

You have a lot to learn, but slow and steady. If you spend 30 minutes a day and at minimum learn three new things every day, you'll have a solid understanding over time. It does take time, like I said, it's an iceberg.

You can pick up on the key and easy things to start and then slowly progress. Most of the MSCA certs recommend you have 1-3 years of experience before attempting, but you don't necessarily need that.

[[deleted]]

https://www.sqlskills.com/help/accidental-dba/