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 …
Day: February 1, 2022
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …