A good grasp of the fundamentals is the starting point for advanced and basic SQL. You can download Itzik Ben-Gan's Logical Query processing poster here The poster helps you think about and write your SQL in a more logical and consistent manner. Also, probably quicker than most training courses that might take a week to get you up to the same level.
By the way, if you want to do a challenge to see if you understand some of the topics covered in SQL Server Master, we have an SQL Server Master challenge. You will be tasked with answering a number of questions about SQL Server and its features. This is a great way to keep track of your progress.
If you are looking to join a company that values and rewards skill, take a look at DataBricks . They have several job openings for people who are very good at SQL Server, and they are looking for people with strong fundamentals in SQL.
So why attend a training course in the first place? The main reason is that SQL is a huge skill set, and it is important for all people working with databases to be good at it. Training is a great way to cement that skill, as well as to strengthen it.
You might be wondering, “What do I learn from training?” This is a great question, and there are plenty of benefits. First and foremost, many of the best database developers today started at the bottom, such as myself. Training is a great way to learn.
Software companies have a huge problem recruiting, and they need to know if employees can write SQL in order to do their jobs. On top of that, today’s database tools can be used to automate repetitive tasks so that developers can focus on more important things. To be a database developer today, you need to be able to do those things.