Best Job Portals In India

Just have a look at some of the top job sites in India in a nutshell.

Naukri

Since its inception in the year 1997, this job site has earned a good name among the job seekers. It is regarded as one of the best job sites in India. The group operates across three verticals, namely, real estate, jobs and matrimony.

Monster India

Like Naukri, Monster India is also one of the top job sites in India. The main objective of this job search site is to enable the job seekers find out about a new job, a new career avenue, and discover the job opportunities that exactly match your profile.

Times Jobs

This is also one of the popular job search sites in India. The site contains all types of jobs and helps an individual to find out the job of his or her choice relevant to his or her area of study.

Careerjet

Careerjet is one of the popular job search engines which have been specially designed to make the entire process of finding a job on the internet much easier for the users. It lists down the job offerings available on the internet in one extensive database by referencing job listings which originate from recruitment agency websites, company websites and large specialist recruitment sites.

Naukri Hub Naukri Hub is regarded as one of the best job sites in India. Naukri Hub is a popular web portal committed towards guiding millions of job aspirants to find the correct way. The website believes that there is no shortcut to quality and always inspire people to set their dreams sky high. The way Naukri Hub executes all the relevant and best sorted job information, places it at a bench mark position. The site indeed leaves a mark to tremendous teamwork, provides an innovative approach, and leads to an excellently well built customer relationship. Career India Career India is also one of the popular job sites in India. It features sections like Walkins, Walk-in-interviews, Post your Seekers and Resumes, IT Jobs in Pune, Change Location, Bangalore, Delhi and Coimbatore. Bixee Bixee is also one of the most popular job sites in India. It was launched during the latter part of 2005. In this site, you can find lots of information on Jobs in India, Chennai, Delhi, Pune, Mumbai, Hyderabad and Bangalore over the internet. ClickJobs ClickJobs is a career site which gives you the option of keeping your profile in the site’s database. The site allows you to keep some of your information confidential if you desire to do so. If a potential employer is interested to view your full profile, you will de directly contacted via email and will be given the name of the potential employer. CareerAge CareerAge was created in the year 1996 and the portal was officially launched in December 1999. This job site was launched for the purpose of making available the various types of jobs and career information over the internet. It is regarded as one of the most comprehensive job portals in India which help the students as well as the career builders by providing detailed information on various career options. Freshersworld This is a portal catering to the jobs for freshers in India. It features sections like Hot Jobs, Govt/Technical Jobs, Defense, Soft Jobs, Careers, Placementweek, Company List and Interview Tips.

About SQL and different commands

Introduction to SQL

• SQL is referred as Structured query language, is database computer language required for managing the data relational data base management system.It acts as Interface for database only,universal interface.
• SQL is Non-Procedural language and it is 4th generation language.
• Procedural means execution from top to bottom and it is 3rd generation language.

 Different types of commands:-

1. Data definition language(DDL)
2. Data manipulation language(DML)
3. Transaction control language (TCL)
4. Data control language(DCL)
5. System control language(SCL)
6. Session control language(SCL)
7. Data Query/Retrieval language

SQL commands ready to work with any platform.It is independent of O/S.It is permission oriented language or it requires privileges.It is exclusively used for DB because it a DB language.
DDL consists of :

1. Create
2. Alter
3. Drop

DML consists of :

1. Select
2. Update
3. Delete
4. Insert

TCL consists of :

1. Savepoint
2. Commit
3. Rollback

DCL consists of:

1. Grant 
2. Revoke

CREATE:
Create command is used to create the DB objects like table,view, synonym, sequence, user, index, cluster, tablespace, segment, database, DBlink, proceduire, Function, Package, Trigger, Role, Directory type...
Syntax
CREATE TABLE TABLENAME
( datatype(width), datatype(width));Ex:  create table student(RollNum number(3), Name varchar2(10));  Various datatypes   

• Char(size): To store fixed length char strings.Max upto 2000 bytes.By default 1 Byte.  

• Varchar(size):To store variable length.Max 4000 Bytes. Difference between varchar and char is that when we use char and assign the size all the placed are reserved for that column and where as varchar releases the memory when they are not used. 

• LONG: Data upto 2 GB can be stored. 

• RAW:To store binary data like signature,Thumb,impressions,photographs. 

• Long Raw: To store binary data upto 2GB size No default. 

• LOB: large objects  

• CLOB: char large objects  

• BLOB:Binary large objects.

• Bfile:Binary file 

• Number(P,S):where P is primary, S is secondary(where P is left size of precision,S is right side precision) Ex:Salary number(6,2).   Date: DD-MM-YY

will be contd....

Google receives 75k job applications in a week

London: Internet search giant Google received a staggering 75,000 job applications within just a week of kicking off its massive recruitment drive, says a media report. According to the Daily Mail, "Google received a staggering 75,000 job applications in just one week as it launch(ed) a huge recruitment spree."

The U.S.-based company holds the record for the highest number of job applications received when it advertised openings in May, 2007, the report noted. However, the latest barrage of applications tops that figure by 15 percent, with the company planning to add more than 6,000 new jobs. Competition for roles at the company is likely to be fierce, with 12 hopeful candidates vying for a single position an average.

Google had just 3,000 staff when it got listed on the New York Stock Exchange in 2004. It now employs 24,400 workers in 63 offices around the world. The company plans to increase hiring as it pushes deeper into mobile services, display advertising and Internet applications.The job vacancies are across the entire company and include posts for software engineers that design new products, enterprise managers and technology experts.

Google's Senior Vice-President of Engineering and Research, Alan Eustace, said in a blog post last week, 'We're looking for top talent. I love Google because of our people. It's inspiring to be part of the team. And that's why I am excited about 2011, because it will be our biggest hiring year in company history."

Eustace further said, "We'll hire as many smart, creative people as we can to tackle some of the toughest challenges in computer science: like building a web-based operating system from scratch, instantly searching an index of more than 100 million gigabytes and even developing cars that drive themselves."

Google was ranked as America's best workplace by Fortune magazine in 2007 and 2008.

Introduction to Oracle

Oracle 11G

The Oracle Database (commonly referred to as Oracle RDBMS or simply as Oracle) is an object-relational database management system (ORDBMS) produced and marketed by Oracle Corporation.

Larry Ellison and his friends and former co-workers Bob Miner and Ed Oates started the consultancy Software Development Laboratories (SDL) in 1977. SDL developed the original version of the Oracle software. The name Oracle comes from the code-name of a CIA-funded project Ellison had worked on while previously employed by Ampex.

General View of Oracle

Introduction to DBMS::
DBMS-Collection of Integrated Interrelated data i.e.in DBMS the data which we are going to store is interrelated.unlike general notepad were data is not related.

Database records the data only once but reads it many times.

Oracle stores the data in the form of records.Each Record maintain 1000 fields.
1 Field can accommodate up to 4 GB


Entity
Entity can be anything in real world which has some properties through which it can identified uniquely form others.
Ex- Let as take student as an entity and Roll Number,Section,Class can be treated as his properties.this properties are called as attributes in database terminology.

Database is used to maintain entity and in RDBMS it is in Tabular form.
Table is a 2 dimensional here.Table consists of rows and colums.
In oracle we can have maximum of 1000 columns and there is no limit of rows.

High U.S visa fees affecting Indian professionals

NEW DELHI: Demanding relaxation in the U.S visa regime , an industry chamber today said the recent hike in professional visa fees by the Obama administration is hurting interests of Indians who want to do business there.

"Today, a lot of Indians wanting to set a shop in the US face difficulties. Visas are being used as non-tariff barriers," said Gautam Mahajan, National President of Indo - American Chamber of Commerce (IACC) here.

"There should be some professionalism in terms of looking at the needs of companies who've invested in the US," he added.

Under the Emergency Border Security Supplemental Appropriations Act, 2010 -- popularly called the Border Security Bill -- the US had hiked fee for certain categories of H-1B and L1 visas by at least USD 2,000 for the next five years.

Businesses in India and the US had termed the hike as discriminatory and said this would undermine the growing Indo-U.S economic relationship, with which the Obama Administration does not agree.

On the issue of radio tagging involving Indian students in the US, Mahajan said, "... (it) is wrong."

After being duped by a California-based "sham" university, scores of Indian students in the US were forced to wear radio collars around their ankles so that authorities can keep a track of their movements.

Meanwhile, a two-day Indo-US Economic Summit would be held here from February 11.

"Our objective is to make the Summit a stock taking exercise of the traditional contours of cooperation and at the same time reach out to newer and potential areas that open up opportunities for scaling business operations," Summit Chairman Lalit Bhasin said.

