Website: www.gracetech.co.in Mo-: +91- 9355666115, 9355666116 Page 1

Training | Development | Placement

.NET Core and Advance Course Content

Introduction to .Net Framework

What is .NET

Why .NET

Advantages of .NET

.DNA Architectures

Three Tier

N-Tier

C# 6.0 Syntax and Data types

C# Program Structure

Defining Namespace

Understanding C# Data Types

Defining Variables

Comparing Value Types and Reference Types

Working with Operators and Expressions

Conditional, Looping, Jumping statement in c#

Array

One dimensional array

Tow dimensional array

Jagged array

Function

User define function

System define function

Regular expression

Random class

Website: www.gracetech.co.in Mo-: +91- 9355666115, 9355666116 Page 2

Object Oriented Programming (OOPS)

Overview of Object-Oriented Programming

Defining and Using Classes and objects

Member of class

Constructor

Destructor

Property

Method

Indexer

Static member

Oops Pillars

-Inheritance

-Polymorphism

-Abstraction

-Encapsulation

interface

Collections

Understanding .NET Collections

Types of Collections

Working with Array list and Hash table

Stack

Queue

Generic collection

o List

o Stack

o Queue

o Sorted list

o Hash table

Website: www.gracetech.co.in Mo-: +91- 9355666115, 9355666116 Page 3

Generic

o Generic class

o Generic methods

Events

Delegates

o Single cast delegates

o Multicast delegates

Multithreading

Managed code

Safe code

Exception Handling

What are Exceptions?

.Net Exception Hierarchy

Catching Exception

Throwing Exception

Finally

File handling

ADO.NET Introduction to ADO.NET

Understanding the ADO.NET Object Model

Difference between ADO and ADO.NET

Connected vs. Disconnected architecture

Using a Connection to connected to a Data Source

Using a Command to execute Queries and stored Procedures

Sql injection

Preventing with sql injections

Website: www.gracetech.co.in Mo-: +91- 9355666115, 9355666116 Page 4

Using a Data Reader to Work with Cursors

Sql server 2008/1012

Introduction To DBMS

File Management System And Its Drawbacks

Database Management System (DBMS) and 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

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

Website: www.gracetech.co.in Mo-: +91- 9355666115, 9355666116 Page 5

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 … And

In

Like

Is Null

Built In Functions

Scalar Functions

Numeric Functions

Character Functions

Conversion Functions

Date Functions

Aggregate Functions

Group By and Having Clauses

Over(partition by …) Clause

Ranking Functions

Common Table Expressions (CTE)

Top n Clause

Website: www.gracetech.co.in Mo-: +91- 9355666115, 9355666116 Page 6

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

ALL

Nested Sub Queries

Exists and Not Exists

Indexes

Clustered Index

NonClustered Index

Create , Alter and Drop Indexes

Using Indexes

Views

Purpose Of Views

Creating , Altering and Dropping Indexes

Simple and Complex Views

Transaction Management

Introduction

Begin Transaction

Commit Transaction

Rollback Transaction

Save Transaction

Role Of Log File In Transaction Management

Implicit Transactions

Website: www.gracetech.co.in Mo-: +91- 9355666115, 9355666116 Page 7

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

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

Asp.net 4.6 Framework

Introducing Asp.Net

Overview of Asp.Net 4.6

Working with Web Forms

Http protocol

Website: www.gracetech.co.in Mo-: +91- 9355666115, 9355666116 Page 8

Static and dynamic page

Difference between asp and asp.net

Introducing of HTML

Creating a simple html Page

Html tags

Html form

Html form with html5

Table

Html R.W.D. approach

Html 5 media

Html 5 object and plugin

Html frame

Html 5 Google map

Html 5 validation

IIS

Working with JavaScript and j-query

Using JavaScript

JavaScript get and set

JavaScript getting object using different approach

JavaScript string

JavaScript date and time

JavaScript array

Array matator and non-mutator

Multi D array

JavaScript object

JavaScript json

