Courses

Module 1: Introduction to .NET Framework

• Overview of .NET Framework, .NET Core, and .NET 5/6
• Setting up the development environment (Visual Studio, .NET SDK)
• Understanding the CLR (Common Language Runtime) and FCL (Framework Class Library)
• Introduction to Visual Studio IDE

Module 2: Basics of C# Programming

• Introduction to C# language and syntax
• Data types, variables, and constants
• Operators and expressions
• Control structures (if-else, switch, loops)
• Methods and functions
• Exception handling

Module 3: Object-Oriented Programming in C#

• Principles of OOP (Encapsulation, Inheritance, Polymorphism, Abstraction)
• Classes and objects
• Constructors and destructors
• Properties and indexers
• Static members
• Method overloading and overriding
• Interfaces and abstract classes

Module 4: Advanced C# Concepts

• Collections and Generics
• Delegates and events
• Lambda expressions
• LINQ (Language Integrated Query)
• Asynchronous programming with async/await
• Handling null values with nullable types

Module 5: Working with Data

• Introduction to ADO.NET
• Connecting to databases (SQL Server, SQLite, etc.)
• Performing CRUD operations
• Using DataReader, DataSet, and DataAdapter
• Introduction to Entity Framework Core
• Code-first and database-first approaches
• LINQ to Entities

Module 6: File I/O and Serialization

• Working with files and directories
• Reading and writing files
• Serialization and deserialization (XML, JSON, Binary)
• Streams and file handling

Module 7: Developing Desktop Applications

• Introduction to Windows Forms
• Building a simple WinForms application
• Event handling in WinForms
• Introduction to Windows Presentation Foundation (WPF)
• Building a simple WPF application
• Data binding in WPF
  
   

  Module 1: Introduction to SQL Server

• Overview of SQL Server and its editions
• Installing SQL Server and SQL Server Management Studio (SSMS)
• Understanding SQL Server components (Database Engine, SSIS, SSAS, SSRS)
• SQL Server architecture and databases

• Module 2: Basic Database Concepts

• Introduction to databases and database management systems (DBMS)
• Understanding tables, rows, and columns
• Data types and their uses
• Primary keys, foreign keys, and relationships

• Module 3: SQL Server Management Studio (SSMS)

• Introduction to SSMS interface
• Connecting to SQL Server instances
• Creating and managing databases
• Creating and managing tables

• Module 4: Basic SQL Queries

• Introduction to SQL language
• Writing basic SELECT statements
• Filtering data using WHERE clause
• Sorting data using ORDER BY clause
• Using DISTINCT to remove duplicates

• Module 5: Working with Data

• Inserting data into tables (INSERT statement)
• Updating existing data (UPDATE statement)
• Deleting data from tables (DELETE statement)
• Bulk insert operations

• Module 6: Functions and Expressions

• Using built-in SQL functions (String, Numeric, Date)
• Understanding expressions and computations
• Using CASE statements for conditional logic
• Aggregate functions (SUM, AVG, COUNT, MIN, MAX)
• Grouping data with GROUP BY clause
• Filtering grouped data using HAVING clause

• Module 7: Joining Tables

• Introduction to joins
• Inner joins, left joins, right joins, and full joins
• Cross joins and self joins
• Using joins to combine data from multiple tables