Contact us

.NET/C# Back end Developer (Duration 12 Weeks)

Build Production-Ready Web APIs and SQL-Driven Backend Applications with .NET Core/C#.

₹9,250

₹10,000

Instructor: Vinay PatelLanguage: English | Hindi | Gujarati

About the course

💻 Course Description : 

Unlock your complete backend career potential. This intensive course transforms you into a high-demand back end developer by mastering ASP.NET Core Web API, C# and MS SQL. Learn to build robust, scalable, and lightning-fast backend services from scratch using modern C# and industry-leading best practices. Go beyond basic CRUD with advanced topics like caching, pagination. Through hands-on lessons and a real-world workshop project, you’ll gain the confidence to design, build, and deploy APIs + databases that power today’s modern web and mobile applications — and step into the role of a job-ready backend developer.

🎯 What you will learn?

  • Build modern, production-grade RESTful APIs using ASP.NET Core Web API and C#
  • Work with MS SQL, Entity Framework, and Dapper for seamless data integration
  • Implement API best practices — caching, pagination, Securing APIs
  • Design secure, maintainable, and high-performance backend architectures
  • Complete a real-world mini workshop project to apply everything you’ve learned
  • Become a job-ready ASP.NET Core Back end Developer

💡 Key Highlights :

  • Learning with real world database examples.
  • Hands-on practical sessions.
  • Flexible batch timings
  • Focused approach (Only 2-3 students per batch). One to one mentoring.
  • Course type : Online | Offline – At Location
  • Learning language options : English | Hindi | Gujarati
  • Course completion certificate
  • The course holds significance importance for the following IT job profiles : 
  1. Backend  Developer
  2. API Developer
  3. Mobile Application Developer

Skills & Tools Covered

  • ASP.NET Core Web API
  • C#
  • SQL
  • SQL Server Management Studio (SSMS)
  • Entity Framework
  • Dapper
  • Visual Studio
  • Deploy Web APIs to IIS
  • Swagger - API Testing UI in VS
  • Postman - API Testing tool

ASP.NET Core Web API Contents

  • Introduction
    • Introduction to ASP.NET Core
    • What is API - History, Why its popular today
    • Tools Overview: Visual Studio 2022, SQL Express, SSMS - SQL Server Management Studio, Postman, Swagger
    • Guidance to set up learner’s machine for required tools
  • C# Essentials (As Needed)
    • Class & Object
    • Class Members: Constructor, Variables, Properties, Methods
    • Access Modifiers : Private, Public, Protected, Internal
    • Working with Lists of (string, integer, class)
    • For loop, If..else, Switch statement
    • Overview of OOPs Concepts
      • Abstraction
      • Encapsulation
      • Polymorphism
      • Inheritance
    • C# Essentials Assignment
  • First WEB API Project
    • Understand Web API project files and folders
    • API Verbs: GET, PUT, POST, DELETE
    • Routing : Conventional and Attribute
    • Debugging and code execution
    • Overview of API response codes : 1XX,2XX,3XX,4XX,5XX
    • Understanding Swagger UI
  • Web API CRUD Operations
    • Entity Framework - Code First
      • Model/Entitiy driven Development
      • Migrations
    • Entity Framework – DB First - Scaffold existing database to C# entities & EF DB Context
    • Dapper (Micro ORM)
    • Data Annotations
    • Model Validations
    • API response codes : 1XX, 2XX,3XX,4XX,5XX
  • SQL Integration (As Needed)
    • DDL, DML and DQL COmmands : Create, Insert, Update, Delete, Select Commands
    • Constraints : Check, Not null, Default
    • Keys : Primary Key, Foreign Key, Unique Key
    • Joins : Inner, Left outer, Right Outer, Full Outer, Self join
    • Using Stored Procedures with best SQL practices
    • Migrate database objects & Data between databases
    • SQL Assignment - as needed
  • Data handling best practices
    • DTOs and Auto Mappers
    • Validate API inputs
    • Caching data in web API
    • Paging data in web API
    • Filter API response using OData
    • API versioning
    • Exception Handling & Logging using Serilog
  • Securing Web APIs
    • Basic Authentication - Using user name and password
    • Secure API using API Key
    • Secure API using JWT Token - Most popular approach for authentication in modern applications
  • Deployment & Testing Web API
    • Deploy Web API to IIS
    • Testing APIs using Swagger UI & Postman
  • Mini Workshop & Interview Questions
    • Workshop using topics learnt so far
    • Interview questions with answers for Web API.
    • Tips for Interviews

SQL Contents

  • Introduction
    • Understand the data around us
    • DBMS vs RDBMS
    • What/Why/Where SQL
  • SQL Fundamentals
    • Commands :
      • DDL (Data Definition Language)
      • DML (Data Manipulation Language)
      • DQL (Data Query Language)
      • TCL (Transaction Control Language)
      • DCL (Data Control Language)
    • Datatypes
    • Comparision & Logical Operators
  • Working with Tables and Data Manipulation
    • Create Table, Insert, Update, Delete
    • Drop Table, Alter Table, Truncate Table
  • DQL/Select Queries - Retrieval and filtering data
    • Expression, Alias
    • Like, In, Not in ,Between and
    • Top, Order by, CASE statement
    • Ltrim, Rtrim, Trim
    • Group By & Having
    • Handling NULL - Isnull, Coalesce
    • Distinct, Union, Union all
    • Agg. Functions - Count, Min, Max, Sum, Avg
  • Advanced Querying Techniques
    • Sub Queries and Corelated Sub Queries
    • Common Table Expressions (CTE)
    • Union, Union All
    • Handling nulls - Isnull, Coalesce
    • Handling Dates in SQL
  • Constraints and Keys
    • Constraints:
      • NOT NULL, CHECK, DEFAULT
    • Keys:
      • Primary Key (PK)
      • Foreign Key (FK)
      • Unique Key (UK)
  • Auto Generated Columns
    • Identity
    • GUID
    • Sequence
  • Joins and Relationships
    • Inner Join
    • Left Outer Join
    • Right Outer Join
    • Cross Join
    • Self Join
    • 1-1, 1-M, M-M relationships
  • Advanced T-SQL
    • Scripts and Variables
    • Views
    • User Defined Functions
    • Stored Procedures
    • Window Functions
  • Workshop & Interview Questions
    • Real world project database design example
    • Interview questions with answers for SQL
    • Tips for interviews

Course Feedback