Website: www.gracetech.co.in Mo-: +91- 9355666115, 9355666116 Page 9

JavaScript function

Creating function using different approach

Validation using JavaScript

J-query:

Using j-query with different approach

J query effects

J query animation

J query DOM manipulation

J query BOM Manipulation

Validation using j-query

Using Ajax

Working with bootstrap

Understanding bootstrap

Using bootstrap classes

Using grid system

Using other features of bootstrap

Maintaining State Management

Understanding why the web is Stateless

Maintaining State within Asp.Net Applications

Introduction of Stateless Process

Controls

Working with HTML Controls

Working with Web Controls

Creating Controls at Runtime

Custom User Controls

Http Cookies

Website: www.gracetech.co.in Mo-: +91- 9355666115, 9355666116 Page 10

Non persistence

Persistence

Third Party

Single Value

Multi Value

Http Session

Understanding the Session

Session Setting in Web.Config file

InProc or OutProc Session management

Session State using SqlServer

Session State Mode

Session State Using State Service

Master Pages

Understanding the Master Page

Designing a Master Page

Designing Content Pages

Data Binding controls

Formatted or Unformatted Controls

Using List Box Controls

Using Grid View Controls

Using Details View Controls

Using Form View Controls

Working with linq

Working with linq-sql

Designing Work with Look and Feel

Skin – Theme and CSS

Creating Style Sheet

Website: www.gracetech.co.in Mo-: +91- 9355666115, 9355666116 Page 11

Apply Style Sheet

Using Templates

Securing Asp.Net Application

Understanding the Asp.Net 4.5 Security Models

Form Security

Window Security

Passport Security

Locking and unlocking user account

Unlocking account using manual grid view

Automatic unlocking

Sending email and password recovery

Recover password using email

Recover password using current password

Recover password using O.T.P.

Project work

Understanding project scenarios

Designing project

Coding project

Testing project

Hosting project/ deploying project

MODEL VIEW CONTROLLER (M.V.C.)

1. Overview of the ASP.NET

Introduction of different Web Technology

What is ASP.NET MVC

How ASP.NET MVC Works

M.V.C. pattern

Website: www.gracetech.co.in Mo-: +91- 9355666115, 9355666116 Page 12

Benefits of using ASP.NET MVC

1. Setting up and Installing ASP.NET MVC

Installing Internet Information Server

Installation of ASP.NET MVC

Application Setting in IIS.

2. Working With Microsoft SQL Server 2014

Overview of SQL Server 2014

Installation of SQL Server 2014

Features of SQL Server Express

SQL Server 2014 Express management tools

3. Getting Started with MVC

ASP.NET MVC project templates

Understanding the structure of an ASP.NET MVC project

Naming conventions

Creating views

Defining controllers

Defining a data model

Data transferring from controller to view using view data

Data transferring from controller to view using view bag

Data accessing using entity framework.

Working with two table using entity framework

Overview of coding standards follows during programming

5. Creating an application in MVC

Creating strongly-typed views

Understanding URLs and action methods

Using HTML helpers

Handling form post-backs

Data validation

5. Razor View Engine

Razor Basics

Website: www.gracetech.co.in Mo-: +91- 9355666115, 9355666116 Page 13

Razor design goals

Implementation of Razor view

Razor syntax

Accessing Model Data in Razor views

6. Strength ASP.NET MVC Applications

ASP.NET application architecture best practices

Implementing a Repository and Entity Framework Data Model

Using Dependency Injection

Implementing a custom controller factory

8. View Techniques

Using bootstrap in M.V.C.

Defining and using custom HTML Helpers

Defining a layout / MVC Master Page

Using Styles

Defining and using partial views

Razor Helper Method syntax

9. Implementing Navigation in MVC web apps

10. Working with entity framework

Understanding entity framework

Data accessing using entity framework

Using code first approach

Using model first approach

Using database first model

11. Implementing Data Filtering in a Controller

12. Understanding the Routing mechanism

13. Adding custom entries to a route table

14. Defining defaults, parameters, and validation

15. Generating URLs and Hyperlinks

16. Custom Route constraints

17. MVC State Management

18. Using hidden fields

Website: www.gracetech.co.in Mo-: +91- 9355666115, 9355666116 Page 14

19. Session and Application State

20. Custom model bindings

21. Using AJAX and jQuery with ASP.NET MVC

Overview of AJAX and ASP.NET MVC

Unobtrusive AJAX

Using AJAX Action Links

Overview of jQuery

jQuery Techniques

Using jQuery UI

22. ASP.NET Web API with MVC

Overview of the ASP.NET Web API

Building servers and clients

Content negotiation

23. Query able Interfaces

24. Dependency Injection

25. Working with Areas

Setting Up Areas

Actions in Areas

Routing and URL Generation with Areas

26.

27.

28.

29.

FTP Management

Understanding FTP

Uploading and downloading FTP contents

Sending Emails

Website: www.gracetech.co.in Mo-: +91- 9355666115, 9355666116 Page 15

30. Designing email panel

31. How to send an email to various users

32. Sending auto emails

33. Deployment

Deploying application on Web Server

34. Live Project

Getting customer’s requirements

Preparing database and business logics

Developing application

Testing and implementing the project

Troubleshooting the project application after implementation

Summary

Windows Communication Foundation (W.C.F.)

1 - Introduction to WCF

2 - Creating a remoting service and a web service

3 - Creating a wcf service

4 - WCF service implementing multiple service contracts

5 - How to make changes to wcf service without breaking clients

6 - WCF Data Contract and Data Member

7 – Known Type attribute in WCF

8 - Different ways of associating known types in wcf

9 - How to enable tracing and message logging in wcf

10 - Message Contract in WCF

11 - Difference between datacontract and messagecontract in wcf

12 - Backward compatible WCF contract changes

13 – Extension DataObject in WCF

14 - Risks of implementing IExtensibleDataObject interface

15 - Exception handling in WCF

16 - SOAP faults in WCF

17 - Unhandled exceptions in WCF

Website: www.gracetech.co.in Mo-: +91- 9355666115, 9355666116 Page 16

18 - Throwing fault exceptions from a WCF service

19 - Creating and throwing strongly typed SOAP faults

20 - Centralized exception handling in WCF

21 - Bindings in WCF

22 - Configure WCF service endpoint dynamically in code

23 - Hosting WCF service

24 - Self hosting a wcf service in console application

25 - Self hosting a wcf service in winforms application

26 - What is a windows service

27 - Hosting a wcf service in a windows service

28 - Advantages and disadvantages of hosting a wcf service in a windows service

29 - Hosting wcf service in IIS

30 - Advantages and disadvantages of hosting WCF Service in IIS

31 - WAS hosting in WCF

32 - Message Exchange Patterns in WCF

33 – One-Way Message Exchange Pattern in WCF

34 - Duplex message exchange pattern in WCF

35 - Sending large messages in WCF using MTOM

36 - Instancing modes in WCF

37 - PerCall instance context mode in WCF

38 – Per-Session instance context mode in WCF

39 - PerSession WCF services

40 - How to retrieve the sessionid in WCF service and in the client application

41 - Single instance context mode in WCF

Website: www.gracetech.co.in Mo-: +91- 9355666115, 9355666116 Page 17

42 - SessionMode Enumeration in WCF

43 - Single concurrency mode in WCF

44 - Multiple concurrency mode in WCF

45 - Reentrant concurrency mode in WCF

46 - WCF throttling

47 - WCF security 48 - Controlling WCF message protection using Protection Level parameter

49 - WCF bindings and the impact on message protection

50 - Authentication in WCF

51 - Message confidentiality and integrity with transport security

52 - Configure wsHttpBinding to use transport security

53 - Configure netTcpBinding to use message security

Address 4th Floor CDR Complex, Naya Bans,

Sector 15 , Noida, ( U.P) Web- : www.gracetech.co.in

Email- : info@gracetech.co.in Mob- : +91- 9355666115,

+91- 9355666116