Real rest Web API using C#, SQL, Dapper, Json.

Real rest Web API using C#, SQL, Dapper, Json., available at $49.99, has an average rating of 4, with 47 lectures, based on 14 reviews, and has 102 subscribers.

You will learn about Build a database and stored procedures in Sql management studio. Build a full Web API application with .net core using Dapper , Json & C#. Build an example to sell used products. This application will contain all actions you need like register a user, reset the password, verify your email, control you selling etc. After this course you will be able to build a real Web API application. This course is ideal for individuals who are For student who wants to build a real ASP. NET CORE Web API in a simple, quick and professional way. or For students who know that dapper is more faster than entity framework. or For students who know that learning in workshops and full featured examples is more efficient than using a small examples for every single concept. It is particularly useful for For student who wants to build a real ASP. NET CORE Web API in a simple, quick and professional way. or For students who know that dapper is more faster than entity framework. or For students who know that learning in workshops and full featured examples is more efficient than using a small examples for every single concept.

Enroll now: Real rest Web API using C#, SQL, Dapper, Json.

Summary

Title: Real rest Web API using C#, SQL, Dapper, Json.

Price: $49.99

Average Rating: 4

Number of Lectures: 47

Number of Published Lectures: 47

Number of Curriculum Items: 47

Number of Published Curriculum Objects: 47

Original Price: $89.99

Quality Status: approved

Status: Live

What You Will Learn

Build a database and stored procedures in Sql management studio.

Build a full Web API application with .net core using Dapper , Json & C#.

Build an example to sell used products.

This application will contain all actions you need like register a user, reset the password, verify your email, control you selling etc.

After this course you will be able to build a real Web API application.

Who Should Attend

For student who wants to build a real ASP. NET CORE Web API in a simple, quick and professional way.

For students who know that dapper is more faster than entity framework.

For students who know that learning in workshops and full featured examples is more efficient than using a small examples for every single concept.

Target Audiences

For student who wants to build a real ASP. NET CORE Web API in a simple, quick and professional way.

For students who know that dapper is more faster than entity framework.

For students who know that learning in workshops and full featured examples is more efficient than using a small examples for every single concept.

Course Tools

SQL Server Management Studio.

Visual Studio.

Postman.

Advantages of this course :

– Learning in real app, where we design an API that meets business objectives.

Such way is considered to be a highly important learning process. Besides, it equips you with a knowledge that can be easily extended and integrated.

– Building Database first, this approach give the developer a lot of advantages like protect you from losing data, and easier to write SQL commands.

– Using C#, which is an object-oriented, component-oriented programming language that supported by Microsoft, and the best news that it will be immediately familiar to C, C++, Java, and JavaScript programmers.

And the most famous advantage of knowing C# is the expanded wideness to make mobile applications, web applications, games and more.

– Using Asp.Net Core, a free and open-source web framework developed by Microsoft. This framework allows us to include packages in our application which make it faster.

– Using Dapper, that is a tool which maps your database directly with C# objects. Fast in performance with fewer line of code.

– Using Json syntax, which is fast and readable way to exchange data between the server and our application, it’s actually a text that written with JavaScript object notation..

Course Curriculum

Chapter 1: Introduction

Lecture 1: Welcome to my course.

Chapter 2: Creating the database

Lecture 1: Creating the database and tables in SQL Server Management Studio – Part 1.

Lecture 2: Creating the database and tables in SQL Server Management Studio – Part 2.

Lecture 3: Creating the database and tables in SQL Server Management Studio – Part 3.

Chapter 3: Setup the project in Visual Studio

Lecture 1: Create the Asp.Net Core Web API project in Visual Studio.

Lecture 2: Add Dapper and SqlClient packages to the project.

Lecture 3: Add the connection string to the project.

Chapter 4: Register a new User

Lecture 1: Add AccountsController to the Project.

Lecture 2: RegisterUser stored procedure in SQL Server.

Lecture 3: RegisterUser models.

Lecture 4: RegisterUser action.

Lecture 5: RegisterUser Test.

Lecture 6: Hash password

Lecture 7: Hashing the Password -Test our code

Chapter 5: Send email to user to verify the registered account.

Lecture 1: Send verification email to the user.

Lecture 2: Test sending an email verification to the user.

Lecture 3: Verify the users email using the generated code (In SQL Server).

Lecture 4: Verify the users email using the generated code (In Visual Studio).

Chapter 6: Sign In

Lecture 1: Stored procedure to sign in the user.

Lecture 2: Sign-In action in Visual Studio.

Lecture 3: How to start documentation in Postman.

Chapter 7: Reset the password and get a new verification code.

Lecture 1: Update and get a new generated code on email.(Stored Procedure)

Lecture 2: Get the generated code (Visual Studio).

Lecture 3: Reset the Password.

Chapter 8: Add, Update and get users contact details.

Lecture 1: Add & update users contact details.

Lecture 2: Get the users contact details.

Lecture 3: Upload the image.

Lecture 4: Add & update users image

Lecture 5: Get users image.

Chapter 9: Fix some issues inside our application.

Lecture 1: Fix an issue – Delete unnecessary images from image folder.

Lecture 2: Fix an issue- Delete unverified user for more than 3 days.

Chapter 10: Add and Update users address

Lecture 1: Add & update users address.

Lecture 2: Get users address.

Chapter 11: Working with products.

Lecture 1: Add some categories to the database.

Lecture 2: Add ItemsController.

Lecture 3: Get list of categories.

Lecture 4: Add products to the items table.

Lecture 5: Update products.

Lecture 6: Change items status.

Lecture 7: Change announcements level

Lecture 8: Upload and add images to the items.

Lecture 9: Update Item Images.

Lecture 10: Get item images

Lecture 11: Select an image from items images.

Lecture 12: Delete an image from items images

Lecture 13: Delete Items from Items table.

Lecture 14: Homework..

Instructors

Adam Eldeek
Mobile app developer

Rating Distribution

1 stars: 2 votes

2 stars: 1 votes

3 stars: 1 votes

4 stars: 6 votes

5 stars: 4 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!