ASP.NET MVC Training in Nepal ASP.NET MVC Training

Topics Covered in MS SQl Server

Installing and Configuring SQL Server

• Install SQL Server 2012
• Configure SQL Server 2012instances and databases.
• Configure SQL Server security

Basics

• Understanding Normalization and Relationships
• SQL Queries
• SQL Insert,Delete ,Update statements
• SQL Joins

Creating and Implementing Database Objects

• Implement a table
• Implement a view
• Implement triggers
• Implement functions
• Implement stored procedures
• Implement constraints
• Implement indexes
• Create user-defined types
• Implement a full-text search.

Maintaining Databases

• Implement and maintain SQL Server Agent jobs
• Manage databases by using Transact-SQL
• Back up a database
• Restore a database
• Move a database between servers

Monitoring and Troubleshooting-SQL Server Performance

• Gather performance and optimization data by using the SQL Server Profiler
• Performance and optimization of data by using the Database Engine Tuning Advisor
• Monitor and resolve blocks and deadlocks
• Diagnose and resolve database server errors
• Monitor SQL Server Agent job history
• Gather performance and optimization data by using DMVs.
• Professional SQL SERVER 2012

SQL Server Reporting Services

• Overview of SSRS
• SSRS Installation
• Building reports
• Customizing reports
• Deploying report

C#. Net Training 

Introduction Of .NET Framework

• Basic Features Of .NET Languages
• Assemblies
• Structure of C# Program
• C# Variables
• Keywords
• Control (if, switch) statements
• Looping Statements (for, foreach, while, do-while) Statements
• Goto, break, return statements
• Namespaces

C# Objects And Types

• Concept of object and object oriented programming
• Classes and structs
• C# Methods
• Properties
• Constructors, constructor overloading
• Destructors
• Partial classes
• Static classes, properties and methods
• Encapsulation
• Interface
• Generics

Inheritance

• Concept of Inheritance
• Implementation of Inheritance
• Virtual Methods
• Abstract classes and Functions
• Parameterized Constructors
• Methods overloading

C# Interface

• Definition and declaration of interface
• Derived interfaces
• Implementation of interfaces IComparable, IEnumerable, IDisposable, ICollection
• Delegate And Events
• Introduction Of Delegate
• Declaration of delegate
• Delegate implementation
• Strings And Regular Expressions

String Operations and Formatting

• Implementation of StringBuilder
• Implementation of Regular Expression

Collections

• Introduction Of Collection
• ArrayList
• Stack
• Queue
• Dictionaries and HashTable
• LinkedList

Entity Framework

• Introduction Of Entity Framework
• Implementing Inheritance
• Implementing Associations
• Understanding Database First, Code First, Model First
• Implementing Database First
• Implementing Model First
• Implementing Code First
• Code First Migration
• LINQ Expressions
• Lambda Expressions
• Working with Stored Procedures
• All types of Join queries
• Aggregate Functions

Generics in C# (Concept and Implementation

• Threading (Concept
• And Implementation)
• Localization and Globalization
• Deployment
• Data Access

ADO.NET Introduction

DataSet, DataTable

• Database Specific Classes(SqlConnection, SqlCommand, SqlTransaction etc)
• Database Connection
• Executing Commands (ExecuteNonQuery(), ExecuteReader(), ExecuteScalar())
• Stored Procedure Concept and Implementation
• Tire Architectures(1 tire, 2 tire and 3 tire) example and implementation

XML

• XML Concept
• Read, write and delete opetaion in XML

ASP .NET MVC Training

JQuery and Java Script

• Introduction
• JavaScript fundamentals
• JQuery Functions
• Dynamic HTML
• JQuery Events
• JQuery Ajax
• JQuery Effects
• Advance topics in JQuery including Utility Functions
• CRUD operations in ASP.NET MVC with AngularJS

Angular Js

• Introduction
• Fundamentals including Expressions, Directives etc
• Understanding Modules,Factory,Services and Controllers
• CRUD operation in ASP.NET MVC using AngularJS

MVC Architecture

• Introduction
• Overview on Model, Controller and Views
• Lifecycle of ASP.NET MVC application
• ASP.NET MVC Pipeline
• Separation of Concern
• Pros and Cons

Routing

• Introduction
• MVC Controllers and Routing
• Defining Custom Routes
• Attribute Routing

Controller:

• Actions and Parameters
• Action Results
• Action Selectors
• Different type of Action Filters
• Implementing Action Filters
• Authentication and Authorization

Model:

• Introduction
• Understanding Model Binders and Implementing it
• Model Validation
• View Model

Views

• View Engines
• Diferent types of Views
• Introduction to Razor Syntax
• Creating Layout Views
• Creating Partial Views
• Html Helpers
• Uploading files
• Form Handling
• Creating Custom Html Helpers
• Using thirdparty grid for displaying data

Validation

• Client Side Validation
• Server Side Validation

AJAX and ASP.NET MVC

• AJAX Helpers
• CRUD operation using ASP.NET Ajax
• Autocompletion
• Paging Results

State Management

• Client Based State Management including Cookies, View Data, View Bag and Temp Data
• Server Based State Management Including Session

Globalization and Localization

• Globalization Using Resource
• Globalization Using XML Resource

MVC Application Development Approach

• Developing and Migrating application using Code First
• Developing application using Database First Approach
• Scaffolding in ASP.NET MVC

Security

• Authentication and Authorization
• OWIN and Katana
• XSRF/CSRF Prevention

Performance

• Profile and Debug application with Glimpse
• Using Asynchronous Methods
• Bundling and Minification
• Caching

Design Patterns

• Creations Patterns including Singleton and Factory Method
• Repository Pattern
• Unit of Work Pattern
• Using above patterns developing MVC application.

Email

• Send Email With CC And BCC
• Send Email With Attachment

Troubleshooting and Error Handling

• Debugging in Asp.NET MVC
• Error Handling in ASP.NET MVC
• Error Logging using ELMAH

Configuring and Deploying -ASP.NET MVC Applications

• Configuring IIS and the .NET Framework
• Deploying ASP.NET MVC Applications

Reporting

• Incorporating ASP.NET MVC and SQL Server Reporting Service

WEB API

• Introduction
• Patients and Data
• Query by ID
• Attribute Routing
• IHttpActionResult
• Cross Origin Resource Sharing
• Authentication and Authorization

Test Driven Development

• Introduction
• UML
• Unit Testing using NUnit
• Test Driven Development
• Test Driven Design
• Testing Controllers