Sunday 23 December 2018

How to create your first ReactJS application online


We are going to create our first program in react js we don't need to do any setup because we are going to use Codepen.io.
React js is a Library for creating the better Application Design.
Here is my code -:

//HTML //

<div id="app"></div>

//CSS//

.person{
  display:inline-block;
  box-shadow: 0 4px 4px #ccc;
  border-style:solid;
  width:200px;
  border-radius:10px;
  border-shadow:2px 2px;
  margin:20px;
  paddin:20px;
  text-align:center;
  font-family:arial;
  background-color:#008080;
  color:white
}

//React JS Code//

function Person(props){

  return(
  <div class="person">
  <h1> {props.name}</h1>
  <p> Age :{props.age}</p>
</div>
  );
 }
var app = (
  <div>
  <Person name="mariay" age="23"/>
  <Person name="Zerry" age="23"/>
  <Person name="jono" age="24"/>
</div>
);

ReactDOM.render(app,document.querySelector("#app"));

  




Monday 10 December 2018

How much does it cost to build a website in India 2019?

Almost everyone will say cost depends on your need which is true but is incomplete. Cost of development also depends on whom you hire what processes he takes and how much he thinks truly in your interest.
It’s not a good idea to spend for the things you don’t need in reality.
In most of the cases, the client doesn’t have any idea of technical things & their costs (in term of money, the time required & skill level).
Like a simple problem in maths can be solved in no. of ways the same feature can be designed in a no. of ways. One way can take 2 min to solve a problem other can take 2 hrs or even more.
As a customer or client, the important thing for you is to fulfil your needs in the best possible way without the need for unnecessary expenditure. Also giving you enough flexibility at the same time.
But the Irony is that the same is rarely a concern for most of the developers or web development agencies out there.
Let’s come to cost. There are three major costs:-
  • Domain Name
  • Hosting
  • Design
