Earning Code Setup Form: Fill & Download for Free

Well, being a coder and being freelance coder is same in a way. First you must know how to code. If you know coding, you can sell your coding skills by freelancing.I can surely guide you regarding freelancing because I've been freelancing since 12 years and today I'm at earning stage of $1500 - $1600 USD every month.Very first, choose right freelance marketplace. Note my words saying 'right freelance marketplace' because hell lot of scams are running out there. So, based on vast experience, I would recommend top 3 to go with:www.Elance.com (Best)www.FreelancerCircle.com (Best)www.Upwork.com (Best)www.PeoplePerHour.com (Optional)www.Guru.com (Optional)www.WorkNHire.com (Optional)www.Freelancer.com (Scam)www.Outsource.com (Not Recommended)www.RentACoder.com (Not Recommended).Second, register free and setup your profile.Third, find relevant coding projects and start bidding on it. Now, mark down these points while bidding:These are some important points while bidding:- Make sure you send proposal with your bid.- Your proposal must contains this line: "Your Invitation over a private chat would be highly appreciated."- Your bid amount should neither be higher nor be lower; make it moderate an average sized bid.- Always communicate in professional language and don't use short forms of the spellings like Your to "ur".- Try be first while bidding on the projects because it give an impressive feel to the employers.- Make sure you use correct spellings and grammars while communicate.Well, you are all set!Thank you.PLEASE HELP ME find an answer:http://www.quora.com/Rajat-Raghvendra/questions

Some common problems asked in interviews for Algorithms :Save all leaf nodes of a Binary tree in a Doubly Linked List by using Right node as Next node and Left Node as Previous Node.Given an array,find the maximum j – i such that arr[j] > arr[i]Remove Alternate Duplicate characters from a char array you have to do it in Place.Like keeping only the odd occurences of each character.Example: Input: “you got beautiful eyes” Output: ”you gtbeaiful es” Allowed Time Complexity was O(n) and Space Complexity was O(1) In a file there are 1 million words . Find 10 most frequent words in that file.Find all nodes at k-distance from a given node in a binary treeClone a linked list with next and random pointerSerialise and Deserialise a linked list with next and random pointer.Construct a binary tree from given inorder and preorder traversals.Return a tree such that each internal node stores sum of all its child nodes. Each leaf node stores zero.How will you implement linked list with 1 million nodes? How will you access 999999 th node? Give some optimal design strategy and implementation.Reversal of Linked List in groups of K.Given a positive integer N, count all possible distinct binary strings of length N such that there are no consecutive 1’s.Check whether given binary tree is balanced or not. Definition was no two leaves should have height difference of greater than one.Remove duplicates from string in place in O(n).Connect nodes on same level in a binary tree.Find sum of data of all leaves of a binary tree on same level and then multiply sums obtained of all levels.Given a matrix of characters and a word.you have to count the number of occurrences of that word in that matrix. you can move to any of the eight valid directions from current position.You are given an string as input which represents a path. You have to normalize that path inplace(NO EXTRA SPACE).e.g.input : "\a\b\c\..\..\file.txt" output: "\a\file.txt" Least common ancestor of two nodes in a binary treeGiven two sorted arrays (with repetitive elements) find the kth minimum number from both arrays.Given the root to a binary tree, a value n and k.Find the sum of nodes at distance k from node with value nFind an element in a rotated arrayThe cost of a stock on each day is given in an array, find the max profit that you can make by buying and selling in those days.For example, if the given array is {100, 180, 260, 310, 40, 535, 695},  the maximum profit can earned by buying on day 0, selling on day 3. Again buy on day 4 and sell on day 6.  If the given array of prices is sorted in decreasing order, then profit cannot be earned at all. Given two linked lists both represent a number. Create a linked list that contains its sum.Given a binary search tree , print the path which has the sum equal to k and has minimum hops. i.e if there are multiple paths with the sum equal to k then print the path with minimum number of nodes.A MxN matrix containing integers (positive, negative and zero’s). For every position containing 0, mark the corresponding row and column as 0.Rotate MxN matrix by 90 degress.Find the nth number that contains the digit k or is divisible by k. (2 <= k <= 9)Write a program to connect next left node in a binary tree. Also first node of each level should be pointing to last node of next level? (Without using Queue)Convert a binary tree to its sum tree(each node is the sum of its children)Given a directed graph. Construct another graph from given graph such that if path exists from vertices A to vertices B and from B to C, then path from A to C and from C to A also should exists.Implement hashmap on your own. Write good hashing function for string.Given an array, arrange the elements such that the number formed by concatenating the elements is highest.E.g.: input = [9, 93, 24, 6],  the output should be: [9,93,6,24].  This is because if you concatenate all the numbers,  993624 is the highest number that can be formed. Given a string, find the longest substring which is palindrome.Given that integers are read from a data stream. Find median of elements read so for in efficient way. For simplicity assume there are no duplicates.Write an efficient program for printing k largest elements in an array. Elements in array can be in any order.Given unsorted array and a number K. Find 2 numbers such that sum is K.Given n-ary tree. zigzag level order traversal.Given string s and string t find whether all permutation of t is present as substring in s.Design a stack which holds an integer value such that getMinimum() function should return the minimum element in the stack. Implement popMin() function which would pop minimum element from the original stack.Given a set of intervals like 5-10, 15-20, 25-40, 30-45, 50-100. Find the ith smallest number in these intervals. Assume there are no duplicate numbers.e.g: 1st smallest number = 5 6th smallest number = 10  7th smallest number = 15 and so on.  Given an array which is first strictly increasing and then strictly decreasing. Find an element in this array.Given a string example : shoppingwithflipkartiseasy, Now we are given this string and a dictionary containing valid words , now we need to break the sentence into words separated by space. Output : shopping with flipkart is easyGiven a series 2,3,4,5,6,8,9,10,……, here in this series all the numbers are present which have factors only and only either 2,3 or 5. Need to write a node to generate nth number for the series . With best approach and complexityGiven a tree with edge weights, find any path in the tree with maximum sum of edges.Merge k sorted arrays.Given a maze, a start point and end point find the shortest path to reach the end point from the starting point.Given a sentence and a set of characters. Find the minimum window within which the set of characters can be found in the sentence in any order.You are given a string of 0’s and 1’s you have to find the number of substrings in the string which starts and end with a 1.eg : input : 0010110010 output : 6 You are given a mapping like a -> 1, b-> 2… z-> 26. You have to print all possible combinations of a given number using the above information.eg : input : 121 output : aba,la,au Given a dictionary of 50,000 words. Given a phrase without spaces, add spaces to make it a proper sentence.e.g:input: thequickbrownfoxjumpoverlazydog  output: the quick brown fox jump over lazy dog Given an unsorted array of n integers which can contain integers from 1 to n. Some elements can be repeated multiple times and some other elements can be absent from the array. Count frequency of all elements that are present and print the missing elements.Examples:Input: arr[] = {2, 3, 3, 2, 5}  Output: Below are frequencies of all elements  1 -> 0 2 -> 2 3 -> 2 4 -> 0 5 -> 1 Get the next bigger number using the same digits of a number.Eg, For 123456, next number would be 123465Given a boolean 2D matrix, find the number of islands. A group of connected 1s forms an island. For example, the below matrix contains 5 islandsInput : mat[][] =  {{1, 1, 0, 0, 0},  {0, 1, 0, 0, 1},   {1, 0, 0, 1, 1},  {0, 0, 0, 0, 0},   {1, 0, 1, 0, 1}} Output : 5 Given two strings in lowercase, the task is to make them anagram. The only allowed operation is to remove a character from any string. Find minimum number of characters to be deleted to make both the strings anagram?If two strings contains same data set in any order then strings are called Anagrams.Examples:  Input : str1 = "bcadeh" str2 = "hea" Output: 3 We need to remove b, c and d from str1.  Input : str1 = "cddgk" str2 = "gcd" Output: 2  Input : str1 = "bca" str2 = "acb" Output: 0 Given n non-negative integers representing an elevation map where the width of each bar is 1, compute how much water it is able to trap after raining.Examples:  Input: arr[] = {2, 0, 2} Output: 2 Structure is like below | | |_| We can trap 2 units of water in the middle gap.  Input: arr[] = {3, 0, 0, 2, 0, 4} Output: 10 Structure is like below  | | | | | | |__|_|  We can trap "3*2 units" of water between 3 an 2, "1 unit" on top of bar 2 and "3 units" between 2  and 4. See below diagram also.  Input: arr[] = [0, 1, 0, 2, 1, 0, 1, 3, 2, 1, 2, 1] Output: 6  |   | || | _|_||_|||||| Trap "1 unit" between first 1 and 2, "4 units" between first 2 and 3 and "1 unit" between second last 1 and last 2 Given two strings str1 and str2 and below operations that can performed on str1. Find minimum number of edits (operations) required to convert ‘str1’ into ‘str2’.InsertRemoveReplaceAll of the above operations are of equal cost.Examples:  Input: str1 = "geek", str2 = "gesek" Output: 1 We can convert str1 into str2 by inserting a 's'.  Input: str1 = "cat", str2 = "cut" Output: 1 We can convert str1 into str2 by replacing 'a' with 'u'.  Input: str1 = "sunday", str2 = "saturday" Output: 3 Last three and first characters are same. We basically need to convert "un" to "atur". This can be done using below three operations.  Replace 'n' with 'r', insert t, insert a Given a string with repeated characters, task is rearrange characters in a string so that no two adjacent characters are same.Note : It may be assumed that the string has only lowercase English alphabets.Examples:  Input: aaabc  Output: abaca   Input: aaabb Output: ababa   Input: aa  Output: Not Possible  Input: aaaabc  Output: Not Possible This problem is know as Clock angle problem where we need to find angle between hands of an analog clock at a given time.Examples:Input: h = 12:00, m = 30.00 Output: 165 degreeInput: h = 3.00, m = 30.00 Output: 75 degree Most often questions asked in Java interviews are based on these concepts(in the approximately increasing order of difficulty):PolymorphismDynamic BindingAbstractionData hidingInheritanceMethod overridingException HandlingDatabase connection setup(JDBC/ODBC)Access modifiersException cascadingImmutabilityUnit testing and integration testingWrapper classesObject classJava libraries and packagesJava util classJava collectionsJava genericsMicroservicesObject Oriented DesignDesign Patterns(Singleton, Factory etc)Frameworks(Play framework, Spring boot, Apache Tomcat, Hibernate)Java ReflectionAnd many more concepts…This website is very helpful in Interview preparations for JAVA and Algorithms. It has tests for MCQs on Java for these topics and a lot of interview experiences to read through for both Java and Algorithms.GeekyPrep - Hub for GeeksGood luck!

