Many companies have lean IT organizations and find themselves with five, ten, or even twenty production SQL Servers and no dedicated Database Administrator to care for them. Instead, they rely on other IT Professionals to ensure the database servers are performant. We’ve worked with many companies where SysAdmins, Application Developers, and Network Administrators have been regularly tasked to perform double duty, taking care of their primary responsibilities while also responding to SQL Server issues. Those IT professionals are looking to learn enough SQL Server to help them accomplish what they need to do.

Free SQL Server Training Resources

Often these IT Professionals, sometimes called “Accidental DBAs,” do an admirable job, even with little formal SQL Server training. Fortunately, there are a lot of great resources available online for the “Accidental DBA.” Here are a few free SQL Server learning resources worth checking out:

1. Microsoft Resources and Labs

Microsoft has put together quite a few learning opportunities available to the public for free. These are in several different formats so you can pick the one you’re most comfortable with. Here are a few you may want to check out:

1. Microsoft SQL Server 2019 (CTP 3.2) Lab. In this self-paced lab, you’ll learn how to use SQL Server 2019 to solve business challenges.
2. Microsoft AI School. Artificial Intelligence is a hot topic in today’s business environment. In Microsoft AI School, you’ll “find the information, learning materials, and resources you need to start building intelligence into your solutions.”
3. SQL Server Tutorials. More than just Online Documentation, SQL Docs is a great place for detailed information about how to use SQL Server. It includes tutorials that will step you through learning the database technology.
4. EdX. Founded by Harvard and MIT, EdX is a place where education is freely available to everyone online. Microsoft has partnered with EdX to provide free courses online for SQL Server. Here are a few:
   • Querying Data with Transact-SQL.
   • Developing SQL Databases.
   • Analyzing and Visualizing Data with SQL Server Reporting Services.
5. Channel 9. Microsoft produces a lot of video content for SQL Server and other products. They make it available online via Channel 9.

2. YouTube Channels

YouTube can be a great resource for learning just about anything. From changing a tire to playing the ukulele, you can find it on YouTube. It should come as no surprise that there are a lot of great SQL Server training videos available as well. Of course, since just about anyone can create a video, you’ll want to be careful. Not everyone is the expert that they portend to be online. Do your own research. Here are a couple of places to start.

1. SQL Server YouTube Search. A list of SQL Server-related videos.
2. Microsoft SQL Server YouTube Channel. Microsoft SQL Server home on YouTube.

3. SQLSaturdays and Virtual Groups

For many years, I was on the board of Directors for a global user group called PASS. The organization is committed to providing learning opportunities for professionals around the globe and to helping the community to better connect with one another. There are a couple of ways PASS helps with this.

1. SQLSaturdays are a series of free one-day training events in cities around the world. These events, as the name suggests are held on Saturdays and are free to attend. They typically have some of the best and most well-known SQL Server experts around. Look for a SQLSaturday near you and plan to attend. You’ll see some great content and better yet make some incredible connections.
2. Virtual Groups. Through live webinars, PASS Virtual Groups offer top-notch training no matter where you happen to be. Check out a list of upcoming webinars.

Summary

With a new release every 18 to 24 months, keeping up with the latest changes can be a challenge. Hopefully, these free resources will help. We also have an ever growing SQL Script Library available to help get you started with some of the more common tasks.

Want to work with The Sero Group?

Want to learn more about how SERO Group helps organizations take the guesswork out of managing their SQL Servers? It’s easy and there is no obligation. 

Schedule a call with us to get started.