Learn MySql

MySql remains one of the most popular database around and it has maintained its popularity even in the age of large number of nosql databases. It remains one of the easiest database to use and at the same time it is stable enough to host successful comapnies (for example, companies like uber, facebook, yahoo all use MySql for many of their use cases)

  • [MySql - Finding Duplicates in a Column](/...

...read more

(MySql) Join Two Columns to Single Column

Many times one want to join 2 columns in a MySql table. For example, you have saved 'First Name' and 'last name' in separate columns and now want to get 'Full Name' as part of query output.

...read more

(MySql) Finding Duplicates in a column

Many times, we need to figure out if there is a duplicate in a particular column of a database. Here is a quick guide on how to find duplicates in a column in MySql.

...read more

(MySql) How to disable Sql Mode like ONLY_FULL_GROUP_BY

MySql supports the concept of sql modes which are global configuration for every sql command. Sometimes one needs to remove particular sql mode like ONLY_FULL_GROUP_BY. Here is a quick guide about how to disable sql modes.

...read more

(UI / UX Design) Sketch for Windows - How to run Sketch app on Windows

If you are into web and digital designing, you are either already using Sketch app or have heard a lot about Sketch app. For the beginner, sketch app is a vector graphics editor for digital design. As of 2017, Sketch is probably the most popular digital design editor in the market and is loved for being lightweight and easy to use interface. It is paid software available for $99, but the biggest ...

...read more

Git Checkout a Remote Branch - Step by Step Guide

During last 4-5 years, git has captured the market for version control system completely. Here are step by step guide about how to checkout a git remote branch.

...read more

5 Strategies for using Whatsapp for Marketing and Business Campaigns

Whatsapp has become the most popular messaging platform in the world - with a user base of over 1 billion reported in Feb 2016. Beyond text messaging, it has enabled voice calling in 2016 and by June 2016 more than 100 million voice calls were made per day. Whatsapp has amazing reach and massive percentage of active users - thus making it one of the most promising platforms for social engagement ...

...read more

Google Adsense Account Enabled Only to Show Ads on Youtube - How to show ads on other sites

Lately lot of people have been signing up for adsense through youtube as this is one of the easiest way to get approved. But this signup only enables the so called 'hosted adsense' account and you can't show adsense ads on your blog/website.

In such cases, if you login to your adsense account, you will see following warning message:

Your AdSense account is enabled only to show ads on YouTube...

...read more

React Native Javascript: Unhandled Promise Rejection Warning

While working with javascript promises, I have been getting erors like:

UnhandledPromiseRejectionWarning: unhandled Promise Rejection (rejection id:1)

Typically this is a good hint that error handling is not implemented properly for your promise. To make it simpler, here is quick guide on Javascript promise and right way to error handling.

A promise is a good way to do async processing in ...

...read more

Google Adsense Responsive Layout - How to hide sidebar ad on mobile

In a mobile first world, it is becoming very important to create responsive websites that work seamlessly on multitude of screen sizes for desktop, mobiles, and tablets. To address this problem from ads perspective, google adsense has been supporting responsive ads for sometime now. But it is not a magical solution and much work needs to be done to ensure optimum utilization of ads across ...

...read more