What is Microsoft dynamics CRM ?

What is Microsoft Dynamics CRM ?

Microsoft Dynamics CRM is a customer relationship management system developed by Microsoft which allows organizations to focus on customer relationship. This Products mainly focus on below sectors.

  • Marketing – Manages marketing related activity for an organisation
  • Sales – Manages Sales related activity for an organisation
  • Services – Manages all services activities for an organisation

Microsoft Dynamics CRM is a XRM platform So All Microsoft partners can customize the system as per their requirements and use it as proprietary

Microsoft Dynamics CRM exists in market in two formats

  • Cloud Based Online CRM.
    • Online CRM
    • Backend Processes like Server App Server , Database Server , Deployments Managed by Microsoft
    • Quickly Implementation
    • Limited Plan 5 GB , 10 GB etc.
    • Auto Update
  • On Premise Offline CRM.
    • Deployed on Target Customer Servers
    • Backend Processes like Server App Server , Database Server , Deployments Managed by Customer
    • Time Taken Implementation
    • Better Customization capabilities
    • Unlimited Space
    • Separately Update by System Administrator

Microsoft Dynamics CRM Features

  • Create as many users as you want
  • Define roles to users
  • Define rights to users/Roles/Team
  • Manages All Marketing related activities
  • Manages All Sales activities
  • Manages all services related activities

Microsoft Dynamics CRM Terminology

  • Sales Module Terminology – Covers complete sales life cycle.
    • Leads – Represents individual or organization which can lead to potential customer
    • Opportunity – When lead shows an interest -> convert to opportunity. Opportunity having 2 status Won or Lost
    • Accounts- Represents an organisation which has relations. Won Opportunities converted into accounts or contacts
    • Contacts – Represent an individual which has relations with organization. Maximum contacts are customer of organization
    • Competitors – Stores All the competitor of organisations
    • Products – Stores all products information for organisations
    • Quote – Quotation of products/services to customers
    • Order – If Quotation sent to customer is accepted results to an order
    • Invoices- When billing is generated against order results to an invoice
  • Marketing Module Terminology
    • Marketing List – Provides mechanism to interact with contacts, Accounts, Leads by sending promotional emails , age group marketing , newsletter , SMS , Promotional content , special content
    • Campaign – Campaign are advertisements for getting business
    • Quick Campaign – Campaign which is done for particular purpose
  • Service Module Terminology
    • Cases – Track complete process of a ticket system
    • Knowledge Base – master repository of all common Frequently asked questions
    • Contracts – Works with cases indicating all active contracts
    • Resources/Resources Group – Resources are used to resolve all customer cases. Can be Team, Tools , People etc. which are used to resolve customer issues.
    • Services – All organisation services offered to clients
    • Services Calendar -maintains all  services schedules/timing  for organisation employee
  • Activity Module
    • Phone Call
    • Email
    • Task
    • Appointment
    • Recurring Appointment
    • Letter
    • Fax
    • Campaign Response
    • Campaign Activity
    • Service Activity
    • Custom Activity

What is Entities in CRM ?

Entities represents a record having complete information of business data. Entities are equivalent to database table. It is of two types

  • Out of box Entities – Comes by default With CRM
  • Custom Entities – Created by user with customization

Let us take an example , Suppose you have to maintains all records of your files which your customer has gone through. So Microsoft Dynamics CRM gives Contacts ( out of the box)  Feature to stores all the information of customer but there is no out of box feature to maintain Files information So for this you will create a new entity named files.

You can create new entity using customization module given in Microsoft dynamics 365 Application.

Steps to create entity is as below

Step 1 − Click the top ribbon button followed by Settings option. Click Customizations option from the Customization section.

Step 2 − Now click Customize the System option.

Step 3 − Expand the Entities option from the left panel.

Step 4 − Now click New → Entity.

Step 5 − In the Entity Form, enter the Display Name as FileInfo and PluralName as FilesInfo.

Select Area where we want to show this Entity in Sales, Service, and Marketing tabs of CRM.

Step 6 − Click on the Save and Close icon. This will create a new entity in CRM database.

 

About Microsoft Dynamics 365 Admin Center 

Microsoft Dynamics 365 admin center provides below some admin level configurations setting

Instances – It shows all the instances like production instance , sandbox instance etc. We can purchase as many instance as we want.

Updates –  Here we can see if any update is there for Microsoft Dyanmics 365.

Service Health – This module is used to check the health of system.

Backup & Restore – Microsoft Dynamics 365 backup exists there and we can restore it at any time

Billing Module – All Billing part is covered under this module. It contains licenses information, Licenses Bill & Payments , Bill Accounts , Payment Methods, All billing notifications