Let’s talk about each in little detail:-
Domain:- (aka name of your website):- It’s a fixed cost, which costs around 600–1200 INR/Year. You can check their prices here on Godaddy (you can easily get discounts in most cases which can lower this cost to almost 500 INR/Year for 1st 2 years).
Hosting:- You need a computer called server to keep your website file which is always connected to the internet. For this, you need a Hosting Providers (Ex:- Bluehost, Siteground, Godaddy etc).
Before coming to cost there are few things you should understand.
Like your mobile has limited RAM and Storage. Same is there in case of the web server. Your mobile’s RAM decides no. of apps (depending upon size) you can run simultaneously in cases of server it decides how many visitors it can handle at a time.
(It is just an illustration of major factors, there are many factors also which matters)
Hosting Cost, You can get it for free also(with many restrictions on RAM, Storage etc) but few free hosting providers can give you enough to handle 100–500 Visits for simple information websites with 99%+ uptime.
You should opt for paid hosting. Which starting around 2k per year to 5k per year (Enough for most of the Small and Medium-sized business). There are also dedicated hosting which many large organisations opt for which can costs more than 10K INR per month too.
I use bluehost.com & 20i to host my 90% of the client website.
SSL:- (Green padlock symbol with the secure word in URL bar in most browsers). You can get this for free but many paid hosting providers like Bluehost with just a click or a contact to support. The free certificate if enough in most cases of small and medium business.
Business emails:- This is also something you can get for free many hosting providers give 5 or more free emails with their most of hosting plans. 5 emails are enough for most of the small and medium-sized business. In case you need unlimited email a bit research is needed and many hosting providers provide this too free with their hosting plans.
Note:- It's important to know your need or say the potential amount of size and amount of use of your website. So that you spend just for what you need. You can migrate your site from one hosting provider to other anytime.
Migration Cost:- For medium websites (like of a school, college etc) just a few hours to a day. Depends on developer how much he charges. If your site is on CMS like Wordpress, Joomla etc. Anyone can learn how to migrate less than an hour and do it himself.
Let’s come to the most important part least known to a typical customer and most flexible cost.
Design:- If what the developer takes for his time is excluded. It can cost zero to anything like 10K+ even for a simple website (like of a school/college etc.)
Let me explain you this with a simple illustration.
Suppose you need to edit a photo (you just need to add a text over it) you know one photo editing tool Adobe Photoshop. You go and buy it for one year for around 8K INR.
Although you could have done the same with many free tool even with the gallery app of your phone but lack of knowledge of available tools cost you much.
Similar things happen in design also, for example, there are tons of good free Themes which can easily fulfil your needs but you or your designer may be convinced to go buy premium themes (although you don’t need that much or will never use extra premium features).
We all know technology is getting cheaper day by day.
Like app in your phone adds extra features there are ( in PHP, WordPress, Joomla etc) plugins which add an extra feature like QnA Platform, Classified Platform, Chat, Push notification etc to your website. They could be free or paid. In many cases, you can get almost the same thing for free of a similar version from another provider for a few dollars.
So, It’s important that your developer has the knowledge of free tools also and thinks in your best interest in order to get the best for your hard earned money.
Cost of designing (in the Indian market) varies from 3K (like for a small static informational website to 30K+ like for an e-commerce website.
Remember your design cost will largely depend on the skills/qualification of developer and the time he invests on your project and time depends largely on the process, not the final result.
A simple illustration, you can hire an IITian to teach maths to your kid of 5th Standard or Hire a 12th Standard student good at maths and explaining things. Although both with give the same amount of time and will teach almost the same but you will have to pay much higher in 1st case.
Summing Up:- You can get your website live with as little 1k including domain, hosting and design or can cost you 20k+ too you need a large website with lots of features.
This answer has been written in the context of needs of most of the individual, small or medium businesses with a purpose to create awareness so that they can get what they need at the best budget.
By now I hope your most of queries related to website cost have been cleared yet.
I am a self-taught Web Developer, who always researches a lot before spending money so that I get what I actually needed at the best price. Be it a domain name, Hosting provider to themes or plugins.
Your Upvote can help this answer to spread to more no of people. Where too many misleading answers are moving out there.
If you are a self-employed professional, small business owner, run institution/school/college/coaching etc. Feel free to reach to me. I’m sure I will be the best fit for you.

Don't hesitate to call me or Email me.
Consultancy and Suggestion are Totaly Free of Cost.
You can contact us for website designing and development

Sourabh Dubey
Website-: www.minzor.com
Email-: sourabh@minzor.com
 -:  +91 8770689525
-:   +91 8656071107

Thank You 😊

Thursday 25 October 2018

How to backup & restore your wordpress website in 3 minutes free 2018

So in this video, we will demonstrate how easy it is to setup backup plugin on a WordPress website. It's 100% free and one of the best WordPress backup solutions available in the market!

The Coding Bus

Friday 19 October 2018

How to Choose a Great Domain Name for Your Business

Choosing the right domain name (and one that sits well with your brand and audience) is vital for sending out the right message and making sure your website gets the hits it deserves.
You might be thinking, “but surely my domain name will just be the same as my business?
The answer to that is yes and no. Yes, your domain name needs to reflect your business and align with it, but a little more thought needs to be put into it than that.
Here's 9 tips I’ve put together to help guide you in choosing a great domain name that keeps on working for your business!

Tip 1:  Stay Away from Keyword Stuffed Domains

The internet in the 90s and early 2000s was filled with keyword stuffed domain names, like “EasyChickenRecipes.com” – essentially, they were made up of keywords that people searched for in Google.
Today, keyword-heavy domains don’t have as much power as they used to. Instead, you want to hint at what it is you do without getting all 90s.
So, if you run a website that provides thousands of easy chicken recipes, you might go for “ChickenChef.com” instead of the keyword-heavy “EasyChickenRecipes.com”.
People will be able to tell what it’s about (chicken), but it has a bit of character and personality.

Tip 2: Make it Brandable

Think about your brand and what kind of “experience” you want your audience to have – do you want to send out a fun and carefree vibe? Or something more serious and corporate? Consider this when choosing your name, and make sure your domain reflects your brand.
If you run a Thai takeaway business and you want to send out a fun, youthful message, you might choose “EatThaiTonight.com” instead of “MoonriseThaiTakeaway.com”.
DID YOU KNOW? The most expensive domain name ever sold is insurance.com, which sold for $35.6 million in 2010.

Tip 3: Think of the Future

Where do you see your business headed in the future? Don’t make the mistake of creating a domain name from trending words that will go out of fashion in six months.
Instead, make sure you choose something lasting and that can evolve with your business. For example, if you’re a marketing agency, will you expand into web design services in the future? Make sure your domain name gives your business room to grow.

Tip 4: Keep it Short

As well as making sure your domain is on brand, you want to keep it short so it’s memorable. No one has time to remember a five-word domain, especially when it’s all bunched together in one, long unreadable sentence.
If your business name is long, consider shortening it or adding initials to keep your domain short and snappy.

Tip 5: Avoid Numbers & Symbols

Likewise, you don’t want to confuse people by adding numbers and symbols.
Ideally, you want your domain to include just letters all in one line without anything to break them up.
If your business name is “John’s Hairdressers” but your domain is “johns-hairdressers.com”, you might get a lot of people forgetting the “-” and going to the wrong place.

Tip 6: Check the Readability & Spelling

Following on from the last point, you want to make sure your domain name doesn’t include any tricky spellings that might trip people up.
Your domain name should be intuitive in its spelling and readability. People won’t just be seeing your domain when it’s written down, you might have to spell it out in person or voice it over the phone.
You don’t want to have to go over it again and again, and you want to consider how it looks when it’s written down (does that O look like a 0, for example).

Tip 7: Check if .Com is Available

The most common domain ending is .com, but this doesn’t mean it’s the only available ending.
In fact, you can now put whatever you want as the ending, so you might have Thai.Takeawayinstead of ThaiTakeaway.com!
It’s worth bearing in mind that most people intuitively type in .com, so check whether the .com is available, too, if you decide to go for another option, just so people don’t end up on a different site when they want to be on yours.
DID YOU KNOW? There are a total of 1519 TLDs (as of Nov 2016) and the .com TLD accounts for 50% of all registered domain names.

Tip 8: Check Whether the Social Channels Available?

It’s highly likely you’ll want to secure some social media handles for your business once you’ve set up your domain, so you might want to check whether the appropriate handles are available before you commit to buying the domain.
Check Twitter, Facebook, Instagram, and any other social media channels you want to use to see if anyone has already nabbed the name you want.

Tip 9: Check for Copyright

So you’ve gone through all of these steps and you’ve found a domain name that fully reflects your business that you’re ready to dive in with.
But hold up a minute. Before you go ahead and click that buy button, make sure there are no copyrights around it and that there are no similar brands using a similar name that your audience might get confused with.
While you want to choose a domain that’s in-line with your business and its goals, you also want to make sure it’s unique and memorable and, therefore, not like any others out there.
You also don’t want to get caught up in any nasty lawsuits in the future if you power on ahead with a domain name that’s too similar to another brand.

Conclusion

Choosing a domain name shouldn’t be something you do in fifteen minutes.
It’s something that takes a lot of thought and consideration as, often, it’s the first thing people will see when introduced to your business.
You might think your domain name is simply the series of letters that goes in the search bar, but it actually conveys a whole lot more about your business than you think. It shows what you’re all about and what kind of business you are running. You also want to make it easy for people to find you, so keeping things short, concise, and easy-to-understand is vital
refrence: howtogetonline.com

Wednesday 17 October 2018

How do I choose a good domain name?

Tip 1: Keep Your Domain and Website Name as the Same
Remember that you domain name should be your website name. This is because when people think about your website, the first thing that flashes on their mind will be your site name, thus if this name is also your URL, they will automatically know where to go. For instance, when people think of HowsHosting.com, they only need to type this site name into the browser, without the need to search for the web address.
In fact, this practice is especially important if you hold your site as an e-commerce one. Generally, you name your online stores with the company name, brand name, or the type of the main products, so you need to choose your domain accordingly, which can effectively reflect your business.
Tip 2: Focus on the Domain Name with .com Extension
It is worth trying to grab a .com domain name when you set up a new site, after all, the .com is the mostly used TLD, and is preferred by both visitors and search engines. Also, we highly recommend you redirecting other domains with different extensions to your main domain name that ends in .com.
Tip 3: Keep Your Domain Short but Not Obscure
It is far better to select a domain name which is short in length, because it makes easy for people to type and remember. Conversely, if your domain is long with a series of unrelated letters like http://tohwtognoe.com, how can people recall it and type it into the address bar? Besides, from the online marketing point of view, the shorter your domain name is, the more likely people will be to introduce your site to their friends.
However, keeping the domain short doesn’t mean that you have to name your domain like http://bwh360.com when your original choice is HowsHosting. In some cases, you need to expand your domain with some specific words, which can clearly explain your site, and in the meanwhile, make people feel easy to remember and type correctly.
Tip 4: Make Your Domain Name Be Unique
A unique domain name can be remembered easily. As a matter of fact, many single-word domains are not available, and you had better create a special word. Here are the suggestions: trying to compound two simple words (Facebook), to use a phrase, to blend some parts of two words, to tweak a word, to affix a word with a suffix or prefix, or to create a unique name that is creative and can be easily used as a brand name.
Tip 5: Keep Your Domain Name Simple
Keep away from some complex spellings and pronouncing because they are hard to remember. It is one thing to come up with a great characteristic name that is not difficult to remember. Another point you need to pay attention is to avoid hyphens. This is because when there is a hyphen in one domain name, people are very likely to forget where the hyphen should go, or even totally forget that this domain is separated by a hyphen.
What’s more, a hyphenated domain name might make readers confused with some similar domains. For example, if people want to type your domain, which is bluehost-hosting-review, but type in bluehosthostingreview instead, that might take advantages to your competitors, not to you.
Tip 6: Make Your Domain Rich in Keyword
Choose a domain name that is full of keywords that are related to the website. That is because when people think about your website, the first thing that comes to their mind is your website name. For example, if the website is something about cars, the site name might be Carsale.com or We Do the Research, You Do the Driving which must contain with the word “car”. Besides, including the keywords that people usually enter when searching for the products or services can help to improve your ranking in search engines (which increases traffic) and just makes more sense to the customers.
Tip 7: Make Your Domain Name Easily Understood
When readers look at or hear your domain name at the very beginning, this domain name should be easily understood which clearly tells what the website is about. Thus, it is very important for you to choose a domain that is easy-to-understand and can be used as a brand as well. The goal is to make the domain name to be passed on easily and to be memorable. This is more likely to happen if people don’t have to stop and think about how to say or spell it.
Tip 8: Focus on Your Website Content
Never choose a domain name of “cosmetic.com” for a fishing website. You have to make sure that the domain and your website content are highly related. It is possible that your website may contain multiple categories. In this case, you’d better choose a broad word that can summarize all your categories perfectly. For instance, if you website is used for the selling of balls, sneakers and sportswear, then you can choose the domain of “http://sportselling.com” or something else.
Tip 9: Avoid Duplication
Before purchasing the domain name, you have to make sure that it has not been used as the trademark and business name by any others. After all, domain duplication or infringement issue can cause a great mess for your fortune and website operation.
How to Choose a Domain Name For Your Web Presence
Tip 10: Try Your Best to Avoid Hyphens and Numbers
You always need to bear in mind that anything that can cause confusion and misunderstanding should be avoided. In this case, you’d better not to add any numbers or hyphens into your domain name. After all, if people hear your domain name, they can be confused that whether you are using the Arabic numbers or spell the number out. Also, they may forget the exact number and the number location. As for the dash or the hyphens, people are likely to forget the existence.
Tip 11: Make Your Domain Name Brandable
This tip is really important for some business sites or the official portals and platforms. Making your domain brandable means when people see or hear your domain name, they will realize your brand instantly. Generally, a brandable domain name has the following features.
  • No hyphens and numbers for they sound strange and unprofessional.
  • The domain should be easy to say and to remember.
  • The uniqueness must be ensured.
  • No trademark infringement against other business.
Tip 12: Do Not Use Doubled Letters, Numbers and Characters
We highly recommend you to avoid the use of double stuffs, including characters, letters and numbers. After all, the double situation may confuse your readers and most people are likely mis-spell your domain name unintentionally. This can lead to the loss of traffic.
Tip 13: Leave Some Rooms to Grow and to Expand
Generally, we do not recommend you to use a specific keyword for your domain name. After all, this may limit your future possibilities and growth. For instance, if your website currently is about biscuit cooking and you use the word of “biscuit”, it can be hard for you to make your web content broad to other baking fields.
In this case, when choosing a domain name, you can make it related to your target niche but not to be specific. This gives you enough room to grow and does not require you to move to a new domain when you want to add something new to your website.
Tip 14: Act Fast
You should know that domain names sell really fast. After all, they are not the expensive stuff and the registration process is quite simple. In this case, many people will register their target domain far before they start creating a website. Therefore, once you have found a perfect option, you’d better make the purchase as quickly as possible.
Tip 15: Choose A Trust-worth Domain Registrar
There are many bad stories that some small domain registrars suck for their customers’ domain names. Typically, many registrars prevent their customers moving away by locking the domain name. In the worst case, some SCAM registrars directly take the domain name to be their own if you’re closed to be successful. So, you shall register a domain name with a trust-worth provider.

What is the most cheapest web hosting service in india for unlimited websites?

These days many website hosting companies in India Offering web hosting services at affordable prices but it is very crucial to find a reliable and best web hosting service for your website or online application. If you are looking for cheapest web hosting service in India for unlimited websites I would recommend you to visit Top 10 Best Web Hosting Companies Here you will be able to discover the list of best hosting services in India. All of the listed website hosting provider offers great features and benefits. Following are top benefits you will get with cheapest web hosting packages:
  1. Free domain name or Domain Transfer: In case you buy web hosting from a reliable web host, you will be rewarded with a free domain name or transfer.
  2. Upto 90 Days money back assurance: You will get upto 90 days money back guarantee
  3. 99.99% server uptime: You will be offered 99.99% uptime guarantee with cheapest web hosting packages
  4. 24/7 Technical Support: You will be rewarded with 24/7 expert support via multiple ways.
  5. 1-Click Installation of important software's/applications: 1-click install of every important applications such as magento, Prestashop, wordpress, Opencart, Joomla and many more..
  6. FREE SSL Certificate for the security of your website
  7. Free easy to use Website Builder tool to create your website easily
Recommended cheapest web hosting services in India for unlimited websites:
  1. Bluehost : India’s most trusted, reputed and best web hosting company. Currently they are hosting around 2 MILLION websites worldwide and with being in the website hosting industry for 18+ years they have gained huge trust.
Their cheapest web hosting packages starts from as low as $2.95/month with free domain name and 1-click WordPress install.
Top reasons to choose Bluehost as your hosting partner
  • Official 'WordPress' recommended hosting provider in India.
  • Free ‘.com’ domain with web hosting packages.
  • One-click installation of WordPress
  • 24*7 expert technical support
  • Advanced Optimization for Email & E-commerce Hosting.
  • Free Cloudflare CDN for excellent performance.
  • 30 days money back guarantee with all hosting packages
  • Free SSL with higher end hosting packages.
There are many other benefits of choosing Bluehost web hosting services. R
2. A2 Hosting: Another best and cheapest web hosting option to host a website. Get Fast Web Hosting with UP TO 20X FASTER in India. They have a blazing fast website hosting service ideal for your website! Whether you have a less traffic, brand new web blog or own a popular business website, A2 Hosting solution has got you covered! Whether you have never run a blog or website before or are a professional web developer, web master, rest assured they have a web hosting solution to match your unique requirements! .
Highlights of A2 Hosting service:
  • UNLIMITED Disk Space
  • UNLIMITED Bandwidth
  • 1-CLICK Script Installs
  • Free Solid State Drives
  • 99.9% Uptime Guarantee
  • Linux & Windows Hosting
  • 24/7/365 Guru Crew Support
  • Anytime Money Back Guarantee
iPage is Another best choice to host your unlimited websites at cheapest cost. They are one of the most trusted & reputed web hosting provider in India, offering top grade hosting solution at cheapest rates with amazing features and benefits. iPage Web Hosting starts from $1.99/mo. with free domain name, 24*7 support and 99.99% uptime guarantee,. Below are the few features of iPage web hosting:
  • Unlimited disk space
  • Scalable bandwidth
  • Unlimited domain names allowed
  • Unlimited MySQL databases
  • Free domain for 1 year ($14.99 value)
  • Access to online marketing guides
  • $100 Google Ad-words offer (US only)
  • $100 Bing search credit
  • Free Yellow pages listing
Read Reviews of iPage by visiting UpdatedReviews to know more about their services.
Now you can choose any of the web host listed above based on your requirements and budgets.
Hope this answer will be helpful for you.

Tuesday 16 October 2018

What is web hosting and how does it work

Web hosting is a service that allows organizations and individuals to post a website or web page onto the Internet. A web host, or web hosting service provider, is a business that provides the technologies and services needed for the website or webpage to be viewed on the Internet. Websites are hosted, or stored, on special computers called servers. When Internet users want to view your website, all they need to do is type your website address or domain into their browser. Their computer will then connect to your server and your web pages will be delivered to them through the browser. 

Most hosting companies require that you own your domain in order to host with them. If you do not have a domain, the hosting companies will help you purchase one. 

Here are some features you should be expecting from your hosting provider:
Email AccountsAs mentioned earlier, most hosting providers require users to have their own domain name. With a domain name (e.g. www.yourwebsite.com) and email account features provided by your hosting company, you can create domain email accounts (e.g. yourname@yourwebsite.com). 
FTP AccessThe use of FTP lets you upload files from your local computer to your web server. If you build your website using your own HTML files, you can transfer the files from your computer to the web server through FTP, allowing your website to be accessed through the internet. 
WordPress SupportWordPress is an online website creation tool. It is a powerful blogging and website content management system, which is a convenient way to create and manage the website. WordPress powers over 25% of websites on the internet. Most hosting providers will tell you right away if their plans are WordPress-compatible or not. The simple requirements for hosting your WordPress websites include PHP version 7 or greater; MySQL version 5.6 or greater.

Monday 15 October 2018

How much does it cost to create a website in anywhere in the world

How much does it cost to create a website in anywhere in the world
Mostly cost is depending on the developer.
Let me show you one example
www.sourabh.work (Portfolio or Static site)
If you want to develop your site like above website(www.minzor.com) then I can develop this in Rs 3000/ Design & Development, Time took 1–2 Days.
The main problem is that People are just going to the company for developing a website and they tell you too much. If you belong to nontechnical field it means you don’t know the reality of Website development cost. so don’t worry I’ll tell you everything about website development costs:
So what are the minimum charges for any website?
So simple it’s depending on 2 things.
1) Domain (Cost 99 INR to 1000 INR)
2) Hosting. (Hosting is -: where you store your website data)(2000 to 4000)
Total Amount 2099 to 5000( Domain + Hosting )
(above cost is mandatory anywhere.)
(Domain is-: Your website name)
(Hosting is -: where you store your website data)
Now let’s talk about a fully developed site means
Domain + Hosting + Design and Development
Now there are 3 types of website
1) Fully Static website. (2000-5000 INR design and development)
2) Static with some Dynamic part. (5000 to 1000)
3) E-Commerce site (started from 10000)
1.
Fully Static Website-: It means you have displayed some text, images, and videos on your website. Like(www.minzor.com)
2.
Static with some Dynamic part-: It means you have to display some text, images, videos and store some data. Like you have to store students’ details or your employee details and access this information in your website.
3.
E-Commerce site -: You have to SELL something on your site. Like Amazon, Flipkart, Paytm etc. This type of site takes too much time to develop. So that’s why there costing is high.
So if you are interested to make your own website or Blog for your Business so please feel free to contact us.
Our website - www.minzor.com
Contact Number-: +91 8656071107 , 8770689525
Thanks for reading.

