Your Ad Here

Search for post

INFORMATION TECHNOLOGY

The Information Technology (IT) - sector has boomed all over the country.With efforts of government to put the India at the forefront of IT revolution ,The IT companies are all set to turn their employees into young millionaires.Areas within the IT- Sector that one could look at are wide and varied-IT enabled services,The Internet Technologies are the next growth sectors within the IT industry.

The IT enabled services are CALL CENTRES- EXECUTIVE CUSTOMER RELATIONS,GEOGRAPHIC INFORMATION SYSTEMS,TELECOM TECHNOLOGY,INTERNET TECHNOLOGIES,NET WORKING,E-COMMERCE,DATA WAREHOUSING.Most of them had choosed their carrier and courses based on these services.




Friday, August 14, 2009

RBN-INFO-TECH : WHAT ARE THE FUNCTIONS IN ORACLE ?

Oracle SQL Functions
1.  ABS(n)  : It returns absolute value of a number
    Eg:   ABS(-25)=25
          ABS(34)=34
 
2.  ACOS(n) : Returns arc cosine of number(n).’n’ must be in the   range of -1 and 1
                  Eg:   ACOS(.3)= 1.26610367
 
3.  ADD_MONTHS(date,num_months) : Returns date + num_months
              Eg: ADD_MONTHS('01-Aug-03', 3)= '01-Nov-03'
  
4.  ASCII(char) : it Converts char into a decimal ascii code
              Eg:   ASCII(3)=51
 
5.  ASCIISTR(char):argument of this function is a string ,or expression that resolves to a string ,in any character set.it returns an ASCII conversions of the string in the database character set.
              Eg:   ASCIISTR(ABCDE)= AB\00C4CDE
 
6.  ASIN(n) : returns arc sine of n.
              Eg:   ASIN(.3)= 0.30469265
 
7.  ATAN(n) : it returns arc tangent of n.
              Eg:   ATAN(.3)= 0.29145679
 
8.  ATAN2(n.m) : it returns arc tangent of n and m. 
              Eg:   ATAN2(.3,.2)= 0.9827937232
 
9.  AVG([DISTINCT]n): Averge value of 'n' ignoring NULLs
 
10.  BETWEEN value AND value : Where 'x' between 25 AND 100
 
11.  BFILENAME('directory','filename'): Get the BFILE locator associated with a physical LOB binary file.
 
12.  CASE : used to Group the data into sub-sets.the case statement is an alternative for the decode function.it is used for the construction of if-then-else.
Eg: select id
, case (when status ='A' then 'Accepted'
when status ='D' then 'Denied'
else 'Other') end
from employee_maser;
 
13.  CEIL(n) :       Round n up to next whole number.
                    Eg: ceil(3.4)=4
                        Ceil(3.9)=4
 
14.  CHARTOROWID(char) : it Converts a Char into a rowid value.
                    Eg : SELECT ID from some_table WHERE ROWID = CHARTOROWID('AAAAtmAAEAAAAFmAAA');     
                     
15.  CHR(n) : Character with value n
                     Eg: chr(51)=3 
 
16.  CONCAT(s1,s2) :  it Concatenate string1 and string2
                   Eg : concat('df','ee')=dfee
 
17.  CONVERT (char_to_convert, new_char_set, old_char_set) : 
              Convert a  string from one character set to another.
18.  COS(n): Cosine of number
                  Eg : cos(.3)= 0.95533648
19.  COSH(n)       Hyperbolic Cosine of number
                  Eg : cosh(.3)= 1.04533851
 
20.  COUNT(*) :     Count the no of rows returned
 

RBN-INFO-TECH

RBN-INFO-TECH : HOW TO MAKE MONEY AT HOME, USING YOUR PERSONAL COMPUTER

Its now easy to earn money with your personal computer,The technology has grown that much which make thinks easy and possible .Not the everyone wants to own their own business and not everyone who wants to is capable of being a success. But for those of you who currently own or are thinking of buying a personal computer, you can just about the guarantee yourself that for just a few hours of your spare time, you could easily produce an income that will exceeds your current monthly earnings. Thousands of success stories have been documented and you could easily earn up to $5,000 a month and more, in your spare time. And if you enjoy the computers you can have fun,while you earn your extra incomes.
The Home based computer entrepreneurs were once predicted to be 'the wave of the future'. The U.S. Labour Department believes that up to half of all Americans could be working at the home by year 2000. If that prediction is true, a large number of these workers will be home based employees of various major corporations. Millions of others ,however will be home based entrepreneurs engaged in a business of their own.
you can also earn,Its true technology has developed a lot .

download the tutorial to refer how to earn money with your personal computer?
Downloads:



RBN-INFO-TECH

RBN-INFO-TECH : HOW TO EVALUATE HIGH 'TECHNOLOGY' STOCKS

The High technology is last frontier in the American business. Many of the new businesses revolve around some type of technology, whether it is directly computer , communications related or some how tied in with the 'Electronic Superhighway', whose arrival we all eagerly anticipate. Although tech stocks have declined sharply in during bear markets, They had prove to have out perform other stocks, re-bounding more sharply in subsequent recoveries.
There are 3 major advantages that point to small companies:
a.) They are generally free from the government regulation because their earnings are often in the new field.

b.) The company stands to gain a lot of ground, if the come up with a unique idea. The growing market will be theirs to dominate.
c.) The impact their earnings will have on their financial status will be considerable.Therefore a success can increase their profitability greatly.


There are several rules to follow, if you choose to be an investor in this high risk market. Firstly, do not be fooled by size of the company. It is important to investigate the high-technology expertise of the firm and secure that it is a meaningful part of the firm’s business. Secondly,It is vital that the company is serving an current social need in the marketplace.

For example:
The cable was first introduced in the 1960’s and interested investors long before, it could draw subscriber's.
Look for companies that are operating in the black. The Companies that offer teriffic scientific break throughs, but operate at a deficit are just too risky.It is also important that you ignore market indexes. The Companies with technological superiority are not tied to a stock market environment over-time.

Lastly, keep current on all technological innovations. Buy trade-magazines and read scientific papers and investment guides that deal with technology and technology-related fields.

RBN-INFO-TECH

RBN-INFO-TECH : THE CAREERS IN ' IT ' ENABLED SERVICES

CALL CENTRES: EXECUTIVE-CUSTOMER RELATIONS


A call centre provides the information support to customers,These
centres are manned by the trained personnel with access to a wide data-bases of information , the thorough knowledge and the product or service being offered by the company.
The employment bases in the call centre business is expected to touch 3.5 million by the year 2008-09. Many of call centre businesses in Australia and U.S.A. have started setting up the base in India.
How to become one of this ?:
The Graduates are preferred for this option. Basic skill required to join a call centre is the language understanding (accent and dialect). The recruiting companies provide on the job training.
Where to get in it:
Companies like ICICI, GE & Bechtel have set up in house call centres and provide the support to own employees worldwide.
Salaries:
The Call centre operators can expect more than Rs.8,000/- at entry level. With two years experience one could grow to a supervisory level and draw around Rs.10,000- 15,000 per month.

GEOGRAPHIC INFORMATION SYSTEMS

The Government Departments, telecom companies and utilities are increasingly
depending on GIS data for environmental resource analysis, land use planning, network analysis, etc. marketing and distribution strategies. The job would involve conversion of the data (maps, records, aerial photography etc...) to digital data that can be used for modelling and analysis.

How do you become one? :
A ' BE' graduate with knowledge of operating systems is eligible for such an opportunity. Knowledge of tools like C& C++, specific GIS package or CAD is an advantage.

The Pixel Infotech, Bangalore provides a course for 3 months for those keen in entering this area. The GIS certificate course offered by Pixel is about Rs.15,000 - 20,000 and the two and half month. GIS certificate course offered by Pentasoft is Rs.75,000.


Where to get in it ?:
The One can get recruited in GIS solution providers, research institutes, the Government Sector and the GIS user industries. A few companies are recruiting personnel for GIS,they are Rolta, Intergraph, Seimens, L&T information Technology and Pentafour.
Salaries:
At the Entry level salaries range from Rs.8,000 to 10,000 per month. In two to three years, one can expect to earn over Rs.20,000-30,000 per month.
TELECOM TECHNOLOGY

With advancement of technology the telecom sector is heavily dependant on internet technology. Starting from WAP (Wireless Application Protocol) Service to satellite communication, telecom technology has extended its wings. Telecom Engineers specialising in information technology are on high demand. B.E. graduates with telecom engineering are preferred. Leading multinational companies like Motorola, Nokia, Ericsson, Panasonic etc. need telecom technologists. Generally the entry level salary ranges from Rs.20,000 to Rs.25,000 per month.
INTERNET TECHNOLOGIES

WEB DESIGNER:
A Web Designer is responsible for creating an appealing web site
that is easy to navigate.“Web Designing requires high level of skills and people with both creative and computer friendly skills come at a very high cost to any organisation”.
How to become one of it ? :
Fresh graduates with creative skills can start as designers. Graduates equipped with a diploma/certificate course in Internet Technologies can get into this field. Skills required: ASP, XML,HTML, Cgi, Perf, VB script, Java script, TCP/IP. A typical 9 months Diploma in Web engineering offered by Arena Multimedia is around Rs.27,000; 3 months Diploma in Multimedia Course by Pentafour is around Rs.21,000.

Where to get in it ?:
One can find recruitment in ‘dot com companies’, advertising agencies, companies specialising in web designing , Internet Service Providers etc. Pentasiu.com is one such company recruiting web designers.

Salaries :
At the Entry level salaries are in the range of Rs.5,000 to 10,000 and goes over Rs.15,000 at middle level.
NETWORKING

Careers :

Network designer, Network Manager, Network data Administration, Network Services and Support Manager, LAN service/Support Manager.
Convergence of technologies primarily calls for a networked environment. In such an environment, network engineers are required to keep the system up and running all the time.
A net working professional should have well-honed technical skills, specialisation in certain areas is preferred. Technical skills are considered more important than conceptual skills at the entry level. The entry level personnel are likely to be focussed on tasks like trouble shooting, monitoring LAN performance and its security, adding or deleting of users, adding on new servers.
How to become one of it:?

BE graduates could opt for this career option. BE in computer science, electricals communication preferred. In Addition certification programmes are available from Microsoft, IBM, Novell and Lotus Development Corporation.
The Microsoft certification curricular (22 days) costs around Rs.28,000; Lotus Certification Curriculum (26 days) costs around Rs.20,000.
Where to get in it ?:

Scope appears to be unlimited in the IT Sector, telecom companies, manufacturing and service sector. A few companies who have recruited people for networking include WIPRO, Microland, BFL Software and Infosys.
Salaries :
Entry level salaries are upward of Rs.10,000 and can go up to Rs.20,000 at mid level.
E Commerce

E-Commerce is the emerging paradigm in the world of business today. Most IT companies appear to be focusing on building e-commerce capabilities.
An e-commerce professional’s work would involve understanding operations of companies, web enable their businesses and connect them with their vendors and customers. It would essentially means reorient businesses to be performed on the Net.

How to become one of it ? :

Basic qualification required is B.E./B.tech, DCA/MCS. In addition, knowledge of VC ++, Oracle, SQL, ASP, HTML, Java, Servtets, EJB,CORBA, COM/DCOM is essential.
Most computer institutes offer the above courses. Some of the reputed institutes offering e-commerce courses are STG, NIIT, APTECH, OCAC etc. A six month e-commerce programme in a reputed institute costs Rs.50,000 upwards.

Where do you get in ?

IT companies working in the area of E-commerce, companies which are developing e-business solutions and the user industries would recruit e-commerce specialists.
A few companies that have recruited the e-commerce specialists are CBSI, BFL, Satyam Infotech, Mastek and Infosys.

Salaries :
At the Entry level compensation packages can start anywhere between Rs.10,000 to Rs.14,000. In two to three years one can expect to draw around Rs.18,000 to Rs.20,000 per month.
DATA WAREHOUSING

Data warehousing, which is a repository of organised data, facilitates on-line analytical processing, decision support and data mining data marts are smaller versions of the enterprise data warehouses.Data warehousing essentially helps users in drawing conclusions from a set of data, which are not necessarily logical.
The popularly known data warehousing tools are the Rapid data, SQL bench and Red Brick (a product of Informix).
How to become one of it? :

ABE Computer Science/B.tech/MCA with a minimum of one year experience in the IT industry are preferred, knowledge of RDBMS is essential.
Institutes like RCS Education, Bangalore (offers courses on Red Brick) and OBSI, Chennai are now offering product specific training.

Where do you get in ? :

You could join any of the data warehousing solution providers or user industries. Currently data warehousing companies like TCS, Sonata, Tata Infotech and IBM do recruit data warehousing professionals.
Salaries :
The salaries start upwards of Rs. 15,000 and for some one with more than two years experience it can go up to Rs.25,000 to 30,000.
SYSTEMS
Systems Software specialists continue to be in demand. However, specialisation is the need of the day. Hence right from the start one needs to focus on areas in which one would like to specialise. For instance, telecom software would involve writing programms, coding and module testing of sub-systems, source code documentation in the areas of digital signal processing, wireless application and related telecom domain areas.


How to become one of it? :

A B.E./B.tech in electronics, communication or computer science or M.tech with specialisation in systems are preferred. In addition, basic knowledge of skills like C, C ++ is a must. Some specific technical skills preferred include GSM, TDMA, CDMA, WLL, etc.
Where to get in it? :
Companies working in the systems domain are likely to recruit such professionals. Motorola, Philips, Lucent, Texas Instruments and SAS are some such companies.
Salaries :
Starting salaries range from Rs.12,000 to 15,000 per month. After two to three years in the industry, salaries could be more than Rs.25,000. Most companies are now adopting performance-based packages.

RBN-INFO-TECH