OOP Fundamentals and Design Principles
This module will guide you through the four basic OOP concepts like abstraction, encapsulation, inheritance, and polymorphism. You will also become familiar with the key OOP design principles like SOLID, GRASP, and more general principles like DRY, KISS and YAGNI. The module also requires you to design and implement a simple application to get practical experience in applying these principles.
Self Study materials
Chapter 1 only - Object Oriented Fundamentals
Object-Oriented programming (C#) - Microsoft article
Inheritance in C# and .NET - Microsoft article
Overview of classes, structs, and records in C# - microsoft article
S.O.L.I.D, GRASP and Other Basic Principles of Object-Oriented Design - an article
S.O.L.I.D. Principles of Object-Oriented Programming in C# - an article
DRY, KISS & YAGNI Principles - an article
The goal of this module is to provide an overview of Language-Integrated Query (LINQ) and its operations like filtering and aggregation. You will learn the essential parts of a query operation and how to use extension method along with query expression syntax. At the end of the module, you will apply the acquired knowledge in composing queries for Orders, Products and Customers data models.
LINQ Introduction - Microsoft article
LINQ to Objects - Microsoft article
Learn the basics of working with Language-Integrated Query (LINQ), which allows developers to filter, sort, aggregate, and query data directly within C# code.
10 LINQ Myths - an article
The goal of this module is to provide an overview of ADO.NET technology, connected and disconnected models. Practical task includes implementation of the DAL (Data Access Layer) using ADO.NET for database access.
ADO.NET - Microsoft article
ADO.NET Overview (whole section) - Microsoft article
Securing ADO.NET applications (whole section) - Microsoft article
Connection to a Data Source (whole section) - Microsoft article
Connection Strings in ADO.NET (whole section) - Microsoft article
Commands and Parameters (whole section) - Microsoft article
DataAdapters and DataReaders (whole section) - Microsoft article
Modifying Data with Stored Procedures - Microsoft article
Basics of ADO.NET - an article
Microsoft ADO.NET for SQL Server (whole section) - Microsoft article
Connected vs Disconnected Architecture in C# - an article