Sunday 30 September 2018

10 Useful Tools, Libraries to Learn Programming Language - Every Programmer Should Know


10 Tools Every Programmer Should Know

Some of you may think 10 tools are nothing but, to be honest, if every programmer knows these truly well, he can accomplish a lot in his day to day job.
Anyway, without any further ado, let's see my list of 10 tools every software developer should know and know well.
1. Git and Github
A good knowledge of any source control repository is mandatory for any programmer or software developer because you need to do check-in, checkout of code every day.
And, to become a better developer you should also know advanced concepts like branching and merging.
In today's world, Git and Github have become synonymous with source control repository and version control tool.
This is the single most important tool for a programmer now and that's why I suggest every programmer learn Git and Github truly well.
If you are a beginner or a programmer who wants to improve his Git knowledge, I suggest you to go check out Git Complete: The definitive, step-by-step guide to Git course from Udemy. One of the best course to learn Git in depth.
2. SQL
This is another essential tool or programming language every programmer should learn. SQL is actually standards Standard Query language and used to work with the database. By using SQL you can read, update, and delete data from the tables.
Since we use database everywhere in the real world, a programmer should have a good understanding of SQL.
Apart from knowing basic commands e.g. SELECT, INSERT, UPDATE and DELETE, a programmer should also know how to write complex queries using joins, aggregate functions, subqueries, and other advanced functionalities.
If you are new to SQL or want to take your SQL skills to next level then The Complete SQL Bootcamp is a good place to start with.

