Dot Net Training in Bangalore

1.Introduction to C# : Getting Started

:

Introduction to C#

History of C# Version

C# Code Execution

Installing and Configuring Visual Studio

Variable

Data Type

Safe Type Casting with IS and AS Operator

2.C# Conditional Statements and Loops

:

Operators

Operators precedence

Conditional Statements: if, if..else if, switch

Loops: do..while, while, for, foreach

Jump Statements

3.C# Arrays and Strings

:

Arrays

Types of Arrays

Strings

String Methods

4.Object-Oriented Programming in C#

:

Object-Oriented Programming Concepts

Access Modifiers

Constructor

Inheritance

Methods

Structure

5.C# Concepts: Abstract Class, Interface and Partial Class

:

Abstract Class

Interface

Interface vs. Abstract Class

Static Class

Extension Methods

Partial Class

Partial Methods

6.C#: Property, Indexer, Attributes and Exception Handling

Learn to work with property, indexer, attributes to create a C# console application for tracking bands. Further learn to handle exceptions in C#. When you are finished with this course, you will have the skills and knowledge you need for building real-world applications using C#.

:

Property

Indexer

Exceptional Handling

Enum

Attributes

7. C# Concepts: Anonymous Type, Delegates, Events and Lambda

:

Extension Methods

Anonymous Type

Var and Dynamic

Delegates

Events

Anonymous Methods

Lambda Expression

Expression Tree

8.C# Asynchronous Programming - Async and Await

:

What is Synchronous and Asynchronous?

Asynchronous Programming Patterns in .NET

Asynchronous Programming Model (APM)

Event-based Asynchronous Pattern (EPM)

Task-based Asynchronous Pattern (TAP)

Async and Await in Task-based Asynchronous Pattern TAP

Asynchronous vs. Multithreading

SQL SERVER

1.Getting Started with SQL Server

:

Introduction to Database

Introduction to SQL Server

Installing SQL Server and Components

SQL Server Database and Tables

SQL Keys

SQL Commands

SQL Constraints

Types of Database

2.T-SQL Fundamentals with SQL Server

:

Data Types, Variables and Operators

SQL Server Control Of Flow

SQL Query and Sub Query

SQL Clauses

SQL Predicates

SQL Joins

SQL Exceptions

Try..Catch

3.SQL Server Views and Indexes

SQL Server Views

Types of Views

SQL Sever Indexes

Types of Indexes

4.SQL Server Stored Procedures and Functions

S

Introduction to Stored Procedure

Types of Stored Procedure

Creating Stored Procedures For Insert, Update and Delete

Stored Procedures Parameters

SQL Server Functions

Scalar Functions

Table Valued Functions

5.SQL Server Triggers and Cursors

S

SQL Server Triggers

Types of Triggers

SQL Server Cursors

Types of Cursors

Cursor Alternatives

6.Understanding and Managing Azure SQL Database

:

Introduction to Azure SQL Database

Database Deployment Models

Azure SQL Database Server

Creating and Managing Single Database

Purchasing Models: DTU and vCore

Azure SQL Database Tools

Database Migration Using DMA

Creating and Managing Elastic Pool

Creating Managed Instance

HTML COURSE

1.Introduction to HTML

:

What is HTML?

History of HTML

HTML Development IDE

HTML Page Structure

Introduction to HTML5

HTML5 Document

Browsers Support and Advantages

2.HTML5 Basics: Tags, Elements and Attributes

:

HTML Tags

HTML Elements and Attributes

HTML Formatting and Styles

HTML Layouts

HTML Blocks and Inline Elements

Empty Elements And Nested Elements

HTML Quotation and Citation Elements

HTML CSS

3. HTML5 Tables, Lists and Layouts

:

HTML Tables - Columns, Row, Border, Padding

HTML Lists - Order and Unorder List

What is HTML Layouts?

Table Based Layout

Div Based Layout

HTML5 Structure Based Layout

 Level : Intermediate

4.HTML5 Forms, Media and Storage

:

HTML5 New Input Elements

HTML5 Forms Attributes

HTML5 Validations

HTML Media

HTML Audio

HTML Video

HTML and JavaScript

HTML Storage API

HTML Graphics

CSS  COURSE

1.CSS3 Fundamentals

:

Introduction to CSS

CSS3 Selectors

Pseudo Elements and Pseudo Classes

Types of CSS

CSS Fonts and CSS Text

CSS Box Model

Margin, Padding and Border

Position and Colors

CSS Background and Gradients

2.CSS3 Advanced Concepts

CSS Units

