1: Introduction to C# and .NET

• Overview of C# and .NET ecosystem
• Setting up the development environment (Visual Studio, VS Code, SDKs)
• Writing your first C# program
• Understanding compilation and execution flow
• Debugging basics in Visual Studio

2: Core C# Fundamentals

• Variables, Constants, and Data Types
• Operators and Expressions
• Control Flow (if, switch, loops)
• Methods and Functions (parameters, return types, overloading)
• Exception Handling (try-catch-finally)

3: Object-Oriented Programming (OOP) in C#

• Classes and Objects
• Encapsulation, Properties, and Fields
• Constructors and Destructors
• Inheritance and Polymorphism
• Abstract Classes and Interfaces
• Static Classes and Members
• Dependency Injection Basics

4: Working with Collections and LINQ

• Arrays and Lists
• Dictionaries, HashSets, and Queues
• IEnumerable, ICollection, and IQueryable
• Introduction to LINQ (Filtering, Sorting, Aggregation)
• Working with Lambda Expressions

5: File Handling and Data Persistence

• What are Files and Directory ?
• Working with Files in C# (Reading and Writing Files)
• C# File Class and Its Methods
• Create a File in C# and Open a File
• Read a File in C# and Write to a File

1: Introduction to Databases & SQL Server

• Understanding Databases and RDBMS Concepts
• Overview of MS SQL Server and Editions
• Installing and Configuring SQL Server & SSMS
• SQL Server Management Studio (SSMS) Overview
• Creating and Managing Databases

2: SQL Basics – Data Retrieval & Manipulation

• Introduction to SQL and T-SQL
• Understanding Data Types in SQL Server
• SELECT Statement – Retrieving Data from Tables
• Filtering Data Using WHERE Clause
• Sorting Data with ORDER BY
• Using DISTINCT for Unique Data
• Using GROUP BY and HAVING Clauses

3: Data Modification – INSERT, UPDATE, DELETE

• Inserting Data into Tables
• Updating Existing Data
• Deleting Records Safely
• Using Transactions (BEGIN, COMMIT, ROLLBACK)
• Handling NULL Values and Defaults

4: Joins and Subqueries

• Introduction to Joins
• INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN
• Using CROSS JOIN and SELF JOIN
• Subqueries and Nested Queries

5: Functions & SQL Server Built-in Features

• Scalar Functions (LEN, UPPER, LOWER, GETDATE, etc.)
• Aggregate Functions (SUM, AVG, COUNT, MIN, MAX)
• String Functions (CONCAT, SUBSTRING, REPLACE)
• Date and Time Functions
• User-Defined Functions (UDFs)

6: Stored Procedures and Triggers

• Introduction to Stored Procedures
• Creating and Executing Stored Procedures
• Input and Output Parameters
• Introduction to Triggers and Their Uses

7: Backup, Restore & Database Maintenance

• Backup Types (Full, Differential, Transaction Log)
• Performing a Database Backup and Restore
• Automating Backups with SQL Agent
• Database Maintenance Plans

1: Introduction to HTML5

• What is HTML5 and Why Use It?
• Differences Between HTML4 and HTML5
• Setting Up an HTML5 Document Structure
• Understanding Doctype and Character Encoding
• Basic HTML Elements and Attributes

2: HTML5 Semantic Elements

• Importance of Semantic Markup
• New Structural Elements: <header>, <nav>, <section>, <article>, <aside>, <footer>
• When to Use Semantic Elements
• Accessibility and SEO Benefits

3: Forms and Input Enhancements

• HTML5 Form Elements: <input>, <textarea>, <select>, <button>
• New Input Types: email, url, number, date, range, etc.
• Form Validation Without JavaScript
• Placeholder, Autofocus, Required Attributes
• Customizing Forms with HTML5 Attributes

4: Multimedia in HTML5

• The <audio> Element and Supported Formats
• The <video> Element and Its Attributes
• Adding Captions and Subtitles
• Fallback Mechanisms for Older Browsers

5: HTML5 Graphics and Animation

• Introduction to the <canvas> Element
• Drawing Shapes and Text on Canvas
• Introduction to SVG (Scalable Vector Graphics)
• Differences Between Canvas and SVG

6: HTML5 APIs

• Geolocation API: Detecting User Location
• Web Storage API: LocalStorage and SessionStorage
• WebSockets: Real-time Communication
• Drag and Drop API

7: Introduction to CSS3

• What is CSS3 and Why Use It?
• Differences Between CSS2 and CSS3
• CSS Syntax and Selectors
• Inline, Internal, and External CSS
• Understanding the Cascade, Specificity, and Inheritance

8: Styling Text and Fonts

• Working with Google Fonts and Web Fonts
• Text Styling: color, font-size, font-family, text-align, letter-spacing
• Text Effects: text-shadow, text-transform, word-wrap
• Line Height and Vertical Alignment

9: CSS Box Model and Layout

• Understanding Margins, Borders, Padding, and Content
• Box Sizing and Overflow Properties
• Display Properties: block, inline, inline-block, none
• Positioning Elements: static, relative, absolute, fixed, sticky
• Z-index and Layering Elements

10: CSS3 Colors and Backgrounds

• RGBA and HSLA Color Models
• Gradients: Linear and Radial
• Background Images and Properties

11: Responsive Web Design with Media Queries

• Introduction to Responsive Design
• Understanding Viewports and Breakpoints
• Using Media Queries for Different Screen Sizes
• Mobile-First Design Approach
• Relative Units (em, rem, vw, vh)

12: CSS3 Flexbox and Grid Layout

• Introduction to Flexbox: display: flex
• Flex Direction, Justify Content, Align Items
• Creating Responsive Layouts with Flexbox
• Introduction to CSS Grid
• Grid Tracks, Columns, Rows, and Gaps
• Combining Flexbox and Grid for Advanced Layouts

1: Functions and Events in JavaScript 1: Functions and Events in JavaScript 

• What is JavaScript?
• Setting Up the Development Environment (Browser Console, VS Code)
• Variables (var, let, const) and Data Types
• Operators and Expressions
• Conditional Statements (if, switch)
• Loops (for, while, do-while)

2: Functions and Events in JavaScript 

• Defining and Calling Functions
• Function Parameters and Return Values
• Arrow Functions (=>)
• Understanding Event Listeners (onclick, onchange, onmouseover)
• DOM Manipulation (getElementById, querySelector)
• Handling Forms and User Inputs

3: Working with Arrays and Objects 

•  Creating and Manipulating Arrays (push, pop, map, filter, forEach)
•  Objects and JSON Basics
•  Object Properties and Methods
•  Iterating Over Objects (for...in, Object.keys)

4: Introduction to jQuery 

•  What is jQuery? Benefits of Using jQuery
•  Setting Up jQuery (Using CDN: https://ajax.googleapis.com/ajax/libs/jquery/3.7.1/jquery.min.js)
•  Selecting Elements ($(), id, class, tag)
•  jQuery Events (click, hover, keyup)
•  jQuery Effects (hide, show, toggle, fadeIn, fadeOut)
•  Adding and Removing Elements (append, remove)

5: AJAX and JSON 

•  What is AJAX? Why Use AJAX?
•  Making HTTP Requests using $.ajax()
•  Fetching Data from a Server (GET, POST)
•  Handling Responses (Success, Error)
•  Working with JSON Data
• Displaying JSON Data on a Web Page

1: Introduction to MVC 

• What is MVC?
• Introduction to design Pattern
• What is framework and differences between framework and library
• Component of MVC design pattern
• Introduction to Model, View and Controller and their responsibility.
• NET MVC and its feature
• Introduction to web application architecture, request and response
• How an application works?
• How separation of concern benefits us?

2: Introduction to MVC 

• What are Views?
• Responsibility of Views
• Benefits of Using Views
• Creating a View
• Content of a View File
• What is Layout?
• How to create a Layout?
• Specifying a Layout
• Layout property of Razor views
• Introduction to RenderBody, Section, RenderSection etc.
• Ignoring sections
• About _ViewStart.cshtml file
• Razor Directives, Importing Shared Directives
• About _ViewImports.cshtml file
• Passing Data from Controller to View
• Introduction to ViewBag and ViewData
• Usages of TempData, ViewBag and ViewData

3: Razor View Engine

• Razor View Engine, Razor Syntax
• Symbol to transition from HTML to C#
• Implicit Razor expressions
• Explicit Razor expressions
• Expression encoding
• Razor code blocks
• Implicit transitions
• Explicit transition
• Transitions in decision and Control Structures
• Comments in Razor Syntax

4: Controller in ASP.NET Core MVC

• What is a Controller?
• Responsibility of a Controller
• Action Methods and Action Results
• ActionResult vs IActionResult
• ViewResult, JsonResult, ContentResult, EmptyResult,
• RedirectResult, RedirectToActionResult, BadRequestResult
• FileResult, FileContentResult, FileStreamResult
• Dependency Injection in Controller
• Implicit Dependencies Principle
• Explicit Dependencies Principle
• Constructor Injection
• Action Injection

5: Model in ASP.NET Core MVC

• What is a Model?
• Responsibility of a Model
• Introduction to Model binding 
• How Model binding works?
• Data Sources To Bind Request Data
• Form values, Route values, Query strings
• Bind Request Data
• Customize Model Binding With Attributes
• [BindRequired], [BindNever]
• Exact Binding source [FromHeader], [FromQuery], [FromRoute], [FromForm] 
• [FromServices], [FromBody] etc.
• What happens Inside Model Binding?
• Value providers and Model Binders activities.

6: Model Validation in ASP.NET Core MVC

• What is Model Validation?
• Why Model Validation?
• Where Model Validation ?
• Introduction to Validation Attributes • How Model validation works?
• Example of Model with Validation Attributes
• Built-in Validation Attributes
• ComponentModel.DataAnnotations Namespace for validation attributes
• Model State and Handling Model State
• Manual Validation and Custom validation
• Client-side validation and Remote validation

7: Routing in ASP.NET Core MVC

• What is Routing?
• Routing in ASP.NET Core
• Routing Basics
• Router Middleware
• Incoming request, Route Handlers, RouteAsync Method, Route collection
• Creating Default Routes
• Extending Default Routes
• Using Attributes
• Building RESTful Routes
• Using Constraints

8: Language Integrated Query (LINQ)

• What is LINQ ?
• Types Of LINQ
• LINQ Architecture IN .NET
• Why LINQ ?
• The building blocks of LINQ
• LINQ Query Syntax
• LINQ Lamda Syntax
• How LINQ to SQL works?
• LINQ Query Operators

9: ORM and Entity Framework Core

• What is ORM?
• Entity Framework Core
• Introduction to Entity Framework Core
• Entity Framework Architecture
• Conceptual Model, Storage Model, Mapping
• Entity Framework Core in two scenarios
• Domain Model and Database
• Domain Model Approaches
• Code First and Database First Approach
• Concept of DBContext
• Introduction to Scaffolding

10: How to use EF Core in ASP.NET Core MVC

• Create the Model
• Add Migration and Create Database
• Introduction to Asynchronous Code
• Synchronous vs. Asynchronous code
• Introduction to async and await
• Entity States, No-tracking Queries etc.

11: Security, Authentication and Authorization in ASP.NET Core MVC

• What is Authentication
• Authentication in ASP.NET Core
• Identity on ASP.NET Core
• Configure Identity
• Introduction to Authorization
• Authorization Types
• Authorization Namespace
• What is Role?
• Different Types of Authorization
• Simple Authorization
• Role based Authorization
• Claims-Based Authorization
• Custom Policy-Based Authorization
• Resource Based Authorization
• View Based Authorization
• How to add role checks?
• Policy based role checks
• How to add claims checks?

12: Application Deployment in ASP.NET Core MVC

• Deploy WEB Application in Remote Server
• Publishing and packaging Web Application
• Backup Database to Local machine
• Configuring Server
• Restore the database to remote server
• Deploying the Application and GO Live

13: Project Work in ASP.NET Core MVC

• Introduction to project
• Project plan, approach and methodology identification
• Setting up the Project environment
• Conceptualization of requirements and develop requirements specification
• Designing solution in detail
• Development or construction based on the design
• Testing and debugging the Application
• Deploy Application to server