CASE Statements in A SQL UPDATE Query

• UPDATE
• [account]
• SET
• balance =
• (
• CASE
• WHEN
• ((balance - 10.00) < 0)
• THEN
• 0
• ELSE
• (balance - 10.00)
• END
• )
• WHERE condition

DBA /BI Engineer Post

Country: Tanzania

City: Dar Es Salaam

Qualification

• A Bachelor’s degree in Computer Engineering, Computer Science, Industrial Engineering/Operations  Mathematics, Management Information Systems.
• Skills in Database operations, SQL queries, etc
• Knowledge of best practices and principles for ETL, data modeling, dashboards, report design, analytics, and data mining
• Strong work ethic
• Ability to multi-task effectively and be comfortable working in a fast-paced, dynamic environment without close guidance or supervision
• Strong leadership skills
• Excellent verbal and written communication skills
• High degree of attention to detAILS

dEADLINE 16/07/2013