CSS Layout

Media Queries

CSS Functions

Transforms - 2D and 3D

Transitions and Animations

CSS Shadow

Getting Started with Bootstrap 4

:

Introduction to Bootstrap

Bootstrap Installation Options

Introduction to Bootstrap 4

Layouts and Grid System

Alignments and Offsets

2. Bootstrap 4 Flexbox, Style and Utilities

S:

Flexbox

Typography

Colors

Utilities

3.Bootstrap 4 CSS Components: Images, List, Tables, Button and Cards

:

Images and Lists

Bootstrap Tables

Buttons, Badges

Cards, Media Objects

4.Bootstrap 4 CSS Components: Forms, Navbars, Pagination and Spinners

:

Forms and Validations

Nav, Navbar

Breadcrumb and Pagination

Progress bars and Spinners

ASP.NET

1.Introduction to ASP.NET MVC

:

Introduction to ASP.NET MVC

ASP.NET MVC vs. ASP.NET Web Forms

Advantages of ASP.NET MVC

Creating ASP.NET MVC5 Project

Understanding ASP.NET MVC Folder Structure

Layout, Sections and View Start

MVC Pattern

MVC vs. Tier

Action Methods and Result Types

2.ASP.NET MVC Fundamentals

:

Razor View Engine

Razor View Engine vs. WebForms Engine

Razor Syntax

Creating Custom View Engine

Routing : Routes and Constraints

HTML Helpers

Validation Summary

AJAX Helpers

Data Passing Techniques: ViewData, ViewBag, TempData, Session, QueryString

Partial Views

3.ASP.NET MVC Forms and Validation

:

ASP.NET MVC Forms

Model Binding

Custom Model Binding

Synchronous Forms

Asynchronous Forms

Forms Validations : Server Side and Client Side

Custom Validation

4.Working with Data Using Entity Framework

:

Introduction to Entity Framework

Creating Database Using Code First

Database CRUD Operations

Working with jQuery AJAX

Calling Stored Procedure and Functions

Listing, Paging, Sorting using WebGrid

AJAX WebGrid

5.ASP.NET MVC Unit Testing

:

Introduction to Unit Testing

Test Driven Development (TDD)

.NET Unit Testing Frameworks

Visual Studio Live Unit Testing

Creating Test cases using MS Test

Creating Test cases using xUnit

Using Mocking Frameworks

6.ASP.NET MVC Pipeline and Security

:

ASP.NET MVC Pipeline

ASP.NET MVC Filters

Filters Configurations and Execution

Creating Custom ASP.NET MVC Filters

Security : Forms Authentication

Creating User Login Flow

Accessing Logged In User Details

Creating Base Controller

7.Building RESTful Services with ASP.NET Web API

:

Introduction to ASP.NET Web API

Building ASP.NET Web API

ASP.NET Web API CRUD Operations

Testing Web API Using Postman

Consuming Web API in ASP.NET MVC

Performing CRUD Operations using ASP.NET MVC

ADO.NET

:

Introduction to Entity Framework

Introduction to ORM Tools

Introduction to Entity Framework

Entity Framework Architecture

Data Modeling Approaches

Getting Started With EF

2.Entity Framework Database First Approach

:

Database First Approach

DbContext in EF 6

EF CRUD Operations Using ASP.NET MVC

Mapping Stored Procedures and Functions

Calling Stored Procedures and Functions

Performing CUD Operations

3.Entity Framework Code First Approach

:

EF Code First Modeling

EF Conventions

Database Annotation

EF Fluent API

CRUD Operations Using ASP.NET MVC

Calling Stored Procedure and Functions

Handling Input and Output Parameters

Handling Multiple Result sets

4.EF Code First Migrations and Relationships

:

Code First Migrations

Script Migrations

Migrations with Existing Database

Reverse Engineering

Database Initializers

Database Relationships - one-to-one, one-to-many, many-to-many

EF Inheritance

 5.Entity Framework Advanced Concepts

:

Queries

Entity and States

Data Loading

Transactions and Async Query

Working with Entity States

Eager Loading vs Explicit Loading

Handling Concurrency Conflicts

Working with Transactions in EF

Introduction to Web API: Getting Started

:

Introduction to SOA

Introduction to REST

Introduction to ASP.NET Web API

WCF vs. Web API

Building Web API

Testing API Using Postman

2.ASP.NET Web API Fundamentals

:

Routing - Convention and Attribute Routing

Route Constraints

Action Result

Content Negotiation

Media Type Formatters

Model Binding

Model Validation

Handling Validation Errors

