C# & ADO.Net
  • VS Installation
    • Visual Studio (community edition) Installation
    • Understanding IDE Features and Shortcuts
    • Creating First Project
  • Basics
    • Introduction
    • History of C#, .Net Framework, .Net Core etc.
    • Variable, Keywords & DataTypes
    • Expression & Operators
    • Methods & Parameters
    • Call by value/reference, ref, out, params
  • Control Statements
    • if-else
    • switch-case
    • while & do while
    • for loops, for-each
    • break, continue, goto etc
  • Arrays & Collections
    • 1D, 2D, Jagged Arrays
    • Structures (struct)
    • Enum
    • Type Conversion (Casting)
    • Boxing & Unboxing
    • String & DateTime Methods
  • Logic Building & Programs
    • Pattern Programs
    • Factorial
    • Prime number
    • Palindrome
    • Swap two variables (with/without temp)
    • Recursion
    • Armstrong Number
  • Object-Oriented Programming (OOPs)
    • Class & Object
    • Constructor, Destructor
    • Inheritance (IS-A)
    • Composition / Aggregation (HAS-A)
    • Polymorphism
      • Method Overloading
      • Method Overriding
    • Access Specifiers
    • Encapsulation >> Properties - SET/GET
    • Abstraction
      • Abstract Class
      • Interface
    • Static Keyword, Static Constructor
    • Nested Classes
  • Advanced C#
    • Delegates
    • Events
    • Exception Handling
    • Try, Catch, Finally, Throw
    • Custom Exceptions
    • Anonymous Methods
    • Lambda Expressions
    • Extension Methods
  • Collections
    • System.Collections
    • Hashtable
    • ArrayList
    • Stack, Queue
  • System.Collections.Generics
    • Stack
    • Queue
    • HashSet, SortedSet
    • List
    • SortedList
    • LinkedList
    • Dictionary
    • SortedDictionary
  • Generics
    • Generic Methods & Classes
    • Constraints
  • Multi Threading
  • Thread Class
  • ThreadPool
  • Locking
  • Task-based Asynchronous Programming
  • async/await
  • File IO
    • Read/Write Text File
    • Read/Write Binary File
    • FileStream, StreamReader, StreamWriter
  • Serialization
    • XML Serialization
    • JSON Serialization (using System.Text.Json, Newtonsoft.Json)
    • Deserialization
  • LINQ (Language Integrated Query)
    • LINQ to Objects
    • LINQ Methods: Where, Select, OrderBy, GroupBy, Join
    • Query vs Method Syntax
    • Anonymous Types, Projection
  • SQL Server
    • SQL Server Installation & SSMS
    • Data Types
    • CRUD Operations (create, read, insert, update, delete)
  • ADO.NET (Database Integration)
    • Connected Architecture:
    • SqlConnection, SqlCommand
    • SqlDataReader
    • Disconnected Architecture:
    • DataSet, DataTable
    • DataAdapter
    • CommandBuilder
    • ExecuteScalar, ExecuteReader, ExecuteNonQuery