How to learn how to build sql database models in conjunction with C # (The goal is to write understandable technical specifications for C # programmers)?

Question

SQL

Greetings.
I do analytics, i.e. I write TK. I plan to move to systems analysts. Knowledge, incl. practical, on databases, on sql at me is not present.
I was told that in the office I was going to, C# programmers (development is carried out in this language) know little sql. And that their system analyst will also need to work out in the TOR, describe the issues of interaction with the sql database. So that according to this TK, programmers clearly understand what and where and how.
Can you please tell me any online training courses (preferably in Russian), books, practical online problems and other resources for quick learning? It would be important to get the opinion of a C# programmer as well.

Answer 1

It's hard to advise you in such a situation. I wonder what the office was doing that C # programmers are not familiar with sql, except for games
. the architecture of applications that use RDBs (thick and thin clients, web applications), and then some details regarding the language.
As a C# programmer, I would expect you as an analyst to know the various principles and disciplines of accessing relays. data, namely:
- use of ORM: when possible and necessary), when you want, but not when you can "thick" ORM (Entity Framework, NHibernate), and when - thin (LINQ to SQL); use of code on the side of the database - triggers, stored procedures;
- principles of building data access layers in combination with business logic (patterns and anti-patterns in these situations, for example, Anemic Data Model);
- methods of relational database schema version control - migrations, source control for triggers and stored procedures (if any), schema update policies along with rolling out a new software version;
- formation of test data in test databases;
Now, if you can advise on these issues, then the developers will only have to learn SQL and a specific ORM, if you use it.

Answer 2

Is there still a chance to refuse? According to your confession, a person who does not know him at all is sent as a consultant to a team that does not know sql well. Sounds scary. https://www.codeschool.com/courses/try-sql try to get started here. Well, look on the toaster. You are not the first to ask this question https://toster.ru/search?q=learning+SQL