3.Building RESTful Services with ASP.NET Web API

:

Introduction to ASP.NET Web API

Building ASP.NET Web API

ASP.NET Web API CRUD Operations

Testing Web API Using Postman

Consuming Web API in ASP.NET MVC

Performing CRUD Operations using ASP.NET MVC

4.ASP.NET Web API Advanced Concepts

:

ASP.NET Web API Pipeline

Web API Filters

Creating Custom Filters

Exception Handling

Dependency Injection

Web API Versioning

Web API Hosting

ANGULAR COURSE

1.Introduction to Angular

.

:

Introduction to Angular

Angular History

Angular1.x vs. Angular2+

Development Tools

Angular CLI

Creating Project for Angular v5, v6, v9

Angular App structure

Angular with Visual Studio

Angular Building Blocks

2.Angular Fundamentals

:

Data Binding

Directives

Custom Directives

Pipes

Custom Pipes

Routing

Router Links and Route Parameters

Nested Routes and Lazy Loading

3.Angular Components

.

:

Angular Components

Components Inheritance

Nested Components

Component Lifecycle Hooks

Content Projection

Shadow DOM

View Encapsulation

4.Angular Forms and Validation

:

Introduction to Angular Forms

Forms and Form Controls State

Template Driven Form

Model Driven (Reactive) Form

Angular Form Validations

Template Driven vs React Form

Custom Form Validations

5.Angular Advanced Concepts

:

Introduction to ReactiveX

Understanding Angular2 Services

Introduction to Zone.js

Observable and Observer

Observable Operators

Observable vs. Promises

Dependency Injection

Change Detection Strategies

6.Angular Unit Testing

:

Tools and Technologies

Writing First Test Case

Isolated Testing

Integration Testing

Code Coverage

Debugging

7.Angular App Optimization Techniques

:

Introduction to App Optimization

Looking into Bundle

Lazy Loading

Removing Shared Module

Specifying Budgets

8.Angular NgRx: Getting Started

:

Introduction to NgRx

When to use NgRx

NgRx Packages

NgRx Store, Reducer and Selectors

NgRx Effects

NgRx DevTools

TYPESCRIPT

1.Introduction to Typescript : Getting Started

:

Introduction to TypeScript

Setting Up Development Environment

Data Types

Variables

var, let and const

2.TypeScript: Conditional Statements and Loops

:

Conditional Statements

if, if..else, switch statements

Loops

while loop

for loop

for..in, for..of loops

Strings

3.Object-Oriented Programming in TypeScript

:

Object-Oriented Programming Concepts

Access Modifiers

Members and Accessors

Inheritance

Polymorphism

Abstract Class and Interface

Methods Overloading

Constructors

4.TypeScript Concepts: Functions, Namespace and Modules

:

Functions

Function Parameters

Generics

Modules

Namespace

1.LINQ Fundamentals

:

What is LINQ?

LINQ Architecture

LINQ Flavors

Advantages and Disadvantages of LINQ

LINQ Pad

LINQ Query Syntax and Query Execution

LINQ Query Operators

Var type vs. Generics

Collection Interfaces

2.LINQ with Entity Framework and EF Core

:

LINQ with Entity Framework

LINQ Query Providers

LINQ Pad to Test and run LINQ Query

Querying Entity Framework 6.x DAL

Entity Data Loading: Lazy Loading and Eager Loading

Querying Entity Core DAL

SQL Joins with LINQ

3.Getting Started with Entity Framework Core

:

Introduction to Entity Framework

Entity Framework Core

EF Core vs. EF 6.x

EF Core Data Modeling Approaches

Defining Model and Schema

Creating Database Using EF Core Code First

4.Entity Framework Core Fundamentals

:

EF Core Conventions

EF Core Custom Conventions

EF Core Migration

Script Migration

Database Reverse Engineering

DbContext Scaffolding

EF Core Power Tool

Relationships in Database

5.Working with Data Using Entity Framework Core

:

Introduction to ORM

Introduction to EF Core

EF Core Data Modeling

Creating Entities and Database

EF Core Migrations

Performing CRUD Operations

1.ADO.NET with ASP.NET Core In Connected Environment

Introduction to ADO.NET

ADO.NET Architecture

Advantages of ADO.NET

ADO.NET Environments

.NET Data Providers

Connection Object

Command Object

Data Reader

Data Reader: CRUD Operations

Transactions

2.ADO.NET with ASP.NET Core In Disconnected Environment

ADO.NET Disconnected Environment

Introduction to Dataset

Dataset: CRUD Operations