question

dtengani avatar image
dtengani asked

What is the best and fastest way to master SQL scripting and/or development

Hi Experts, What is the best and fastest way to master SQL scripting and/or development
developmentmaster
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Grant Fritchey avatar image Grant Fritchey ♦♦ commented ·
This site runs by you voting. For each helpful answer below, click on the thumbs up next to those answers. If any one answer lead to a solution, indicate this by clicking on the thumbs up next to that answer.
0 Likes 0 ·
Grant Fritchey avatar image
Grant Fritchey answered
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.
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

dtengani avatar image dtengani commented ·
Thank very much for the insightful advice Much Appreciated
0 Likes 0 ·
Manuelrdgz avatar image
Manuelrdgz answered
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.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

eaglescout avatar image
eaglescout answered
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!
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.