Login

Lost your password?
Don't have an account? Sign Up

Learn Angular 10, Web API & SQL Server by Creating a Web Application from Scratch

Source Code:

Related Tutorials:
——————–
React JS + Python Django + SQLite full-stack app

——————–
React JS + .NET Core Web API + Microsoft SQL full stack app

——————–
.NET Core API + Vue JS + Microsoft SQL full-stack web app

——————–
ASP .NET Core Web API + Microsoft SQL CRUD APIs

——————–
ASP .Net Core Web API + MySQL | CRUD APIs Tutorial

——————–
.NET Core Web API + PostgreSQL | CRUD APIs

——————–
.Net Core Web API + MongoDB CRUD APIs

——————–
Python Django + SQLite | REST APIs

——————–
Python Django + PostgreSQL | REST API Tutorial

——————–
Python Django + MySQL CRUD API Tutorial

——————–
Python Django + MongoDB CRUD API Tutorial

——————–
Python Django + Microsoft SQL Server CRUD API Tutorial

——————–

 Kite is a free AI-powered coding assistant that will help you code faster and smarter. The Kite plugin integrates with all the top editors and IDEs to give you smart completions and documentation while you’re typing. 

Python and Angular app tutorial video:
Learn to create a simple web application from scratch using Angular 10, ASP .NET Web API and Microsoft SQL Server.
1:12 : Install SQL Server and SQL Server Management Studio.
4:26 : Install Visual Studio.
5:50 : Install Visual Studio Code.
6:56 : Install POSTMAN.
7:44 : Install Node JS.
8:43 : Install Angular 10.
10:01 : Create DB and Tables in Microsoft SQL Server.
16:51 : Create .NET Web API Project.
20:38 : Force API to return JSON response only.
22:49 : Enable CORS.
24:52 : Create Models.
27:22 : API for Department Screen : GET.
33:13 : API for Department Screen : POST, PUT and DELETE.
36:48 : APIs for Employee Screen.
43:30 : Upload Photo API.
46:32 : Angular Project Intro.
48:02 : Create Angular 10 Project.
51:38 : Generate Components and Services in the Angular Project.
53:57 : Add Service methods to consume APIs.
59:32 : Routing in Angular.
1:01:42 : Add Bootstrap to our Angular App.
1:02:45 : Navigation Menu using Bootstrap.
1:04:50 : Show Department Screen with Bootstrap Table.
1:08:49 : Modal Pop Up Window using Bootstrap.
1:12:39 : Add and Edit Pop Up Screen for Department.
1:17:24 : Delete Department.
1:19:12 : Show Employee Screen with Bootstrap table.
1:22:31 : Upload Photo, Add and Edit Employee Details Pop Up Screen.
1:31:34 : Custom Sorting and Filtering to our Bootstrap table.
1:36:41 : How to get Publishable files of .NET Web API and Angular.

https://www.educational.guru

22 comments

  1. Thembelani Thomas

    You are amazing. Just one question. If you didn’t want to pick a date with datepicker but instead wanted GETDATE() current date how to you go about it in the web api? It works on sql server but gives an error in the api with that string query.

  2. Trevor Judd

    Thank you for making tutorial videos like this. It’s astounding how the practical skills needed to build applications are neglected at the university level in favor of pure theory. This is excellent content. Please keep doing what you’re doing.

  3. CHITUS?⸻⸻⸻⸻⸻⸻⸻⸻⸻⸻⸻⸻⸻⸻⸻⸻⸻⸻⸻⸻⸻⸻⸻⸻⸻⸻⸻⸻⸻⸻⸻⸻⸻⸻⸻⸻⸻⸻⸻⸻⸻⸻

    If only college & university tutors were as clear and straight forward to the end-product. Then 90% of IT students would end up as great software developers. You made it seem like a walk in the park.

  4. onyango ogolla

    If only college & university tutors were as clear and straight forward to the end-product. Then 90% of IT students would end up as great software developers. You made it seem like a walk in the park.

  5. Ned egt

    I simply use Python Flask (+ extensions) / Brython(Transpiler to JS) / HTML / CSS (W3CSS Framework)
    It’s very easy to learn and you can create all kind of apps in a very short time.
    I know everyone has their preferences, but too many peoples just follow what others
    are doing. JS is very much saturated, so many different flavors. It makes it difficult
    to master the language like one could master C++

  6. Trevor Judd

    I have a request. At 28:20 in this video, you write a database query in raw format and mention that we would need to use secure coding practices to avoid an SQL injection vulnerability. Would you consider doing another video like this one covering secure coding practices during full stack development?

  7. Jordan Ferrazza

    I used slightly quicker things such as using $@ instead of @+ or using the Code terminal instead of the Command Prompt. I would have used a scaffolder to do the modelling but I couldn’t be bothered.

  8. Anjali Gupta

    Very helpful video sir… just one question can I use visual studio 2015 for Web API and some lower version of Angular to build the same application?as the same setup is not available on our development server.

    Thanks in advance
    Awaiting for reply

Leave a Comment

Your email address will not be published. Required fields are marked *

*
*