This week we provided training sessions SMS and Symbian under Wireless, Relational Databases, SQL Keys and SQL Table Commands under Database sections.

Knowledge Base Latest Updates

Wireless

What is SMS
SMS, which stands for Short Message Service and is also referred to as “text messaging,” is a cheaper alternative to making phone calls from mobile phone to mobile phone, instead sending short messages between them. The 1985 Global System for Mobile communications (GSM) series of standards included SMS among its standards.

What is Symbian
Symbian is a proprietary operating system for wireless telecommunications, succeeding Psion Software’s EPOC. Released in 1999, it is owned by a number of companies: Nokia with 47.9% of the share, Ericsson with 15.6%, Sony Ericsson with 13.1%, Panasonic with 10.5%, Siemens AG with 8.4%, and Samsung with 4.5%. Symbian was designed for handheld mobile

Database

Relational Databases
What is a Relational Database? Popular, modern databases are built on top of an idea called “relational algebra”, which defines how “relations” (e.g. tables and sequences in databases) interact within the entire “set” of relations. This set of relations includes all the relations in a single database.

GeekInterview.com Blog Articles

Avoid the Job Hunting Stress
By Chandra Vennapoosa
It’s always frustrating to jump from one interview to another without any luck. Be careful, you might have the “job hunter’s stress”. By the name alone, this type of stress is targeted to individuals who have been looking for a job for sometime without any luck. If you’ve been suffering from this, you might want to take it easy as this type of stress will cost you your ability to get a job. Read the rest..

Great Things about Being a Temp
By Chandra Vennapoosa
A temp job is often seen as a thankless job with an end that is always in sight. Some people think that being on a temporary job means you don’t have specific skills that could impress other companies so you’re stuck in a temporary job. The pay is also lower so naturally people are expecting more so that they will have the financial stability they wanted. Read the rest..

Bored with your Job? Don’t Just Leave Yet
By Chandra Vennapoosa
Working is a necessity for us adults since it is only through work that we get paid which in turn puts food in the table. Everyday people are either looking for work or striving to be better in their selected business. Kids who are either in high school or college always try to figure out what they will do after school. Often we just don’t think of a job but we focus on a career. Read the rest..

Passing through the Head Hunters
By Chandra Vennapoosa
There are companies who use the power of searching through keywords to filter the resume for possible candidates. On the other hand, there are companies that have a human resource department that manually takes a look at the resumes one by one. Usually these are small to medium sized businesses or a company that has a large human resource department. The human resource department usually screens the resume manually when you personally hand them over your resume and uses the keyword strategy for screening the resumes. Read the rest..

Scannable Resume
By Chandra Vennapoosa
Large scale companies receive thousands of resumes everyday that they don’t have time to read all the resumes and file them for future use. Instead, they have conceived an idea in scanning the resumes and filtering them through keywords. Using keywords, they will find their ideal candidate without having to skim through each copy of the resume they receive everyday. That’s where the idea of a scannable resume is born. Read the rest..

Ajax Articles

● Dark Side of UpdatePanel on Web Navigation

● Optimizing the Server Side of Ajax

● Some DOM Tricks to Your Website

● How can Ajax get you into trouble with Google

● Taconite: The Power of Simplicity

● WaveMaker Releases Visual Ajax Studio for Mac

● Expanding the Browser to a New Level

Free Training

Using XML Schemas
The simplest way to create an XMLType storage structure in Oracle XML DB is by registering an appropriate XML schema against the database. As a part of the registration process, Oracle automatically creates the storage for a particular set of XML documents, based on the information provided by the schema.

Retrieving XML Data
To retrieve XML data from an XMLType table, you can use a SELECT SQL statement, just as you would if you had to query a relational table. For example, to select the employee with the id set to 100 from the employees XMLType table discussed in the preceding section, you might issue the following query from SQL*Plus when connected as xmlusr/xmlusr:

Performing DML Operations on XML Schema Based XMLType Views
Analyzing the underlying query of the empSch_v view discussed in the preceding section, you may note that each attribute of the EMP_T object used in the select list maps to a certain column of a single table, namely emps. What this means in practice is that the empSch_v view can be inherently updated, so you can perform DML operations against it without having to write INSTEAD-OF triggers.

Using Oracle XML DB Repository
Another variation on accessing and manipulating XML content stored in Oracle database is provided by Oracle XML DB repository, which is an essential component of Oracle XML DB.

Accessing Repository Resources with SQL
In fact, Oracle XML DB repository resources are stored in a set of database tables and indexes, which can be accessed via SQL. You are not supposed to access those tables directly. Instead, Oracle XML DB provides two public views RESOURCE_VIEW and PATH_VIEW through which you can access repository resources.

Taking Advantage of Standard Internet Protocols
As mentioned, Oracle XML DB provides native support for standard internet protocols, such as HTTP(S), WebDAV, and FTP. Continuing with the preceding sample, you might, for example, upload another employee XML document into the XML repository with one of the above protocols, say, FTP.

Querying Data with Oracle XQuery
Starting with Oracle Database 10g Release 2, you can take advantage of a full-featured native XQuery engine integrated with the database. With Oracle XQuery, you can accomplish various tasks involved in developing PHP/Oracle XML applications, operating on any kind of data that can be expressed in XML.

Breaking up XML into Relational Data
While the preceding example shows how to construct an XML representation over relational data, the example in this section illustrates how you can shred XML data back into relational data. This reverse operation can be useful if your application works with relational data rather than XML, but the data which you work with, is stored in XML format.

Business Intelligence Integration
How to Integrate Business Intelligence within Your Organization Before you Integrate Business Intelligence into your Organization Business Intelligence has developed into strategic process over the years of its extraordinary growth, even so it still needs to be incorporated into each business process with great care in order to properly lead business operations onto the path of attaining their individual strategic objectives.

Managing SQA Projects
No matter how big a project is, there will always be a person who will be overseeing the whole project. They are usually the project managers and in this case, called the SQA managers. SQA managers are always at the forefront of everything, answering to the business manager regarding the status of the application and informing the subordinates regarding updates or the new policies about the application. That is generally the work of every manager, supervisor or anyone who has people working under their guidance. But to be specific each manager in every field of work has different approaches in guiding their subordinates.