3. Python
You might be surprised that as a Java developer, why I am suggesting every programmer learn Python? Well, there is a reason for it. Python is a powerful high-level, object-oriented programming language which is very versatile.
You can not only create big applications as you do in Java but also you can use Python to create useful scripts to automate stuff.
It also has numerous modules which make almost anything possible, starting from accessing the file system, developing web applications to machine learning.
I can't say more but to show you this picture which clearly explains why every programmer should learn Python.
It also has simple easy-to-use syntax, making it the perfect language for someone trying to learn computer programming for the first time. If you want to learn Python then The Complete Python Bootcamp course is a great place to start with.
4. Excel or any SpreadSheet
The Microsoft Excel is another essential tool for programmers and software developers. Don't mistake it just for a spreadsheet application, you can do a lot more using Excel then you can ever imagine.
The biggest reason to learn Microsoft Excel is that you will find it everywhere. Everybody uses it, starting from business to BA, QA and project managers. You can use it generate reports, automate and reconcile stuff and a lot more.
If you want to go beyond just copy pasting stuff into excel to learn functions like VLOOKUP, I suggest you join the Microsoft Excel - Excel from Beginner to the Advanced course on Udemy. One of the best course to learn Excel in depth.
5. Word or Similar
Microsoft Word is not as popular as Microsoft Excel but still its one of the essential tool for programmers and software engineers.
As a developer, you often need to create documents e.g. software design documents, requirement documents etc and Microsoft Word is the best tool for that.
It provides sophisticated formatting options to create really good looking documentation.
If you are a beginner or an intermediate developer who wants to improve your knowledge of Microsoft world then I suggest you go through Master Microsoft Word Beginner to the Advanced course on Udemy.
6. PowerPoint
Along with Microsoft Excel and Word, Powerpoint forms the trilogy of essential office tools and that's why they are also essential for Software engineers and IT professionals including developer, QA, BA, and project manager.
Microsoft PowerPoint is the most popular tool to create presentations and as a programmer, many times you need to do presentations e.g. presenting your ideas to business, your plans to managers and doing many knowledge sharing sessions between teams and that's why you just can't ignore powerpoint.
If you want to learn Powerpoint or improve your knowledge then Master Powerpoint presentations course on Udemy is a good place to start with.
7. Text Editors (SubLime)
Every programmer should know one text editor pretty well. Software developer do a lot of text processing job and knowing a text editor will always help.
Apart from NotePad, which is a very good, omnipresent basic text editor, I encourage the programmer to learn some advanced text editors e.g. Sublime or NotePad++.
They support regular expression search and replace and Macros which will help you a lot with your everyday work. If you want to learn more about a sublime text editor, Sublime Text for Rapid Web Development is a good place to start with.
8. Linux commands
Just like SQL, Linux commands is another essential tool for programmers. Every programmer has to work on UNIX sometime and many of us spend most of our day on Linux machine.
A good knowledge of Linux commands means you can find what you want, you can know what's going on with the machine and you can troubleshoot any issues with your application running on Linux.
This is a must-have skill for every programmer and if you are not comfortable with Linux commands you must spend some time to learn it, especially if you have some exploring to Linux. For beginners, Linux Command Line Basics is a good place to start with.
9. SVN
Even though Git has taken almost 70% market share in terms of version control system, there are still projects where SVN (also known as subversion) is used.
Not just on the property but also on open source and that's why knowing tortoise SVN is good for programmers.
It's the same tool, I have started with SVN 12 years back and it's still around. If you are a beginner or someone who want to improve his SVN knowledge and learn some advanced concepts like branching and merging in SVN then Introduction to SVN by John Sonmez on Pluarlsight is a good course to start with.

