Dotnet Training

The main objective of this .Net online course is to make you fundamentally knowledgeable in the below areas:

• VS.NET IDE
• Object-Oriented Concepts
• .Net Framework
• XML IN .NET
• Error Handling
• ADO.Net Components
• Object-Oriented Concepts
• Implementation Of ADO.NET

• .Net framework has been used by more than 17,000 organizations globally and the count is increasing day by day. 
• Top MNC’s such as Mindtree, Vodafone, Samsung and a lot more other companies are offering employment opportunities. 
• According to Payscale.com the average salary received by a .Net professional is $97,393 per year.

Following are the professionals who get benefited from learning this skill.

• IT Experts
• Testing engineers
• Web developers
• Software engineers

There are no special prerequisites to enrol into this course but having basic technical knowledge is essential.

Yes, upon the successful completion of the .Net course you will get the course completion certificate form the SK Trainings. This Certificate is valid across all the top organizations and simplifies your job search process.

• What's New in SQL Server?
• SQL Server Editions
• Installing SQL Server
• Internals of Sql Server Database
• What is Sql server Management studio(SSMS )

• Introducing SQL Server Management Studio
• Creating a Database
• Adding Tables
• Creating Indexes and Constraints
• Alteration of Table Design

• What is T-SQL?
• Syntax Conventions
• Executing SQL Statements
• Identifiers
• Creating Data Types
• Operators
• Variables
• Using T-SQL to Build and Alter Objects
• Using Stored Procedures
• Using Functions
• Using Views
• Transactions
• Error Handling

• INSERT queries
• UPDATE queries
• DELETE queries
• The SELECT Clause
• The FROM Clause
• The WHERE Clause
• The ORDER BY Clause
• Using GROUP BY and HAVING
• Using TOP N and TOP N PERCENT
• SELECT INTO queries

• ADO.NET Overview
• .Net Data Providers
• Connected & Disconnected Architecture
• Using Data Readers
• Datasets
• Data Tables
• Data Adapters
• Data Bindings with Controls
• DataGridView Controls
• Managing Connection Pooling
• Working with Transactions

• Introduction to Client side & Server side programing
• What is ASP.NET
• Page Life Cycle
• Page Layout
• Working with Server Controls
• Validation controls
• Navigation controls

• Basics of Html
• Designing WebPages using Html
• HTML Tags & Forms Elements
• Designing CSS & Implementation
• Basic of JavaScript
• JavaScript Variables & Operators
• Programming with JavaScript

• Master Pages
• Themes
• Creating User Controls

• Data Sources
• Data Control (Gridview,Repeater)
• Parameterized Queries
• Updating Bound Controls

• Page Level Exceptions
• Site Level Exceptions
• Custom Error Pages

• Viewstate,Query Strings ,Cookies
• Session & Application objects

• Deployment & Configuration
• Introduction to AJAX
• Project (Additional )
• Knowledge on TFS version Control (Additional )

CTS stands for Common Type System. It follows certain rules according to which a data type should be declared and used in the program code. CTS also describes the data types that are going to be used in the application. We can even make our own classes and functions following the rules in the CTS, it helps in calling the data type declared in one program language by other programming languages.

Common language specification helps the developers to use the components that are inter-language compatible with certain rules that come with CLS. It then helps in reusing the code in other .NET compatible languages.

Response.Output.Write() is used to get the formatted output.

• BCL is a base class library of classes, interfaces and value types
• It is the foundation of .NET framework applications, components, and controls
• Encapsulates a huge number of common functions and make them easily available for the developers
• It provides functionality like threading, input/output, security, diagnostics, resources, globalization, etc.
• Also serves the purpose of interaction between user and runtime
• It also provides namespaces that are used very frequently. for eg: system, system.Activities, etc.

An assembly is a physical grouping of logical units whereas namespace groups classes. Also, a namespace can span multiple assemblies as well.

MSIL is the Microsoft Intermediate Language, it provides instructions for calling methods, storing and initializing values, memory handling, exception handling and so on. All the .NET codes are first compiled to Intermediate Language.

Following are the components of .NET

• Common Language run-time
• Application Domain
• Common Type System
• .NET Class Library
• .NET Framework
• Profiling

CLR stands for common language run-time, it is an important component of the .NET framework. We can use CLR as a building block of various applications and provides a secure execution environment for applications.

Whenever an application written in C# is compiled, the code is converted into an intermediate language. After this, the code is targeted to CLR which then performs several operations like memory management, security checks, loading assemblies, and thread management.

JIT is a compiler which stands for Just In Time. It is used to convert the intermediate code into the native language. During the execution, the intermediate code is converted into the native language.

Response.Redirect basically redirects the user’s browser to another page or site. The history of the user’s browser is updated to reflect the new address as well. It also performs a trip back to the client where the client’s browser is redirected to the new page.

Whereas, Server.Transfer transfers from one page to the other without making any round-trip back to the client’s browser. The history does not get updated in the case of Server.Transfer.

It is an acronym for Language integrated query which was introduced with visual studio 2008. LINQ is a set of features that extend query capabilities to the .NET framework language syntax that allows data manipulation irrespective of the data source. LINQ bridges the gap between the world of objects and the world of data.

All web forms are inherited from page class.

In C#, we can use the sealed keyword to prevent a class from being inherited.

• MDI( Multiple Document Interface): An MDI lets you open multiple windows, it will have one parent window and as many child windows. The components are shared from the parent window like menubar, toolbar, etc.
• SDI( Single Document Interface): It opens each document in a separate window. Each window has its own components like menubar, toolbar, etc. Therefore it is not constrained to the parent window.

Garbage collector feature in .NET frees the unused code objects in the memory. The memory head is divided into 3 generations:

• Generation 0: It stores short-lived objects.
• Generation 1: This is for medium-lived objects.
• Generation 2: It stores long-lived objects.

A delegate in .NET is similar to a function pointer in other programming languages like C or C++. A delegate allows the user to encapsulate the reference of a method in a delegate object. A delegate object can then be passed in a program, which will call the referenced method. We can even use a delegate method to create a custom event in a class.

MVC stands for model view controller which is an architecture to build .NET applications.

Model: They are the logical part of any application that handles the object storage and retrieval from the databases for an application.
View: View handles the UI part of an application. They get the information from the models for their display.
Controller: They handle the user interactions, figure out the responses for the user input and also render the view that is required for the user interaction.

ASP.NET introduces a concept of application domain or AppDomain which is like a lightweight process that acts like both container and boundary. The .NET run-time uses the AppDomain as a container for data and code. The CLR allows multiple .NET applications to run in a single AppDomain.

EXE and DLL are assembly executable modules.

EXE: It is an executable file that runs the application for which it is designed. When we build an application, an exe file is generated. Therefore the assemblies are loaded directly when we run an exe. But an exe file cannot be shared with other applications.
DLL: It stands for dynamic link library that consists of code that needs to be hidden. The code is encapsulated in this library, an application can have many DLLs and can also be shared with other applications.

Following are the events in the page life cycle:

• Page_PreInit
• Page_Init
• Page_InitComplete
• Page_PreLoad
• Page_Load
• Page_LoadComplete
• Page_PreRender
• Render

Role-based security is used to implement security measures based on the role assigned to the users in the organization. Then we can authorize users based on their roles in the organization. For example, windows have role-based access like user, administrators, and guests.

During the passport authentication, it first checks the passport authentication cookie, if the cookie is not available the application redirects to the passport sign on page. Passport service then authenticates the details of the user on the sign on page and if they are valid, stores them on the client machine and then redirects the user to the requested page.