Md Sohail

Jubilee Hills, Hyderabad, India - 500033

Md Sohail photo

Md Sohail

Computer Professional

Jubilee Hills, Hyderabad, India - 500033.

4.9

UrbanPro Rating

Details verified of Md Sohail

Identity

Education

Know how UrbanPro verifies Tutor details

Identity is verified based on matching the details uploaded by the Tutor with government databases.

Overview

Sr., Technologist with good domain knowledge(banking) and database in Oracle PL/SQL. Total 6+ years of experience in IT Industry and 5+ years of teaching experience.

Languages Spoken

Urdu

Telugu

Hindi Mother Tongue (Native)

English Proficient

Education

JNTU 2013

Master of Engineering - Master of Technology (M.E./M.Tech.)

Address

Jubilee Hills, Hyderabad, India - 500033

Verified Info

Education Verified

Phone Verified

Email Verified

Demo Class

Yes, not charged

Report this Profile

Is this listing inaccurate or duplicate? Any other problem?

Please tell us about the problem and we will fix it.

Please describe the problem that you see in this page.

Type the letters as shown below *

Please enter the letters as show below

C Language Classes Overview

C Language Classes

Class Location

Student's Home

Tutor's Home

Online (video chat via skype, google hangout etc)

Years of Experience in C Language Classes

5

Gallery (1)

Star Performer Award

Reviews

this is test message this is test message this is test message this is test message this is test message this is test message this is test message

No Reviews yet! Be the first one to Review

Answers by Md Sohail (5)

Answered on 16 Feb CBSE/Class 10/Mathematics/UNIT V: Trigonometry/Introduction to Trigonometry IT Courses

Hi All, SSC passout students can go for MS Office and C language & Data Structures as this is basic and must for any further studies.
Answers 70 Comments
Dislike Bookmark

Answered on 25 Jan IT Courses/MS Office Software Training IT Courses/MS Office Software Training/Microsoft Excel Training

Why does VBA often recurse on it's own?

A recursive procedure is one that calls itself. In general, this is not the most effective way to write Visual Basic code.
Answers 1 Comments
Dislike Bookmark

Answered on 25 Jan IT Courses/MS Office Software Training IT Courses/MS Office Software Training/Microsoft Excel Training

What are some of the most common examples of spreadsheet applications?

Bleow are of the common spread sheet application. Google Sheets - (online and free). iWork Numbers - Apple Office Suite. LibreOffice -> Calc (free). Lotus 1-2-3 (discontinued). Lotus Symphony - Spreadsheets. Microsoft Excel. OpenOffice -> Calc (free). VisiCalc (discontinued). ...more

Bleow are of the common spread sheet application.

  • Google Sheets - (online and free).
  • iWork Numbers - Apple Office Suite.
  • LibreOffice -> Calc (free).
  • Lotus 1-2-3 (discontinued).
  • Lotus Symphony - Spreadsheets.
  • Microsoft Excel.
  • OpenOffice -> Calc (free).
  • VisiCalc (discontinued).
Answers 2 Comments
Dislike Bookmark

Answered on 25 Jan IT Courses/MS Office Software Training IT Courses/MS Office Software Training/Microsoft Excel Training

How does the evaluation context work in DAX?

The evaluation context in DAX consider two context for an expression: Filter Context: it is a set of filters applied to any iterator or aggregation function in DAX. You can imagine it as a list of values allowed for one or more columns in one or more tables. These filters can be manipulated by using... ...more

The evaluation context in DAX consider two context for an expression:

  • Filter Context: it is a set of filters applied to any iterator or aggregation function in DAX. You can imagine it as a list of values allowed for one or more columns in one or more tables. These filters can be manipulated by using DAX functions such as CALCULATE and CALCULATETABLE, which modify the filter context where a DAX expression is evaluated.
  • Row Context: it is the “current row” during a table iteration where a column reference can be evaluated. A calculated column and the expression applied to an iterator are always executed within a row context.
Answers 1 Comments
Dislike Bookmark

Answered on 25 Jan IT Courses/MS Office Software Training IT Courses/MS Office Software Training/Microsoft Excel Training

What is the Google Sheets function to extract a URL from a cell that contains text and the wanted URL?