10. Powershell or Cygwin
Once you worked in Linux, you feel constraint while working in Windows because there is nothing like Linux commands in Windows and Powershell just solves that problem for once and all.
Windows PowerShell is a shell developed by Microsoft for the purposes of task automation and configuration management.
This powerful shell is based on the .NET framework and it includes a command-line shell and a scripting language so that you can automate stuff and create a script as you do in Linux.
If you want to start with PowerShell then I suggest you look at Learning Windows PowerShell course on Udemy, I have bought it recently to improve my Powershell skills.
That's all about essential tools for every programmer. These are some of the basic tools which everyone need be it a web developer working in JavaScript, a Java developer working on server-side code, or a mobile developer working on Android or iOS apps.
A good knowledge of these tools goes a long way in your software development career because you will use these tools each and every day and appreciate the time and effort you put initially to learn them.

source:
houseofbots.com

Sunday 16 September 2018

Google Interview Experience | Set 6

Google Interview Experience | Set 6

It was a nice experience to be part of google placement programme. There were 4 Rounds
The online test consists of 4 modules.
For each module, a timer is set (at the right-hand side bottom of the screen).
Total time given is 40 minutes.


Module 1: English (duration 5 min):
It consists of a single passage followed by 5 questions.
Module 2: General aptitude (duration 10 min):
Module 3: Technical questions (duration 15 min):


It consists of 15 questions where some are web based, HTML, protocols Etc. For this section going through COMPUTER NETWORKS subject will be helpful to a great extent.
Module 4: Test on Analysis (duration 10 min):
This section is the most time consuming one. Here we are asked to Rate certain sites along with an explanation. The images of these sites are also provided to us for a clear view and better understanding.
refrence:geeksforgeeks.org

Google Interview Experience | Set 7 (For Software Engineering Intern)

Google Interview Experience | Set 7 (For Software Engineering Intern)

Round 1: Coding Sample
In this coding sample, I was given 90 minutes to answer 2 coding questions.
Question 1: Given a string A consisting of n characters and a string B consisting of m characters, write a function that will return the number of times A must be stated such that B is a substring of the repeated A. If B can never be a substring, return -1.
Example:
A = ‘abcd’
B = ‘cdabcdab’
The function should return 3 because after stating A 3 times, getting ‘abcdabcdabcd’, B is now a substring of A.
You can assume that n and m are integers in the range [1, 1000].



Question 2: Consider an undirected tree with N nodes, numbered from 1 to N. Each node has a label associated with it, which is an integer value. Different nodes can have the same label. Write a function that, given a zero indexed array A of length N, where A[j] is the label value of the (j + 1)-th node in the tree and a zero-indexed array E of length K = (N – 1) * 2 in which the edges of the tree are described, returns the length of the longest path such that all the nodes on that path have the same label. The length is the number of edges in that path.
Example:
A = [1, 1, 1, 2, 2]
E = [1, 2, 1, 3, 2, 4, 2, 5]
This tree is shown below. A node follows the form label, value.
----------1, 1

-----1, 2        1, 3

2, 4      2, 5
The function should return 2, because the longest path is 2->1->3, and there are 2 edges in this path.
Assume that 1 <= N <= 1000 and each element of the array A is an integer in the range [1, 1000000000].

Round 2: Phone Interview
In this phone interview I was given one question.
Question: Write a function that takes a list L and returns a random sublist of size N of that list. Assume that the indexes must be in increasing order. That is, you cannot go backwards.
Example:
L = [1, 2, 3, 4, 5]
N = 3
The function should return one of these lists:
[1, 2, 3]
[1, 2, 4]
[1, 2, 5]
[1, 3, 4]
[1, 3, 5]
[1, 4, 5]
[2, 3, 4]
[2, 3, 5]
[2, 4, 5]
[3, 4, 5]

Round 3: Phone Interview
I was again asked only one question.
Question: Given a list L of video names and their watch rates, write a function that will return the videos with the top 10 watch rates. Video names may appear more than once.
Example:
L = [(‘abc’, 10), (‘def’, 15), (‘ghi’, 10), (‘abc’, 12), …, (‘xyz’, 100)]
The function should return [‘xyz’, ‘abc’, …, ‘def’, ‘ghi’]
Experience:
I solved all the questions but, unfortunately, I was not selected. Though I was not selected, I had a very positive experience. My interviewers and recruiters were all pleasant to work with. I will definitely try again next year and hopefully, I will clear it and get selected for a full time job.

Tips for Interview:
Ask questions. The interviewer will purposely give you a vague question in hopes of you asking the necessary questions to clarify it for yourself.
Don’t panic. I know it can be nerve racking to go on an interview, especially if it’s your first. But, nerves are only going to make it worse. Collect yourself, and if you don’t know the answer, it’s okay. Think through it for a few minutes and I’m sure anyone can come up with a solution. These questions are designed for you to be able to solve in the allocated time for an interview.
THINK OUT LOUD! I can’t stress this one enough. You are also being judged on your thought process. If your interviewer doesn’t know what you are thinking, they can’t throw you hints or correct you in any way. And believe me, they want to see you succeed. They are there to help you and guide you through the problem.
Other than that, study, study, study. Do as many algorithmically challenging problems as you can. Cracking the Coding Interview and Geeks for Geeks will be your best friends through the study process. Take advantage of these resources.
refrence: geeksforgeeks.org

😍Developer on Weekends #shorts #officememes #developermemes

😍Developer on Weekends #shorts #officememes #developermemes Welcome to the latest viral YouTube shorts meme for developers! 😍Developer on...