This question has so many potential meanings!Let's start with the obvious. I have to get it out of my system.You can write SQL code anywhere! You can even write it in a notebook while bored in class or in a meeting. I feel sorry for you if you're so bored that writing SQL is more exciting than what you're currently doing, but I've been there.Now, let's consider scenarios that might lead to this question.You're just learning SQL and want to find a way to practice.Most SQL engines have a command-line client.If you've installed MySQL (or MariaDB — they work the same), try typing “mysql” on a command line. You're going need to learn how to create a database first, so this is how you would create the “learning” database: (you can substitute “learning” with any other valid database name)mysql -u root -p (you might not need -p to login as root if you're the root user in your operating system)grant all privileges on `learning`.* to 'user'@’localhost’ identified by 'password'; (replace the word “password” with an actual password)create database `learning`; (this actually creates the database)Quit mysql. \qFrom now on, since you've already created the database, you can just follow the remaining steps:Now login as the user you just created: mysql -u username -pSelect the database: use learning;Start typing SQL to your heart's content!If MySQL is a bit much for you, you could learn more basic SQL using sqlite which also has a command line client. I won't go into details. If you want details then ask another question, specify sqlite and request that I answer.If you have an entire web-based development environment setup, maybe something like WAMP or MAMP, or an environment that you've setup yourself, look into phpMyAdmin. It's a decent web-based interface for MySQL.You've learned MySQL but you aren't sure how to use it in your code.This depends on what language you're using and, if you're using a framework, then it depends on which framework. Ask another question with these specifics and request that I answer. If I can, I will.You're a hacker trying to exploit SQL injections.Find an inexperienced web developer.Go to their website.Find a form.Type your SQL into a field.Submit.???Profit!Don't do that.(Unless the inexperienced web developer is a friend and you're trying to teach them a lesson and you know that they'll suffer no real loss as a result. Let's keep the white hat on, shall we?)You're in the Quora Partner Program and you're just trying to find questions that will earn you more money.*ugh* I wish that program would go away, or at least reduce its rates to such a level that it's a waste of time for those who take advantage of it.I feel so used! Please tell me this isn't it!