SQL DATABASES -SQL GROUP BY

SQL DATABASES -SQL GROUP BY The GROUP BY clause is usually used with an aggregate function (COUNT, SUM, AVG, MIN, MAX). It groups the rows by a given column value (specified after GROUP BY) then calculates the aggregate for each Read More …

Share this:

MULTIPLE CONDITIONS IN SQL DATABASES

MULTIPLE CONDITIONS IN SQL DATABASES You can use more than one condition to filter. For that, we have two logical operators: OR, AND. SELECT * FROM table_name WHERE column1 != ‘expression’ AND column3 LIKE ‘%xzy%’; This query returns every column Read More …

Share this:

SQL Databases

DATA TYPES IN SQL In SQL we have more than 40 different data types. But these seven are the most important ones: 1. Integer. A whole number without a fractional part. E.g. 1, 156, 2012412 2. Decimal. A number with Read More …

Share this:

Logistics Management Information Systems

Logistics Management Information Systems A logistics management information system (LMIS) is a system of records and reports – whether paper-based or electronic – used to aggregate, analyze, validate and display data (from all levels of the logistics system) that can Read More …

Share this:

SYNCHRONIZATION IN DISTRIBUTED SYSTEMS

CLOCK SYNCHRONIZATION Every computer needs a timer mechanism (called a computer clock) to keep track of current time and also For various accounting purposes such as calculating the time spent by a process in CPU utilization, disk I/O and so Read More …

Share this:

Performance management

The performance management system should provide benefits to both the employee and to the organization. For the individual, the appraisal should provide a management information system for making management decision as well as a toll for improving performance. Today’s organization Read More …

Share this:

Guidelines for Conducting an Interview.

1. Plan the Interview Being by reviewing the candidate’s application and not any areas that vague or that may indicate strengths or weakness .Review the job specification and plan to start the interview with a clear picture of the traits Read More …

Share this:

Common Interviewing Mistakes

1. Snap Judgements One of the most consistent findings in the interviewing literature is that interviewers tend to jump to conclusions- make snap judgments about candidates during the few minutes of the interview, or even before the interview begins based Read More …

Share this:

Basic Testing Concepts

Effective selection is therefore important and depends, to large degree on the basic testing concepts of validity and reliability. I .validity A test is a sample of a person’s behavior, but some tests are more clearly representative of the behavior Read More …

Share this:

EMPLOYEE TESTING AND SELECTION IN KENYA

One of the biggest challenges facing firms lies in the process of testing and selection of employees. A firm that fails to lay emphasis on this process will find itself experiencing a high employee turnover. The purpose of this lesson Read More …

Share this: