What is GCFA certification? Overview GCFA certification stands for GIAC Certified Forensic Analyst. It is a cybersecurity certificate managed and offered by GIAC. It validates that candidates have the knowledge, skills, and ability to conduct formal incident investigations and handle advanced incident handling scenarios. The exam evaluates candidates for their capabilities in internal and external […]
What is ECIH certification? Overview ECIH certification stands for EC-Council Certified Incident Handler and The International Council of E-Commerce Consultants (EC–Council) offers and maintains the certificate. And before further discussing the exam, it makes sense to broadly understand what incident handler means in cybersecurity perspective. In essence, it is a concept used to describe the […]
DECODE Function DECODE Function is an oracle database conditional function and has more than three parameters. The function returns different values based on the values of the comparison condition parameter. The syntax for DECODE Function is: DECODE(expr1,comp1, iftrue1,[comp2,iftrue2…[ compN , iftrueN]], [iffalse]) if the value of the ‘expr1’ and ‘comp1’ parameters are equal, the function […]
COALESCE Function COALESCE Function is an oracle database function and has many parameters. The function returns the first parameter from the list that has nonnull value. The syntax for COALESCE Function is : COALESCE(expr1, expr2,…,exprn) The value of the ‘expr1‘ parameter above is returned if it is not null, unless the value of the ‘expr2‘ […]
NULLIF Function NULLIF Function has two parameters and checks whether the value of these two parameters are equal or not. The syntax is : NULLIF(ifunequal, comparision_term) If the ‘ifunequal‘ parameter value and the ‘comparision_term‘ parameter value are equal, the function returns NULL value unless it returns the ‘ifunequal’ parameter value. Example: Connect to your oracle […]
NVL2 Function NVL2 oracle function checks whether the data type of a column or expression is null or not. The syntax for NVL2 oracle function is: NVL2(original, ifnotnull, ifnull) If the value of the ‘original’ parameter is not null, the function returns the value of the ‘ifnotnull’ parameter unless the function returns the value of […]
The DEFINE command Oracle define command enables us to define and create session level variables. when we select and run SQL statements, these session variables are referenced using double ampersand substitution(&&). Before defining and creating these variables, we have to make sure that the oracle SQL client tools such as SQL*PLUS and SQL developer ,that […]
DESCRIBE command DESCRIBE SQL table command in oracle database enables us to view or display the structure of a table. And we can run this command using oracle client tools such as SQL*PLUS and SQL developer. SQL*PLUS is a client tool which will be installed by default when we install and create oracle database software […]
Git Best Practices Commit Related Changes A commit should be a wrapper for related changes. Example: fixing two different bugs should produce two separate commits. Commit Often Committing often keeps your commits small. Small commits make it easer for other team members to understand the changes and roll them back if some thing went wrong. […]