Search This Blog

Tuesday, June 27, 2017

How to Install MySQL on Windows machines

First of all download the mysql setup following instructions as in How to Download MySQL for Windows machines.

Now Double Click downloaded mysql-installer-community-5.7.18.1

Click Run in case a Security warning pops up as in screenshot below:


Accept the license terms and Click on Next

Friday, June 23, 2017

How to Download MySQL for Windows machines

In order to learn SQL you need to Download, Install and Configure Mysql on your machine. Here's how to Download it:

1. Go to https://dev.mysql.com/downloads/installer/

This is a freeware community edition. You need to buy commercial license for enterprise business editions for commercial use.

2. Select 32/64 bit version as per your system. Click on Download.



Thursday, June 22, 2017

Basics of Create Table statement in SQL

Here are basics of Create Table statement in SQL to get started and have a hands on experience.

1. Create Table : 

CREATE TABLE MyFirstTable(
   column1  INT  NOT NULL,
   column2  VARCHAR (20) NOT NULL,
   column3  INT NOT NULL,
   column4  CHAR (25) ,
   PRIMARY KEY (column1)
);
Explanation:

Thursday, March 16, 2017

Testing: What's important when u have over 5 years of expertise?

1. Don't let developers teach you what to test and what not to. Teach them to code well.

2. Behind every good & successful developer, there's an evil tester making his life miserable to justify his package :D

3. Behind every bug, there's a disrespect, rather oxygen that keeps a developer alive.

Friday, June 3, 2016

10 things to keep in mind if you are a boss

"A good manager is a man who isn't worried about his own career but rather the careers of those who work for him." - H.S. M Burns

Yeah! I'm back blogging again after a day's break! Not much to say about your boss or mine, but just a couple of things if you stargaze to be a cool foreman or a Manager down the line (What I think ;))

1. Respect them: Never, ever think call your team members as resources (They think they're materialistic things/ alive-machines)

Monday, May 30, 2016

10 Benefits of a New and a Better workplace


So I haven't posted on my blog for a while... but recently our office was shifted to a new location (which is far better than the previous one ;) ), so I think I must share what I feel what all things you feel mentally, emotionally and physically when your workplace changes.

1. Your mind gets boosted with creativity, what all things you can place on your desk.
2. New shades of grey; new colors cheers you up.
3. The new environment refreshes you up enhancing your productivity.
4. You get new neighbor buddies to chitchat with.
5. You start exploring for new places to enjoy Sutta with a cutting Chai.

Tuesday, April 26, 2016

Benefits of working at Startups in India

Having almost 5 years of experience in IT firm I've been associated with 2 startups lately it would be hard to compare startups with the well settled MNC's  having lots of shares in the stock exchange.

This is an era of cockroach startups. Everybody out there is wondering how to start a small business somehow. Everybody wants to run the same race and win. Believe me everybody wants to get richer in less time. 


Tuesday, March 29, 2016

Query to find duplicate records with count in a specific column of a table

Query to find duplicate records with the count of their occurrence in a specific column of a table:

SELECT column_name,COUNT(*) AS count
FROM  table_name
GROUP BY  column_name
HAVING count>1;

Tuesday, December 8, 2015

How to install Java,Maven and setup environment variables for Selenium

Environment setup
Install Java  7+
Download and install JDK 1.7 or higher version on your machine.
Download link: JDK 8


Set environment variables:

  • Add to PATH -> C:\\bin
  • Check JAVA version by running command "java -version"

Wednesday, October 28, 2015

Login to Gmail using Selenium Webdriver

If you have just started with Selenium and struggling with creating and executing your first test case, here's a script to Login to Gmail using Selenium Webdriver.

Once you Login to Gmail using Selenium Webdriver you will get enough confidence to move on further and automate whatever you like:

Here's the code to automate Login to Gmail using Selenium Webdriver: