Technology Topics
C#(Yogendra, Neeraj, Pankaj Sai)
C# - A1 C# Basics and OOPS
C# - A2 C# Basics and OOPS
C# - B1 C# Basics and OOPS
C# - C1 C# Delegates
C# - B2 C# Collections and Generics
C# - B3
C# - B3 C# tuples, exception handling
C# - C2 Multi threading
SQL( Tanya)
SQL - A1 SQL
SQL - B1 SQL
C#, LINQ( Yogendra, Yash, Pankaj Sai)
C# - A3 LINQ
C# - B4 LINQ
C# - B5 LINQ
C# - C3 LINQ
Entity Framework( Yogendra, Pankaj
Sai)
EF - C1 Entity Framework
.NET(Yogendra, Neeraj, Yash)
.NET B1 .Net Core Framework
.NET C1 .Net Core Framework
.NET B2 Web API
.NET B3 Web API
.NET C2 Web API
.NET C# Web API
Project 1 Project 1 [Server Side]
Project 2 [Link]
Project 3 [Link]
Project 4 [Link]
Total Days in
Previous
plan (No
Projects)
Total Days in
Current Plan
(With 5 Additional days for Project 4
Projects) + Final Assessment
Level Duration(Days) Content To Study
Common Operators, Value Type & Reference Type, Nullable Type,
Dynamic Type, Var, Datatypes conversion, Conditional Statement and
Loops,Methods,Optional Parameter,Namespaces,Static and
Basic 1 Instance,Param
Arrays and its methods, string methods
OOPS Concepts -
Inheritance
Encapsulation
Polymorphism - Method Overloading and Overriding
Method Hiding
Basic 1 Abstraction-Interface and Abstract class
Properties
Structures
Access Modifiers
Enums
Partial Class
Sealed class
Virtual
Intermediate 1 Override
Delegates
Multicast Delegates
Anonymous method
Lamda Expression
Advanced 1 -
Collections
Intermediate 1 Non Generic Collection - ArrayList, Hashtable
Generic Collection - List, Dictionary, SortedList
Generics
Tuples - Introduction, Generic Class and Methods, How to
Intermediate 1 apply Generics
Extension Method
Exception Handling
Intermediate 1
1 Project 1
Task
Multi-Threading
Advanced 1
6
Introduction to MySql
SQL Languages: DML, DDL, DCL & TCL
SQL - Constraints
SQL clauses (Select, order by, distinct, aggregation, string,
like, not in, in, exists, group by, having)
Basic 1 SQL-Joins - Aliases - inner
Outer joins - left, right
Stored procedure
Function
Intermediate Triggers
1 Project 2
Introduction and Query Syntax/Method Syntax
Lambda Expression and Annonymous type
Queryable/Enumerable
Basic 1 Deferred & Immediate Execution
Where
OrderBy
ThenBy
Select, SelectMany
All, Any, Contains
ElementAt, ElementAtOrDefault
First, FirstOrDefault
Last, LastOrDefault
Intermediate 1 Single, SingleOrDefault
GroupBy
Aggregation Operators (SUM, MAX, AVG, etc)
Join, right and left join, Group Join
Let and Into keywords
Include, ThenInclude
Distinct, Except, Intersect, Union
Intermediate 1 Take, TakeWhile, Skip, SkipWhile
Linq to SQL
Linq to Object
Dynamic Query
Advanced 1 Predicate Builder
Introduction to Entity Framework
Data Model and DbContext
Entity Framework -
Database First Approach
Code First Approach
Handle model changes in Entity Framework
Advanced 1 Change Tracker, Entity States
1 Project 3
Introduction to .Net Core Framework
CLR, CLS, CTS
Project Structure
Advantage of .Net Core
Middleware in .net core
Intermediate 1 DLL File , Exe File
Dependency Injection with all methods, registration,
Advanced 1 transient, scoped, singleton
Introduction To Web API
Creating A Web API
Testing A Web API using Postman
Intermediate 1 Web API Controller
Web API Routing
1. Conventional Routing
2. Attribute Routing
3. Parameter Binding - FromBody, FromUri Keyword,
FromQuery
Intermediate 1 Action Return Type - IActionResult, JSONResult, ViewResult
Middleware
Web API Filter and Attribute
HTTP Client
Cross Origin Resource Sharing (CORS)
Advanced 1 HTTP Codes
Web API CRUD
- Connect angular and web api
Advanced 1 - Consume another web api using HttpClient from web api method
5 Project 4 + Final Assessment
Project 1
Project 2
Project 3
Project 4
21
29
References
"[Link] [Link] https:
[Link] [Link] https:
[Link] [Link]
[Link]
[Link] [Link]
[Link]
[Link] [Link]
[Link] [Link]
[Link]
[Link]
[Link] [Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link]
[Link] [Link]
[Link]
[Link]
[Link]