Personally I would use MID() which is a bit shorter and more elegant function. This will find a URL anywhere within the input string - start, middle or end. For an input string in cell A2 this is the formula: =MID(A2,FIND("http",A2),FIND(" ",A2,FIND("http",A2))-FIND("http",A2)) Description of... ...more

Personally I would use MID() which is a bit shorter and more elegant function. This will find a URL anywhere within the input string - start, middle or end.

For an input string in cell A2 this is the formula:

  1. =MID(A2,FIND("http",A2),FIND(" ",A2,FIND("http",A2))-FIND("http",A2))

Description of how it works. First the MID() formula, it extracts text from a string. It takes three inputs: (1) the input string, (2) where to start extracting and (3) the length of the text to extract.

(1) The input string is the contents of cell A2.

(2) The place to start: where “http” is found, FIND(A2,”http”). The value returned to MID() will actually be at the location of the “h” in “http”. This will work for “https” urls too because they still have “http” in them.

(3) Then I do a bit of subtraction. URLs do not have any spaces in them. So if I can find the first space after the URL I can use that to get the length of the URL. I use FIND() to find a space. FIND() has an optional third argument which is to start looking at the location I desire. So I set that location to be where “http” was found using the same formula as before. Since that will return the location within the whole input string and not the length of just the URL I need to subtract from it. I subtract the location of “http” using FIND("http",A2).

Answers 1 Comments
Dislike Bookmark

Md SohailDirections

x
C Language Classes 4.9

Class Location

Student's Home

Tutor's Home

Online (video chat via skype, google hangout etc)

Years of Experience in C Language Classes

5

C++ Language Classes 4.9

Class Location

Student's Home

Tutor's Home

Online (video chat via skype, google hangout etc)

Years of Experience in C++ Language Classes

4

Proficiency level taught

Basic C++, Advanced C++

RDBMS Training 4.9

Class Location

Student's Home

Tutor's Home

Online (video chat via skype, google hangout etc)

Years of Experience in RDBMS Training

5

Subjects

PostgreSQL

Courses in RDBMS Training

Visual Basic Training 4.9

Class Location

Student's Home

Tutor's Home

Online (video chat via skype, google hangout etc)

Years of Experience in Visual Basic Training

5

Advanced VBScript Training 4.9

Class Location

Student's Home

Tutor's Home

Online (video chat via skype, google hangout etc)

Years of Experience in Advanced VBScript Training

5

Computer Course classes 4.9

Class Location

Student's Home

Tutor's Home

Online (video chat via skype, google hangout etc)

Years of Experience in Computer Course classes

5

Type of Computer course taken

Software Programming, Training in Software application usage, Training in Computer tools usage, Basics of Computer usage

Data Mining Data 4.9

Class Location

Student's Home

Tutor's Home

Online (video chat via skype, google hangout etc)

Years of Experience in Data Mining Data

5

MS Office Software Training 5.0

Class Location

Student's Home

Tutor's Home

Online (video chat via skype, google hangout etc)

Years of Experience in MS Office Software Training

5

Microsoft Excel Training classes 5.0

Class Location

Student's Home

Tutor's Home

Online (video chat via skype, google hangout etc)

Years of Experience in Microsoft Excel Training classes

5

Teaches following Excel features

Advanced Excel, Basic Excel, Excel VBA & Macro Training

Microsoft Visual Studio 4.9

Class Location

Student's Home

Tutor's Home

Online (video chat via skype, google hangout etc)

Years of Experience in Microsoft Visual Studio

5

this is test message this is test message this is test message this is test message this is test message this is test message this is test message

No Reviews yet! Be the first one to Review

Answers by Md Sohail (5)

Answered on 16 Feb CBSE/Class 10/Mathematics/UNIT V: Trigonometry/Introduction to Trigonometry IT Courses

Hi All, SSC passout students can go for MS Office and C language & Data Structures as this is basic and must for any further studies.
Answers 70 Comments
Dislike Bookmark

Answered on 25 Jan IT Courses/MS Office Software Training IT Courses/MS Office Software Training/Microsoft Excel Training

Why does VBA often recurse on it's own?

A recursive procedure is one that calls itself. In general, this is not the most effective way to write Visual Basic code.
Answers 1 Comments
Dislike Bookmark

Answered on 25 Jan IT Courses/MS Office Software Training IT Courses/MS Office Software Training/Microsoft Excel Training

What are some of the most common examples of spreadsheet applications?

Bleow are of the common spread sheet application. Google Sheets - (online and free). iWork Numbers - Apple Office Suite. LibreOffice -> Calc (free). Lotus 1-2-3 (discontinued). Lotus Symphony - Spreadsheets. Microsoft Excel. OpenOffice -> Calc (free). VisiCalc (discontinued). ...more

Bleow are of the common spread sheet application.

  • Google Sheets - (online and free).
  • iWork Numbers - Apple Office Suite.
  • LibreOffice -> Calc (free).
  • Lotus 1-2-3 (discontinued).
  • Lotus Symphony - Spreadsheets.
  • Microsoft Excel.
  • OpenOffice -> Calc (free).
  • VisiCalc (discontinued).
Answers 2 Comments
Dislike Bookmark

Answered on 25 Jan IT Courses/MS Office Software Training IT Courses/MS Office Software Training/Microsoft Excel Training

How does the evaluation context work in DAX?

The evaluation context in DAX consider two context for an expression: Filter Context: it is a set of filters applied to any iterator or aggregation function in DAX. You can imagine it as a list of values allowed for one or more columns in one or more tables. These filters can be manipulated by using... ...more

The evaluation context in DAX consider two context for an expression:

  • Filter Context: it is a set of filters applied to any iterator or aggregation function in DAX. You can imagine it as a list of values allowed for one or more columns in one or more tables. These filters can be manipulated by using DAX functions such as CALCULATE and CALCULATETABLE, which modify the filter context where a DAX expression is evaluated.
  • Row Context: it is the “current row” during a table iteration where a column reference can be evaluated. A calculated column and the expression applied to an iterator are always executed within a row context.
Answers 1 Comments
Dislike Bookmark

Answered on 25 Jan IT Courses/MS Office Software Training IT Courses/MS Office Software Training/Microsoft Excel Training

What is the Google Sheets function to extract a URL from a cell that contains text and the wanted URL?

Personally I would use MID() which is a bit shorter and more elegant function. This will find a URL anywhere within the input string - start, middle or end. For an input string in cell A2 this is the formula: =MID(A2,FIND("http",A2),FIND(" ",A2,FIND("http",A2))-FIND("http",A2)) Description of... ...more

Personally I would use MID() which is a bit shorter and more elegant function. This will find a URL anywhere within the input string - start, middle or end.

For an input string in cell A2 this is the formula:

  1. =MID(A2,FIND("http",A2),FIND(" ",A2,FIND("http",A2))-FIND("http",A2))

Description of how it works. First the MID() formula, it extracts text from a string. It takes three inputs: (1) the input string, (2) where to start extracting and (3) the length of the text to extract.

(1) The input string is the contents of cell A2.

(2) The place to start: where “http” is found, FIND(A2,”http”). The value returned to MID() will actually be at the location of the “h” in “http”. This will work for “https” urls too because they still have “http” in them.

(3) Then I do a bit of subtraction. URLs do not have any spaces in them. So if I can find the first space after the URL I can use that to get the length of the URL. I use FIND() to find a space. FIND() has an optional third argument which is to start looking at the location I desire. So I set that location to be where “http” was found using the same formula as before. Since that will return the location within the whole input string and not the length of just the URL I need to subtract from it. I subtract the location of “http” using FIND("http",A2).

Answers 1 Comments
Dislike Bookmark

Md Sohail describes himself as Computer Professional. He conducts classes in Advanced VBScript, C Language and C++ Language. Md is located in Jubilee Hills, Hyderabad. Md takes at students Home and Online Classes- via online medium. He has 5 years of teaching experience . Md has completed Master of Engineering - Master of Technology (M.E./M.Tech.) from JNTU in 2013. HeĀ is well versed in English, Urdu, Hindi and Telugu.

X

Post your Learning Need

Let us shortlist and give the best tutors and institutes.

or

Send Enquiry to Md Sohail

Let Md Sohail know you are interested in their class

Reply to 's review

Enter your reply*

1500/1500

Please enter your reply

Your reply should contain a minimum of 10 characters

Your reply has been successfully submitted.

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 25 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 6.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more