Users : This module is used to create multiple users who can access now our system with given username and password . We can assign any product license.

Active Users : Users who is allowed to login into Microsoft Dynamics CRM

Support : We can raise tickets with Microsoft for any type of queries

Settings

Services & Add in : Here is all Services and add in mentioned are there

Security & Privacy – Here admin can set for users auto notifications for password. Also admin can set for password validity

Organisation Information – Here Admin can see the his/her organisation information

Partners Relationship – This contains the partner information who is actually provide us the service

Products – Here is the list of all products which we have taken subscription from Microsoft

Domains – Here we can see the list of all domain which we have shared with Microsoft during the creation of account. We can add as many domains we want .

 

* The Content stated above is for informational purpose only. Expert Software Team is not responsible if any part of content found meaningless in any manner or condition.

Database Testing Interview Questions

Database Testing Interview Questions

Here are some Database testing interview question if a test Engineer is having understanding of all below testing questions then he/she can say himself/herself good in Database testing basics. web testing is having good scope and done by manual test engineers as well as automation test engineer. Below are some common interview questions

Before going further into web testing concept we should have knowledge of below

  • Database Basics
  • SQL
  • Normalizations
  • DDL
  • DML
  • Constraints
  • Tables
  • Schema
  • Views
  • Indexes
  • Stored Procedures
  • Triggers
  • Functions
  • Privileges

Some Database testing common interview questions are as below

What is Database testing?

What are Constraints ?

What is foreign Key Constraint?

What is difference between primary key and foreign key ?

What is difference between primary key and unique key ?

What is check Constraint?

What is Transactions ? – For data consistencies , Rollback , commit, savepoint

What is the SQL injection ?

What is difference in INNODB and MYISAM?

What are joins ?

  • Left Join
  • Right Join
  • Equi Join
  • Self Join
  • Cross Join

What are indexes? – Created on columns to improve performance of fast data retrieval

  • B-Tree index
  • Bitmap index
  • Clustered index
  • Covering index
  • Non-unique index
  • Unique index

What are the difference between clustered and non clustered index ? There can be only 1 clustered index in a table

What is Distinct Keyword ?

What is order by clause?

what is Group By  clause?

What are loose inserts in database testing? How this can be converted to a bug ?

What are stored Procedures?

What are Functions ?

What is difference between Stored Procedures and function?

What are trigger?

What are DML ? which impacts on data like update insert delete

What are DDL ? which impacts on table structure like Create Alter drop truncate

What is DCL/ Privileges ?  – Grant Revoke

What are views ?

What is Black Box Testing ? Perform action in frontend and check backend table to validate data

What is White Box Testing? checking all the logic and data

How to test database stored procedures and triggers?

What is difference between delete and Truncate ?

What is difference between drop and Truncate ?

What is normalization?

What is Cursor ?

What are basic points to test in database testing ?

  • Database Connection
  • Constraints
  • Front end App with Database Field and its size
  • Front end Data Retrieval accuracy
  • Data Insertion
  • Stored Procedures
  • Functional flow

What is Union , Minus , Union All Intersect ?

What is composite Primary Key ?

What type of common bugs are there in database testing ?

 

 

* The Content stated above is for informational purpose only. Expert Software Team is not responsible if any part of content found meaningless in any manner or condition.

Web Testing Interview Questions

Web Testing Interview Questions

Here are some Web testing interview question if a test Engineer is having understanding of all below testing questions then he/she can say himself/herself good in web testing basics. web testing is having good scope and done by manual test engineers as well as automation test engineer. Below are some common interview questions

Before going further into web testing concept we should have knowledge of below keywords

  • Test Environmet Architecture
  • Client
  • Server
  • Browsers
  • DOM
  • Cookies
  • Sessions
  • Redirections
  • HTTP / HTTPS Protocol

 

What is Browser Compatibility Testing?

What is SQL Injection Testing?

What is Client Server Architecture?

What is Cookies ?

What is Sessions?

What is Difference between Cookies and Sessions?

What is the scope of web testing ? – Performance testing , load testing , environment testing , functional testing , API testing, browser compatibility testing , Security Testing , Database Testing , Usability Testing , Interface testing

Common issues in web testing ?

What is difference between HTTP and HTTPS?

Http : Hypertext Transfer Protocol – Set of rules passing information from client to Server. Uses port 80

HTTPS : Hypertext Transfer Protocol using SSL- Secure Sockets Layer – or Using TSL Transport Layer Security. Uses port 443

What is cross site Scripting ?

 

* The Content stated above is for informational purpose only. Expert Software Team is not responsible if any part of content found meaningless in any manner or condition.

Manual Testing Interview Questions

Manual Testing Interview Questions 

Here are some manual testing interview question if a test Engineer is having understanding of all below testing questions then he/she can say himself/herself good in manual testing basics. Manual testing is having its own scope and done by test engineers. Below are some common interview questions

What is Software Testing ?

Software testing means developed product meets the users’ requirements

What is Verification ?

There is always some standard defined for software product development by organization. So Is product  is developing as per the specifications and using the standard development processes. The process comprises the following activities:

  • Inspections
  • Reviews
  • Walk-throughs
  • Demos

What is Validation ?

We do validation on developed product to find bugs this covers below testings

  • Functional Testing
  • Non Functional Testing

What is difference between verification and validation?

What is Agile Methodology?

Agile Methodology is a software testing process that evaluates software from the customers’ point of view. In this methodology ,  development team and QA team can start together on project . There is no need that development team complete coding for starting QA. There will be requirement of continuous customer interaction.

What is Sprint?

 

What is Sprint Size?

What is Spill Over ?

What is Product Backlog ?

What is User Stories ?

What is Black Box Testing?

What is White Box Testing?

What is Test Plan?

What is Test Coverage ?

What is equivalence Partitioning ?

What is boundary value analysis?

What is Unit Testing?

What is Functional Testing?

What is Integration Testing?

What is System Testing?

What is UAT – User Acceptance Testing?

What is Smoke Testing?

What is Sanity Testing?

What is Regression Testing?

What is Retesting?

What is difference between Regression Testing and Retesting?

What is Performance Testing?

What is load Testing?

What is Stress Testing?

What is Data Flow Testing?

What is end to end Testing?

What is Alpha Testing?

What is Beta Testing?

What is Bug Life Cycle?

What is bug , Defect , Error ?

What is severity and priority ?

Give an example of low severity and high Priority ?

Give an example of low severity and low Priority ?

Give an example of high severity and high Priority ?

Give an example of high severity and low Priority ?

What is QA – Quality Assurance ? – We monitor process

What is QC – Quality Control ? – Process implemented by QA implemented by QC

What is bug leakage ? – when the bug is discovered by the end user/customer and missed by the testing team

what is Bug release? – when software is released with a set of known bugs

What is Monkey Testing ? – Checking behavior of software by random inputs and trying to crash application.

 

* The Content stated above is for informational purpose only. Expert Software Team is not responsible if any part of content found meaningless in any manner or condition.

Common Software Testing Interview Questions

Common Software Testing Interview Questions

All Test Engineer need the common questions which can be asked in interview. Below are few Interview Questions Categories

Manual Testing Interview Questions

Web Testing Interview Questions

API Testing Interview Questions

Database Testing Interview Questions

Automation Testing Interview Questions

Selenium Testing Interview Questions

Unified Functional Testing Interview Questions

Security Testing Interview Questions

Common Process Related Interview Questions

 

* The Content stated above is for informational purpose only. Expert Software Team is not responsible if any part of content found meaningless in any manner or condition.

What is C# (C Sharp) ?

What is C#  (C Sharp) ?

C# is a general-purpose, modern and object-oriented programming language pronounced as “C sharp”. C# is a programming language of .Net Framework.C# is an object-oriented programming language derived from C++ and Java. C# allows developers to build applications using Visual Studio on .Net platform. C Sharp supports below type of applications

  • Window applications
  • Web applications
  • Distributed applications
  • Web service applications
  • Database applications etc.

Our C# tutorial includes all topics of C#

  • Control statements
  • Objects and classes
  • Inheritance
  • Constructor
  • Destructor
  • Polymorphism
  • Abstraction
  • Abstract class
  • Interface
  • Namespace
  • Encapsulation
  • Properties
  • Indexer
  • Arrays
  • Strings
  • Regex
  • Exception handling
  • Multi threading
  • File IO
  • Collections

Below is C# example program to print Expert Software Team

using System;
namespace Expertsoftwareteam{
class Demoexample {
static void main(){
    Console.WriteLine("Expert Software Team");
	}
  }
}
  • A namespace is a collection of multiple classes. Each namespace is declared with keyword ‘using’.
  • The first statement of the code includes the namespace ‘System’ into our program. System namespace defines the fundamental classes and events used in C#. The namespace to be used depends on the program requirement.
  • The second statement is declaring a namespace “Expertsoftwareteam” for the class “Demoexample” A C# file can contain multiple classes within the same namespace.
  • The third statement includes the class declaration. A class may contain multiple attributes and multiple methods.
  • The fourth statement includes a declaration of the Main method. The main method is the entry point of execution for each class.
  • The last statement is the C# syntax used for printing a statement to console. WriteLine is a method of the class ‘Console.

 

* The Content stated above is for informational purpose only. Expert Software Team is not responsible if any part of content found meaningless in any manner or condition.

How to Download and install Selenium Web Driver ? 

How to download and install selenium web driver ?

All the engineers who want to work on selenium they are having query How to download and install selenium web driver. How to create setup for selenium testing. A lot of queries is there in mind of engineers. Lets give some light on this

Prerequiste for Selenium Web Driver installation

For Java

Step 1 : Download Java : Download java software development kit from Java Official Website

Step 2 : Install Java : Install Java by following instructions from java Official Website 

Step 3 : Download Eclipse IDE : Download Eclipse latest version from Eclipse Official Website

Step 4 : Install Eclipse IDE : Install Eclipse

  • Double click on downloaded setup
  • Select Eclipse IDE for Java Developers
  • Select Path to install. In our Case it is “C:\eclipse”
  • Click on Install Button
  • Wait for Installation
  • Click on Launch to launch Eclipse

Step 5 : Download Selenium java Client Driver from Selenium Official Website

  • Results to download zip file
  • Extract Zip file to C Drive
  • This Directory contains multiple jar files
  • Will be imported into Eclipse for selenium project

Step 6 : Configure Eclipse and IDE Driver

  • Launch Eclipse exe file from eclipse installed location. In our case it is “C:\eclipse”
  • Select Workspace location
  • Create a new project through File > New > Java Project.
  • Name the project as “newproject”
  • Project Name
  • Location to save project
  • Select an execution JRE
  • Select layout project option
  • Click on Finish button
  • Right Click on Newly Created Project in Eclipse
  • Enter Package Name in our case it is newpackage
  • Click Finish
  • Right Click on package name i.e. newpackage
  • Create a new Java class
  • Enter Class Name
  • Click Finish

Step 7 : Load Selenium Jar Files into Project

  • Right-click on “newproject”
  • select Properties.
  • Click on “Java Build Path”.
  • Click on the Libraries tab
  • Click on “Add External JARs..”
  • On pop-up window.
  • Open lib folder
  • Select all jar files and add it
  • Select files outside lib folder
  • click “Apply and Close” button
  • Click OK
  • Import Selenium Libraries Done

Step 8 : Installing Browser Drivers

For HTMLUnit and Firefox there is no need of separate component as web driver can directly communicate But for all other browsers like chrome , internet explorer etc. there is need of separate component called Driver Server 

In Selenium latest version , All browsers need a driver server to automate

We can officially download drivers from Selenium official website

For C#

 

* The Content stated above is for informational purpose only. Expert Software Team is not responsible if any part of content found meaningless in any manner or condition.

What is Selenium Web Driver ?

What is Selenium Web Driver ?

Selenium WebDriver is a web automation framework that allows you to execute your tests against different browsers, not just Firefox, Chrome (unlike Selenium IDE).

WebDriver allows engineers to use a programming language in creating your test scripts which is not  possible in Selenium IDE.

Engineers can now use iterations logics and conditional operations.

This platform supports multiple languages Java, C#, PHP, Python, Perl, Ruby

Pros

  • Simple installation compared to RC.
  • Communicates directly to Browser Unlike RC.
  • Browser Interaction is more realastics.
  • Fast Execution time than IDE and RC.

Cons

  • Installation is complicated than IDE.
  • Need Knowledge of Programming.
  • Can not support new browsers.
  • Has to code for test results and logs.

Summary

  • Selenium WebDriver is a tool for testing web applications across different browsers using different programming languages.
  • WebDriver allows engineers to use a programming language in designing your tests thus give power to script.
  • WebDriver is faster than Selenium RC because of its simpler architecture.
  • WebDriver directly talks to the browser.
  • WebDriver’s API is more concise.
  • WebDriver can support HtmlUnit.
  • Web Driver cannot readily support new browsers.
  • Web Driver does not have a built-in command for automatic generation of test results.

* The Content stated above is for informational purpose only. Expert Software Team is not responsible if any part of content found meaningless in any manner or condition.

Selenium Tutorials for beginners

Selenium Tutorials for beginners

Selenium is the open source web based automation tool. In this tutorials you will cover basics as well as advance features. Below are few topics which we are going to cover

What is Selenium ? Brief introduction about Selenium

What is Selenium Web Driver ?

How to Download and install Selenium Web Driver ? 

What is C# ?

 

 

* The Content stated above is for informational purpose only. Expert Software Team is not responsible if any part of content found meaningless in any manner or condition.