Posts

Showing posts with the label DotnetonlineTraining

Stylesheet

Image
import * as React from 'react'; import styles from './Employeespotlight.module.scss'; import { IEmployeespotlightProps } from './IEmployeespotlightProps'; import { escape } from '@microsoft/sp-lodash-subset'; import * as $ from 'jquery'; import { WebPartContext } from '@microsoft/sp-webpart-base'; import { SPHttpClient, SPHttpClientResponse } from '@microsoft/sp-http'; import { SliderHelper } from './Helper'; export interface SpotlightDetails { userDisplayName: string; userEmail: string; userProfilePic: string; description: string; designation?: string; } export interface IStateEmployeeSlider { value:SpotlightDetails[]; } var result=[]; export interface ResponceDetails { title: string; id: string; } export default class Employeespotlight extends React.Component { private defaultProfileImageUrl: string = "/_layouts/15/userphoto.aspx?size=L"; private helper: SliderHelper = new SliderHe...
Post a Comment
Read more

SQL SERVER 2019 INSTALLATION GUIDE

Image
      Posted by Ganesan - +919042710472                                            SQL SERVER 2019 INSTALLATION GUIDE INTRODUCTION:   Microsoft products SQL SERVER developer edition is a full featured free edition. Licensed for use a development and test database in a non- production environment. Download link: https://www.microsoft.com/en-in/sql-server/sql-server-downloads Step 1:   Once completed the download the application then double click it to start the installation process.   Step 2: You have chosen the custom installation, click on “ Install”, allow the application to download and install packages. Step 3:   After all of the packages have downloaded, a new page you can see, follow the box. Click on “ Installation”.    Step 4:   After step 3, choose the first option in the list and proceed to the next step. Step 5:...
Post a Comment
Read more

SQL Vs MySQL

Image
  Posted by Ganesan - +919042710472 SQL: STRUCTURED QUERY LANGUAGE SQL or Structured Query Language is a programming language that enables the function of retrieving, managing, storing the data in the relational database management system. The condition of the SQL statement is declarative in nature and is known as SQL Query. There are different SQL clauses that can be used while writing the queries to define the purpose of action. Some of the most basic and fundamental clauses and their functions are: SELECT : Extracts data from the database UPDATE: Updates data in a databases DELETE: Deletes the data from the data set. CREATE TABLE: Create a new table in a database. CREATE DATABASE: Create a new database INSERT INTO: Insert new data into a database. ALTER TABLE : Modifies a table. WHERE: Filter records based on conditions FROM: Retrieve data from specific columns of a table. MySQL: MySQL was one of the first open source database. MySQL uses SQL queries to perform actions...
Post a Comment
Read more

ADO.NET Interview Questions and Answers

   Posted by Ganesan - +919042710472 1. What is ADO.NET? ADO.NET stands for Microsoft ActiveX Data Object. Ado.net is a database technology which we can think like a set of classes that can be used to interact with the data sources like databases and XML files. Asp.net application, windows application, console application are the few types of .net applications that use ADO.NET to connect with the databases to execute commands and retrieve data. 2. What are the key features of ADO.NET? · Disconnected data architecture · Data cached in data set · Scalability · Data transfer in HTML Format · Strongly typed language. 3. Why is it important to close an ADO.NET application? Connections need to be closed properly because it affects the scalability and reliability of the applications. Open connections are always vulnerable to attack, so to be short , ‘ open connections as late as possible and close it as early as possible’. We can close the connection by final block or using the USING...
Post a Comment
Read more

SQL Interview questions and answers for freshers

Posted by Ganesan - +919042710472  1. What is SQL?   SQL-Structured Query Language   It is a microsoft database which can be used for manipulation of datas.  2. What are the subsets of SQL?   DDL – Data Definition Language –It allows you to perform various operations on the database such as CREATE, ALTER and DELETE objects.   DML – Data Manipulation Language – It allows you to access and manipulate data. It helps you to INSERT, UPDATE, DELETE and RETRIVE data from the database.    DCL – Data Control Language – It allows you to control access to the database .example Grant, Revoke access permissions.   TCL – Transaction Control Language – Used to manage transactions in the database. Example COMMIT, ROLLBACK and SAVEPOINT. 3. How to create a table and add data   Syntax : CREATE TABLE table_name(                  Column1 datatype,                 ...
Post a Comment
Location: Chennai, Tamil Nadu, India
Read more

How to grab your first job as Dotnet developer

Posted by Ganesan - +919042710472 Engineers after completing their degree in Computers, they have to learn technologies to get into Job market. Upskilling and learning technologies is a continuous process and it will not end up.  In my point of view Engineering does not makes to land you in your first dream job. It just acts as a mere degree or a qualification expected in Software industry. Every engineer will be in a dream to pursue their first job in top MNC 's like CTS, Infosys, HCL, Wipro or any other bigger MNC. Only 10 -20 % of the engineers will get their jobs in On Campus that too in Urban areas. It’s a bitter fact that students from Rural areas are not even able to crack the MNC interviews in first shot. You will realise that grabbing a job in top mnc's as a fresher is not possible without any technical skill. The first thing that comes on to the mind after completing the studies is to pursue a job. Everyone will be in a curiosity to start earning money after completin...
Post a Comment
Read more

OOPS - OBJECT ORIENTED PROGRAMMING SYSTEM

Posted by Ganesan - +919042710472 Object oriented programming uses a different set of programming languages than old procedural programming languages. Everything in OOP is grouped as self sustainable "objects".  Main concepts of OOPs are  Class, Object, Abstraction, encapsulation, inheritance and polymorphism. CLASS: Class is a collection of objects. Class is composed of three things, a name, attributes, and operations. To create a class, you simply use the keyword "Class" followed by the Class name,            Class ClassName             {               } OBJECT:   An object can be considered a "thing" that can perform a set of related activities. The set of activities that the object performs defines the object's behaviour. For example the hand (object) can grip something. Can give their name or address. an Object is an instance of a class.           ...
Post a Comment
Read more