thinking nothing...............!!
In this article, we’ll try to understand the role and responsibilities of a business analyst and how one should prepare for the interview process. Every organization’s business problems are unique, but there are problems every analyst should be able to solve. I’ll try to list down questions, answers, and tips covering those topics along with a couple of behavioural aptitudes.
A business analyst is responsible for the functional design of system or application. S/he is the one who interacts with both stakeholders and subject matter experts and defines the system elements which further translate into software requirement specifications. Today’s analysts are the innovators who take the product to the next level. [Read more…]
1997…
Me: Baba, I don’t want to go to college, please buy me a computer I want to start my software business.
Father: First, you have to complete your graduation then I’ll think about your computer!
2003…
Yahoo Chat Friend: Hey, what do you do?
Me: I’m an entrepreneur, I build and sell software applications.
Yahoo Chat Friend: Really? Well, we have a vacancy for a trainee engineer, would you like to join?…
I was born in a middle-class family in which thinking about becoming an entrepreneur was like having the desire to eat some forbidden fruit! But I probably thought myself as someone like Lily Evans Potter, a muggle-born wizard hence I always natured an impossible aspiration of becoming an entrepreneur… one day!
Three failed startups in the last four years (as an employee, though!) my goal seemed stupid and distant. Then came a friend/colleague with his startup idea (R2D Freight), and we took the plunge! I next two months, we got going with the development of our second startup product (KidzByte).
I still can’t believe that we have now completed our first year. Mithu Sarkar without your courage Ebullientech Interactive LLP would not have become a reality. Pradnyesh and Amin, I don’t know what you saw in me and quit everything to make my impossible desire a reality.
Some photos from our first anniversary celebrations…
A Proud moment being the first generation entrepreneur, our first-ever Android App KidzByte is live now. Thanks, Chetan Dsouza for believing in our team and giving us the opportunity…, thanks Pradnyesh Shembavanekar, Mithu Sarkar, Amin Ghoghari, Jay Gupta for making this happen.
The App can be downloaded from Google Playstore https://goo.gl/caJJJu. It is an Educational News App for children between 9-15 years (class 4 to 10) covering the latest from around the world in an innovative and kid-friendly manner.
Problem
Can we get the list of blog posts in the following structure?
Published Date
Author
Category
Post Title
Blog URL
Solution
[bash]
SELECT p.ID,DATE(p.post_date) Date,u.display_name Author,p.post_title Title,GROUP_CONCAT(t.name) Category,
CONCAT(‘http://yourdomain.com/blog/’,p.post_name) URL
FROM wp_posts p
LEFT JOIN wp_users u ON p.post_author = u.ID
LEFT JOIN wp_term_relationships rel ON rel.object_id = p.ID
LEFT JOIN wp_term_taxonomy tax ON (tax.term_taxonomy_id = rel.term_taxonomy_id AND tax.taxonomy=’category’)
LEFT JOIN wp_terms t ON (t.term_id = tax.term_id AND t.name!=’uncategorized’)
WHERE p.post_status = ‘publish’ and p.post_type=’post’
GROUP BY p.ID
ORDER BY Date;
[/bash]
Tables used in the above query are:
wp_posts
wp_posts table contains all kinds of contents of an WordPress Website / Blog and the content types include the following:
wp_users
wp_users table contains user data.
wp_term_relationships
WordPress content types are attached to the following types of data:
wp_term_relationships contains the relationship between WordPress contents and categories / tags.
wp_term_taxonomy
wp_term_taxonomy contains the taxonomy details.
wp_terms
wp_terms contains the details of all defined categories and tags.
The WordPress Database Structure
WordPress uses a number of database tables with relationships between them, most of these relationships are one-to-many.
One-to-many relationships occur when each record in TableA may have many linked records in TableB but each record in TableB may have only one corresponding record in TableA.
In case of WordPress, one user can have many posts that they have written related to their user record.
The diagram below is taken from the WordPress Codex and shows the database tables and how they are related / linked:
