Learn AspNet Core And SQL By Writing Todo API

Learn how to write an API as a beginner with step-by-step instructions using AspNet Core, SQL Server and T-SQL.

So the first question you will have is why even learn about ASPNET Core? That is a very good question. The answer is that it allows you to build flexible and reliable APIs and web applications. In our course we are going to laser focus on how to build APIs.

What you’ll learn

  • Basics of back-end development with ASPNET Core.
  • Building a simple API then taking the concepts and being able to use it for complex APIs.
  • SQL Server and T-SQL and how to create database objects for ASPNET Core API.
  • Using Dapper with ASPNET Core API and ASPNET Core Identity.
  • Using ASPNET Core Identity For registration and login process.

Course Content

  • Introduction –> 2 lectures • 11min.
  • Setup –> 3 lectures • 9min.
  • Outline All Pieces –> 2 lectures • 8min.
  • Build SQL Objects –> 11 lectures • 1hr 4min.
  • Build Models –> 10 lectures • 46min.
  • Build Repository –> 6 lectures • 1hr 3min.
  • Build Services –> 2 lectures • 17min.
  • Build Identity –> 1 lecture • 19min.
  • Build Web –> 5 lectures • 1hr 8min.
  • Testing –> 3 lectures • 23min.

Learn AspNet Core And SQL By Writing Todo API

Requirements

  • Basics of C# and T-SQL are preferable but not necessary.
  • Windows machine that could handle Visual Studio 2019+ and SQL Server 2019+.

So the first question you will have is why even learn about ASPNET Core? That is a very good question. The answer is that it allows you to build flexible and reliable APIs and web applications. In our course we are going to laser focus on how to build APIs.

If one does not have reliable API then no matter how great the front-end is designed and fancy it is the user experience is going to be negative. This in turn will push a lot of people away from your product or the one you are building for a company.

The API is the gateway to your data so it needs to be secure, performant and reliable. ASPNET Core has all of the tools to make this happen starting from handling simple requests to allowing users complete registration and login.

The main idea of this course is not to build a very complex API, instead I chose something pretty simple – ToDo list. Everybody knows how it works and there is no confusion there. This allows me to focus more on the mechanics of how ASPNET Core works in order to build APIs.

We take it step-by-step and go over everything that we need to build and then we go ahead and build it. I am there with you every step of the way and if you have any questions the Q&A section is always ready to help you out.

Now a word about Entity Framework. Just in case you are new to the Entity Framework – it is an ORM that help you interact with the database. Helps you read, write and delete and more so you you don’t have to take care of it manually. The selling point of it is that it writes the “database code” automatically.

A very unique thing about this course is that we don’t use Entity Framework like every other course but instead we are using Dapper. The reason is that using Entity Framework is pretty simple if there is no team. However, in the long term it is known to have performance issues and it is not as flexible, also when there is a team in place it can become very tricky to navigate which migrations need to be run properly.

Dapper is made by StackOverflow team and is widely used however Microsoft made it pretty difficult integrating with ASPNET Core if one is not using Entity Framework. The goal of this course is to make the process simpler and show you exactly how to integrate Dapper with ASPNET Core. We also write our own SQL which I show you is not as scary as it seems.

After we are finish with the course you will be able to make your own APIs with ASPNET Core – all the way from handling simple requests to performing registration and login process.

Enroll now and let’s start learning ASPNET Core together!