SQL Get record start with and end with particular character

02 SQL alias based Query. SQL MCQ

SELECT * FROM Employee;

What will be output of below SQL Query  ?

SELECT (FirstName +' ' + LastName) as FullName

FROM Employee 

        WHERE EmployeeID = 1;

Answer : Error

Reason of error:

• When using aliase, it must be a single world.
• Alliase will not accept space

01 SQL like operator based Question.

How to Signout from LinkedIn in mobile device browser.

Quickest way to copy text from image in Window

LinkedIn How to delete past Resume applied for job ?

                  In LinkedIn How to manage Resume?
When you apply for Job, you upload a resume.
and each time if you have uploaded new resume then LinkedIn will save that resume.

Benefit:
Next time while applying for new job, you can reuse those save resume.

Issue:
While applying for new Job, if you wish to use those existing saved resumes then it is difficult to remember internal details of resume so which one as a candidate need to use.
It’s a better to remove those older resumes.

In LinkedIn, how to manage Resume?

1: How to delete saved resume (previous applied resume)

while applying for new Job?

 

2: How to add new resume on LinkedIn?

Solution:
Open LinkedIn

1.   Navigate to the Jobs tab.

2.   Click on Preferences.

3.   In the pop-up modal, Resumes and application data.

4.   To Delete a previously applied resume -
By clicking on the … icon then click Delete.

5.   To Upload a new resume-
click on Upload resume

Youtube Link

How to add Github profile to Linkedin ?

How to add Github account profile to LinkedIn prfile for better profile visibility.

Steps : 

Open LinkedIn

1 : Navigate to Profile section.

2 : Click on "Add profile section".

3 : Pop-up modal will open,  expand "Recommended.

4 : Click on "Add featured" and new Fatured layout will be load.

5 : Click on +  plus icon. then select "Add a link"

6 : Now login to Github and navigate to your profile.

7 : Copy profile page URL and paste in text box opened in step 5 and click "Add"

In Title field : use can specify like "Github Profile" or any thing 

8 : https://www.linkedin.com/feed/

For step by step process, you can go through bellow video