I'm diving into backend development for web applications and could use some guidance on how to get started. I've been a game developer for nearly 5 years, but the job market has not been great—I'm often faced with low pay or high stress. My main programming language is C#, which I really enjoy. I've also dabbled in web technologies like HTML, CSS, and JavaScript. Right now, I'm particularly interested in learning SQL or database management first, but I'm wondering if there's a specific path I should follow initially. Any tips would be appreciated!
5 Answers
Since you're already experienced with C#, I suggest sticking with MS .NET. It's fairly straightforward and allows you to build APIs or full-stack applications, making it a perfect fit for your skills.
I recommend starting by learning how to model a database using ERMs (Entity Relationship Models). After that, check out SQL commands on w3schools. Once you feel comfortable, try setting up a test database with DBeaver. The three normalization rules are crucial, while views and stored procedures can be learned later.
Could you specify what you mean by backend development? Are you looking into web, machine learning, or something else? I'm exploring machine learning and have found some backend components within that space. There seems to be a current shortage of talent in this area according to online sources.
Isn't it possible for anyone to code in C# nowadays using LLMs? What sets apart a knowledgeable developer?
With your 5 years of experience in C#, you have a solid advantage. Instead of switching to a new language like Node or Python, just jump right into ASP.NET Core. Companies pay top dollar for skilled C# backend developers, and the work-life balance is typically much better than in game development. You should consider creating a simple REST API with ASP.NET Core and using Entity Framework Core to manage your SQL database. You've already mastered the language; now it's about learning the web framework.

What exactly are ERMs?