Skip to main content

Featured post

5 Super SEO Blogger Tools

In this post, I have explained top blogging tools that need to be considered by every blogger. These tools help you write better SEO friendly blog posts.



1). Headline Analyzer The best tool is the EMV Headline Analyzer. When you enter the headline it analyzes it and gives you EMV ranking. When you get '50' and above it performs better SEO.

2). Headline Length Checker The usual headline length is 50 to 60 characters. Beyond that, the headline will get truncated and looks ugly for search engine users. The tool SERP Snippet Optimization Tool useful to know how it appears in the search results.

3). Free Submission to Search Engines The tool Ping-O-Matic is a nice free submission tool. After your blog post, you can submit your feed to Ping-O-Matic. It submits to search engines freely.

4). Spell and Grammar Check Another free tool is Grammarly, this tool checks your spelling and grammar mistakes. So that you can avoid small mistakes.

5). Keyword AnalyzerWordstream Keyword analyzer i…

SQL top ideas on how to use built-in functions correctly

In this post I am giving top examples on SQL functions. About built-in functions, I have covered in my previous post.
sql examples on built-in functions

List of Built-in Functions

  1. DATE-TIME functions
  2. Numeric functions
  3. Char functions
  4. Null-related functions

1. DATE/TIME functions

SELECT p_code, launch_dt, CURRENT_DATE FROM product;
CURRENT_DATE returns current date.

SELECT p_code, TO_CHAR(launch_dt, 'DD MONTH YYYY') reformatted_dt FROM product;
TO_CHAR function returns DATE in CHAR format.

2. Numeric functions

SELECT p_code, price, (price - 20), ABS(price - 20.00) FROM product;
ABS - function returns absolute value

SELECT p_code, price, ROUND (price, 1) FROM product;
ROUND function - Round to 1 digit.

SELECT p_code, price, SIGN(price - 15) FROM product;
SIGN function - It returns sign; either + or -

SELECT p_code, price, TRUNC(price, 1) FROM product;
TRUNC function - Truncates to a certain number of decimal places.

3. CHAR functions

SELECT p_code, CONCAT(CONCAT(p_name, ' -- ') , price) FROM product;
CONCAT function - concats two strings.

SELECT p_name, LOWER(p_name), UPPER(p_name) FROM product;
UPPER function returns upper case.
LOWER function returns lower case.

SELECT p_name, LENGTH(p_name) FROM product;
LENGTH function returns length of the string.

SELECT SUBSTR(phone, 3) FROM customer;
SUBSTR function returns sub string from main string.

4. Null related functions

SELECT p_name, price, min_price,
COALESCE((price * 0.9), min_price, 5.0) sale_price FROM product;

COALESCE function: returns first non-null value from the expression.

Summary
  • Given list of top built-in functions
  • Example SQL queries on built-in function given for you to read quickly
  • These examples are almost common in any RDBMS

Comments

Most Viewed

Tokenization story you need Vault based Vs Vault-less

The term tokenization refers to create a numeric or alphanumeric number in place of the original card number. It is difficult for hackers to get original card numbers.

Vault-Tokenization is a concept a Vault server create a new Token for each transaction when Customer uses Credit or Debit Card at Merchant outlets 
Let us see an example,  data analysis. Here, card numbers masked with other junk characters for security purpose.

Popular Tokenization ServersThere are two kinds of servers currently popular for implementing tokenization.
Vault-based Vault-less Video Presentation on Tokenization
Vault-based server The term vault based means both card number and token will be stored in a Table usually Teradata tables. During increasing volume of transactions, the handling of Table is a big challenge.
Every time during tokenization it stores a record for each card and its token. When you used a card multiple times, each time it generates multiple tokens. It is a fundamental concept.
So the challe…