He said the Summit, to be attended by a large number of delegates from the two countries, would be inaugurated by Deputy Chairman of Planning Commission Montek Singh Ahluwalia.

Banking, Finance: Are you ready for the job from Day 1?

THE recession in 2008 is a distant memory and the stock markets have almost reached their previous record high valuations. Financial sector is right now back from the brink, though global indicators are still far from satisfactory. But everybody agrees the worst is behind us.
So is the job market hot? Well, recruiters look at a combination of factors like articulated communication, presentation skills, overall personality, and the candidate’s basic knowledge of the industry.
They also test networking abilities and negotiation skills before inviting them on-board. For prepared candidates, opportunities do exist. But the million dollar question is - why is that after two years of a gruelling PGDM programme, are students still not ready to start work right away?
Are you job-ready?
“Not quite ready” is a common refrain. The course curriculum followed by academic institution provides the required knowledge inputs in management subjects like finance, marketing or HR. “ What it lacks is a vocational or industry focus,” says Judhajit Das, Chief Human Resources, ICICI Prudential Life Insurance Company.
Krish Lakshmikant, a leading headhunter seconds. The students do not apply their minds sufficiently and are just not ready to roll up their sleeves. The while collar AC room job mentality still persists he says. And corporations invest in costly training structures to get them job ready.
Fresh hires at Yes Bank undergo formal and intensive 5-week induction/ on-board programme. “We give them insight into company’s philosophy, culture, into our diverse business verticals and structure”, says Deodutta. Post that, the recruits are given on-the-job training and are exposed to 4-5 key support functions right at the inception stage. Similar induction programmes are conducted in Insurance and financial services sector too.
Where is the moolah?
In the insurance and banking sectors, entry-level salaries for MBAs range between Rs 5-8 lakhs per annum. Capital markets pay Rs 2.5 lakh or more for a sales and marketing function.
The entry-level salary band starts at Rs 1.5 lakhs per annum, varying city-to-city and the B-School the students come from. The highest salary in 2009 was Rs. 18 lakhs , while the average was Rs.10.20 lakhs, says Dr. Anupam Rastogi, Senior Prof. (Finance & Economics), NMIMS.
Skilled employees start higher, and the salaries are more if a professional exam has been cleared by a candidate. “Typically associate actuaries earn Rs. 20,00,000 plus pa and fellow actuaries Rs. 40,00,000 plus pa,” says Rajendra Shah, managing director, DS Actuarial Education Services.
Sounds like music to your ears? Then BFSI is your symphony indeed!

Top Ten Software Companies....

Forbes 2000

This yearly list shows 2000 large companies active in all kinds of industries. By selecting software & services a sublist can be made, which is 35 companies long in the 2010 edition. Forbes shows figures such as sales, profits, assets and market capitalization. Only public companies are listed. The ranking seems to be based upon a multiplication of sales × profits × assets × market capitalization. A Top 10 extract of the world's largest software companies according to the Forbes Global 2000 is provided below.

1.Apple Inc.

2.IBM

3.Microsoft

4.Google

5.Accenture

6.SAP AG

7.Hewlett Packard

8.Computer Science Corporation

9.Yahoo!

10.CA

Forbes includes services revenues given its listing of IBM, Accenture, Computer Sciences and Cap Gemini. Forbes also appears to include advertising revenues given the listing of Google and Yahoo in their Top 10. Large private software companies are not on the Forbes list. Market capitalization influences the ranking: Forbes has used the market cap of Mar 01 2010 to build their list.

The Software 500 by Software Magazine

A yearly list that is available after free subscription. The list offers 500 companies. Services revenues are included in the software revenues. Software magazine sends out a yearly request for data: companies fill in their own data online. As Software Magazine is primarily read in the US, the list also has a slight focus on the US, although it is becoming more international every year. The companies are ranked according to software & services sales revenues. Both public and private companies are included.

Software Magazine's Top 10 ranking of 2009 is as follows (see their website for more info):

1.IBM

2.Oracle Corporation

3.Accenture

4.Yahoo!

5.HP

6.SAP AG

7.HP

8.Capgemini

9.CSC

Due to the inclusion of services revenues, many IT services companies appear on the list: Accenture, CSC and Cap Gemini. Software Magazine usually publishes a new edition in September.