DotNet Course

Eligibility/Duration/Course Fee

Eligibility

Graduate

Duration

4 – 6 Months

Course Fees

INR 30000.00

Payment Instructions:

  • GST 18 % applicable from 1st July
  • All payment should be in favor of “ICR India Certifications Private Limited” payable at Meerut.

Curriculum

Dot Net

The .NET framework is a software development framework from Microsoft. It provides a controlled programming environment where software can be developed.

1. C#  Dot Net

C# is an elegant and type-safe object-oriented language that enables developers to build a variety of secure and robust applications that run on the .NET Framework. You can use C# to create Windows client applications, XML Web services, distributed components, client-server applications, database applications, and much, much more. Visual C# provides an advanced code editor, convenient user interface designers, integrated debugger, and many other tools to make it easier to develop applications based on the C# language and the .NET Framework.

Basics

  • Basics of Dot Net
  • Dot Net Architecture
  • Understanding the .Net Framework and CLR
  • Memory Management in dot net
  • Dot Net 4.0 new features

ASP.NET Basics

  • NET File architecture
  • Dot net controls and configuration
  • Events for controls
  • Page Life Cycle
  • Http Modules and Handlers

ADO.NET

  • Basics of Databases, Sql, SqlServer 2005 (How to create tables, referential integrity)
  • An introduction to ADO.Net, Architecture
  • Programming using ADO.Net Api’s
  • Accessing Data using Ado.net from SqlServer Databases using both inline queries and SP
  • Populating controls using ado.net
  • Populating gridview control and repeater control
  • Grid view events
  • DataBase Related controls (ADO.net in Asp.net like gridview and repeater controls)
  • Grid View Paging and Sorting

ASP.NET

  • An Introduction to web Technologies
  • Introduction to ASP.net
  • Validation Controls
  • Directives in Asp.net
  • User Controls And Master Pages

Session and State Management

  • Difference between server side and client side state management
  • Session
  • Application
  • Profile
  • Cookies
  • Querystring
  • View state
  • Control state

Authorization and authentication

  • Login and Member Ship Controls

XML

  • An introduction to XML
  • Controls related to XML Data source
  • XML Parsing
  • XML Real Time Implementation

Scripting (JavaScript)

  • Introduction to Scripting languages
  • Importance of JavaScript
  • Attaching JavaScript code to Html and Server controls
  • JQuery
  • JSON

Navigation Controls

  • Menu
  • Tree View
  • List View
  • Hyperlinks

Send Mail using Asp.net

  • Email Configuration
  • SMTP Server configuration

Web Services

  • Basics of Web Service
  • Deployment of Web Service
  • Consuming a webservice

An introduction to C#.net(Console Applications)

  • Data types
  • Loops
  • Conditions

An introduction to classes and interfaces in C#

  • Class
  • Encapsulation
  • Abstraction
  • Constructors
  • Inheritance
  • Overloading
  • Dynamic binding
  • Interface

Exception Handling

  • Exception basics and architecture
  • User defined exception
  • Custom Exceptions

Collections and Generics

  • Collection basics
  • Types of collections and comparison
  • Generics

Advance Features of 3.5

  • Introduction to WCF
  • Introduction to MVC
  • Introduction to MVVM
  • Anonymous methods
  • Extension methods
  • Lamda Expressions
  • MSMQ

Windows Services

  • Basics of Windows service
  • Defining a windows service
  • Deploying a windows service
  • Debugging a windows service

An Introduction to Windows Application

  • Windows applications and Event Driven programming
  • Sample and Practical programs only on windows Applications
  • How to use controls like Button,TextBox,ComboBox,DialogControls

2. MVC

Model–View–Controller (MVC) is a software architectural pattern for implementing user interfaces on computers. It divides a given application into three interconnected parts in order to separate internal representations of information from the ways that information is presented to and accepted from the user.The MVC design pattern decouples these major components allowing for efficient code reuse and parallel development.

MVC Course Syllabus

  • Introduction to Asp.NET MVC
  • The Model-View-Controller Pattern
  • Differences between MVC and Web Forms Applications
  • Building a Simple MVC Application with Visual Studio
  • Working with Controllers and Actions
  • Using a Controller to Manage the Application
  • Controller Actions
  • Creating MVC Models
  • Data and Business Rules in MVC Applications
  • Creating a Custom Data Model
  • Creating an Entity Framework Model
  • Data Validation and Data Annotations
  • Using MVC Views
  • Views in ASP.NET MVC
  • Creating Views
  • Adding Content to a View
  • HTML Helpers and Action Filters
  • Using HTML Helpers in MVC
  • Creating a Custom Helper
  • Using Action Filters
  • Creating a Custom Filter
  • Routing and URLs
  • Customizing Application URLs
  • Creating Route Constraints
  • Routing and Web Forms
  • Using MVC and AJAX and jQuery
  • Introducing the AJAX and jQuery Libraries
  • Integrating Client-Side Script with MVC
  • Using the MVC AJAX Helpers
  • Working with JSON Data
  • MVC 3 Enhancements
  • New Features that Build on Old Libraries
  • The Razor View Engine
  • Controller Enhancements

 

3. SQL Server

SQL Server is used to manage and store information. Technically, SQL Server is a “relational database management system” (RDMS).The data stored inside SQL Server will be housed in a “relational database”, and that SQL Server is an entire “management system”, not just a database. SQL itself stands for Structured Query Language. This is the language used to manage and administer the database server.

Introduction To DBMS

      • File Management System And Its Drawbacks
      • Database Management System (DBMS) and Data Models
      • Physical Data Models
      • Logical Data Models
      • Hierarchical Data Model (HDBMS)
      • Network Data Model (NDBMS)
      • Relational Data Model (RDBMS)
      • Object Data Model (ODBMS)
      • Object Relational Data Model (ORDBMS)
      • Conceptual Data Models
      • Entity – Relationship (E-R) Model

Introduction To SQL Server

      • Advantages and Drawbacks Of SQL Server Compared To Oracle And DB2
      • Connecting To Server
      • Server Type
      • Server Name
      • Authentication Modes
      • Sql Server Authentication Mode
      • Windows Authentication Mode
      • Login and Password
      • Sql Server Management Studio and Tools In Management Studio
      • Object Explorer
      • Object Explorer Details
      • Query Editor

TSQL (Transact Structured Query Language) Introduction To TSQL

      • History and Features of TSQL
      • Types Of TSQL Commands
      • Data Definition Language (DDL)
      • Data Manipulation Language (DML)
      • Data Query Language (DQL)
      • Data Control Language (DCL)
      • Transaction Control Language (TCL)
      • Database
      • Creating Database
      • Altering Database
      • Deleting Database
      • Constrains
      • Procedural Integrity Constraints
      • Declarative Integrity Constraints
      • Not Null, Unique, Default and Check constraints
      • Primary Key and Referential Integrity or foreign key constraints
      • Data Types In TSQL
      • Table
      • Creating Table
      • Altering Table
      • Deleting Table

Data Manipulation Language

      • Insert
      • Identity
      • Creating A Table From Another Table
      • Inserting Rows From One Table To Another
      • Update
      • Computed Columns
      • Delete
      • Truncate
      • Differences Between Delete and Truncate

Data Query Language (DQL)

      • Select
      • Where clause
      • Order By Clause
      • Distinct Keyword
      • Isnull() function
      • Column aliases
      • Predicates
      • Between … Andv
      • In
      • Like
      • Is Null

Introduction To DBMS

      • Scalar Functions
      • Numeric Functions
      • Character Functions
      • Conversion Functions
      • Date Functions
      • Aggregate Functions
      • Convenient Aggregate Functions
      • Statistical Aggregate Functions
      • Group By and Having Clauses
      • Super Aggregates
      • Over(partition by …) Clause
      • Ranking Functions
      • Common Table Expressions (CTE)

Top n Clause Set Operators Top n Clause Set Operators

      • Union
      • Intersect
      • Except

Joins

      • Inner Join
      • Equi Join
      • Natural Join
      • Non-Equi Join
      • Self Join
      • Outer Join
      • Left Outer Join
      • Right Outer Join
      • Full Outer Join
      • Cross Join

Sub Queries

      • Single Row Sub Queries
      • Multi Row Sub Queries
      • Any or Some
      • ALL
      • Nested Sub Queries
      • Co-Related Sub Queries
      • Exists and Not Exists

Indexes

      • Clustered Index
      • NonClusteredIndexi
      • Create , Alter and Drop Indexes
      • Using Indexes

Security

      • Login Creation
      • SQL Server Authenticated Login
      • Windows Authenticated Login
      • User Creation
      • Granting Permissions
      • Revoking Permissions
      • Roles

Views

      • Purpose Of Views
      • Creating , Altering and Dropping Indexes
      • Simple and Complex Views
      • Encryption and Schema Binding Options in creating views

Transaction Management

      • Introduction
      • Begin Transaction
      • Commit Transaction
      • Rollback Transaction
      • Save Transaction
      • Role Of Log File In Transaction Management
      • Implicit Transactions

TSQL Programming

      • Drawbacks Of TSQL that leads to TSQL Programming
      • Introduction To TSQL Programming
      • Control statements In TSQL Programming
      • Conditional Control Statements
      • If
      • Case
      • Looping Control Statements
      • While

Cursors

      • Working With Cursors
      • Types Of Cursors
      • Forward_Only and Scroll Cursors
      • Static, Dynamic and Keyset Cursors
      • Local and Global Cursors

Stored Sub Programs

      • Advantages Of Stored Sub Programs compared to Independent SQL Statements
      • Stored Procedures
      • Creating , Altering and Dropping
      • Optional Parameters
      • Input and Output Parameters
      • Permissions on Stored Procedures
      • User Defined Functions
      • Creating, Altering and Dropping
      • Types Of User Defined Functions
      • Scalar Functions
      • Table Valued Functions
      • Inline Table Valued Functions
      • Multi Statement Table Valued Functions
      • Permissions On User Defined Functions
      • Triggers
      • Purpose of Triggers
      • Differences Between Stored Procedures and User Defined Functions and Triggers
      • Creating, Altering and Dropping Triggers
      • Magic Tables
      • Instead Of Triggers
      • Exception Handling
      • Implementing Exception Handling
      • Adding and removing User Defined Error Messages To And From SQL Server Error Messages List
      • Raising Exceptions Manual

CLR Integration

      • What is CLR Integration and The Steps For Implementing It
      • A Simple Example With CLR Integration

Working With XML Data Type
Backup and Restore Of Database
Attach and Detach of Database
Normalization