.NET Fundamentals

• What is Microsoft .NET

• History of .NET

• Origin of .NET

• Usage of .NET

• DOT net Architecture

• Different tiers in Dotnet Architecture

• Know about Visual studio IDE

• How to add numbers using IDE

• Common Language Runtime (CLR) basics

• CLR Architecture and its Services

• JIT compilation and CLS

• Strict type checking

Review Syntax

• Overview of Writing Applications using C#

• Datatypes, Operators, and Expressions

• Functions and its types

• Arrays and Strings

• OOPS concepts: Classes, Objects, Constructors, Inheritance, polymorphism, multithreading, encapsulation, access modifiers, abstraction and interfaces

• C# Programming Language Constructs

• Know about Indexer

Methods, exceptional handling and app monitoring

• Creating and Invoking Methods

• Creating Overloaded Methods

• Using Optional and Output Parameters

• Handling Exceptions

• Monitoring Applications

Delegates and Events

• What is delegate

• Types of Delegates

• Anonymous methods

• What are events

• Event Model

• Creating events using Delegates

Develop the code for a graphic app

• Implementing Structs and Enums

• Organizing Data into Collections

• Handling Events

Classes, interfaces, and type-safe collections

• Creating and using custom Classes

• Defining and Implementing Custom Interfaces

• Use generics for Implementing Type-safe Collections

Creating class hierarchies using Inheritance

• Define abstract classes

• Define Inheritance

• Creating Class Hierarchies

• Extending .NET Framework Classes

• Using extension methods

• Creating Generic Types

Reading and Writing Local Data

• Reading and Writing Files

• Serializing and Deserializing Data

• Performing I/O Using Streams

Accessing a Database

• Creating and Using Entity Data Models

• Querying Data by Using LINQ

• Updating Data by Using LINQ

.NET Programming Principles

• Writing a procedural program

• Transitioning to the object-oriented philosophy

• Coding using fundamental C# or VB syntax and semantics

• Reviewing, compiling and executing a program in Visual Studio

Using Visual Studio

• Creating projects and solutions

• Editing and compiling a program

• Running a console application

Coding object–oriented applications

• Dividing code into classes

• Adding fields, methods and properties

• Defining code layout and limiting scope

• Instantiating objects

Working with data types and conversions

• Strings

• Dates and time

• Integers

• Real numbers

• Booleans

• Performing calculations with mathematical operators

• Converting between data types

Controlling program execution

• IF statements

• Writing complex criteria expressions

• CASE (switch) statements

• For...Next loops

• Do While...loops

Constructing ASP.NET websites with Visual Studio

• Writing HTML pages and forms

• Maintaining consistency with Master Pages

• Designing pages with ASP.NET controls

• Styling sites with ASP.NET themes

Processing ASP.NET Web Forms

• Displaying data and gathering user input Activating

• Web Forms with events Maintaining variables with sessions

• Styling using CSS (Cascading Style Sheets)

Relational database concepts

• Employing databases for fast, efficient storage

• Selecting, inserting, updating and deleting query syntax

Creating a SQL Server database

• Adding tables, fields and indexes

• Defining primary and foreign key relationships

Accessing the database with Entity Framework

• Connecting to the database

• Storing user information

• Retrieving existing records

• Updating and saving user information

• Adding and deleting records

Object Oriented Program Layout

• Encapsulating data

• Ensuring proper object creation using constructors

• Extending classes using inheritance

• Overriding using virtual functions

Code Quality and Error Handling

• Ensuring type safety with Enums

• Throwing and handling exceptions

• Try...Catch...Finally error handling

• Commenting code

Developing .NET business apps

• Preparing an effective layered application architecture

• Implementing a Visual Basic solution with Visual Studio

• Strong naming assemblies with Visual Studio

Designing classes with encapsulation

• Coding classes with fields and public properties, methods and events

• Instantiating objects with constructors and initializers

• Linking objects with associations

• Crafting classes with Visual Studio class designer

• Creating shared, overloaded and extension methods

Applying inheritance

• Identifying when to use inheritance

• Coding inheritance hierarchies with Inherits

• Overriding base class functionality with Protected, Overridable and Overrides

Employing polymorphism

• Creating abstractions with Must Inherit classes

• Connecting to databases with ADO.NET

• Working with Connection, Command and Data Reader

• Calling stored procedures from ADO.NET

• Releasing disposable objects

• Mapping objects to databases with ADO.NET Entity Framework

• Demystifying the database, model and code-first approaches

• Automating object-relational mapping

• Representing associations with foreign key mappings

• Lazy and eager loading-related objects

• Persisting an object graph into the database

Integrating query into Visual Basic with LINQ

• Constructing LINQ statements

• Filtering, sorting, grouping and reshaping data: Where, Order By, Group By and Select

• Building custom objects from LINQ queries with anonymous classes

• Working with expression and lambda function LINQ syntax

• Harnessing LINQ with collections and Entity Framework

• Deploying Visual Basic Applications