There is no fast way. Just lots and lots of practice and learning. To learn T-SQL, I strongly recommend Itzik Ben Gan's book T-SQL Fundamentals. That will give a very good basis in how T-SQL works within SQL Server. After that, it really depends on what you need to do, but it's just lots of work.
Aw man, get ready to roll up those sleeves and put in some work. The fastest way is through some serious sweating!!! Two scenarios: A - No job in SQL server related stuff? 1)Pick a project that is fun for you that you would like to solve with a database and some tsql code. 2) Read Itzik Ben Gan books and Pinal Dave books 3) Learn and master these fundamentals (backups to local server and network location, flat file inserts into databases, scripting tables and scripting jobs, ETL type stored procedures) This will give you a crash practice in some very common scripting scenarios that involve many different components so you get exposure to many things at once. 4) Search for Itzik Ben Gan TSQL challenges and answers and study those. B - Have a job as DBA but need to learn Dev? 1) Read Itzik Ben Gan books 2) Open up stored procedures or any code database developers have done and try to decipher what is going on. Try to recreate some of them on your own in a dev box. 3)Talk to your developers and see if they will want to mentor you or include you in some of their projects. 4) If you have some SSIS packages floating around that you have access to, try to recreate the functionality of those tasks with t-sql code. Forget about practicality the idea is simply to learn how to do these things. This will force your hand at development and speed up your training! Again remember to have fun! Those are the two fastest ways I can think of to learn database development. Hope you have a ton of fun learning.
Hello @dtengani, Here are my suggestions, because I am still new to this area, I believe you can benefits from my suggestions! 1. PRACTICE and MORE PRACTICE. Reading books and article alone will not further your skills, because if you don’t put it to use, your mind forgets it. 2. Run real life scenarios. Start with simple things and then work your way to more complex code. 3. Get a mentor or take hands-on classes. I can’t tell you just how much I’ve learned from talking to other people through networking, taking hands-on classes and seminars, and joining local groups that are involved in PASS, SQLServerCentral, SimpleTalk, etc. Hope that helps!