Home
Join

7 Replies

  • While some of the Microsoft certifications are obsolete now, the training materials for the older SQL Server certs can be useful. The "usual" online training resources will have those.

    Are you looking for stuff like "intro DBA"-type materials?  Or are you looking to learn how to write SQL itself?

    EDIT: let me ask in a different way.  How does supporting databases fit into your current role?  What is it that you would like to start doing as part of your role?

    Was this post helpful? thumb_up thumb_down
  • Not a crash course, but from a non-dba angle, its a good starting point. Check out Ola's scripts, understand how and why to implement them, figure out what they do. They will go a long way in understanding how to Administer SQL from a non-DBA type angle. 

    https://ola.hallengren.com/ 

    Was this post helpful? thumb_up thumb_down
  • Not sure if the Learn section on here has anything for you but always worth a look.

    Was this post helpful? thumb_up thumb_down
  • Code Academy's course will get you started. 

    I've also used W3 for a  few things. 

    Spice (1) flagReport
    Was this post helpful? thumb_up thumb_down
  • Eric7615 wrote:

    Not sure if the Learn section on here has anything for you but always worth a look.

    Content for SQL here on SW Learn is pretty sparse, and not useful for a beginner.

    Was this post helpful? thumb_up thumb_down
  • Build a home lab and try installing and running various SQL Servers deployments like standalone, failover cluster instances, or availability groups https://www.hyper-v.io/can-sql-server. The installation wizard and configuration already provide a lot of information to better understand how that beast works. Try running an application that uses SQL Server (free Veeam B&R is a good option https://www.veeam.com/virtual-machine-backup-solution-free.html) to see how databases and tables are created and used and how to properly configure a SQL server connection. You may also use GUI tools for SQL Server like built-in Management Studio and/or Navicat https://navicat.com/en/.
    Was this post helpful? thumb_up thumb_down
  • You could also go to Udemy courses and see if any of the SQL classes fits your needs. Be sure to look at the rating and instructor before buying their class.  

    Was this post helpful? thumb_up thumb_down

Read these next...