• Home
  • Technology
    • Ebullientech
    • Entrepreneurship
    • Video Technology
    • Cloud Computing
    • Business Analysis
  • Healthcare
    • Pharmacology
  • Thoughts
    • Food
    • General
    • Stories
    • Places
    • Workplace
    • Social Issues
    • Reviews
  • Quotes
  • Ebullientech News and Events
  • About

Kamalika's Notebook

thinking nothing...............!!

KidzByte Premium Feature Launch Celebration

December 10, 2019 By Kamalika Leave a Comment

Movie night with the team to celebrate the launch of KidzByte premium. One of our most challenging deliveries since the launch last year, a clean release in record time. Team Ebullientech rocks! Thanks, Pradnyesh, Mayur, Bhakti, Amin, Jay, Rajat, Mithu.

  • Movie night – Knives Out

Filed Under: Ebullientech News and Events Tagged With: Ebullientech, Ebullientech Interactive LLP

Top 25 business analyst interview questions, answers, and tips

June 20, 2019 By Kamalika Leave a Comment

Common interview questions and how to answer them

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.

Who is a business analyst?

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…]

Filed Under: Business Analysis, Ebullientech, Technology Tagged With: Business Analysis, Business Analyst, Ebullientech, Ebullientech Interactive LLP, Requirement Engineering, Technology

Ebullientech First Anniversary

January 4, 2019 By Kamalika Leave a Comment

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…

  • The cake…
  • The white board…
  • Window…
  • Window…

Filed Under: Ebullientech News and Events Tagged With: Ebullientech, Ebullientech Interactive LLP

KidzByte launch, Ebullientech’s First Android App

July 31, 2018 By Kamalika Leave a Comment

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.

KidzByte

Filed Under: Ebullientech News and Events Tagged With: Ebullientech, Ebullientech Interactive LLP

How To Get Posts Category In WordPress

April 30, 2015 By Kamalika Leave a Comment

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:

  • posts
  • pages
  • custom post types
  • attachments
  • links
  • navigation menu items (which are stored as individual posts)

wp_users

wp_users table contains user data.

wp_term_relationships

WordPress content types are attached to the following types of data:

  • categories
  • tags
  • custom taxonomies and terms
  • post metadata

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:

WordPress Database Diagram

Filed Under: Ebullientech, MySQL, WordPress Tagged With: Custom WordPress Queries, Ebullientech, Ebullientech Interactive LLP, SQL Query, WordPress, WordPress Consultant Mumbai, WordPress Database Diagram, WordPress Database Structure, WordPress Developer Mumbai, WordPress SQL Query Category, WordPress to SQL Query Query

  • « Previous Page
  • 1
  • 2
  • 3
  • Next Page »

Let’s connect…

  • Facebook
  • Instagram
  • LinkedIn
  • Twitter
  • YouTube

Hello There…

I'm Kamalika, a techpreneur & startup mentor, blogger, hobbyist photographer, Netflix & Kindle indulgent, food connoisseur, Starbucks aficionado and former Disney employee ...next

Looking for something?

Tags

All in One SEO Pack AWS Banaras Blogger Blogging Blogs Dasaswamedh Ghat Ebullientech Ebullientech Interactive LLP Facebook Facebook Developers father's day father's day wishes father's day wishes for dad fathers day love Fathers Day Special Fathers Day wishes from daughter Father’s day memories GeoTech GeoTech Informatics HipHop for PHP Kamalika Guha Roy Kashi Ganga LAMP MySQL Nabaneeta Guha Roy Online Marketing PayPal PayPal's suspension of Indian bank transactions PHP PHP & MySQL Saraswati Puja Search Engine Optimization SEO Startup The Ganges TypePad UCO HUT Varanasi Web 2.0 Web 2.0 Design Web Design Web Marketing WordPress WordPress.COM

Timeline

  • 2024 (1)
  • 2021 (3)
  • 2020 (7)
  • 2019 (4)
  • 2018 (1)
  • 2015 (6)
  • 2014 (13)
  • 2013 (9)
  • 2010 (7)
  • 2009 (2)

Topics

Copyright © 2021 · Kamalika Guha Roy, Powered by: Ebullientech