How to improve databse queries practicing

You should first learn the basics of SQL Server query - https://www.w3schools.com/sql/

Here for your practice all the schema and some test data are availabe. You can also learn there ASP.Net apart from that you can download CRUD application in C# and ASP.Net using sql server from C# Corner. Look into that and try to understand the design, query, code with different perspective. You cand change anything in your downloaded code for your practices. Once you will change and definitely you can see different results and hence you can compare and get confident.

 

You can also buy/download some books or pdf from C# corner books section here https://www.c-sharpcorner.com/ebooks/

 

You can check with your experience level and download that comfortable level book as all level books are posted there. You can visit MSDN sql server documentation also to learn sql server queries.

 

You can watch Youtube videos, MVA academy videos, Pluralsight videso, etc. online with free. Some of the best websites available for SQL Server articles, blog and forums are as listed below:

 

https://www.c-sharpcorner.com/technologies/sql-server

https://www.mssqltips.com/

https://blog.sqlauthority.com/

https://docs.microsoft.com/en-us/sql/sql-server/sql-server-technical-documentation?view=sql-server-2017

https://stackoverflow.com/questions/tagged/sql-server

 

All these above suggestions are not required to do at once. It takes time and definitely you can learn when you will try practices step by step.

 

Remember always you are not the first fresher all developers even me was in that stage one day. When you get any error you will try to get solution and in this way you will learn. Even sometime in initial stage developers are requested to do some explicit mistakes for learning in your test project.

 

Apart from above you can learn from your recently joined companies already used projects and queries. You should always give some extra time for your learning and practices. It is said in first time job you should not see the salary and company rather than try to learn there as much as possible to learn.

 

Never hesigitate to ask something from your colleagues in case of difficulties. Discussion in early stage is always good. You should always think the logic and the process from customer perspective. Remember software development is not a business itself rather than it is business driven. So rather than your comfort give user experience first priority.

 

You can learn ASP.Net from here.

 

https://www.c-sharpcorner.com/UploadFile/4aae29/complete-crud-operations-in-Asp-Net/

 

Check this below link for database related links.

 

https://www.c-sharpcorner.com/Resources/4395/sql-server-tutorial-for-beginners.aspx

 

Best of luck.