Translate

Saturday, 29 May 2021

.NET 5 & .NET Core 3.1 Web API & Entity Framework Jumpstart

 The .NET framework is getting better and better and more important in the web development world nowadays.

Almost every request I get for new web development projects is asking for knowledge in .NET, including Web API and Entity Framework Core.

So, knowing the fundamentals of back end web development with .NET can be highly beneficial to your career. And that’s where this course comes in.

In a short period of time, you will learn how to set up a Web API, make restful calls to this Web API and also save data persistently with Entity Framework CoreCode-First Migration, a SQL Server & SQLite database, and all three types of relationships in this database.

We will get right to the point, you will see every single step of writing the necessary code and by the end of this course, you will have what it takes to say ‘yes’ to all the .NET project requests from any recruiter.

The only tool you need in the beginning is Visual Studio Code which is available for free.

We will use Visual Studio Code for our implementations and make calls to the Web API with the help of Swagger UI - an interface that lets you consume the API out-of-the-box, thanks to the latest version of the .NET framework.

Later, we will also utilize SQL Server Express and the SQL Server Management Studio to manage our database. These are also available for free.

Later, we will utilize the free SQL Server Express with SQL Server Management Studio to manage our database. We will also have a quick look at SQLite, so that you know how to use any database you want.

The back end application we’re going to build is a small text-based role-playing game where different users can register (we’re going to use JSON web tokens for authentication) and create their own characters like a mage or a knight, add some skills and a weapon, and also let the characters fight against each other to see who is the best of them all.


What You Will Learn

Introduction

  • Create your first Web API call in less than 10 minutes

  • Initialize a Git repository for your source control

Web API

  • The Model-View-Controller (MVC) pattern

  • Create models and controllers

  • Attribute routing (with parameters)

  • The HTTP request methods GET, POST, PUT & DELETE

  • Best practices for your Web API like a ServiceResponse class and Data-Transfer-Objects (DTOs)

  • Map your models with AutoMapper

Entity Framework Core

  • Object-Relational-Mapping

  • Code-First Migration

  • SQL Server Express

  • How to use a DataContext and a proper ConnectionString

  • All previous HTTP requests with Entity Framework Core to save your data in a SQL Server & SQLite database

  • Data Seeding: Insert data with a migration programmatically

Authentication

  • Token Authentication with JSON Web Tokens

  • Claims

  • Secure controllers with the Authorize attribute

  • Add roles to the users

Advanced Relationships with Entity Framework Core

  • One-to-one relationships

  • One-to-many relationships

  • Many-to-many relationships

  • Include entities with Entity Framework Core

  • Get the proper relations between entities

More Than Just CRUD

  • Start automatic fights

  • Filter and order RPG characters by their highscore


Your Instructor

My name is Patrick and I will be your instructor for this course. I’m a web developer for over a decade now, I have worked for big corporations and small teams, as an employee and a contractor and I just love to see the way Microsoft is going with .NET and how important it gets day by day.

To this date, I was able to run seven courses on web development here on Udemy about ASP.NET, Blazor, single-page applications, Angular, and DevOps, with a total of over 50.000 unique students and more than 5.000 reviews.

If you have any questions, feel free to connect.


And if you still have any doubts, you have a 30-day money-back guarantee, no questions asked.

So, I hope you’re ready for your new skills and your new projects! ;)

I’m looking forward to seeing you in the course!


Course image: practicum/Shutterstock


Who this course is for:

  • Students who want to build professional .NET 5 or .NET Core web development skills.
Under $10 Udemy #deals on #udemy #course FOR

NET 5 & .NET Core 3.1 Web API & Entity #Framework Jumpstart
Build the back-end of a .NET 5 or .NET Core. 3.1 web application with Web API, Entity Framework & #SQL Server in no time!

#coupon link

https://www.udemy.com/course/net-core-31-web-api-entity-framework-core-jumpstart/?referralCode=CA390CA392FF8B003518

Tuesday, 18 May 2021

Learn SQL Concepts with simple examples SQL Basic and Intermediate Level

 SQL is being used quite widely in IT industry. Many front end applications also use SQL as Microsoft SQL Server, Oracle or other databases are being used as back end in many organisations. Most of SQL is same except for some differences for different databases. Understanding basic concepts of SQL to write SQL queries is quite helpful to build careers in quite a lot of areas of IT. SQL is being used in Data Science, Business intelligence, Big data and many other areas. Not only SQL Developer but a business analyst and even application developer needs the knowledge of SQL.

This course helps you in building your careers in the SQL related fields. In this course you will learn important concepts of SQL. This course deals with about 30 topics of SQL with total time of about 6-1/2 hours. The course is divided into 2 sections. Section 1 covers the basic topics of SQL and section 2 covers the intermediate level topics of SQL. After completing this course, you’ll get good understanding of almost all the topics of SQL that are useful in most situations. You can have a good foundation in SQL after completing this course that helps in building your careers.

Who this course is for:

  • Students who are aspiring for a career in SQL, Business Intelligence, Data Science or whoever uses SQL as back end.


#Learn #SQL Concepts with simple examples
SQL Basic and Intermediate Level
#couponlink

https://www.udemy.com/course/learn-sql-concepts-with-simple-examples/?referralCode=FDBBA80DF656F227DA3E