Connecting Angular to an SQL database
Learning Angular is ridiculously difficult. Not because Angular is difficult, but because you need to teach yourself a gazillion unrelated technologies before you can create a real Angular application
Join the DZone community and get the full member experience.Join For Free
Creating a "real" Angular app is ridiculously difficult, because it requires you to learn some sort of backend technology, SQL, HTTP and a gazillion other unrelated technologies. This implies that before you can create as much as a single (useful) Hello World app in Angular, you've spent the larger parts of a decade to learn unrelated technologies required to know before you can connect your Angular app to a database, and actually do something useful with your app. If you want a .Net backend for instance, you'll need to know the following.
- .Net class hierarchy
- Basic OOP
- Basic design pattern theory
- SQL if you're using an SQL database
- Some database theory
- Etc, etc, etc
Simply the number of classes in .Net you'll need to study, understand, and consume, rapidly becomes mind blowing. This is before you even start out with the Angular parts of your app. Sure you could create a pure Angular application, and simply ignore the server altogether - But if you do, your app is little more than fancy animations and beautifully constructed buttons, coupled inside animating navbars and tabs. If you want to create a "real" Angular app though, you'll need some sort of backend, which of course implies spending 85% of your time, on things not even remotely related to Angular in any ways what so ever. Having a real backend as you learn Angular, is also for obvious reasons a million times funnier as you start out learning.
I just had an email from a guy wanting to learn Angular frontend development, and he asked me for help. So I gave him a free license of Magic, and created an instructional video about how to get started with Angular using Magic. This implies he now has a million less things to worry about, yet still can create a real Angular app, connect it to an SQL database backend - And as he proceeds up to the point where he's good enough to maybe get a job as a frontend developer, he can use a real app as a part of his resume, and even host it for as little as $5 per month if he wants to send it to potential employers wanting to hire him. This of course would give him a huge advantage in a job interview, because the interviewer can see a real app, connected to a real backend, with an SQL database backing his Angular app, resulting in that his resume pops out compared to other people's resume.
If you came to me applying for a job as a frontend Angular developer, and all you could show for was fancy animations, navbars, and tabs - I'd probably choose somebody else. If you could show me a real Angular app, invoking a real backend, persisting data into some sort of SQL database though - I'd give your resume a second chance. However, creating a real Angular app, with a real backend, is at least 10 times as hard as creating a pure Angular app - Unless you use Magic of course. See how I created the backend in the video below.
If you're a student of Angular, and/or React for that matter, and you recognise the problem I'm describing above - I might give you a free license too, assuming you are able to convince me that you actually are a student, and you ask politely, and explain to me why you want to learn Angular software development. My reasons are obvious; There's a gazillion unemployed people on the planet today because of Covid19, looking for a different type of job, wanting to learn a craft that gives them more job security - And I've had a lot of uncertainty myself in my life, so I can empathise with your suffering. If you're dedicated enough to wanting to do this, you'll find my email address all by yourself. Hence, step 1 is as follows ...
Wax on, wax off!
Opinions expressed by DZone contributors are their own.