ASP.NET MVC Training in Nepal

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

• 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.

• 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

• 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

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

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

• 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

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

• 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

• mplementation of StringBuilder
• Implementation of Regular Expression

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

• 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

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

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 Concept
• Read, write and delete opetaion in XML

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

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

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

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

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

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

• 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

• Client Side Validation
• Server Side Validation

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

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

• Globalization Using Resource
• Globalization Using XML Resource

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

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

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

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

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

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

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

• Incorporating ASP.NET MVC and SQL Server Reporting Service

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

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