6 Key Elements You Must Know While Writing Your Resume

A potential resume accentuates your achievements, your wok experience and educational qualifications along side escalating your expertise and dynamism. In today’s competitive world, even the best of educational qualification will not get you the job; you will have to persuade the recruiter during the interview. Your resume is a declaration of facts intended to highlight your exceptional combination of comprehension & talent to convince your employer.

1. Academic qualifications can build a striking resume. List them in reverse sequence, i.e., from most recent to least resent. If you are doing some part time or specialization at present, highlight it. Stating the year of graduation and post graduation is wise.

2. Accentuate your achievements. For successfully getting an interview call highlight all the reasons why must he call you in? It is your résumé’s crisp, attractive information that will persuade recruiter to call you for the interview. It’s the section to openly say why you are the best contender for this job!

3. State individually the Summer Training, Work Shops, Corporate Projects under taken. You must emphasize on all the areas clearly. Don’t mix them under one heading. Remember you will not assist the reader. He will read just as you have written. They will give you an edge if set correctly.

4. Glorifying your co-curricular achievements is a good step. This is one section where we must know how to restrict the information we are providing. Just don’t list all the little debate competitions you have attended. Just mention the prestigious ones where you have scored a good position. It can be in sports, arts, etc. this section will depict you as an all-rounder. When called for interview, remember carrying along all your certificates of achievement.

5. References will back bone your resume. Someone senior from the same organization or your previous job can refer you for the job. This section will give your recruiter a chance to find about you. Make sure you give the correct contact no. of the person(s) you are naming under reference section.

6. Providing correct Contact Information is a must. Contact Information will allow your recruiter to contact you for further after going through your resume. So must give correct and complete postal mailing address, e-mail address, permanent residence phone number, your mobile phone number, etc. Don’t change mobile phone numbers during this time. And keep checking your e- mails regularly.

Remember there is no worth of a general resume any more. The jobs today are specific and so must the résumé’s be. Make sure your resume is altered according to requirements of the job you are seeking.This is the first step for getting an interview call!

How to survive in the organization in slowdown?

How to survive in the organization in slowdown?

In times of economic slowdown, it is important to develop individual skills like ability to work in a global environment, flexibility, adaptability, relationship skills etc. to remain an inevitable organizational resource. The better the resource you are the longer you stay in the organization.

Organizations are looking to retain strong, versatile talent. So it’s important for each employee to continuously develop themselves making sure they stay relevant to the needs of the organization/market, and continue to add value. Make sure you have a great track record of delivery, be willing to go the extra mile, perhaps take on responsibilities that others may not want to do.

How companies can handle slowdown?

This will differ from company to company. Companies need to maintain laser focus on the needs of their customers, adapt their products and services to meet those customer needs, focus on retaining and developing their critical talent, be financially prudent, and show strong leadership.

How should companies motivate their employees?

People need transparency and honesty from their leadership, to engender a sense of trust. Make employees part of the solution for addressing the challenges. Communicate regularly to connect with them. Don’t make false promises. For most folks, sense of purpose and clarity of roles and responsibilities helps to keep them on track. In addition to this, employee engagement activities such as employee resource groups can be helpful.

The good and bad picture of iPhone 5

iPhone 5! It’s shiny. It looks yummy! It’s slimmer, sleeker, stronger, faster and taller than iPhone 4S. In sum, it’s a fantastic update of a device that is already very good. Lets talk about the good and bad picture of iPhone 5.

The good picture

1. iPhone 5 is lighter than iPhone 4S (Use of Aluminium)

The biggest change is the use of aluminium as the primary material instead of glass. This means iPhone 5 is sturdier and lighter than iPhone 4S. At the same time, it is also going to be a little less cold (figuratively) to the touch with the aluminum texture feeling smooth and assuring in the hand.

2. Better Hardware, Better Battery Life (A6 Processor, ARM Technology)

The hardware that powers iPhone 5 continues to be the best in its class. Apple is using A6 processor, a new chip, to power the phone. This chip is based on architecture developed by Apple using ARM technology.  ARM technology will give better performance as well as better battery life. 

3. Better Camera

The camera in iPhone 4S is very good. But Apple has improved it in iPhone 5 further, though it continues to sport the 8 megapixel tag. But megapixels don’t matter.

4. Support for 4G

iPhone 5 supports 4G.

The bad picture

1. No innovated software

Apple has not really innovated in terms of software and user interface (UI) in iOS after 2007. iOS 6, which powers iPhone 5, too brings nothing radically new to the table.

2. No innovated user-interface

In terms of user interface (UI), Windows Phone 8 looks to be miles ahead of iOS. Even Android Ice Cream Sandwich and Jelly Bean look better than iOS.

3. Apple Maps vs Google Maps

Apple Maps are no match for Google Maps. This means iPhone 5 is not going to help much for tasks like navigation and finding routes.

4. You won’t be able to charge it with the industry-standard chargers that use microUSB port.

5. iPhone 5 doesn’t support mass-storage mode, the easiest way to manage files on a smartphone or tablet.

6. The screen is not bigger. It is only longer. I don’t think it is going to make much difference when it comes to web browsing or media playback experience. The bigger Android phones are still better for these tasks.

Shortcuts to Shutdown, Restart and Log Off in Windows 8

Here in this article, I have listed 3 ways to shutdown/restart/logoff your windows 8 machine:

1. Switch to the desktop view and press ALT + F4 to bring shutdown menu.
 

2. Press the shortcut key Win+C, go to Settings – > Power – > Shut down.

3. Create Simple Tiles on your windows 8 desktop to shutdown/restart/logoff your machine:

Enter createButtons.vbs – this is a simple utility (or rather a script) that will automatically add Shut Down and other related buttons to your Windows 8 screen. There’s no installation required – just download the file to your desktop and double-click to create the various buttons.

3 Simple and Interesting PLSQL Programs to Explain Triggers

Triggers in PL/SQL are the blocks which are automatically fired before or after any alteration (insert, update, delete) is done to the table. Here are 3 simple programs which will illustrate the concept of triggers very efficiently. Have a look...

Consider the following table named student. It contains roll no, name and marks of each student.

roll          name     marks
20034   SID        69
20035   HARRY 88
20036   TANK    34

1. Program to illustrate the use of BEFORE TRIGGER. This trigger will always enter the name of student in capital letters.

CREATE OR REPLACE TRIGGER capital_name BEFORE INSERT OR UPDATE ON student FOR EACH ROW
BEGIN
:NEW.name := UPPER(:NEW.name);
END;

Now if you make the following query to student table:

UPDATE student SET name = ‘Steven’ WHERE roll = 20035;

Then instead of ‘Steven’, ‘STEVEN’ is inserted into the table.

2. Program to illustrate the use of BEFORE TRIGGER. This trigger will not allow to do any action with student table on a specified day, here saturday.

CREATE OR REPLACE TRIGGER no_action BEFORE INSERT OR UPDATE OR DELETE ON student FOR EACH ROW
BEGIN
IF(LTRIM(RTRIM(TO_CHAR(SYSDATE,’DAY’)))=’SATURDAY’)
THEN
RAISE_APPLICATION_ERROR(-20998,’Action Denied’);
END IF;
END;

Now if you make the following query to student table:

UPDATE student SET name = ‘Steven’ WHERE roll = 20035;

on saturday. You will get the message ‘Action Denied’. This is very useful feature used to avoid any alteration in sensitive data on weekends when you are not around and anybody else tries to alter it.

3. Program to illustrate the use of AFTER TRIGGER. This trigger will put the altered enteries in a new table named track.

Suppose student table is very critical and crucial. Only you are allowed to alter the enteries. So you can make trigger to track other persons who login with their username and try to alter the table. For this you have to create a table track as follows:

CREATE TABLE track (roll number, name varchar2(40), oldmarks number, newmarks number, uname varchar2(40));

Now create a Trigger as

CREATE OR REPLACE TRIGGER track_action AFTER UPDATE ON student FOR EACH ROW
BEGIN
INSERT INTO track VALUES(:OLD.roll, :OLD.name, :OLD.marks, :NEW.marks, USER);
END;

Now suppose a relative of TANK works in your department and he comes to increase his marks for 34 to 94. He will login from his username and will fire the following query.

UPDATE student SET marks = 94 WHERE roll = 20036;

He will now get delighted that he has altered the table. But he doesn’t know that a secret table named track has strored all the alterations done by him.

Now when you come in morning and fire the following query:

SELECT * FROM track;

Now, there will be one record in this table containing roll as 20036, name as TANK, old marks as 34 and new marks as 94 and most importantly the username of sneaker. So he has been trapped.

3 Very Simple PLSQL Programs to Explain Procedures, Functions and Packages

Here in this tutorial, Procdures, Functions and Packages are fully explored through simple programs. Procedure is a subprogram that performs a given task while Function is same as Procedure but it returns the value. Packages group up Procedures, Functions, Variable, Constants, Cursors and Exceptions.

1. Program to illustrate the use of Procedure. The program is to multiply two numbers. This program is stored in a file name myprocedure.sql

CREATE OR REPLACE PROCEDURE product(a number, b number) AS
c number;
BEGIN
c:=a*b;
DBMS_OUTPUT.PUT_LINE(c);
END product;

Now use SQL>@ myprocedure to create this procedure.
Now use SQL> SHOW ERRORS; to find out if there is any error. This is the optional step.
Now use SQL> EXEC product(3,4); It will give output 12.

You can also call the above procedure through a program below:

SQL> ED CALLPRO
DECLARE
a number;
b number;
BEGIN
a:= &a;
b:= &b;
product(a,b);
END

SQL> @ CALLPRO;

2. Program to illustrate the use of Functions. The program is to multiply two numbers. This program is stored in a file name myfunction.sql

CREATE OR REPLACE FUNCTION product2(a number, b number) RETURN number AS
c number;
BEGIN
c:=a*b;
RETURN c;
END product2;

Now use SQL>@ myfunction to create this function.
Now use SQL> SHOW ERRORS; to find out if there is any error. This is the optional step.
Now use SQL> SELECT product2(3,4) FROM DUAL; It will give output 12.

You can also call the above function through a program below:

SQL> ED CALLFUN
DECLARE
a number;
b number;
result number;
BEGIN
a:= &a;
b:= &b;
result:= product2(a,b);
DBMS_OUTPUT.PUT_LINE(result);
END

SQL> @ CALLFUN;

3. Program to illustrate the use of Packages. This package name is combine and package specification is stored in file pack and package body is stored in file pack_body.

SQL> ED pack
CREATE OR REPLACE PACKAGE combine AS
PROCEDURE product(a number, b number);
FUNCTION product2(a number, b number) RETURN number;
END combine;

Now use SQL>@ pack to create this package.
Now use SQL> SHOW ERRORS; to find out if there is any error. This is the optional step.

Now we will make package body in file pack_body.

SQL> ED pack_body
CREATE OR REPLACE PACKAGE BODY combine AS

PROCEDURE product(a number, b number) AS
c number;
BEGIN
c:=a*b;
DBMS_OUTPUT.PUT_LINE(c);
END product;

FUNCTION product2(a number, b number) RETURN number AS
c number;
BEGIN
c:=a*b;
RETURN c;
END product2;

END combine;

Now use SQL>@ pack_body to create this package body.
Now use SQL> SHOW ERRORS; to find out if there is any error. This is the optional step.

Now we will make call to this package as

SQL> EXEC combine.product(3,4);
SQL> SELECT combine.product(3,4) FROM DUAL;

9 Very Simple PLSQL Programs to Explain Control Structures

Here you will find the list of 9 simplest plsql programs fully exploring the control structures. This tutorial covers IF, ELSE, ELSIF, LOOP, EXIT, EXIT WHEN, WHILE, FOR, GOTO and NULL statements. So have a look...

1. Program to insert values in a table student which has two fields student_id and name.

DECLARE
max_id number;
BEGIN
SELECT MAX(student_id) INTO max_id FROM student;
INSERT INTO student (student_id, name) VALUES (max_id + 1, ‘Harry’);
DBMS_OUTPUT.PUT_LINE(’Record Inserted’);
END;

2. Program illustrating the use of IF, ELSE and ELSIF

If Percentage >=80 –> Grade A
If Percentage >=60 –> Grade B
If Percentage >=45 –> Grade C
If Percentage < 45 --> Fail

 

DECLARE
n number;
BEGIN
–Enter percentage between 1 and 100
n:=&n;
IF(n>=1 AND n< =100) THEN
IF(n>=80) THEN
DBMS_OUTPUT.PUT_LINE(’Grade A’);
ELSIF(n>=60 AND n<80)
DBMS_OUTPUT.PUT_LINE(’Grade B’);
ELSIF(n>=45 AND n<60)
DBMS_OUTPUT.PUT_LINE(’Grade C’);
ELSE
DBMS_OUTPUT.PUT_LINE(’Fail’);
END IF;
ELSE
DBMS_OUTPUT.PUT_LINE(’Percentage must be between 0 and 100′);
END IF;
END;

3. Program illustrating the use of LOOP with EXIT statement

DECLARE
n number:=0;
BEGIN
LOOP
n:=n+1;
IF(n>3) THEN
EXIT;
END IF;
END LOOP;
DBMS_OUTPUT.PUT_LINE(n);
END;

output: 3

4. Program illustrating the use of LOOP with EXIT WHEN statement

DECLARE
n number:=0;
BEGIN
LOOP
n:=n+1;
EXIT WHEN n>3;
END LOOP;
DBMS_OUTPUT.PUT_LINE(n);
END;

output: 3

5. Program illustrating the use of WHILE LOOP statement

DECLARE
n number:=0;
BEGIN
WHILE n<3
LOOP
n:=n+1;
END LOOP;
DBMS_OUTPUT.PUT_LINE(n);
END;

output: 3

6. Program illustrating the use of FOR LOOP statement

DECLARE

n number:=0;

BEGIN
FOR i IN 1..3
LOOP
n:=n+i;
END LOOP;
DBMS_OUTPUT.PUT_LINE(n);
END;

output: 6

7. Program illustrating the use of FOR LOOP REVERSE statement

DECLARE
n number:=0;
BEGIN
FOR i IN REVERSE 1..3
LOOP
n:=n+i;
END LOOP;
DBMS_OUTPUT.PUT_LINE(n);
END;

output: 6

8. Program illustrating the use of GOTO statement

BEGIN
DBMS_OUTPUT.PUT_LINE(’First Line’);
GOTO third;
DBMS_OUTPUT.PUT_LINE(’Second Line’);
< >
DBMS_OUTPUT.PUT_LINE(’Third Line’);
END;

output:
First Line
Third LIne

9. Program illustrating the use of NULL statement

DECLARE
n number:= &n;
BEGIN
IF n MOD 2 = 0 THEN
DBMS_OUTPUT.PUT_LINE(’Number is Even’);
ELSE
NULL;
END IF;
END;

output: If entered no. is even then it will display the message otherwise no message will be displayed.