ASP.NET MVC is a Model-View-Controller based web application development framework which implements a front controller based design. It is lightweight, highly testable framework which splits up the business logic, database access and presentation. In ASP.NET MVC , controller controller all the interaction between View and Model . View is responsible for displaying all or a portion of the data to users. Further, Model is the lowest level of the pattern which is responsible for maintaining data. 

The biggest advantage of ASP.NET MVC are

  • Separation of concerns
  • Test Driven Development
  • Search Engine Optimization
  • Easier integration with client side tools
  • Proper Ajax
  • Easy to maintain and modify
  • Produces much leaner page

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

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

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

Broadway Infosys Nepal is one of the best inclusive computer training institutes in Kathmandu, Nepal. Established in 2008, our professional IT Training and Development center has been employing experts in this field to impart professional education to trainees. We offer well-structured complete professional training in various Programming Languages, Graphics & Multimedia, Web Designing as well as Development Training that is based upon the current recruitment needs in the IT market.

Further, we also provide training on thorough understanding of:

  • Project Requirement Identification and Analysis,
  • Software Development Life Cycle,
  • Functional Design,
  • Testing and Implementation
  • Quality Assurance

Since establishment, we have successfully established and maintained network with more than fifty IT and other companies which has made us able to offer and provide our students with internship and job opportunities.

See all Broadway Infosys Nepal courses

Contact information not available.

Courses you can instantly connect with...
Web development courses IT Training Nepal Wordpress Training Broadway Infosys Nepal PhoneGap Training Broadway Infosys Nepal

Is this the right course for you?

Rate our content

Didn't find what you were looking for ?

or